Merge from trunk

[plcapi.git] / trunk / migrations / 001-up-subversion.sql

diff --git a/trunk/migrations/001-up-subversion.sql b/trunk/migrations/001-up-subversion.sql
new file mode 100644 (file)
index 0000000..01046a5
--- /dev/null
+++ b/trunk/migrations/001-up-subversion.sql
@@ -0,0 +1,5 @@
+-- Add plc_db_version.subversion field
+ALTER TABLE plc_db_version ADD subversion integer NOT NULL DEFAULT 0;
+
+-- Bump subversion
+UPDATE plc_db_version SET subversion = 1;