CREATE TABLE alarms (
  alarmstring varchar(16) NOT NULL default '',
  acct varchar(4) NOT NULL default '',
  mt char(2) default NULL,
  q char(1) default NULL,
  event char(3) default NULL,
  gg char(2) default NULL,
  zone char(3) default NULL,
  cksm char(1) default NULL,
  received timestamp(14) NOT NULL,
  uniqueid varchar(128) NOT NULL default '',
  callingfrom varchar(15) default NULL,
  callername varchar(16) default NULL,
  PRIMARY KEY  (uniqueid)
) TYPE=MyISAM;