From e122d5a55de18a0950a4bba54f25b8dccc3ab1bc Mon Sep 17 00:00:00 2001 From: Mark Hymers Date: Tue, 26 Jul 2011 23:29:16 +0100 Subject: [PATCH] Update schema version Signed-off-by: Mark Hymers --- setup/current_schema.sql | 2 +- setup/{schema_61.sql => schema_62.sql} | 11 ++++++++++- 2 files changed, 11 insertions(+), 2 deletions(-) rename setup/{schema_61.sql => schema_62.sql} (99%) diff --git a/setup/current_schema.sql b/setup/current_schema.sql index c9cfd43f..a52d8c02 120000 --- a/setup/current_schema.sql +++ b/setup/current_schema.sql @@ -1 +1 @@ -schema_61.sql \ No newline at end of file +schema_62.sql \ No newline at end of file diff --git a/setup/schema_61.sql b/setup/schema_62.sql similarity index 99% rename from setup/schema_61.sql rename to setup/schema_62.sql index 29bb5d31..4229a235 100644 --- a/setup/schema_61.sql +++ b/setup/schema_62.sql @@ -3042,6 +3042,14 @@ ALTER TABLE ONLY suite_architectures ADD CONSTRAINT suite_architectures_pkey PRIMARY KEY (suite, architecture); +-- +-- Name: suite_name_unique; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace: +-- + +ALTER TABLE ONLY suite + ADD CONSTRAINT suite_name_unique UNIQUE (suite_name); + + -- -- Name: suite_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace: -- @@ -5578,4 +5586,5 @@ GRANT SELECT ON TABLE version_checks TO PUBLIC; -- -- Set schema version -INSERT INTO config (name, value) VALUES ('db_revision', 61); +INSERT INTO config (name, value) VALUES ('db_revision', 62); + -- 2.39.2