diff options
Diffstat (limited to 'sql/MySQL/downgrade')
-rw-r--r-- | sql/MySQL/downgrade/3-2/001-auto.sql | 12 | ||||
-rw-r--r-- | sql/MySQL/downgrade/4-3/001-auto.sql | 12 |
2 files changed, 24 insertions, 0 deletions
diff --git a/sql/MySQL/downgrade/3-2/001-auto.sql b/sql/MySQL/downgrade/3-2/001-auto.sql new file mode 100644 index 0000000..64b6ca2 --- /dev/null +++ b/sql/MySQL/downgrade/3-2/001-auto.sql @@ -0,0 +1,12 @@ +-- Convert schema 'sql/_source/deploy/3/001-auto.yml' to 'sql/_source/deploy/2/001-auto.yml':; + +; +BEGIN; + +; +ALTER TABLE task DROP COLUMN started_when; + +; + +COMMIT; + diff --git a/sql/MySQL/downgrade/4-3/001-auto.sql b/sql/MySQL/downgrade/4-3/001-auto.sql new file mode 100644 index 0000000..63475c8 --- /dev/null +++ b/sql/MySQL/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 UNIQUE task_projectid (projectid); + +; + +COMMIT; + |