CREATE TABLE IF NOT EXISTS profile_corps (
  uid INT(11) NOT NULL,
  original_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0,
  current_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0,
  rankid INT(4) UNSIGNED NOT NULL DEFAULT 0,
  corps_pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private',
  PRIMARY KEY(uid)
) CHARSET=utf8;


CREATE TABLE IF NOT EXISTS profile_corps_enum (
  id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL DEFAULT '',
  abbreviation CHAR(5) NOT NULL DEFAULT '',
  still_exists TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
  PRIMARY KEY(id),
  UNIQUE KEY(name),
  UNIQUE KEY(abbreviation)
) CHARSET=utf8;


CREATE TABLE IF NOT EXISTS profile_corps_rank_enum (
  id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL DEFAULT '',
  abbreviation CHAR(5) NOT NULL DEFAULT '',
  PRIMARY KEY(id),
  UNIQUE KEY(name),
  UNIQUE KEY(abbreviation)
) CHARSET=utf8;

--  vim:set syntax=mysql: