Deu isso agora.
Erro
Comando SQL:
DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN
DELETE FROM
`bans`
WHERE
`type` IN (3, 4)
AND `value` = OLD.`id`; END | CREATE TRIGGER `oncreate_guilds`
AFTER
INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`)
VALUES
('Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`)
VALUES
('Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`)
VALUES
('Member', 1, NEW.`id`); END | CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN
UPDATE
`players`
SET
`guildnick` = '',
`rank_id` = 0
WHERE
`rank_id` IN (
SELECT
`id`
FROM
`guild_ranks`
WHERE
`guild_id` = OLD.`id`
); END | CREATE TRIGGER `oncreate_players`
AFTER
INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills` (`player_id`, `skillid`, `value`)
VALUES
(NEW.`id`, 0, 10); INSERT[...]
Mensagens do MySQL :
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END | CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH RO' at line 5