From 85c05d8e967deb9bf6cd544119da577acb035714 Mon Sep 17 00:00:00 2001
From: Robin Houston <robin@lenny.robin>
Date: Thu, 9 Jun 2011 17:19:52 +0100
Subject: 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.)

---
 db/development_structure.sql | 32 +++++++++++++++++++++++++++-----
 1 file changed, 27 insertions(+), 5 deletions(-)

(limited to 'db/development_structure.sql')

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
@@ -1309,6 +1307,30 @@ CREATE UNIQUE INDEX users_email_index ON users USING btree (lower((email)::text)
 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: -
 --
-- 
cgit v1.2.3

