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