|
Lines 1-25
Link Here
|
| 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) |
| 6 |
VALUES |
| 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), |
| 11 |
|
| 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), |
| 16 |
|
| 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), |
| 21 |
|
| 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); |