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

(-)a/installer/data/mysql/atomicupdate/removeoldsyspref.sql (-1 lines)
Line 1 Link Here
1
DELETE FROM systempreferences where variable = 'EDIInvoicesShippingBudget';
(-)a/installer/data/mysql/updatedatabase.pl (-6 / +1 lines)
Lines 12094-12100 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
12094
}
12094
}
12095
12095
12096
$DBversion = "3.23.00.045";
12096
$DBversion = "3.23.00.045";
12097
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
12097
if ( CheckVersion($DBversion) ) {
12098
## Holds details for vendors supplying goods by EDI
12098
## Holds details for vendors supplying goods by EDI
12099
   $dbh->do(q{
12099
   $dbh->do(q{
12100
           CREATE TABLE IF NOT EXISTS vendor_edi_accounts (
12100
           CREATE TABLE IF NOT EXISTS vendor_edi_accounts (
Lines 12186-12195 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
12186
                   CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
12186
                   CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
12187
                   ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12187
                   ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12188
           });
12188
           });
12189
## Syspref budget to hold shipping costs
12190
   $dbh->do(q{
12191
           INSERT INTO systempreferences (variable, explanation, type) VALUES('EDIInvoicesShippingBudget','The budget code used to allocate shipping charges to when processing EDI Invoice messages',  'free');
12192
           });
12193
12189
12194
## Add a permission for managing EDI
12190
## Add a permission for managing EDI
12195
   $dbh->do(q{
12191
   $dbh->do(q{
12196
- 

Return to bug 16288