sqlchanges20010206.sql

来自「GForge 3.0 协作开发平台 支持CVS, mailing lists, 」· SQL 代码 · 共 10 行

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