#
# Companies are companies you're tracking.
#
CREATE TABLE company (
  company_id int(10) unsigned NOT NULL default '0',
  name varchar(255) default NULL,
  status tinyint(4) unsigned default NULL,
  notes mediumtext,
  PRIMARY KEY  (company_id)
) TYPE=MyISAM;

#
# Spam is for spam.
#
CREATE TABLE spam (
  spam_id int(10) unsigned NOT NULL default '0',
  company_id int(10) unsigned NOT NULL default '0',
  spam text NOT NULL,
  date date default '0000-00-00',
  PRIMARY KEY  (spam_id)
) TYPE=MyISAM;

#
# Actions are when you call, fax or email a spammer.
#
CREATE TABLE action (
  action_id int(10) unsigned NOT NULL default '0',
  company_id int(10) unsigned NOT NULL default '0',
  date date default NULL,
  action varchar(255) NOT NULL default '',
  PRIMARY KEY  (action_id)
) TYPE=MyISAM;

#
# Keywords are used to match incoming spams with companies
#
CREATE TABLE keyword (
  keyword_id int(10) unsigned NOT NULL default '0',
  company_id int(10) unsigned default NULL,
  keyword varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Incoming spam isn't isn't yet associated with a company.
#
CREATE TABLE incoming (
  incoming_id int(10) unsigned NOT NULL default '0',
  spam text NOT NULL,
  PRIMARY KEY  (incoming_id)
) TYPE=MyISAM;