BEGIN;

-- Netdisco
-- Database Schema Modifications
-- UPGRADE from 1.0 to 1.1

--
-- Add index to node_ip table
CREATE INDEX idx_node_ip_ip_active ON node_ip(ip,active);

-- Add "power" column to device_port_power table
ALTER TABLE device_port_power ADD power integer;

COMMIT;