projects
/
fusionforge
/
fusionforge.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
project home
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Use <p>
[fusionforge/fusionforge.git]
/
src
/
db
/
20010511.sql
1
-- by: pfalcon
2
-- purpose: table with history of users' rating, for tracking changes/graphing
3
4
CREATE TABLE user_metric_history(
5
month int not null,
6
day int not null,
7
user_id int not null,
8
ranking int not null,
9
metric float not null);
10
11
CREATE UNIQUE INDEX user_metric_history_date_userid
12
ON user_metric_history(month,day,user_id);