database patch for trunk

[richlv]

revision 8325 :

alter table items add mtime integer DEFAULT '0' NOT NULL;

[richlv]

revision 8327

alter table hosts add ipmi_error varchar(128) DEFAULT '' NOT NULL;
alter table hosts add snmp_error varchar(128) DEFAULT '' NOT NULL;

[ufocek]

Hi,

I have tested zabbix 1.7.2 rev 8341 and when I add new host I have get error:

# pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/zb172/include/db.inc.php:547]

[richlv]

Hi,

I have tested zabbix 1.7.2 rev 8341 and when I add new host I have get error:

# pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/zb172/include/db.inc.php:547]

please report bugs on the tracker, thanks

[ufocek]

Bug reported - https://support.zabbix.com/browse/ZBX-1325

[richlv]

revision 8396 (branch only, but will be merged soon and won't hurt) :

alter table events drop index events_2;
create index events_2 on events (clock, objectid);

[richlv]

...some revision today

ALTER TABLE sysmaps ADD highlight INTEGER DEFAULT '1' NOT NULL;
alter table sysmaps_links  add label varchar(255) DEFAULT '' NOT NULL;
ALTER TABLE sysmaps_elements ADD iconid_maintenance BIGINT unsigned DEFAULT '0' NOT NULL;

[richlv]

revision 8479

delete from graph_theme where graphthemeid='1';
INSERT INTO graph_theme VALUES (1,'Original Blue','css_ob.css','F0F0F0','FFFFFF','333333','CCCCCC','AAAAAA','000000','222222','AA4444','11CC11','CC1111','E0E0E0',1,1);

[richlv]

revision 8514

alter table graph_theme change column noneworktimecolor noneworktimecolor varchar(6) DEFAULT 'E0E0E0' NOT NULL;