Use a simple user_id for tables with one owning user

[rails.git] / db / structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index 7888d8a9cfde10976355e1862ae1f5b422fb9381..742791df544f70baafa75f6aeb4fcfe3318a98da 100644 (file)
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -692,9 +692,8 @@ ALTER SEQUENCE gpx_files_id_seq OWNED BY gpx_files.id;
 CREATE TABLE issue_comments (
     id integer NOT NULL,
     issue_id integer NOT NULL,
 CREATE TABLE issue_comments (
     id integer NOT NULL,
     issue_id integer NOT NULL,

-    commenter_user_id integer NOT NULL,
+    user_id integer NOT NULL,

     body text NOT NULL,
     body text NOT NULL,

-    reassign boolean,

     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL
 );
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL
 );


@@ -733,9 +732,9 @@ CREATE TABLE issues (
     resolved_at timestamp without time zone,
     resolved_by integer,
     updated_by integer,
     resolved_at timestamp without time zone,
     resolved_by integer,
     updated_by integer,

+    reports_count integer DEFAULT 0,

     created_at timestamp without time zone NOT NULL,
     created_at timestamp without time zone NOT NULL,

-    updated_at timestamp without time zone NOT NULL,
-    reports_count integer DEFAULT 0
+    updated_at timestamp without time zone NOT NULL

 );
 
 
 );
 
 


@@ -1066,8 +1065,8 @@ CREATE TABLE relations (
 CREATE TABLE reports (
     id integer NOT NULL,
     issue_id integer,
 CREATE TABLE reports (
     id integer NOT NULL,
     issue_id integer,

-    reporter_user_id integer,
-    details text,
+    user_id integer,
+    details text NOT NULL,

     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL
 );
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL
 );


@@ -2032,17 +2031,17 @@ CREATE INDEX index_diary_entry_subscriptions_on_diary_entry_id ON diary_entry_su
 
 
 --
 
 
 --

--- Name: index_issue_comments_on_commenter_user_id; Type: INDEX; Schema: public; Owner: -
+-- Name: index_issue_comments_on_issue_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_issue_comments_on_issue_id ON issue_comments USING btree (issue_id);

 
 
 --
 
 
 --

--- Name: index_issue_comments_on_issue_id; Type: INDEX; Schema: public; Owner: -
+-- Name: index_issue_comments_on_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_user_id ON issue_comments USING btree (user_id);

 
 
 --
 
 
 --


@@ -2109,10 +2108,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);

 
 
 --
 
 
 --


@@ -2528,19 +2527,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
 --
 
 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) ON DELETE CASCADE;

 
 
 --
 
 
 --

--- Name: issue_comments_issue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: issue_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -

 --
 
 ALTER TABLE ONLY issue_comments
 --
 
 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 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

 
 
 --
 
 
 --


@@ -2680,11 +2679,11 @@ ALTER TABLE ONLY reports
 
 
 --
 
 
 --

--- 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
 --
 
 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) ON DELETE CASCADE;

 
 
 --
 
 
 --


@@ -2831,8 +2830,6 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20150222101847'),
 ('20150818224516'),
 ('20160822153055'),
 ('20150222101847'),
 ('20150818224516'),
 ('20160822153055'),

-('20160822153115'),
-('20160822153153'),

 ('20161002153425'),
 ('20161011010929'),
 ('20170222134109'),
 ('20161002153425'),
 ('20161011010929'),
 ('20170222134109'),