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/SQLite/downgrade/3-2/001-auto.sql | 49 +++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 sql/SQLite/downgrade/3-2/001-auto.sql

(limited to 'sql/SQLite/downgrade/3-2/001-auto.sql')

diff --git a/sql/SQLite/downgrade/3-2/001-auto.sql b/sql/SQLite/downgrade/3-2/001-auto.sql
new file mode 100644
index 0000000..1a13821
--- /dev/null
+++ b/sql/SQLite/downgrade/3-2/001-auto.sql
@@ -0,0 +1,49 @@
+-- Convert schema 'sql/_source/deploy/3/001-auto.yml' to 'sql/_source/deploy/2/001-auto.yml':;
+
+;
+BEGIN;
+
+;
+CREATE TEMPORARY TABLE task_temp_alter (
+  taskid INTEGER PRIMARY KEY NOT NULL,
+  sha256 text NOT NULL,
+  projectid int NOT NULL,
+  running bool NOT NULL DEFAULT '0'
+);
+
+;
+INSERT INTO task_temp_alter SELECT taskid, sha256, projectid, running FROM task;
+
+;
+DROP TABLE task;
+
+;
+CREATE TABLE task (
+  taskid INTEGER PRIMARY KEY NOT NULL,
+  sha256 text NOT NULL,
+  projectid int NOT NULL,
+  running bool NOT NULL DEFAULT '0'
+);
+
+;
+CREATE INDEX task_idx_sha25602 ON task (sha256);
+
+;
+CREATE INDEX task_idx_projectid02 ON task (projectid);
+
+;
+CREATE UNIQUE INDEX task_projectid02 ON task (projectid);
+
+;
+CREATE UNIQUE INDEX task_sha25602 ON task (sha256);
+
+;
+INSERT INTO task SELECT taskid, sha256, projectid, running FROM task_temp_alter;
+
+;
+DROP TABLE task_temp_alter;
+
+;
+
+COMMIT;
+
-- 
cgit v1.2.3

