[Koha-patches] [PATCH 13/78] changing kohaversion
paul.poulain at biblibre.com
paul.poulain at biblibre.com
Thu May 28 18:32:23 CEST 2009
From: Paul Poulain <paul.poulain at biblibre.com>
---
installer/data/mysql/updatedatabase.pl | 40 ++++++++++++++++----------------
kohaversion.pl | 2 +-
2 files changed, 21 insertions(+), 21 deletions(-)
diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index a58567f..11a6584 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -2455,7 +2455,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do("ALTER TABLE `borrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1;");
print "Upgrade to $DBversion done (add new syspref and column in borrowers)\n";
-$DBversion = '3.01.00.020';
+$DBversion = '3.01.00.036';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do(<<'END_SQL');
CREATE TABLE IF NOT EXISTS `aqcontract` (
@@ -2474,7 +2474,7 @@ END_SQL
SetVersion ($DBversion);
}
-$DBversion = '3.01.00.021';
+$DBversion = '3.01.00.037';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do("ALTER TABLE `aqbasket` ADD COLUMN `basketname` varchar(50) default NULL AFTER `basketno`");
$dbh->do("ALTER TABLE `aqbasket` ADD COLUMN `note` mediumtext AFTER `basketname`");
@@ -2485,7 +2485,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = '3.01.00.022';
+$DBversion = '3.01.00.038';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do("ALTER TABLE `aqorders` ADD COLUMN `uncertainprice` tinyint(1)");
@@ -2493,7 +2493,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = '3.01.00.023';
+$DBversion = '3.01.00.039';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do("CREATE TABLE IF NOT EXISTS `aqbasketgroups` (
`id` int(11) NOT NULL auto_increment,
@@ -2511,7 +2511,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = '3.01.00.024';
+$DBversion = '3.01.00.040';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do("DROP TABLE IF EXISTS `aqbudgetperiods` ");
$dbh->do(qq|
@@ -2584,7 +2584,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = '3.01.00.025';
+$DBversion = '3.01.00.041';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
# removes 'aqbudgets' NOT NULL
@@ -2600,7 +2600,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = '3.01.00.026';
+$DBversion = '3.01.00.042';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
# removes 'aqbudgets' NOT NULL
@@ -2613,7 +2613,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
}
-$DBversion = '3.01.00.027';
+$DBversion = '3.01.00.043';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
# removes 'aqbudgets' NOT NULL
@@ -2624,7 +2624,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = '3.01.00.028';
+$DBversion = '3.01.00.044';
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
$dbh->do("ALTER TABLE aqbudgetperiods ADD COLUMN budget_period_total decimal(28,6)");
print "Upgrade to $DBversion done (adds 'budget_period_total' column to aqbudgetperiods table)\n";
@@ -2632,7 +2632,7 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
}
-$DBversion = '3.01.00.029';
+$DBversion = '3.01.00.045';
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
$dbh->do("ALTER TABLE currency ADD COLUMN active tinyint(1)");
@@ -2640,7 +2640,7 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
SetVersion($DBversion);
}
-$DBversion = '3.01.00.030';
+$DBversion = '3.01.00.046';
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
$dbh->do("INSERT INTO permissions (module_bit, code, description) VALUES
(11, 'vendors_manage', 'Manage vendors'),
@@ -2658,7 +2658,7 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
SetVersion($DBversion);
}
-$DBversion = '3.01.00.031';
+$DBversion = '3.01.00.047';
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
$dbh->do("ALTER TABLE aqbudgets CHANGE COLUMN budget_owner_id budget_owner_id int(11)");
@@ -2667,7 +2667,7 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
}
-$DBversion = '3.01.00.032';
+$DBversion = '3.01.00.048';
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
$dbh->do(qq| INSERT INTO permissions (module_bit, code, description) VALUES
(11, 'budget_add_del', "Add and delete budgets (but can't modify budgets) )") |);
@@ -2676,14 +2676,14 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
SetVersion($DBversion);
}
-$DBversion = '3.01.00.033';
+$DBversion = '3.01.00.049';
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
$dbh->do("ALTER TABLE aqbooksellers ADD COLUMN `gstrate` decimal(5,2) default NULL");
print "Upgrade to $DBversion done (added per-supplier gstrate setting)\n";
SetVersion($DBversion);
}
-$DBversion = "3.01.00.034";
+$DBversion = "3.01.00.050";
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
if (C4::Context->preference("opaclanguages") eq "fr") {
$dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AcqCreateItem','ordering','Définit quand l'exemplaire est créé : à la commande, à la livraison, au catalogage','ordering|receiving|cataloguing','Choice')");
@@ -2694,7 +2694,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = "3.01.00.035";
+$DBversion = "3.01.00.051";
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do(qq|
CREATE TABLE `aqorders_items` (
@@ -2711,7 +2711,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = "3.01.00.036";
+$DBversion = "3.01.00.052";
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
my $query = "SELECT * FROM `aqbooksellers`";
my $sth = $dbh->prepare($query);
@@ -2729,7 +2729,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = "3.01.00.037";
+$DBversion = "3.01.00.053";
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do( qq# INSERT INTO `systempreferences` VALUES ('CurrencyFormat','US','US|FR','Determines the display format of currencies. eg: ''36000'' is displayed as ''360 000,00'' in ''FR'' or 360,000.00'' in ''US''.','Choice') #);
@@ -2737,7 +2737,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = "3.01.00.038";
+$DBversion = "3.01.00.054";
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do("ALTER table aqorders drop column title");
@@ -2745,7 +2745,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
-$DBversion = "3.01.00.039";
+$DBversion = "3.01.00.055";
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do("ALTER TABLE `aqorders` CHANGE `budget_id` `budget_id` INT( 11 ) NOT NULL");
print "Upgrade to $DBversion done update budget_id size that should not be a tinyint\n";
diff --git a/kohaversion.pl b/kohaversion.pl
index 6d838d3..f10abb3 100644
--- a/kohaversion.pl
+++ b/kohaversion.pl
@@ -10,7 +10,7 @@
use strict;
sub kohaversion {
- our $VERSION = '3.01.00.034';
+ our $VERSION = '3.01.00.055';
# version needs to be set this way
# so that it can be picked up by Makefile.PL
# during install
--
1.6.0.4
More information about the Koha-patches
mailing list