-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 */;