1 CREATE TABLE IF NOT EXISTS profile_corps (
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',
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,
18 UNIQUE KEY(abbreviation)
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 '',
28 UNIQUE KEY(abbreviation)
31 -- vim:set syntax=mysql: