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); |