Lines 1-15
Link Here
|
1 |
INSERT INTO account_debit_types ( code, description, can_be_added_manually, default_amount, is_system ) VALUES |
1 |
INSERT INTO account_debit_types ( code, description, can_be_invoiced, can_be_sold, default_amount, is_system ) VALUES |
2 |
('ACCOUNT', 'Account creation fee', 0, NULL, 1), |
2 |
('ACCOUNT', 'Account creation fee', 0, 0, NULL, 1), |
3 |
('ACCOUNT_RENEW', 'Account renewal fee', 0, NULL, 1), |
3 |
('ACCOUNT_RENEW', 'Account renewal fee', 0, 0, NULL, 1), |
4 |
('LOST', 'Lost item', 1, NULL, 1), |
4 |
('LOST', 'Lost item', 1, 0, NULL, 1), |
5 |
('MANUAL', 'Manual fee', 1, NULL, 0), |
5 |
('MANUAL', 'Manual fee', 1, 0, NULL, 0), |
6 |
('NEW_CARD', 'New card fee', 1, NULL, 1), |
6 |
('NEW_CARD', 'New card fee', 1, 0, NULL, 1), |
7 |
('OVERDUE', 'Overdue fine', 0, NULL, 1), |
7 |
('OVERDUE', 'Overdue fine', 0, 0, NULL, 1), |
8 |
('PROCESSING', 'Lost item processing fee', 0, NULL, 1), |
8 |
('PROCESSING', 'Lost item processing fee', 0, 0, NULL, 1), |
9 |
('PAYOUT', 'Payment from library to patron', 0, NULL, 1), |
9 |
('PAYOUT', 'Payment from library to patron', 0, 0, NULL, 1), |
10 |
('RENT', 'Rental fee', 0, NULL, 1), |
10 |
('RENT', 'Rental fee', 0, 0, NULL, 1), |
11 |
('RENT_DAILY', 'Daily rental fee', 0, NULL, 1), |
11 |
('RENT_DAILY', 'Daily rental fee', 0, 0, NULL, 1), |
12 |
('RENT_RENEW', 'Renewal of rental item', 0, NULL, 1), |
12 |
('RENT_RENEW', 'Renewal of rental item', 0, 0, NULL, 1), |
13 |
('RENT_DAILY_RENEW', 'Rewewal of daily rental item', 0, NULL, 1), |
13 |
('RENT_DAILY_RENEW', 'Rewewal of daily rental item', 0, 0, NULL, 1), |
14 |
('RESERVE', 'Hold fee', 0, NULL, 1), |
14 |
('RESERVE', 'Hold fee', 0, 0, NULL, 1), |
15 |
('RESERVE_EXPIRED', 'Hold waiting too long', 0, NULL, 1); |
15 |
('RESERVE_EXPIRED', 'Hold waiting too long', 0, 0, NULL, 1); |