Attachment #23749 for bug #11260

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

Lines 1-16 Link Here

(-)a/installer/data/mysql/de-DE/mandatory/sample_frequencies.sql (-13 / +13 lines)
1	INSERT INTO subscription_frequencies	1	INSERT INTO subscription_frequencies
2	(description, unit, unitsperissue, issuesperunit, displayorder)	2	(description, unit, unitsperissue, issuesperunit, displayorder)
3	VALUES	3	VALUES
4	('2/day', 'day', 1, 2, 1),	4	('2/Tag', 'day', 1, 2, 1),
5	('1/day', 'day', 1, 1, 2),	5	('1/Tag', 'day', 1, 1, 2),
6	('3/week', 'week', 1, 3, 3),	6	('3/Woche', 'week', 1, 3, 3),
7	('1/week', 'week', 1, 1, 4),	7	('1/Woche', 'week', 1, 1, 4),
8	('1/2 weeks', 'week', 2, 1, 5),	8	('1/2 Wochen', 'week', 2, 1, 5),
9	('1/3 weeks', 'week', 3, 1, 6),	9	('1/3 Wochen', 'week', 3, 1, 6),
10	('1/month', 'month', 1, 1, 7),	10	('1/Monat', 'month', 1, 1, 7),
11	('1/2 months', 'month', 2, 1, 8),	11	('1/2 Monate', 'month', 2, 1, 8),
12	('1/3 months', 'month', 3, 1, 9),	12	('1/3 Monate', 'month', 3, 1, 9),
13	('2/year', 'month', 6, 1, 10),	13	('2/Jahr', 'month', 6, 1, 10),
14	('1/year', 'year', 1, 1, 11),	14	('1/Jahr', 'year', 1, 1, 11),
15	('1/2 year', 'year', 2, 1, 12),	15	('1/2 Jahre', 'year', 2, 1, 12),
16	('Irregular', NULL, 1, 1, 13);	16	('Unregelmäßig', NULL, 1, 1, 13);

Line 1 Link Here

(-)a/installer/data/mysql/de-DE/mandatory/sample_frequencies.txt (-1 / +1 lines)
1	Sample frequencies for subscriptions	1	Erscheinungsweisen für Zeitschriftenabonnements




    label2, add2, every2, whenmorethan2, setto2, numbering2,
    label3, add3, every3, whenmorethan3, setto3, numbering3)
VALUES
    ('Nummer', 1, 'Einfache Nummerierung', 'Nr. {X}',
    'Nummer', 1, 1, 99999, 1, NULL,
    NULL, NULL, NULL, NULL, NULL, NULL,
    NULL, NULL, NULL, NULL, NULL, NULL),

    ('Band, Nummer, Heft', 2, 'Band X, Nummer Y, Heft Z', 'Bd. {X}, Nr. {Y}, H. {Z}',
    'Band', 1, 48, 99999, 1, NULL,
    'Nummer', 1, 4, 12, 1, NULL,
    'Heft', 1, 1, 4, 1, NULL),

    ('Band, Nummer', 3, 'Bd. X, Nr. Y', 'Bd. {X}, Nr. {Y}',
    'Band', 1, 12, 99999, 1, NULL,
    'Nummer', 1, 1, 12, 1, NULL,
    NULL, NULL, NULL, NULL, NULL, NULL),

    ('Saisonal', 4, 'Saison Jahr', '{X} {Y}',
    'Saison', 1, 1, 3, 0, 'season',
    'Jahr', 1, 4, 99999, 1, NULL,
    NULL, NULL, NULL, NULL, NULL, NULL);

Line 1 Link Here

(-)a/installer/data/mysql/de-DE/mandatory/sample_numberpatterns.txt (-2 / +1 lines)
1	Sample numbering patterns for subscriptions	1	Nummerierungsmuster für Zeitschriftenabonnements
2	-

Return to bug 11260

Lines 4-25 INSERT INTO subscription_numberpatterns Link Here

(-)a/installer/data/mysql/de-DE/mandatory/sample_numberpatterns.sql (-12 / +12 lines)
4	label2, add2, every2, whenmorethan2, setto2, numbering2,	4	label2, add2, every2, whenmorethan2, setto2, numbering2,
5	label3, add3, every3, whenmorethan3, setto3, numbering3)	5	label3, add3, every3, whenmorethan3, setto3, numbering3)
6	VALUES	6	VALUES
7	('Number', 1, 'Simple Numbering method', 'No.{X}',	7	('Nummer', 1, 'Einfache Nummerierung', 'Nr. {X}',
8	'Number', 1, 1, 99999, 1, NULL,	8	'Nummer', 1, 1, 99999, 1, NULL,
9	NULL, NULL, NULL, NULL, NULL, NULL,	9	NULL, NULL, NULL, NULL, NULL, NULL,
10	NULL, NULL, NULL, NULL, NULL, NULL),	10	NULL, NULL, NULL, NULL, NULL, NULL),
11		11
12	('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',	12	('Band, Nummer, Heft', 2, 'Band X, Nummer Y, Heft Z', 'Bd. {X}, Nr. {Y}, H. {Z}',
13	'Volume', 1, 48, 99999, 1, NULL,	13	'Band', 1, 48, 99999, 1, NULL,
14	'Number', 1, 4, 12, 1, NULL,	14	'Nummer', 1, 4, 12, 1, NULL,
15	'Issue', 1, 1, 4, 1, NULL),	15	'Heft', 1, 1, 4, 1, NULL),
16		16
17	('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',	17	('Band, Nummer', 3, 'Bd. X, Nr. Y', 'Bd. {X}, Nr. {Y}',
18	'Volume', 1, 12, 99999, 1, NULL,	18	'Band', 1, 12, 99999, 1, NULL,
19	'Number', 1, 1, 12, 1, NULL,	19	'Nummer', 1, 1, 12, 1, NULL,
20	NULL, NULL, NULL, NULL, NULL, NULL),	20	NULL, NULL, NULL, NULL, NULL, NULL),
21		21
22	('Seasonal', 4, 'Season Year', '{X} {Y}',	22	('Saisonal', 4, 'Saison Jahr', '{X} {Y}',
23	'Season', 1, 1, 3, 0, 'season',	23	'Saison', 1, 1, 3, 0, 'season',
24	'Year', 1, 4, 99999, 1, NULL,	24	'Jahr', 1, 4, 99999, 1, NULL,
25	NULL, NULL, NULL, NULL, NULL, NULL);	25	NULL, NULL, NULL, NULL, NULL, NULL);