[platal.git] / upgrade / 1.1.0 / 16_register_ext.sql

DROP TABLE IF EXISTS register_pending_xnet;

CREATE TABLE register_pending_xnet (
  uid INT(11) UNSIGNED NOT NULL DEFAULT 0,
  hruid VARCHAR(255) NOT NULL DEFAULT '',
  email VARCHAR(255) NOT NULL DEFAULT '',
  date DATE NOT NULL DEFAULT '0000-00-00',
  hash VARCHAR(12) NOT NULL DEFAULT '',
  PRIMARY KEY (uid),
  UNIQUE KEY hruid (hruid),
  KEY hash (hash),
  FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (hruid) REFERENCES accounts (hruid) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB, CHARSET=utf8;

-- vim:set syntax=mysql:
Commit	Line	Data
bc6e8005 SJ	1	DROP TABLE IF EXISTS register_pending_xnet;
	2
	3	CREATE TABLE register_pending_xnet (
	4	uid INT(11) UNSIGNED NOT NULL DEFAULT 0,
	5	hruid VARCHAR(255) NOT NULL DEFAULT '',
	6	email VARCHAR(255) NOT NULL DEFAULT '',
	7	date DATE NOT NULL DEFAULT '0000-00-00',
	8	hash VARCHAR(12) NOT NULL DEFAULT '',
	9	PRIMARY KEY (uid),
	10	UNIQUE KEY hruid (hruid),
	11	KEY hash (hash),
	12	FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
	13	FOREIGN KEY (hruid) REFERENCES accounts (hruid) ON DELETE CASCADE ON UPDATE CASCADE
	14	) ENGINE=InnoDB, CHARSET=utf8;
	15
	16	-- vim:set syntax=mysql: