X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/683722ed5c1b3224a04c23b4d175a0638964f713..9046b5ba8d07cd8907685ab8da7f73829cb692c5:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index f0a07adf5..53be24a5a 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -664,15 +664,16 @@ ALTER SEQUENCE gpx_files_id_seq OWNED BY gpx_files.id; -- --- Name: issue_comments; Type: TABLE; Schema: public; Owner: -; Tablespace: +-- Name: issue_comments; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE issue_comments ( id integer NOT NULL, issue_id integer, - user_id integer, + commenter_user_id integer, body text, created_at timestamp without time zone NOT NULL, + reassign boolean, updated_at timestamp without time zone NOT NULL ); @@ -697,19 +698,22 @@ ALTER SEQUENCE issue_comments_id_seq OWNED BY issue_comments.id; -- --- Name: issues; Type: TABLE; Schema: public; Owner: -; Tablespace: +-- Name: issues; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE issues ( id integer NOT NULL, - reportable_type character varying, - reportable_id integer, - user_id integer, + reportable_type character varying NOT NULL, + reportable_id integer NOT NULL, + reported_user_id integer NOT NULL, status integer, + issue_type character varying, 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_at timestamp without time zone NOT NULL, + updated_by integer, + report_count integer DEFAULT 0 ); @@ -1034,13 +1038,13 @@ CREATE TABLE relations ( -- --- Name: reports; Type: TABLE; Schema: public; Owner: -; Tablespace: +-- Name: reports; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE reports ( id integer NOT NULL, issue_id integer, - user_id integer, + reporter_user_id integer, details text, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL @@ -1596,7 +1600,7 @@ ALTER TABLE ONLY gpx_files -- --- Name: issue_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: +-- Name: issue_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY issue_comments @@ -1604,7 +1608,7 @@ ALTER TABLE ONLY issue_comments -- --- Name: issues_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: +-- Name: issues_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY issues @@ -1708,7 +1712,7 @@ ALTER TABLE ONLY relations -- --- Name: reports_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: +-- Name: reports_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY reports @@ -1976,31 +1980,38 @@ CREATE UNIQUE INDEX index_client_applications_on_key ON client_applications USIN -- --- Name: index_issue_comments_on_issue_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_issue_comments_on_commenter_user_id; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX index_issue_comments_on_issue_id ON issue_comments USING btree (issue_id); +CREATE INDEX index_issue_comments_on_commenter_user_id ON issue_comments USING btree (commenter_user_id); -- --- Name: index_issue_comments_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_issue_comments_on_issue_id; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX index_issue_comments_on_user_id ON issue_comments USING btree (user_id); +CREATE INDEX index_issue_comments_on_issue_id ON issue_comments USING btree (issue_id); -- --- Name: index_issues_on_reportable_id_and_reportable_type; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_issues_on_reportable_id_and_reportable_type; Type: INDEX; Schema: public; Owner: - -- CREATE INDEX index_issues_on_reportable_id_and_reportable_type ON issues USING btree (reportable_id, reportable_type); -- --- Name: index_issues_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_issues_on_reported_user_id; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_issues_on_reported_user_id ON issues USING btree (reported_user_id); + + +-- +-- Name: index_issues_on_updated_by; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX index_issues_on_user_id ON issues USING btree (user_id); +CREATE INDEX index_issues_on_updated_by ON issues USING btree (updated_by); -- @@ -2032,17 +2043,17 @@ CREATE UNIQUE INDEX index_oauth_tokens_on_token ON oauth_tokens USING btree (tok -- --- Name: index_reports_on_issue_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_reports_on_issue_id; Type: INDEX; Schema: public; Owner: - -- CREATE INDEX index_reports_on_issue_id ON reports USING btree (issue_id); -- --- Name: index_reports_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_reports_on_reporter_user_id; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX index_reports_on_user_id ON reports USING btree (user_id); +CREATE INDEX index_reports_on_reporter_user_id ON reports USING btree (reporter_user_id); -- @@ -2442,27 +2453,35 @@ ALTER TABLE ONLY gpx_files -- --- Name: issue_comments_issue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- Name: issue_comments_commenter_user_id; 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); + ADD CONSTRAINT issue_comments_commenter_user_id FOREIGN KEY (commenter_user_id) REFERENCES users(id) ON DELETE CASCADE; -- --- Name: issue_comments_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_user_id FOREIGN KEY (user_id) REFERENCES users(id); + ADD CONSTRAINT issue_comments_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE; -- --- Name: issues_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- Name: issues_reported_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY issues - ADD CONSTRAINT issues_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); + ADD CONSTRAINT issues_reported_user_id_fkey FOREIGN KEY (reported_user_id) REFERENCES users(id) ON DELETE CASCADE; + + +-- +-- Name: issues_updated_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY issues + ADD CONSTRAINT issues_updated_by_fkey FOREIGN KEY (updated_by) REFERENCES users(id) ON DELETE CASCADE; -- @@ -2582,15 +2601,15 @@ ALTER TABLE ONLY relations -- ALTER TABLE ONLY reports - ADD CONSTRAINT reports_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id); + ADD CONSTRAINT reports_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE; -- --- Name: reports_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- Name: reports_reporter_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY reports - ADD CONSTRAINT reports_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); + ADD CONSTRAINT reports_reporter_user_id_fkey FOREIGN KEY (reporter_user_id) REFERENCES users(id) ON DELETE CASCADE; -- @@ -2783,15 +2802,13 @@ INSERT INTO schema_migrations (version) VALUES ('20150111192335'); INSERT INTO schema_migrations (version) VALUES ('20150222101847'); -INSERT INTO schema_migrations (version) VALUES ('20150516073616'); +INSERT INTO schema_migrations (version) VALUES ('20150818224516'); -INSERT INTO schema_migrations (version) VALUES ('20150516075620'); +INSERT INTO schema_migrations (version) VALUES ('20160822153055'); -INSERT INTO schema_migrations (version) VALUES ('20150526130032'); +INSERT INTO schema_migrations (version) VALUES ('20160822153115'); -INSERT INTO schema_migrations (version) VALUES ('20150528113100'); - -INSERT INTO schema_migrations (version) VALUES ('20150528114520'); +INSERT INTO schema_migrations (version) VALUES ('20160822153153'); INSERT INTO schema_migrations (version) VALUES ('21'); @@ -2880,4 +2897,3 @@ INSERT INTO schema_migrations (version) VALUES ('7'); INSERT INTO schema_migrations (version) VALUES ('8'); INSERT INTO schema_migrations (version) VALUES ('9'); -