1BEGIN; 2 3-- Netdisco 4-- Database Schema Modifications 5-- UPGRADE from 1.0 to 1.1 6 7-- 8-- Add index to node_ip table 9CREATE INDEX idx_node_ip_ip_active ON node_ip(ip,active); 10 11-- Add "power" column to device_port_power table 12ALTER TABLE device_port_power ADD power integer; 13 14COMMIT; 15