1 INSERT INTO subscription_numberpatterns
2 (label, displayorder, description, numberingmethod,
3 label1, add1, every1, whenmorethan1, setto1, numbering1,
4 label2, add2, every2, whenmorethan2, setto2, numbering2,
5 label3, add3, every3, whenmorethan3, setto3, numbering3)
7 ('Number', 1, 'Simple Numbering method', 'No. {X}',
8 'Number', 1, 1, 99999, 1, NULL,
9 NULL, NULL, NULL, NULL, NULL, NULL,
10 NULL, NULL, NULL, NULL, NULL, NULL),
12 ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol. {X}, Number {Y}, Issue {Z}',
13 'Volume', 1, 48, 99999, 1, NULL,
14 'Number', 1, 4, 12, 1, NULL,
15 'Issue', 1, 1, 4, 1, NULL),
17 ('Volume, Number', 3, 'Volume Number 1', 'Vol. {X}, No. {Y}',
18 'Volume', 1, 12, 99999, 1, NULL,
19 'Number', 1, 1, 12, 1, NULL,
20 NULL, NULL, NULL, NULL, NULL, NULL),
22 ('Seasonal', 4, 'Season Year', '{X} {Y}',
23 'Season', 1, 1, 3, 0, 'season',
24 'Year', 1, 4, 99999, 1, NULL,
25 NULL, NULL, NULL, NULL, NULL, NULL);