Attachment #23998 for bug #11260

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




    label2, add2, every2, whenmorethan2, setto2, numbering2,
    label3, add3, every3, whenmorethan3, setto3, numbering3)
VALUES
    ('Number', 1, 'Simple Numbering method', 'No. {X}',
    'Number', 1, 1, 99999, 1, NULL,
    NULL, NULL, NULL, NULL, NULL, NULL,
    NULL, NULL, NULL, NULL, NULL, NULL),

    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol. {X}, Number {Y}, Issue {Z}',
    'Volume', 1, 48, 99999, 1, NULL,
    'Number', 1, 4, 12, 1, NULL,
    'Issue', 1, 1, 4, 1, NULL),

    ('Volume, Number', 3, 'Volume Number 1', 'Vol. {X}, No. {Y}',
    'Volume', 1, 12, 99999, 1, NULL,
    'Number', 1, 1, 12, 1, NULL,
    NULL, NULL, NULL, NULL, NULL, NULL),
- 

Return to bug 11260

Lines 4-20 INSERT INTO subscription_numberpatterns Link Here

(-)a/installer/data/mysql/en/mandatory/sample_numberpatterns.sql (-4 / +3 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	('Number', 1, 'Simple Numbering method', 'No. {X}',
8	'Number', 1, 1, 99999, 1, NULL,	8	'Number', 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	('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol. {X}, Number {Y}, Issue {Z}',
13	'Volume', 1, 48, 99999, 1, NULL,	13	'Volume', 1, 48, 99999, 1, NULL,
14	'Number', 1, 4, 12, 1, NULL,	14	'Number', 1, 4, 12, 1, NULL,
15	'Issue', 1, 1, 4, 1, NULL),	15	'Issue', 1, 1, 4, 1, NULL),
16		16
17	('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',	17	('Volume, Number', 3, 'Volume Number 1', 'Vol. {X}, No. {Y}',
18	'Volume', 1, 12, 99999, 1, NULL,	18	'Volume', 1, 12, 99999, 1, NULL,
19	'Number', 1, 1, 12, 1, NULL,	19	'Number', 1, 1, 12, 1, NULL,
20	NULL, NULL, NULL, NULL, NULL, NULL),	20	NULL, NULL, NULL, NULL, NULL, NULL),
21	-