Add partial support for multiple worlds.

1 files changed, 7 insertions, 0 deletions

diff --git a/main.sql b/main.sql
index 2b8a63a..e15b2f7 100644
--- a/main.sql
+++ b/main.sql
@@ -44,6 +44,13 @@ CREATE TABLE IF NOT EXISTS `player` (
     PRIMARY KEY (`userid`)
 ) ENGINE=MyISAM;
 
+CREATE TABLE IF NOT EXISTS `world` (
+    `userid` INT(11) UNSIGNED NOT NULL DEFAULT 0,
+    `world` VARCHAR(32) NOT NULL DEFAULT '',
+    `status` INT(11) NOT NULL DEFAULT 0,
+    PRIMARY KEY (`userid`,`world`)
+) ENGINE=MyISAM;
+
 CREATE TABLE IF NOT EXISTS `party` (
     `userid` INT(11) UNSIGNED NOT NULL DEFAULT 0,
     `party_id` TINYINT(2) NOT NULL DEFAULT 0,