View | Details | Raw Unified | Return to bug 37829
Collapse All | Expand All

(-)a/test_bug_37829.sql (-1 / +29 lines)
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');

Return to bug 37829