#
#  The INTERFACE table is used to store information about network interfaces.
#
#  _rowid	is a positive integer, unique within the INTERFACE table, that
# 		is used to identify a specific row in the table.
#
#  created      is the date and time that the row entry was created
#
#  modified     is the date and time that the row entry was last modified
#
#  host		is the rowid of the entry in the HOST table of the host that
#		owns this interface.
#
#  snmp         is the rowid of the entry in the SNMP table that identifies
#		the SNMP configuration to be used when querying this interface
#
#  transport	is the AF_xxx number of the transport used by this interface.
#		Interfaces that respond to multiple transport methods will
#		have multiple entries in the INTERFACE table, one for each
#		transport.
#
#  address	is the network address of the interface.  The network address
#		is stored in the database in human-readable format.
#
#  netmask	For IPv4, the network mask associated with the interface. The
#		netmask is stored in the database in dotted decimal format.
#
#  name		is the human-readable name of the interface, such as
#		"eth0" or "fddi0".
#
create table interface (
   _rowid        int not null,
   created      char(20),
   modified     char(20), 
   host		int,
   snmp		int,
   transport	smallint,
   address	char(127),
   netmask	char(127),
   name		char(127),
   primary key  (_rowid),
   foreign key  (host) references host,
   foreign key  (snmp) references snmp
);