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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 3157-3163 CREATE TABLE aqinvoice_adjustments ( Link Here
3157
    reason varchar(80) default NULL, -- reason for adjustment defined by authorised values in ADJ_REASON category
3157
    reason varchar(80) default NULL, -- reason for adjustment defined by authorised values in ADJ_REASON category
3158
    note mediumtext default NULL, -- text to explain adjustment
3158
    note mediumtext default NULL, -- text to explain adjustment
3159
    budget_id int(11) default NULL, -- optional link to budget to apply adjustment to
3159
    budget_id int(11) default NULL, -- optional link to budget to apply adjustment to
3160
    encumber_open smallint(1) NOT NULL default 1, -- whether or not to encumber the finds when invoice is still open, 1 = yes, 0 = no
3160
    encumber_open smallint(1) NOT NULL default 1, -- whether or not to encumber the funds when invoice is still open, 1 = yes, 0 = no
3161
    timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- timestamp  of last adjustment to adjustment
3161
    timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- timestamp  of last adjustment to adjustment
3162
    PRIMARY KEY (adjustment_id),
3162
    PRIMARY KEY (adjustment_id),
3163
    CONSTRAINT aqinvoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
3163
    CONSTRAINT aqinvoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE,
3164
- 

Return to bug 23932