X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=migrations%2F001-up-subversion.sql;fp=migrations%2F001-up-subversion.sql;h=01046a5ed2e456b1fae8f5afe8007c44bdfe9b21;hb=de4f9cef3e24c6d1436dae82c862b3c0eeda6940;hp=3a1903df529fabca6bb6cdede03908f1ca565e87;hpb=a48266f78b43aa1569c6353eecbe2f90cb0bbd46;p=plcapi.git

diff --git a/migrations/001-up-subversion.sql b/migrations/001-up-subversion.sql
index 3a1903d..01046a5 100644
--- 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;