3 -- Host: localhost Database: RAGNAROEK
4 -- ------------------------------------------------------
5 -- Server version 4.0.16-log
8 -- Table structure for table `ALLIANCE`
11 DROP TABLE IF EXISTS ALLIANCE;
12 CREATE TABLE ALLIANCE (
13 GAME smallint(5) unsigned NOT NULL default '0',
14 PLAYER smallint(5) NOT NULL default '0',
15 OTHER smallint(5) NOT NULL default '0',
16 STATUS enum('NEUTRAL','ALLIED','FRIEND','FOE','BETRAY') NOT NULL default 'NEUTRAL',
17 PRIMARY KEY (GAME,PLAYER,OTHER)
18 ) COMMENT='friend or foe?';
21 -- Table structure for table `COMMAND`
24 DROP TABLE IF EXISTS COMMAND;
25 CREATE TABLE COMMAND (
26 ID mediumint(9) NOT NULL auto_increment,
27 GAME smallint(5) unsigned NOT NULL default '0',
28 EXEC datetime NOT NULL default '0000-00-00 00:00:00',
29 SUBMIT datetime NOT NULL default '0000-00-00 00:00:00',
30 PLAYER smallint(5) NOT NULL default '0',
31 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',
32 LOCATION varchar(7) default NULL,
33 MOBILE mediumint(8) unsigned NOT NULL default '0',
34 ARGUMENTS text NOT NULL,
35 ACK datetime default NULL,
36 DONE datetime default NULL,
39 ) COMMENT='here the commands of players are stored';
42 -- Table structure for table `EARTHLING`
45 DROP TABLE IF EXISTS EARTHLING;
46 CREATE TABLE EARTHLING (
47 GAME smallint(6) NOT NULL default '0',
48 PLAYER smallint(6) NOT NULL default '0',
49 DYING enum('PKH','PHK','HPK','HKP','KPH','KHP') NOT NULL default 'KHP',
50 HERO smallint(6) NOT NULL default '0',
51 PRIMARY KEY (GAME,PLAYER)
52 ) COMMENT='info special for each earthling';
55 -- Table structure for table `EVENT`
58 DROP TABLE IF EXISTS EVENT;
60 ID mediumint(9) unsigned NOT NULL auto_increment,
61 GAME smallint(6) NOT NULL default '0',
62 LOCATION char(5) NOT NULL default '',
63 TAG char(30) NOT NULL default '',
64 ARG1 char(25) NOT NULL default '',
65 ARG2 char(25) NOT NULL default '',
66 ARG3 char(25) NOT NULL default '',
67 ARG4 char(25) NOT NULL default '',
68 COMMAND_ID mediumint(9) NOT NULL default '0',
69 TIME datetime NOT NULL default '0000-00-00 00:00:00',
74 -- Table structure for table `GAME`
77 DROP TABLE IF EXISTS GAME;
79 GAME smallint(5) unsigned NOT NULL default '0',
80 NAME varchar(20) NOT NULL default '',
81 SIZE smallint(5) unsigned NOT NULL default '0',
82 SPEED int(11) NOT NULL default '1800',
83 FORTUNE tinyint(3) unsigned NOT NULL default '0',
84 LAST_TEMPLE varchar(7) NOT NULL default '',
85 TEMPLE_SIZE smallint(3) unsigned NOT NULL default '1',
86 START_MANA smallint(5) unsigned NOT NULL default '20',
87 RUNNING enum('Y','N') NOT NULL default 'Y',
89 ) COMMENT='here some generell global information is stored';
92 -- Table structure for table `GOD`
95 DROP TABLE IF EXISTS GOD;
97 GAME smallint(5) unsigned NOT NULL default '0',
98 PLAYER smallint(5) NOT NULL default '0',
99 MANA smallint(5) unsigned NOT NULL default '0',
100 DEATH_HERO smallint(5) unsigned NOT NULL default '0',
101 DEATH_AVATAR smallint(5) unsigned NOT NULL default '0',
102 ARRIVAL char(7) NOT NULL default '',
103 PRIMARY KEY (GAME,PLAYER)
104 ) COMMENT='here some god-related stuff is stored';
107 -- Table structure for table `LOCALIZE`
110 DROP TABLE IF EXISTS LOCALIZE;
111 CREATE TABLE LOCALIZE (
112 TAG varchar(25) NOT NULL default '',
113 LANGUAGE enum('DE','EN') NOT NULL default 'DE',
115 PRIMARY KEY (TAG,LANGUAGE)
119 -- Table structure for table `MAP`
122 DROP TABLE IF EXISTS MAP;
124 GAME smallint(6) unsigned NOT NULL default '0',
125 LOCATION varchar(7) NOT NULL default '',
126 HOME smallint(6) NOT NULL default '0',
127 OCCUPANT smallint(6) NOT NULL default '0',
128 TERRAIN enum('PLAIN','WATER','CITY','MOUNTAIN','ISLE','POLE','AYMARGEDDON') NOT NULL default 'PLAIN',
129 TEMPLE enum('Y','N') NOT NULL default 'N',
130 PLAGUE set('PESTILENTIA','INFLUENZA','TUBERCULOSIS') default NULL,
131 LAST_PRODUCE timestamp NOT NULL,
132 ATTACKER smallint(5) unsigned default '0',
133 GOD_ATTACKER smallint(5) unsigned default '0',
134 NAME varchar(20) NOT NULL default '',
135 FLUXLINE set('N','S','SW','NW','SE','NE') NOT NULL default '',
136 PRIMARY KEY (GAME,LOCATION)
137 ) COMMENT='This is the main map of the world';
140 -- Table structure for table `MESSAGE`
143 DROP TABLE IF EXISTS MESSAGE;
144 CREATE TABLE MESSAGE (
145 ID mediumint(8) unsigned NOT NULL auto_increment,
146 GAME smallint(5) unsigned NOT NULL default '0',
147 TIME datetime NOT NULL default '0000-00-00 00:00:00',
148 MFROM smallint(5) NOT NULL default '0',
149 MTO smallint(5) NOT NULL default '0',
150 LOCATION varchar(7) NOT NULL default '',
151 TYPE enum('MESSAGE','ERROR','WARNING') NOT NULL default 'MESSAGE',
152 MSG_TEXT text NOT NULL,
153 MSG_TAG varchar(25) NOT NULL default '',
154 ARG1 varchar(25) NOT NULL default '',
155 ARG2 varchar(25) NOT NULL default '',
156 ARG3 varchar(25) NOT NULL default '',
157 ARG4 varchar(25) NOT NULL default '',
160 ) COMMENT='here messages to the players are stored';
163 -- Table structure for table `MOBILE`
166 DROP TABLE IF EXISTS MOBILE;
167 CREATE TABLE MOBILE (
168 ID mediumint(8) unsigned NOT NULL default '0',
169 GAME smallint(5) unsigned NOT NULL default '0',
170 LOCATION char(7) NOT NULL default '',
171 TYPE enum('WARRIOR','HERO','PRIEST','PROPHET','AVATAR','ARK') NOT NULL default 'WARRIOR',
172 OWNER smallint(5) NOT NULL default '0',
173 ADORING smallint(5) unsigned NOT NULL default '0',
174 COUNT smallint(5) unsigned NOT NULL default '0',
175 AVAILABLE enum('Y','N') NOT NULL default 'Y',
176 STATUS enum('BLOCK','HELP','IGNORE') NOT NULL default 'BLOCK',
177 COMMAND_ID mediumint(9) NOT NULL default '0',
178 MOVE_WITH mediumint(6) unsigned default '0',
180 ) COMMENT='Here all mobile objects are stored';
183 -- Table structure for table `PLAYER`
186 DROP TABLE IF EXISTS PLAYER;
187 CREATE TABLE PLAYER (
188 PLAYER smallint(5) NOT NULL default '0',
189 REALNAME varchar(30) NOT NULL default '',
190 EMAIL varchar(40) NOT NULL default '',
191 SECURITY enum('USER','FRIEND','TRUSTED') NOT NULL default 'USER',
192 DESCRIPTION text NOT NULL,
193 PICTURE blob NOT NULL,
194 EARTHLING_SCORE smallint(6) NOT NULL default '0',
195 GOD_SCORE smallint(6) NOT NULL default '0',
196 BLOCKED enum('N','Y') NOT NULL default 'N',
197 LANGUAGE char(2) NOT NULL default '',
198 LOGIN varchar(20) NOT NULL default '',
199 PASSWORD varchar(20) NOT NULL default '',
200 GAMES_PLAYED_EARTHLING smallint(5) unsigned NOT NULL default '0',
201 GAMES_PLAYED_GOD smallint(5) unsigned NOT NULL default '0',
202 PRIMARY KEY (PLAYER),
203 UNIQUE KEY PLAYER (PLAYER),
204 UNIQUE KEY LOGIN (LOGIN),
205 UNIQUE KEY EMAIL (EMAIL)
206 ) COMMENT='information for players, which are not related to a game';
209 -- Table structure for table `ROLE`
212 DROP TABLE IF EXISTS ROLE;
214 GAME smallint(5) unsigned NOT NULL default '0',
215 PLAYER smallint(5) NOT NULL default '0',
216 NICKNAME varchar(20) default NULL,
217 ROLE enum('OBSERVER','EARTHLING','GOD') NOT NULL default 'EARTHLING',
218 GENDER enum('MALE','FEMALE','PLURAL') NOT NULL default 'PLURAL',
221 PRIMARY KEY (GAME,PLAYER)
222 ) COMMENT='which player plays which role?';