-- phpMyAdmin SQL Dump -- version 4.8.0.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: May 31, 2018 at 11:03 PM -- Server version: 10.0.34-MariaDB-0ubuntu0.16.04.1 -- PHP Version: 7.0.30-1+ubuntu16.04.1+deb.sury.org+1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `wordpressdb134` -- -- -------------------------------------------------------- -- -- Table structure for table `smackuci_events` -- CREATE TABLE `smackuci_events` ( `id` bigint(20) NOT NULL, `revision` bigint(20) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `original_file_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `friendly_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `import_type` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `filetype` text COLLATE utf8mb4_unicode_520_ci, `filepath` text COLLATE utf8mb4_unicode_520_ci, `eventKey` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `registered_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `parent_node` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `processing` tinyint(1) NOT NULL DEFAULT '0', `executing` tinyint(1) NOT NULL DEFAULT '0', `triggered` tinyint(1) NOT NULL DEFAULT '0', `event_started_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `count` bigint(20) NOT NULL DEFAULT '0', `processed` bigint(20) NOT NULL DEFAULT '0', `created` bigint(20) NOT NULL DEFAULT '0', `updated` bigint(20) NOT NULL DEFAULT '0', `skipped` bigint(20) NOT NULL DEFAULT '0', `deleted` bigint(20) NOT NULL DEFAULT '0', `is_terminated` tinyint(1) NOT NULL DEFAULT '0', `terminated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_activity` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `siteid` int(11) NOT NULL DEFAULT '1', `month` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `year` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `smackuci_history` -- CREATE TABLE `smackuci_history` ( `id` bigint(20) NOT NULL, `event_id` bigint(20) NOT NULL, `time_taken` text COLLATE utf8mb4_unicode_520_ci, `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `summary` text COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `store_locator_country` -- CREATE TABLE `store_locator_country` ( `id` bigint(20) NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `store_locator_state` -- CREATE TABLE `store_locator_state` ( `id` bigint(20) NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `store_locator_transactions` -- CREATE TABLE `store_locator_transactions` ( `id` bigint(20) NOT NULL, `post_id` bigint(20) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `date` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_commentmeta` -- CREATE TABLE `wp_commentmeta` ( `meta_id` bigint(20) UNSIGNED NOT NULL, `comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_comments` -- CREATE TABLE `wp_comments` ( `comment_ID` bigint(20) UNSIGNED NOT NULL, `comment_post_ID` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `comment_author` tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL, `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_content` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `comment_karma` int(11) NOT NULL DEFAULT '0', `comment_approved` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1', `comment_agent` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_duplicator_packages` -- CREATE TABLE `wp_duplicator_packages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(250) NOT NULL, `hash` varchar(50) NOT NULL, `status` int(11) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `owner` varchar(60) NOT NULL, `package` mediumblob NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_gglcptch_whitelist` -- CREATE TABLE `wp_gglcptch_whitelist` ( `id` int(10) UNSIGNED NOT NULL, `ip` char(31) NOT NULL, `ip_from_int` bigint(20) DEFAULT NULL, `ip_to_int` bigint(20) DEFAULT NULL, `add_time` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `wp_huge_it_videogallery_galleries` -- CREATE TABLE `wp_huge_it_videogallery_galleries` ( `id` int(11) UNSIGNED NOT NULL, `name` varchar(200) NOT NULL, `sl_height` int(11) UNSIGNED DEFAULT NULL, `sl_width` int(11) UNSIGNED DEFAULT NULL, `pause_on_hover` text, `videogallery_list_effects_s` text, `description` text, `param` text, `sl_position` text NOT NULL, `ordering` int(11) NOT NULL, `published` text, `huge_it_sl_effects` text NOT NULL, `display_type` int(11) DEFAULT '2', `content_per_page` int(11) DEFAULT '5', `autoslide` varchar(3) DEFAULT 'on' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `wp_huge_it_videogallery_videos` -- CREATE TABLE `wp_huge_it_videogallery_videos` ( `id` int(11) UNSIGNED NOT NULL, `name` varchar(100) DEFAULT NULL, `videogallery_id` varchar(200) DEFAULT NULL, `description` text, `image_url` text, `sl_url` varchar(128) DEFAULT NULL, `sl_type` text NOT NULL, `link_target` text NOT NULL, `ordering` int(11) NOT NULL, `published` tinyint(4) UNSIGNED DEFAULT NULL, `published_in_sl_width` tinyint(4) UNSIGNED DEFAULT NULL, `thumb_url` text, `show_controls` varchar(3) DEFAULT 'on', `show_info` varchar(3) DEFAULT 'on' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `wp_layerslider` -- CREATE TABLE `wp_layerslider` ( `id` int(10) NOT NULL, `author` int(10) NOT NULL DEFAULT '0', `name` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '', `slug` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '', `data` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL, `date_c` int(10) NOT NULL, `date_m` int(10) NOT NULL, `schedule_start` int(10) NOT NULL DEFAULT '0', `schedule_end` int(10) NOT NULL DEFAULT '0', `flag_hidden` tinyint(1) NOT NULL DEFAULT '0', `flag_deleted` tinyint(1) NOT NULL DEFAULT '0', `flag_popup` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_layerslider_revisions` -- CREATE TABLE `wp_layerslider_revisions` ( `id` int(10) NOT NULL, `slider_id` int(10) NOT NULL, `author` int(10) NOT NULL DEFAULT '0', `data` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL, `date_c` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_links` -- CREATE TABLE `wp_links` ( `link_id` bigint(20) UNSIGNED NOT NULL, `link_url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_image` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_target` varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_description` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_visible` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y', `link_owner` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `link_rating` int(11) NOT NULL DEFAULT '0', `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `link_rel` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `link_notes` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL, `link_rss` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_login_redirects` -- CREATE TABLE `wp_login_redirects` ( `rul_type` enum('user','role','level','all','register') NOT NULL, `rul_value` varchar(191) DEFAULT NULL, `rul_url` longtext, `rul_url_logout` longtext, `rul_order` int(2) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_options` -- CREATE TABLE `wp_options` ( `option_id` bigint(20) UNSIGNED NOT NULL, `option_name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `option_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, `autoload` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_pmxi_files` -- CREATE TABLE `wp_pmxi_files` ( `id` bigint(20) UNSIGNED NOT NULL, `import_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `path` text COLLATE utf8mb4_unicode_520_ci, `registered_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_pmxi_history` -- CREATE TABLE `wp_pmxi_history` ( `id` bigint(20) UNSIGNED NOT NULL, `import_id` bigint(20) UNSIGNED NOT NULL, `type` enum('manual','processing','trigger','continue','') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `time_run` text COLLATE utf8mb4_unicode_520_ci, `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `summary` text COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_pmxi_imports` -- CREATE TABLE `wp_pmxi_imports` ( `id` bigint(20) UNSIGNED NOT NULL, `parent_import_id` bigint(20) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `friendly_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `feed_type` enum('xml','csv','zip','gz','') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `path` text COLLATE utf8mb4_unicode_520_ci, `xpath` text COLLATE utf8mb4_unicode_520_ci, `options` longtext COLLATE utf8mb4_unicode_520_ci, `registered_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `root_element` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '', `processing` tinyint(1) NOT NULL DEFAULT '0', `executing` tinyint(1) NOT NULL DEFAULT '0', `triggered` tinyint(1) NOT NULL DEFAULT '0', `queue_chunk_number` bigint(20) NOT NULL DEFAULT '0', `first_import` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `count` bigint(20) NOT NULL DEFAULT '0', `imported` bigint(20) NOT NULL DEFAULT '0', `created` bigint(20) NOT NULL DEFAULT '0', `updated` bigint(20) NOT NULL DEFAULT '0', `skipped` bigint(20) NOT NULL DEFAULT '0', `deleted` bigint(20) NOT NULL DEFAULT '0', `canceled` tinyint(1) NOT NULL DEFAULT '0', `canceled_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `failed` tinyint(1) NOT NULL DEFAULT '0', `failed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `settings_update_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_activity` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `iteration` bigint(20) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_pmxi_posts` -- CREATE TABLE `wp_pmxi_posts` ( `id` bigint(20) UNSIGNED NOT NULL, `post_id` bigint(20) UNSIGNED NOT NULL, `import_id` bigint(20) UNSIGNED NOT NULL, `unique_key` text COLLATE utf8mb4_unicode_520_ci, `product_key` text COLLATE utf8mb4_unicode_520_ci, `iteration` bigint(20) NOT NULL DEFAULT '0', `specified` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_pmxi_templates` -- CREATE TABLE `wp_pmxi_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `options` longtext COLLATE utf8mb4_unicode_520_ci, `scheduled` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `title` text COLLATE utf8mb4_unicode_520_ci, `content` longtext COLLATE utf8mb4_unicode_520_ci, `is_keep_linebreaks` tinyint(1) NOT NULL DEFAULT '0', `is_leave_html` tinyint(1) NOT NULL DEFAULT '0', `fix_characters` tinyint(1) NOT NULL DEFAULT '0', `meta` longtext COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_postmeta` -- CREATE TABLE `wp_postmeta` ( `meta_id` bigint(20) UNSIGNED NOT NULL, `post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_posts` -- CREATE TABLE `wp_posts` ( `ID` bigint(20) UNSIGNED NOT NULL, `post_author` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_title` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_excerpt` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish', `comment_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open', `ping_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open', `post_password` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `post_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `to_ping` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `pinged` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `post_content_filtered` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `guid` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `menu_order` int(11) NOT NULL DEFAULT '0', `post_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post', `post_mime_type` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `comment_count` bigint(20) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_revslider_css` -- CREATE TABLE `wp_revslider_css` ( `id` int(9) NOT NULL, `handle` text NOT NULL, `settings` longtext, `hover` longtext, `params` longtext NOT NULL, `advanced` longtext ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_revslider_layer_animations` -- CREATE TABLE `wp_revslider_layer_animations` ( `id` int(9) NOT NULL, `handle` text NOT NULL, `params` text NOT NULL, `settings` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_revslider_navigations` -- CREATE TABLE `wp_revslider_navigations` ( `id` int(9) NOT NULL, `name` varchar(191) NOT NULL, `handle` varchar(191) NOT NULL, `css` longtext NOT NULL, `markup` longtext NOT NULL, `settings` longtext ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_revslider_sliders` -- CREATE TABLE `wp_revslider_sliders` ( `id` int(9) NOT NULL, `title` tinytext NOT NULL, `alias` tinytext, `params` longtext NOT NULL, `settings` text, `type` varchar(191) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_revslider_slides` -- CREATE TABLE `wp_revslider_slides` ( `id` int(9) NOT NULL, `slider_id` int(9) NOT NULL, `slide_order` int(11) NOT NULL, `params` longtext NOT NULL, `layers` longtext NOT NULL, `settings` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_revslider_static_slides` -- CREATE TABLE `wp_revslider_static_slides` ( `id` int(9) NOT NULL, `slider_id` int(9) NOT NULL, `params` longtext NOT NULL, `layers` longtext NOT NULL, `settings` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_simple_locator_history` -- CREATE TABLE `wp_simple_locator_history` ( `id` int(10) UNSIGNED NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `user_ip` varchar(20) DEFAULT NULL, `search_lat` varchar(20) DEFAULT NULL, `search_lng` varchar(20) DEFAULT NULL, `search_term` varchar(100) DEFAULT NULL, `search_term_formatted` varchar(100) DEFAULT NULL, `distance` varchar(20) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_termmeta` -- CREATE TABLE `wp_termmeta` ( `meta_id` bigint(20) UNSIGNED NOT NULL, `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_terms` -- CREATE TABLE `wp_terms` ( `term_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `term_group` bigint(10) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_term_relationships` -- CREATE TABLE `wp_term_relationships` ( `object_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `term_order` int(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_term_taxonomy` -- CREATE TABLE `wp_term_taxonomy` ( `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL, `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `description` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, `parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `count` bigint(20) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_ultimate_csv_importer_log_values` -- CREATE TABLE `wp_ultimate_csv_importer_log_values` ( `id` int(10) NOT NULL, `eventKey` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL, `recordId` int(10) NOT NULL, `module` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL, `method_of_import` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL, `log_message` blob NOT NULL, `imported_time` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL, `mode_of_import` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL, `sequence` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL, `status` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL, `assigned_user_id` int(10) NOT NULL, `imported_by` int(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_ultimate_csv_importer_manageshortcodes` -- CREATE TABLE `wp_ultimate_csv_importer_manageshortcodes` ( `id` int(11) NOT NULL, `pID` int(20) DEFAULT NULL, `shortcode` varchar(110) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `eventkey` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `mode_of_code` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `module` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `populate_status` int(5) DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_ultimate_csv_importer_shortcodes_statusrel` -- CREATE TABLE `wp_ultimate_csv_importer_shortcodes_statusrel` ( `id` int(11) NOT NULL, `eventkey` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `shortcodes_count` int(20) DEFAULT NULL, `shortcode_mode` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `current_status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'Pending' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_fields` -- CREATE TABLE `wp_upicrm_fields` ( `field_id` int(11) NOT NULL, `field_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Dumping data for table `wp_upicrm_fields` -- INSERT INTO `wp_upicrm_fields` (`field_id`, `field_name`) VALUES (1, 'Name'), (2, 'Last name'), (3, 'Date'), (4, 'Message subject'), (5, 'Phone number mobile'), (6, 'Phone number work'), (7, 'Phone number'), (8, 'Email'), (9, 'Role'), (10, 'Company'), (11, 'Industry'), (12, 'Website'), (13, 'Product'), (14, 'Service'), (15, 'City'), (16, 'Street'), (17, 'Country'), (18, 'Zip code'), (19, 'Address'), (20, 'Fax number'), (21, 'Future contact allowed'), (22, 'Message details/Remarks'), (23, 'Received From'); -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_fields_mapping` -- CREATE TABLE `wp_upicrm_fields_mapping` ( `fm_id` int(11) NOT NULL, `field_id` int(11) NOT NULL, `fm_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `source_id` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `source_type` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Dumping data for table `wp_upicrm_fields_mapping` -- INSERT INTO `wp_upicrm_fields_mapping` (`fm_id`, `field_id`, `fm_name`, `source_id`, `source_type`) VALUES (1, 1, 'namess', '1221', 2), (2, 8, 'email', '1221', 2), (3, 7, 'tel', '1221', 2), (4, 22, 'Messege', '1221', 2), (5, 1, 'namess', '308', 2), (6, 2, 'namese', '308', 2), (7, 8, 'email', '308', 2), (8, 7, 'tel', '308', 2), (9, 22, 'Messege', '308', 2), (10, 21, 'checkbox-165', '308', 2), (11, 14, 'menu-675', '308', 2), (12, 1, 'yours-name', '148', 2), (13, 18, 'postcode', '148', 2), (14, 19, 'address', '148', 2), (15, 2, 'yours-name', '148', 2), (16, 7, 'phone', '148', 2), (17, 8, 'email', '148', 2), (18, 22, 'Message', '148', 2), (19, 1, 'your-name', '147', 2), (20, 8, 'email', '147', 2), (21, 7, 'phone', '147', 2), (22, 22, 'Messege', '147', 2), (23, 1, 'namess', '5', 2), (24, 8, 'email', '5', 2), (25, 22, 'Messege', '5', 2), (26, 12, 'web', '5', 2), (27, 4, 'car', '5', 2), (28, 23, 'recipient-email', '4170', 2), (29, 1, 'text-461', '4170', 2), (30, 7, 'text-460', '4170', 2), (31, 22, 'textarea-62', '4170', 2), (32, 8, 'email-871', '4170', 2), (33, 16, 'Message', '5', 2), (34, 28, 'your-email', '4170', 2), (35, 3, 'destination-email', '4170', 2), (36, 8, 'email-871', '4362', 2), (37, 8, 'email-871', '4159', 2), (38, 1, 'text-461', '4362', 2), (39, 8, 'email', '4363', 2), (40, 8, 'your-email', '4774', 2), (41, 9, 'your-subject', '4774', 2), (42, 1, 'text-461', '4775', 2), (43, 7, 'text-460', '4775', 2), (44, 8, 'your-email', '4775', 2), (45, 23, 'recipient-email', '4775', 2), (46, 22, 'textarea-62', '4775', 2); -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_integrations` -- CREATE TABLE `wp_upicrm_integrations` ( `integration_id` int(11) NOT NULL, `integration_domain` text, `integration_clean_domain` text NOT NULL, `integration_key` text, `integration_status` text, `integration_is_slave` int(1) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_leads` -- CREATE TABLE `wp_upicrm_leads` ( `lead_id` int(11) NOT NULL, `source_type` int(11) NOT NULL, `source_id` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `lead_content` text COLLATE utf8mb4_unicode_520_ci, `user_ip` text COLLATE utf8mb4_unicode_520_ci, `user_agent` text COLLATE utf8mb4_unicode_520_ci, `user_referer` text COLLATE utf8mb4_unicode_520_ci, `old_user_lead_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `lead_status_id` int(11) NOT NULL, `lead_management_comment` text COLLATE utf8mb4_unicode_520_ci, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `lead_webservice_transmission` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_leads_campaign` -- CREATE TABLE `wp_upicrm_leads_campaign` ( `lead_id` int(11) DEFAULT NULL, `utm_source` text COLLATE utf8mb4_unicode_520_ci, `utm_medium` text COLLATE utf8mb4_unicode_520_ci, `utm_term` text COLLATE utf8mb4_unicode_520_ci, `utm_content` text COLLATE utf8mb4_unicode_520_ci, `utm_campaign` text COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Dumping data for table `wp_upicrm_leads_campaign` -- INSERT INTO `wp_upicrm_leads_campaign` (`lead_id`, `utm_source`, `utm_medium`, `utm_term`, `utm_content`, `utm_campaign`) VALUES (48, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (53, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (65, 'FB website', NULL, NULL, NULL, 'FB website'), (22, 'FB DPF Deadline', NULL, NULL, NULL, 'FB DPF Deadline'), (27, 'Facebook', 'Adverts', NULL, 'MPG', 'AdSet4'), (29, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (66, 'FB website', NULL, NULL, NULL, 'FB website'), (135, 'FB website', NULL, NULL, NULL, 'FB website'), (161, 'FB DPF Deadline', NULL, NULL, NULL, 'FB DPF Deadline'), (179, 'FB DPF Deadline', NULL, NULL, NULL, 'FB DPF Deadline'), (293, 'FB website', NULL, NULL, NULL, 'FB website'), (310, 'FB website', NULL, NULL, NULL, 'FB website'), (319, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (322, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (339, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (344, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (346, 'FB website', NULL, NULL, NULL, 'FB website'), (363, 'FB website', NULL, NULL, NULL, 'FB website'), (369, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (371, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (373, 'FB website', NULL, NULL, NULL, 'FB website'), (374, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (419, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (438, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (439, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (440, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (446, 'FB DPF Blog', NULL, NULL, NULL, 'FB DPF Blog'), (453, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (454, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (455, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (456, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (459, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (460, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (461, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (463, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (464, 'FB DPF Blog', NULL, NULL, NULL, 'FB DPF Blog'), (469, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (473, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (496, 'FB website', NULL, NULL, NULL, 'FB website'), (583, 'FB DPF Blog', NULL, NULL, NULL, 'FB DPF Blog'), (627, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (633, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (636, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (672, 'FB case study', NULL, NULL, NULL, 'FB case study'), (690, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (696, 'FB DPF Blog', NULL, NULL, NULL, 'FB DPF Blog'), (697, 'FB DPF Blog', NULL, NULL, NULL, 'FB DPF Blog'), (758, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (771, 'FB case study', NULL, NULL, NULL, 'FB case study'), (783, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (784, 'FB case study', NULL, NULL, NULL, 'FB case study'), (803, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (814, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (819, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (820, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (829, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (832, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (833, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (834, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (857, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (877, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (883, 'FB DPF Blog', NULL, NULL, NULL, 'FB DPF Blog'), (910, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (911, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (935, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (936, 'FB drivers', NULL, NULL, NULL, 'FB drivers'), (998, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1006, 'FB case study', NULL, NULL, NULL, 'FB case study'), (1007, 'FB case study', NULL, NULL, NULL, 'FB case study'), (1011, 'FB website', NULL, NULL, NULL, 'FB website'), (1013, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1329, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (1331, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1363, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1572, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (1640, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (1650, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1651, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1655, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1656, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1673, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (1677, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1679, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1693, 'FB DPF rant', NULL, NULL, NULL, 'FB DPF rant'), (1714, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1715, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1736, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (1812, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1813, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1832, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1833, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1834, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1835, 'FB engine carbon clean', NULL, NULL, NULL, 'FB engine carbon clean'), (1882, 'FB MOT', NULL, NULL, NULL, 'FB MOT'), (1893, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (1901, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (1963, 'FB fleet', NULL, NULL, NULL, 'FB fleet'), (1975, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (1976, 'FB fleet', NULL, NULL, NULL, 'FB fleet'), (1977, 'FB fleet', NULL, NULL, NULL, 'FB fleet'), (1987, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (1990, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (1999, 'FB fleet', NULL, NULL, NULL, 'FB fleet'), (2007, 'FB performance', NULL, NULL, NULL, 'FB performance'), (2025, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (2046, 'FB clean dpf', NULL, NULL, NULL, 'FB clean dpf'), (2095, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2096, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2104, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2135, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2166, 'FB clean dpf', NULL, NULL, NULL, 'FB clean dpf'), (2180, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2182, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2192, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (2202, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2206, 'Facebook', 'Adverts', NULL, NULL, 'DPFHome'), (2209, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2210, 'FB fleet', NULL, NULL, NULL, 'FB fleet'), (2225, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2235, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2282, 'Facebook', 'Adverts', NULL, 'ad1', 'VidViews'), (2286, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (2291, 'FB DPF Landing page', NULL, NULL, NULL, 'FB DPF Landing page'), (2299, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (2300, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'), (2308, 'FB mot owners', NULL, NULL, NULL, 'FB mot owners'); -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_leads_integration` -- CREATE TABLE `wp_upicrm_leads_integration` ( `lead_integration_id` int(11) NOT NULL, `lead_id` int(11) NOT NULL, `lead_id_external` int(11) NOT NULL, `integration_id` int(11) NOT NULL, `lead_integration_status` text, `integration_is_slave` int(1) NOT NULL, `lead_integration_error` int(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_leads_route` -- CREATE TABLE `wp_upicrm_leads_route` ( `lead_route_id` int(11) NOT NULL, `lead_route_option` varchar(30) NOT NULL DEFAULT 'content', `field_id` text NOT NULL, `lead_route_type` int(11) NOT NULL, `lead_route_value` text NOT NULL, `lead_route_and` tinyint(1) NOT NULL, `lead_route_option2` varchar(30) NOT NULL DEFAULT 'content', `field_id2` text NOT NULL, `lead_route_type2` int(11) NOT NULL, `lead_route_value2` text NOT NULL, `leads_route_rr_users` text NOT NULL, `leads_route_rr_count` int(11) NOT NULL, `user_id` int(11) NOT NULL, `lead_status_id` int(11) NOT NULL, `change_field_id` int(11) NOT NULL, `change_field_value` text NOT NULL, `webservice_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_leads_status` -- CREATE TABLE `wp_upicrm_leads_status` ( `lead_status_id` int(11) NOT NULL, `lead_status_name` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Dumping data for table `wp_upicrm_leads_status` -- INSERT INTO `wp_upicrm_leads_status` (`lead_status_id`, `lead_status_name`) VALUES (1, 'Received'), (2, 'Qualified'), (3, 'Assigned'), (4, 'In process'), (5, 'Quote'), (6, 'Closing'), (7, 'Revenue'), (8, 'Not relevant'); -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_mails` -- CREATE TABLE `wp_upicrm_mails` ( `mail_id` int(11) NOT NULL, `mail_event` text COLLATE utf8mb4_unicode_520_ci, `mail_content` text COLLATE utf8mb4_unicode_520_ci, `mail_subject` text COLLATE utf8mb4_unicode_520_ci, `mail_cc` text COLLATE utf8mb4_unicode_520_ci, `mail_event_name` text COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_options` -- CREATE TABLE `wp_upicrm_options` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `value` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_users` -- CREATE TABLE `wp_upicrm_users` ( `inside_id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `user_parent_id` int(11) DEFAULT NULL, `user_label` text, `user_permission` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_webservice` -- CREATE TABLE `wp_upicrm_webservice` ( `webservice_id` int(11) NOT NULL, `webservice_method` int(11) NOT NULL, `webservice_status` int(11) NOT NULL, `webservice_url` text, `webservice_charset` varchar(100) NOT NULL DEFAULT 'UTF-8', `webservice_log` int(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_upicrm_webservice_parameters` -- CREATE TABLE `wp_upicrm_webservice_parameters` ( `webservice_parameter_id` int(11) NOT NULL, `webservice_id` int(11) NOT NULL, `webservice_parameter_option` varchar(30) NOT NULL DEFAULT 'content', `field_id` text, `webservice_parameter_value` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `wp_usermeta` -- CREATE TABLE `wp_usermeta` ( `umeta_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_520_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_users` -- CREATE TABLE `wp_users` ( `ID` bigint(20) UNSIGNED NOT NULL, `user_login` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_pass` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_nicename` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_url` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `user_status` int(11) NOT NULL DEFAULT '0', `display_name` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_wpmm_subscribers` -- CREATE TABLE `wp_wpmm_subscribers` ( `id_subscriber` bigint(20) NOT NULL, `email` varchar(50) NOT NULL, `insert_date` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `wp_yikes_easy_mc_forms` -- CREATE TABLE `wp_yikes_easy_mc_forms` ( `id` int(11) NOT NULL, `list_id` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `form_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `form_description` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `fields` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `custom_styles` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `custom_template` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `send_welcome_email` int(11) NOT NULL, `redirect_user_on_submit` int(11) NOT NULL, `redirect_page` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `submission_settings` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `optin_settings` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `form_settings` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `error_messages` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `custom_notifications` text COLLATE utf8mb4_unicode_520_ci NOT NULL, `impressions` int(11) NOT NULL, `submissions` int(11) NOT NULL, `custom_fields` text COLLATE utf8mb4_unicode_520_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_yoast_seo_links` -- CREATE TABLE `wp_yoast_seo_links` ( `id` bigint(20) UNSIGNED NOT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL, `post_id` bigint(20) UNSIGNED NOT NULL, `target_post_id` bigint(20) UNSIGNED NOT NULL, `type` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wp_yoast_seo_meta` -- CREATE TABLE `wp_yoast_seo_meta` ( `object_id` bigint(20) UNSIGNED NOT NULL, `internal_link_count` int(10) UNSIGNED DEFAULT NULL, `incoming_link_count` int(10) UNSIGNED DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `smackuci_events` -- ALTER TABLE `smackuci_events` ADD PRIMARY KEY (`id`); -- -- Indexes for table `smackuci_history` -- ALTER TABLE `smackuci_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `store_locator_country` -- ALTER TABLE `store_locator_country` ADD PRIMARY KEY (`id`); -- -- Indexes for table `store_locator_state` -- ALTER TABLE `store_locator_state` ADD PRIMARY KEY (`id`); -- -- Indexes for table `store_locator_transactions` -- ALTER TABLE `store_locator_transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_commentmeta` -- ALTER TABLE `wp_commentmeta` ADD PRIMARY KEY (`meta_id`), ADD KEY `comment_id` (`comment_id`), ADD KEY `meta_key` (`meta_key`(191)); -- -- Indexes for table `wp_comments` -- ALTER TABLE `wp_comments` ADD PRIMARY KEY (`comment_ID`), ADD KEY `comment_post_ID` (`comment_post_ID`), ADD KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`), ADD KEY `comment_date_gmt` (`comment_date_gmt`), ADD KEY `comment_parent` (`comment_parent`), ADD KEY `comment_author_email` (`comment_author_email`(10)); -- -- Indexes for table `wp_duplicator_packages` -- ALTER TABLE `wp_duplicator_packages` ADD PRIMARY KEY (`id`), ADD KEY `hash` (`hash`); -- -- Indexes for table `wp_gglcptch_whitelist` -- ALTER TABLE `wp_gglcptch_whitelist` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `ip` (`ip`); -- -- Indexes for table `wp_huge_it_videogallery_galleries` -- ALTER TABLE `wp_huge_it_videogallery_galleries` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_huge_it_videogallery_videos` -- ALTER TABLE `wp_huge_it_videogallery_videos` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_layerslider` -- ALTER TABLE `wp_layerslider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_layerslider_revisions` -- ALTER TABLE `wp_layerslider_revisions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_links` -- ALTER TABLE `wp_links` ADD PRIMARY KEY (`link_id`), ADD KEY `link_visible` (`link_visible`); -- -- Indexes for table `wp_login_redirects` -- ALTER TABLE `wp_login_redirects` ADD UNIQUE KEY `rul_type` (`rul_type`,`rul_value`); -- -- Indexes for table `wp_options` -- ALTER TABLE `wp_options` ADD PRIMARY KEY (`option_id`), ADD UNIQUE KEY `option_name` (`option_name`); -- -- Indexes for table `wp_pmxi_files` -- ALTER TABLE `wp_pmxi_files` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_pmxi_history` -- ALTER TABLE `wp_pmxi_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_pmxi_imports` -- ALTER TABLE `wp_pmxi_imports` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_pmxi_posts` -- ALTER TABLE `wp_pmxi_posts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_pmxi_templates` -- ALTER TABLE `wp_pmxi_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_postmeta` -- ALTER TABLE `wp_postmeta` ADD PRIMARY KEY (`meta_id`), ADD KEY `post_id` (`post_id`), ADD KEY `meta_key` (`meta_key`(191)); -- -- Indexes for table `wp_posts` -- ALTER TABLE `wp_posts` ADD PRIMARY KEY (`ID`), ADD KEY `post_name` (`post_name`(191)), ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`), ADD KEY `post_parent` (`post_parent`), ADD KEY `post_author` (`post_author`); -- -- Indexes for table `wp_revslider_css` -- ALTER TABLE `wp_revslider_css` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_revslider_layer_animations` -- ALTER TABLE `wp_revslider_layer_animations` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_revslider_navigations` -- ALTER TABLE `wp_revslider_navigations` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_revslider_sliders` -- ALTER TABLE `wp_revslider_sliders` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_revslider_slides` -- ALTER TABLE `wp_revslider_slides` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_revslider_static_slides` -- ALTER TABLE `wp_revslider_static_slides` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_simple_locator_history` -- ALTER TABLE `wp_simple_locator_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_termmeta` -- ALTER TABLE `wp_termmeta` ADD PRIMARY KEY (`meta_id`), ADD KEY `term_id` (`term_id`), ADD KEY `meta_key` (`meta_key`(191)); -- -- Indexes for table `wp_terms` -- ALTER TABLE `wp_terms` ADD PRIMARY KEY (`term_id`), ADD KEY `slug` (`slug`(191)), ADD KEY `name` (`name`(191)); -- -- Indexes for table `wp_term_relationships` -- ALTER TABLE `wp_term_relationships` ADD PRIMARY KEY (`object_id`,`term_taxonomy_id`), ADD KEY `term_taxonomy_id` (`term_taxonomy_id`); -- -- Indexes for table `wp_term_taxonomy` -- ALTER TABLE `wp_term_taxonomy` ADD PRIMARY KEY (`term_taxonomy_id`), ADD UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`), ADD KEY `taxonomy` (`taxonomy`); -- -- Indexes for table `wp_ultimate_csv_importer_log_values` -- ALTER TABLE `wp_ultimate_csv_importer_log_values` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_ultimate_csv_importer_manageshortcodes` -- ALTER TABLE `wp_ultimate_csv_importer_manageshortcodes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_ultimate_csv_importer_shortcodes_statusrel` -- ALTER TABLE `wp_ultimate_csv_importer_shortcodes_statusrel` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_upicrm_fields` -- ALTER TABLE `wp_upicrm_fields` ADD PRIMARY KEY (`field_id`); -- -- Indexes for table `wp_upicrm_fields_mapping` -- ALTER TABLE `wp_upicrm_fields_mapping` ADD PRIMARY KEY (`fm_id`); -- -- Indexes for table `wp_upicrm_integrations` -- ALTER TABLE `wp_upicrm_integrations` ADD PRIMARY KEY (`integration_id`); -- -- Indexes for table `wp_upicrm_leads` -- ALTER TABLE `wp_upicrm_leads` ADD PRIMARY KEY (`lead_id`); -- -- Indexes for table `wp_upicrm_leads_integration` -- ALTER TABLE `wp_upicrm_leads_integration` ADD PRIMARY KEY (`lead_integration_id`); -- -- Indexes for table `wp_upicrm_leads_route` -- ALTER TABLE `wp_upicrm_leads_route` ADD PRIMARY KEY (`lead_route_id`); -- -- Indexes for table `wp_upicrm_leads_status` -- ALTER TABLE `wp_upicrm_leads_status` ADD PRIMARY KEY (`lead_status_id`), ADD UNIQUE KEY `lead_status_name` (`lead_status_name`), ADD UNIQUE KEY `lead_status_name_2` (`lead_status_name`); -- -- Indexes for table `wp_upicrm_mails` -- ALTER TABLE `wp_upicrm_mails` ADD PRIMARY KEY (`mail_id`); -- -- Indexes for table `wp_upicrm_options` -- ALTER TABLE `wp_upicrm_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wp_upicrm_users` -- ALTER TABLE `wp_upicrm_users` ADD PRIMARY KEY (`inside_id`); -- -- Indexes for table `wp_upicrm_webservice` -- ALTER TABLE `wp_upicrm_webservice` ADD PRIMARY KEY (`webservice_id`); -- -- Indexes for table `wp_upicrm_webservice_parameters` -- ALTER TABLE `wp_upicrm_webservice_parameters` ADD PRIMARY KEY (`webservice_parameter_id`); -- -- Indexes for table `wp_usermeta` -- ALTER TABLE `wp_usermeta` ADD PRIMARY KEY (`umeta_id`), ADD KEY `user_id` (`user_id`), ADD KEY `meta_key` (`meta_key`(191)); -- -- Indexes for table `wp_users` -- ALTER TABLE `wp_users` ADD PRIMARY KEY (`ID`), ADD KEY `user_login_key` (`user_login`), ADD KEY `user_nicename` (`user_nicename`), ADD KEY `user_email` (`user_email`); -- -- Indexes for table `wp_wpmm_subscribers` -- ALTER TABLE `wp_wpmm_subscribers` ADD PRIMARY KEY (`id_subscriber`); -- -- Indexes for table `wp_yikes_easy_mc_forms` -- ALTER TABLE `wp_yikes_easy_mc_forms` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `wp_yoast_seo_links` -- ALTER TABLE `wp_yoast_seo_links` ADD PRIMARY KEY (`id`), ADD KEY `link_direction` (`post_id`,`type`); -- -- Indexes for table `wp_yoast_seo_meta` -- ALTER TABLE `wp_yoast_seo_meta` ADD UNIQUE KEY `object_id` (`object_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `smackuci_events` -- ALTER TABLE `smackuci_events` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `smackuci_history` -- ALTER TABLE `smackuci_history` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `store_locator_country` -- ALTER TABLE `store_locator_country` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=242; -- -- AUTO_INCREMENT for table `store_locator_state` -- ALTER TABLE `store_locator_state` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52; -- -- AUTO_INCREMENT for table `store_locator_transactions` -- ALTER TABLE `store_locator_transactions` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_commentmeta` -- ALTER TABLE `wp_commentmeta` MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `wp_comments` -- ALTER TABLE `wp_comments` MODIFY `comment_ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `wp_duplicator_packages` -- ALTER TABLE `wp_duplicator_packages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `wp_gglcptch_whitelist` -- ALTER TABLE `wp_gglcptch_whitelist` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_huge_it_videogallery_galleries` -- ALTER TABLE `wp_huge_it_videogallery_galleries` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `wp_huge_it_videogallery_videos` -- ALTER TABLE `wp_huge_it_videogallery_videos` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `wp_layerslider` -- ALTER TABLE `wp_layerslider` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_layerslider_revisions` -- ALTER TABLE `wp_layerslider_revisions` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_links` -- ALTER TABLE `wp_links` MODIFY `link_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_options` -- ALTER TABLE `wp_options` MODIFY `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=424127; -- -- AUTO_INCREMENT for table `wp_pmxi_files` -- ALTER TABLE `wp_pmxi_files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_pmxi_history` -- ALTER TABLE `wp_pmxi_history` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_pmxi_imports` -- ALTER TABLE `wp_pmxi_imports` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_pmxi_posts` -- ALTER TABLE `wp_pmxi_posts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_pmxi_templates` -- ALTER TABLE `wp_pmxi_templates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_postmeta` -- ALTER TABLE `wp_postmeta` MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41124; -- -- AUTO_INCREMENT for table `wp_posts` -- ALTER TABLE `wp_posts` MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4850; -- -- AUTO_INCREMENT for table `wp_revslider_css` -- ALTER TABLE `wp_revslider_css` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110; -- -- AUTO_INCREMENT for table `wp_revslider_layer_animations` -- ALTER TABLE `wp_revslider_layer_animations` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_revslider_navigations` -- ALTER TABLE `wp_revslider_navigations` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_revslider_sliders` -- ALTER TABLE `wp_revslider_sliders` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_revslider_slides` -- ALTER TABLE `wp_revslider_slides` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_revslider_static_slides` -- ALTER TABLE `wp_revslider_static_slides` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_simple_locator_history` -- ALTER TABLE `wp_simple_locator_history` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33152; -- -- AUTO_INCREMENT for table `wp_termmeta` -- ALTER TABLE `wp_termmeta` MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `wp_terms` -- ALTER TABLE `wp_terms` MODIFY `term_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `wp_term_taxonomy` -- ALTER TABLE `wp_term_taxonomy` MODIFY `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `wp_ultimate_csv_importer_log_values` -- ALTER TABLE `wp_ultimate_csv_importer_log_values` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=958; -- -- AUTO_INCREMENT for table `wp_ultimate_csv_importer_manageshortcodes` -- ALTER TABLE `wp_ultimate_csv_importer_manageshortcodes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_ultimate_csv_importer_shortcodes_statusrel` -- ALTER TABLE `wp_ultimate_csv_importer_shortcodes_statusrel` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_upicrm_fields` -- ALTER TABLE `wp_upicrm_fields` MODIFY `field_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `wp_upicrm_fields_mapping` -- ALTER TABLE `wp_upicrm_fields_mapping` MODIFY `fm_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47; -- -- AUTO_INCREMENT for table `wp_upicrm_integrations` -- ALTER TABLE `wp_upicrm_integrations` MODIFY `integration_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_upicrm_leads` -- ALTER TABLE `wp_upicrm_leads` MODIFY `lead_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2310; -- -- AUTO_INCREMENT for table `wp_upicrm_leads_integration` -- ALTER TABLE `wp_upicrm_leads_integration` MODIFY `lead_integration_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_upicrm_leads_route` -- ALTER TABLE `wp_upicrm_leads_route` MODIFY `lead_route_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `wp_upicrm_leads_status` -- ALTER TABLE `wp_upicrm_leads_status` MODIFY `lead_status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `wp_upicrm_mails` -- ALTER TABLE `wp_upicrm_mails` MODIFY `mail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `wp_upicrm_options` -- ALTER TABLE `wp_upicrm_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_upicrm_users` -- ALTER TABLE `wp_upicrm_users` MODIFY `inside_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=453; -- -- AUTO_INCREMENT for table `wp_upicrm_webservice` -- ALTER TABLE `wp_upicrm_webservice` MODIFY `webservice_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_upicrm_webservice_parameters` -- ALTER TABLE `wp_upicrm_webservice_parameters` MODIFY `webservice_parameter_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_usermeta` -- ALTER TABLE `wp_usermeta` MODIFY `umeta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9395; -- -- AUTO_INCREMENT for table `wp_users` -- ALTER TABLE `wp_users` MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=490; -- -- AUTO_INCREMENT for table `wp_wpmm_subscribers` -- ALTER TABLE `wp_wpmm_subscribers` MODIFY `id_subscriber` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_yikes_easy_mc_forms` -- ALTER TABLE `wp_yikes_easy_mc_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wp_yoast_seo_links` -- ALTER TABLE `wp_yoast_seo_links` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2810; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;