mysql error

[zabbixtester]

mysql-server-5.0.27-1.fc6



mysql> use zabbix;
Database changed
mysql> CREATE TABLE slideshows (
-> slideshowidbigint unsignedDEFAULT '0'NOT NULL,
-> namevarchar(255)DEFAULT ''NOT NULL,
-> delayintegerDEFAULT '0'NOT NULL,
-> PRIMARY KEY (slideshowid)
-> ) type=InnoDB;
ERROR 1064 (42000): 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 'unsignedDEFAULT '0'NOT NULL,
namevarchar(255)DEFAULT ''NOT NULL,
delayintegerDEF' at line 2
mysql>


mysql> CREATE TABLE dhosts (
-> dhostidbigint unsignedDEFAULT '0'NOT NULL,
-> druleidbigint unsignedDEFAULT '0'NOT NULL,
-> ipvarchar(15)DEFAULT ''NOT NULL,
-> statusintegerDEFAULT '0'NOT NULL,
-> lastupintegerDEFAULT '0'NOT NULL,
-> lastdownintegerDEFAULT '0'NOT NULL,
-> PRIMARY KEY (dhostid)
-> ) type=InnoDB;
ERROR 1064 (42000): 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 'unsignedDEFAULT '0'NOT NULL,
druleidbigint unsignedDEFAULT '0'NOT NULL,
ipvarcha' at line 2
mysql>


Does anyhone have a mysql file for use with fedora core 6?

Regards,