· 4 years ago · Mar 19, 2021, 11:58 AM
1-- Adminer 4.7.7 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `wp_asp_schedule_events`;
9CREATE TABLE `wp_asp_schedule_events` (
10 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
11 `subscription_title` varchar(255) NOT NULL,
12 `report_type` varchar(255) NOT NULL,
13 `present_date_range` varchar(255) DEFAULT NULL,
14 `lead_create_start` date DEFAULT NULL,
15 `lead_create_end` date DEFAULT NULL,
16 `medium` varchar(255) DEFAULT NULL,
17 `offer_type` varchar(255) DEFAULT NULL,
18 `billing_month` int(11) DEFAULT NULL,
19 `provider` varchar(255) NOT NULL,
20 `user_id` int(11) NOT NULL,
21 `type` enum('Hourly','Daily','Weekly','Monthly') NOT NULL,
22 `every_hours` int(11) DEFAULT NULL,
23 `Monday` tinyint(4) NOT NULL DEFAULT 0,
24 `Tuesday` tinyint(4) NOT NULL DEFAULT 0,
25 `Wednesday` tinyint(4) NOT NULL DEFAULT 0,
26 `Thursday` tinyint(4) NOT NULL DEFAULT 0,
27 `Friday` tinyint(4) NOT NULL DEFAULT 0,
28 `Saturday` tinyint(4) NOT NULL DEFAULT 0,
29 `Sunday` tinyint(4) NOT NULL DEFAULT 0,
30 `January` tinyint(4) NOT NULL DEFAULT 0,
31 `February` tinyint(4) NOT NULL DEFAULT 0,
32 `March` tinyint(4) NOT NULL DEFAULT 0,
33 `April` tinyint(4) NOT NULL DEFAULT 0,
34 `May` tinyint(4) NOT NULL DEFAULT 0,
35 `June` tinyint(4) NOT NULL DEFAULT 0,
36 `July` tinyint(4) NOT NULL DEFAULT 0,
37 `August` tinyint(4) NOT NULL DEFAULT 0,
38 `September` tinyint(4) NOT NULL DEFAULT 0,
39 `October` tinyint(4) NOT NULL DEFAULT 0,
40 `November` tinyint(4) NOT NULL DEFAULT 0,
41 `December` tinyint(4) NOT NULL DEFAULT 0,
42 `start_date` date NOT NULL,
43 `end_date` date DEFAULT NULL,
44 `start_time` time DEFAULT NULL,
45 `email_list` text NOT NULL,
46 `subject` varchar(255) NOT NULL,
47 `export_type` enum('CSV (Comma Delimited)','Excel') NOT NULL,
48 PRIMARY KEY (`id`),
49 KEY `January` (`January`),
50 KEY `February` (`February`),
51 KEY `April` (`April`),
52 KEY `March` (`March`),
53 KEY `May` (`May`),
54 KEY `June` (`June`),
55 KEY `July` (`July`),
56 KEY `August` (`August`),
57 KEY `September` (`September`),
58 KEY `October` (`October`),
59 KEY `November` (`November`),
60 KEY `December` (`December`),
61 KEY `start_date` (`start_date`),
62 KEY `end_date` (`end_date`),
63 KEY `Sunday` (`Sunday`),
64 KEY `Saturday` (`Saturday`),
65 KEY `Friday` (`Friday`),
66 KEY `Thursday` (`Thursday`),
67 KEY `Wednesday` (`Wednesday`),
68 KEY `Tuesday` (`Tuesday`),
69 KEY `Monday` (`Monday`),
70 KEY `type` (`type`)
71) ENGINE=MyISAM DEFAULT CHARSET=latin1;
72
73INSERT INTO `wp_asp_schedule_events` (`id`, `subscription_title`, `report_type`, `present_date_range`, `lead_create_start`, `lead_create_end`, `medium`, `offer_type`, `billing_month`, `provider`, `user_id`, `type`, `every_hours`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`, `Saturday`, `Sunday`, `January`, `February`, `March`, `April`, `May`, `June`, `July`, `August`, `September`, `October`, `November`, `December`, `start_date`, `end_date`, `start_time`, `email_list`, `subject`, `export_type`) VALUES
74(19, 'Subscription 4', 'external_partner_lead_detailed_report', 'Custom', '2020-02-05', '2020-02-23', 'Partner', 'LINKOUT', NULL, 'XYZ', 94, 'Monthly', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, '2021-03-01', '2021-03-22', '09:00:00', 'jignesh.bhavani@multidots.com,ankit.solanki@multidots.com', 'This is test email subject', 'Excel'),
75(21, 'Monthly Email - Intraday external partner lead detail Report', 'external_partner_lead_detailed_report', 'Last Month', '0000-00-00', '0000-00-00', 'Partner', 'LINKOUT', NULL, 'XYZ', 94, 'Hourly', 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2021-03-01', '2021-03-22', '09:00:00', 'jignesh.bhavani@multidots.com,ankit.solanki@multidots.com', 'This is test email subject', 'Excel'),
76(18, 'Subscription 3', 'external_partner_lead_detailed_report', 'Custom', '2020-02-05', '2020-02-23', 'Partner', 'LINKOUT', NULL, 'XYZ', 94, 'Hourly', 6, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2021-03-01', '2021-03-22', '18:30:00', 'jignesh.bhavani@multidots.com, ankit.solanki@multidots.com', 'This is test email subject', 'Excel'),
77(20, 'Subscription 4', 'external_partner_lead_detailed_report', 'Custom', '2020-02-05', '2020-02-23', 'Partner', 'LINKOUT', NULL, 'XYZ', 94, 'Hourly', 3, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2021-03-01', '2021-03-22', '09:00:00', 'jignesh.bhavani@multidots.com,ankit.solanki@multidots.com', 'This is test email subject', 'Excel');
78
79-- 2021-03-19 11:50:50