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

(-)a/installer/data/mysql/atomicupdate/bug_19166.perl (+19 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "
4
        CREATE TABLE IF NOT EXISTS invoice_adjustments (
5
            adjustment_id int(11) NOT NULL AUTO_INCREMENT,
6
            invoiceid int(11) NOT NULL,
7
            adjustment decimal(28,6),
8
            reason mediumtext default NULL,
9
            budget_id int(11) default NULL,
10
            encumber_open smallint(1) NOT NULL default 1,
11
            timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
12
            PRIMARY KEY (adjustment_id),
13
            CONSTRAINT invoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
14
            CONSTRAINT invoice_adjustments_fk_budget_id FOREIGN KEY (budget_id) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
15
        )
16
        " );
17
    SetVersion( $DBversion );
18
    print "Upgrade to $DBversion done (Bug 19166 - Add the ability to add adjustments to an invoice)\n";
19
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +18 lines)
Lines 848-853 CREATE TABLE `import_items` ( Link Here
848
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
848
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
849
849
850
--
850
--
851
-- Table structure for table 'invoice_adjustments'
852
--
853
854
DROP TABLE IF EXISTS invoice_adjustments;
855
CREATE TABLE IF NOT EXISTS invoice_adjustments (
856
    adjustment_id int(11) NOT NULL AUTO_INCREMENT, -- primary key for adjustments
857
    invoiceid int(11) NOT NULL, -- foreign key to link an adjustment to an invoice
858
    adjustment decimal(28,6), -- amount of adjustment
859
    reason mediumtext default NULL, -- text to explain reason for adjustment
860
    budget_id int(11) default NULL, -- optional link to budget to apply adjustment to
861
    encumber_open smallint(1) NOT NULL default 1, -- whether or not to encumber the finds when invoice is still open, 1 = yes, 0 = no
862
    timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- timestamp  of last adjustment to adjustment
863
    PRIMARY KEY (adjustment_id),
864
    CONSTRAINT invoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
865
    CONSTRAINT invoice_adjustments_fk_budget_id FOREIGN KEY (budget_id) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
866
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
867
868
--
851
-- Table structure for table `issuingrules`
869
-- Table structure for table `issuingrules`
852
--
870
--
853
871
854
- 

Return to bug 19166