w3e6kdtV

1CREATE TABLE IF NOT EXISTS `guildpack_guilds` (
2  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
3  `guild_name` VARCHAR(24) NOT NULL DEFAULT '',
4  `master_char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
5  `master_name` VARCHAR(24) NOT NULL DEFAULT '',
6  `redeem_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
7  PRIMARY KEY  (`guild_id`)
8) ENGINE=MYISAM;
9
10CREATE TABLE IF NOT EXISTS `guildpack_members` (
11  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
12  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
13  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
14  `name` VARCHAR(30) NOT NULL DEFAULT '',
15  `ip` VARCHAR(15) NOT NULL DEFAULT '',
16  `mac` VARCHAR(17) NOT NULL DEFAULT '',
17  PRIMARY KEY  (`guild_id`,`char_id`),
18  KEY `guild_id` (`guild_id`)
19) ENGINE=MYISAM;