Lines 1-31
Link Here
|
1 |
truncate labels_templates; |
1 |
truncate creator_templates; |
2 |
truncate labels_conf; |
2 |
truncate creator_layouts; |
3 |
|
3 |
|
4 |
-- Label Templates |
4 |
-- Label Templates |
5 |
LOCK TABLES `labels_templates` WRITE; |
5 |
LOCK TABLES `creator_templates` WRITE; |
6 |
INSERT INTO `labels_templates` |
6 |
INSERT INTO `creator_templates` (template_id,template_code,template_desc,page_width,page_height,label_width,label_height,top_margin,left_margin,cols,rows,col_gap,row_gap, |
7 |
(tmpl_id,tmpl_code,tmpl_desc,page_width,page_height,label_width,label_height,topmargin,leftmargin,cols,`rows`,colgap,rowgap, |
7 |
units) |
8 |
active,units,fontsize,font) |
|
|
9 |
VALUES |
8 |
VALUES |
10 |
(1,'Avery 5160 | 1 x 2-5/8','3 стовпчики, 10 рядів наклейок',8.5,11,2.625,1,0.5,0.1875,3,10,0.125,0,1,'INCH',7,'TR'), |
9 |
(1,'Avery 5160 | 1 x 2-5/8','3 стовпчики, 10 рядів наклейок',8.5,11,2.625,1,0.5,0.1875,3,10,0.125,0,'INCH'), |
11 |
(2,'Gaylord 8511 бічна наклейка','Друк лише лівого стовпчика Gaylord 8511.',8.5,11,1,1.25,0.6,0.5,1,8,0,0,NULL,'INCH',10,'TR'), |
10 |
(2,'Gaylord 8511 боковая наклейка','ПДрук лише лівого стовпчика Gaylord 8511',8.5,11,1,1.25,0.6,0.5,1,8,0,0,'INCH'), |
12 |
(3,'Avery 5460 вертикальна','',3.625,5.625,1.5,0.75,0.38,0.35,2,7,0.25,0,NULL,'INCH',8,'TR'), |
11 |
(3,'Avery 5460 вертикальна','',3.625,5.625,1.5,0.75,0.38,0.35,2,7,0.25,0,'INCH'), |
13 |
(4,'Avery 5460 бічні наклейки','',5.625,3.625,0.75,1.5,0.35,0.31,7,2,0,0.25,NULL,'INCH',8,'TR'), |
12 |
(4,'Avery 5460 бічні наклейки','',5.625,3.625,0.75,1.5,0.35,0.31,7,2,0,0.25,'INCH'), |
14 |
(5,'Avery 8163','2 ряди x 5 рядів',8.5,11,4,2,0.5,0.17,2,5,0.2,0.01,NULL,'INCH',11,'TR'), |
13 |
(5,'Avery 8163','2 ряди x 5 рядів',8.5,11,4,2,0.5,0.17,2,5,0.2,0.01,'INCH'), |
15 |
(6,'cards','Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\" [3x10] : еквівалент: Gaylord JD-ML3000',8.5,11,2.75,1.05,0.25,0,3,10,0.2,0.01,NULL,'INCH',8,'TR'), |
14 |
(6,'cards','Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\" [3x10] : еквівалент: Gaylord JD-ML3000',8.5,11,2.75,1.05,0.25,0,3,10,0.2,0.01,'INCH'), |
16 |
(7,'HB-PC0001','Шаблон для карток відвідувачів домашнього виготовлення',8.5,11,3.125,1.875,0.375,0.5625,2,5,1.125,0.1875,NULL,'INCH',16,'TR'); |
15 |
(7,'HB-PC0001','Шаблон для карток відвідувачів домашнього виготовлення',8.5,11,3.125,1.875,0.375,0.5625,2,5,1.125,0.1875,'INCH'); |
17 |
|
16 |
|
18 |
UNLOCK TABLES; |
17 |
UNLOCK TABLES; |
19 |
|
18 |
|
20 |
LOCK TABLES `labels_conf` WRITE; |
19 |
LOCK TABLES `creator_layouts` WRITE; |
21 |
/*!40000 ALTER TABLE `labels_conf` DISABLE KEYS */; |
20 |
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */; |
22 |
INSERT INTO `labels_conf` |
21 |
INSERT INTO `creator_layouts` VALUES |
23 |
(id,barcodetype,title,subtitle,itemtype,barcode,dewey,classification,subclass,itemcallnumber,author,issn,isbn,startlabel, |
22 |
(1,'CODE39',1,'BIBBAR','бібліо-запис та штрих-код',0,1,'TR',7,'POINT',0,'L','title, author, itemcallnumber', '<opt></opt>', 'Labels'), |
24 |
printingtype,formatstring,layoutname,guidebox,active,fonttype,ccode,callnum_split) |
23 |
(2,'CODE39',1,'BAR','змінний',0,1,'TR',3,'POINT',0,'L','','','Labels'); |
25 |
VALUES |
24 |
/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */; |
26 |
(5,'CODE39',2,0,3,0,0,0,0,4,1,0,0,1,'BIBBAR','бібліо-запис та штрих-код',1,1,NULL,NULL,NULL,NULL), |
|
|
27 |
(6,'CODE39',2,0,0,0,0,3,4,0,1,0,3,1,'BAR','змінний',1,1,NULL,NULL,NULL,NULL), |
28 |
(7,'CODE39',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,1,'PATCRD','Картки ідентифікації відвідувачів',1,NULL,NULL,NULL,NULL,NULL); |
29 |
/*!40000 ALTER TABLE `labels_conf` ENABLE KEYS */; |
30 |
|
25 |
|
31 |
UNLOCK TABLES; |
26 |
UNLOCK TABLES; |
32 |
- |
|
|