Well, I accidentally deleted a table, it had some triggers associated with it. How do I "restore" the triggers? Thanks in advance.

PHP Code:
CREATE TABLE `guilds`
(
    `
idINT NOT NULL AUTO_INCREMENT,
    `
nameVARCHAR(255NOT NULL COMMENT 'guild name - nothing else needed here',
    `
owneridINT NOT NULL,
    `
creationdataINT NOT NULL,
    `
motdVARCHAR(255NOT NULL,
    
PRIMARY KEY (`id`)
ENGINE InnoDB;

CREATE TABLE `guild_invites`
(
    `
player_idINT UNSIGNED NOT NULL DEFAULT 0,
    `
guild_idINT UNSIGNED NOT NULL DEFAULT 0
ENGINE InnoDB;

CREATE TABLE `guild_ranks`
(
    `
idINT NOT NULL AUTO_INCREMENT,
    `
guild_idINT NOT NULL COMMENT 'guild',
    `
nameVARCHAR(255NOT NULL COMMENT 'rank name',
    `
levelINT NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else',
    
PRIMARY KEY (`id`),
    
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
ENGINE InnoDB
And the triggers
PHP Code:
CREATE TRIGGER `ondelete_guilds`
BEFORE DELETE
ON 
`guilds`
FOR 
EACH ROW
BEGIN
    UPDATE 
`playersSET `guildnick` = '', `rank_id` = 0 WHERE `rank_idIN (SELECT `idFROM `guild_ranksWHERE `guild_id` = OLD.`id`);
END|

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`);
    
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member'1, NEW.`id`);
END
When I try to type in the trigger in mySQL, it gives me
#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 '' at line 6 -- Line 6 refers to the line that begins with INSERT INTO `guild_ranks` ( `name` , `level` , `guild_id` )
[/code]