host.table

来自「gxsnmp SNMP MANAGER 的实现」· TABLE 代码 · 共 36 行

#
#  The HOST table is used to store information about hosts.
#
#  _rowid       is a positive integer, unique within the HOST 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
#
#  dns_name	is the preferred DNS name to use when accessing this host.
#
#  name         is the user assigned name of the host.  This is the name that
#		is displayed on the maps.
#
#  description  is the user assigned description of the host, possibly
#               including its physical location or other notes.
#
#  contact      is the user assigned name of the person responsible for the
#               host, and possibly other identifying information, such
#               as a phone number
#
#  tags         is the application specfic tags for this object.
#
create table host (
   _rowid        int not null,
   created      char(20), 
   modified     char(20),
   dns_name	char(32),
   name         char(36),
   description  char(127),
   contact      char(64),
   tags         char(255),
   primary key  (_rowid)
);