[37/40] Updating sample labels data

This update takes care of the EN and FR data only. Sorry.

diff --git a/installer/data/mysql/en/optional/sample_labels.sql b/installer/data/mysql/en/optional/sample_labels.sql
index 28702f8..c0fdd13 100644 (file)
--- a/installer/data/mysql/en/optional/sample_labels.sql
+++ b/installer/data/mysql/en/optional/sample_labels.sql
@@ -1,25 +1,21 @@
 -- Label Templates
 LOCK TABLES `labels_templates` WRITE;
-INSERT INTO `labels_templates`
-(tmpl_id,tmpl_code,tmpl_desc,page_width,page_height,label_width,label_height,topmargin,leftmargin,cols,`rows`,colgap,rowgap,
-active,units,fontsize,font)
-VALUES
-(1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.625,1,0.5,0.1875,3,10,0.125,0,1,'INCH',7,'TR'),
-(2,'Gaylord 8511 Spine Label','Prints only the left-hand column of a Gaylord 8511.',8.5,11,1,1.25,0.6,0.5,1,8,0,0,NULL,'INCH',10,'TR'),
-(3,'Avery 5460 vertical','',3.625,5.625,1.5,0.75,0.38,0.35,2,7,0.25,0,NULL,'INCH',8,'TR'),
-(4,'Avery 5460 spine labels','',5.625,3.625,0.75,1.5,0.35,0.31,7,2,0,0.25,NULL,'INCH',8,'TR'),
-(5,'Avery 8163','2rows x 5 rows',8.5,11,4,2,0.5,0.17,2,5,0.2,0.01,NULL,'INCH',11,'TR'),
-(6,'cards','Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\"  [3x10] : equivalent: Gaylord JD-ML3000',8.5,11,2.75,1.05,0.25,0,3,10,0.2,0.01,NULL,'INCH',8,'TR'),
-(7,'HB-PC0001','A template for home brewed patron card forms',8.5,11,3.125,1.875,0.375,0.5625,2,5,1.125,0.1875,NULL,'INCH',16,'TR');
-UNLOCK TABLES; 
-LOCK TABLES `labels_conf` WRITE;
-/*!40000 ALTER TABLE `labels_conf` DISABLE KEYS */;
-INSERT INTO `labels_conf` 
-(id,barcodetype,title,subtitle,itemtype,barcode,dewey,classification,subclass,itemcallnumber,author,issn,isbn,startlabel,
-printingtype,formatstring,layoutname,guidebox,active,fonttype,ccode,callnum_split)
-VALUES 
-(5,'CODE39',2,0,3,0,0,0,0,4,1,0,0,1,'BIBBAR','biblio and barcode',1,1,NULL,NULL,NULL,NULL),
-(6,'CODE39',2,0,0,0,0,3,4,0,1,0,3,1,'BAR','alternating',1,1,NULL,NULL,NULL,NULL),
-(7,'CODE39',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,1,'PATCRD','Patron ID Cards',1,NULL,NULL,NULL,NULL,NULL);
-/*!40000 ALTER TABLE `labels_conf` ENABLE KEYS */;
+/*!40000 ALTER TABLE `labels_templates` DISABLE KEYS */;
+INSERT INTO `labels_templates` VALUES
+(1,0,'Avery 5160 | 1 x 2-5/8',  '3 columns, 10 rows of labels',                                                 8.5,    11,     2.63,   1,      0.139,  0,      0.35,   0.23,   3,      10,     0.13,   0,      'INCH'),
+(2,0,'Gaylord 8511 Spine Label','Prints only the left-hand column of a Gaylord 8511.',                          8.5,    11,     1,      1.25,   0.6,    0.5,    0,      0,      1,      8,      0,      0,      'INCH'),
+(3,0,'Avery 5460 vertical',     '',                                                                             3.625,  5.625,  1.5,    0.75,   0.38,   0.35,   2,      7,      2,      1,      0.25,   0,      'INCH'),
+(4,0,'Avery 5460 spine labels', '',                                                                             5.625,  3.625,  0.75,   1.5,    0.35,   0.31,   7,      2,      1,      0,      0.25,   0,      'INCH'),
+(5,0,'Avery 8163',              '2rows x 5 rows',                                                               8.5,    11,     4,      2,      0,      0,      0.5,    0.17,   2,      5,      0.2,    0.01,   'INCH'),
+(6,0,'cards',                   'Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\"  [3x10] : equivalent: Gaylord JD-ML3000', 8.5,    11,     2.75,   1.05,   0,      0,      0.25,   0,      3,      10,     0.2,    0.01,   'INCH'),
+(7,0,'Demco WS14942260',        '1\" X 1.5\" Spine Label',                                                      8.5,    11,     1.5,    1,      0.236,  0,      0.4,    0.25,   5,      10,     0.0625, 0,      'INCH');
+/*!40000 ALTER TABLE `labels_templates` ENABLE KEYS */;
+UNLOCK TABLES;
+LOCK TABLES `labels_layouts` WRITE;
+/*!40000 ALTER TABLE `labels_layouts` DISABLE KEYS */;
+INSERT INTO `labels_layouts` VALUES
+(1,'CODE39','BIBBAR',   'biblio and barcode',   0,      'TR',7,0,'L','title, author, itemcallnumber'),
+(2,'CODE39','BIB',      'spine',                0,      'TR',3,1,'L','itemcallnumber'),
+(3,'CODE39','BARBIB',   'barcode and biblio',   0,      'TR',3,1,'L','title, author, itemcallnumber');
+/*!40000 ALTER TABLE `labels_layouts` ENABLE KEYS */;
 UNLOCK TABLES;

