K9DKnmT1

1DROP TABLE IF EXISTS `realmlist`;
2CREATE TABLE `realmlist` (
3  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4  `name` varchar(32) NOT NULL DEFAULT '',
5  `address` varchar(32) NOT NULL DEFAULT '127.0.0.1',
6  `port` int(11) NOT NULL DEFAULT '8085',
7  `icon` tinyint(3) unsigned NOT NULL DEFAULT '0',
8  `realmflags` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT 'Supported masks: 0x1 (invalid, not show in realm list), 0x2 (offline, set by mangosd), 0x4 (show version and build), 0x20 (new players), 0x40 (recommended)',
9  `timezone` tinyint(3) unsigned NOT NULL DEFAULT '0',
10  `allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
11  `population` float unsigned NOT NULL DEFAULT '0',
12  `realmbuilds` varchar(64) NOT NULL DEFAULT '',
13  PRIMARY KEY (`id`),
14  UNIQUE KEY `idx_name` (`name`)
15) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System';