diff options
author | franck cuny <franck@lumberjaph.net> | 2011-01-24 21:32:25 +0100 |
---|---|---|
committer | franck cuny <franck@lumberjaph.net> | 2011-01-24 21:32:25 +0100 |
commit | 0e615cf95a4fe198eed9ce125804767d1f38d80f (patch) | |
tree | 76b999d3a2f25ec6c76e24a2f05aa42ac01ded60 /sql/MySQL/deploy | |
parent | don't ignore .sql files (diff) | |
download | jitterbug-0e615cf95a4fe198eed9ce125804767d1f38d80f.tar.gz |
add sql schema for various version
Diffstat (limited to 'sql/MySQL/deploy')
-rw-r--r-- | sql/MySQL/deploy/1/001-auto-__VERSION.sql | 18 | ||||
-rw-r--r-- | sql/MySQL/deploy/1/001-auto.sql | 46 | ||||
-rw-r--r-- | sql/MySQL/deploy/2/001-auto-__VERSION.sql | 18 | ||||
-rw-r--r-- | sql/MySQL/deploy/2/001-auto.sql | 47 |
4 files changed, 129 insertions, 0 deletions
diff --git a/sql/MySQL/deploy/1/001-auto-__VERSION.sql b/sql/MySQL/deploy/1/001-auto-__VERSION.sql new file mode 100644 index 0000000..597d180 --- /dev/null +++ b/sql/MySQL/deploy/1/001-auto-__VERSION.sql @@ -0,0 +1,18 @@ +-- +-- Created by SQL::Translator::Producer::MySQL +-- Created on Mon Jan 24 21:25:06 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/1/001-auto.sql b/sql/MySQL/deploy/1/001-auto.sql new file mode 100644 index 0000000..2a8b829 --- /dev/null +++ b/sql/MySQL/deploy/1/001-auto.sql @@ -0,0 +1,46 @@ +-- +-- Created by SQL::Translator::Producer::MySQL +-- Created on Mon Jan 24 21:25:06 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, + 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 diff --git a/sql/MySQL/deploy/2/001-auto-__VERSION.sql b/sql/MySQL/deploy/2/001-auto-__VERSION.sql new file mode 100644 index 0000000..e91854a --- /dev/null +++ b/sql/MySQL/deploy/2/001-auto-__VERSION.sql @@ -0,0 +1,18 @@ +-- +-- Created by SQL::Translator::Producer::MySQL +-- Created on Mon Jan 24 21:26:42 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/2/001-auto.sql b/sql/MySQL/deploy/2/001-auto.sql new file mode 100644 index 0000000..d208773 --- /dev/null +++ b/sql/MySQL/deploy/2/001-auto.sql @@ -0,0 +1,47 @@ +-- +-- Created by SQL::Translator::Producer::MySQL +-- Created on Mon Jan 24 21:26:41 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', + 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 |