|
Lines 1-34
Link Here
|
| 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 |
INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT"> |
| 6 |
<images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63"> |
| 7 |
<data_source image_name="none" image_source="patronimages" /> |
| 8 |
</images> |
| 9 |
<text><firstname> <surname></text> |
| 10 |
<text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" /> |
| 11 |
<text>Branch: <branchcode></text> |
| 12 |
<text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" /> |
| 13 |
<text>Expires: August 31, 2010</text> |
| 14 |
<text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" /> |
| 15 |
</opt> |
| 16 |
','Patroncards'); |
| 17 |
UNLOCK TABLES; |
| 18 |
|
| 19 |
|
| 20 |
LOCK TABLES `creator_templates` WRITE; |
| 21 |
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'); |
| 22 |
UNLOCK TABLES; |
| 23 |
|
| 24 |
LOCK TABLES `printers_profile` WRITE; |
| 25 |
INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES |
| 26 |
( 1,'Library Laser', 1,'Bypass', -2,9,3,0,'POINT','Labels'), |
| 27 |
(13,'Library Laser', 7,'Tray 1', 0,0,0,0,'POINT','Labels'), |
| 28 |
(14,'Library Laser', 12,'Tray 2', 0,0,0,0,'POINT','Labels'), |
| 29 |
(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'), |
| 30 |
(22,'Library Laser', 0,'Tray 3', 0,0,0,0,'POINT','Labels'); |
| 31 |
UNLOCK TABLES; |
| 32 |
|
| 33 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
| 34 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |