create unique index one_outstanding_outage_per_service_idx on outages (ifserviceid) where ifregainedservice is null;

create table minions (
    id           varchar(36) not null,
    location     text not null,
    status       text,
    last_updated timestamp with time zone default now(),

    constraint pk_minions primary key (id)
);

create table minions_properties (
    id        integer default nextval('opennmsnxtid') not null,
    minion_id varchar(36) not null,
    key       text not null,
    value     text,

    constraint pk_minions_properties_id primary key (id),
    constraint fk_minions_properties foreign key (minion_id) references minions (id) ON DELETE CASCADE
);

CREATE UNIQUE INDEX minions_properties_unique_idx ON minions_properties(minion_id, key);


ALTER TABLE lldpElement ALTER COLUMN lldpChassisId TYPE text;
ALTER TABLE lldpElement ALTER COLUMN lldpSysname TYPE text;


ALTER TABLE lldpLink ALTER COLUMN lldpPortId TYPE text;
ALTER TABLE lldpLink ALTER COLUMN lldpPortDescr TYPE text;
ALTER TABLE lldpLink ALTER COLUMN lldpRemChassisId TYPE text;
ALTER TABLE lldpLink ALTER COLUMN lldpRemSysname TYPE text;
ALTER TABLE lldpLink ALTER COLUMN lldpRemPortId TYPE text;
ALTER TABLE lldpLink ALTER COLUMN lldpRemPortDescr TYPE text;


ALTER TABLE cdpElement ALTER COLUMN cdpGlobalDeviceId TYPE text;



ALTER TABLE cdpLink ADD COLUMN cdpCacheDeviceIndex integer;
ALTER TABLE cdpLink ALTER COLUMN cdpInterfaceName TYPE text;
ALTER TABLE cdpLink ALTER COLUMN cdpCacheAddress TYPE text;
ALTER TABLE cdpLink ALTER COLUMN cdpCacheDeviceId TYPE text;
ALTER TABLE cdpLink ALTER COLUMN cdpCacheDevicePort TYPE text;
ALTER TABLE cdpLink ALTER COLUMN cdpCacheDevicePlatform TYPE text;


ALTER TABLE bridgeElement ALTER COLUMN vlanname TYPE text;


ALTER TABLE bridgeMacLink ALTER COLUMN bridgePortIfName TYPE text;


ALTER TABLE bridgeBridgeLink ALTER COLUMN bridgePortIfName TYPE text;
ALTER TABLE bridgeBridgeLink ALTER COLUMN designatedBridgePortIfName TYPE text;


ALTER TABLE bridgeStpLink ALTER COLUMN stpPortIfName TYPE text;