diff options
Diffstat (limited to 'sql/realmd.sql')
| -rw-r--r-- | sql/realmd.sql | 27 |
1 files changed, 17 insertions, 10 deletions
diff --git a/sql/realmd.sql b/sql/realmd.sql index d60d88c434e..2f4ea16d172 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -2,7 +2,7 @@ -- -- Host: localhost Database: realmd -- ------------------------------------------------------ --- Server version 5.0.34-log +-- Server version 5.0.45-Debian_1ubuntu3.1-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -22,13 +22,13 @@ DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( `id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier', - `username` varchar(32) NOT NULL, + `username` varchar(32) NOT NULL default '', `sha_pass_hash` varchar(40) NOT NULL default '', `gmlevel` tinyint(3) unsigned NOT NULL default '0', `sessionkey` longtext, `v` longtext, `s` longtext, - `email` varchar(320) NOT NULL default '', + `email` text, `joindate` timestamp NOT NULL default CURRENT_TIMESTAMP, `last_ip` varchar(30) NOT NULL default '127.0.0.1', `failed_logins` int(11) unsigned NOT NULL default '0', @@ -41,7 +41,7 @@ CREATE TABLE `account` ( PRIMARY KEY (`id`), UNIQUE KEY `idx_username` (`username`), KEY `idx_gmlevel` (`gmlevel`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System'; +) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC COMMENT='Account System'; -- -- Dumping data for table `account` @@ -49,6 +49,11 @@ CREATE TABLE `account` ( LOCK TABLES `account` WRITE; /*!40000 ALTER TABLE `account` DISABLE KEYS */; +/*INSERT INTO `account` VALUES +(1,'ADMINISTRATOR','a34b29541b87b7e4823683ce6c7bf6ae68beaaac',3,'','0','0','','2006-04-25 10:18:56','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0), +(2,'GAMEMASTER','7841e21831d7c6bc0b57fbe7151eb82bd65ea1f9',2,'','0','0','','2006-04-25 10:18:56','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0), +(3,'MODERATOR','a7f5fbff0b4eec2d6b6e78e38e8312e64d700008',1,'','0','0','','2006-04-25 10:19:35','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0), +(4,'PLAYER','3ce8a96d17c5ae88a30681024e86279f1a38c041',0,'','0','0','','2006-04-25 10:19:35','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0);*/ /*!40000 ALTER TABLE `account` ENABLE KEYS */; UNLOCK TABLES; @@ -83,11 +88,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `ip_banned`; CREATE TABLE `ip_banned` ( `ip` varchar(32) NOT NULL default '127.0.0.1', - `bandate` int(11) NOT NULL, - `unbandate` int(11) NOT NULL, + `bandate` bigint(40) NOT NULL, + `unbandate` bigint(40) NOT NULL, `bannedby` varchar(50) NOT NULL default '[Console]', - `banreason` varchar(50) NOT NULL default 'no reason', - PRIMARY KEY (`ip`) + `banreason` varchar(255) NOT NULL default 'no reason', + PRIMARY KEY (`ip`,`bandate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Banned IPs'; -- @@ -137,7 +142,7 @@ CREATE TABLE `realmlist` ( `population` float unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System'; +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System'; -- -- Dumping data for table `realmlist` @@ -145,6 +150,8 @@ CREATE TABLE `realmlist` ( LOCK TABLES `realmlist` WRITE; /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */; +INSERT INTO `realmlist` VALUES +(1,'Trinity','127.0.0.1',8085,1,0,1,0,0); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -157,4 +164,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2008-10-14 13:28:11 +-- Dump completed on 2008-01-10 11:37:06 |