Arianne

Marauroa Database Structure: Difference between revisions

← Older editNewer edit →
Content deleted Content added
VisualWikitext
imported>MartinFuchs
update to the current Stendhal database schema
imported>MartinFuchs
Line 6:
This are the tables of the Stendhal database schema:
<pre>
Table account (InnoDB)
+----------+------------------------------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
Line 18:
+----------+------------------------------------+------+-----+-------------------+----------------+
 
Table banlist (InnoDB)
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
Line 28:
+---------+--------------+------+-----+---------+----------------+
 
Table characters (InnoDB)
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
Line 37:
+-----------+-------------+------+-----+---------+-------+
 
Table character_stats (MyISAM)
+----------+--------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
Line 65:
+----------+--------------+------+-----+-------------------+-------+
 
Table gameevents (InnoDB)
+----------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
Line 77:
+----------+--------------+------+-----+-------------------+----------------+
 
Table itemidhalloffame (MyISAM)
+----------+-------------+------+-----+---------+----------------+▼
| Field | Type | Null | Key | Default | Extra |▼
+----------+-------------+------+-----+---------+----------------+▼
| dataid | blob | int(11) | YESNO | PRI | NULL | auto_increment |▼
| zone_idcharname | varchar(32) | NO | PRI | | |▼
| fametype | char(1) | NO | | | |
| points | int(11) | NO | | | |
+----------+-------------+------+-----+---------+----------------+▼
 
Table itemid (MyISAM)
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
Line 84 ⟶ 94:
+---------+---------+------+-----+---------+-------+
 
Table itemlog (MyISAM)
+----------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
Line 99 ⟶ 109:
+----------+-------------+------+-----+-------------------+----------------+
 
Table rpobjectloginevent (InnoDB)
+-----------+-------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+-------------------+-------+
| player_id | int(11) | NO | | | |
| address | varchar(64) | YES | | NULL | |
| timedate | timestamp | NO | | CURRENT_TIMESTAMP | |
| result | tinyint(4) | YES | | NULL | |
+-----------+-------------+------+-----+-------------------+-------+
 
Table rpobject (InnoDB)
+-----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
Line 107 ⟶ 127:
+-----------+---------+------+-----+---------+----------------+
 
Table statisticsrpzone (InnoDB)
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| zone_id | varchar(32) | NO | PRI | | |
| data | blob | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
 
Table statistics (InnoDB)
+-----------------+-----------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
Line 119 ⟶ 147:
| players_online | int(11) | YES | | NULL | |
+-----------------+-----------+------+-----+-------------------+-------+
 
Table rpzone
▲+---------+-------------+------+-----+---------+-------+
▲| Field | Type | Null | Key | Default | Extra |
▲+---------+-------------+------+-----+---------+-------+
▲| zone_id | varchar(32) | NO | PRI | | |
▲| data | blob | YES | | NULL | |
▲+---------+-------------+------+-----+---------+-------+
 
Important tables which store original data, use the InnoDB engine. Tables with redundant data for easy access and logging use the MyISAM table type.
Line 153 ⟶ 173:
* ''jdbc_class'': This field tells the engine what Driver to use for database access. Please refer to your software manual to see the multiple options.
* ''jdbc_url'': This points to the type and source of the information, for MySQL the string must be as follows:
** '''jdbc:mysql://ip:database_name/'''
* ''jdbc_user'': This is the username for the database
* ''jdbc_pwd'': This is the password for that username in the database.
Retrieved from "https://meet.konsthol.eu/w/index.php?title=Marauroa_Database_Structure"