DROP TRIGGER IF EXISTS oncreate_guilds;
CREATE TRIGGER oncreate_guilds AFTER INSERT ON guilds
FOR EACH ROW 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)...