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

(-)a/installer/data/mysql/atomicupdate/bug_8179.perl (+15 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    # you can use $dbh here like:
4 
    $dbh->do( qq{
5 
        INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
6 
        ('AcqReceiveMultipleOrderLines', '0', NULL, 'Process multiple order lines at once', 'YesNo')
7 
    });
8 
    # or perform some test and warn
9 
    # if( !column_exists( 'biblio', 'biblionumber' ) ) {
10 
    #    warn "There is something wrong";
11 
    # }
12 

            

            

              13
              
    # Always end with this (adjust the bug info)

            

            

              14
              
    NewVersion( $DBversion, 8179, "Add AcqReceiveMultipleOrderLines system preference");

            

            

              15
              
}

            



(-)a/installer/data/mysql/sysprefs.sql
      (-1 / +1 lines)




  

    
      
            Lines 5-10
          INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
      
      
        Link Here
      
    
  

        

          5
          
('AcqEnableFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to invoice records.','YesNo'),

          5
          
('AcqEnableFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to invoice records.','YesNo'),

        

        

          6
          
('AcqItemSetSubfieldsWhenReceiptIsCancelled','', '','Upon cancelling a receipt, update the items subfields if they were created when placing an order (e.g. o=5|a="bar foo")', 'Free'),

          6
          
('AcqItemSetSubfieldsWhenReceiptIsCancelled','', '','Upon cancelling a receipt, update the items subfields if they were created when placing an order (e.g. o=5|a="bar foo")', 'Free'),

        

        

          7
          
('AcqItemSetSubfieldsWhenReceived','','','Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")','Free'),

          7
          
('AcqItemSetSubfieldsWhenReceived','','','Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")','Free'),

        

            

              
              
              8
              
('AcqReceiveMultipleOrderLines', '0', NULL, 'Process multiple order lines at once', 'YesNo'),

            

        

          8
          
('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),

          9
          
('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),

        

        

          9
          
('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),

          10
          
('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),

        

        

          10
          
('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),

          11
          
('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),

        

            

              11
              
- 

              
              
            






  

  Return to bug 8179