3 -- Host: localhost Database: opusdev
4 -- ------------------------------------------------------
5 -- Server version 4.0.24_Debian-10sarge1
8 -- Table structure for table `labels_conf`
11 DROP TABLE IF EXISTS `labels_conf`;
12 CREATE TABLE `labels_conf` (
13 `id` int(4) NOT NULL auto_increment,
14 `barcodetype` char(100) default '',
15 `title` tinyint(1) default '0',
16 `isbn` tinyint(1) default '0',
17 `itemtype` tinyint(1) default '0',
18 `barcode` tinyint(1) default '0',
19 `dewey` tinyint(1) default '0',
20 `class` tinyint(1) default '0',
21 `author` tinyint(1) default '0',
22 `papertype` char(100) default '',
23 `startrow` int(2) default NULL,
24 `printingtype` char(10) default NULL,
25 `guidebox` tinyint(1) default NULL,
30 -- Table structure for table `labels`
33 DROP TABLE IF EXISTS `labels`;
34 CREATE TABLE `labels` (
35 `labelid` int(11) NOT NULL auto_increment,
36 `itemnumber` varchar(100) NOT NULL default '',
37 `timestamp` timestamp(14) NOT NULL,
38 PRIMARY KEY (`labelid`)