CREATE TABLE `llx_smseverywhere_reminder` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `dateremind` datetime NOT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `offsetvalue` int(11) NOT NULL,
  `offsetunit` varchar(1) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_actioncomm` int(11) NOT NULL,
  `fk_email_template` int(11) DEFAULT NULL,
  `lasterror` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_smseverywhere_reminder_unique` (`fk_user`,`fk_soc`,`offsetvalue`,`offsetunit`,`fk_actioncomm`),
  KEY `idx_smseverywhere_reminder_rowid` (`rowid`),
  KEY `idx_smseverywhere_reminder_dateremind` (`dateremind`),
  KEY `idx_smseverywhere_reminder_fk_user` (`fk_user`),
  KEY `idx_smseverywhere_reminder_status` (`status`),
  KEY `idx_smseverywhere_reminder_fk_soc` (`fk_soc`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=latin1