1 -- MySQL dump 10.13 Distrib 5.5.24, for debian-linux-gnu (x86_64)
3 -- Host: localhost Database: RAGNAROEK
4 -- ------------------------------------------------------
5 -- Server version 5.5.24-0ubuntu0.12.04.1
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19 -- Table structure for table `ALLIANCE`
22 DROP TABLE IF EXISTS `ALLIANCE`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `ALLIANCE` (
26 `GAME` smallint(5) unsigned NOT NULL DEFAULT '0',
27 `PLAYER` smallint(5) NOT NULL DEFAULT '0',
28 `OTHER` smallint(5) NOT NULL DEFAULT '0',
29 `STATUS` enum('NEUTRAL','ALLIED','FRIEND','FOE','BETRAY') NOT NULL DEFAULT 'NEUTRAL',
30 PRIMARY KEY (`GAME`,`PLAYER`,`OTHER`)
31 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='friend or foe?';
32 /*!40101 SET character_set_client = @saved_cs_client */;
35 -- Table structure for table `COMMAND`
38 DROP TABLE IF EXISTS `COMMAND`;
39 /*!40101 SET @saved_cs_client = @@character_set_client */;
40 /*!40101 SET character_set_client = utf8 */;
41 CREATE TABLE `COMMAND` (
42 `ID` mediumint(9) NOT NULL AUTO_INCREMENT,
43 `GAME` smallint(5) unsigned NOT NULL DEFAULT '0',
44 `EXEC` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
45 `SUBMIT` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
46 `PLAYER` smallint(5) NOT NULL DEFAULT '0',
47 `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',
48 `LOCATION` varchar(7) DEFAULT NULL,
49 `MOBILE` mediumint(8) unsigned NOT NULL DEFAULT '0',
50 `ARGUMENTS` text NOT NULL,
51 `ACK` datetime DEFAULT NULL,
52 `DONE` datetime DEFAULT NULL,
55 ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 COMMENT='here the commands of players are stored';
56 /*!40101 SET character_set_client = @saved_cs_client */;
59 -- Table structure for table `EARTHLING`
62 DROP TABLE IF EXISTS `EARTHLING`;
63 /*!40101 SET @saved_cs_client = @@character_set_client */;
64 /*!40101 SET character_set_client = utf8 */;
65 CREATE TABLE `EARTHLING` (
66 `GAME` smallint(6) NOT NULL DEFAULT '0',
67 `PLAYER` smallint(6) NOT NULL DEFAULT '0',
68 `DYING` enum('PKH','PHK','HPK','HKP','KPH','KHP') NOT NULL DEFAULT 'KHP',
69 `HERO` smallint(6) NOT NULL DEFAULT '0',
70 PRIMARY KEY (`GAME`,`PLAYER`)
71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='info special for each earthling';
72 /*!40101 SET character_set_client = @saved_cs_client */;
75 -- Table structure for table `EVENT`
78 DROP TABLE IF EXISTS `EVENT`;
79 /*!40101 SET @saved_cs_client = @@character_set_client */;
80 /*!40101 SET character_set_client = utf8 */;
81 CREATE TABLE `EVENT` (
82 `ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
83 `GAME` smallint(6) NOT NULL DEFAULT '0',
84 `LOCATION` char(5) NOT NULL DEFAULT '',
85 `TAG` char(30) NOT NULL DEFAULT '',
86 `ARG1` char(25) NOT NULL DEFAULT '',
87 `ARG2` char(25) NOT NULL DEFAULT '',
88 `ARG3` char(25) NOT NULL DEFAULT '',
89 `ARG4` char(25) NOT NULL DEFAULT '',
90 `COMMAND_ID` mediumint(9) NOT NULL DEFAULT '0',
91 `TIME` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
93 ) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
94 /*!40101 SET character_set_client = @saved_cs_client */;
97 -- Table structure for table `GAME`
100 DROP TABLE IF EXISTS `GAME`;
101 /*!40101 SET @saved_cs_client = @@character_set_client */;
102 /*!40101 SET character_set_client = utf8 */;
103 CREATE TABLE `GAME` (
104 `GAME` smallint(5) unsigned NOT NULL DEFAULT '0',
105 `NAME` varchar(20) NOT NULL DEFAULT '',
106 `SIZE` smallint(5) unsigned NOT NULL DEFAULT '0',
107 `SPEED` int(11) NOT NULL DEFAULT '1800',
108 `FORTUNE` tinyint(3) unsigned NOT NULL DEFAULT '0',
109 `LAST_TEMPLE` varchar(7) NOT NULL DEFAULT '',
110 `TEMPLE_SIZE` smallint(3) unsigned NOT NULL DEFAULT '1',
111 `START_MANA` smallint(5) unsigned NOT NULL DEFAULT '20',
112 `RUNNING` enum('Y','N') NOT NULL DEFAULT 'Y',
114 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='here some generell global information is stored';
115 /*!40101 SET character_set_client = @saved_cs_client */;
118 -- Table structure for table `GOD`
121 DROP TABLE IF EXISTS `GOD`;
122 /*!40101 SET @saved_cs_client = @@character_set_client */;
123 /*!40101 SET character_set_client = utf8 */;
125 `GAME` smallint(5) unsigned NOT NULL DEFAULT '0',
126 `PLAYER` smallint(5) NOT NULL DEFAULT '0',
127 `MANA` smallint(5) unsigned NOT NULL DEFAULT '0',
128 `DEATH_HERO` smallint(5) unsigned NOT NULL DEFAULT '0',
129 `DEATH_AVATAR` smallint(5) unsigned NOT NULL DEFAULT '0',
130 `ARRIVAL` char(7) NOT NULL DEFAULT '',
131 PRIMARY KEY (`GAME`,`PLAYER`)
132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='here some god-related stuff is stored';
133 /*!40101 SET character_set_client = @saved_cs_client */;
136 -- Table structure for table `LOCALIZE`
139 DROP TABLE IF EXISTS `LOCALIZE`;
140 /*!40101 SET @saved_cs_client = @@character_set_client */;
141 /*!40101 SET character_set_client = utf8 */;
142 CREATE TABLE `LOCALIZE` (
143 `TAG` varchar(25) NOT NULL DEFAULT '',
144 `LANGUAGE` enum('DE','EN') NOT NULL DEFAULT 'DE',
145 `TEXT` text NOT NULL,
146 PRIMARY KEY (`TAG`,`LANGUAGE`)
147 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
148 /*!40101 SET character_set_client = @saved_cs_client */;
151 -- Table structure for table `MAP`
154 DROP TABLE IF EXISTS `MAP`;
155 /*!40101 SET @saved_cs_client = @@character_set_client */;
156 /*!40101 SET character_set_client = utf8 */;
158 `GAME` smallint(6) unsigned NOT NULL DEFAULT '0',
159 `LOCATION` varchar(7) NOT NULL DEFAULT '',
160 `HOME` smallint(6) NOT NULL DEFAULT '0',
161 `OCCUPANT` smallint(6) NOT NULL DEFAULT '0',
162 `TERRAIN` enum('PLAIN','WATER','CITY','MOUNTAIN','ISLE','POLE','AYMARGEDDON') NOT NULL DEFAULT 'PLAIN',
163 `TEMPLE` enum('Y','N') NOT NULL DEFAULT 'N',
164 `PLAGUE` set('PESTILENTIA','INFLUENZA','TUBERCULOSIS') DEFAULT NULL,
165 `LAST_PRODUCE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
166 `ATTACKER` smallint(5) unsigned DEFAULT '0',
167 `GOD_ATTACKER` smallint(5) unsigned DEFAULT '0',
168 `NAME` varchar(20) NOT NULL DEFAULT '',
169 `FLUXLINE` set('N','S','SW','NW','SE','NE') NOT NULL DEFAULT '',
170 PRIMARY KEY (`GAME`,`LOCATION`)
171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This is the main map of the world';
172 /*!40101 SET character_set_client = @saved_cs_client */;
175 -- Table structure for table `MESSAGE`
178 DROP TABLE IF EXISTS `MESSAGE`;
179 /*!40101 SET @saved_cs_client = @@character_set_client */;
180 /*!40101 SET character_set_client = utf8 */;
181 CREATE TABLE `MESSAGE` (
182 `ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
183 `GAME` smallint(5) unsigned NOT NULL DEFAULT '0',
184 `TIME` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
185 `MFROM` smallint(5) NOT NULL DEFAULT '0',
186 `MTO` smallint(5) NOT NULL DEFAULT '0',
187 `LOCATION` varchar(7) NOT NULL DEFAULT '',
188 `TYPE` enum('MESSAGE','ERROR','WARNING') NOT NULL DEFAULT 'MESSAGE',
189 `MSG_TEXT` text NOT NULL,
190 `MSG_TAG` varchar(25) NOT NULL DEFAULT '',
191 `ARG1` varchar(25) NOT NULL DEFAULT '',
192 `ARG2` varchar(25) NOT NULL DEFAULT '',
193 `ARG3` varchar(25) NOT NULL DEFAULT '',
194 `ARG4` varchar(25) NOT NULL DEFAULT '',
197 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='here messages to the players are stored';
198 /*!40101 SET character_set_client = @saved_cs_client */;
201 -- Table structure for table `MOBILE`
204 DROP TABLE IF EXISTS `MOBILE`;
205 /*!40101 SET @saved_cs_client = @@character_set_client */;
206 /*!40101 SET character_set_client = utf8 */;
207 CREATE TABLE `MOBILE` (
208 `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
209 `GAME` smallint(5) unsigned NOT NULL DEFAULT '0',
210 `LOCATION` char(7) NOT NULL DEFAULT '',
211 `TYPE` enum('WARRIOR','HERO','PRIEST','PROPHET','AVATAR','ARK') NOT NULL DEFAULT 'WARRIOR',
212 `OWNER` smallint(5) NOT NULL DEFAULT '0',
213 `ADORING` smallint(5) unsigned NOT NULL DEFAULT '0',
214 `COUNT` smallint(5) unsigned NOT NULL DEFAULT '0',
215 `AVAILABLE` enum('Y','N') NOT NULL DEFAULT 'Y',
216 `STATUS` enum('BLOCK','HELP','IGNORE') NOT NULL DEFAULT 'BLOCK',
217 `COMMAND_ID` mediumint(9) NOT NULL DEFAULT '0',
218 `MOVE_WITH` mediumint(6) unsigned DEFAULT '0',
220 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Here all mobile objects are stored';
221 /*!40101 SET character_set_client = @saved_cs_client */;
224 -- Table structure for table `PLAYER`
227 DROP TABLE IF EXISTS `PLAYER`;
228 /*!40101 SET @saved_cs_client = @@character_set_client */;
229 /*!40101 SET character_set_client = utf8 */;
230 CREATE TABLE `PLAYER` (
231 `PLAYER` smallint(5) NOT NULL DEFAULT '0',
232 `REALNAME` varchar(30) NOT NULL DEFAULT '',
233 `EMAIL` varchar(40) NOT NULL DEFAULT '',
234 `SECURITY` enum('USER','FRIEND','TRUSTED') NOT NULL DEFAULT 'USER',
235 `DESCRIPTION` text NOT NULL,
236 `PICTURE` blob NOT NULL,
237 `EARTHLING_SCORE` smallint(6) NOT NULL DEFAULT '0',
238 `GOD_SCORE` smallint(6) NOT NULL DEFAULT '0',
239 `BLOCKED` enum('N','Y') NOT NULL DEFAULT 'N',
240 `LANGUAGE` char(2) NOT NULL DEFAULT '',
241 `LOGIN` varchar(20) NOT NULL DEFAULT '',
242 `PASSWORD` varchar(20) NOT NULL DEFAULT '',
243 `GAMES_PLAYED_EARTHLING` smallint(5) unsigned NOT NULL DEFAULT '0',
244 `GAMES_PLAYED_GOD` smallint(5) unsigned NOT NULL DEFAULT '0',
245 PRIMARY KEY (`PLAYER`),
246 UNIQUE KEY `PLAYER` (`PLAYER`),
247 UNIQUE KEY `LOGIN` (`LOGIN`),
248 UNIQUE KEY `EMAIL` (`EMAIL`)
249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='information for players, which are not related to a game';
250 /*!40101 SET character_set_client = @saved_cs_client */;
253 -- Table structure for table `ROLE`
256 DROP TABLE IF EXISTS `ROLE`;
257 /*!40101 SET @saved_cs_client = @@character_set_client */;
258 /*!40101 SET character_set_client = utf8 */;
259 CREATE TABLE `ROLE` (
260 `GAME` smallint(5) unsigned NOT NULL DEFAULT '0',
261 `PLAYER` smallint(5) NOT NULL DEFAULT '0',
262 `NICKNAME` varchar(20) DEFAULT NULL,
263 `ROLE` enum('OBSERVER','EARTHLING','GOD') NOT NULL DEFAULT 'EARTHLING',
264 `GENDER` enum('MALE','FEMALE','PLURAL') NOT NULL DEFAULT 'PLURAL',
267 PRIMARY KEY (`GAME`,`PLAYER`)
268 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='which player plays which role?';
269 /*!40101 SET character_set_client = @saved_cs_client */;
270 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
272 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
273 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
274 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
275 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
276 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
277 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
278 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
280 -- Dump completed on 2012-09-23 12:14:38