diff options
author | franck cuny <franck@lumberjaph.net> | 2011-02-13 17:38:02 +0100 |
---|---|---|
committer | franck cuny <franck@lumberjaph.net> | 2011-02-13 17:38:02 +0100 |
commit | 2309ed42a44905214f96a7cbafed444fbf0f714f (patch) | |
tree | 2edef616ce274e1ff3b3dfad9554af355b8f59a9 /sql/SQLite | |
parent | don't ignore sql files (diff) | |
download | jitterbug-2309ed42a44905214f96a7cbafed444fbf0f714f.tar.gz |
import schema modifications
Diffstat (limited to '')
-rw-r--r-- | sql/SQLite/deploy/3/001-auto-__VERSION.sql | 18 | ||||
-rw-r--r-- | sql/SQLite/deploy/3/001-auto.sql | 44 | ||||
-rw-r--r-- | sql/SQLite/deploy/4/001-auto-__VERSION.sql | 18 | ||||
-rw-r--r-- | sql/SQLite/deploy/4/001-auto.sql | 43 | ||||
-rw-r--r-- | sql/SQLite/downgrade/3-2/001-auto.sql | 49 | ||||
-rw-r--r-- | sql/SQLite/downgrade/4-3/001-auto.sql | 12 | ||||
-rw-r--r-- | sql/SQLite/upgrade/2-3/001-auto.sql | 12 | ||||
-rw-r--r-- | sql/SQLite/upgrade/3-4/001-auto.sql | 12 |
8 files changed, 208 insertions, 0 deletions
diff --git a/sql/SQLite/deploy/3/001-auto-__VERSION.sql b/sql/SQLite/deploy/3/001-auto-__VERSION.sql new file mode 100644 index 0000000..6ff2cf3 --- /dev/null +++ b/sql/SQLite/deploy/3/001-auto-__VERSION.sql @@ -0,0 +1,18 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Sun Feb 13 17:36:37 2011 +-- + +; +BEGIN TRANSACTION; +-- +-- Table: dbix_class_deploymenthandler_versions +-- +CREATE TABLE dbix_class_deploymenthandler_versions ( + id INTEGER PRIMARY KEY NOT NULL, + version varchar(50) NOT NULL, + ddl text, + upgrade_sql text +); +CREATE UNIQUE INDEX dbix_class_deploymenthandler_versions_version ON dbix_class_deploymenthandler_versions (version); +COMMIT \ No newline at end of file diff --git a/sql/SQLite/deploy/3/001-auto.sql b/sql/SQLite/deploy/3/001-auto.sql new file mode 100644 index 0000000..58ac7ef --- /dev/null +++ b/sql/SQLite/deploy/3/001-auto.sql @@ -0,0 +1,44 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Sun Feb 13 17:36:37 2011 +-- + +; +BEGIN TRANSACTION; +-- +-- Table: project +-- +CREATE TABLE project ( + projectid INTEGER PRIMARY KEY NOT NULL, + name text NOT NULL, + url text NOT NULL, + description text NOT NULL, + owner text NOT NULL +); +CREATE UNIQUE INDEX project_name ON project (name); +-- +-- Table: commit_push +-- +CREATE TABLE commit_push ( + sha256 text NOT NULL, + content text NOT NULL, + projectid int NOT NULL, + timestamp datetime NOT NULL, + PRIMARY KEY (sha256) +); +CREATE INDEX commit_push_idx_projectid ON commit_push (projectid); +-- +-- 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', + started_when datetime +); +CREATE INDEX task_idx_sha256 ON task (sha256); +CREATE INDEX task_idx_projectid ON task (projectid); +CREATE UNIQUE INDEX task_projectid ON task (projectid); +CREATE UNIQUE INDEX task_sha256 ON task (sha256); +COMMIT \ No newline at end of file diff --git a/sql/SQLite/deploy/4/001-auto-__VERSION.sql b/sql/SQLite/deploy/4/001-auto-__VERSION.sql new file mode 100644 index 0000000..ae85c90 --- /dev/null +++ b/sql/SQLite/deploy/4/001-auto-__VERSION.sql @@ -0,0 +1,18 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Sun Feb 13 17:36:49 2011 +-- + +; +BEGIN TRANSACTION; +-- +-- Table: dbix_class_deploymenthandler_versions +-- +CREATE TABLE dbix_class_deploymenthandler_versions ( + id INTEGER PRIMARY KEY NOT NULL, + version varchar(50) NOT NULL, + ddl text, + upgrade_sql text +); +CREATE UNIQUE INDEX dbix_class_deploymenthandler_versions_version ON dbix_class_deploymenthandler_versions (version); +COMMIT \ No newline at end of file diff --git a/sql/SQLite/deploy/4/001-auto.sql b/sql/SQLite/deploy/4/001-auto.sql new file mode 100644 index 0000000..f318bb2 --- /dev/null +++ b/sql/SQLite/deploy/4/001-auto.sql @@ -0,0 +1,43 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Sun Feb 13 17:36:48 2011 +-- + +; +BEGIN TRANSACTION; +-- +-- Table: project +-- +CREATE TABLE project ( + projectid INTEGER PRIMARY KEY NOT NULL, + name text NOT NULL, + url text NOT NULL, + description text NOT NULL, + owner text NOT NULL +); +CREATE UNIQUE INDEX project_name ON project (name); +-- +-- Table: commit_push +-- +CREATE TABLE commit_push ( + sha256 text NOT NULL, + content text NOT NULL, + projectid int NOT NULL, + timestamp datetime NOT NULL, + PRIMARY KEY (sha256) +); +CREATE INDEX commit_push_idx_projectid ON commit_push (projectid); +-- +-- 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', + started_when datetime +); +CREATE INDEX task_idx_sha256 ON task (sha256); +CREATE INDEX task_idx_projectid ON task (projectid); +CREATE UNIQUE INDEX task_sha256 ON task (sha256); +COMMIT \ No newline at end of file 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; + diff --git a/sql/SQLite/upgrade/2-3/001-auto.sql b/sql/SQLite/upgrade/2-3/001-auto.sql new file mode 100644 index 0000000..f88b4de --- /dev/null +++ b/sql/SQLite/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/SQLite/upgrade/3-4/001-auto.sql b/sql/SQLite/upgrade/3-4/001-auto.sql new file mode 100644 index 0000000..afc3322 --- /dev/null +++ b/sql/SQLite/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; + +; +DROP INDEX task_projectid; + +; + +COMMIT; + |