--
--- Name: issue_comments; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: issue_comments; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE issue_comments (
--
--- Name: issues; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: issues; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE issues (
resolved_by integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
- updated_by integer
+ updated_by integer,
+ report_count integer DEFAULT 0
);
--
--- Name: reports; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: reports; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reports (
--
--- Name: issue_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: issue_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
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
--
--- Name: reports_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: reports_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reports
--
--- Name: index_issue_comments_on_commenter_user_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_commenter_user_id ON issue_comments USING btree (commenter_user_id);
--
--- Name: index_issue_comments_on_issue_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_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_reported_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_updated_by ON issues USING btree (updated_by);
+
+
--
-- Name: index_note_comments_on_body; Type: INDEX; Schema: public; Owner: -
--
--
--- 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_reporter_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_reporter_user_id ON reports USING btree (reporter_user_id);
--
ALTER TABLE ONLY issue_comments
- ADD CONSTRAINT issue_comments_commenter_user_id FOREIGN KEY (commenter_user_id) REFERENCES users(id);
+ ADD CONSTRAINT issue_comments_commenter_user_id FOREIGN KEY (commenter_user_id) REFERENCES users(id) ON DELETE CASCADE;
--
--
ALTER TABLE ONLY issue_comments
- ADD CONSTRAINT issue_comments_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id);
+ ADD CONSTRAINT issue_comments_issue_id_fkey FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE;
--
--
ALTER TABLE ONLY issues
- ADD CONSTRAINT issues_reported_user_id_fkey FOREIGN KEY (reported_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;
--
--
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;
--
--
ALTER TABLE ONLY reports
- ADD CONSTRAINT reports_reporter_user_id_fkey FOREIGN KEY (reporter_user_id) REFERENCES users(id);
+ ADD CONSTRAINT reports_reporter_user_id_fkey FOREIGN KEY (reporter_user_id) REFERENCES users(id) ON DELETE CASCADE;
--
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 ('20150526130032');
+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 ('8');
INSERT INTO schema_migrations (version) VALUES ('9');
-