1-- Remove table structure for table `tbltask_schedule`
  2DROP TABLE IF EXISTS `tbltask_schedule`;
  3
  4-- Remove table structure for table `tbltask_mutex`
  5DROP TABLE IF EXISTS `tbltask_mutex`;
  6
  7-- Remove table structure for table `tbllog_task`
  8DROP TABLE IF EXISTS `tbllog_task`;
  9
 10
 11-- Table structure for table `tbltask`
 12
 13DROP TABLE IF EXISTS `tbltask`;
 14CREATE TABLE `tbltask` (
 15  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 16  `priority` int(11) NOT NULL DEFAULT '0',
 17  `class_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 18  `is_enabled` tinyint(4) NOT NULL DEFAULT '1',
 19  `is_periodic` tinyint(4) NOT NULL DEFAULT '1',
 20  `frequency` int(10) unsigned NOT NULL DEFAULT '0',
 21  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 22  `description` text COLLATE utf8_unicode_ci NOT NULL,
 23  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 24  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 25  PRIMARY KEY (`id`)
 26) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 27
 28LOCK TABLES `tbltask` WRITE;
 29INSERT INTO `tbltask` (`id`,`priority`,`class_name`,`is_enabled`,`is_periodic`,`frequency`,`name`,`description`,`created_at`,`updated_at`) VALUES (1,1530,'WHMCS\\Cron\\Task\\AddLateFees',1,1,1440,'Late Fees','Apply Late Fees','2016-11-02 16:59:20','2016-11-02 16:59:20'),(2,1620,'WHMCS\\Cron\\Task\\AffiliateCommissions',1,1,1440,'Delayed Affiliate Commissions','Process Delayed Affiliate Commissions','2016-11-02 16:59:20','2016-11-02 16:59:20'),(3,1630,'WHMCS\\Cron\\Task\\AffiliateReports',1,1,43200,'Affiliate Reports','Send Monthly Affiliate Reports','2016-11-02 16:59:20','2016-11-02 16:59:20'),(4,1680,'WHMCS\\Cron\\Task\\AutoClientStatusSync',1,1,1440,'Client Status Update','Synchronise Client Status','2016-11-02 16:59:20','2016-11-02 16:59:20'),(5,1590,'WHMCS\\Cron\\Task\\AutoTerminations',1,1,1440,'Overdue Terminations','Process Overdue Terminations','2016-11-02 16:59:20','2016-11-02 16:59:20'),(6,1570,'WHMCS\\Cron\\Task\\CancellationRequests',1,1,1440,'Cancellation Requests','Process Cancellation Requests','2016-11-02 16:59:20','2016-11-02 16:59:20'),(7,2000,'WHMCS\\Cron\\Task\\CheckForWhmcsUpdate',1,1,480,'WHMCS Updates','Check for WHMCS Software Updates','2016-11-02 16:59:20','2016-11-02 16:59:20'),(8,1610,'WHMCS\\Cron\\Task\\CloseInactiveTickets',1,1,1440,'Inactive Tickets','Auto Close Inactive Tickets','2016-11-02 16:59:20','2016-11-02 16:59:20'),(9,1520,'WHMCS\\Cron\\Task\\CreateInvoices',1,1,1440,'Invoices','Generate Invoices','2016-11-02 16:59:20','2016-11-02 16:59:20'),(10,1650,'WHMCS\\Cron\\Task\\CreditCardExpiryNotices',1,1,43200,'Credit Card Expiry Notices','Sending Credit Card Expiry Reminders','2016-11-02 16:59:20','2016-11-02 16:59:20'),(11,1500,'WHMCS\\Cron\\Task\\CurrencyUpdateExchangeRates',1,1,1440,'Currency Exchange Rates','Update Currency Exchange Rates','2016-11-02 16:59:20','2016-11-02 16:59:20'),(12,1510,'WHMCS\\Cron\\Task\\CurrencyUpdateProductPricing',1,1,1440,'Product Pricing Updates','Update Product Prices for Current Rates','2016-11-02 16:59:20','2016-11-02 16:59:20'),(13,1560,'WHMCS\\Cron\\Task\\DomainRenewalNotices',1,1,1440,'Domain Renewal Notices','Processing Domain Renewal Notices','2016-11-02 16:59:20','2016-11-02 16:59:20'),(14,1640,'WHMCS\\Cron\\Task\\EmailMarketer',1,1,1440,'Email Marketer Rules','Process Email Marketer Rules','2016-11-02 16:59:20','2016-11-02 16:59:20'),(15,1600,'WHMCS\\Cron\\Task\\FixedTermTerminations',1,1,1440,'Fixed Term Terminations','Process Fixed Term Terminations','2016-11-02 16:59:20','2016-11-02 16:59:20'),(16,1550,'WHMCS\\Cron\\Task\\InvoiceReminders',1,1,1440,'Invoice & Overdue Reminders','Generate daily reminders for unpaid and overdue invoice','2016-11-02 16:59:20','2016-11-02 16:59:20'),(17,1670,'WHMCS\\Cron\\Task\\OverageBilling',1,1,43200,'Overage Billing Charges','Process Overage Billing Charges','2016-11-02 16:59:20','2016-11-02 16:59:20'),(18,1540,'WHMCS\\Cron\\Task\\ProcessCreditCardPayments',1,1,1440,'Credit Card Charges','Process Credit Card Charges','2016-11-02 16:59:20','2016-11-02 16:59:20'),(19,1580,'WHMCS\\Cron\\Task\\AutoSuspensions',1,1,1440,'Overdue Suspensions','Process Overdue Suspensions','2016-11-02 16:59:21','2016-11-02 16:59:21'),(20,1700,'WHMCS\\Cron\\Task\\TicketEscalations',1,1,3,'Ticket Escalation Rules','Process and escalate tickets per any Escalation Rules','2016-11-02 16:59:21','2016-11-02 16:59:21'),(21,1690,'WHMCS\\Cron\\Task\\UpdateDomainExpiryStatus',1,1,1440,'Domain Expiry','Update Domain Expiry Status','2016-11-02 16:59:21','2016-11-02 16:59:21'),(22,1660,'WHMCS\\Cron\\Task\\UpdateServerUsage',1,1,1440,'Server Usage Stats','Updating Disk & Bandwidth Usage Stats','2016-11-02 16:59:21','2016-11-02 16:59:21');
 30UNLOCK TABLES;
 31
 32-- Table structure for table `tbltask_status`
 33
 34DROP TABLE IF EXISTS `tbltask_status`;
 35CREATE TABLE `tbltask_status` (
 36  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 37  `task_id` int(10) unsigned NOT NULL,
 38  `in_progress` tinyint(4) NOT NULL DEFAULT '0',
 39  `last_run` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 40  `next_due` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 41  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 42  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 43  PRIMARY KEY (`id`)
 44) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 45
 46LOCK TABLES `tbltask_status` WRITE;
 47INSERT INTO `tbltask_status` (`id`,`task_id`,`in_progress`,`last_run`,`next_due`,`created_at`,`updated_at`) VALUES (1,1,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(2,2,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(3,3,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(4,4,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(5,5,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(6,6,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(7,7,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(8,8,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(9,9,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(10,10,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(11,11,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(12,12,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(13,13,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(14,14,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(15,15,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(16,16,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(17,17,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(18,18,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:20','2016-11-02 16:59:23'),(19,19,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:21','2016-11-02 16:59:23'),(20,20,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:21','2016-11-02 16:59:23'),(21,21,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:21','2016-11-02 16:59:23'),(22,22,0,'0000-00-00 00:00:00','2016-11-02 16:59:23','2016-11-02 16:59:21','2016-11-02 16:59:23');
 48UNLOCK TABLES;
 49
 50-- Table structure for table `tbllog_register`
 51
 52DROP TABLE IF EXISTS `tbllog_register`;
 53CREATE TABLE `tbllog_register` (
 54  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 55  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 56  `namespace_id` int(10) unsigned,
 57  `namespace` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
 58  `namespace_value` text COLLATE utf8_unicode_ci NOT NULL,
 59  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 60  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 61  PRIMARY KEY (`id`)
 62) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 63
 64-- Insert Automation Status Permission to admin role 1
 65INSERT INTO `tbladminperms` (`roleid`, `permid`) VALUES (1, 138);
 66