From 9d88ff4580cec1ff8a419318d9d74291498c85d1 Mon Sep 17 00:00:00 2001
From: sushi <sushi>
Date: Wed, 19 Jul 2006 01:10:45 +0000
Subject: [PATCH] sql used to create 'labels_conf' and 'labels' table

---
 barcodes/create_labels_conf_table.sql | 44 +++++++++++++++++++++++++++
 1 file changed, 44 insertions(+)
 create mode 100644 barcodes/create_labels_conf_table.sql

diff --git a/barcodes/create_labels_conf_table.sql b/barcodes/create_labels_conf_table.sql
new file mode 100644
index 0000000000..6fec07a3d7
--- /dev/null
+++ b/barcodes/create_labels_conf_table.sql
@@ -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;
+
+
+
+
+
-- 
2.39.2