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