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