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>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
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 */;
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'),
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 */;
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 */;
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 */;