CREATE TABLE txrep ( | |
username varchar(100) NOT NULL default '', | |
email varchar(255) NOT NULL default '', | |
ip varchar(40) NOT NULL default '', | |
msgcount int(11) NOT NULL default '0', | |
totscore float NOT NULL default '0', | |
signedby varchar(255) NOT NULL default '', | |
last_hit timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | |
PRIMARY KEY (username,email,signedby,ip), | |
KEY last_hit (last_hit) | |
) ENGINE=InnoDB; |