1
alter table graphs_items add color varchar(32) DEFAULT 'Dark Green' NOT NULL;
2
alter table sysmaps_hosts add icon varchar(32) DEFAULT 'Server' NOT NULL;
3
alter table alarms add key (triggerid,clock);
4
alter table users modify passwd char(32) default '' not null;
6
alter table hosts add useip int1 DEFAULT '0' NOT NULL;
7
alter table hosts add ip varchar(15) DEFAULT '127.0.0.1' NOT NULL;
9
alter table actions modify message blob default '' not null;
10
alter table alerts modify message blob default '' not null;