set subversion

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

diff --git a/migrations/001-up-subversion.sql b/migrations/001-up-subversion.sql
index 3a1903d..01046a5 100644 (file)
--- a/migrations/001-up-subversion.sql
+++ b/migrations/001-up-subversion.sql
@@ -1,4 +1,5 @@
--- this is mostly sample code
--- since subversion is also created by the migration code in plc.d/db
+-- Add plc_db_version.subversion field
+ALTER TABLE plc_db_version ADD subversion integer NOT NULL DEFAULT 0;
 
-ALTER TABLE plc_db_version ADD subversion integer DEFAULT 0;
+-- Bump subversion
+UPDATE plc_db_version SET subversion = 1;