 --#  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
+--#  baseType		: Indicates what type of bridging this bridge can
 --#                             perform.
 --#						        '1' unknown
 --#						        '2' transparent-only

--#
--########################################################################
create table demandPolls (
	id			integer ,
	requestTime	timestamp without time zone,
	username	varchar,
	description varchar,

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

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,
    
	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);

create index atinterface_nodeid_idx on atinterface USING HASH(nodeid) ;
create index atinterface_node_ipaddr_idx on atinterface(nodeid,ipaddr);
