problems with mysql.sql

[Arthur]

The mysql.sql script has some problems:

1: For the pre 1.3 Tables it uses the ID fields the type serial
This is only supported by mysql > 4.1

2: With the older tables it uses bigint or interger for the ID fields
but it does not have the auto_increment option.

So for mysql < 4.1 add the auto_increment option
for >= 4.1 make all ID fields of type serial

Alexei: maybe we can check the the mysql version as well in
the config gui.
and add "if not exists" to the create statements.

rgds
/Arthur

[Arthur]

The files in zabbix-1.3/frontends/php/create
and zabbix-1.3/create/mysql don't match

the file "zabbix.spec" still show's Version: 1.1alpha6