diff options
author | franck cuny <franck@lumberjaph.net> | 2011-02-13 14:15:23 +0100 |
---|---|---|
committer | franck cuny <franck@lumberjaph.net> | 2011-02-13 14:15:23 +0100 |
commit | 412587ddac4ba483d06bef9a8a89c07b4d3cf44b (patch) | |
tree | 3b58b44657d4e3c2817228a7984f2436e90f1244 /sql/MySQL | |
parent | Merge branch 'refactor_builder' (diff) | |
parent | update templates to show informations about running tasks (diff) | |
download | jitterbug-412587ddac4ba483d06bef9a8a89c07b4d3cf44b.tar.gz |
resolve merge conflict
Diffstat (limited to 'sql/MySQL')
-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 | ||||
-rw-r--r-- | sql/MySQL/downgrade/2-1/001-auto.sql | 12 | ||||
-rw-r--r-- | sql/MySQL/upgrade/1-2/001-auto.sql | 12 |
6 files changed, 153 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 diff --git a/sql/MySQL/downgrade/2-1/001-auto.sql b/sql/MySQL/downgrade/2-1/001-auto.sql new file mode 100644 index 0000000..3285916 --- /dev/null +++ b/sql/MySQL/downgrade/2-1/001-auto.sql @@ -0,0 +1,12 @@ +-- Convert schema 'sql/_source/deploy/2/001-auto.yml' to 'sql/_source/deploy/1/001-auto.yml':; + +; +BEGIN; + +; +ALTER TABLE task DROP COLUMN running; + +; + +COMMIT; + diff --git a/sql/MySQL/upgrade/1-2/001-auto.sql b/sql/MySQL/upgrade/1-2/001-auto.sql new file mode 100644 index 0000000..1183d23 --- /dev/null +++ b/sql/MySQL/upgrade/1-2/001-auto.sql @@ -0,0 +1,12 @@ +-- Convert schema 'sql/_source/deploy/1/001-auto.yml' to 'sql/_source/deploy/2/001-auto.yml':; + +; +BEGIN; + +; +ALTER TABLE task ADD COLUMN running bool NOT NULL DEFAULT '0'; + +; + +COMMIT; + |