[Koha-cvs] koha/updater updatedatabase

[Mason James]

CVSROOT:	/sources/koha
Module name:	koha
Branch: 	
Changes by:	Mason James <sushi at savannah.gnu.org>	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