|
Lines 1-16
Link Here
|
| 1 |
INSERT INTO subscription_frequencies |
|
|
| 2 |
(description, unit, unitsperissue, issuesperunit, displayorder) |
| 3 |
VALUES |
| 4 |
('2/day', 'day', 1, 2, 1), |
| 5 |
('1/day', 'day', 1, 1, 2), |
| 6 |
('3/week', 'week', 1, 3, 3), |
| 7 |
('1/week', 'week', 1, 1, 4), |
| 8 |
('1/2 weeks', 'week', 2, 1, 5), |
| 9 |
('1/3 weeks', 'week', 3, 1, 6), |
| 10 |
('1/month', 'month', 1, 1, 7), |
| 11 |
('1/2 months', 'month', 2, 1, 8), |
| 12 |
('1/3 months', 'month', 3, 1, 9), |
| 13 |
('2/year', 'month', 6, 1, 10), |
| 14 |
('1/year', 'year', 1, 1, 11), |
| 15 |
('1/2 year', 'year', 2, 1, 12), |
| 16 |
('Irregular', NULL, 1, 1, 13); |