1 DROP TABLE IF EXISTS account_xnet_lost_passwords
;
3 CREATE TABLE account_xnet_lost_passwords (
4 uid
INT(11) UNSIGNED
NOT NULL DEFAULT 0,
5 date DATETIME
NULL DEFAULT NULL,
6 hash
CHAR(32) NOT NULL DEFAULT '',
9 FOREIGN KEY (uid
) REFERENCES accounts (uid
) ON DELETE CASCADE ON UPDATE CASCADE
10 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
12 -- vim:set syntax=mysql: