mysql 1.3.2 db script

[bobp66]

Hi to all,
I' ve tried to create a new database with the script provided in the create directory.
Script has error related to serial datatype.
Where I can find the correct script?
regards
Roberto

[Alexei]

Where is your error? Give more info please!

[bobp66]

mymonitor:/home/roberto/zabbix-1.3.2/create/mysql# cat schema.sql |mysql -uzabbix -pzabbix zabbix
ERROR 1064 at line 246: 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

Server version: MySQL 4.0.24_Debian-10sarge2-log

[peacestgt]

same here:

ccnagios:/home/uploads/zabbix-1.3.2/create/mysql# cat schema.sql |mysql -u root  -p zabbi                          x
Enter password:
ERROR 1064 at line 246: You have an error in your SQL syntax.  Check the manual that corr                          esponds to your MySQL server version for the right syntax to use near 'serial           ,
        nodeid          bigint unsigned         DEFAULT '0'     NOT NULL,
        ite
ccnagios:/home/uploads/zabbix-1.3.2/create/mysql#

mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)
Server version: Apache/2.0.54

[peacestgt]

the solution is remove serial to "BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE"