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

(-)a/installer/data/mysql/atomicupdate/bug_19166.perl (+20 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 varchar(80) default NULL,
9
            note mediumtext default NULL,
10
            budget_id int(11) default NULL,
11
            encumber_open smallint(1) NOT NULL default 1,
12
            timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
13
            PRIMARY KEY (adjustment_id),
14
            CONSTRAINT invoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
15
            CONSTRAINT invoice_adjustments_fk_budget_id FOREIGN KEY (budget_id) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
16
        )
17
        " );
18
    SetVersion( $DBversion );
19
    print "Upgrade to $DBversion done (Bug 19166 - Add the ability to add adjustments to an invoice)\n";
20
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +19 lines)
Lines 824-829 CREATE TABLE `import_items` ( Link Here
824
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
824
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
825
825
826
--
826
--
827
-- Table structure for table 'invoice_adjustments'
828
--
829
830
DROP TABLE IF EXISTS invoice_adjustments;
831
CREATE TABLE IF NOT EXISTS invoice_adjustments (
832
    adjustment_id int(11) NOT NULL AUTO_INCREMENT, -- primary key for adjustments
833
    invoiceid int(11) NOT NULL, -- foreign key to link an adjustment to an invoice
834
    adjustment decimal(28,6), -- amount of adjustment
835
    reason varchar(80) default NULL, -- reason for adjustment defined by authorised values in ADJ_REASON category
836
    note mediumtext default NULL, -- text to explain adjustment
837
    budget_id int(11) default NULL, -- optional link to budget to apply adjustment to
838
    encumber_open smallint(1) NOT NULL default 1, -- whether or not to encumber the finds when invoice is still open, 1 = yes, 0 = no
839
    timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- timestamp  of last adjustment to adjustment
840
    PRIMARY KEY (adjustment_id),
841
    CONSTRAINT invoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
842
    CONSTRAINT invoice_adjustments_fk_budget_id FOREIGN KEY (budget_id) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
843
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
844
845
--
827
-- Table structure for table `issuingrules`
846
-- Table structure for table `issuingrules`
828
--
847
--
829
848
830
- 

Return to bug 19166