From 8e06f00c08cdc4077e20e4acf97dcd069bb10c90 Mon Sep 17 00:00:00 2001 From: Mark Tompsett 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 Signed-off-by: Katrin Fischer Signed-off-by: Nick Clemens --- 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