From bc31005f0d04964239023a663e0c025dddf1e8b6 Mon Sep 17 00:00:00 2001 From: Chris Nighswonger Date: Tue, 22 Jul 2008 13:43:31 -0500 Subject: [PATCH] Adding lastmodified.virtualshelves; Bumping version to 100 Signed-off-by: Galen Charlton Signed-off-by: Joshua Ferraro --- installer/data/mysql/kohastructure.sql | 1 + installer/data/mysql/updatedatabase.pl | 6 ++++++ kohaversion.pl | 2 +- 3 files changed, 8 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index dcc8dc0c6c..c9813051f0 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2008,6 +2008,7 @@ CREATE TABLE `virtualshelves` ( `owner` varchar(80) default NULL, `category` varchar(1) default NULL, `sortfield` varchar(16) default NULL, + `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`shelfnumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 9e9b569d85..f233d0469b 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -1864,6 +1864,12 @@ if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion = '3.00.00.100'; +if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) { + $dbh->do('ALTER TABLE virtualshelves ADD COLUMN lastmodified timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'); + print "Upgrade to $DBversion done (Adding lastmodified column to virtualshelves)\n"; + SetVersion($DBversion); +} =item DropAllForeignKeys($table) diff --git a/kohaversion.pl b/kohaversion.pl index ca4785b11d..943962f3d1 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.00.00.099'; + our $VERSION = '3.00.00.100'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.2