CREATE TABLE IF NOT EXISTS tblexport_reports_jobs (
  id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  status ENUM('pending','in_progress','completed','failed') NOT NULL DEFAULT 'pending',
  description LONGTEXT NULL,
  filters LONGTEXT  NULL,
  module  VARCHAR(100) NOT NULL,
  added_on DATETIME NOT NULL, 
  added_by BIGINT(20), 
  PRIMARY KEY (id)
) ENGINE=INNODB DEFAULT CHARSET=utf8 ;

INSERT INTO tblapad_emailtemplates (TYPE,slug,LANGUAGE,NAME,SUBJECT,message,ACTIVE, fromname, `order`)
VALUES('report','export-report','english','Export Report',"Export Report",'<span style="font-size: 12pt;">Hi {staff_firstname},</span><br/><br/><span style="font-size: 12pt;">Please find the business report that you had requested for.</span><br/><br/><br/><br/><span style="font-size: 12pt;">Regards,</span><br/><br/>',1, '', 0);

