X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/c3ad6aa2923c03aeeea0b57033b0a9238d262aa2..ee1a8637d3e97575135b3a022605e0b831c8b232:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index 6abd8c753..73cb543e7 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -2,12 +2,16 @@ -- PostgreSQL database dump -- +-- Dumped from database version 9.5.7 +-- Dumped by pg_dump version 9.5.7 + SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; +SET row_security = off; -- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: - @@ -23,6 +27,20 @@ CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; +-- +-- Name: btree_gist; Type: EXTENSION; Schema: -; Owner: - +-- + +CREATE EXTENSION IF NOT EXISTS btree_gist WITH SCHEMA public; + + +-- +-- Name: EXTENSION btree_gist; Type: COMMENT; Schema: -; Owner: - +-- + +COMMENT ON EXTENSION btree_gist IS 'support for indexing common datatypes in GiST'; + + SET search_path = public, pg_catalog; -- @@ -48,6 +66,17 @@ CREATE TYPE gpx_visibility_enum AS ENUM ( ); +-- +-- Name: issue_status_enum; Type: TYPE; Schema: public; Owner: - +-- + +CREATE TYPE issue_status_enum AS ENUM ( + 'open', + 'ignored', + 'resolved' +); + + -- -- Name: note_event_enum; Type: TYPE; Schema: public; Owner: - -- @@ -106,6 +135,33 @@ CREATE TYPE user_status_enum AS ENUM ( ); +-- +-- Name: maptile_for_point(bigint, bigint, integer); Type: FUNCTION; Schema: public; Owner: - +-- + +CREATE FUNCTION maptile_for_point(bigint, bigint, integer) RETURNS integer + LANGUAGE c STRICT + AS '$libdir/libpgosm', 'maptile_for_point'; + + +-- +-- Name: tile_for_point(integer, integer); Type: FUNCTION; Schema: public; Owner: - +-- + +CREATE FUNCTION tile_for_point(integer, integer) RETURNS bigint + LANGUAGE c STRICT + AS '$libdir/libpgosm', 'tile_for_point'; + + +-- +-- Name: xid_to_int4(xid); Type: FUNCTION; Schema: public; Owner: - +-- + +CREATE FUNCTION xid_to_int4(xid) RETURNS integer + LANGUAGE c IMMUTABLE STRICT + AS '$libdir/libpgosm', 'xid_to_int4'; + + SET default_tablespace = ''; SET default_with_oids = false; @@ -117,9 +173,9 @@ SET default_with_oids = false; CREATE TABLE acls ( id integer NOT NULL, address inet, - k character varying NOT NULL, - v character varying, - domain character varying + k character varying(255) NOT NULL, + v character varying(255), + domain character varying(255) ); @@ -142,6 +198,18 @@ CREATE SEQUENCE acls_id_seq ALTER SEQUENCE acls_id_seq OWNED BY acls.id; +-- +-- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: - +-- + +CREATE TABLE ar_internal_metadata ( + key character varying NOT NULL, + value character varying, + created_at timestamp without time zone NOT NULL, + updated_at timestamp without time zone NOT NULL +); + + -- -- Name: changeset_comments; Type: TABLE; Schema: public; Owner: - -- @@ -181,8 +249,8 @@ ALTER SEQUENCE changeset_comments_id_seq OWNED BY changeset_comments.id; CREATE TABLE changeset_tags ( changeset_id bigint NOT NULL, - k character varying DEFAULT ''::character varying NOT NULL, - v character varying DEFAULT ''::character varying NOT NULL + k character varying(255) DEFAULT ''::character varying NOT NULL, + v character varying(255) DEFAULT ''::character varying NOT NULL ); @@ -238,10 +306,10 @@ CREATE TABLE changesets_subscribers ( CREATE TABLE client_applications ( id integer NOT NULL, - name character varying, - url character varying, - support_url character varying, - callback_url character varying, + name character varying(255), + url character varying(255), + support_url character varying(255), + callback_url character varying(255), key character varying(50), secret character varying(50), user_id integer, @@ -282,8 +350,8 @@ ALTER SEQUENCE client_applications_id_seq OWNED BY client_applications.id; CREATE TABLE current_node_tags ( node_id bigint NOT NULL, - k character varying DEFAULT ''::character varying NOT NULL, - v character varying DEFAULT ''::character varying NOT NULL + k character varying(255) DEFAULT ''::character varying NOT NULL, + v character varying(255) DEFAULT ''::character varying NOT NULL ); @@ -330,7 +398,7 @@ CREATE TABLE current_relation_members ( relation_id bigint NOT NULL, member_type nwr_enum NOT NULL, member_id bigint NOT NULL, - member_role character varying NOT NULL, + member_role character varying(255) NOT NULL, sequence_id integer DEFAULT 0 NOT NULL ); @@ -341,8 +409,8 @@ CREATE TABLE current_relation_members ( CREATE TABLE current_relation_tags ( relation_id bigint NOT NULL, - k character varying DEFAULT ''::character varying NOT NULL, - v character varying DEFAULT ''::character varying NOT NULL + k character varying(255) DEFAULT ''::character varying NOT NULL, + v character varying(255) DEFAULT ''::character varying NOT NULL ); @@ -395,8 +463,8 @@ CREATE TABLE current_way_nodes ( CREATE TABLE current_way_tags ( way_id bigint NOT NULL, - k character varying DEFAULT ''::character varying NOT NULL, - v character varying DEFAULT ''::character varying NOT NULL + k character varying(255) DEFAULT ''::character varying NOT NULL, + v character varying(255) DEFAULT ''::character varying NOT NULL ); @@ -474,13 +542,13 @@ ALTER SEQUENCE diary_comments_id_seq OWNED BY diary_comments.id; CREATE TABLE diary_entries ( id bigint NOT NULL, user_id bigint NOT NULL, - title character varying NOT NULL, + title character varying(255) NOT NULL, body text NOT NULL, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL, latitude double precision, longitude double precision, - language_code character varying DEFAULT 'en'::character varying NOT NULL, + language_code character varying(255) DEFAULT 'en'::character varying NOT NULL, visible boolean DEFAULT true NOT NULL, body_format format_enum DEFAULT 'markdown'::format_enum NOT NULL ); @@ -505,6 +573,16 @@ CREATE SEQUENCE diary_entries_id_seq ALTER SEQUENCE diary_entries_id_seq OWNED BY diary_entries.id; +-- +-- Name: diary_entry_subscriptions; Type: TABLE; Schema: public; Owner: - +-- + +CREATE TABLE diary_entry_subscriptions ( + user_id bigint NOT NULL, + diary_entry_id bigint NOT NULL +); + + -- -- Name: friends; Type: TABLE; Schema: public; Owner: - -- @@ -556,7 +634,7 @@ CREATE TABLE gps_points ( CREATE TABLE gpx_file_tags ( gpx_id bigint DEFAULT 0 NOT NULL, - tag character varying NOT NULL, + tag character varying(255) NOT NULL, id bigint NOT NULL ); @@ -588,12 +666,12 @@ CREATE TABLE gpx_files ( id bigint NOT NULL, user_id bigint NOT NULL, visible boolean DEFAULT true NOT NULL, - name character varying DEFAULT ''::character varying NOT NULL, + name character varying(255) DEFAULT ''::character varying NOT NULL, size bigint, latitude double precision, longitude double precision, "timestamp" timestamp without time zone NOT NULL, - description character varying DEFAULT ''::character varying NOT NULL, + description character varying(255) DEFAULT ''::character varying NOT NULL, inserted boolean NOT NULL, visibility gpx_visibility_enum DEFAULT 'public'::gpx_visibility_enum NOT NULL ); @@ -624,11 +702,10 @@ ALTER SEQUENCE gpx_files_id_seq OWNED BY gpx_files.id; CREATE TABLE issue_comments ( id integer NOT NULL, - issue_id integer, - commenter_user_id integer, - body text, + issue_id integer NOT NULL, + user_id integer NOT NULL, + body text NOT NULL, created_at timestamp without time zone NOT NULL, - reassign boolean, updated_at timestamp without time zone NOT NULL ); @@ -660,15 +737,15 @@ CREATE TABLE issues ( id integer NOT NULL, reportable_type character varying NOT NULL, reportable_id integer NOT NULL, - reported_user_id integer NOT NULL, - status integer, - issue_type character varying, + reported_user_id integer, + status issue_status_enum DEFAULT 'open'::public.issue_status_enum NOT NULL, + assigned_role user_role_enum NOT NULL, resolved_at timestamp without time zone, resolved_by integer, - created_at timestamp without time zone NOT NULL, - updated_at timestamp without time zone NOT NULL, updated_by integer, - report_count integer DEFAULT 0 + reports_count integer DEFAULT 0, + created_at timestamp without time zone NOT NULL, + updated_at timestamp without time zone NOT NULL ); @@ -696,9 +773,9 @@ ALTER SEQUENCE issues_id_seq OWNED BY issues.id; -- CREATE TABLE languages ( - code character varying NOT NULL, - english_name character varying NOT NULL, - native_name character varying + code character varying(255) NOT NULL, + english_name character varying(255) NOT NULL, + native_name character varying(255) ); @@ -709,7 +786,7 @@ CREATE TABLE languages ( CREATE TABLE messages ( id bigint NOT NULL, from_user_id bigint NOT NULL, - title character varying NOT NULL, + title character varying(255) NOT NULL, body text NOT NULL, sent_on timestamp without time zone NOT NULL, message_read boolean DEFAULT false NOT NULL, @@ -746,8 +823,8 @@ ALTER SEQUENCE messages_id_seq OWNED BY messages.id; CREATE TABLE node_tags ( node_id bigint NOT NULL, version bigint NOT NULL, - k character varying DEFAULT ''::character varying NOT NULL, - v character varying DEFAULT ''::character varying NOT NULL + k character varying(255) DEFAULT ''::character varying NOT NULL, + v character varying(255) DEFAULT ''::character varying NOT NULL ); @@ -773,7 +850,7 @@ CREATE TABLE nodes ( -- CREATE TABLE note_comments ( - id bigint NOT NULL, + id integer NOT NULL, note_id bigint NOT NULL, visible boolean NOT NULL, created_at timestamp without time zone NOT NULL, @@ -808,7 +885,7 @@ ALTER SEQUENCE note_comments_id_seq OWNED BY note_comments.id; -- CREATE TABLE notes ( - id bigint NOT NULL, + id integer NOT NULL, latitude integer NOT NULL, longitude integer NOT NULL, tile bigint NOT NULL, @@ -844,7 +921,7 @@ ALTER SEQUENCE notes_id_seq OWNED BY notes.id; CREATE TABLE oauth_nonces ( id integer NOT NULL, - nonce character varying, + nonce character varying(255), "timestamp" integer, created_at timestamp without time zone, updated_at timestamp without time zone @@ -891,9 +968,9 @@ CREATE TABLE oauth_tokens ( allow_write_api boolean DEFAULT false NOT NULL, allow_read_gpx boolean DEFAULT false NOT NULL, allow_write_gpx boolean DEFAULT false NOT NULL, - callback_url character varying, + callback_url character varying(255), verifier character varying(20), - scope character varying, + scope character varying(255), valid_to timestamp without time zone, allow_write_notes boolean DEFAULT false NOT NULL ); @@ -924,10 +1001,10 @@ ALTER SEQUENCE oauth_tokens_id_seq OWNED BY oauth_tokens.id; CREATE TABLE redactions ( id integer NOT NULL, - title character varying, + title character varying(255), description text, - created_at timestamp without time zone, - updated_at timestamp without time zone, + created_at timestamp without time zone NOT NULL, + updated_at timestamp without time zone NOT NULL, user_id bigint NOT NULL, description_format format_enum DEFAULT 'markdown'::format_enum NOT NULL ); @@ -960,7 +1037,7 @@ CREATE TABLE relation_members ( relation_id bigint DEFAULT 0 NOT NULL, member_type nwr_enum NOT NULL, member_id bigint NOT NULL, - member_role character varying NOT NULL, + member_role character varying(255) NOT NULL, version bigint DEFAULT 0 NOT NULL, sequence_id integer DEFAULT 0 NOT NULL ); @@ -972,8 +1049,8 @@ CREATE TABLE relation_members ( CREATE TABLE relation_tags ( relation_id bigint DEFAULT 0 NOT NULL, - k character varying DEFAULT ''::character varying NOT NULL, - v character varying DEFAULT ''::character varying NOT NULL, + k character varying(255) DEFAULT ''::character varying NOT NULL, + v character varying(255) DEFAULT ''::character varying NOT NULL, version bigint NOT NULL ); @@ -998,9 +1075,10 @@ CREATE TABLE relations ( CREATE TABLE reports ( id integer NOT NULL, - issue_id integer, - reporter_user_id integer, - details text, + issue_id integer NOT NULL, + user_id integer NOT NULL, + details text NOT NULL, + category character varying NOT NULL, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL ); @@ -1030,7 +1108,7 @@ ALTER SEQUENCE reports_id_seq OWNED BY reports.id; -- CREATE TABLE schema_migrations ( - version character varying NOT NULL + version character varying(255) NOT NULL ); @@ -1077,8 +1155,8 @@ ALTER SEQUENCE user_blocks_id_seq OWNED BY user_blocks.id; CREATE TABLE user_preferences ( user_id bigint NOT NULL, - k character varying NOT NULL, - v character varying NOT NULL + k character varying(255) NOT NULL, + v character varying(255) NOT NULL ); @@ -1089,9 +1167,9 @@ CREATE TABLE user_preferences ( CREATE TABLE user_roles ( id integer NOT NULL, user_id bigint NOT NULL, - role user_role_enum NOT NULL, created_at timestamp without time zone, updated_at timestamp without time zone, + role user_role_enum NOT NULL, granter_id bigint NOT NULL ); @@ -1122,7 +1200,7 @@ ALTER SEQUENCE user_roles_id_seq OWNED BY user_roles.id; CREATE TABLE user_tokens ( id bigint NOT NULL, user_id bigint NOT NULL, - token character varying NOT NULL, + token character varying(255) NOT NULL, expiry timestamp without time zone NOT NULL, referer text ); @@ -1152,36 +1230,36 @@ ALTER SEQUENCE user_tokens_id_seq OWNED BY user_tokens.id; -- CREATE TABLE users ( - email character varying NOT NULL, + email character varying(255) NOT NULL, id bigint NOT NULL, - pass_crypt character varying NOT NULL, + pass_crypt character varying(255) NOT NULL, creation_time timestamp without time zone NOT NULL, - display_name character varying DEFAULT ''::character varying NOT NULL, + display_name character varying(255) DEFAULT ''::character varying NOT NULL, data_public boolean DEFAULT false NOT NULL, description text DEFAULT ''::text NOT NULL, home_lat double precision, home_lon double precision, home_zoom smallint DEFAULT 3, nearby integer DEFAULT 50, - pass_salt character varying, + pass_salt character varying(255), image_file_name text, email_valid boolean DEFAULT false NOT NULL, - new_email character varying, - creation_ip character varying, - languages character varying, + new_email character varying(255), + creation_ip character varying(255), + languages character varying(255), status user_status_enum DEFAULT 'pending'::user_status_enum NOT NULL, terms_agreed timestamp without time zone, consider_pd boolean DEFAULT false NOT NULL, - auth_uid character varying, - preferred_editor character varying, + preferred_editor character varying(255), terms_seen boolean DEFAULT false NOT NULL, + auth_uid character varying(255), description_format format_enum DEFAULT 'markdown'::format_enum NOT NULL, - image_fingerprint character varying, + image_fingerprint character varying(255), changesets_count integer DEFAULT 0 NOT NULL, traces_count integer DEFAULT 0 NOT NULL, diary_entries_count integer DEFAULT 0 NOT NULL, image_use_gravatar boolean DEFAULT false NOT NULL, - image_content_type character varying, + image_content_type character varying(255), auth_provider character varying ); @@ -1223,8 +1301,8 @@ CREATE TABLE way_nodes ( CREATE TABLE way_tags ( way_id bigint DEFAULT 0 NOT NULL, - k character varying NOT NULL, - v character varying NOT NULL, + k character varying(255) NOT NULL, + v character varying(255) NOT NULL, version bigint NOT NULL ); @@ -1426,6 +1504,14 @@ ALTER TABLE ONLY acls ADD CONSTRAINT acls_pkey PRIMARY KEY (id); +-- +-- Name: ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY ar_internal_metadata + ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key); + + -- -- Name: changeset_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -1530,6 +1616,14 @@ ALTER TABLE ONLY diary_entries ADD CONSTRAINT diary_entries_pkey PRIMARY KEY (id); +-- +-- Name: diary_entry_subscriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY diary_entry_subscriptions + ADD CONSTRAINT diary_entry_subscriptions_pkey PRIMARY KEY (user_id, diary_entry_id); + + -- -- Name: friends_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -1756,7 +1850,7 @@ CREATE INDEX changeset_tags_id_idx ON changeset_tags USING btree (changeset_id); -- Name: changesets_bbox_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX changesets_bbox_idx ON changesets USING btree (min_lat, max_lat, min_lon, max_lon); +CREATE INDEX changesets_bbox_idx ON changesets USING gist (min_lat, max_lat, min_lon, max_lon); -- @@ -1935,10 +2029,17 @@ CREATE UNIQUE INDEX index_client_applications_on_key ON client_applications USIN -- --- Name: index_issue_comments_on_commenter_user_id; Type: INDEX; Schema: public; Owner: - +-- Name: index_client_applications_on_user_id; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_client_applications_on_user_id ON client_applications USING btree (user_id); + + +-- +-- Name: index_diary_entry_subscriptions_on_diary_entry_id; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX index_issue_comments_on_commenter_user_id ON issue_comments USING btree (commenter_user_id); +CREATE INDEX index_diary_entry_subscriptions_on_diary_entry_id ON diary_entry_subscriptions USING btree (diary_entry_id); -- @@ -1949,10 +2050,17 @@ CREATE INDEX index_issue_comments_on_issue_id ON issue_comments USING btree (iss -- --- Name: index_issues_on_reportable_id_and_reportable_type; Type: INDEX; Schema: public; Owner: - +-- Name: index_issue_comments_on_user_id; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX index_issues_on_reportable_id_and_reportable_type ON issues USING btree (reportable_id, reportable_type); +CREATE INDEX index_issue_comments_on_user_id ON issue_comments USING btree (user_id); + + +-- +-- Name: index_issues_on_reportable_type_and_reportable_id; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_issues_on_reportable_type_and_reportable_id ON issues USING btree (reportable_type, reportable_id); -- @@ -1997,6 +2105,13 @@ CREATE UNIQUE INDEX index_oauth_nonces_on_nonce_and_timestamp ON oauth_nonces US CREATE UNIQUE INDEX index_oauth_tokens_on_token ON oauth_tokens USING btree (token); +-- +-- Name: index_oauth_tokens_on_user_id; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_oauth_tokens_on_user_id ON oauth_tokens USING btree (user_id); + + -- -- Name: index_reports_on_issue_id; Type: INDEX; Schema: public; Owner: - -- @@ -2005,10 +2120,10 @@ CREATE INDEX index_reports_on_issue_id ON reports USING btree (issue_id); -- --- Name: index_reports_on_reporter_user_id; Type: INDEX; Schema: public; Owner: - +-- Name: index_reports_on_user_id; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX index_reports_on_reporter_user_id ON reports USING btree (reporter_user_id); +CREATE INDEX index_reports_on_user_id ON reports USING btree (user_id); -- @@ -2367,6 +2482,22 @@ ALTER TABLE ONLY diary_entries ADD CONSTRAINT diary_entries_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); +-- +-- Name: diary_entry_subscriptions_diary_entry_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY diary_entry_subscriptions + ADD CONSTRAINT diary_entry_subscriptions_diary_entry_id_fkey FOREIGN KEY (diary_entry_id) REFERENCES diary_entries(id); + + +-- +-- Name: diary_entry_subscriptions_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY diary_entry_subscriptions + ADD CONSTRAINT diary_entry_subscriptions_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); + + -- -- Name: friends_friend_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- @@ -2408,19 +2539,19 @@ ALTER TABLE ONLY gpx_files -- --- Name: issue_comments_commenter_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - +-- Name: issue_comments_issue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY issue_comments - ADD CONSTRAINT issue_comments_commenter_user_id FOREIGN KEY (commenter_user_id) REFERENCES users(id) ON DELETE CASCADE; + ADD CONSTRAINT issue_comments_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id); -- --- Name: issue_comments_issue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- Name: issue_comments_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY issue_comments - ADD CONSTRAINT issue_comments_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE; + ADD CONSTRAINT issue_comments_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); -- @@ -2428,7 +2559,15 @@ ALTER TABLE ONLY issue_comments -- ALTER TABLE ONLY issues - ADD CONSTRAINT issues_reported_user_id_fkey FOREIGN KEY (reported_user_id) REFERENCES users(id) ON DELETE CASCADE; + ADD CONSTRAINT issues_reported_user_id_fkey FOREIGN KEY (reported_user_id) REFERENCES users(id); + + +-- +-- Name: issues_resolved_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY issues + ADD CONSTRAINT issues_resolved_by_fkey FOREIGN KEY (resolved_by) REFERENCES users(id); -- @@ -2436,7 +2575,7 @@ ALTER TABLE ONLY issues -- ALTER TABLE ONLY issues - ADD CONSTRAINT issues_updated_by_fkey FOREIGN KEY (updated_by) REFERENCES users(id) ON DELETE CASCADE; + ADD CONSTRAINT issues_updated_by_fkey FOREIGN KEY (updated_by) REFERENCES users(id); -- @@ -2556,15 +2695,15 @@ ALTER TABLE ONLY relations -- ALTER TABLE ONLY reports - ADD CONSTRAINT reports_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE; + ADD CONSTRAINT reports_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id); -- --- Name: reports_reporter_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- Name: reports_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY reports - ADD CONSTRAINT reports_reporter_user_id_fkey FOREIGN KEY (reporter_user_id) REFERENCES users(id) ON DELETE CASCADE; + ADD CONSTRAINT reports_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); -- @@ -2659,195 +2798,104 @@ ALTER TABLE ONLY ways -- PostgreSQL database dump complete -- -SET search_path TO "$user",public; - -INSERT INTO schema_migrations (version) VALUES ('1'); - -INSERT INTO schema_migrations (version) VALUES ('10'); - -INSERT INTO schema_migrations (version) VALUES ('11'); - -INSERT INTO schema_migrations (version) VALUES ('12'); - -INSERT INTO schema_migrations (version) VALUES ('13'); - -INSERT INTO schema_migrations (version) VALUES ('14'); - -INSERT INTO schema_migrations (version) VALUES ('15'); - -INSERT INTO schema_migrations (version) VALUES ('16'); - -INSERT INTO schema_migrations (version) VALUES ('17'); - -INSERT INTO schema_migrations (version) VALUES ('18'); - -INSERT INTO schema_migrations (version) VALUES ('19'); - -INSERT INTO schema_migrations (version) VALUES ('2'); - -INSERT INTO schema_migrations (version) VALUES ('20'); - -INSERT INTO schema_migrations (version) VALUES ('20100513171259'); - -INSERT INTO schema_migrations (version) VALUES ('20100516124737'); - -INSERT INTO schema_migrations (version) VALUES ('20100910084426'); - -INSERT INTO schema_migrations (version) VALUES ('20101114011429'); - -INSERT INTO schema_migrations (version) VALUES ('20110322001319'); - -INSERT INTO schema_migrations (version) VALUES ('20110508145337'); - -INSERT INTO schema_migrations (version) VALUES ('20110521142405'); - -INSERT INTO schema_migrations (version) VALUES ('20110925112722'); - -INSERT INTO schema_migrations (version) VALUES ('20111116184519'); - -INSERT INTO schema_migrations (version) VALUES ('20111212183945'); - -INSERT INTO schema_migrations (version) VALUES ('20120123184321'); - -INSERT INTO schema_migrations (version) VALUES ('20120208122334'); - -INSERT INTO schema_migrations (version) VALUES ('20120208194454'); - -INSERT INTO schema_migrations (version) VALUES ('20120214210114'); - -INSERT INTO schema_migrations (version) VALUES ('20120219161649'); - -INSERT INTO schema_migrations (version) VALUES ('20120318201948'); - -INSERT INTO schema_migrations (version) VALUES ('20120328090602'); - -INSERT INTO schema_migrations (version) VALUES ('20120404205604'); - -INSERT INTO schema_migrations (version) VALUES ('20120808231205'); - -INSERT INTO schema_migrations (version) VALUES ('20121005195010'); - -INSERT INTO schema_migrations (version) VALUES ('20121012044047'); - -INSERT INTO schema_migrations (version) VALUES ('20121119165817'); - -INSERT INTO schema_migrations (version) VALUES ('20121202155309'); - -INSERT INTO schema_migrations (version) VALUES ('20121203124841'); - -INSERT INTO schema_migrations (version) VALUES ('20130328184137'); - -INSERT INTO schema_migrations (version) VALUES ('20131212124700'); - -INSERT INTO schema_migrations (version) VALUES ('20140115192822'); - -INSERT INTO schema_migrations (version) VALUES ('20140117185510'); - -INSERT INTO schema_migrations (version) VALUES ('20140210003018'); - -INSERT INTO schema_migrations (version) VALUES ('20140507110937'); - -INSERT INTO schema_migrations (version) VALUES ('20140519141742'); - -INSERT INTO schema_migrations (version) VALUES ('20150110152606'); - -INSERT INTO schema_migrations (version) VALUES ('20150111192335'); - -INSERT INTO schema_migrations (version) VALUES ('20150222101847'); - -INSERT INTO schema_migrations (version) VALUES ('20150818224516'); - -INSERT INTO schema_migrations (version) VALUES ('20160822153055'); - -INSERT INTO schema_migrations (version) VALUES ('20160822153115'); - -INSERT INTO schema_migrations (version) VALUES ('20160822153153'); - -INSERT INTO schema_migrations (version) VALUES ('21'); - -INSERT INTO schema_migrations (version) VALUES ('22'); - -INSERT INTO schema_migrations (version) VALUES ('23'); - -INSERT INTO schema_migrations (version) VALUES ('24'); - -INSERT INTO schema_migrations (version) VALUES ('25'); - -INSERT INTO schema_migrations (version) VALUES ('26'); - -INSERT INTO schema_migrations (version) VALUES ('27'); - -INSERT INTO schema_migrations (version) VALUES ('28'); - -INSERT INTO schema_migrations (version) VALUES ('29'); - -INSERT INTO schema_migrations (version) VALUES ('3'); - -INSERT INTO schema_migrations (version) VALUES ('30'); - -INSERT INTO schema_migrations (version) VALUES ('31'); - -INSERT INTO schema_migrations (version) VALUES ('32'); - -INSERT INTO schema_migrations (version) VALUES ('33'); - -INSERT INTO schema_migrations (version) VALUES ('34'); - -INSERT INTO schema_migrations (version) VALUES ('35'); - -INSERT INTO schema_migrations (version) VALUES ('36'); - -INSERT INTO schema_migrations (version) VALUES ('37'); - -INSERT INTO schema_migrations (version) VALUES ('38'); - -INSERT INTO schema_migrations (version) VALUES ('39'); - -INSERT INTO schema_migrations (version) VALUES ('4'); - -INSERT INTO schema_migrations (version) VALUES ('40'); - -INSERT INTO schema_migrations (version) VALUES ('41'); - -INSERT INTO schema_migrations (version) VALUES ('42'); - -INSERT INTO schema_migrations (version) VALUES ('43'); - -INSERT INTO schema_migrations (version) VALUES ('44'); - -INSERT INTO schema_migrations (version) VALUES ('45'); - -INSERT INTO schema_migrations (version) VALUES ('46'); - -INSERT INTO schema_migrations (version) VALUES ('47'); - -INSERT INTO schema_migrations (version) VALUES ('48'); - -INSERT INTO schema_migrations (version) VALUES ('49'); - -INSERT INTO schema_migrations (version) VALUES ('5'); - -INSERT INTO schema_migrations (version) VALUES ('50'); - -INSERT INTO schema_migrations (version) VALUES ('51'); - -INSERT INTO schema_migrations (version) VALUES ('52'); - -INSERT INTO schema_migrations (version) VALUES ('53'); - -INSERT INTO schema_migrations (version) VALUES ('54'); - -INSERT INTO schema_migrations (version) VALUES ('55'); - -INSERT INTO schema_migrations (version) VALUES ('56'); - -INSERT INTO schema_migrations (version) VALUES ('57'); - -INSERT INTO schema_migrations (version) VALUES ('6'); - -INSERT INTO schema_migrations (version) VALUES ('7'); - -INSERT INTO schema_migrations (version) VALUES ('8'); +SET search_path TO "$user", public; + +INSERT INTO "schema_migrations" (version) VALUES +('1'), +('10'), +('11'), +('12'), +('13'), +('14'), +('15'), +('16'), +('17'), +('18'), +('19'), +('2'), +('20'), +('20100513171259'), +('20100516124737'), +('20100910084426'), +('20101114011429'), +('20110322001319'), +('20110508145337'), +('20110521142405'), +('20110925112722'), +('20111116184519'), +('20111212183945'), +('20120123184321'), +('20120208122334'), +('20120208194454'), +('20120214210114'), +('20120219161649'), +('20120318201948'), +('20120328090602'), +('20120404205604'), +('20120808231205'), +('20121005195010'), +('20121012044047'), +('20121119165817'), +('20121202155309'), +('20121203124841'), +('20130328184137'), +('20131212124700'), +('20140115192822'), +('20140117185510'), +('20140210003018'), +('20140507110937'), +('20140519141742'), +('20150110152606'), +('20150111192335'), +('20150222101847'), +('20150818224516'), +('20160822153055'), +('20161002153425'), +('20161011010929'), +('20170222134109'), +('21'), +('22'), +('23'), +('24'), +('25'), +('26'), +('27'), +('28'), +('29'), +('3'), +('30'), +('31'), +('32'), +('33'), +('34'), +('35'), +('36'), +('37'), +('38'), +('39'), +('4'), +('40'), +('41'), +('42'), +('43'), +('44'), +('45'), +('46'), +('47'), +('48'), +('49'), +('5'), +('50'), +('51'), +('52'), +('53'), +('54'), +('55'), +('56'), +('57'), +('6'), +('7'), +('8'), +('9'); -INSERT INTO schema_migrations (version) VALUES ('9');