diff options
Diffstat (limited to '')
-rw-r--r-- | sql/SQLite/deploy/3/001-auto.sql | 44 |
1 files changed, 44 insertions, 0 deletions
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 |