diff options
Diffstat (limited to 'db/structure.sql')
-rw-r--r-- | db/structure.sql | 21 |
1 files changed, 19 insertions, 2 deletions
diff --git a/db/structure.sql b/db/structure.sql index 7b5d81f..9e03d7d 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -167,7 +167,8 @@ CREATE TABLE public.mini_environments ( backend_type character varying, backend_id bigint, backend_data jsonb, - signon_users jsonb + signon_users jsonb, + data_snapshot_id bigint ); @@ -575,6 +576,13 @@ CREATE INDEX index_mini_environments_on_backend_type_and_backend_id ON public.mi -- +-- Name: index_mini_environments_on_data_snapshot_id; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_mini_environments_on_data_snapshot_id ON public.mini_environments USING btree (data_snapshot_id); + + +-- -- Name: index_mini_environments_on_govuk_guix_revision_id; Type: INDEX; Schema: public; Owner: - -- @@ -606,6 +614,14 @@ ALTER TABLE ONLY public.govuk_guix_data_snapshots -- +-- Name: mini_environments fk_rails_eba071cb24; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY public.mini_environments + ADD CONSTRAINT fk_rails_eba071cb24 FOREIGN KEY (data_snapshot_id) REFERENCES public.govuk_guix_data_snapshots(id); + + +-- -- PostgreSQL database dump complete -- @@ -643,6 +659,7 @@ INSERT INTO "schema_migrations" (version) VALUES ('20180527183740'), ('20180530191341'), ('20180530192706'), -('20180601153537'); +('20180601153537'), +('20180601182655'); |