diff --git a/installer/data/mysql/en/optional/sample_labels.txt b/installer/data/mysql/en/optional/sample_labels.txt
index 685c938..2018fc6 100644 (file)
--- a/installer/data/mysql/en/optional/sample_labels.txt
+++ b/installer/data/mysql/en/optional/sample_labels.txt
@@ -5,4 +5,5 @@ Gaylord 8511 Spine Label
 Avery 5460 - vertical
 Avery 5460 - spine labels
 Avery 8163 - 2rows x 5 rows
-cards Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\"  [3x10] : equivalent: Gaylord JD-ML3000
+cards Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8"  [3x10] : equivalent: Gaylord JD-ML3000
+Demco WS14942260 | 1" X 1.5" Spine Label

diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_labels.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_labels.sql
index a2dac43..80b3645 100644 (file)
--- a/installer/data/mysql/fr-FR/2-Optionel/sample_labels.sql
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_labels.sql
@@ -1,24 +1,20 @@
 -- Label Templates
 set NAMES 'utf8';
 LOCK TABLES `labels_templates` WRITE;
-INSERT INTO `labels_templates`
-(tmpl_id,tmpl_code,tmpl_desc,page_width,page_height,label_width,label_height,topmargin,leftmargin,cols,`rows`,colgap,rowgap,
-active,units,fontsize,font)
-VALUES
-(1,'Avery 5160 | 1 x 2-5/8','3 colonnes, 10 lignes d''étiquette',8.5,11,2.625,1,0.5,0.1875,3,10,0.125,0,1,'INCH',7,'TR'),
-(2,'Gaylord 8511 Spine Label','Imprime uniquement dans la colnne de gauche d''une planche Gaylord 8511.',8.5,11,1,1.25,0.6,0.5,1,8,0,0,NULL,'INCH',10,'TR'),
-(3,'Avery 5460 vertical','',3.625,5.625,1.5,0.75,0.38,0.35,2,7,0.25,0,NULL,'INCH',8,'TR'),
-(4,'Avery 5460 Etiquettes de cote','',5.625,3.625,0.75,1.5,0.35,0.31,7,2,0,0.25,NULL,'INCH',8,'TR'),
-(5,'Avery 8163','2colonnes x 5 colonnes',8.5,11,4,2,0.5,0.17,2,5,0.2,0.01,NULL,'INCH',11,'TR'),
-(6,'cards','Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\"  [3x10] : equivalent: Gaylord JD-ML3000',8.5,11,2.75,1.05,0.25,0,3,10,0.2,0.01,NULL,'INCH',8,'TR');
+INSERT INTO `labels_templates` VALUES
+(1,0,'Avery 5160 | 1 x 2-5/8',  '3 colonnes, 10 lignes d''étiquette',                                           8.5,    11,     2.63,   1,      0.139,  0,      0.35,   0.23,   3,      10,     0.13,   0,      'INCH'),
+(2,0,'Gaylord 8511 Spine Label','Imprime uniquement dans la colnne de gauche d''une planche Gaylord 8511.',     8.5,    11,     1,      1.25,   0.6,    0.5,    0,      0,      1,      8,      0,      0,      'INCH'),
+(3,0,'Avery 5460 vertical',     '',                                                                             3.625,  5.625,  1.5,    0.75,   0.38,   0.35,   2,      7,      2,      1,      0.25,   0,      'INCH'),
+(4,0,'Avery 5460 spine labels', '',                                                                             5.625,  3.625,  0.75,   1.5,    0.35,   0.31,   7,      2,      1,      0,      0.25,   0,      'INCH'),
+(5,0,'Avery 8163',              '2colonnes x 5 colonnes',                                                       8.5,    11,     4,      2,      0,      0,      0.5,    0.17,   2,      5,      0.2,    0.01,   'INCH'),
+(6,0,'cards',                   'Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\"  [3x10] : equivalent: Gaylord JD-ML3000', 8.5,    11,     2.75,   1.05,   0,      0,      0.25,   0,      3,      10,     0.2,    0.01,   'INCH'),
+(7,0,'Demco WS14942260',        '1\" X 1.5\" Etiquettes de cotes',                                              8.5,    11,     1.5,    1,      0.236,  0,      0.4,    0.25,   5,      10,     0.0625, 0,      'INCH');
 UNLOCK TABLES; 
