1.3.2 to 1.3.3 upgrade script

[clahti]

I have make a diff of the stock 1.3.2 and 1.3.3 databases, here is a script to upgrade your 1.3.2 database to 1.3.3. I am pretty sure there are no data content changes to be made, but your mileage may vary. MAKE A BACKUP OF YOUR DATA!! You have been warned

ALTER TABLE `config` ADD `alert_usrgrpid` bigint(20) unsigned NOT NULL default '0';
ALTER TABLE `help_items` MODIFY `key_` varchar(255) NOT NULL default '';
ALTER TABLE `hosts` ADD `dns` varchar(64) NOT NULL default '';
ALTER TABLE `items` MODIFY `key_` varchar(255) NOT NULL default '';
ALTER TABLE `items` MODIFY `prevorgvalue` varchar(255) default NULL;
ALTER TABLE `media_type` ADD `username` varchar(255) NOT NULL default '';
ALTER TABLE `media_type` ADD `passwd` varchar(255) NOT NULL default '';
ALTER TABLE `nodes` DROP COLUMN `events_eventid`;
ALTER TABLE `nodes` DROP COLUMN `alerts_alertid`;

CREATE TABLE `httpstep` (
  `httpstepid` bigint(20) unsigned NOT NULL default '0',
  `httptestid` bigint(20) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `no` int(11) NOT NULL default '0',
  `url` varchar(128) NOT NULL default '',
  `timeout` int(11) NOT NULL default '30',
  `posts` blob NOT NULL,
  `required` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`httpstepid`),
  KEY `httpstep_httpstep_1` (`httptestid`)
);

CREATE TABLE `httpstepitem` (
  `httpstepitemid` bigint(20) unsigned NOT NULL default '0',
  `httpstepid` bigint(20) unsigned NOT NULL default '0',
  `itemid` bigint(20) unsigned NOT NULL default '0',
  `type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`httpstepitemid`),
  UNIQUE KEY `httpstepitem_httpstepitem_1` (`httpstepid`,`itemid`)
);

CREATE TABLE `httptest` (
  `httptestid` bigint(20) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `applicationid` bigint(20) unsigned NOT NULL default '0',
  `lastcheck` int(11) NOT NULL default '0',
  `nextcheck` int(11) NOT NULL default '0',
  `curstate` int(11) NOT NULL default '0',
  `curstep` int(11) NOT NULL default '0',
  `lastfailedstep` bigint(20) unsigned NOT NULL default '0',
  `delay` int(11) NOT NULL default '60',
  `status` int(11) NOT NULL default '0',
  `macros` blob NOT NULL,
  `agent` varchar(255) NOT NULL default '',
  `time` double(16,4) NOT NULL default '0.0000',
  `error` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`httptestid`),
  KEY `httptest_httptest_1` (`httptestid`)
);

CREATE TABLE `httptestitem` (
  `httptestitemid` bigint(20) unsigned NOT NULL default '0',
  `httptestid` bigint(20) unsigned NOT NULL default '0',
  `itemid` bigint(20) unsigned NOT NULL default '0',
  `type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`httptestitemid`),
  UNIQUE KEY `httptestitem_httptestitem_1` (`httptestid`,`itemid`)
);

CREATE TABLE `ids` (
  `nodeid` int(11) NOT NULL default '0',
  `table_name` varchar(64) NOT NULL default '',
  `field_name` varchar(64) NOT NULL default '',
  `nextid` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`nodeid`,`table_name`,`field_name`)
);