Bukkit

CREATE TABLE `va_superuser` (
  `player` char(20) NOT NULL,

  -- clear to validate record, or 'flush'
  `dirty` char(6) DEFAULT '',

  `online` char(6) DEFAULT 'false',

  -- may be true/false/stealth
  `super` char(8) DEFAULT 'false',

  -- PEX group
  `pgroup` char(10) DEFAULT 'new_user',

  `is_op` char(6) DEFAULT 'false',
  `gamemode` char(10) DEFAULT 'SURVIVAL',

  -- expiration of jail time
  `jailed` char(12) DEFAULT '',

  -- time eligable for auto reset
  `kicked` char(12) DEFAULT '',

  -- expiration of ban
  `banned` char(12) DEFAULT '',

  -- build or break permission
  `edit_ok` char(6) DEFAULT 'false',

  -- false = rollback on player quit
  `save_wrk` char(6) DEFAULT 'false',

  -- false = rollback on player quit
  `save_tnt` char(6) DEFAULT 'false',

  -- teleport permission
  `tp_ok` char(6) DEFAULT 'false',

  -- permission to vanish, including potion
  `hide_ok` char(6) DEFAULT 'false',

  -- commands starting with '//'
  `we_ok` char(6) DEFAULT 'false',

  -- tnt or anything associated with it
  `tnt_ok` char(6) DEFAULT 'false',

  -- placing or handling lava
  `lava_ok` char(6) DEFAULT 'false',

  -- permission to fly
  `fly_ok` char(6) DEFAULT 'false',

  -- inter world travel
  `mwrld_ok` char(6) DEFAULT 'false',

  -- permission to chat
  `chat_ok` char(6) DEFAULT 'false',

  -- permission to use buckets
  `bckt_ok` char(6) DEFAULT 'false',

  -- permission to harm players
  `k_plr_ok` char(6) DEFAULT 'false',

  -- permission to harm animals
  `k_aml_ok` char(6) DEFAULT 'false',

  -- permission to harm pets
  `k_pet_ok` char(6) DEFAULT 'false',

  -- use of spawn eggs
  `spwn_ok` char(6) DEFAULT 'false',

  -- use of potion
  `potn_ok` char(6) DEFAULT 'false',

  `password` char(20) DEFAULT '',
  `ip_addr` char(20) DEFAULT '',
  `logged_in` char(6) DEFAULT 'false',
  `session` char(6) DEFAULT 'false',

  -- total harm offenses
  `harm` char(6) DEFAULT '0',

  -- total damage offenses
  `damage` char(6) DEFAULT '0',

  -- total trespass offenses
  `trespass` char(6) DEFAULT '0',

  -- total breach offenses
  `breach` char(6) DEFAULT '0',

  -- total felonies - 2 allowed
  `felony` char(6) DEFAULT '0',

  -- total command offenses
  `command` char(6) DEFAULT '0',

  -- a number indicates guest status
  `guestlogin` char(12) DEFAULT '',

  -- running login total
  `count` char(6) DEFAULT '0',

  -- accumulated time total
  `accum_secs` char(8) DEFAULT '0',

  -- time, world, X, Y, Z
  `first_login` char(60) DEFAULT '',

  -- time, world, X, Y, Z
  `last_login` char(60) DEFAULT '',

  -- time, world, X, Y, Z
  `last_logout` char(60) DEFAULT '',

  -- time, world, X, Y, Z
  `last_death` char(60) DEFAULT '',

  -- time, world, X, Y, Z
  `last_spawn` char(60) DEFAULT '',

  `init` char(1) DEFAULT '0',
  `last_post` char(12) DEFAULT '',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `player_2` (`player`),
  KEY `player` (`player`)
) ENGINE=InnoDB AUTO_INCREMENT=1;