[Koha-cvs] koha/updater updatedatabase [dev_week]

[Kyle Hall]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         dev_week
Changes by:     Kyle Hall <kylemhall>   07/04/23 15:13:45

Modified files:
        updater        : updatedatabase 

Log message:
        Added tables for RotatingCollections.pm

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&only_with_tag=dev_week&r1=1.100.2.43.2.7&r2=1.100.2.43.2.8

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.100.2.43.2.7
retrieving revision 1.100.2.43.2.8
diff -u -b -r1.100.2.43.2.7 -r1.100.2.43.2.8
--- updatedatabase      13 Apr 2007 18:40:19 -0000      1.100.2.43.2.7
+++ updatedatabase      23 Apr 2007 15:13:45 -0000      1.100.2.43.2.8
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.100.2.43.2.7 2007/04/13 18:40:19 kylemhall Exp $
+# $Id: updatedatabase,v 1.100.2.43.2.8 2007/04/23 15:13:45 kylemhall Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -219,6 +219,21 @@
                                       branchcode varchar(4) default NULL 
COMMENT 'foreign key to branches',
                                       PRIMARY KEY  (caseId)
                                       )",
+
+      collections => "(
+                      colId int(11) NOT NULL auto_increment,
+                      colTitle varchar(100) NOT NULL ,
+                      colDesc text NOT NULL default '',
+                      colBranchcode varchar(4) default NULL COMMENT 
'branchcode for branch where item should be held.',
+                      PRIMARY KEY  (colId)
+                      )",
+      
+     collectionsTracking => "(
+                             ctId int(11) NOT NULL auto_increment,
+                             colId int(11) NOT NULL default '0' COMMENT 
'collections.colId',
+                             itemnumber int(11) NOT NULL default '0' COMMENT 
'items.itemnumber',
+                             PRIMARY KEY  (ctId)
+                             )",
 );
 
 my %requirefields = (
@@ -1697,6 +1712,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.100.2.43.2.8  2007/04/23 15:13:45  kylemhall
+# Added tables for RotatingCollections.pm
+#
 # Revision 1.100.2.43.2.7  2007/04/13 18:40:19  kylemhall
 # Adding 'Clubs & Services' Module to Koha, more to come!
 #