SQL to upgrade from 1.5.3 to 1.5.4

[mikecrowe]

Hi folks,

I generated this for 1.5.4 (from 1.5.3). Enjoy!

SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
ALTER TABLE escalations
    ADD r_eventid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER eventid,
    COMMENT='InnoDB free: 11264 kB';


ALTER TABLE events
    DROP INDEX events_3;


ALTER TABLE httpstep
    MODIFY url varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci;
#
#  Fieldformat of
#    httpstep.url changed from varchar(128) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE opconditions
    COMMENT='InnoDB free: 11264 kB';


ALTER TABLE profiles
    ADD idx2 bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER idx,
    ADD value_id bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER idx2,
    ADD value_int int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER value_id,
    ADD value_str varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER value_int,
    ADD type int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER source,
    MODIFY idx varchar(96) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
    [URL="http://74.223.101.213/mysqldiff/index.php?sc=field&table=profiles&field=value&fields%5B%5D=idx2&fields%5B%5D=value_id&fields%5B%5D=value_int&fields%5B%5D=value_str&fields%5B%5D=type"]DROP[/URL] value,
    [URL="http://74.223.101.213/mysqldiff/index.php?sc=field&table=profiles&field=value2&fields%5B%5D=idx2&fields%5B%5D=value_id&fields%5B%5D=value_int&fields%5B%5D=value_str&fields%5B%5D=type"]DROP[/URL] value2,
    MODIFY source varchar(96) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
    [URL="http://74.223.101.213/mysqldiff/index.php?sc=field&table=profiles&field=valuetype&fields%5B%5D=idx2&fields%5B%5D=value_id&fields%5B%5D=value_int&fields%5B%5D=value_str&fields%5B%5D=type"]DROP[/URL] valuetype,
    DROP INDEX profiles_1,
    ADD INDEX profiles_1 (userid, idx, idx2);
#
#  Fieldformats of
#    profiles.idx changed from varchar(64) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(96) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci.
#    profiles.source changed from varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(96) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE proxy_history
    ADD itemid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER id,
    [URL="http://74.223.101.213/mysqldiff/index.php?sc=field&table=proxy_history&field=host&fields%5B%5D=itemid"]DROP[/URL] host,
    [URL="http://74.223.101.213/mysqldiff/index.php?sc=field&table=proxy_history&field=key_&fields%5B%5D=itemid"]DROP[/URL] key_;


ALTER TABLE rights
    DROP type;


ALTER TABLE scripts
    COMMENT='InnoDB free: 11264 kB';


ALTER TABLE sessions
    ADD status int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER lastaccess;


ALTER TABLE sysmaps_elements
    ADD iconid_disabled bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER url;


ALTER TABLE sysmaps_link_triggers
    COMMENT='InnoDB free: 11264 kB';


ALTER TABLE trends_uint
    COMMENT='InnoDB free: 11264 kB';


#
# DDL END
#

SET FOREIGN_KEY_CHECKS = 1;