diff options
| author | Robin Houston <robin@lenny.robin> | 2011-06-09 17:19:52 +0100 |
|---|---|---|
| committer | Robin Houston <robin@lenny.robin> | 2011-06-09 17:19:52 +0100 |
| commit | 85c05d8e967deb9bf6cd544119da577acb035714 (patch) | |
| tree | d65bd20230c565dad9f582a800ea1edf1daf5e5c /db/development_structure.sql | |
| parent | 5591cc2c9be9b7c7cb07a8ef2a7fcf5edcdfbbd2 (diff) | |
Updated db/development_structure.sql (Having this file in the repository is a bit of a mixed blessing: it gives an easy way to see the entire schema, but different versions of PostgreSQL will result in very slightly different files, so unless all developers use precisely the same version there will be some spurious differences.)
Diffstat (limited to 'db/development_structure.sql')
| -rw-r--r-- | db/development_structure.sql | 32 |
1 files changed, 27 insertions, 5 deletions
diff --git a/db/development_structure.sql b/db/development_structure.sql index d9ce53380..38d90e719 100644 --- a/db/development_structure.sql +++ b/db/development_structure.sql @@ -2,7 +2,6 @@ -- PostgreSQL database dump -- -SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; @@ -215,7 +214,6 @@ CREATE TABLE holidays ( -- CREATE SEQUENCE holidays_id_seq - START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE @@ -516,12 +514,12 @@ CREATE TABLE public_body_translations ( id integer NOT NULL, public_body_id integer, locale character varying(255), - short_name text, request_email text, - notes text, - publication_scheme text, url_name text, + publication_scheme text, + notes text, first_letter character varying(255), + short_name text, name text, created_at timestamp without time zone, updated_at timestamp without time zone @@ -1310,6 +1308,30 @@ CREATE INDEX users_lower_email_index ON users USING btree (lower((email)::text)) -- +-- Name: fk_censor_rules_info_request; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY censor_rules + ADD CONSTRAINT fk_censor_rules_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id); + + +-- +-- Name: fk_censor_rules_public_body; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY censor_rules + ADD CONSTRAINT fk_censor_rules_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id); + + +-- +-- Name: fk_censor_rules_user; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY censor_rules + ADD CONSTRAINT fk_censor_rules_user FOREIGN KEY (user_id) REFERENCES users(id); + + +-- -- Name: fk_comments_info_request; Type: FK CONSTRAINT; Schema: public; Owner: - -- |