sqlchanges20010206.sql

GForge 3.0 协作开发平台 支持CVS, mailing lists, bug tracking, message boards/forums, task management, perman

-- by: pfalcon
-- purpose: add timestamp/version for stored multimedia files

ALTER TABLE db_images ADD COLUMN upload_date int NOT NULL;
ALTER TABLE db_images ADD COLUMN version int NOT NULL;

CREATE UNIQUE INDEX usergroup_uniq_groupid_userid ON 
user_group(group_id,user_id);