about summary refs log tree commit diff
path: root/sql/PostgreSQL/upgrade
diff options
context:
space:
mode:
authorfranck cuny <franck@lumberjaph.net>2011-01-24 21:32:25 +0100
committerfranck cuny <franck@lumberjaph.net>2011-01-24 21:32:25 +0100
commit0e615cf95a4fe198eed9ce125804767d1f38d80f (patch)
tree76b999d3a2f25ec6c76e24a2f05aa42ac01ded60 /sql/PostgreSQL/upgrade
parentdon't ignore .sql files (diff)
downloadjitterbug-0e615cf95a4fe198eed9ce125804767d1f38d80f.tar.gz
add sql schema for various version
Diffstat (limited to 'sql/PostgreSQL/upgrade')
-rw-r--r--sql/PostgreSQL/upgrade/1-2/001-auto.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/PostgreSQL/upgrade/1-2/001-auto.sql b/sql/PostgreSQL/upgrade/1-2/001-auto.sql
new file mode 100644
index 0000000..3edf5df
--- /dev/null
+++ b/sql/PostgreSQL/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 DEFAULT '0' NOT NULL;
+
+;
+
+COMMIT;
+