Triggers

[Xexza]

Clean installation, I uploaded schema.mysql and got this:
Error

SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN ( 1, 2 ) AND `value` = OLD.`id` ;

MySQL said: Documentation
#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 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR ' at line 1



Newest version, everything default.

 

[Xexza]

Server added the triggers when I started it. No need for support