2004.06.01  v0.16cvs  balleman
  ALTER TABLE `graphs` ADD `max` INT, ADD `min` INT;

2004.05.25  v0.16cvs  balleman
  ALTER TABLE `devices` ADD `no_snmp_uptime_check` TINYINT DEFAULT '0' NOT NULL ;
  ALTER TABLE `tests_snmp` ADD `type` TINYINT DEFAULT '0' NOT NULL , ADD `subitem` INT DEFAULT '0' NOT NULL ;

2004.03.10  v0.14cvs  silfreed
  ALTER TABLE user DROP INDEX user;
  ALTER TABLE user ADD CONSTRAINT UNIQUE user (user);

2004.01.05  v0.13  balleman
  CREATE TABLE `log` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `date` DATETIME NOT NULL,
    `dev_id` INT,
    `subdev_id` INT,
    `mon_id` INT,
    `level` INT NOT NULL ,
    `component` INT NOT NULL ,
    `message` VARCHAR( 200 ) NOT NULL ,
    PRIMARY KEY ( `id` ) , INDEX ( `date` ) ,
    INDEX ( `dev_id` ), INDEX ( `subdev_id` ) , INDEX( `mon_id` ));

2004.01.04  v0.13  balleman
  ALTER TABLE `devices` ADD `snmp_recache_method` SMALLINT DEFAULT '0' NOT NULL AFTER `dev_type`;
  UPDATE devices SET snmp_recache_method = 4 WHERE snmp_recache = 1;
  UPDATE devices SET snmp_recache_method = 3 WHERE snmp_recache = 0 AND snmp_check_ifnumber = 1;
  UPDATE devices SET snmp_recache_method = 1 WHERE snmp_recache = 0 AND snmp_check_ifnumber = 0;
  ALTER TABLE `devices` DROP `snmp_recache`;
  ALTER TABLE `devices` DROP `snmp_check_ifnumber`;

2003.11.24  v0.10  silfreed
  INSERT INTO user_prefs (uid, module, pref, value) SELECT id, "SlideShow", "AutoScroll", 1 FROM user;

2003.11.20  v0.10  silfreed
  CREATE TABLE user_prefs (
    id INT NOT NULL AUTO_INCREMENT, uid INT NOT NULL,
    module VARCHAR(64) NOT NULL, pref VARCHAR(64) NOT NULL,
    value VARCHAR(64) NOT NULL,
    PRIMARY KEY (id),
    KEY uid (uid),
    KEY uid_module_pref (uid, module, pref));

2003.10.14  v0.10  balleman
  ALTER TABLE `devices` CHANGE `snmp_enabled` `snmp_version` TINYINT( 4 ) DEFAULT '1' NOT NULL ;
  ALTER TABLE `devices` ADD `snmp_timeout` INT UNSIGNED DEFAULT '1000000' NOT NULL AFTER `snmp_version` ,
  ADD `snmp_retries` TINYINT UNSIGNED DEFAULT '3' NOT NULL AFTER `snmp_timeout` ,
  ADD `snmp_port` SMALLINT UNSIGNED DEFAULT '161' NOT NULL AFTER `snmp_retries` ;

2003.09.13  v0.10pre1  balleman
  ALTER TABLE `graphs` ADD `options` SET( 'nolegend', 'logarithmic' ) NOT NULL ;
  ALTER TABLE `graphs` ADD `base` INT DEFAULT '1000' NOT NULL ;

2003.09.06  v0.10pre1  balleman
  ALTER TABLE `graph_ds` ADD `start_time` VARCHAR( 20 ) NOT NULL ;
  ALTER TABLE `graph_ds` ADD `end_time` VARCHAR( 20 ) NOT NULL ;

2003.08.29  v0.10pre1  balleman
  ALTER TABLE `graphs` ADD `title` VARCHAR( 100 ) NOT NULL AFTER `name`;
  ALTER TABLE `graph_ds` CHANGE `multiplier` `multiplier` VARCHAR( 100 ) DEFAULT '1' NOT NULL;

2003.08.05  v0.10pre1  balleman
  ALTER TABLE snmp_interface_cache ADD COLUMN ifSpeed int(11) NOT NULL;
