From c19a085b158fc60cd51de702943c742aa7953084 Mon Sep 17 00:00:00 2001 From: Mason James Date: Fri, 9 Nov 2007 16:58:41 -0600 Subject: [PATCH] changing biblioitems.itemtype to varchar(10) Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- updater/updatedatabase | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/updater/updatedatabase b/updater/updatedatabase index 6a636593dc..cae90eef0a 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -568,6 +568,14 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.024"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("ALTER TABLE biblioitems CHANGE itemtype itemtype VARCHAR(10)"); + print "Upgrade to $DBversion done (changing itemtype to (10))\n"; + SetVersion ($DBversion); +} + + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table -- 2.39.5