[Koha-cvs] koha/updater updatedatabase

[Mason James]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         
Changes by:     Mason James <address@hidden>    06/04/17 21:55:33

Modified files:
        updater        : updatedatabase 

Log message:
        Added 'labels' and 'labels_conf' tables, for spine lable tool.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/koha/updater/updatedatabase.diff?tr1=1.135&tr2=1.136&r1=text&r2=text

Patches:
Index: koha/updater/updatedatabase
diff -u koha/updater/updatedatabase:1.135 koha/updater/updatedatabase:1.136
--- koha/updater/updatedatabase:1.135   Sat Apr 15 02:37:03 2006
+++ koha/updater/updatedatabase Mon Apr 17 21:55:33 2006
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.135 2006/04/15 02:37:03 tgarip1957 Exp $
+# $Id: updatedatabase,v 1.136 2006/04/17 21:55:33 sushi Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -144,6 +144,29 @@
                                                `road_type` char(100) NOT NULL,
                                                PRIMARY KEY (`roadtypeid`)
                                        )",
+
+       labels                     => "(
+                               labelid int(11) NOT NULL auto_increment,
+                               itemnumber varchar(100) NOT NULL default '',
+                               timestamp timestamp(14) NOT NULL,
+                               PRIMARY KEY  (labelid),
+                               )",
+
+       labels_conf                => "(
+                               id int(4) NOT NULL auto_increment,
+                               barcodetype char(100) default '',
+                               title tinyint(1) default '0',
+                               isbn tinyint(1) default '0',
+                               itemtype tinyint(1) default '0',
+                               barcode tinyint(1) default '0',
+                               dewey tinyint(1) default '0',
+                               class tinyint(1) default '0',
+                               author tinyint(1) default '0',
+                               papertype char(100) default '',
+                               startrow int(2) default NULL,
+                               PRIMARY KEY  (id),
+                               )",
+
 );
 
 my %requirefields = (
@@ -1505,6 +1528,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.136  2006/04/17 21:55:33  sushi
+# Added 'labels' and 'labels_conf' tables, for spine lable tool.
+#
 # Revision 1.135  2006/04/15 02:37:03  tgarip1957
 # Marc record should be set to UTF-8 in leader.Force it.
 # XML should be with<record> wrappers