[Koha-cvs] koha/barcodes create_labels_conf_table.sql
Mason James
szrj1m at yahoo.com
Wed Jul 19 03:10:45 CEST 2006
CVSROOT: /sources/koha
Module name: koha
Changes by: Mason James <sushi> 06/07/19 01:10:45
Added files:
barcodes : create_labels_conf_table.sql
Log message:
sql used to create 'labels_conf' and 'labels' table
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/barcodes/create_labels_conf_table.sql?cvsroot=koha&rev=1.1
Patches:
Index: create_labels_conf_table.sql
===================================================================
RCS file: create_labels_conf_table.sql
diff -N create_labels_conf_table.sql
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ create_labels_conf_table.sql 19 Jul 2006 01:10:45 -0000 1.1
@@ -0,0 +1,44 @@
+-- MySQL dump 9.11
+--
+-- Host: localhost Database: opusdev
+-- ------------------------------------------------------
+-- Server version 4.0.24_Debian-10sarge1
+
+--
+-- Table structure for table `labels_conf`
+--
+
+DROP TABLE IF EXISTS `labels_conf`;
+CREATE TABLE `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,
+ `printingtype` char(10) default NULL,
+ `guidebox` tinyint(1) default NULL,
+ PRIMARY KEY (`id`)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table `labels`
+--
+
+DROP TABLE IF EXISTS `labels`;
+CREATE TABLE `labels` (
+ `labelid` int(11) NOT NULL auto_increment,
+ `itemnumber` varchar(100) NOT NULL default '',
+ `timestamp` timestamp(14) NOT NULL,
+ PRIMARY KEY (`labelid`)
+) TYPE=MyISAM;
+
+
+
+
+
More information about the Koha-cvs
mailing list