PDA

View Full Version : Correction schema.sql


erisan500
21-05-2006, 18:28
There is a small mistake in the schema.sql file.
The description field in the help-items table is limited to 255 characters, while line 131 in data.sql contains a description of more then 300 characters (i counted them but forgot the exact number).

I don't know if mysql4 complains when cat-ing data.sql but mysql5 surely complains about line 131.

To solve this, change the file schema.sql (at the end) from:

CREATE TABLE help_items (
itemtype int(4) DEFAULT '0' NOT NULL,
key_ varchar(64) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (itemtype, key_)
) type=InnoDB;

to:

CREATE TABLE help_items (
itemtype int(4) DEFAULT '0' NOT NULL,
key_ varchar(64) DEFAULT '' NOT NULL,
description varchar(500) DEFAULT '' NOT NULL,
PRIMARY KEY (itemtype, key_)
) type=InnoDB;

I put 500 so there's rome enough for future long descriptions.

Greetings

perico
21-05-2006, 19:21
Hi I made some corrections on the postgres script.

I didn't test the functionality of Zabbix itself, but I hope it makes things easier

cheers,
Peter