
--
-- 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 (340,1,0),(341,1,0),(342,1,0),(343,1,0),(344,1,0),(359,1,0),(374,1,0),(394,1,0),(424,1,0),(430,1,0),(435,1,0),(438,1,0),(443,1,0),(501,4,0),(501,15,0),(512,1,0),(522,19,0),(531,4,0),(531,15,0),(535,16,0),(554,1,0),(589,16,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=20 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,0),(2,2,'product_type','',0,0),(3,3,'product_type','',0,0),(4,4,'product_type','',0,2),(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,2),(16,16,'card_type','',0,2),(17,17,'card_type','',0,0),(18,18,'card_type','',0,0),(19,19,'card_type','',0,1);

--
-- 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_termmeta` VALUES (1,15,'product_count_product_cat','2');

--
-- 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=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_terms` VALUES (1,'Sem categoria','sem-categoria',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,'Sem categoria','sem-categoria',0),(16,'Advocacia','advocacia',0),(17,'Contabilidade','contabilidade',0),(18,'Academia','academia',0),(19,'Marketing','marketing',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=163 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_usermeta` VALUES (1,1,'nickname','Admin Webtouch'),(2,1,'first_name','Maira'),(3,1,'last_name','Torresani'),(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',''),(15,1,'show_welcome_panel','1'),(16,1,'session_tokens','a:2:{s:64:\"30dd210c22f2812a17a0d382c56bb0874fa7eab887e75e447b8e38a96c7eea18\";a:4:{s:10:\"expiration\";i:1572815127;s:2:\"ip\";s:3:\"::1\";s:2:\"ua\";s:120:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36\";s:5:\"login\";i:1572642327;}s:64:\"96497cf641e123deddf881083647ea7ee1810cf18cc69f42f8efaa5a44ef54de\";a:4:{s:10:\"expiration\";i:1572815486;s:2:\"ip\";s:14:\"201.48.143.147\";s:2:\"ua\";s:120:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36\";s:5:\"login\";i:1572642686;}}'),(17,1,'wp_user-settings','libraryContent=browse&editor=tinymce&advImgDetails=hide&imgsize=full'),(18,1,'wp_user-settings-time','1565724716'),(19,1,'wp_dashboard_quick_press_last_post_id','4'),(20,1,'community-events-location','a:1:{s:2:\"ip\";s:9:\"127.0.0.0\";}'),(21,1,'_woocommerce_tracks_anon_id','woo:tWlkWbjpfPYoFcW18qs1Qz8E'),(23,1,'dismissed_wc_admin_notice','1'),(24,1,'dismissed_no_secure_connection_notice','1'),(25,1,'wc_last_active','1572566400'),(28,1,'meta-box-order_dashboard','a:4:{s:6:\"normal\";s:28:\"woocommerce_dashboard_status\";s:4:\"side\";s:12:\"gadwp-widget\";s:7:\"column3\";s:24:\"wpseo-dashboard-overview\";s:7:\"column4\";s:31:\"simple_history_dashboard_widget\";}'),(30,2,'nickname','gerenciador'),(31,2,'first_name','Gerenciador'),(32,2,'last_name','do Site'),(33,2,'description',''),(34,2,'rich_editing','true'),(35,2,'syntax_highlighting','true'),(36,2,'comment_shortcuts','false'),(37,2,'admin_color','fresh'),(38,2,'use_ssl','0'),(39,2,'show_admin_bar_front','true'),(40,2,'locale',''),(41,2,'wp_capabilities','a:1:{s:12:\"site_manager\";b:1;}'),(42,2,'wp_user_level','0'),(43,2,'_yoast_wpseo_profile_updated','1565802734'),(44,2,'dismissed_wp_pointers',''),(45,2,'session_tokens','a:1:{s:64:\"363e6ce19db0ce6bcd3dc60180fa8e87e273a57fbf1bd50dcbe22b6d8f434bf0\";a:4:{s:10:\"expiration\";i:1565975587;s:2:\"ip\";s:9:\"127.0.0.1\";s:2:\"ua\";s:121:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36\";s:5:\"login\";i:1565802787;}}'),(46,2,'wc_last_active','1565740800'),(48,2,'_woocommerce_tracks_anon_id','woo:I33NzJGXXTf+oh/PnaycAmQM'),(49,2,'meta-box-order_dashboard','a:4:{s:6:\"normal\";s:28:\"woocommerce_dashboard_status\";s:4:\"side\";s:0:\"\";s:7:\"column3\";s:24:\"wpseo-dashboard-overview\";s:7:\"column4\";s:31:\"simple_history_dashboard_widget\";}'),(50,1,'closedpostboxes_cards','a:0:{}'),(51,1,'metaboxhidden_cards','a:3:{i:0;s:13:\"pageparentdiv\";i:1;s:7:\"slugdiv\";i:2;s:9:\"authordiv\";}'),(58,1,'closedpostboxes_acf-field-group','a:2:{i:0;s:22:\"plugins-by-dreihochzwo\";i:1;s:22:\"acf-field-group-fields\";}'),(59,1,'metaboxhidden_acf-field-group','a:1:{i:0;s:7:\"slugdiv\";}'),(60,1,'acf_user_settings','a:1:{s:15:\"show_field_keys\";s:1:\"0\";}'),(61,1,'_yoast_wpseo_profile_updated','1566233430'),(62,1,'wpseo_title',''),(63,1,'wpseo_metadesc',''),(64,1,'wpseo_noindex_author',''),(65,1,'wpseo_content_analysis_disable',''),(66,1,'wpseo_keyword_analysis_disable',''),(68,1,'billing_first_name','Maira'),(69,1,'billing_last_name','Torresani'),(70,1,'billing_cpf','101.803.309-26'),(71,1,'billing_address_1','Rua Henrique Knihs'),(72,1,'billing_number','585'),(73,1,'billing_address_2',''),(74,1,'billing_neighborhood','Águas Claras'),(75,1,'billing_city','Brusque'),(76,1,'billing_postcode','88353-690'),(77,1,'billing_country','BR'),(78,1,'billing_state','SC'),(79,1,'billing_phone','(47) 99199-3490'),(80,1,'billing_cellphone',''),(81,1,'billing_email','infra@sandbox.pagseguro.com.br'),(82,1,'shipping_first_name',''),(83,1,'shipping_last_name',''),(84,1,'shipping_company',''),(85,1,'shipping_address_1',''),(86,1,'shipping_number',''),(87,1,'shipping_address_2',''),(88,1,'shipping_neighborhood',''),(89,1,'shipping_city',''),(90,1,'shipping_postcode',''),(91,1,'shipping_country',''),(92,1,'shipping_state',''),(93,1,'facebook',''),(94,1,'instagram',''),(95,1,'linkedin',''),(96,1,'myspace',''),(97,1,'pinterest',''),(98,1,'soundcloud',''),(99,1,'tumblr',''),(100,1,'twitter',''),(101,1,'youtube',''),(102,1,'wikipedia',''),(103,1,'last_update','1566310947'),(104,1,'closedpostboxes_product','a:0:{}'),(105,1,'metaboxhidden_product','a:3:{i:0;s:14:\"product_catdiv\";i:1;s:19:\"tagsdiv-product_tag\";i:2;s:7:\"slugdiv\";}'),(106,1,'meta-box-order_cards','a:4:{s:15:\"acf_after_title\";s:0:\"\";s:4:\"side\";s:41:\"submitdiv,tagsdiv-card_type,pageparentdiv\";s:6:\"normal\";s:65:\"acf-group_5d5444bb1db6a,acf-group_5d544ee285e69,slugdiv,authordiv\";s:8:\"advanced\";s:0:\"\";}'),(107,1,'screen_layout_cards','2'),(110,1,'shipping_method',''),(111,3,'nickname','maira.torresani'),(112,3,'first_name','Maira'),(113,3,'last_name','Torresani'),(114,3,'description',''),(115,3,'rich_editing','true'),(116,3,'syntax_highlighting','true'),(117,3,'comment_shortcuts','false'),(118,3,'admin_color','fresh'),(119,3,'use_ssl','0'),(120,3,'show_admin_bar_front','true'),(121,3,'locale',''),(122,3,'wp_capabilities','a:1:{s:8:\"customer\";b:1;}'),(123,3,'wp_user_level','0'),(124,3,'_yoast_wpseo_profile_updated','1566413501'),(125,3,'session_tokens','a:1:{s:64:\"ac4407446a6b323a0df8e9c2472c8d0066776d8c3b4dd3debd3d4185b049f35f\";a:4:{s:10:\"expiration\";i:1567623102;s:2:\"ip\";s:9:\"127.0.0.1\";s:2:\"ua\";s:121:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36\";s:5:\"login\";i:1566413502;}}'),(126,3,'last_update','1566415398'),(127,3,'billing_first_name','Maira'),(128,3,'billing_last_name','Torresani'),(129,3,'billing_address_1','Rua Paulino Minella'),(130,3,'billing_city','Brusque'),(131,3,'billing_state','SC'),(132,3,'billing_postcode','88357-197'),(133,3,'billing_country','BR'),(134,3,'billing_email','maira@sandbox.pagseguro.com.br'),(135,3,'billing_phone','(47) 99199-3490'),(136,3,'shipping_method',''),(137,3,'billing_cpf','101.803.309-26'),(138,3,'billing_number','211'),(139,3,'billing_neighborhood','Santa Luzia'),(140,3,'billing_cellphone',''),(141,3,'wc_last_active','1566345600'),(143,3,'facebook',''),(144,3,'instagram',''),(145,3,'linkedin',''),(146,3,'myspace',''),(147,3,'pinterest',''),(148,3,'soundcloud',''),(149,3,'tumblr',''),(150,3,'twitter',''),(151,3,'youtube',''),(152,3,'wikipedia',''),(153,3,'paying_customer','1'),(154,3,'_woocommerce_tracks_anon_id','woo:NYnQbtGyoPQ6AwcANxjmMdLw'),(155,3,'wp_user-settings','libraryContent=browse&mfold=o'),(156,3,'wp_user-settings-time','1566416931'),(157,3,'wp_media_library_mode','grid'),(158,1,'wp_media_library_mode','list'),(162,1,'wp_yoast_notifications','a:2:{i:0;a:2:{s:7:\"message\";s:447:\"Yoast SEO e WooCommerce podem trabalhar juntos muito melhor adicionando um plugin auxiliar. Por favor, instale Yoast WooCommerce SEO para fazer sua vida melhor. <a href=\"https://yoa.st/1o0?php_version=7.2&platform=wordpress&platform_version=5.2.4&software=free&software_version=12.3&days_active=30plus&user_language=pt_BR\" aria-label=\"Mais informação sobre Yoast WooCommerce SEO\" target=\"_blank\" rel=\"noopener noreferrer\">Mais informações</a>.\";s:7:\"options\";a:9:{s:4:\"type\";s:7:\"warning\";s:2:\"id\";s:44:\"wpseo-suggested-plugin-yoast-woocommerce-seo\";s:5:\"nonce\";N;s:8:\"priority\";d:0.5;s:9:\"data_json\";a:0:{}s:13:\"dismissal_key\";N;s:12:\"capabilities\";a:1:{i:0;s:15:\"install_plugins\";}s:16:\"capability_check\";s:3:\"all\";s:14:\"yoast_branding\";b:0;}}i:1;a:2:{s:7:\"message\";s:287:\"<strong>Problema grave de SEO: Você está bloqueando o acesso dos robôs.</strong> Você deve <a href=\"http://homolog2.webtouch.com.br/cartao-digital/wp-admin/options-reading.php\">acessar as Configurações de leitura</a> e desmarcar a opção \"Visibilidade nos mecanismos de pesquisa\".\";s:7:\"options\";a:9:{s:4:\"type\";s:5:\"error\";s:2:\"id\";s:32:\"wpseo-dismiss-blog-public-notice\";s:5:\"nonce\";N;s:8:\"priority\";i:1;s:9:\"data_json\";a:0:{}s:13:\"dismissal_key\";N;s:12:\"capabilities\";s:20:\"wpseo_manage_options\";s:16:\"capability_check\";s:3:\"all\";s:14:\"yoast_branding\";b:0;}}}');

--
-- Table structure for table `wp_users`
--

CREATE TABLE `wp_users` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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 '',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`),
  KEY `user_email` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_users`
--

INSERT INTO `wp_users` VALUES (1,'Admin Webtouch','$P$Bjf9YV72oMvOVDkTLO6K37GWQhwuG4/','admin-webtouch','infra@webtouch.com.br','','2019-08-12 17:19:29','',0,'Admin Webtouch'),(2,'gerenciador','$P$BtxndnK5cI7wrx.Ph7246XNkZjjuff/','gerenciador','marcos@webtouch.com.br','','2019-08-14 17:12:13','',0,'Gerenciador do Site'),(3,'maira.torresani','$P$BZfrm.ysh9C.WRGT1T9QdsTulXy0Yg1','maira-torresani','maira@webtouch.com.br','','2019-08-21 18:51:41','',0,'Maira Torresani');

--
-- 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_product_meta_lookup`
--

