Stackposts v7.0.2 - инструмент социального маркетинга

CREATE TABLE `instagram_activities` (
`id` int(11) NOT NULL,
`ids` text,
`uid` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT '0',
`account` int(11) DEFAULT NULL,
`action` longtext,
`time` datetime DEFAULT NULL,
`data` longtext,
`settings` longtext,
`status` int(1) DEFAULT NULL,
`changed` datetime DEFAULT NULL,
`created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `instagram_activities_log` (
`id` int(11) NOT NULL,
`ids` text,
`uid` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`action` text,
`data` longtext,
`created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `payment` (
`id` int(11) NOT NULL,
`paypal_email` varchar(255) DEFAULT NULL,
`pagseguro_email` varchar(255) DEFAULT NULL,
`pagseguro_token` varchar(255) DEFAULT NULL,
`sandbox` int(1) DEFAULT '0',
`currency` varchar(32) DEFAULT NULL,
`symbol` varchar(255) DEFAULT '$'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `payment_history` (
`id` int(11) NOT NULL,
`type` varchar(255) DEFAULT NULL,
`uid` int(11) DEFAULT NULL,
`invoice` varchar(255) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`business` varchar(255) DEFAULT NULL,
`receiver_email` varchar(255) DEFAULT NULL,
`payer_email` varchar(255) DEFAULT NULL,
`item_name` varchar(255) DEFAULT NULL,
`item_number` int(1) DEFAULT NULL,
`address_street` varchar(255) DEFAULT NULL,
`address_city` varchar(255) DEFAULT NULL,
`address_country` varchar(255) DEFAULT NULL,
`mc_gross` float DEFAULT NULL,
`feeAmount` float DEFAULT NULL,
`netAmount` float DEFAULT NULL,
`mc_currency` varchar(255) DEFAULT NULL,
`payment_date` datetime DEFAULT NULL,
`payment_status` varchar(255) DEFAULT NULL,
`full_data` text,
`created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `linkedin_posts` (
`id` int(11) NOT NULL,
`ids` text,
`uid` int(11) DEFAULT NULL,
`account` int(11) DEFAULT NULL,
`type` text,
`data` longtext,
`time_post` datetime DEFAULT NULL,
`delay` int(11) DEFAULT NULL,
`time_delete` int(11) DEFAULT NULL,
`result` text,
`status` int(1) DEFAULT NULL,
`changed` datetime DEFAULT NULL,
`created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `linkedin_accounts` (
`id` int(11) NOT NULL,
`ids` text,
`uid` int(11) DEFAULT NULL,
`pid` text,
`type` text,
`username` text,
`url` text,
`avatar` text,
`access_token` text,
`status` int(1) DEFAULT '1',
`changed` datetime DEFAULT NULL,
`created` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `vk_accounts` (
`id` int(11) NOT NULL,
`ids` text,
`uid` int(11) DEFAULT NULL,
`pid` text,
`type` text,
`username` text CHARACTER SET utf8,
`url` text,
`avatar` text,
`access_token` text,
`status` int(1) DEFAULT '1',
`changed` datetime DEFAULT NULL,
`created` datetime DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `vk_posts` (
`id` int(11) NOT NULL,
`ids` text,
`uid` int(11) DEFAULT NULL,
`account` int(11) DEFAULT NULL,
`group_id` text,
`type` text,
`data` longtext,
`time_post` datetime DEFAULT NULL,
`delay` int(11) DEFAULT NULL,
`time_delete` int(11) DEFAULT NULL,
`result` text,
`status` int(1) DEFAULT NULL,
`changed` datetime DEFAULT NULL,
`created` datetime DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4;