@@ -, +, @@ uploaded_files --- installer/data/mysql/atomicupdate/14295.sql | 5 +++++ installer/data/mysql/kohastructure.sql | 6 +++++- 2 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/14295.sql --- a/installer/data/mysql/atomicupdate/14295.sql +++ a/installer/data/mysql/atomicupdate/14295.sql @@ -0,0 +1,5 @@ +ALTER TABLE uploaded_files + ADD COLUMN filesize int, + ADD COLUMN dtcreated timestamp NOT NULL default CURRENT_TIMESTAMP, + ADD COLUMN owner int, + ADD CONSTRAINT FOREIGN KEY (owner) REFERENCES borrowers (borrowernumber); --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3358,7 +3358,11 @@ DROP TABLE IF EXISTS uploaded_files; CREATE TABLE uploaded_files ( id CHAR(40) NOT NULL PRIMARY KEY, filename TEXT NOT NULL, - dir TEXT NOT NULL + dir TEXT NOT NULL, + filesize int, + dtcreated timestamp NOT NULL default CURRENT_TIMESTAMP, + owner int, + FOREIGN KEY (owner) REFERENCES borrowers (borrowernumber) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- --