xref: /dports/net-mgmt/netdisco/App-Netdisco-2.047002/share/schema_versions/App-Netdisco-DB-47-48-PostgreSQL.sql

BEGIN;

ALTER TABLE device_port_properties ADD COLUMN "remote_is_wap" bool DEFAULT false;
ALTER TABLE device_port_properties ADD COLUMN "remote_is_phone" bool DEFAULT false;
ALTER TABLE device_port_properties ADD COLUMN "remote_vendor" text;
ALTER TABLE device_port_properties ADD COLUMN "remote_model"  text;
ALTER TABLE device_port_properties ADD COLUMN "remote_os_ver" text;
ALTER TABLE device_port_properties ADD COLUMN "remote_serial" text;

COMMIT;