--
-- Host: localhost    Database: designwa_moviegaang
-- ------------------------------------------------------


--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_commentmeta`
--


--
-- Table structure for table `wp_comments`
--

CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`),
  KEY `comment_author_email` (`comment_author_email`(10)),
  KEY `woo_idx_comment_type` (`comment_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_comments`
--

INSERT INTO `wp_comments` VALUES (1,1,'A WordPress Commenter','wapuu@wordpress.example','https://wordpress.org/','','2019-01-17 14:19:08','2019-01-17 14:19:08','Hi, this is a comment.\nTo get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.\nCommenter avatars come from <a href=\"https://gravatar.com\">Gravatar</a>.',0,'1','','',0,0);

--
-- Table structure for table `wp_ewwwio_images`
--

CREATE TABLE `wp_ewwwio_images` (
  `id` int(14) unsigned NOT NULL AUTO_INCREMENT,
  `attachment_id` bigint(20) unsigned DEFAULT NULL,
  `gallery` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `resize` varchar(75) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `path` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `converted` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `results` varchar(75) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `image_size` int(10) unsigned DEFAULT NULL,
  `orig_size` int(10) unsigned DEFAULT NULL,
  `backup` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `level` int(5) unsigned DEFAULT NULL,
  `pending` tinyint(1) NOT NULL DEFAULT '0',
  `updates` int(5) unsigned DEFAULT NULL,
  `updated` timestamp NOT NULL DEFAULT '1970-12-31 18:30:00' ON UPDATE CURRENT_TIMESTAMP,
  `trace` blob,
  UNIQUE KEY `id` (`id`),
  KEY `path` (`path`(191)),
  KEY `attachment_info` (`gallery`(3),`attachment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_ewwwio_images`
--


--
-- Table structure for table `wp_ewwwio_queue`
--

CREATE TABLE `wp_ewwwio_queue` (
  `attachment_id` bigint(20) unsigned DEFAULT NULL,
  `gallery` varchar(10) DEFAULT NULL,
  `scanned` tinyint(1) NOT NULL DEFAULT '0',
  KEY `attachment_info` (`gallery`(3),`attachment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_ewwwio_queue`
--


--
-- Table structure for table `wp_links`
--

CREATE TABLE `wp_links` (
  `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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 '',
  PRIMARY KEY (`link_id`),
  KEY `link_visible` (`link_visible`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_links`
--


--
-- Table structure for table `wp_options`
--

CREATE TABLE `wp_options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name` (`option_name`)
) ENGINE=InnoDB AUTO_INCREMENT=662 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_options`
--



--
-- Table structure for table `wp_post_views`
--

CREATE TABLE `wp_post_views` (
  `id` bigint(20) unsigned NOT NULL,
  `type` tinyint(1) unsigned NOT NULL,
  `period` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `count` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`type`,`period`,`id`),
  UNIQUE KEY `id_type_period_count` (`id`,`type`,`period`,`count`) USING BTREE,
  KEY `type_period_count` (`type`,`period`,`count`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_post_views`
--


--
-- Table structure for table `wp_postmeta`
--

CREATE TABLE `wp_postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_postmeta`
--

INSERT INTO `wp_postmeta` VALUES (1,2,'_wp_page_template','default'),(2,3,'_wp_page_template','default'),(3,1,'_zilla_likes','0'),(8,7,'_wp_attached_file','2019/02/log_file_2019-02-13__17-25-56.txt'),(9,8,'_wp_attached_file','2019/02/log_file_2019-02-14__13-33-43.txt'),(12,10,'_form','<label> Your Name (required)\n    [text* your-name] </label>\n\n<label> Your Email (required)\n    [email* your-email] </label>\n\n<label> Subject\n    [text your-subject] </label>\n\n<label> Your Message\n    [textarea your-message] </label>\n\n[submit \"Send\"]'),(13,10,'_mail','a:8:{s:7:\"subject\";s:27:\"Moviegaang \"[your-subject]\"\";s:6:\"sender\";s:37:\"Moviegaang <wordpress@designwagon.in>\";s:4:\"body\";s:194:\"From: [your-name] <[your-email]>\nSubject: [your-subject]\n\nMessage Body:\n[your-message]\n\n-- \nThis e-mail was sent from a contact form on Moviegaang (http://designwagon.in/works/moviegaangdevelop)\";s:9:\"recipient\";s:18:\"v25vimal@gmail.com\";s:18:\"additional_headers\";s:22:\"Reply-To: [your-email]\";s:11:\"attachments\";s:0:\"\";s:8:\"use_html\";i:0;s:13:\"exclude_blank\";i:0;}'),(14,10,'_mail_2','a:9:{s:6:\"active\";b:0;s:7:\"subject\";s:27:\"Moviegaang \"[your-subject]\"\";s:6:\"sender\";s:37:\"Moviegaang <wordpress@designwagon.in>\";s:4:\"body\";s:136:\"Message Body:\n[your-message]\n\n-- \nThis e-mail was sent from a contact form on Moviegaang (http://designwagon.in/works/moviegaangdevelop)\";s:9:\"recipient\";s:12:\"[your-email]\";s:18:\"additional_headers\";s:28:\"Reply-To: v25vimal@gmail.com\";s:11:\"attachments\";s:0:\"\";s:8:\"use_html\";i:0;s:13:\"exclude_blank\";i:0;}'),(15,10,'_messages','a:8:{s:12:\"mail_sent_ok\";s:45:\"Thank you for your message. It has been sent.\";s:12:\"mail_sent_ng\";s:71:\"There was an error trying to send your message. Please try again later.\";s:16:\"validation_error\";s:61:\"One or more fields have an error. Please check and try again.\";s:4:\"spam\";s:71:\"There was an error trying to send your message. Please try again later.\";s:12:\"accept_terms\";s:69:\"You must accept the terms and conditions before sending your message.\";s:16:\"invalid_required\";s:22:\"The field is required.\";s:16:\"invalid_too_long\";s:22:\"The field is too long.\";s:17:\"invalid_too_short\";s:23:\"The field is too short.\";}'),(16,10,'_additional_settings',NULL),(17,10,'_locale','en_US');

--
-- 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',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_term_relationships`
--

INSERT INTO `wp_term_relationships` VALUES (1,1,0);

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_term_taxonomy`
--

INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,1),(2,2,'product_type','',0,0),(3,3,'product_type','',0,0),(4,4,'product_type','',0,0),(5,5,'product_type','',0,0),(6,6,'product_visibility','',0,0),(7,7,'product_visibility','',0,0),(8,8,'product_visibility','',0,0),(9,9,'product_visibility','',0,0),(10,10,'product_visibility','',0,0),(11,11,'product_visibility','',0,0),(12,12,'product_visibility','',0,0),(13,13,'product_visibility','',0,0),(14,14,'product_visibility','',0,0),(15,15,'product_cat','',0,0),(16,16,'category','',0,0),(17,17,'category','',0,0),(18,18,'category','',0,0),(19,19,'category','',0,0),(20,20,'category','',0,0),(21,21,'category','',0,0),(22,22,'category','',0,0),(23,23,'category','',0,0),(24,24,'category','',0,0),(25,25,'category','',0,0),(26,26,'category','',0,0),(27,27,'category','',0,0),(28,28,'category','',0,0),(29,29,'category','',0,0),(30,30,'category','',0,0),(31,31,'category','',0,0),(32,32,'post_tag','',0,0),(33,33,'post_tag','',0,0),(34,34,'post_tag','',0,0),(35,35,'post_tag','',0,0),(36,36,'post_tag','',0,0),(37,37,'post_tag','',0,0),(38,38,'post_tag','',0,0),(39,39,'post_tag','',0,0),(40,40,'post_tag','',0,0),(41,41,'post_tag','',0,0),(42,42,'post_tag','',0,0),(43,43,'post_tag','',0,0),(44,44,'post_tag','',0,0),(45,45,'post_tag','',0,0),(46,46,'post_tag','',0,0),(47,47,'post_tag','',0,0),(48,48,'post_tag','',0,0),(49,49,'post_tag','',0,0),(50,50,'post_tag','',0,0),(51,51,'post_tag','',0,0),(52,52,'post_tag','',0,0),(53,53,'post_tag','',0,0),(54,54,'post_tag','',0,0),(55,55,'post_tag','',0,0),(56,56,'post_tag','',0,0),(57,57,'post_tag','',0,0),(58,58,'post_tag','',0,0),(59,59,'post_tag','',0,0),(60,60,'post_tag','',0,0),(61,61,'post_tag','',0,0),(62,62,'post_tag','',0,0),(63,63,'post_tag','',0,0),(64,64,'post_tag','',0,0),(65,65,'post_tag','',0,0),(66,66,'post_tag','',0,0),(67,67,'post_tag','',0,0),(68,68,'post_tag','',0,0),(69,69,'post_tag','',0,0),(70,70,'post_tag','',0,0),(71,71,'post_tag','',0,0),(72,72,'post_tag','',0,0),(73,73,'post_tag','',0,0),(74,74,'post_tag','',0,0),(75,75,'post_tag','',0,0),(76,76,'post_tag','',0,0),(77,77,'post_tag','',0,0),(78,78,'post_tag','',0,0),(79,79,'post_tag','',0,0),(80,80,'post_tag','',0,0),(81,81,'post_tag','',0,0),(82,82,'post_tag','',0,0),(83,83,'post_tag','',0,0),(84,84,'post_tag','',0,0),(85,85,'post_tag','',0,0),(86,86,'post_tag','',0,0),(87,87,'post_tag','',0,0),(88,88,'post_tag','',0,0),(89,89,'post_tag','',0,0),(90,90,'post_tag','',0,0),(91,91,'post_tag','',0,0),(92,92,'post_tag','',0,0),(93,93,'post_tag','',0,0),(94,94,'post_tag','',0,0),(95,95,'post_tag','',0,0),(96,96,'post_tag','',0,0),(97,97,'post_tag','',0,0),(98,98,'post_tag','',0,0),(99,99,'post_tag','',0,0),(100,100,'post_tag','',0,0),(101,101,'post_tag','',0,0),(102,102,'post_tag','',0,0),(103,103,'post_tag','',0,0),(104,104,'post_tag','',0,0),(105,105,'post_tag','',0,0),(106,106,'post_tag','',0,0),(107,107,'post_tag','',0,0),(108,108,'post_tag','',0,0),(109,109,'post_tag','',0,0),(110,110,'post_tag','',0,0),(111,111,'post_tag','',0,0),(112,112,'post_tag','',0,0),(113,113,'post_tag','',0,0),(114,114,'post_tag','',0,0),(115,115,'post_tag','',0,0),(116,116,'post_tag','',0,0),(117,117,'post_tag','',0,0),(118,118,'post_tag','',0,0),(119,119,'post_tag','',0,0),(120,120,'post_tag','',0,0),(121,121,'post_tag','',0,0),(122,122,'post_tag','',0,0),(123,123,'post_tag','',0,0),(124,124,'post_tag','',0,0),(125,125,'post_tag','',0,0),(126,126,'post_tag','',0,0),(127,127,'post_tag','',0,0),(128,128,'post_tag','',0,0),(129,129,'post_tag','',0,0),(130,130,'post_tag','',0,0),(131,131,'post_tag','',0,0),(132,132,'post_tag','',0,0),(133,133,'post_tag','',0,0),(134,134,'post_tag','',0,0),(135,135,'post_tag','',0,0),(136,136,'post_tag','',0,0),(137,137,'post_tag','',0,0),(138,138,'post_tag','',0,0),(139,139,'post_tag','',0,0),(140,140,'post_tag','',0,0),(141,141,'post_tag','',0,0),(142,142,'post_tag','',0,0),(143,143,'post_tag','',0,0),(144,144,'post_tag','',0,0),(145,145,'post_tag','',0,0),(146,146,'post_tag','',0,0),(147,147,'post_tag','',0,0),(148,148,'post_tag','',0,0),(149,149,'post_tag','',0,0),(150,150,'post_tag','',0,0),(151,151,'post_tag','',0,0),(152,152,'post_tag','',0,0),(153,153,'post_tag','',0,0),(154,154,'post_tag','',0,0),(155,155,'post_tag','',0,0),(156,156,'post_tag','',0,0),(157,157,'post_tag','',0,0),(158,158,'post_tag','',0,0),(159,159,'post_tag','',0,0),(160,160,'post_tag','',0,0),(161,161,'post_tag','',0,0),(162,162,'post_tag','',0,0),(163,163,'post_tag','',0,0),(164,164,'post_tag','',0,0),(165,165,'post_tag','',0,0),(166,166,'post_tag','',0,0),(167,167,'post_tag','',0,0),(168,168,'post_tag','',0,0),(169,169,'post_tag','',0,0),(170,170,'post_tag','',0,0),(171,171,'post_tag','',0,0),(172,172,'post_tag','',0,0),(173,173,'post_tag','',0,0),(174,174,'post_tag','',0,0),(175,175,'post_tag','',0,0),(176,176,'post_tag','',0,0),(177,177,'post_tag','',0,0),(178,178,'post_tag','',0,0),(179,179,'post_tag','',0,0),(180,180,'post_tag','',0,0),(181,181,'post_tag','',0,0),(182,182,'post_tag','',0,0),(183,183,'post_tag','',0,0),(184,184,'post_tag','',0,0),(185,185,'post_tag','',0,0),(186,186,'post_tag','',0,0),(187,187,'post_tag','',0,0),(188,188,'post_tag','',0,0),(189,189,'post_tag','',0,0),(190,190,'post_tag','',0,0),(191,191,'post_tag','',0,0),(192,192,'post_tag','',0,0),(193,193,'post_tag','',0,0),(194,194,'post_tag','',0,0),(195,195,'post_tag','',0,0),(196,196,'post_tag','',0,0),(197,197,'post_tag','',0,0),(198,198,'post_tag','',0,0),(199,199,'post_tag','',0,0),(200,200,'post_tag','',0,0),(201,201,'post_tag','',0,0),(202,202,'post_tag','',0,0),(203,203,'post_tag','',0,0),(204,204,'post_tag','',0,0),(205,205,'post_tag','',0,0),(206,206,'post_tag','',0,0),(207,207,'post_tag','',0,0),(208,208,'post_tag','',0,0),(209,209,'post_tag','',0,0),(210,210,'post_tag','',0,0),(211,211,'post_tag','',0,0),(212,212,'post_tag','',0,0),(213,213,'post_tag','',0,0),(214,214,'post_tag','',0,0),(215,215,'post_tag','',0,0),(216,216,'post_tag','',0,0),(217,217,'post_tag','',0,0),(218,218,'post_tag','',0,0),(219,219,'post_tag','',0,0),(220,220,'post_tag','',0,0),(221,221,'post_tag','',0,0),(222,222,'post_tag','',0,0),(223,223,'post_tag','',0,0),(224,224,'post_tag','',0,0),(225,225,'nav_menu','',0,0),(226,226,'nav_menu','',0,0),(227,227,'post_format','',0,0),(228,228,'post_format','',0,0),(229,229,'post_format','',0,0),(230,230,'post_format','',0,0),(231,231,'post_format','',0,0),(232,232,'nav_menu','',0,0);

--
-- Table structure for table `wp_termmeta`
--

CREATE TABLE `wp_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_termmeta`
--


--
-- Table structure for table `wp_terms`
--

CREATE TABLE `wp_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_terms`
--

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'simple','simple',0),(3,'grouped','grouped',0),(4,'variable','variable',0),(5,'external','external',0),(6,'exclude-from-search','exclude-from-search',0),(7,'exclude-from-catalog','exclude-from-catalog',0),(8,'featured','featured',0),(9,'outofstock','outofstock',0),(10,'rated-1','rated-1',0),(11,'rated-2','rated-2',0),(12,'rated-3','rated-3',0),(13,'rated-4','rated-4',0),(14,'rated-5','rated-5',0),(15,'Uncategorized','uncategorized',0),(16,'Agriculture','agriculture',0),(17,'Basketball','basketball',0),(18,'Business','business',0),(19,'Cricket','cricket',0),(20,'Entertainment','entertainment',0),(21,'Fashion','fashion',0),(22,'Foods','foods',0),(23,'Football','football',0),(24,'Health','health',0),(25,'Lifestyle','lifestyle',0),(26,'Politics','politics',0),(27,'Racing','racing',0),(28,'Sports','sports',0),(29,'Technology','technology',0),(30,'Travel','travel',0),(31,'Wildlife','wildlife',0),(32,'agriculture','agriculture',0),(33,'aircraft','aircraft',0),(34,'airplane','airplane',0),(35,'allies','allies',0),(36,'analysis','analysis',0),(37,'announcement','announcement',0),(38,'anonymous day','anonymous-day',0),(39,'archary','archary',0),(40,'baba','baba',0),(41,'basket','basket',0),(42,'basketball','basketball',0),(43,'basketball player','basketball-player',0),(44,'beach','beach',0),(45,'beach life','beach-life',0),(46,'beauty','beauty',0),(47,'biggest wheel','biggest-wheel',0),(48,'bike','bike',0),(49,'bike race','bike-race',0),(50,'birds','birds',0),(51,'blue dress','blue-dress',0),(52,'boating','boating',0),(53,'books','books',0),(54,'boot','boot',0),(55,'bowler','bowler',0),(56,'boxing','boxing',0),(57,'building','building',0),(58,'burger','burger',0),(59,'Business','business',0),(60,'busy city','busy-city',0),(61,'butterfly','butterfly',0),(62,'car race','car-race',0),(63,'cats','cats',0),(64,'cheering','cheering',0),(65,'chicken','chicken',0),(66,'children','children',0),(67,'chinese fashion','chinese-fashion',0),(68,'circeling','circeling',0),(69,'classic jacket','classic-jacket',0),(70,'cobra','cobra',0),(71,'competition','competition',0),(72,'concert','concert',0),(73,'conference','conference',0),(74,'construction','construction',0),(75,'cool batsman','cool-batsman',0),(76,'court','court',0),(77,'cricket fan','cricket-fan',0),(78,'cricket player','cricket-player',0),(79,'cycling','cycling',0),(80,'daily news','daily-news',0),(81,'dance','dance',0),(82,'deal','deal',0),(83,'Desert','desert',0),(84,'dessert','dessert',0),(85,'doctors','doctors',0),(86,'dream','dream',0),(87,'dressup','dressup',0),(88,'drone','drone',0),(89,'dry fruits','dry-fruits',0),(90,'ducks','ducks',0),(91,'entertainment','entertainment',0),(92,'exercise','exercise',0),(93,'facebook','facebook',0),(94,'family cricket','family-cricket',0),(95,'family food','family-food',0),(96,'family travel','family-travel',0),(97,'fashion','fashion',0),(98,'fashion dress','fashion-dress',0),(99,'fashion life','fashion-life',0),(100,'fitness','fitness',0),(101,'flower','flower',0),(102,'food','food',0),(103,'food dish','food-dish',0),(104,'food item','food-item',0),(105,'food items','food-items',0),(106,'foods','foods',0),(107,'football','football',0),(108,'football match','football-match',0),(109,'french food','french-food',0),(110,'fried rice','fried-rice',0),(111,'friends','friends',0),(112,'friends time','friends-time',0),(113,'friends travel','friends-travel',0),(114,'fruits','fruits',0),(115,'fun','fun',0),(116,'fun time','fun-time',0),(117,'game','game',0),(118,'geenday','geenday',0),(119,'giant wheel','giant-wheel',0),(120,'girl','girl',0),(121,'golden food','golden-food',0),(122,'grapes','grapes',0),(123,'green looks','green-looks',0),(124,'guru','guru',0),(125,'gym','gym',0),(126,'halloween','halloween',0),(127,'handsome guy','handsome-guy',0),(128,'highest peak','highest-peak',0),(129,'history place','history-place',0),(130,'horse riding','horse-riding',0),(131,'horses','horses',0),(132,'intel','intel',0),(133,'international','international',0),(134,'jet plane','jet-plane',0),(135,'journey','journey',0),(136,'jungle safari','jungle-safari',0),(137,'laboratory','laboratory',0),(138,'lady','lady',0),(139,'laptops','laptops',0),(140,'laundry','laundry',0),(141,'leg pain','leg-pain',0),(142,'legal','legal',0),(143,'life','life',0),(144,'lifestyle','lifestyle',0),(145,'lion','lion',0),(146,'lizard','lizard',0),(147,'long ride','long-ride',0),(148,'love','love',0),(149,'management','management',0),(150,'map walk','map-walk',0),(151,'marriage ceremony','marriage-ceremony',0),(152,'marriage dress','marriage-dress',0),(153,'Marshmello','marshmello',0),(154,'match','match',0),(155,'men working','men-working',0),(156,'modern boy','modern-boy',0),(157,'music','music',0),(158,'nano chips','nano-chips',0),(159,'nature','nature',0),(160,'new','new',0),(161,'night party','night-party',0),(162,'night song','night-song',0),(163,'obama','obama',0),(164,'old man','old-man',0),(165,'Olympics','olympics',0),(166,'one piece','one-piece',0),(167,'online sale','online-sale',0),(168,'oranges','oranges',0),(169,'paddy','paddy',0),(170,'paradise','paradise',0),(171,'Paris','paris',0),(172,'party','party',0),(173,'photograph','photograph',0),(174,'picnic','picnic',0),(175,'plan','plan',0),(176,'playing','playing',0),(177,'playing football','playing-football',0),(178,'politics','politics',0),(179,'public voices','public-voices',0),(180,'pumpkin','pumpkin',0),(181,'racing','racing',0),(182,'rhino','rhino',0),(183,'rider','rider',0),(184,'road race','road-race',0),(185,'roaming','roaming',0),(186,'roti','roti',0),(187,'runner','runner',0),(188,'running','running',0),(189,'russia','russia',0),(190,'sea travel','sea-travel',0),(191,'sea view','sea-view',0),(192,'singer','singer',0),(193,'skirts','skirts',0),(194,'snacks','snacks',0),(195,'snake','snake',0),(196,'spacex','spacex',0),(197,'sports','sports',0),(198,'sports car','sports-car',0),(199,'standard lifestyle','standard-lifestyle',0),(200,'swimming','swimming',0),(201,'technology','technology',0),(202,'thoughts','thoughts',0),(203,'time','time',0),(204,'tomato','tomato',0),(205,'tortoise','tortoise',0),(206,'travel','travel',0),(207,'trophy','trophy',0),(208,'trump','trump',0),(209,'usa','usa',0),(210,'usa government','usa-government',0),(211,'vacation','vacation',0),(212,'vegetables','vegetables',0),(213,'village style','village-style',0),(214,'virtual reality','virtual-reality',0),(215,'voices','voices',0),(216,'white dress','white-dress',0),(217,'white pigeon','white-pigeon',0),(218,'wicket','wicket',0),(219,'wild animal','wild-animal',0),(220,'women','women',0),(221,'women voice','women-voice',0),(222,'worldcup','worldcup',0),(223,'yoga. class','yoga-class',0),(224,'youths','youths',0),(225,'Footer Menu','footer-menu',0),(226,'Main Menu','main-menu',0),(227,'post-format-audio','post-format-audio',0),(228,'post-format-gallery','post-format-gallery',0),(229,'post-format-link','post-format-link',0),(230,'post-format-quote','post-format-quote',0),(231,'post-format-video','post-format-video',0),(232,'Top Menu','top-menu',0);

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_usermeta`
--

INSERT INTO `wp_usermeta` VALUES (1,1,'nickname','admin'),(2,1,'first_name',''),(3,1,'last_name',''),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'syntax_highlighting','true'),(7,1,'comment_shortcuts','false'),(8,1,'admin_color','fresh'),(9,1,'use_ssl','0'),(10,1,'show_admin_bar_front','true'),(11,1,'locale',''),(12,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(13,1,'wp_user_level','10'),(14,1,'dismissed_wp_pointers','wp496_privacy'),(15,1,'show_welcome_panel','1'),(16,1,'session_tokens','a:1:{s:64:\"a4a810e1c3ddb36c86268949d6d1abc84e5d46c4ce40da61373a20c6f62381c2\";a:4:{s:10:\"expiration\";i:1550250910;s:2:\"ip\";s:13:\"42.109.145.17\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36\";s:5:\"login\";i:1550078110;}}'),(17,1,'wp_dashboard_quick_press_last_post_id','4'),(18,1,'community-events-location','a:1:{s:2:\"ip\";s:11:\"103.61.12.0\";}'),(19,1,'_woocommerce_persistent_cart_1','a:1:{s:4:\"cart\";a:0:{}}'),(20,1,'wc_last_active','1550102400');

--
-- Table structure for table `wp_wc_download_log`
--

CREATE TABLE `wp_wc_download_log` (
  `download_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `user_ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  PRIMARY KEY (`download_log_id`),
  KEY `permission_id` (`permission_id`),
  KEY `timestamp` (`timestamp`),
  CONSTRAINT `fk_wp_wc_download_log_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `wp_woocommerce_downloadable_product_permissions` (`permission_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_download_log`
--


--
-- Table structure for table `wp_wc_webhooks`
--

CREATE TABLE `wp_wc_webhooks` (
  `webhook_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `delivery_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `secret` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `topic` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `api_version` smallint(4) NOT NULL,
  `failure_count` smallint(10) NOT NULL DEFAULT '0',
  `pending_delivery` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`webhook_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_webhooks`
--


--
-- Table structure for table `wp_woocommerce_api_keys`
--

CREATE TABLE `wp_woocommerce_api_keys` (
  `key_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `description` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `permissions` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `consumer_key` char(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `consumer_secret` char(43) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `nonces` longtext COLLATE utf8mb4_unicode_520_ci,
  `truncated_key` char(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `last_access` datetime DEFAULT NULL,
  PRIMARY KEY (`key_id`),
  KEY `consumer_key` (`consumer_key`),
  KEY `consumer_secret` (`consumer_secret`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_api_keys`
--


--
-- Table structure for table `wp_woocommerce_attribute_taxonomies`
--

CREATE TABLE `wp_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_label` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `attribute_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_orderby` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_public` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`attribute_id`),
  KEY `attribute_name` (`attribute_name`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_attribute_taxonomies`
--


--
-- Table structure for table `wp_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `wp_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `download_id` varchar(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `order_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_email` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `access_expires` datetime DEFAULT NULL,
  `download_count` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`permission_id`),
  KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
  KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_downloadable_product_permissions`
--


--
-- Table structure for table `wp_woocommerce_log`
--

CREATE TABLE `wp_woocommerce_log` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `level` smallint(4) NOT NULL,
  `source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `context` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`log_id`),
  KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_log`
--


--
-- Table structure for table `wp_woocommerce_order_itemmeta`
--

CREATE TABLE `wp_woocommerce_order_itemmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `order_item_id` (`order_item_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_order_itemmeta`
--


--
-- Table structure for table `wp_woocommerce_order_items`
--

CREATE TABLE `wp_woocommerce_order_items` (
  `order_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `order_item_type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `order_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_order_items`
--


--
-- Table structure for table `wp_woocommerce_payment_tokenmeta`
--

CREATE TABLE `wp_woocommerce_payment_tokenmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payment_token_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `payment_token_id` (`payment_token_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_payment_tokenmeta`
--


--
-- Table structure for table `wp_woocommerce_payment_tokens`
--

CREATE TABLE `wp_woocommerce_payment_tokens` (
  `token_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gateway_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `token` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`token_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_payment_tokens`
--


--
-- Table structure for table `wp_woocommerce_sessions`
--

CREATE TABLE `wp_woocommerce_sessions` (
  `session_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `session_key` char(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `session_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `session_expiry` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`session_id`),
  UNIQUE KEY `session_key` (`session_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_sessions`
--


--
-- Table structure for table `wp_woocommerce_shipping_zone_locations`
--

CREATE TABLE `wp_woocommerce_shipping_zone_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_id` bigint(20) unsigned NOT NULL,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `location_id` (`location_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zone_locations`
--


--
-- Table structure for table `wp_woocommerce_shipping_zone_methods`
--

CREATE TABLE `wp_woocommerce_shipping_zone_methods` (
  `zone_id` bigint(20) unsigned NOT NULL,
  `instance_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `method_order` bigint(20) unsigned NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zone_methods`
--


--
-- Table structure for table `wp_woocommerce_shipping_zones`
--

CREATE TABLE `wp_woocommerce_shipping_zones` (
  `zone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `zone_order` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zones`
--


--
-- Table structure for table `wp_woocommerce_tax_rate_locations`
--

CREATE TABLE `wp_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `tax_rate_id` bigint(20) unsigned NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_tax_rate_locations`
--


--
-- Table structure for table `wp_woocommerce_tax_rates`
--

CREATE TABLE `wp_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_rate_country` varchar(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate_priority` bigint(20) unsigned NOT NULL,
  `tax_rate_compound` int(1) NOT NULL DEFAULT '0',
  `tax_rate_shipping` int(1) NOT NULL DEFAULT '1',
  `tax_rate_order` bigint(20) unsigned NOT NULL,
  `tax_rate_class` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`tax_rate_id`),
  KEY `tax_rate_country` (`tax_rate_country`),
  KEY `tax_rate_state` (`tax_rate_state`(2)),
  KEY `tax_rate_class` (`tax_rate_class`(10)),
  KEY `tax_rate_priority` (`tax_rate_priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_tax_rates`
--



