From 746e78ce1beba9152d7c67930959fdb0747fadc9 Mon Sep 17 00:00:00 2001 From: Seb Bacon Date: Fri, 1 Apr 2011 15:14:20 +0100 Subject: further test fixage --- db/development_structure.sql | 94 ++++++++++++++++++++++++++++++++------------ 1 file changed, 68 insertions(+), 26 deletions(-) (limited to 'db/development_structure.sql') diff --git a/db/development_structure.sql b/db/development_structure.sql index 1dd93901b..d9ce53380 100644 --- a/db/development_structure.sql +++ b/db/development_structure.sql @@ -95,7 +95,8 @@ CREATE TABLE comments ( body text NOT NULL, visible boolean DEFAULT true NOT NULL, created_at timestamp without time zone NOT NULL, - updated_at timestamp without time zone NOT NULL + updated_at timestamp without time zone NOT NULL, + locale text DEFAULT ''::text NOT NULL ); @@ -507,6 +508,45 @@ CREATE SEQUENCE public_body_tags_id_seq ALTER SEQUENCE public_body_tags_id_seq OWNED BY has_tag_string_tags.id; +-- +-- Name: public_body_translations; Type: TABLE; Schema: public; Owner: -; Tablespace: +-- + +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, + first_letter character varying(255), + name text, + created_at timestamp without time zone, + updated_at timestamp without time zone +); + + +-- +-- Name: public_body_translations_id_seq; Type: SEQUENCE; Schema: public; Owner: - +-- + +CREATE SEQUENCE public_body_translations_id_seq + START WITH 1 + INCREMENT BY 1 + NO MAXVALUE + NO MINVALUE + CACHE 1; + + +-- +-- Name: public_body_translations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - +-- + +ALTER SEQUENCE public_body_translations_id_seq OWNED BY public_body_translations.id; + + -- -- Name: public_body_versions; Type: TABLE; Schema: public; Owner: -; Tablespace: -- @@ -828,6 +868,13 @@ ALTER TABLE profile_photos ALTER COLUMN id SET DEFAULT nextval('profile_photos_i ALTER TABLE public_bodies ALTER COLUMN id SET DEFAULT nextval('public_bodies_id_seq'::regclass); +-- +-- Name: id; Type: DEFAULT; Schema: public; Owner: - +-- + +ALTER TABLE public_body_translations ALTER COLUMN id SET DEFAULT nextval('public_body_translations_id_seq'::regclass); + + -- -- Name: id; Type: DEFAULT; Schema: public; Owner: - -- @@ -982,6 +1029,14 @@ ALTER TABLE ONLY has_tag_string_tags ADD CONSTRAINT public_body_tags_pkey PRIMARY KEY (id); +-- +-- Name: public_body_translations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: +-- + +ALTER TABLE ONLY public_body_translations + ADD CONSTRAINT public_body_translations_pkey PRIMARY KEY (id); + + -- -- Name: public_body_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- @@ -1191,6 +1246,13 @@ CREATE INDEX index_public_body_tags_on_name ON has_tag_string_tags USING btree ( CREATE UNIQUE INDEX index_public_body_tags_on_public_body_id_and_name_and_value ON has_tag_string_tags USING btree (model_id, name, value); +-- +-- Name: index_public_body_translations_on_public_body_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- + +CREATE INDEX index_public_body_translations_on_public_body_id ON public_body_translations USING btree (public_body_id); + + -- -- Name: index_track_things_on_tracking_user_id_and_track_query; Type: INDEX; Schema: public; Owner: -; Tablespace: -- @@ -1247,30 +1309,6 @@ 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: - -- @@ -1673,4 +1711,8 @@ INSERT INTO schema_migrations (version) VALUES ('93'); INSERT INTO schema_migrations (version) VALUES ('94'); -INSERT INTO schema_migrations (version) VALUES ('95'); \ No newline at end of file +INSERT INTO schema_migrations (version) VALUES ('95'); + +INSERT INTO schema_migrations (version) VALUES ('96'); + +INSERT INTO schema_migrations (version) VALUES ('97'); \ No newline at end of file -- cgit v1.2.3