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;
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;
-