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

(-)a/installer/data/mysql/en/optional/auth_val.sql (-1 / +7 lines)
Lines 4-9 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST Link Here
4 
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Library Copy Lost');
 4 
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Library Copy Lost');
5 
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
 5 
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
6 

          6
          

        

            

              
              
              7
              
-- Desired formats for requesting new materials

            

            

              8
              
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book');

            

            

              9
              
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print');

            

            

              10
              
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');

            

            

              11
              
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');

            

            

              12
              
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');

            

            

              13
              

            

        

          7
          
-- availability statuses

          14
          
-- availability statuses

        

        

          8
          
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');

          15
          
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');

        

        

          9
          
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');

          16
          
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');

        

            

              10
              
- 

              
              
            






  

  Return to bug 9468