CREATE TABLE awl ( | |
username varchar(100) NOT NULL default '', | |
email varchar(200) NOT NULL default '', | |
ip varchar(10) NOT NULL default '', | |
count bigint default '0', | |
totscore float default '0' | |
); | |
CREATE UNIQUE INDEX awl_pkey ON awl (username,email,ip); |