View | Details | Raw Unified | Return to bug 15053
Collapse All | Expand All

(-)a/installer/data/mysql/fr-FR/2-Optionel/sample_labels.sql (-16 / +16 lines)
Lines 1-20 Link Here
1
-- Label Templates
1
-- Label Templates
2
set NAMES 'utf8';
2
set NAMES 'utf8';
3
LOCK TABLES `labels_templates` WRITE;
3
LOCK TABLES `creator_templates` WRITE;
4
INSERT INTO `labels_templates` VALUES
4
INSERT INTO `creator_templates` VALUES
5
(1,0,'Avery 5160 | 1 x 2-5/8',  '3 colonnes, 10 lignes d''étiquette',                                           8.5,    11,     2.63,   1,      0.139,  0,      0.35,   0.23,   3,      10,     0.13,   0,      'INCH'),
5
(1,0,'Avery 5160 | 1 x 2-5/8',  '3 colonnes, 10 lignes d''étiquette',                                           8.5,    11,     2.63,   1,      0.139,  0,      0.35,   0.23,   3,      10,     0.13,   0,      'INCH', 'Labels'),
6
(2,0,'Gaylord 8511 Spine Label','Imprime uniquement dans la colnne de gauche d''une planche Gaylord 8511.',     8.5,    11,     1,      1.25,   0.6,    0.5,    0,      0,      1,      8,      0,      0,      'INCH'),
6
(2,0,'Gaylord 8511 Spine Label','Imprime uniquement dans la colnne de gauche d''une planche Gaylord 8511.',     8.5,    11,     1,      1.25,   0.6,    0.5,    0,      0,      1,      8,      0,      0,      'INCH', 'Labels'),
7
(3,0,'Avery 5460 vertical',     '',                                                                             3.625,  5.625,  1.5,    0.75,   0.38,   0.35,   2,      7,      2,      1,      0.25,   0,      'INCH'),
7
(3,0,'Avery 5460 vertical',     '',                                                                             3.625,  5.625,  1.5,    0.75,   0.38,   0.35,   2,      7,      2,      1,      0.25,   0,      'INCH', 'Labels'),
8
(4,0,'Avery 5460 spine labels', '',                                                                             5.625,  3.625,  0.75,   1.5,    0.35,   0.31,   7,      2,      1,      0,      0.25,   0,      'INCH'),
8
(4,0,'Avery 5460 spine labels', '',                                                                             5.625,  3.625,  0.75,   1.5,    0.35,   0.31,   7,      2,      1,      0,      0.25,   0,      'INCH', 'Labels'),
9
(5,0,'Avery 8163',              '2colonnes x 5 colonnes',                                                       8.5,    11,     4,      2,      0,      0,      0.5,    0.17,   2,      5,      0.2,    0.01,   'INCH'),
9
(5,0,'Avery 8163',              '2colonnes x 5 colonnes',                                                       8.5,    11,     4,      2,      0,      0,      0.5,    0.17,   2,      5,      0.2,    0.01,   'INCH', 'Labels'),
10
(6,0,'cards',                   'Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\"  [3x10] : equivalent: Gaylord JD-ML3000', 8.5,    11,     2.75,   1.05,   0,      0,      0.25,   0,      3,      10,     0.2,    0.01,   'INCH'),
10
(6,0,'cards',                   'Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\"  [3x10] : equivalent: Gaylord JD-ML3000', 8.5,    11,     2.75,   1.05,   0,      0,      0.25,   0,      3,      10,     0.2,    0.01,   'INCH', 'Labels'),
11
(7,0,'Demco WS14942260',        '1\" X 1.5\" Etiquettes de cotes',                                              8.5,    11,     1.5,    1,      0.236,  0,      0.4,    0.25,   5,      10,     0.0625, 0,      'INCH');
11
(7,0,'Demco WS14942260',        '1\" X 1.5\" Etiquettes de cotes',                                              8.5,    11,     1.5,    1,      0.236,  0,      0.4,    0.25,   5,      10,     0.0625, 0,      'INCH', 'Labels');
12
UNLOCK TABLES; 
12
UNLOCK TABLES; 
13
LOCK TABLES `labels_layouts` WRITE;
13
LOCK TABLES `creator_layouts` WRITE;
14
/*!40000 ALTER TABLE `labels_layouts` DISABLE KEYS */;
14
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
15
INSERT INTO `labels_layouts` VALUES
15
INSERT INTO `creator_layouts` VALUES
16
(1,'CODE39','BIBBAR','biblio and barcode',0,'TR',7,0,'L','title, author, itemcallnumber'),
16
(1,'CODE39',1,'BIBBAR','biblio and barcode',0,1,'TR',7,'POINT',0,'L','title, author, itemcallnumber', '<opt></opt>', 'Labels'),
17
(2,'CODE39','BIB','spine',0,'TR',3,1,'L','itemcallnumber'),
17
(2,'CODE39',1,'BIB','spine',0,1,'TR',3,'POINT',1,'L','itemcallnumber', '<opt></opt>', 'Labels'),
18
(3,'CODE39','BARBIB','barcode and biblio',0,'TR',3,1,'L','title, author, itemcallnumber');
18
(3,'CODE39',1,'BARBIB','barcode and biblio',0,1,'TR',3,'POINT',1,'L','title, author, itemcallnumber', '<opt></opt>', 'Labels');
19
/*!40000 ALTER TABLE `labels_layouts` ENABLE KEYS */;
19
/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */;
20
UNLOCK TABLES;
20
UNLOCK TABLES;
(-)a/installer/data/mysql/ru-RU/optional/print_labels.sql (-21 / +17 lines)
Lines 1-28 Link Here
1
-- Label Templates
1
-- Label Templates
2
LOCK TABLES `labels_templates` WRITE;
2
LOCK TABLES `creator_templates` WRITE;
3
INSERT INTO `labels_templates`
3
INSERT INTO `creator_templates`
4
(tmpl_id,tmpl_code,tmpl_desc,page_width,page_height,label_width,label_height,topmargin,leftmargin,cols,`rows`,colgap,rowgap,
4
(template_id,template_code,template_desc,page_width,page_height,label_width,label_height,top_margin,left_margin,cols,rows,col_gap,row_gap,
5
active,units,fontsize,font)
5
units)
6
VALUES
6
VALUES
7
(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'),
7
(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'),
8
(2,'Gaylord 8511 боковая наклейка','Печать только левой колонки Gaylord 8511.',8.5,11,1,1.25,0.6,0.5,1,8,0,0,NULL,'INCH',10,'TR'),
8
(2,'Gaylord 8511 боковая наклейка','Печать только левой колонки Gaylord 8511.',8.5,11,1,1.25,0.6,0.5,1,8,0,0,'INCH'),
9
(3,'Avery 5460 вертикальная','',3.625,5.625,1.5,0.75,0.38,0.35,2,7,0.25,0,NULL,'INCH',8,'TR'),
9
(3,'Avery 5460 вертикальная','',3.625,5.625,1.5,0.75,0.38,0.35,2,7,0.25,0,'INCH'),
10
(4,'Avery 5460 боковые наклейки','',5.625,3.625,0.75,1.5,0.35,0.31,7,2,0,0.25,NULL,'INCH',8,'TR'),
10
(4,'Avery 5460 боковые наклейки','',5.625,3.625,0.75,1.5,0.35,0.31,7,2,0,0.25,'INCH'),
11
(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'),
11
(5,'Avery 8163','2 ряда x 5 рядов',8.5,11,4,2,0.5,0.17,2,5,0.2,0.01,'INCH'),
12
(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'),
12
(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'),
13
(7,'HB-PC0001','Шаблон для карточек посетителей домашнего изготовления',8.5,11,3.125,1.875,0.375,0.5625,2,5,1.125,0.1875,NULL,'INCH',16,'TR');
13
(7,'HB-PC0001','Шаблон для карточек посетителей домашнего изготовления',8.5,11,3.125,1.875,0.375,0.5625,2,5,1.125,0.1875,'INCH');
14
14
15
UNLOCK TABLES; 
15
UNLOCK TABLES; 
16
16
17
LOCK TABLES `labels_conf` WRITE;
17
LOCK TABLES `creator_layouts` WRITE;
18
/*!40000 ALTER TABLE `labels_conf` DISABLE KEYS */;
18
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
19
INSERT INTO `labels_conf` 
19
INSERT INTO `creator_layouts` VALUES
20
(id,barcodetype,title,subtitle,itemtype,barcode,dewey,classification,subclass,itemcallnumber,author,issn,isbn,startlabel,
20
(1,'CODE39',1,'BIBBAR','библио-запись и штрих-код',0,1,'TR',7,'POINT',0,'L','title, author, itemcallnumber', '<opt></opt>', 'Labels'),
21
printingtype,formatstring,layoutname,guidebox,active,fonttype,ccode,callnum_split)
21
(2,'CODE39',1,'BAR','переменный',0,1,'TR',3,'POINT',0,'L','','','Labels');
22
VALUES 
22
/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */;
23
(5,'CODE39',2,0,3,0,0,0,0,4,1,0,0,1,'BIBBAR','библио-запись и штрих-код',1,1,NULL,NULL,NULL,NULL),
24
(6,'CODE39',2,0,0,0,0,3,4,0,1,0,3,1,'BAR','переменный',1,1,NULL,NULL,NULL,NULL),
25
(7,'CODE39',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,1,'PATCRD','Карточки идентификации посетителей',1,NULL,NULL,NULL,NULL,NULL);
26
/*!40000 ALTER TABLE `labels_conf` ENABLE KEYS */;
27
23
28
UNLOCK TABLES;
24
UNLOCK TABLES;
(-)a/installer/data/mysql/uk-UA/optional/print_labels.sql (-24 / +18 lines)
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
- 

Return to bug 15053