sqlchanges20010511.sql

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

-- by: pfalcon
-- purpose: table with history of users' rating, for tracking changes/graphing

CREATE TABLE user_metric_history(
month int not null,
day  int not null,
user_id int not null,
ranking int not null,
metric float not null);

CREATE UNIQUE INDEX user_metric_history_date_userid 
ON user_metric_history(month,day,user_id);