@@ -, +, @@ --- installer/data/mysql/atomicupdate/14321a_public.sql | 5 +++++ installer/data/mysql/kohastructure.sql | 2 ++ 2 files changed, 7 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/14321a_public.sql --- a/installer/data/mysql/atomicupdate/14321a_public.sql +++ a/installer/data/mysql/atomicupdate/14321a_public.sql @@ -0,0 +1,5 @@ +ALTER TABLE uploaded_files + ADD COLUMN public tinyint, + ADD COLUMN permanent tinyint; +-- Any records already there are public and permanent storage +UPDATE uploaded_files SET public=1, permanent=1; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3361,6 +3361,8 @@ CREATE TABLE uploaded_files ( dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, categorycode tinytext, owner int(11), + public tinyint, + permanent tinyint, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; --