 );
 
 --# this doesn't wor with installer 
-alter table iprouteinterface add constraint pk_iprouteinterface primary key (nodeid,routedest);
-
+--#alter table iprouteinterface add constraint pk_iprouteinterface primary key (nodeid,routedest);
+
+create index iprouteinterface_node_routedest_idx on iprouteinterface(nodeid,routedest);
 create index iprouteinterface_node_ifdex_idx on iprouteinterface(nodeid,routeifindex);
 create index iprouteinterface_rnh_idx on iprouteinterface(routenexthop);
 

	constraint fk_mapID foreign key (mapId) references map on delete cascade
);

--# These don't work with installer
alter table element add	constraint pk_element primary key (mapId,elementId);
alter table element add constraint elementid check (elementid <> 0);

--# Sequence for the eventID column in the events table
--#          sequence,   column, table

drop sequence outageNxtId;
drop sequence notifyNxtId;
drop sequence userNotifNxtId;
drop sequence demandPollNxtId;
drop sequence vulnNxtId;

--########################################################################