-LOCK TABLES `labels_conf` WRITE;
-/*!40000 ALTER TABLE `labels_conf` DISABLE KEYS */;
-INSERT INTO `labels_conf`
-(id,barcodetype,title,subtitle,itemtype,barcode,dewey,classification,subclass,itemcallnumber,author,issn,isbn,startlabel,
-printingtype,formatstring,layoutname,guidebox,active,fonttype,ccode,callnum_split)
-VALUES 
-(5,'CODE39',2,0,3,0,0,0,0,4,1,0,0,1,'BIBBAR','biblio and barcode',1,1,NULL,NULL,NULL,NULL),
-(6,'CODE39',2,0,0,0,0,3,4,0,1,0,3,1,'BAR','alternating',1,1,NULL,NULL,NULL,NULL);
-/*!40000 ALTER TABLE `labels_conf` ENABLE KEYS */;
+LOCK TABLES `labels_layouts` WRITE;
+/*!40000 ALTER TABLE `labels_layouts` DISABLE KEYS */;
+INSERT INTO `labels_layouts` VALUES
+(1,'CODE39','BIBBAR','biblio and barcode',0,'TR',7,0,'L','title, author, itemcallnumber'),
+(2,'CODE39','BIB','spine',0,'TR',3,1,'L','itemcallnumber'),
+(3,'CODE39','BARBIB','barcode and biblio',0,'TR',3,1,'L','title, author, itemcallnumber');
+/*!40000 ALTER TABLE `labels_layouts` ENABLE KEYS */;
 UNLOCK TABLES;

diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_labels.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_labels.txt
index a532480..022869e 100644 (file)
--- a/installer/data/mysql/fr-FR/2-Optionel/sample_labels.txt
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_labels.txt
@@ -4,4 +4,5 @@ Gaylord 8511 Spine Label
 Avery 5460 - vertical
 Avery 5460 - spine labels
 Avery 8163 - 2rows x 5 rows
-cards Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\"  [3x10] : equivalent: Gaylord JD-ML3000
+cards Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8"  [3x10] : equivalent: Gaylord JD-ML3000
+Demco WS14942260 | 1" X 1.5" Etiquettes de cotes