From 2309ed42a44905214f96a7cbafed444fbf0f714f Mon Sep 17 00:00:00 2001 From: franck cuny Date: Sun, 13 Feb 2011 17:38:02 +0100 Subject: import schema modifications --- sql/SQLite/downgrade/3-2/001-auto.sql | 49 +++++++++++++++++++++++++++++++++++ sql/SQLite/downgrade/4-3/001-auto.sql | 12 +++++++++ 2 files changed, 61 insertions(+) create mode 100644 sql/SQLite/downgrade/3-2/001-auto.sql create mode 100644 sql/SQLite/downgrade/4-3/001-auto.sql (limited to 'sql/SQLite/downgrade') 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; + diff --git a/sql/SQLite/downgrade/4-3/001-auto.sql b/sql/SQLite/downgrade/4-3/001-auto.sql new file mode 100644 index 0000000..773dbb8 --- /dev/null +++ b/sql/SQLite/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; + +; +CREATE UNIQUE INDEX task_projectid ON task (projectid); + +; + +COMMIT; + -- cgit 1.4.1