From de4f9cef3e24c6d1436dae82c862b3c0eeda6940 Mon Sep 17 00:00:00 2001 From: Mark Huang Date: Wed, 31 Jan 2007 19:55:27 +0000 Subject: [PATCH] set subversion --- migrations/001-up-subversion.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/migrations/001-up-subversion.sql b/migrations/001-up-subversion.sql index 3a1903df..01046a5e 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; -- 2.47.0