|
Line 0
Link Here
|
| 0 |
- |
1 |
UPDATE itemtypes |
|
|
2 |
SET bookable = 1 |
| 3 |
WHERE itemtype = 'BK'; |
| 4 |
INSERT INTO authorised_value_categories (category_name) |
| 5 |
VALUES ('BOOKINGS_URGENCY'); |
| 6 |
INSERT INTO authorised_values (category, authorised_value, lib) |
| 7 |
VALUES ('BOOKINGS_URGENCY', 'LOW', 'Low'); |
| 8 |
INSERT INTO authorised_values (category, authorised_value, lib) |
| 9 |
VALUES ( |
| 10 |
'BOOKINGS_URGENCY', |
| 11 |
'MEDIUM', |
| 12 |
'Medium' |
| 13 |
); |
| 14 |
INSERT INTO authorised_values (category, authorised_value, lib) |
| 15 |
VALUES ('BOOKINGS_URGENCY', 'HIGH', 'High'); |
| 16 |
INSERT INTO additional_fields ( |
| 17 |
tablename, |
| 18 |
name, |
| 19 |
authorised_value_category |
| 20 |
) |
| 21 |
VALUES ('bookings', 'Urgency', 'BOOKINGS_URGENCY'); |
| 22 |
INSERT INTO additional_fields ( |
| 23 |
tablename, |
| 24 |
name, |
| 25 |
repeatable |
| 26 |
) |
| 27 |
VALUES ('bookings', 'Note', 1); |
| 28 |
INSERT INTO additional_fields (tablename, name) |
| 29 |
VALUES ('bookings', 'Contact'); |