git://git.onelab.eu
/
plcapi.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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;