BEGIN
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('the Leader', 3, NEW.`id`);
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Vice-Leader', 2, NEW.`id`);
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member', 1, NEW.`id`);
END
delete from guilds;
ALTER TABLE `guilds` ADD COLUMN `join_date` INT( 11 ) NOT NULL DEFAULT '0';
ingameGuildManagement = true
ingameGuildManagement = true
ingameGuildManagement = false