[Koha-patches] [PATCH] fixed SQL error in sample labels scripts

[Galen Charlton]

---
 installer/data/mysql/en/optional/sample_labels.sql |   12 +++++++++---
 .../data/mysql/fr-FR/2-Optionel/sample_labels.sql  |   10 ++++++++--
 2 files changed, 17 insertions(+), 5 deletions(-)

diff --git a/installer/data/mysql/en/optional/sample_labels.sql b/installer/data/mysql/en/optional/sample_labels.sql
index c4a9fea..28702f8 100644
--- a/installer/data/mysql/en/optional/sample_labels.sql
+++ b/installer/data/mysql/en/optional/sample_labels.sql
@@ -1,6 +1,9 @@
 -- Label Templates
 LOCK TABLES `labels_templates` WRITE;
-INSERT INTO `labels_templates` VALUES
+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'),
@@ -11,9 +14,12 @@ INSERT INTO `labels_templates` VALUES
 UNLOCK TABLES; 
 LOCK TABLES `labels_conf` WRITE;
 /*!40000 ALTER TABLE `labels_conf` DISABLE KEYS */;
-INSERT INTO `labels_conf` VALUES 
+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);
+(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 */;
 UNLOCK TABLES;
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 ad87f46..a2dac43 100644
--- a/installer/data/mysql/fr-FR/2-Optionel/sample_labels.sql
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_labels.sql
@@ -1,7 +1,10 @@
 -- Label Templates
 set NAMES 'utf8';
 LOCK TABLES `labels_templates` WRITE;
-INSERT INTO `labels_templates` VALUES
+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'),
@@ -11,7 +14,10 @@ INSERT INTO `labels_templates` VALUES
 UNLOCK TABLES; 
 LOCK TABLES `labels_conf` WRITE;
 /*!40000 ALTER TABLE `labels_conf` DISABLE KEYS */;
-INSERT INTO `labels_conf` VALUES 
+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 */;
-- 
1.5.5.rc0.16.g02b00