2 -- purpose: add timestamp/version for stored multimedia files
4 ALTER TABLE db_images ADD COLUMN upload_date int;
5 ALTER TABLE db_images ALTER COLUMN upload_date SET NOT NULL;
7 ALTER TABLE db_images ADD COLUMN version int;
8 ALTER TABLE db_images ALTER COLUMN version SET NOT NULL;
10 CREATE UNIQUE INDEX usergroup_uniq_groupid_userid ON
11 user_group(group_id,user_id);