Commit | Line | Data |
---|---|---|
e1e112b3 SJ |
1 | DROP TABLE IF EXISTS account_xnet_lost_passwords; |
2 | ||
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 '', | |
7 | PRIMARY KEY (uid), | |
8 | KEY hash (hash), | |
9 | FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE | |
10 | ) ENGINE=InnoDB, CHARSET=utf8; | |
11 | ||
12 | -- vim:set syntax=mysql: |