[Koha-cvs] koha/barcodes create_labels_conf_table.sql

[Mason James]

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;
+
+
+
+
+