X-Git-Url: http://aymargeddon.de/gitweb/?p=aymargeddon%2Fcurrent.git;a=blobdiff_plain;f=var%2FRAGNAROEK.sql;h=4347429ea4de862039aa3250c0c71566cfd43ae6;hp=cea0ce3bbea83098b6ee47fb6e85d2cbf50af549;hb=2e6d04d5a87fe2042cf0c7f11711105908c3f7d9;hpb=04e6fbd873a9142c6497832831b1544a53a2c4ae diff --git a/var/RAGNAROEK.sql b/var/RAGNAROEK.sql index cea0ce3..4347429 100644 --- a/var/RAGNAROEK.sql +++ b/var/RAGNAROEK.sql @@ -1,223 +1,280 @@ --- MySQL dump 9.09 +-- MySQL dump 10.13 Distrib 5.5.24, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: RAGNAROEK -- ------------------------------------------------------ --- Server version 4.0.16-log +-- Server version 5.5.24-0ubuntu0.12.04.1 + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `ALLIANCE` -- -DROP TABLE IF EXISTS ALLIANCE; -CREATE TABLE ALLIANCE ( - GAME smallint(5) unsigned NOT NULL default '0', - PLAYER smallint(5) NOT NULL default '0', - OTHER smallint(5) NOT NULL default '0', - STATUS enum('NEUTRAL','ALLIED','FRIEND','FOE','BETRAY') NOT NULL default 'NEUTRAL', - PRIMARY KEY (GAME,PLAYER,OTHER) -) COMMENT='friend or foe?'; +DROP TABLE IF EXISTS `ALLIANCE`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ALLIANCE` ( + `GAME` smallint(5) unsigned NOT NULL DEFAULT '0', + `PLAYER` smallint(5) NOT NULL DEFAULT '0', + `OTHER` smallint(5) NOT NULL DEFAULT '0', + `STATUS` enum('NEUTRAL','ALLIED','FRIEND','FOE','BETRAY') NOT NULL DEFAULT 'NEUTRAL', + PRIMARY KEY (`GAME`,`PLAYER`,`OTHER`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='friend or foe?'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `COMMAND` -- -DROP TABLE IF EXISTS COMMAND; -CREATE TABLE COMMAND ( - ID mediumint(9) NOT NULL auto_increment, - GAME smallint(5) unsigned NOT NULL default '0', - EXEC datetime NOT NULL default '0000-00-00 00:00:00', - SUBMIT datetime NOT NULL default '0000-00-00 00:00:00', - PLAYER smallint(5) NOT NULL default '0', - COMMAND enum('SEND_MSG','MOVE_WITH','PRAY','PRODUCE','FIGHT_EARTHLING','FIGHT_GOD','CH_STATUS','MOVE','BUILD_TEMPLE','CH_ADORING','CH_ACTION','BLESS_PRIEST','BLESS_HERO','DIE_ORDER','MOVE_MTN','INCARNATE','BUILD_ARK','PLAGUE','FLOOD','DESTROY','CH_LUCK') NOT NULL default 'CH_STATUS', - LOCATION varchar(7) default NULL, - MOBILE mediumint(8) unsigned NOT NULL default '0', - ARGUMENTS text NOT NULL, - ACK datetime default NULL, - DONE datetime default NULL, - PRIMARY KEY (ID), - KEY EXEC (EXEC) -) COMMENT='here the commands of players are stored'; +DROP TABLE IF EXISTS `COMMAND`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `COMMAND` ( + `ID` mediumint(9) NOT NULL AUTO_INCREMENT, + `GAME` smallint(5) unsigned NOT NULL DEFAULT '0', + `EXEC` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `SUBMIT` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `PLAYER` smallint(5) NOT NULL DEFAULT '0', + `COMMAND` enum('SEND_MSG','MOVE_WITH','PRAY','PRODUCE','FIGHT_EARTHLING','FIGHT_GOD','CH_STATUS','MOVE','BUILD_TEMPLE','CH_ADORING','CH_ACTION','BLESS_PRIEST','BLESS_HERO','DIE_ORDER','MOVE_MTN','INCARNATE','BUILD_ARK','PLAGUE','FLOOD','DESTROY','CH_LUCK') NOT NULL DEFAULT 'CH_STATUS', + `LOCATION` varchar(7) DEFAULT NULL, + `MOBILE` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ARGUMENTS` text NOT NULL, + `ACK` datetime DEFAULT NULL, + `DONE` datetime DEFAULT NULL, + PRIMARY KEY (`ID`), + KEY `EXEC` (`EXEC`) +) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 COMMENT='here the commands of players are stored'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EARTHLING` -- -DROP TABLE IF EXISTS EARTHLING; -CREATE TABLE EARTHLING ( - GAME smallint(6) NOT NULL default '0', - PLAYER smallint(6) NOT NULL default '0', - DYING enum('PKH','PHK','HPK','HKP','KPH','KHP') NOT NULL default 'KHP', - HERO smallint(6) NOT NULL default '0', - PRIMARY KEY (GAME,PLAYER) -) COMMENT='info special for each earthling'; +DROP TABLE IF EXISTS `EARTHLING`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `EARTHLING` ( + `GAME` smallint(6) NOT NULL DEFAULT '0', + `PLAYER` smallint(6) NOT NULL DEFAULT '0', + `DYING` enum('PKH','PHK','HPK','HKP','KPH','KHP') NOT NULL DEFAULT 'KHP', + `HERO` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`GAME`,`PLAYER`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='info special for each earthling'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EVENT` -- -DROP TABLE IF EXISTS EVENT; -CREATE TABLE EVENT ( - ID mediumint(9) unsigned NOT NULL auto_increment, - GAME smallint(6) NOT NULL default '0', - LOCATION char(5) NOT NULL default '', - TAG char(30) NOT NULL default '', - ARG1 char(25) NOT NULL default '', - ARG2 char(25) NOT NULL default '', - ARG3 char(25) NOT NULL default '', - ARG4 char(25) NOT NULL default '', - COMMAND_ID mediumint(9) NOT NULL default '0', - TIME datetime NOT NULL default '0000-00-00 00:00:00', - PRIMARY KEY (ID) -); +DROP TABLE IF EXISTS `EVENT`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `EVENT` ( + `ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT, + `GAME` smallint(6) NOT NULL DEFAULT '0', + `LOCATION` char(5) NOT NULL DEFAULT '', + `TAG` char(30) NOT NULL DEFAULT '', + `ARG1` char(25) NOT NULL DEFAULT '', + `ARG2` char(25) NOT NULL DEFAULT '', + `ARG3` char(25) NOT NULL DEFAULT '', + `ARG4` char(25) NOT NULL DEFAULT '', + `COMMAND_ID` mediumint(9) NOT NULL DEFAULT '0', + `TIME` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + PRIMARY KEY (`ID`) +) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `GAME` -- -DROP TABLE IF EXISTS GAME; -CREATE TABLE GAME ( - GAME smallint(5) unsigned NOT NULL default '0', - NAME varchar(20) NOT NULL default '', - SIZE smallint(5) unsigned NOT NULL default '0', - SPEED int(11) NOT NULL default '1800', - FORTUNE tinyint(3) unsigned NOT NULL default '0', - LAST_TEMPLE varchar(7) NOT NULL default '', - TEMPLE_SIZE smallint(3) unsigned NOT NULL default '1', - START_MANA smallint(5) unsigned NOT NULL default '20', - RUNNING enum('Y','N') NOT NULL default 'Y', - PRIMARY KEY (GAME) -) COMMENT='here some generell global information is stored'; +DROP TABLE IF EXISTS `GAME`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `GAME` ( + `GAME` smallint(5) unsigned NOT NULL DEFAULT '0', + `NAME` varchar(20) NOT NULL DEFAULT '', + `SIZE` smallint(5) unsigned NOT NULL DEFAULT '0', + `SPEED` int(11) NOT NULL DEFAULT '1800', + `FORTUNE` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LAST_TEMPLE` varchar(7) NOT NULL DEFAULT '', + `TEMPLE_SIZE` smallint(3) unsigned NOT NULL DEFAULT '1', + `START_MANA` smallint(5) unsigned NOT NULL DEFAULT '20', + `RUNNING` enum('Y','N') NOT NULL DEFAULT 'Y', + PRIMARY KEY (`GAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='here some generell global information is stored'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `GOD` -- -DROP TABLE IF EXISTS GOD; -CREATE TABLE GOD ( - GAME smallint(5) unsigned NOT NULL default '0', - PLAYER smallint(5) NOT NULL default '0', - MANA smallint(5) unsigned NOT NULL default '0', - DEATH_HERO smallint(5) unsigned NOT NULL default '0', - DEATH_AVATAR smallint(5) unsigned NOT NULL default '0', - ARRIVAL char(7) NOT NULL default '', - PRIMARY KEY (GAME,PLAYER) -) COMMENT='here some god-related stuff is stored'; +DROP TABLE IF EXISTS `GOD`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `GOD` ( + `GAME` smallint(5) unsigned NOT NULL DEFAULT '0', + `PLAYER` smallint(5) NOT NULL DEFAULT '0', + `MANA` smallint(5) unsigned NOT NULL DEFAULT '0', + `DEATH_HERO` smallint(5) unsigned NOT NULL DEFAULT '0', + `DEATH_AVATAR` smallint(5) unsigned NOT NULL DEFAULT '0', + `ARRIVAL` char(7) NOT NULL DEFAULT '', + PRIMARY KEY (`GAME`,`PLAYER`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='here some god-related stuff is stored'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `LOCALIZE` -- -DROP TABLE IF EXISTS LOCALIZE; -CREATE TABLE LOCALIZE ( - TAG varchar(25) NOT NULL default '', - LANGUAGE enum('DE','EN') NOT NULL default 'DE', - TEXT text NOT NULL, - PRIMARY KEY (TAG,LANGUAGE) -); +DROP TABLE IF EXISTS `LOCALIZE`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `LOCALIZE` ( + `TAG` varchar(25) NOT NULL DEFAULT '', + `LANGUAGE` enum('DE','EN') NOT NULL DEFAULT 'DE', + `TEXT` text NOT NULL, + PRIMARY KEY (`TAG`,`LANGUAGE`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `MAP` -- -DROP TABLE IF EXISTS MAP; -CREATE TABLE MAP ( - GAME smallint(6) unsigned NOT NULL default '0', - LOCATION varchar(7) NOT NULL default '', - HOME smallint(6) NOT NULL default '0', - OCCUPANT smallint(6) NOT NULL default '0', - 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, - LAST_PRODUCE timestamp NOT 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) -) COMMENT='This is the main map of the world'; +DROP TABLE IF EXISTS `MAP`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `MAP` ( + `GAME` smallint(6) unsigned NOT NULL DEFAULT '0', + `LOCATION` varchar(7) NOT NULL DEFAULT '', + `HOME` smallint(6) NOT NULL DEFAULT '0', + `OCCUPANT` smallint(6) NOT NULL DEFAULT '0', + `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, + `LAST_PRODUCE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `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`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This is the main map of the world'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `MESSAGE` -- -DROP TABLE IF EXISTS MESSAGE; -CREATE TABLE MESSAGE ( - ID mediumint(8) unsigned NOT NULL auto_increment, - GAME smallint(5) unsigned NOT NULL default '0', - TIME datetime NOT NULL default '0000-00-00 00:00:00', - MFROM smallint(5) NOT NULL default '0', - MTO smallint(5) NOT NULL default '0', - LOCATION varchar(7) NOT NULL default '', - TYPE enum('MESSAGE','ERROR','WARNING') NOT NULL default 'MESSAGE', - MSG_TEXT text NOT NULL, - MSG_TAG varchar(25) NOT NULL default '', - ARG1 varchar(25) NOT NULL default '', - ARG2 varchar(25) NOT NULL default '', - ARG3 varchar(25) NOT NULL default '', - ARG4 varchar(25) NOT NULL default '', - PRIMARY KEY (ID), - KEY TIME (TIME) -) COMMENT='here messages to the players are stored'; +DROP TABLE IF EXISTS `MESSAGE`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `MESSAGE` ( + `ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, + `GAME` smallint(5) unsigned NOT NULL DEFAULT '0', + `TIME` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `MFROM` smallint(5) NOT NULL DEFAULT '0', + `MTO` smallint(5) NOT NULL DEFAULT '0', + `LOCATION` varchar(7) NOT NULL DEFAULT '', + `TYPE` enum('MESSAGE','ERROR','WARNING') NOT NULL DEFAULT 'MESSAGE', + `MSG_TEXT` text NOT NULL, + `MSG_TAG` varchar(25) NOT NULL DEFAULT '', + `ARG1` varchar(25) NOT NULL DEFAULT '', + `ARG2` varchar(25) NOT NULL DEFAULT '', + `ARG3` varchar(25) NOT NULL DEFAULT '', + `ARG4` varchar(25) NOT NULL DEFAULT '', + PRIMARY KEY (`ID`), + KEY `TIME` (`TIME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='here messages to the players are stored'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `MOBILE` -- -DROP TABLE IF EXISTS MOBILE; -CREATE TABLE MOBILE ( - ID mediumint(8) unsigned NOT NULL default '0', - GAME smallint(5) unsigned NOT NULL default '0', - LOCATION char(7) NOT NULL default '', - TYPE enum('WARRIOR','HERO','PRIEST','PROPHET','AVATAR','ARK') NOT NULL default 'WARRIOR', - OWNER smallint(5) NOT NULL default '0', - ADORING smallint(5) unsigned NOT NULL default '0', - COUNT smallint(5) unsigned NOT NULL default '0', - AVAILABLE enum('Y','N') NOT NULL default 'Y', - STATUS enum('BLOCK','HELP','IGNORE') NOT NULL default 'BLOCK', - COMMAND_ID mediumint(9) NOT NULL default '0', - MOVE_WITH mediumint(6) unsigned default '0', - PRIMARY KEY (ID) -) COMMENT='Here all mobile objects are stored'; +DROP TABLE IF EXISTS `MOBILE`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `MOBILE` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `GAME` smallint(5) unsigned NOT NULL DEFAULT '0', + `LOCATION` char(7) NOT NULL DEFAULT '', + `TYPE` enum('WARRIOR','HERO','PRIEST','PROPHET','AVATAR','ARK') NOT NULL DEFAULT 'WARRIOR', + `OWNER` smallint(5) NOT NULL DEFAULT '0', + `ADORING` smallint(5) unsigned NOT NULL DEFAULT '0', + `COUNT` smallint(5) unsigned NOT NULL DEFAULT '0', + `AVAILABLE` enum('Y','N') NOT NULL DEFAULT 'Y', + `STATUS` enum('BLOCK','HELP','IGNORE') NOT NULL DEFAULT 'BLOCK', + `COMMAND_ID` mediumint(9) NOT NULL DEFAULT '0', + `MOVE_WITH` mediumint(6) unsigned DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Here all mobile objects are stored'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PLAYER` -- -DROP TABLE IF EXISTS PLAYER; -CREATE TABLE PLAYER ( - PLAYER smallint(5) NOT NULL default '0', - REALNAME varchar(30) NOT NULL default '', - EMAIL varchar(40) NOT NULL default '', - SECURITY enum('USER','FRIEND','TRUSTED') NOT NULL default 'USER', - DESCRIPTION text NOT NULL, - PICTURE blob NOT NULL, - EARTHLING_SCORE smallint(6) NOT NULL default '0', - GOD_SCORE smallint(6) NOT NULL default '0', - BLOCKED enum('N','Y') NOT NULL default 'N', - LANGUAGE char(2) NOT NULL default '', - LOGIN varchar(20) NOT NULL default '', - PASSWORD varchar(20) NOT NULL default '', - GAMES_PLAYED_EARTHLING smallint(5) unsigned NOT NULL default '0', - GAMES_PLAYED_GOD smallint(5) unsigned NOT NULL default '0', - PRIMARY KEY (PLAYER), - UNIQUE KEY PLAYER (PLAYER), - UNIQUE KEY LOGIN (LOGIN), - UNIQUE KEY EMAIL (EMAIL) -) COMMENT='information for players, which are not related to a game'; +DROP TABLE IF EXISTS `PLAYER`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `PLAYER` ( + `PLAYER` smallint(5) NOT NULL DEFAULT '0', + `REALNAME` varchar(30) NOT NULL DEFAULT '', + `EMAIL` varchar(40) NOT NULL DEFAULT '', + `SECURITY` enum('USER','FRIEND','TRUSTED') NOT NULL DEFAULT 'USER', + `DESCRIPTION` text NOT NULL, + `PICTURE` blob NOT NULL, + `EARTHLING_SCORE` smallint(6) NOT NULL DEFAULT '0', + `GOD_SCORE` smallint(6) NOT NULL DEFAULT '0', + `BLOCKED` enum('N','Y') NOT NULL DEFAULT 'N', + `LANGUAGE` char(2) NOT NULL DEFAULT '', + `LOGIN` varchar(20) NOT NULL DEFAULT '', + `PASSWORD` varchar(20) NOT NULL DEFAULT '', + `GAMES_PLAYED_EARTHLING` smallint(5) unsigned NOT NULL DEFAULT '0', + `GAMES_PLAYED_GOD` smallint(5) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`PLAYER`), + UNIQUE KEY `PLAYER` (`PLAYER`), + UNIQUE KEY `LOGIN` (`LOGIN`), + UNIQUE KEY `EMAIL` (`EMAIL`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='information for players, which are not related to a game'; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ROLE` -- -DROP TABLE IF EXISTS ROLE; -CREATE TABLE ROLE ( - GAME smallint(5) unsigned NOT NULL default '0', - PLAYER smallint(5) NOT NULL default '0', - NICKNAME varchar(20) default NULL, - ROLE enum('OBSERVER','EARTHLING','GOD') NOT NULL default 'EARTHLING', - GENDER enum('MALE','FEMALE','PLURAL') NOT NULL default 'PLURAL', - DESCRIPTION text, - PICTURE blob, - PRIMARY KEY (GAME,PLAYER) -) COMMENT='which player plays which role?'; +DROP TABLE IF EXISTS `ROLE`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ROLE` ( + `GAME` smallint(5) unsigned NOT NULL DEFAULT '0', + `PLAYER` smallint(5) NOT NULL DEFAULT '0', + `NICKNAME` varchar(20) DEFAULT NULL, + `ROLE` enum('OBSERVER','EARTHLING','GOD') NOT NULL DEFAULT 'EARTHLING', + `GENDER` enum('MALE','FEMALE','PLURAL') NOT NULL DEFAULT 'PLURAL', + `DESCRIPTION` text, + `PICTURE` blob, + PRIMARY KEY (`GAME`,`PLAYER`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='which player plays which role?'; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; +-- Dump completed on 2012-09-23 12:14:38