ned help with finishing my SQl

[Newrealots]

i got all the way to the end and i got this problem wheni imported my SQl files...


SQL query:

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 |

MySQL said:

#1465 - Triggers can not be created on system tables


someone please help me

 

[Cronox]

Remove

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` ;


You will get a few more errors after that, remove those lines too

 

[Newrealots]

where are those lines from? i'm noobie at this.

 

[Cronox]

You get .sql or any querys for create database?
for import .sql?

 

[Newrealots]

i'm makin the site for a friend he's hosting when he sent me copy of the ot the ban folder didn't send with it.. i downloaded everything... and done as the tutorial said. i got all the way to import the my sql file... and when i did it gave me that error i posted on top.

 

[Blez]

The real realsoft would know all of this.