CREATE TABLE `za_lp_heita_comm` (
  `comm_id` INT(11) NOT NULL AUTO_INCREMENT,  
  `device` varchar(255) NOT NULL default '',
  `prem` varchar(255) NOT NULL default '',
  `mesg` varchar(255) NOT NULL default '',
  `num` varchar(255) NOT NULL default '',
  `tonum` varchar(255) NOT NULL default '',
  `id` varchar(255) NOT NULL default '',  
  `comm_date` date NOT NULL,
  `comm_time` time NOT NULL,
  `ad` varchar(255) NOT NULL default '',  
  PRIMARY KEY (comm_id)
);


CREATE TABLE `za_lp_heita_cellphone_num` (
  `cellphone_id` INT(11) NOT NULL AUTO_INCREMENT,
  `cellphone` varchar(255) NOT NULL default '',
  `added_date` date NOT NULL,
  `added_time` time NOT NULL,
  PRIMARY KEY (cellphone_id)
);
