[Koha-cvs] koha/barcodes create_blank_labels_tables.sql [dev_week]

[Mason James]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         dev_week
Changes by:     Mason James <sushi>     07/01/18 04:33:53

Added files:
        barcodes       : create_blank_labels_tables.sql 

Log message:
        creates blank labels/barcodes tables.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/barcodes/create_blank_labels_tables.sql?cvsroot=koha&only_with_tag=dev_week&rev=1.1.2.1

Patches:
Index: create_blank_labels_tables.sql
===================================================================
RCS file: create_blank_labels_tables.sql
diff -N create_blank_labels_tables.sql
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ create_blank_labels_tables.sql      18 Jan 2007 04:33:53 -0000      1.1.2.1
@@ -0,0 +1,66 @@
+-- MySQL dump 9.11
+--
+-- Host: localhost    Database: hlt
+-- ------------------------------------------------------
+-- Server version      4.0.24_Debian-10sarge1-log
+
+--
+-- 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',
+  `subclass` tinyint(1) default '0',
+  `itemcallnumber` tinyint(1) default '0',
+  `author` tinyint(1) default '0',
+  `startlabel` int(2) default NULL,
+  `printingtype` char(10) default NULL,
+  `guidebox` tinyint(1) default NULL,
+  `fonttype` char(10) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table `labels_templates`
+--
+
+DROP TABLE IF EXISTS `labels_templates`;
+CREATE TABLE `labels_templates` (
+  `tmpl_id` int(4) NOT NULL auto_increment,
+  `tmpl_code` char(100) default '',
+  `tmpl_desc` char(100) default '',
+  `page_width` float default '0',
+  `page_height` float default '0',
+  `label_width` float default '0',
+  `label_height` float default '0',
+  `topmargin` float default '0',
+  `leftmargin` float default '0',
+  `cols` int(2) default '0',
+  `rows` int(2) default '0',
+  `colgap` float default '0',
+  `rowgap` float default '0',
+  `active` int(1) default NULL,
+  `units` char(20) default 'PX',
+  `fontsize` int(4) default NULL,
+  PRIMARY KEY  (`tmpl_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;