#
# The HINVENTORY table is used to store information about the physical 
# inventory of a machine. (Hard Drive size and type, network card etc..)
#
# _rowid       Is a positive integer, unique within this table that is
#              used to identify a specific row in the table.
# created      Timestamp of when this entry was created.
# modified     Timestamp of when this entry was last modified.
# item         The _rowid of the item from the hitems table of this item.
#              This is where the description, vendor, model # comes from
#              This will allow reporting on the # of a given item in use. 
# host         The _rowid of the host that this item belongs to.
# serial       The serial # of this item.
# installed    The date this was installed.
# removed      The date this item was removed. (NULL == Still installed.)
#
create TABLE hinventory (
   _rowid      int not null,
   created     char(20),
   modified    char(20),
   item        int,
   host        int,
   serial      char(40),
   installed   char(20),
   removed     char(20),
   primary key (_rowid),
   foreign key (item) references hitems,
   foreign key (host) references host
);