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;
+