[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/07/13 02:59:30

Modified files:
        barcodes       : create_blank_labels_tables.sql 

Log message:
        updated with new table structure.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/barcodes/create_blank_labels_tables.sql?cvsroot=koha&only_with_tag=dev_week&r1=1.1.2.2&r2=1.1.2.3

Patches:
Index: create_blank_labels_tables.sql
===================================================================
RCS file: /sources/koha/koha/barcodes/Attic/create_blank_labels_tables.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -b -r1.1.2.2 -r1.1.2.3
--- create_blank_labels_tables.sql      8 Jul 2007 22:14:21 -0000       1.1.2.2
+++ create_blank_labels_tables.sql      13 Jul 2007 02:59:30 -0000      1.1.2.3
@@ -1,8 +1,32 @@
--- MySQL dump 9.11
+-- MySQL dump 10.11
 --
--- Host: localhost    Database: hlt
+-- Host: localhost    Database: yti
 -- ------------------------------------------------------
--- Server version      4.0.24_Debian-10sarge1-log
+-- Server version      5.0.32-Debian_7etch1-log
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, 
FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `labels`
+--
+
+DROP TABLE IF EXISTS `labels`;
+CREATE TABLE `labels` (
+  `labelid` int(11) NOT NULL auto_increment,
+  `batch_id` varchar(10) collate utf8_unicode_ci NOT NULL default '1',
+  `itemnumber` varchar(100) collate utf8_unicode_ci NOT NULL default '',
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  PRIMARY KEY  (`labelid`)
+) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Table structure for table `labels_conf`
@@ -11,7 +35,7 @@
 DROP TABLE IF EXISTS `labels_conf`;
 CREATE TABLE `labels_conf` (
   `id` int(4) NOT NULL auto_increment,
-  `barcodetype` char(100) default '',
+  `barcodetype` char(100) collate utf8_unicode_ci default '',
   `title` int(1) default '0',
   `itemtype` int(1) default '0',
   `barcode` int(1) default '0',
@@ -22,14 +46,14 @@
   `author` int(1) default '0',
   `issn` int(1) default '0',
   `isbn` int(1) default '0',
-  `startlabel` int(2) default NULL,
-  `printingtype` char(32) default NULL,
-  `guidebox` int(1) default NULL,
-  `active` tinyint(1) default NULL,
-  `fonttype` char(10) default NULL,
-    `layoutname` varchar(32) default NULL,
+  `startlabel` int(2) NOT NULL default '1',
+  `printingtype` char(32) collate utf8_unicode_ci default 'BAR',
+  `layoutname` char(20) collate utf8_unicode_ci NOT NULL default 'TEST',
+  `guidebox` int(1) default '0',
+  `active` tinyint(1) default '1',
+  `fonttype` char(10) collate utf8_unicode_ci default NULL,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 --
 -- Table structure for table `labels_templates`
@@ -38,8 +62,8 @@
 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 '',
+  `tmpl_code` char(100) collate utf8_unicode_ci default '',
+  `tmpl_desc` char(100) collate utf8_unicode_ci default '',
   `page_width` float default '0',
   `page_height` float default '0',
   `label_width` float default '0',
@@ -51,20 +75,18 @@
   `colgap` float default '0',
   `rowgap` float default '0',
   `active` int(1) default NULL,
-  `units` char(20) default 'PX',
-  `fontsize` int(4) default NULL,
+  `units` char(20) collate utf8_unicode_ci default 'PX',
+  `fontsize` int(4) NOT NULL default '3',
   PRIMARY KEY  (`tmpl_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40103 SET address@hidden */;
 
---
--- Table structure for table `labels`
---
+/*!40101 SET address@hidden */;
+/*!40014 SET address@hidden */;
+/*!40014 SET address@hidden */;
+/*!40101 SET address@hidden */;
+/*!40101 SET address@hidden */;
+/*!40101 SET address@hidden */;
+/*!40111 SET address@hidden */;
 
-DROP TABLE IF EXISTS `labels`;
-CREATE TABLE `labels` (
-  `labelid` int(11) NOT NULL auto_increment,
-  `batch_id` varchar(10),
-  `itemnumber` varchar(100) NOT NULL default '',
-  `timestamp` timestamp(14) NOT NULL,
-  PRIMARY KEY  (`labelid`)
-) TYPE=MyISAM;
+-- Dump completed on 2007-07-13  2:58:08