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/MySQL/deploy/4/001-auto.sql | |
parent | don't ignore sql files (diff) | |
download | jitterbug-2309ed42a44905214f96a7cbafed444fbf0f714f.tar.gz |
import schema modifications
Diffstat (limited to '')
-rw-r--r-- | sql/MySQL/deploy/4/001-auto.sql | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/sql/MySQL/deploy/4/001-auto.sql b/sql/MySQL/deploy/4/001-auto.sql new file mode 100644 index 0000000..b856c45 --- /dev/null +++ b/sql/MySQL/deploy/4/001-auto.sql @@ -0,0 +1,47 @@ +-- +-- Created by SQL::Translator::Producer::MySQL +-- Created on Sun Feb 13 17:36:49 2011 +-- +; +SET foreign_key_checks=0; +-- +-- Table: `project` +-- +CREATE TABLE `project` ( + `projectid` integer NOT NULL auto_increment, + `name` text NOT NULL, + `url` text NOT NULL, + `description` text NOT NULL, + `owner` text NOT NULL, + PRIMARY KEY (`projectid`), + UNIQUE `project_name` (`name`) +) ENGINE=InnoDB; +-- +-- Table: `commit_push` +-- +CREATE TABLE `commit_push` ( + `sha256` text NOT NULL, + `content` text NOT NULL, + `projectid` integer NOT NULL, + `timestamp` datetime NOT NULL, + INDEX `commit_push_idx_projectid` (`projectid`), + PRIMARY KEY (`sha256`), + CONSTRAINT `commit_push_fk_projectid` FOREIGN KEY (`projectid`) REFERENCES `project` (`projectid`) +) ENGINE=InnoDB; +-- +-- Table: `task` +-- +CREATE TABLE `task` ( + `taskid` integer NOT NULL auto_increment, + `sha256` text NOT NULL, + `projectid` integer NOT NULL, + `running` bool NOT NULL DEFAULT '0', + `started_when` datetime, + INDEX `task_idx_sha256` (`sha256`), + INDEX `task_idx_projectid` (`projectid`), + PRIMARY KEY (`taskid`), + UNIQUE `task_sha256` (`sha256`), + CONSTRAINT `task_fk_sha256` FOREIGN KEY (`sha256`) REFERENCES `commit_push` (`sha256`), + CONSTRAINT `task_fk_projectid` FOREIGN KEY (`projectid`) REFERENCES `project` (`projectid`) +) ENGINE=InnoDB; +SET foreign_key_checks=1 \ No newline at end of file |