From 2309ed42a44905214f96a7cbafed444fbf0f714f Mon Sep 17 00:00:00 2001
From: franck cuny <franck@lumberjaph.net>
Date: Sun, 13 Feb 2011 17:38:02 +0100
Subject: import schema modifications

---
 sql/SQLite/deploy/3/001-auto.sql | 44 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 44 insertions(+)
 create mode 100644 sql/SQLite/deploy/3/001-auto.sql

(limited to 'sql/SQLite/deploy/3/001-auto.sql')

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
-- 
cgit v1.2.3

