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

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

Return to bug 23932