a micro-framework for handling migrations

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

diff --git a/migrations/001-up-subversion.sql b/migrations/001-up-subversion.sql
new file mode 100644 (file)
index 0000000..3a1903d
--- /dev/null
+++ b/migrations/001-up-subversion.sql
@@ -0,0 +1,4 @@
+-- this is mostly sample code
+-- since subversion is also created by the migration code in plc.d/db
+
+ALTER TABLE plc_db_version ADD subversion integer DEFAULT 0;