1BEGIN;
2
3ALTER TABLE device_port_wireless ALTER COLUMN ip SET NOT NULL;
4
5ALTER TABLE device_port_wireless ALTER COLUMN port SET NOT NULL;
6
7ALTER TABLE device_port_wireless ADD CONSTRAINT device_port_wireless_pkey PRIMARY KEY (ip, port);
8
9ALTER TABLE device_port_ssid ALTER COLUMN ip SET NOT NULL;
10
11ALTER TABLE device_port_ssid ALTER COLUMN port SET NOT NULL;
12
13ALTER TABLE device_port_ssid ALTER COLUMN bssid SET NOT NULL;
14
15ALTER TABLE device_port_ssid ADD CONSTRAINT device_port_ssid_pkey PRIMARY KEY (ip, bssid, port);
16
17ALTER TABLE device_port_log ADD PRIMARY KEY (id);
18
19COMMIT;
20