upgrade/1.1.0/17_recovery_ext.sql

   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: