about summary refs log tree commit diff
path: root/sql/PostgreSQL/downgrade/4-3
diff options
context:
space:
mode:
Diffstat (limited to 'sql/PostgreSQL/downgrade/4-3')
-rw-r--r--sql/PostgreSQL/downgrade/4-3/001-auto.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/PostgreSQL/downgrade/4-3/001-auto.sql b/sql/PostgreSQL/downgrade/4-3/001-auto.sql
new file mode 100644
index 0000000..e40aafe
--- /dev/null
+++ b/sql/PostgreSQL/downgrade/4-3/001-auto.sql
@@ -0,0 +1,12 @@
+-- Convert schema 'sql/_source/deploy/4/001-auto.yml' to 'sql/_source/deploy/3/001-auto.yml':;
+
+;
+BEGIN;
+
+;
+ALTER TABLE task ADD CONSTRAINT "task_projectid" UNIQUE (projectid);
+
+;
+
+COMMIT;
+