From 725e822aed8b6947e174fac648432f9d6a5d8207 Mon Sep 17 00:00:00 2001 From: Joshua Ferraro Date: Tue, 20 May 2008 09:36:26 -0500 Subject: [PATCH] DB Update .086: adding new table tmp_holdsqueue, used for reporting picklist for holds in multi-location libraries. This is a temporary workaround to a longer-term post-3.0 cleanup of the holds process. Following this will be a cron job for managing the holds picklist queue as well as a report for viewing the list of items from circulation --- installer/data/mysql/kohastructure.sql | 22 ++++++++++++++++++++++ installer/data/mysql/updatedatabase.pl | 23 +++++++++++++++++++++++ kohaversion.pl | 2 +- 3 files changed, 46 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c3d475c0f9..90f59ba278 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2096,6 +2096,28 @@ CREATE TABLE `user_permissions` ( ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `tmp_holdsqueue` +-- + +DROP TABLE IF EXISTS `tmp_holdsqueue`; +CREATE TABLE `tmp_holdsqueue` ( + `biblionumber` int(11) default NULL, + `itemnumber` int(11) default NULL, + `barcode` varchar(20) default NULL, + `surname` mediumtext NOT NULL, + `firstname` text, + `phone` text, + `borrowernumber` int(11) NOT NULL, + `cardnumber` varchar(16) default NULL, + `reservedate` date default NULL, + `title` mediumtext, + `itemcallnumber` varchar(30) default NULL, + `holdingbranch` varchar(10) default NULL, + `pickbranch` varchar(10) default NULL, + `notes` text +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index df03fe9318..5f1edb5e56 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -1576,6 +1576,29 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.086"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do( + "CREATE TABLE `tmp_holdsqueue` ( + `biblionumber` int(11) default NULL, + `itemnumber` int(11) default NULL, + `barcode` varchar(20) default NULL, + `surname` mediumtext NOT NULL, + `firstname` text, + `phone` text, + `borrowernumber` int(11) NOT NULL, + `cardnumber` varchar(16) default NULL, + `reservedate` date default NULL, + `title` mediumtext, + `itemcallnumber` varchar(30) default NULL, + `holdingbranch` varchar(10) default NULL, + `pickbranch` varchar(10) default NULL, + `notes` text + ) ENGINE=InnoDB DEFAULT CHARSET=utf8"); + print "Upgrade to $DBversion done (Table structure for table `tmp_holdsqueue`)\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index b3f03f2107..c284f4b080 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = "3.00.00.085"; + our $VERSION = "3.00.00.086"; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5