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

(-)a/installer/data/mysql/en/mandatory/sample_numberpatterns.sql (-4 / +3 lines)
Lines 4-20 INSERT INTO subscription_numberpatterns Link Here
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
- 

Return to bug 11260