From 05b0bad473ecae43e73290807acefe92181b423d Mon Sep 17 00:00:00 2001 From: Ryan Higgins Date: Fri, 17 Aug 2007 18:47:25 -0500 Subject: [PATCH] adding labels_templates table Signed-off-by: Joshua Ferraro Signed-off-by: Chris Cormack --- installer/kohastructure.sql | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index d7e06f8cf1..7717c083f0 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -941,6 +941,32 @@ CREATE TABLE `labels_conf` ( PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- 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`) + ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + -- -- Table structure for table `letter` -- -- 2.39.5