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