OTHER smallint(5) NOT NULL default '0',
STATUS enum('NEUTRAL','ALLIED','FRIEND','FOE','BETRAY') NOT NULL default 'NEUTRAL',
PRIMARY KEY (GAME,PLAYER,OTHER)
OTHER smallint(5) NOT NULL default '0',
STATUS enum('NEUTRAL','ALLIED','FRIEND','FOE','BETRAY') NOT NULL default 'NEUTRAL',
PRIMARY KEY (GAME,PLAYER,OTHER)
DYING enum('PKH','PHK','HPK','HKP','KPH','KHP') NOT NULL default 'KHP',
HERO smallint(6) NOT NULL default '0',
PRIMARY KEY (GAME,PLAYER)
DYING enum('PKH','PHK','HPK','HKP','KPH','KHP') NOT NULL default 'KHP',
HERO smallint(6) NOT NULL default '0',
PRIMARY KEY (GAME,PLAYER)
COMMAND_ID mediumint(9) NOT NULL default '0',
TIME datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
COMMAND_ID mediumint(9) NOT NULL default '0',
TIME datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
START_MANA smallint(5) unsigned NOT NULL default '20',
RUNNING enum('Y','N') NOT NULL default 'Y',
PRIMARY KEY (GAME)
START_MANA smallint(5) unsigned NOT NULL default '20',
RUNNING enum('Y','N') NOT NULL default 'Y',
PRIMARY KEY (GAME)
DEATH_AVATAR smallint(5) unsigned NOT NULL default '0',
ARRIVAL char(7) NOT NULL default '',
PRIMARY KEY (GAME,PLAYER)
DEATH_AVATAR smallint(5) unsigned NOT NULL default '0',
ARRIVAL char(7) NOT NULL default '',
PRIMARY KEY (GAME,PLAYER)
LANGUAGE enum('DE','EN') NOT NULL default 'DE',
TEXT text NOT NULL,
PRIMARY KEY (TAG,LANGUAGE)
LANGUAGE enum('DE','EN') NOT NULL default 'DE',
TEXT text NOT NULL,
PRIMARY KEY (TAG,LANGUAGE)
TERRAIN enum('PLAIN','WATER','CITY','MOUNTAIN','ISLE','POLE','AYMARGEDDON') NOT NULL default 'PLAIN',
TEMPLE enum('Y','N') NOT NULL default 'N',
PLAGUE set('PESTILENTIA','INFLUENZA','TUBERCULOSIS') default NULL,
TERRAIN enum('PLAIN','WATER','CITY','MOUNTAIN','ISLE','POLE','AYMARGEDDON') NOT NULL default 'PLAIN',
TEMPLE enum('Y','N') NOT NULL default 'N',
PLAGUE set('PESTILENTIA','INFLUENZA','TUBERCULOSIS') default NULL,
ATTACKER smallint(5) unsigned default '0',
GOD_ATTACKER smallint(5) unsigned default '0',
NAME varchar(20) NOT NULL default '',
FLUXLINE set('N','S','SW','NW','SE','NE') NOT NULL default '',
PRIMARY KEY (GAME,LOCATION)
ATTACKER smallint(5) unsigned default '0',
GOD_ATTACKER smallint(5) unsigned default '0',
NAME varchar(20) NOT NULL default '',
FLUXLINE set('N','S','SW','NW','SE','NE') NOT NULL default '',
PRIMARY KEY (GAME,LOCATION)
COMMAND_ID mediumint(9) NOT NULL default '0',
MOVE_WITH mediumint(6) unsigned default '0',
PRIMARY KEY (ID)
COMMAND_ID mediumint(9) NOT NULL default '0',
MOVE_WITH mediumint(6) unsigned default '0',
PRIMARY KEY (ID)
UNIQUE KEY PLAYER (PLAYER),
UNIQUE KEY LOGIN (LOGIN),
UNIQUE KEY EMAIL (EMAIL)
UNIQUE KEY PLAYER (PLAYER),
UNIQUE KEY LOGIN (LOGIN),
UNIQUE KEY EMAIL (EMAIL)