1BEGIN; 2 3-- Netdisco 4-- Database Schema Modifications 5-- UPGRADE from 1.1 to 1.2 6 7-- Add "vlantype" column to device_port_vlan table 8ALTER TABLE device_port_vlan ADD vlantype text; 9 10-- Add "topology" table to augment manual topo file 11CREATE TABLE topology ( 12 dev1 inet not null, 13 port1 text not null, 14 dev2 inet not null, 15 port2 text not null 16); 17 18-- Add "bssid" column to device_port_ssid table 19ALTER TABLE device_port_ssid ADD bssid macaddr; 20 21-- Add "vlan" column to node table 22ALTER TABLE node ADD vlan text DEFAULT '0'; 23 24ALTER TABLE node DROP CONSTRAINT node_pkey; 25ALTER TABLE node ADD PRIMARY KEY (mac, switch, port, vlan); 26 27-- Add "ssid" column to node_wireless table 28ALTER TABLE node_wireless ADD ssid text DEFAULT ''; 29 30ALTER TABLE node_wireless DROP CONSTRAINT node_wireless_pkey; 31ALTER TABLE node_wireless ADD PRIMARY KEY (mac, ssid); 32 33COMMIT; 34