-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.3.38-MariaDB-0ubuntu0.20.04.1 - Ubuntu 20.04
-- Server OS:                    debian-linux-gnu
-- HeidiSQL Version:             12.6.0.6765
-- --------------------------------------------------------

-- Dumping structure for table wlcj2_data.cronlist
CREATE TABLE IF NOT EXISTS `cronlist` (
  `batchnum` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `batchflag` enum('P','N','R','D','T') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'P',
  `sendDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `datesent` date NOT NULL,
  `actualtimestarted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `timestarted` time NOT NULL,
  `subject` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attach1` varchar(100) NOT NULL,
  `attach2` varchar(100) NOT NULL,
  `timelastsent` time NOT NULL,
  UNIQUE KEY `batchnum` (`batchnum`),
  KEY `batchflag` (`batchflag`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='list of email jobs';