Add files to installer/data/mysql/nb-NO/2-Valgfritt/
[koha.git] / installer / data / mysql / nb-NO / 2-Valgfritt / sample_creator_data.sql
1 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3
4 LOCK TABLES `creator_layouts` WRITE;
5 /*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
6 INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, callnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, callnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, callnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
7   <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
8     <data_source image_name="none" image_source="patronimages" />
9   </images>
10   <text>&lt;firstname&gt; &lt;surname&gt;</text>
11   <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
12   <text>Branch: &lt;branchcode&gt;</text>
13   <text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" />
14   <text>Expires: August 31, 2010</text>
15   <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
16 </opt>
17 ','Patroncards');
18 /*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */;
19 UNLOCK TABLES;
20
21
22 LOCK TABLES `creator_templates` WRITE;
23 /*!40000 ALTER TABLE `creator_templates` DISABLE KEYS */;
24 INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.63,1,0.139,0,0.35,0.23,3,10,0.13,0,'INCH','Labels'),(7,13,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for up to four lines of text',8.5,11,1.5,1,0.236,0,0.5,0.25,5,10,0.0625,0,'INCH','Labels'),(12,14,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for five lines of text',8.5,11,1.5,1,0.139,0,0.53,0.3,5,10,0.0625,0,'INCH','Labels'),(22,0,'DEFAULT TEMPLATE 01','Default description',0,5,0,0,0,0,0,0,0,0,0,0,'POINT','Labels'),(23,16,'HB-PC0001','A template for home brewed patron card forms',8.5,11,3.1875,1.9375,0,0,0.6875,0.875,2,4,0.4375,0.1875,'INCH','Patroncards');
25 /*!40000 ALTER TABLE `creator_templates` ENABLE KEYS */;
26 UNLOCK TABLES;
27
28 LOCK TABLES `printers_profile` WRITE;
29 /*!40000 ALTER TABLE `printers_profile` DISABLE KEYS */;
30 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');
31 /*!40000 ALTER TABLE `printers_profile` ENABLE KEYS */;
32 UNLOCK TABLES;
33 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
34 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;