diff options
author | franck cuny <franck@lumberjaph.net> | 2011-02-13 16:20:59 +0100 |
---|---|---|
committer | franck cuny <franck@lumberjaph.net> | 2011-02-13 16:20:59 +0100 |
commit | e81938b20ae19d472a6f835f8af01a428b8724de (patch) | |
tree | d6cea5e811f60fcd8f3c94ee1d9b4cf247404531 /sql/SQLite/downgrade/2-1 | |
parent | Make jitterbug::Test use the current perl interp (diff) | |
parent | Merge branch 'feature/stack_builds' into devel (diff) | |
download | jitterbug-e81938b20ae19d472a6f835f8af01a428b8724de.tar.gz |
Merge branch 'devel'
* devel: add more tests inside the hook, we check if we can add more than one task for this project add configuration option to skip some branches; add tests for the Hook that's why we want datetime use DateTime update templates to show informations about running tasks column started_when: datetime when the build started prepare to update schema again display current build if any add sql schema for various version don't ignore .sql files script to migrate/upgrade dbix schema add version to our schema update templates and css we want a find, not a search here add pending status to the schema (TODO: need a script to migrate the schema) load tasks and display them on the dashboard
Diffstat (limited to '')
-rw-r--r-- | sql/SQLite/downgrade/2-1/001-auto.sql | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/sql/SQLite/downgrade/2-1/001-auto.sql b/sql/SQLite/downgrade/2-1/001-auto.sql new file mode 100644 index 0000000..763b77b --- /dev/null +++ b/sql/SQLite/downgrade/2-1/001-auto.sql @@ -0,0 +1,47 @@ +-- Convert schema 'sql/_source/deploy/2/001-auto.yml' to 'sql/_source/deploy/1/001-auto.yml':; + +; +BEGIN; + +; +CREATE TEMPORARY TABLE task_temp_alter ( + taskid INTEGER PRIMARY KEY NOT NULL, + sha256 text NOT NULL, + projectid int NOT NULL +); + +; +INSERT INTO task_temp_alter SELECT taskid, sha256, projectid FROM task; + +; +DROP TABLE task; + +; +CREATE TABLE task ( + taskid INTEGER PRIMARY KEY NOT NULL, + sha256 text NOT NULL, + projectid int NOT NULL +); + +; +CREATE INDEX task_idx_sha25602 ON task (sha256); + +; +CREATE INDEX task_idx_projectid02 ON task (projectid); + +; +CREATE UNIQUE INDEX task_projectid02 ON task (projectid); + +; +CREATE UNIQUE INDEX task_sha25602 ON task (sha256); + +; +INSERT INTO task SELECT taskid, sha256, projectid FROM task_temp_alter; + +; +DROP TABLE task_temp_alter; + +; + +COMMIT; + |