| 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: |