diff options
Diffstat (limited to '')
-rw-r--r-- | sql/PostgreSQL/deploy/3/001-auto-__VERSION.sql | 17 | ||||
-rw-r--r-- | sql/PostgreSQL/deploy/3/001-auto.sql | 65 | ||||
-rw-r--r-- | sql/PostgreSQL/deploy/4/001-auto-__VERSION.sql | 17 | ||||
-rw-r--r-- | sql/PostgreSQL/deploy/4/001-auto.sql | 64 | ||||
-rw-r--r-- | sql/PostgreSQL/downgrade/3-2/001-auto.sql | 12 | ||||
-rw-r--r-- | sql/PostgreSQL/downgrade/4-3/001-auto.sql | 12 | ||||
-rw-r--r-- | sql/PostgreSQL/upgrade/2-3/001-auto.sql | 12 | ||||
-rw-r--r-- | sql/PostgreSQL/upgrade/3-4/001-auto.sql | 12 |
8 files changed, 211 insertions, 0 deletions
diff --git a/sql/PostgreSQL/deploy/3/001-auto-__VERSION.sql b/sql/PostgreSQL/deploy/3/001-auto-__VERSION.sql new file mode 100644 index 0000000..50b572b --- /dev/null +++ b/sql/PostgreSQL/deploy/3/001-auto-__VERSION.sql @@ -0,0 +1,17 @@ +-- +-- Created by SQL::Translator::Producer::PostgreSQL +-- Created on Sun Feb 13 17:36:37 2011 +-- +; +-- +-- Table: dbix_class_deploymenthandler_versions +-- +CREATE TABLE "dbix_class_deploymenthandler_versions" ( + "id" serial NOT NULL, + "version" character varying(50) NOT NULL, + "ddl" text, + "upgrade_sql" text, + PRIMARY KEY ("id"), + CONSTRAINT "dbix_class_deploymenthandler_versions_version" UNIQUE ("version") +); + diff --git a/sql/PostgreSQL/deploy/3/001-auto.sql b/sql/PostgreSQL/deploy/3/001-auto.sql new file mode 100644 index 0000000..b9caaad --- /dev/null +++ b/sql/PostgreSQL/deploy/3/001-auto.sql @@ -0,0 +1,65 @@ +-- +-- Created by SQL::Translator::Producer::PostgreSQL +-- Created on Sun Feb 13 17:36:37 2011 +-- +; +-- +-- Table: project +-- +CREATE TABLE "project" ( + "projectid" serial NOT NULL, + "name" text NOT NULL, + "url" text NOT NULL, + "description" text NOT NULL, + "owner" text NOT NULL, + PRIMARY KEY ("projectid"), + CONSTRAINT "project_name" UNIQUE ("name") +); + +; +-- +-- Table: commit_push +-- +CREATE TABLE "commit_push" ( + "sha256" text NOT NULL, + "content" text NOT NULL, + "projectid" integer NOT NULL, + "timestamp" timestamp NOT NULL, + PRIMARY KEY ("sha256") +); +CREATE INDEX "commit_push_idx_projectid" on "commit_push" ("projectid"); + +; +-- +-- Table: task +-- +CREATE TABLE "task" ( + "taskid" serial NOT NULL, + "sha256" text NOT NULL, + "projectid" integer NOT NULL, + "running" bool DEFAULT '0' NOT NULL, + "started_when" timestamp, + PRIMARY KEY ("taskid"), + CONSTRAINT "task_projectid" UNIQUE ("projectid"), + CONSTRAINT "task_sha256" UNIQUE ("sha256") +); +CREATE INDEX "task_idx_sha256" on "task" ("sha256"); +CREATE INDEX "task_idx_projectid" on "task" ("projectid"); + +; +-- +-- Foreign Key Definitions +-- + +; +ALTER TABLE "commit_push" ADD FOREIGN KEY ("projectid") + REFERENCES "project" ("projectid") DEFERRABLE; + +; +ALTER TABLE "task" ADD FOREIGN KEY ("sha256") + REFERENCES "commit_push" ("sha256") DEFERRABLE; + +; +ALTER TABLE "task" ADD FOREIGN KEY ("projectid") + REFERENCES "project" ("projectid") DEFERRABLE; + diff --git a/sql/PostgreSQL/deploy/4/001-auto-__VERSION.sql b/sql/PostgreSQL/deploy/4/001-auto-__VERSION.sql new file mode 100644 index 0000000..1e06671 --- /dev/null +++ b/sql/PostgreSQL/deploy/4/001-auto-__VERSION.sql @@ -0,0 +1,17 @@ +-- +-- Created by SQL::Translator::Producer::PostgreSQL +-- Created on Sun Feb 13 17:36:49 2011 +-- +; +-- +-- Table: dbix_class_deploymenthandler_versions +-- +CREATE TABLE "dbix_class_deploymenthandler_versions" ( + "id" serial NOT NULL, + "version" character varying(50) NOT NULL, + "ddl" text, + "upgrade_sql" text, + PRIMARY KEY ("id"), + CONSTRAINT "dbix_class_deploymenthandler_versions_version" UNIQUE ("version") +); + diff --git a/sql/PostgreSQL/deploy/4/001-auto.sql b/sql/PostgreSQL/deploy/4/001-auto.sql new file mode 100644 index 0000000..486d9d2 --- /dev/null +++ b/sql/PostgreSQL/deploy/4/001-auto.sql @@ -0,0 +1,64 @@ +-- +-- Created by SQL::Translator::Producer::PostgreSQL +-- Created on Sun Feb 13 17:36:49 2011 +-- +; +-- +-- Table: project +-- +CREATE TABLE "project" ( + "projectid" serial NOT NULL, + "name" text NOT NULL, + "url" text NOT NULL, + "description" text NOT NULL, + "owner" text NOT NULL, + PRIMARY KEY ("projectid"), + CONSTRAINT "project_name" UNIQUE ("name") +); + +; +-- +-- Table: commit_push +-- +CREATE TABLE "commit_push" ( + "sha256" text NOT NULL, + "content" text NOT NULL, + "projectid" integer NOT NULL, + "timestamp" timestamp NOT NULL, + PRIMARY KEY ("sha256") +); +CREATE INDEX "commit_push_idx_projectid" on "commit_push" ("projectid"); + +; +-- +-- Table: task +-- +CREATE TABLE "task" ( + "taskid" serial NOT NULL, + "sha256" text NOT NULL, + "projectid" integer NOT NULL, + "running" bool DEFAULT '0' NOT NULL, + "started_when" timestamp, + PRIMARY KEY ("taskid"), + CONSTRAINT "task_sha256" UNIQUE ("sha256") +); +CREATE INDEX "task_idx_sha256" on "task" ("sha256"); +CREATE INDEX "task_idx_projectid" on "task" ("projectid"); + +; +-- +-- Foreign Key Definitions +-- + +; +ALTER TABLE "commit_push" ADD FOREIGN KEY ("projectid") + REFERENCES "project" ("projectid") DEFERRABLE; + +; +ALTER TABLE "task" ADD FOREIGN KEY ("sha256") + REFERENCES "commit_push" ("sha256") DEFERRABLE; + +; +ALTER TABLE "task" ADD FOREIGN KEY ("projectid") + REFERENCES "project" ("projectid") DEFERRABLE; + diff --git a/sql/PostgreSQL/downgrade/3-2/001-auto.sql b/sql/PostgreSQL/downgrade/3-2/001-auto.sql new file mode 100644 index 0000000..64b6ca2 --- /dev/null +++ b/sql/PostgreSQL/downgrade/3-2/001-auto.sql @@ -0,0 +1,12 @@ +-- Convert schema 'sql/_source/deploy/3/001-auto.yml' to 'sql/_source/deploy/2/001-auto.yml':; + +; +BEGIN; + +; +ALTER TABLE task DROP COLUMN started_when; + +; + +COMMIT; + diff --git a/sql/PostgreSQL/downgrade/4-3/001-auto.sql b/sql/PostgreSQL/downgrade/4-3/001-auto.sql new file mode 100644 index 0000000..e40aafe --- /dev/null +++ b/sql/PostgreSQL/downgrade/4-3/001-auto.sql @@ -0,0 +1,12 @@ +-- Convert schema 'sql/_source/deploy/4/001-auto.yml' to 'sql/_source/deploy/3/001-auto.yml':; + +; +BEGIN; + +; +ALTER TABLE task ADD CONSTRAINT "task_projectid" UNIQUE (projectid); + +; + +COMMIT; + diff --git a/sql/PostgreSQL/upgrade/2-3/001-auto.sql b/sql/PostgreSQL/upgrade/2-3/001-auto.sql new file mode 100644 index 0000000..bb1e5e7 --- /dev/null +++ b/sql/PostgreSQL/upgrade/2-3/001-auto.sql @@ -0,0 +1,12 @@ +-- Convert schema 'sql/_source/deploy/2/001-auto.yml' to 'sql/_source/deploy/3/001-auto.yml':; + +; +BEGIN; + +; +ALTER TABLE task ADD COLUMN started_when timestamp; + +; + +COMMIT; + diff --git a/sql/PostgreSQL/upgrade/3-4/001-auto.sql b/sql/PostgreSQL/upgrade/3-4/001-auto.sql new file mode 100644 index 0000000..8bfddf7 --- /dev/null +++ b/sql/PostgreSQL/upgrade/3-4/001-auto.sql @@ -0,0 +1,12 @@ +-- Convert schema 'sql/_source/deploy/3/001-auto.yml' to 'sql/_source/deploy/4/001-auto.yml':; + +; +BEGIN; + +; +ALTER TABLE task DROP CONSTRAINT task_projectid; + +; + +COMMIT; + |