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

(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
Lines 1-6 Link Here
1 
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
 1 
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
2 
('AcqCreateItem','ordering','ordering|receiving|cataloguing','Define when the item is created : when ordering, when receiving, or in cataloguing module','Choice'),
 2 
('AcqCreateItem','ordering','ordering|receiving|cataloguing','Define when the item is created : when ordering, when receiving, or in cataloguing module','Choice'),
3 
('AcqItemSetSubfieldsWhenReceived','0','','Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")','Free'),
 3 
('AcqItemSetSubfieldsWhenReceived','','','Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")','Free'),
4 
('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),
 4 
('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),
5 
('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),
 5 
('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),
6 
('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),
 6 
('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +8 lines)
Lines 7919-7925 if(CheckVersion($DBversion)) { Link Here
7919 
        SET explanation = 'Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")'
 7919 
        SET explanation = 'Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")'
7920 
        WHERE variable = "AcqItemSetSubfieldsWhenReceived"
 7920 
        WHERE variable = "AcqItemSetSubfieldsWhenReceived"
7921 
    });
 7921 
    });
7922 
    print "Upgrade to $DBversion done (Bug 11237: Update explanation for AcqItemSetSubfieldsWhenReceived syspref)\n";
 7922 

            

            

              
              

              7923
              
    $dbh->do(q{

            

            


              7924
              
        UPDATE systempreferences

            

            


              7925
              
        SET value = ''

            

            


              7926
              
        WHERE variable = "AcqItemSetSubfieldsWhenReceived"

            

            


              7927
              
            AND value = "0"

            

            


              7928
              
    });

            

            


              7929
              
    print "Upgrade to $DBversion done (Bug 11237: Update explanation and default value for AcqItemSetSubfieldsWhenReceived syspref)\n";

            

        

          7923
          
    SetVersion($DBversion);

          7930
          
    SetVersion($DBversion);

        

        

          7924
          
}

          7931
          
}

        

        

          7925
          

          7932
          

        

            

              7926
              
- 

              
              
            






  

  Return to bug 11237