From 801b9767db6e5afbb634374faa3c82743061bc30 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Mon, 2 Nov 2009 16:37:53 +0100 Subject: [PATCH] 3.01.038 was missed and replaced by other code --- installer/data/mysql/updatedatabase.pl | 20 ++++++++++++++++++++ kohaversion.pl | 2 +- 2 files changed, 21 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index ccd20ef9f5..7055fabc0f 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -3083,6 +3083,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $DBversion = "3.01.00.118"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do(" +??? d'ici jusqu'à ???FIN des lignes ont pu être insérées/effacées INSERT INTO `permissions` (`module_bit`, `code`, `description`) VALUES (16, 'execute_reports', 'Execute SQL reports'), (16, 'create_reports', 'Create SQL Reports') @@ -3127,6 +3128,24 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +=item + + Deal with branches + +=cut + +my $DBversion = "3.01.00.0122"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + # update branches table + # + $dbh->do("ALTER TABLE branches ADD `branchzip` varchar(25) default NULL AFTER `branchaddress3`"); + $dbh->do("ALTER TABLE branches ADD `branchcity` mediumtext AFTER `branchzip`"); + $dbh->do("ALTER TABLE branches ADD `branchcountry` text AFTER `branchcity`"); + $dbh->do("ALTER TABLE branches ADD `branchurl` mediumtext AFTER `branchemail`"); + $dbh->do("ALTER TABLE branches ADD `branchnotes` mediumtext AFTER `branchprinter`"); + print "Upgrade to $DBversion done (branches)\n"; + SetVersion ($DBversion); +} =item DropAllForeignKeys($table) @@ -3134,6 +3153,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { =cut + sub DropAllForeignKeys { my ($table) = @_; # get the table description diff --git a/kohaversion.pl b/kohaversion.pl index 1f4ee8bd0d..a9ec93abf2 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.01.00.121'; + our $VERSION = '3.01.00.122'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5