1 -- table adjustments for uploaded_files
2 ALTER TABLE uploaded_files
3 CHANGE COLUMN id hashvalue char(40) NOT NULL,
5 ALTER TABLE uploaded_files
6 ADD COLUMN id int NOT NULL AUTO_INCREMENT FIRST,
7 ADD CONSTRAINT PRIMARY KEY (id),
8 ADD COLUMN filesize int,
9 ADD COLUMN dtcreated timestamp,
10 ADD COLUMN categorycode tinytext,