 --########################################################################
 
 create table atinterface (
-    nodeid	   integer not null,
-    ipAddr	   varchar(16) not null,
-    atPhysAddr	   varchar(12) not null,
-    status	   char(1) not null,
-    sourceNodeid   integer not null,
-    ifindex	   integer not null,
-    lastPollTime timestamp not null,
+	nodeid		integer not null,
+	ipAddr		varchar(16) not null,
+	atPhysAddr	varchar(12) not null,
+	status		char(1) not null,
+	sourceNodeid	integer not null,
+	ifindex		integer not null,
+	lastPollTime	timestamp not null,
     
-    constraint fk_ia_nodeID1 foreign key (nodeid) references node
+	constraint fk_ia_nodeID1 foreign key (nodeid) references node
 );
 
 --# this doesn't wor with installer 
-alter table atinterface add constraint pk_atinterface primary key (nodeid,ipAddr,atPhysAddr);
+--#alter table atinterface add constraint pk_atinterface primary key (nodeid,ipAddr,atPhysAddr);
 
 create index atinterface_nodeid_idx on atinterface USING HASH(nodeid) ;
 create index atinterface_node_ipaddr_idx on atinterface(nodeid,ipaddr);


--# Sequence for the id column in the demandPolls table
--#          sequence, column, table
--# install: demandPollsNxtId id   demandPolls
create sequence demandPollNxtId minvalue 1;

--# Sequence for the id column in the pollResults table
--#          sequence, column, table
--# install: pollResultsNxtId id   pollResults
create sequence pollResultNxtId minvalue 1;

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

--#  baseBridgeAddress        : The MAC address used by this bridge when it must
--#                             be referred to in a unique fashion.
--#  baseNumPorts             : The number of ports controlled by the bridge entity.
--#  baseType		: Indicates what type of bridging this bridge can
--#                             perform.
--#						        '1' unknown
--#						        '2' transparent-only
