File: update-from-0.17.sql

package info (click to toggle)
netmrg 0.20-2.1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 2,820 kB
  • ctags: 2,009
  • sloc: php: 9,401; sh: 4,597; cpp: 2,898; perl: 621; ansic: 381; makefile: 331; xml: 92; sql: 71; sed: 16
file content (40 lines) | stat: -rw-r--r-- 2,773 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
ALTER TABLE `graph_ds` CHANGE `stats` `stats` SET( 'CURRENT', 'AVERAGE', 'MAXIMUM', 'SUMS', 'INTEGER', 'MULTSUM' ) DEFAULT 'CURRENT,AVERAGE,MAXIMUM' NOT NULL ;
-- INSERT INTO updates SET update_version = '0.18.1', name = 'Graph Multiply Sum Support', version_applied_to = 'pre-0.17', dateapplied = now();

INSERT INTO tests_internal VALUES (7,'SNMP Failure');
-- INSERT INTO updates SET update_version = '0.18.1', name = 'New Internal Test - SNMP Failure', version_applied_to = 'pre-0.17', dateapplied = now();

ALTER TABLE `tests_sql` ADD `timeout` INT DEFAULT '10' NOT NULL ;
-- INSERT INTO updates SET update_version = '0.18.1', name = 'SQL Test Timeout', version_applied_to = 'pre-0.17', dateapplied = now();

UPDATE `versioninfo` set version = '0.18.1' where module = 'Main';

-- Update to 0.18.2
UPDATE `versioninfo` set version = '0.18.2' where module = 'Main';

-- Update to 0.19
ALTER TABLE monitors MODIFY test_id INT NOT NULL;
ALTER TABLE view MODIFY pos INT NOT NULL;
INSERT INTO tests_internal VALUES (8,'Windows CPU Load');
INSERT INTO tests_script SET name='Livingston Portmaster Active Modems', cmd='pmmodems.pl %snmp_read_community% %ip%', data_type='2';
UPDATE graphs SET min=NULL WHERE min=0;
UPDATE graphs SET max=NULL WHERE max=0;
UPDATE `versioninfo` set version = '0.19' where module = 'Main';

-- update to 0.20
INSERT INTO updates SET update_version = '0.20', name = 'Device Properties Table', version_applied_to = '0.19', dateapplied = now();
CREATE TABLE `dev_props` (`id` INT NOT NULL AUTO_INCREMENT, `dev_type_id` INT NOT NULL, `name` VARCHAR( 200 ) NOT NULL, `test_type` TINYINT NOT NULL, `test_id` INT NOT NULL, `test_params` VARCHAR( 150 ) NOT NULL, PRIMARY KEY ( `id` )) TYPE = MYISAM;

INSERT INTO updates SET update_version = '0.20', name = 'Device Properties Values Table', version_applied_to = '0.19', dateapplied = now();
CREATE TABLE `dev_prop_vals` ( `dev_id` INT NOT NULL, `prop_id` INT NOT NULL, `value` VARCHAR( 250 ) NOT NULL, PRIMARY KEY ( `dev_id` , `prop_id` ));

INSERT INTO updates SET update_version = '0.20', name = 'SNMP Interface Cache New Fields', version_applied_to = '0.19', dateapplied = now();
ALTER TABLE `snmp_interface_cache` ADD `nexthop` VARCHAR( 20 ) , ADD `vlan` VARCHAR( 20 ) , ADD `mode` TINYINT;

INSERT INTO updates SET update_version = '0.20', name = 'Graph Item Consolidation Function Field', version_applied_to = '0.19', dateapplied = now();
ALTER TABLE `graph_ds` ADD `cf` TINYINT NOT NULL DEFAULT '1';

INSERT INTO updates SET update_version = '0.20', name = 'Device Unknowns on SNMP Restart Field', version_applied_to = '0.19', dateapplied = now();
ALTER TABLE `devices` ADD `unknowns_on_snmp_restart` TINYINT NOT NULL DEFAULT '1';

UPDATE `versioninfo` set version = '0.20' where module = 'Main';