/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `wplc_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wplc_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `comment_author` tinytext NOT NULL,
  `comment_author_email` varchar(100) NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) 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 NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) NOT NULL DEFAULT '',
  `comment_type` varchar(20) NOT NULL DEFAULT 'comment',
  `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=147 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

INSERT INTO `wplc_comments` VALUES (130,925,'WooCommerce','woocommerce@dubdelivery.club','','','2022-08-25 11:16:13','2022-08-25 16:16:13','Payment to be made upon delivery. Order status changed from Pending payment to Processing.',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (131,1094,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 09:06:00','2022-10-14 14:06:00','Square  Charge Approved: MasterCard ending in 1305 (expires 3/23) (Transaction ID z5kWsZwJjvFPgoMVFSGpVEuxcdJZY)',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (132,1094,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 09:06:00','2022-10-14 14:06:00','Order status changed from Pending payment to Processing.',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (133,1094,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 09:06:18','2022-10-14 14:06:18','Order record synced to ActiveCampaign (ID: 2)',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (134,1094,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 09:09:04','2022-10-14 14:09:04','Customer Invoice send to PrintNode Automatically, Status Code : 201',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (135,1094,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 09:09:09','2022-10-14 14:09:09','Packing Slip send to PrintNode Automatically, Status Code : 201',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (136,1095,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 11:35:50','2022-10-14 16:35:50','Square  Charge Approved: MasterCard ending in 1305 (expires 3/23) (Transaction ID lAjcX0flxVsJEz5vUg450HZcRFYZY)',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (137,1095,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 11:35:51','2022-10-14 16:35:51','Order status changed from Pending payment to Processing.',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (138,1095,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 11:36:04','2022-10-14 16:36:04','Customer Invoice send to PrintNode Automatically, Status Code : 201',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (139,1095,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 11:36:10','2022-10-14 16:36:10','Packing Slip send to PrintNode Automatically, Status Code : 201',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (140,1095,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 11:36:12','2022-10-14 16:36:12','Order record synced to ActiveCampaign (ID: 3)',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (141,1095,'WooCommerce','woocommerce@dubdelivery.club','','','2022-10-14 11:36:13','2022-10-14 16:36:13','Order record synced to ActiveCampaign (ID: 3)',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (143,1117,'WooCommerce','woocommerce@dubdelivery.club','','','2022-12-18 09:53:46','2022-12-18 15:53:46','Payment to be made upon delivery. Order status changed from Pending payment to Processing.',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (144,1117,'WooCommerce','woocommerce@dubdelivery.club','','','2022-12-18 09:53:53','2022-12-18 15:53:53','Order record synced to ActiveCampaign (ID: 4)',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (145,1117,'WooCommerce','woocommerce@dubdelivery.club','','','2023-10-24 11:39:13','2023-10-24 16:39:13','ActiveCampaign for WC synced order\n			[Status: processing]',0,'1','WooCommerce','order_note',0,0);
INSERT INTO `wplc_comments` VALUES (146,8601,'WooCommerce','woocommerce@dubdelivery.club','','','2024-01-07 00:00:03','2024-01-07 06:00:03','Membership status changed from Active to Expired.',0,'1','WooCommerce','user_membership_note',0,0);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

