· 6 years ago · Aug 08, 2019, 03:58 AM
1-- Adminer 4.4.0 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
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `wp_sb_networks`;
11CREATE TABLE `wp_sb_networks` (
12 `id` int(11) NOT NULL AUTO_INCREMENT,
13 `profile_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
14 `prof_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15 `network` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
16 `auth_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
17 `auth_platform` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
18 `auth_platform_id` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
19 `token` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
20 `auth_status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
21 `auth_con` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
22 `extra` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
23 `auth_date` datetime NOT NULL,
24 PRIMARY KEY (`id`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
26
27INSERT INTO `wp_sb_networks` (`id`, `profile_id`, `prof_name`, `network`, `auth_type`, `auth_platform`, `auth_platform_id`, `token`, `auth_status`, `auth_con`, `extra`, `auth_date`) VALUES
28(1, 'rx_1brfu5r', 'Ahmeds Page', 'facebook', 'auto', 'page', '310524812915243', 'EAAGBDqYIBFEBAGLawe1cK7JNK1d2QzaS5vDXsTNaS1DUGmXSpCm94TbgnhbpbomJmxA7iFYfMeRpG2I6IlpVqeX82WnUewsPwMpQBrAEM5ZBbi8ucgCR9w0ZAFqHIycHpw4QnXZC0LzuGYF15Rb95wZArt77ZBNyBVJIUiIIQdC512AaAKZCDO', 'active', 'active', NULL, '2019-06-25 00:00:00'),
29(2, 'rx_1brfu5r', 'takhi44', 'twitter', 'auto', 'profile', '923038866780459008-V4uMQNf2g5hBjyuF6F2t3Bzvpl3diUa', 'qulxbpQsShH2ml4upfBB9Vd3w4LRMkF8TPdokX6YiTcMN', 'inactive', 'active', 'a:2:{s:12:\"consumer_key\";s:25:\"IJlFtwrPDRVIFUqav8mZBWyRS\";s:15:\"consumer_secret\";s:50:\"xEp2wmfgZKG1OaNP8NjVoJ6Lw5EvzK4dKtac5GYD25OjBHgy6a\";}', '2019-06-25 00:00:00'),
30(5, 'rx_1brfu5r', 'sakib44.tumblr.com', 'tumblr', 'auto', 'profile', '0V1Ya5uit4cef5Spgwbr3gFqnssBBNazWftEIBnckic3aSH3Dg', 'rfzaKwM6xPjU9At52AmF9rN0OxaQJx7Amku5DKOFITMEmqVTTr', 'inactive', 'active', 'a:2:{s:12:\"consumer_key\";s:50:\"vaOrik0xoe4emBD7eraxfYLw8p7QQid2Y2BybtfjLuKwpGOICg\";s:15:\"consumer_secret\";s:50:\"xw6XI6kavQeTHDeJfTDk4XpI7WTJu7T2bazosKaZA5FIF8e6OS\";}', '2019-06-25 00:00:00');
31
32DROP TABLE IF EXISTS `wp_sb_profiles`;
33CREATE TABLE `wp_sb_profiles` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `profile_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
36 `profile_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
37 PRIMARY KEY (`id`),
38 UNIQUE KEY `profile_id` (`profile_id`)
39) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
40
41INSERT INTO `wp_sb_profiles` (`id`, `profile_id`, `profile_name`) VALUES
42(4, 'rx_1brfu5r', 'RexThemefghgjdfgjfhsfh'),
43(5, 'rx_eah4jah', 'CodeRex');
44
45DROP TABLE IF EXISTS `wp_sb_scheduled_posts`;
46CREATE TABLE `wp_sb_scheduled_posts` (
47 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
48 `post_id` int(11) NOT NULL,
49 `post_meta` longtext COLLATE utf8mb4_unicode_520_ci,
50 `profile_id` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
51 `network_id` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
52 `share_type` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
53 `schedule_type` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
54 `schedule_time` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
55 PRIMARY KEY (`id`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
57
58INSERT INTO `wp_sb_scheduled_posts` (`id`, `post_id`, `post_meta`, `profile_id`, `network_id`, `share_type`, `schedule_type`, `schedule_time`) VALUES
59(1, 124, 'a:2:{s:7:\"message\";s:0:\"\";s:4:\"link\";s:38:\"https://dev.social-booster.com/colors/\";}', 'rx_1brfu5r', '1', 'scheduled', 'daily', '2019-07-18 10:27:00'),
60(2, 124, 'a:2:{s:7:\"message\";s:0:\"\";s:4:\"link\";s:38:\"https://dev.social-booster.com/colors/\";}', 'rx_1brfu5r', '2', 'scheduled', 'daily', '2019-07-18 10:27:00'),
61(3, 124, 'a:2:{s:7:\"message\";s:0:\"\";s:4:\"link\";s:38:\"https://dev.social-booster.com/colors/\";}', 'rx_1brfu5r', '5', 'scheduled', 'daily', '2019-07-18 10:27:00'),
62(4, 124, 'a:2:{s:7:\"message\";s:0:\"\";s:4:\"link\";s:38:\"https://dev.social-booster.com/colors/\";}', 'rx_1brfu5r', '1', 'scheduled', 'daily', '2019-07-18 10:28:00'),
63(5, 124, 'a:2:{s:7:\"message\";s:0:\"\";s:4:\"link\";s:38:\"https://dev.social-booster.com/colors/\";}', 'rx_1brfu5r', '2', 'scheduled', 'daily', '2019-07-18 10:28:00'),
64(6, 124, 'a:2:{s:7:\"message\";s:0:\"\";s:4:\"link\";s:38:\"https://dev.social-booster.com/colors/\";}', 'rx_1brfu5r', '5', 'scheduled', 'daily', '2019-07-18 10:28:00');
65
66DROP TABLE IF EXISTS `wp_sb_shared_posts`;
67CREATE TABLE `wp_sb_shared_posts` (
68 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
69 `post_id` int(11) NOT NULL,
70 `post_meta` longtext COLLATE utf8mb4_unicode_520_ci,
71 `published_date` datetime NOT NULL,
72 `profile_id` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
73 `network_id` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
74 `share_type` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
75 `success` tinyint(1) DEFAULT NULL,
76 `error_msg` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
77 PRIMARY KEY (`id`)
78) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
79
80INSERT INTO `wp_sb_shared_posts` (`id`, `post_id`, `post_meta`, `published_date`, `profile_id`, `network_id`, `share_type`, `success`, `error_msg`) VALUES
81(4, 51, 'a:3:{s:7:\"message\";s:31:\"Ut dolorem quia enim reiciendis\";s:4:\"link\";s:63:\"https://dev.social-booster.com/ut-dolorem-quia-enim-reiciendis/\";s:12:\"access_token\";s:183:\"EAAGBDqYIBFEBAGLawe1cK7JNK1d2QzaS5vDXsTNaS1DUGmXSpCm94TbgnhbpbomJmxA7iFYfMeRpG2I6IlpVqeX82WnUewsPwMpQBrAEM5ZBbi8ucgCR9w0ZAFqHIycHpw4QnXZC0LzuGYF15Rb95wZArt77ZBNyBVJIUiIIQdC512AaAKZCDO\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '1', 'instant', 1, ''),
82(5, 51, 'a:1:{s:6:\"status\";s:95:\"Ut dolorem quia enim reiciendis https://dev.social-booster.com/ut-dolorem-quia-enim-reiciendis/\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '2', 'instant', 1, ''),
83(6, 51, 'a:3:{s:4:\"type\";s:4:\"link\";s:5:\"title\";s:31:\"Ut dolorem quia enim reiciendis\";s:3:\"url\";s:63:\"https://dev.social-booster.com/ut-dolorem-quia-enim-reiciendis/\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '5', 'instant', 1, ''),
84(7, 51, 'a:3:{s:7:\"message\";s:31:\"Ut dolorem quia enim reiciendis\";s:4:\"link\";s:63:\"https://dev.social-booster.com/ut-dolorem-quia-enim-reiciendis/\";s:12:\"access_token\";s:183:\"EAAGBDqYIBFEBAGLawe1cK7JNK1d2QzaS5vDXsTNaS1DUGmXSpCm94TbgnhbpbomJmxA7iFYfMeRpG2I6IlpVqeX82WnUewsPwMpQBrAEM5ZBbi8ucgCR9w0ZAFqHIycHpw4QnXZC0LzuGYF15Rb95wZArt77ZBNyBVJIUiIIQdC512AaAKZCDO\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '1', 'instant', 1, ''),
85(8, 51, 'a:1:{s:6:\"status\";s:95:\"Ut dolorem quia enim reiciendis https://dev.social-booster.com/ut-dolorem-quia-enim-reiciendis/\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '2', 'instant', 1, ''),
86(9, 51, 'a:3:{s:4:\"type\";s:4:\"link\";s:5:\"title\";s:31:\"Ut dolorem quia enim reiciendis\";s:3:\"url\";s:63:\"https://dev.social-booster.com/ut-dolorem-quia-enim-reiciendis/\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '5', 'shared', 1, ''),
87(10, 46, 'a:3:{s:7:\"message\";s:23:\"Vel corporis ea sed sit\";s:4:\"link\";s:55:\"https://dev.social-booster.com/vel-corporis-ea-sed-sit/\";s:12:\"access_token\";s:183:\"EAAGBDqYIBFEBAGLawe1cK7JNK1d2QzaS5vDXsTNaS1DUGmXSpCm94TbgnhbpbomJmxA7iFYfMeRpG2I6IlpVqeX82WnUewsPwMpQBrAEM5ZBbi8ucgCR9w0ZAFqHIycHpw4QnXZC0LzuGYF15Rb95wZArt77ZBNyBVJIUiIIQdC512AaAKZCDO\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '1', 'instant', 1, ''),
88(11, 46, 'a:1:{s:6:\"status\";s:79:\"Vel corporis ea sed sit https://dev.social-booster.com/vel-corporis-ea-sed-sit/\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '2', 'instant', 1, ''),
89(12, 46, 'a:3:{s:4:\"type\";s:4:\"link\";s:5:\"title\";s:23:\"Vel corporis ea sed sit\";s:3:\"url\";s:55:\"https://dev.social-booster.com/vel-corporis-ea-sed-sit/\";}', '2019-07-02 00:00:00', 'rx_1brfu5r', '5', 'instant', 1, '');
90
91-- 2019-08-08 03:53:58