From 2309ed42a44905214f96a7cbafed444fbf0f714f Mon Sep 17 00:00:00 2001
From: franck cuny <franck@lumberjaph.net>
Date: Sun, 13 Feb 2011 17:38:02 +0100
Subject: import schema modifications

---
 sql/MySQL/upgrade/2-3/001-auto.sql | 12 ++++++++++++
 sql/MySQL/upgrade/3-4/001-auto.sql | 12 ++++++++++++
 2 files changed, 24 insertions(+)
 create mode 100644 sql/MySQL/upgrade/2-3/001-auto.sql
 create mode 100644 sql/MySQL/upgrade/3-4/001-auto.sql

(limited to 'sql/MySQL/upgrade')

diff --git a/sql/MySQL/upgrade/2-3/001-auto.sql b/sql/MySQL/upgrade/2-3/001-auto.sql
new file mode 100644
index 0000000..f88b4de
--- /dev/null
+++ b/sql/MySQL/upgrade/2-3/001-auto.sql
@@ -0,0 +1,12 @@
+-- Convert schema 'sql/_source/deploy/2/001-auto.yml' to 'sql/_source/deploy/3/001-auto.yml':;
+
+;
+BEGIN;
+
+;
+ALTER TABLE task ADD COLUMN started_when datetime;
+
+;
+
+COMMIT;
+
diff --git a/sql/MySQL/upgrade/3-4/001-auto.sql b/sql/MySQL/upgrade/3-4/001-auto.sql
new file mode 100644
index 0000000..8fa3cbf
--- /dev/null
+++ b/sql/MySQL/upgrade/3-4/001-auto.sql
@@ -0,0 +1,12 @@
+-- Convert schema 'sql/_source/deploy/3/001-auto.yml' to 'sql/_source/deploy/4/001-auto.yml':;
+
+;
+BEGIN;
+
+;
+ALTER TABLE task DROP INDEX task_projectid;
+
+;
+
+COMMIT;
+
-- 
cgit 1.4.1