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