Schema.sql Errors

[ssullivan]

Zabbix 1.3
Os: Debian:
Mysql:4.0.24_Debian-10sarge2-log

Here is the error I get.
cat schema.sql | mysql -u(username) -p(password) zabbix
ERROR 1064 at line 245: 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 'serial ,
nodeid bigint unsigned DEFAULT '0' NOT NULL,
ite


Can anybody help?

[brick]

http://dev.mysql.com/doc/refman/5.0/...-overview.html

so, just replace "SERIAL" with "BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE"