CREATE TABLE IF NOT EXISTS tblnotification_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,
  notification_details LONGTEXT  NULL,
  scheduled_on DATETIME NULL, 
  added_on DATETIME NOT NULL, 
  added_by_admin_id BIGINT(20), 
  PRIMARY KEY (id)
) ENGINE=INNODB DEFAULT CHARSET=utf8 ;


INSERT INTO tblapad_options (name,value) VALUES('fcm_tokens_per_batch',1000);

