1 DROP TABLE IF EXISTS register_pending_xnet
;
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 '',
10 UNIQUE KEY hruid (hruid
),
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
;
16 -- vim:set syntax=mysql: