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

(-)a/installer/data/mysql/de-DE/optional/sample_creator_data.sql (-1 / +1 lines)
Lines 3-9 Link Here
3
3
4
LOCK TABLES `creator_layouts` WRITE;
4
LOCK TABLES `creator_layouts` WRITE;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
6
INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Etikettentest',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','Testlayout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
6
INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Etikettentest',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Testlayout',0,1,'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">
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" />
8
    <data_source image_name="none" image_source="patronimages" />
9
  </images>
9
  </images>
(-)a/installer/data/mysql/es-ES/optional/sample_creator_data.sql (-1 / +1 lines)
Lines 3-9 Link Here
3
3
4
LOCK TABLES `creator_layouts` WRITE;
4
LOCK TABLES `creator_layouts` WRITE;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
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, 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
INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,1,'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">
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" />
8
    <data_source image_name="none" image_source="patronimages" />
9
  </images>
9
  </images>
(-)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/it-IT/necessari/sample_creator_data.sql (-3 / +3 lines)
Lines 3-11 Link Here
3
3
4
LOCK TABLES `creator_layouts` WRITE;
4
LOCK TABLES `creator_layouts` WRITE;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
6
INSERT INTO `creator_layouts` VALUES (1,'CODE39',1,'BIBBAR','Test etic. (BIBBAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
6
INSERT INTO `creator_layouts` VALUES (1,'CODE39',1,'BIBBAR','Test etic. (BIBBAR)',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
7
(2,'CODE39',1,'BAR','Test etic. (BAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
7
(2,'CODE39',1,'BAR','Test etic. (BAR)',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
8
(3,'CODE39',1,'BAR','Test tessere',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
8
(3,'CODE39',1,'BAR','Test tessere',0,1,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
9
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
9
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
10
    <data_source image_name="none" image_source="patronimages" />
10
    <data_source image_name="none" image_source="patronimages" />
11
  </images>
11
  </images>
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql (-2 / +1 lines)
Lines 3-9 Link Here
3
3
4
LOCK TABLES `creator_layouts` WRITE;
4
LOCK TABLES `creator_layouts` WRITE;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
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, 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
INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,1,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,1,'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">
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" />
8
    <data_source image_name="none" image_source="patronimages" />
9
  </images>
9
  </images>
10
- 

Return to bug 15064