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