CREATE TABLE `wp_wc_product_meta_lookup` (
  `product_id` bigint(20) NOT NULL,
  `sku` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  `virtual` tinyint(1) DEFAULT '0',
  `downloadable` tinyint(1) DEFAULT '0',
  `min_price` decimal(10,2) DEFAULT NULL,
  `max_price` decimal(10,2) DEFAULT NULL,
  `onsale` tinyint(1) DEFAULT '0',
  `stock_quantity` double DEFAULT NULL,
  `stock_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'instock',
  `rating_count` bigint(20) DEFAULT '0',
  `average_rating` decimal(3,2) DEFAULT '0.00',
  `total_sales` bigint(20) DEFAULT '0',
  PRIMARY KEY (`product_id`),
  KEY `virtual` (`virtual`),
  KEY `downloadable` (`downloadable`),
  KEY `stock_status` (`stock_status`),
  KEY `stock_quantity` (`stock_quantity`),
  KEY `onsale` (`onsale`),
  KEY `min_max_price` (`min_price`,`max_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_product_meta_lookup`
--

INSERT INTO `wp_wc_product_meta_lookup` VALUES (501,'',0,0,59.90,59.90,0,NULL,'instock',0,0.00,5),(502,'',1,0,59.90,59.90,0,NULL,'instock',0,0.00,0),(503,'',1,0,59.90,59.90,0,NULL,'instock',0,0.00,0),(504,'',1,0,59.90,59.90,0,NULL,'instock',0,0.00,0),(531,'',0,0,99.90,199.90,0,NULL,'instock',0,0.00,0),(532,'',0,0,99.90,99.90,0,NULL,'instock',0,0.00,0),(533,'',0,0,149.90,149.90,0,NULL,'instock',0,0.00,0),(534,'',0,0,199.90,199.90,0,NULL,'instock',0,0.00,0),(570,'',1,0,59.90,59.90,0,NULL,'instock',0,0.00,0);

--
-- Table structure for table `wp_wc_tax_rate_classes`
--

CREATE TABLE `wp_wc_tax_rate_classes` (
  `tax_rate_class_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 '',
  PRIMARY KEY (`tax_rate_class_id`),
  UNIQUE KEY `slug` (`slug`(191))
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_tax_rate_classes`
--

INSERT INTO `wp_wc_tax_rate_classes` VALUES (1,'Reduced rate','reduced-rate'),(2,'Zero rate','zero-rate'),(3,'Taxa reduzida','taxa-reduzida'),(4,'Taxa zero','taxa-zero');

--
-- 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`),
  KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`)
) 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 AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_woocommerce_order_itemmeta` VALUES (11,2,'_product_id','501'),(12,2,'_variation_id','570'),(13,2,'_qty','2'),(14,2,'_tax_class',''),(15,2,'_line_subtotal','119.8'),(16,2,'_line_subtotal_tax','0'),(17,2,'_line_total','119.8'),(18,2,'_line_tax','0'),(19,2,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(20,2,'modelo','Marketing'),(21,3,'_product_id','501'),(22,3,'_variation_id','502'),(23,3,'_qty','1'),(24,3,'_tax_class',''),(25,3,'_line_subtotal','59.9'),(26,3,'_line_subtotal_tax','0'),(27,3,'_line_total','59.9'),(28,3,'_line_tax','0'),(29,3,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(30,3,'modelo','Advocacia'),(31,4,'_product_id','501'),(32,4,'_variation_id','504'),(33,4,'_qty','1'),(34,4,'_tax_class',''),(35,4,'_line_subtotal','59.9'),(36,4,'_line_subtotal_tax','0'),(37,4,'_line_total','59.9'),(38,4,'_line_tax','0'),(39,4,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(40,4,'modelo','Academia'),(51,6,'_product_id','501'),(52,6,'_variation_id','502'),(53,6,'_qty','1'),(54,6,'_tax_class',''),(55,6,'_line_subtotal','59.9'),(56,6,'_line_subtotal_tax','0'),(57,6,'_line_total','59.9'),(58,6,'_line_tax','0'),(59,6,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(60,6,'modelo','Advocacia');

--
-- 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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_woocommerce_order_items` VALUES (2,'Cartão Digital Interativo Padrão - Marketing','line_item',572),(3,'Cartão Digital Interativo Padrão - Advocacia','line_item',573),(4,'Cartão Digital Interativo Padrão - Academia','line_item',573),(6,'Cartão Digital Interativo Padrão - Advocacia','line_item',588);

--
-- 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`
--


--
-- Table structure for table `wp_yoast_seo_links`
--

CREATE TABLE `wp_yoast_seo_links` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `link_direction` (`post_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_yoast_seo_links`
--


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

--
-- Dumping data for table `wp_yoast_seo_meta`
--

INSERT INTO `wp_yoast_seo_meta` VALUES (1,0,0),(2,0,0),(3,0,0),(4,0,0),(5,0,0),(6,0,0),(9,0,0),(10,0,0),(11,0,0),(12,0,0),(13,0,0),(14,0,0),(15,0,0),(16,0,0),(17,0,0),(18,0,0),(19,0,0),(20,0,0),(21,0,0),(23,0,0),(25,0,0),(339,0,0),(340,0,0),(341,0,0),(342,0,0),(343,0,0),(344,0,0),(345,0,0),(346,0,0),(347,0,0),(348,0,0),(349,0,0),(350,0,0),(351,0,0),(352,0,0),(353,0,0),(354,0,0),(355,0,0),(356,0,0),(357,0,0),(358,0,0),(359,0,0),(360,0,0),(363,0,0),(364,0,0),(365,0,0),(366,0,0),(367,0,0),(368,0,0),(369,0,0),(370,0,0),(371,0,0),(372,0,0),(373,0,0),(374,0,0),(375,0,0),(377,0,0),(379,0,0),(380,0,0),(381,0,0),(382,0,0),(383,0,0),(384,0,0),(385,0,0),(386,0,0),(387,0,0),(388,0,0),(389,0,0),(390,0,0),(391,0,0),(392,0,0),(393,0,0),(394,0,0),(395,0,0),(396,0,0),(397,0,0),(398,0,0),(399,0,0),(400,0,0),(401,0,0),(402,0,0),(403,0,0),(404,0,0),(405,0,0),(406,0,0),(407,0,0),(410,0,0),(411,0,0),(412,0,0),(413,0,0),(420,0,0),(421,0,0),(422,0,0),(424,0,0),(430,0,0),(435,0,0),(438,0,0),(439,0,0),(440,0,0),(441,0,0),(442,0,0),(443,0,0),(447,0,0),(475,0,0),(491,0,0),(495,0,0),(496,0,0),(497,0,0),(501,0,0),(506,0,0),(508,0,0),(509,0,0),(510,0,0),(511,0,0),(512,0,0),(514,0,0),(515,0,0),(516,0,0),(517,0,0),(518,0,0),(519,0,0),(520,0,0),(521,0,0),(522,0,0),(523,0,0),(525,0,0),(526,0,0),(527,0,0),(528,0,0),(530,0,0),(531,0,0),(535,0,0),(536,0,0),(550,0,0),(554,0,0),(560,0,0),(574,0,0),(575,0,0),(576,0,0),(577,0,0),(578,0,0),(579,0,0),(580,0,0),(581,0,0),(582,0,0),(583,0,0),(584,0,0),(586,0,0),(587,0,0),(589,0,0),(590,0,0),(591,0,0),(592,0,0),(593,0,0),(594,0,0),(602,0,0),(604,0,0);


