#
# The HITEMS table is used to store the defintion of various hardware items.
#
# _rowid       is a positive integer, unique to this table that is used to 
#              identify a specific row in the table.
# group        which 'group' of items this belongs to. (Hard drive, NIC etc..)
# created      is the date that this entry was created.
# modified     is the date that this entry was last modified.
# name         is what this item is called.
# description  guess.
# model        is the manufacture model #
# vendor       is the vendor id for this vendor (vendors table?)
# 
create TABLE hitems (
  _rowid      int not null,
  igroup      char(10),
  created     char(20),
  modified    char(20),
  name        char(60),
  description char(127),
  model       char(40),
  vendor      char(20),
  primary key (_rowid)
);