From 0e615cf95a4fe198eed9ce125804767d1f38d80f Mon Sep 17 00:00:00 2001 From: franck cuny Date: Mon, 24 Jan 2011 21:32:25 +0100 Subject: add sql schema for various version --- sql/SQLite/deploy/1/001-auto-__VERSION.sql | 18 +++++++++++++ sql/SQLite/deploy/1/001-auto.sql | 42 +++++++++++++++++++++++++++++ sql/SQLite/deploy/2/001-auto-__VERSION.sql | 18 +++++++++++++ sql/SQLite/deploy/2/001-auto.sql | 43 ++++++++++++++++++++++++++++++ 4 files changed, 121 insertions(+) create mode 100644 sql/SQLite/deploy/1/001-auto-__VERSION.sql create mode 100644 sql/SQLite/deploy/1/001-auto.sql create mode 100644 sql/SQLite/deploy/2/001-auto-__VERSION.sql create mode 100644 sql/SQLite/deploy/2/001-auto.sql (limited to 'sql/SQLite/deploy') diff --git a/sql/SQLite/deploy/1/001-auto-__VERSION.sql b/sql/SQLite/deploy/1/001-auto-__VERSION.sql new file mode 100644 index 0000000..6d6e3fa --- /dev/null +++ b/sql/SQLite/deploy/1/001-auto-__VERSION.sql @@ -0,0 +1,18 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Mon Jan 24 21:25:06 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/1/001-auto.sql b/sql/SQLite/deploy/1/001-auto.sql new file mode 100644 index 0000000..804958b --- /dev/null +++ b/sql/SQLite/deploy/1/001-auto.sql @@ -0,0 +1,42 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Mon Jan 24 21:25:06 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 +); +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/2/001-auto-__VERSION.sql b/sql/SQLite/deploy/2/001-auto-__VERSION.sql new file mode 100644 index 0000000..8b1bc1f --- /dev/null +++ b/sql/SQLite/deploy/2/001-auto-__VERSION.sql @@ -0,0 +1,18 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Mon Jan 24 21:26:41 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/2/001-auto.sql b/sql/SQLite/deploy/2/001-auto.sql new file mode 100644 index 0000000..45ac741 --- /dev/null +++ b/sql/SQLite/deploy/2/001-auto.sql @@ -0,0 +1,43 @@ +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Mon Jan 24 21:26:41 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' +); +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 -- cgit 1.4.1