diff options
Diffstat (limited to 'sql/MySQL/deploy/3')
-rw-r--r-- | sql/MySQL/deploy/3/001-auto-__VERSION.sql | 18 | ||||
-rw-r--r-- | sql/MySQL/deploy/3/001-auto.sql | 48 |
2 files changed, 66 insertions, 0 deletions
diff --git a/sql/MySQL/deploy/3/001-auto-__VERSION.sql b/sql/MySQL/deploy/3/001-auto-__VERSION.sql new file mode 100644 index 0000000..53626e8 --- /dev/null +++ b/sql/MySQL/deploy/3/001-auto-__VERSION.sql @@ -0,0 +1,18 @@ +-- +-- Created by SQL::Translator::Producer::MySQL +-- Created on Sun Feb 13 17:36:37 2011 +-- +; +SET foreign_key_checks=0; +-- +-- Table: `dbix_class_deploymenthandler_versions` +-- +CREATE TABLE `dbix_class_deploymenthandler_versions` ( + `id` integer NOT NULL auto_increment, + `version` varchar(50) NOT NULL, + `ddl` text, + `upgrade_sql` text, + PRIMARY KEY (`id`), + UNIQUE `dbix_class_deploymenthandler_versions_version` (`version`) +); +SET foreign_key_checks=1 \ No newline at end of file diff --git a/sql/MySQL/deploy/3/001-auto.sql b/sql/MySQL/deploy/3/001-auto.sql new file mode 100644 index 0000000..fc5ab9e --- /dev/null +++ b/sql/MySQL/deploy/3/001-auto.sql @@ -0,0 +1,48 @@ +-- +-- Created by SQL::Translator::Producer::MySQL +-- Created on Sun Feb 13 17:36:37 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_projectid` (`projectid`), + 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 |