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

(-)a/installer/data/mysql/atomicupdate/14295.sql (+5 lines)
Line 0 Link Here
1
ALTER TABLE uploaded_files
2
    ADD COLUMN filesize int, 
3
    ADD COLUMN dtcreated timestamp NOT NULL default CURRENT_TIMESTAMP,
4
    ADD COLUMN owner int,
5
    ADD CONSTRAINT FOREIGN KEY  (owner) REFERENCES borrowers (borrowernumber);
(-)a/installer/data/mysql/kohastructure.sql (-2 / +5 lines)
Lines 3358-3364 DROP TABLE IF EXISTS uploaded_files; Link Here
3358
CREATE TABLE uploaded_files (
3358
CREATE TABLE uploaded_files (
3359
    id CHAR(40) NOT NULL PRIMARY KEY,
3359
    id CHAR(40) NOT NULL PRIMARY KEY,
3360
    filename TEXT NOT NULL,
3360
    filename TEXT NOT NULL,
3361
    dir TEXT NOT NULL
3361
    dir TEXT NOT NULL,
3362
    filesize int,
3363
    dtcreated timestamp NOT NULL default CURRENT_TIMESTAMP,
3364
    owner int,
3365
    FOREIGN KEY (owner) REFERENCES borrowers (borrowernumber)
3362
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3366
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3363
3367
3364
--
3368
--
3365
- 

Return to bug 14295