From 8e06f00c08cdc4077e20e4acf97dcd069bb10c90 Mon Sep 17 00:00:00 2001
From: Mark Tompsett <mtompset@hotmail.com>
Date: Mon, 23 Oct 2017 14:00:53 +0000
Subject: [PATCH] Bug 10222: Correct and expand to other languages

This added column names, and reformated to be a bit more readable.
This also adds this change to de-DE, es-ES, fr-CA, and nb-NO.
While there was printer_profiles for it-IT, the Italian file seems
to not use the same numbers, and does not visibly look like it needs
these changes.

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
---
 installer/data/mysql/de-DE/optional/sample_creator_data.sql    |  7 ++++++-
 installer/data/mysql/en/optional/sample_creator_data.sql       |  2 +-
 installer/data/mysql/es-ES/optional/sample_creator_data.sql    |  7 ++++++-
 installer/data/mysql/fr-CA/facultatif/sample_creator_data.sql  | 10 ++++++----
 installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql |  7 ++++++-
 5 files changed, 25 insertions(+), 8 deletions(-)

diff --git a/installer/data/mysql/de-DE/optional/sample_creator_data.sql b/installer/data/mysql/de-DE/optional/sample_creator_data.sql
index 66ff21a..5dcd1b9 100644
--- a/installer/data/mysql/de-DE/optional/sample_creator_data.sql
+++ b/installer/data/mysql/de-DE/optional/sample_creator_data.sql
@@ -22,7 +22,12 @@ INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 Spalten,
 UNLOCK TABLES;
 
 LOCK TABLES `printers_profile` WRITE;
-INSERT INTO `printers_profile` VALUES (1,'Laserdrucker Bibliothek',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Laserdrucker Bibliothek',1,'Fach 1',0,0,0,0,'POINT','Labels'),(16,'Testdrucker 01',23,'Testfach',0,0,0,0,'POINT','Patroncards');
+INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES
+( 1,'Laserdrucker Bibliothek',  1,'Bypass', -2,9,3,0,'POINT','Labels'),
+(13,'Laserdrucker Bibliothek',  7,'Fach 1',  0,0,0,0,'POINT','Labels'),
+(14,'Laserdrucker Bibliothek', 12,'Fach 2',  0,0,0,0,'POINT','Labels'),
+(16,'Testdrucker 01',          23,'Testfach',0,0,0,0,'POINT','Patroncards'),
+(22,'Laserdrucker Bibliothek',  0,'Fach 3',  0,0,0,0,'POINT','Labels');
 UNLOCK TABLES;
 
 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
diff --git a/installer/data/mysql/en/optional/sample_creator_data.sql b/installer/data/mysql/en/optional/sample_creator_data.sql
index 1078006..2601946 100644
--- a/installer/data/mysql/en/optional/sample_creator_data.sql
+++ b/installer/data/mysql/en/optional/sample_creator_data.sql
@@ -22,7 +22,7 @@ INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns,
 UNLOCK TABLES;
 
 LOCK TABLES `printers_profile` WRITE;
-INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creek_horz, creep_vert, units, creator ) VALUES
+INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES
 ( 1,'Library Laser',   1,'Bypass', -2,9,3,0,'POINT','Labels'),
 (13,'Library Laser',   7,'Tray 1',  0,0,0,0,'POINT','Labels'),
 (14,'Library Laser',  12,'Tray 2',  0,0,0,0,'POINT','Labels'),
diff --git a/installer/data/mysql/es-ES/optional/sample_creator_data.sql b/installer/data/mysql/es-ES/optional/sample_creator_data.sql
index d519044..ed447b6 100644
--- a/installer/data/mysql/es-ES/optional/sample_creator_data.sql
+++ b/installer/data/mysql/es-ES/optional/sample_creator_data.sql
@@ -21,7 +21,12 @@ INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns,
 UNLOCK TABLES;
 
 LOCK TABLES `printers_profile` WRITE;
-INSERT INTO `printers_profile` VALUES (1,'Library Laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Library Laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards');
+INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES
+( 1,'Library Laser',   1,'Bypass', -2,9,3,0,'POINT','Labels'),
+(13,'Library Laser',   7,'Tray 1',  0,0,0,0,'POINT','Labels'),
+(14,'Library Laser',  12,'Tray 2',  0,0,0,0,'POINT','Labels'),
+(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'),
+(22,'Library Laser',   0,'Tray 3',  0,0,0,0,'POINT','Labels');
 UNLOCK TABLES;
 
 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
diff --git a/installer/data/mysql/fr-CA/facultatif/sample_creator_data.sql b/installer/data/mysql/fr-CA/facultatif/sample_creator_data.sql
index f41bea1..b07c082 100644
--- a/installer/data/mysql/fr-CA/facultatif/sample_creator_data.sql
+++ b/installer/data/mysql/fr-CA/facultatif/sample_creator_data.sql
@@ -34,10 +34,12 @@ UNLOCK TABLES;
 
 LOCK TABLES `printers_profile` WRITE;
 /*!40000 ALTER TABLE `printers_profile` DISABLE KEYS */;
-INSERT INTO `printers_profile` VALUES
-(1,'Imprimante laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),
-(11,'Imprimante laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),
-(16,'Imprimante de test 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards');
+INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES
+( 1,'Imprimante laser',      1,'Bypass', -2,9,3,0,'POINT','Labels'),
+(13,'Imprimante laser',      7,'Tray 1',  0,0,0,0,'POINT','Labels'),
+(14,'Imprimante laser',     12,'Tray 2',  0,0,0,0,'POINT','Labels'),
+(16,'Imprimante de test 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'),
+(22,'Imprimante laser',      0,'Tray 3',  0,0,0,0,'POINT','Labels');
 /*!40000 ALTER TABLE `printers_profile` ENABLE KEYS */;
 UNLOCK TABLES;
 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql
index d519044..ed447b6 100644
--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql
+++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql
@@ -21,7 +21,12 @@ INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns,
 UNLOCK TABLES;
 
 LOCK TABLES `printers_profile` WRITE;
-INSERT INTO `printers_profile` VALUES (1,'Library Laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Library Laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards');
+INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES
+( 1,'Library Laser',   1,'Bypass', -2,9,3,0,'POINT','Labels'),
+(13,'Library Laser',   7,'Tray 1',  0,0,0,0,'POINT','Labels'),
+(14,'Library Laser',  12,'Tray 2',  0,0,0,0,'POINT','Labels'),
+(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'),
+(22,'Library Laser',   0,'Tray 3',  0,0,0,0,'POINT','Labels');
 UNLOCK TABLES;
 
 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-- 
2.1.4