Commit | Line | Data |
---|---|---|
72e96bc0 SJ |
1 | CREATE TABLE IF NOT EXISTS profile_corps ( |
2 | uid INT(11) NOT NULL, | |
3 | original_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0, | |
4 | current_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0, | |
5 | rankid INT(4) UNSIGNED NOT NULL DEFAULT 0, | |
6 | corps_pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private', | |
7 | PRIMARY KEY(uid) | |
8 | ) CHARSET=utf8; | |
9 | ||
10 | ||
11 | CREATE TABLE IF NOT EXISTS profile_corps_enum ( | |
12 | id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT, | |
13 | name VARCHAR(255) NOT NULL DEFAULT '', | |
14 | abbreviation CHAR(5) NOT NULL DEFAULT '', | |
15 | still_exists TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, | |
16 | PRIMARY KEY(id), | |
17 | UNIQUE KEY(name), | |
18 | UNIQUE KEY(abbreviation) | |
19 | ) CHARSET=utf8; | |
20 | ||
21 | ||
22 | CREATE TABLE IF NOT EXISTS profile_corps_rank_enum ( | |
23 | id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT, | |
24 | name VARCHAR(255) NOT NULL DEFAULT '', | |
25 | abbreviation CHAR(5) NOT NULL DEFAULT '', | |
26 | PRIMARY KEY(id), | |
27 | UNIQUE KEY(name), | |
28 | UNIQUE KEY(abbreviation) | |
29 | ) CHARSET=utf8; | |
30 | ||
31 | -- vim:set syntax=mysql: |