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