Ad Widget

**mikecrowe** · 15-02-2008, 03:50

DB upgrade instructions for 1.4.4 to 1.5-alpha

Here's what I used to upgrade. I took a schema diff between 1.4.4 and 1.5 nightly (from nightly 2/12/2008).

Enjoy.

Code:

#
# DDL START
#
CREATE TABLE proxies (
    proxyid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
    name varchar(64) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
    lastaccess int(11) NOT NULL DEFAULT '0' COMMENT '',
    PRIMARY KEY (proxyid),
    INDEX proxies_1 (name)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='InnoDB free: 7168 kB';

CREATE TABLE scripts (
    scriptid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
    name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
    command varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
    host_access int(11) NOT NULL DEFAULT '0' COMMENT '',
    PRIMARY KEY (scriptid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='InnoDB free: 7168 kB';

CREATE TABLE sysmaps_link_triggers (
    linkid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
    triggerid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
    drawtype int(11) NOT NULL DEFAULT '0' COMMENT '',
    color varchar(6) NOT NULL DEFAULT '000000' COMMENT '' COLLATE latin1_swedish_ci,
    PRIMARY KEY (linkid, triggerid),
    INDEX sysmaps_link_triggers_1 (linkid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='InnoDB free: 7168 kB';

CREATE TABLE trends_uint (
    itemid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
    clock int(11) NOT NULL DEFAULT '0' COMMENT '',
    num int(11) NOT NULL DEFAULT '0' COMMENT '',
    value_min bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
    value_avg bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
    value_max bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
    PRIMARY KEY (itemid, clock)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='InnoDB free: 7168 kB';

ALTER TABLE config
    ADD event_ack_enable int(11) NOT NULL DEFAULT '1' COMMENT '' AFTER alert_usrgrpid,
    ADD event_expire int(11) NOT NULL DEFAULT '7' COMMENT '' AFTER event_ack_enable,
    ADD event_show_max int(11) NOT NULL DEFAULT '100' COMMENT '' AFTER event_expire,
    ADD default_theme varchar(128) NOT NULL DEFAULT 'default.css' COMMENT '' COLLATE latin1_swedish_ci AFTER event_show_max;


ALTER TABLE dhosts
    MODIFY ip varchar(39) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci;


ALTER TABLE drules
    ADD proxyid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER druleid;


ALTER TABLE events
    DROP INDEX events_1,
    ADD INDEX events_1 (object, objectid, eventid);


ALTER TABLE graphs
    ADD show_legend int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER graphtype,
    ADD show_3d int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER show_legend;


ALTER TABLE hosts
    ADD proxyid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER hostid,
    MODIFY ip varchar(39) NOT NULL DEFAULT '127.0.0.1' COMMENT '' COLLATE latin1_swedish_ci,
    ADD INDEX hosts_3 (proxyid);


ALTER TABLE items_applications
    ADD INDEX items_applications_2 (itemid);


ALTER TABLE node_cksum
    ADD sync char(128) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER cksum,
    DROP cksumid,
    MODIFY nodeid int(11) NOT NULL DEFAULT '0' COMMENT '',
    DROP fieldname,
    MODIFY cksum text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
    DROP PRIMARY KEY,
    DROP INDEX node_cksum_cksum_1,
    ADD INDEX node_cksum_cksum_1 (nodeid, tablename, recordid, cksumtype);

DROP TABLE node_configlog;

ALTER TABLE nodes
    MODIFY ip varchar(39) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
    DROP event_lastid,
    DROP history_lastid,
    DROP history_str_lastid,
    DROP history_uint_lastid;

ALTER TABLE screens_items
    ADD dynamic int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER url;


ALTER TABLE sysmaps_links
    ADD drawtype int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER selementid2,
    ADD color varchar(6) NOT NULL DEFAULT '000000' COMMENT '' COLLATE latin1_swedish_ci AFTER drawtype,
    DROP triggerid,
    DROP drawtype_off,
    DROP color_off,
    DROP drawtype_on,
    DROP color_on;


ALTER TABLE triggers
    ADD type int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER templateid,
    MODIFY comments blob NOT NULL DEFAULT '' COMMENT '';

ALTER TABLE users
    ADD theme varchar(128) NOT NULL DEFAULT 'default.css' COMMENT '' COLLATE latin1_swedish_ci AFTER type;


ALTER TABLE usrgrp
    ADD gui_access int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER name,
    ADD users_status int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER gui_access;


#
# DDL END
#

Ad Widget

Cannot Upgrade MySQLDatabase from 1.4.4 to 1.5

Cannot Upgrade MySQLDatabase from 1.4.4 to 1.5

Comment