@@ -, +, @@ --- 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(-) --- a/installer/data/mysql/de-DE/optional/sample_creator_data.sql +++ a/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 */; --- a/installer/data/mysql/en/optional/sample_creator_data.sql +++ a/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'), --- a/installer/data/mysql/es-ES/optional/sample_creator_data.sql +++ a/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 */; --- a/installer/data/mysql/fr-CA/facultatif/sample_creator_data.sql +++ a/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 */; --- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql +++ a/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 */; --