[platal.git] / upgrade / 1.1.0 / 17_recovery_ext.sql

DROP TABLE IF EXISTS account_xnet_lost_passwords;

CREATE TABLE account_xnet_lost_passwords (
  uid INT(11) UNSIGNED NOT NULL DEFAULT 0,
  date DATETIME NULL DEFAULT NULL,
  hash CHAR(32) NOT NULL DEFAULT '',
  PRIMARY KEY (uid),
  KEY hash (hash),
  FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB, CHARSET=utf8;

-- vim:set syntax=mysql:
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: