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

(-)a/installer/data/mysql/atomicupdate/14321a_public.sql (+5 lines)
Line 0 Link Here
1
ALTER TABLE uploaded_files
2
    ADD COLUMN public tinyint,
3
    ADD COLUMN permanent tinyint;
4
-- Any records already there are public and permanent storage
5
UPDATE uploaded_files SET public=1, permanent=1;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 3361-3366 CREATE TABLE uploaded_files ( Link Here
3361
    dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3361
    dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3362
    categorycode tinytext,
3362
    categorycode tinytext,
3363
    owner int(11),
3363
    owner int(11),
3364
    public tinyint,
3365
    permanent tinyint,
3364
    PRIMARY KEY (id)
3366
    PRIMARY KEY (id)
3365
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3367
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3366
3368
3367
- 

Return to bug 14321