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

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;
+