--
-- Host: localhost    Database: proviska_ai
-- ------------------------------------------------------


--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action` varchar(100) NOT NULL,
  `details` json DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `license_key` varchar(255) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_action` (`action`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_license_key` (`license_key`),
  KEY `idx_logs_action_created` (`action`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` VALUES (1,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"544\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752322038_5863&pf_payment_id=2608370&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=599.00&amount_fee=-13.78&amount_net=585.22&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-12+12%3A07%3A18&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Customer&name_last=Purchase&email_address=customer%40example.com&merchant_id=10033492&signature=4be0acc947dc909e0148e070effbb310\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Purchase\", \"signature\": \"4be0acc947dc909e0148e070effbb310\", \"amount_fee\": \"-13.78\", \"amount_net\": \"585.22\", \"name_first\": \"Customer\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-12 12:07:18\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"599.00\", \"m_payment_id\": \"cmdsharp_single_1752322038_5863\", \"email_address\": \"customer@example.com\", \"pf_payment_id\": \"2608370\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-12 12:07:33'),(2,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"MANUAL-9-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 07:37:38'),(3,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 07:41:09'),(4,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 07:59:17'),(5,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 08:06:58'),(6,'lemonsqueezy_webhook_received','{\"event_name\": \"unknown\", \"webhook_id\": \"unknown\", \"custom_data\": []}',NULL,NULL,NULL,NULL,'2025-07-13 08:50:24'),(7,'lemonsqueezy_webhook_ignored','{\"reason\": \"Unsupported event type\", \"event_name\": \"\"}',NULL,NULL,NULL,NULL,'2025-07-13 08:50:24'),(8,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7\", \"Pragma\": \"no-cache\", \"Connection\": \"keep-alive, close\", \"User-Agent\": \"Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1\", \"Cache-Control\": \"no-cache\", \"Accept-Encoding\": \"gzip\", \"Accept-Language\": \"zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7\", \"Upgrade-Insecure-Requests\": \"1\"}, \"raw_data\": \"\", \"post_data\": []}',NULL,NULL,NULL,NULL,'2025-07-13 08:59:09'),(9,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 09:16:54'),(10,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 09:17:18'),(11,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 09:23:14'),(12,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"MANUAL-9-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 11:04:05'),(13,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 11:05:03'),(14,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 11:05:22'),(15,'license_activated','{\"channel\": \"direct\", \"device_id\": \"device_7d6fce8f65a91041_1752404722\", \"user_email\": \"\", \"device_name\": \"Unknown Device\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 11:05:22'),(16,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 12:28:40'),(17,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 12:28:40'),(18,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 13:45:29'),(19,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 13:45:29'),(20,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 15:14:54'),(21,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 15:14:54'),(22,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 15:22:59'),(23,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 15:22:59'),(24,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 16:34:54'),(25,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 16:34:54'),(26,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"543\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752425940_2488&pf_payment_id=2609178&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+16%3A59%3A00&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Customer&name_last=Purchase&email_address=customer%40example.com&merchant_id=10033492&signature=2cf39c57ad1394a107634187b89f720b\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Purchase\", \"signature\": \"2cf39c57ad1394a107634187b89f720b\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Customer\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 16:59:00\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752425940_2488\", \"email_address\": \"customer@example.com\", \"pf_payment_id\": \"2609178\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 16:59:56'),(27,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"543\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752428356_2482&pf_payment_id=2609197&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+17%3A39%3A16&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Customer&name_last=Purchase&email_address=customer%40example.com&merchant_id=10033492&signature=4c9533e2f07497f17eff03d6502d4506\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Purchase\", \"signature\": \"4c9533e2f07497f17eff03d6502d4506\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Customer\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 17:39:16\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752428356_2482\", \"email_address\": \"customer@example.com\", \"pf_payment_id\": \"2609197\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 17:39:30'),(28,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"543\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752429059_7602&pf_payment_id=2609201&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+17%3A50%3A59&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Customer&name_last=Purchase&email_address=customer%40example.com&merchant_id=10033492&signature=3cdda04c56dcec353ba11395190cdd19\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Purchase\", \"signature\": \"3cdda04c56dcec353ba11395190cdd19\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Customer\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 17:50:59\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752429059_7602\", \"email_address\": \"customer@example.com\", \"pf_payment_id\": \"2609201\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 17:51:09'),(29,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"543\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752430075_6434&pf_payment_id=2609207&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+18%3A07%3A55&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Customer&name_last=Purchase&email_address=customer%40example.com&merchant_id=10033492&signature=b0bbb1f0d4535b40f5a65d19bfeee15d\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Purchase\", \"signature\": \"b0bbb1f0d4535b40f5a65d19bfeee15d\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Customer\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 18:07:55\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752430075_6434\", \"email_address\": \"customer@example.com\", \"pf_payment_id\": \"2609207\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 18:08:06'),(30,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 18:49:31'),(31,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 18:49:31'),(32,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"538\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752433730_1043&pf_payment_id=2609240&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+19%3A08%3A50&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=c46cc495ed6364abde3c34a799a0a4dd\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"c46cc495ed6364abde3c34a799a0a4dd\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 19:08:50\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752433730_1043\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609240\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 19:09:00'),(33,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"462\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752434245_4807&pf_payment_id=2609250&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=&custom_str2=&custom_str3=&custom_str4=&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=caf8f16e26a1ae25039d1ce206c1a45c\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"caf8f16e26a1ae25039d1ce206c1a45c\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"\", \"custom_str2\": \"\", \"custom_str3\": \"\", \"custom_str4\": \"\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752434245_4807\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609250\", \"payment_status\": \"COMPLETE\", \"item_description\": \"\"}}',NULL,NULL,NULL,NULL,'2025-07-13 19:17:37'),(34,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Expect\": \"100-continue\", \"Referer\": \"https://sandbox.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"multipart/form-data; boundary=------------------------bd2a2c57c3dbe3df\", \"Content-Length\": \"2508\"}, \"raw_data\": \"\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"caf8f16e26a1ae25039d1ce206c1a45c\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"\", \"custom_str2\": \"\", \"custom_str3\": \"\", \"custom_str4\": \"\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752434245_4807\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609250\", \"payment_status\": \"COMPLETE\", \"item_description\": \"\"}}',NULL,NULL,NULL,NULL,'2025-07-13 19:19:59'),(35,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"462\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752434747_2944&pf_payment_id=2609256&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=&custom_str2=&custom_str3=&custom_str4=&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=3b3e9252d44f02db27724b09993e0adc\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"3b3e9252d44f02db27724b09993e0adc\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"\", \"custom_str2\": \"\", \"custom_str3\": \"\", \"custom_str4\": \"\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752434747_2944\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609256\", \"payment_status\": \"COMPLETE\", \"item_description\": \"\"}}',NULL,NULL,NULL,NULL,'2025-07-13 19:25:56'),(36,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"462\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752436565_2572&pf_payment_id=2609271&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=&custom_str2=&custom_str3=&custom_str4=&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=9e74ae2f7a50401c64a222575414ed23\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"9e74ae2f7a50401c64a222575414ed23\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"\", \"custom_str2\": \"\", \"custom_str3\": \"\", \"custom_str4\": \"\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752436565_2572\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609271\", \"payment_status\": \"COMPLETE\", \"item_description\": \"\"}}',NULL,NULL,NULL,NULL,'2025-07-13 19:56:19'),(37,'payfast_webhook_error','{\"error\": \"SQLSTATE[01000]: Warning: 1265 Data truncated for column \'license_type\' at row 1\", \"payment_id\": \"cmdsharp_single_1752436565_2572\"}',NULL,NULL,NULL,NULL,'2025-07-13 19:56:19'),(38,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"538\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752437305_1020&pf_payment_id=2609275&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+20%3A08%3A25&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=914b4cc5b4022c0b15047e3e7b5cfe5e\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"914b4cc5b4022c0b15047e3e7b5cfe5e\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:08:25\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752437305_1020\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609275\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 20:08:33'),(39,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:08:35'),(40,'license_created','{\"amount\": 399, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752437305_1020\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:08:35'),(41,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"538\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752437984_7138&pf_payment_id=2609280&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+20%3A19%3A44&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=f442530227e69b1c41a8180f09b3f714\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"f442530227e69b1c41a8180f09b3f714\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:19:44\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752437984_7138\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609280\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 20:19:53'),(42,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:19:54'),(43,'license_created','{\"amount\": 399, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752437984_7138\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:19:54'),(44,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"538\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752438656_8955&pf_payment_id=2609283&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+20%3A30%3A56&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=b264dbce8893abc743b81af8e4eac562\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"b264dbce8893abc743b81af8e4eac562\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:30:56\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752438656_8955\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609283\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 20:31:06'),(45,'webhook_data_extracted','{\"amount\": 399, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752438656_8955\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:31:06'),(46,'attempting_email_send','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:31:06'),(47,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"mail\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:31:06'),(48,'license_created','{\"amount\": 399, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752438656_8955\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:31:06'),(49,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"538\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752439224_8062&pf_payment_id=2609285&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+20%3A40%3A24&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=09b59e9791da9d72699aa057304fa5da\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"09b59e9791da9d72699aa057304fa5da\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:40:24\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752439224_8062\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609285\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 20:40:35'),(50,'webhook_data_extracted','{\"amount\": 399, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752439224_8062\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:40:35'),(51,'attempting_email_send','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:40:35'),(52,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"mail\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:40:36'),(53,'license_created','{\"amount\": 399, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752439224_8062\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:40:36'),(54,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"538\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752440186_3284&pf_payment_id=2609290&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+20%3A56%3A26&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=9c6dfa6cc7094b3b5347d3da6ab7ea3d\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"9c6dfa6cc7094b3b5347d3da6ab7ea3d\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:56:26\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752440186_3284\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609290\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 20:56:35'),(55,'webhook_data_extracted','{\"amount\": 399, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752440186_3284\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:56:35'),(56,'attempting_email_send','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:56:35'),(57,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:56:37'),(58,'license_created','{\"amount\": 399, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752440186_3284\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-13 20:56:37'),(59,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"538\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752441111_8871&pf_payment_id=2609293&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-13+21%3A11%3A51&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=aad825eec86fef88dd69d5d9da285160\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"aad825eec86fef88dd69d5d9da285160\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 21:11:51\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752441111_8871\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609293\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-13 21:12:00'),(60,'webhook_data_extracted','{\"amount\": 399, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752441111_8871\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\"}',NULL,NULL,NULL,NULL,'2025-07-13 21:12:00'),(61,'attempting_email_send','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-13 21:12:00'),(62,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-13 21:12:03'),(63,'license_created','{\"amount\": 399, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752441111_8871\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-13 21:12:03'),(64,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"539\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752479321_7859&pf_payment_id=2609531&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=399.00&amount_fee=-9.18&amount_net=389.82&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-14+07%3A48%3A41&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Gerda&name_last=Vermeulen&email_address=gerda%40micode.co.za&merchant_id=10033492&signature=9bdacb71faf4b6f6b9452d7e8d7f61fe\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Vermeulen\", \"signature\": \"9bdacb71faf4b6f6b9452d7e8d7f61fe\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Gerda\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-14 07:48:41\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752479321_7859\", \"email_address\": \"gerda@micode.co.za\", \"pf_payment_id\": \"2609531\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-14 07:48:58'),(65,'webhook_data_extracted','{\"amount\": 399, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752479321_7859\", \"license_type\": \"single\", \"customer_name\": \"Gerda Vermeulen\", \"customer_email\": \"gerda@micode.co.za\"}',NULL,NULL,NULL,NULL,'2025-07-14 07:48:58'),(66,'attempting_email_send','{\"email\": \"gerda@micode.co.za\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-14 07:48:58'),(67,'license_email_sent','{\"email\": \"gerda@micode.co.za\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 07:49:10'),(68,'license_created','{\"amount\": 399, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752479321_7859\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-14 07:49:10'),(69,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 08:31:13'),(70,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 08:31:58'),(71,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"539\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752484326_4644&pf_payment_id=2609709&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=499.00&amount_fee=-11.48&amount_net=487.52&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-14+09%3A12%3A06&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=8c0eeefbf8d934c7ef26e0015fdb6eda\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"8c0eeefbf8d934c7ef26e0015fdb6eda\", \"amount_fee\": \"-11.48\", \"amount_net\": \"487.52\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-14 09:12:06\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"499.00\", \"m_payment_id\": \"cmdsharp_single_1752484326_4644\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609709\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-14 09:12:19'),(72,'webhook_data_extracted','{\"amount\": 499, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752484326_4644\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\"}',NULL,NULL,NULL,NULL,'2025-07-14 09:12:19'),(73,'attempting_email_send','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-14 09:12:19'),(74,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 09:12:24'),(75,'license_created','{\"amount\": 499, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752484326_4644\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-14 09:12:24'),(76,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 11:50:45'),(77,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 11:50:45'),(78,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 11:54:19'),(79,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 11:54:19'),(80,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 12:42:56'),(81,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 12:42:56'),(82,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 12:55:29'),(83,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 12:55:29'),(84,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 13:04:59'),(85,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 13:04:59'),(86,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 13:27:31'),(87,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 13:27:31'),(88,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 14:27:17'),(89,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 14:27:17'),(90,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 15:06:19'),(91,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 15:06:19'),(92,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 15:41:21'),(93,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 15:41:21'),(94,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 15:53:13'),(95,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 15:53:13'),(96,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:04:54'),(97,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:04:54'),(98,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:16:02'),(99,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:16:02'),(100,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:31:36'),(101,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:31:36'),(102,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:44:25'),(103,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:44:25'),(104,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:55:51'),(105,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 16:55:51'),(106,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 17:02:26'),(107,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 17:02:26'),(108,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 17:10:31'),(109,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 17:10:31'),(110,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 17:12:23'),(111,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 17:12:23'),(112,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 17:27:37'),(113,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 17:27:37'),(114,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 18:18:59'),(115,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 18:18:59'),(116,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 18:37:23'),(117,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 18:37:23'),(118,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 18:49:10'),(119,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 18:49:10'),(120,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 18:57:56'),(121,'license_activated','{\"channel\": \"direct\", \"device_id\": \"device_997400ddb25404f1_1752519476\", \"user_email\": \"\", \"device_name\": \"Unknown Device\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 18:57:56'),(122,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 19:10:35'),(123,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 19:10:35'),(124,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 19:26:45'),(125,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 19:26:45'),(126,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 19:31:11'),(127,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 19:31:11'),(128,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 19:54:28'),(129,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 19:54:28'),(130,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:03:51'),(131,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:03:51'),(132,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:38:51'),(133,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:38:51'),(134,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:44:37'),(135,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:44:37'),(136,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:48:50'),(137,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:48:50'),(138,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:54:19'),(139,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 20:54:19'),(140,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 21:00:00'),(141,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 21:00:00'),(142,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 21:10:12'),(143,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 21:10:12'),(144,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 21:16:52'),(145,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 21:16:52'),(146,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 21:33:17'),(147,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 21:33:17'),(148,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 22:40:16'),(149,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 22:40:16'),(150,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 23:56:45'),(151,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-14 23:56:45'),(152,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 00:58:59'),(153,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 00:58:59'),(154,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 02:01:55'),(155,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 02:01:55'),(156,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 03:03:08'),(157,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 03:03:08'),(158,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 04:06:18'),(159,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 04:06:19'),(160,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 05:06:25'),(161,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 05:06:25'),(162,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 06:07:25'),(163,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 06:07:25'),(164,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 07:08:10'),(165,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 07:08:10'),(166,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 07:57:53'),(167,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 07:57:53'),(168,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:28:21'),(169,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:31:26'),(170,'license_activated','{\"channel\": \"direct\", \"device_id\": \"device_f8d6d7a783b9614d_1752582686\", \"user_email\": \"\", \"device_name\": \"Unknown Device\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:31:26'),(171,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:34:11'),(172,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:34:11'),(173,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:34:33'),(174,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:34:33'),(175,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:58:14'),(176,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 12:58:14'),(177,'lemonsqueezy_webhook_received','{\"event_name\": \"order_created\", \"webhook_id\": \"5952850\", \"custom_data\": {\"channel\": \"direct\", \"currency\": \"USD\", \"timestamp\": \"2025-07-15 12:38:34\", \"payment_id\": \"cmdsharp_single_1752583114_1315\", \"license_type\": \"single\"}}',NULL,NULL,NULL,NULL,'2025-07-15 13:07:54'),(178,'license_email_sent','{\"email\": \"support@proviska.com\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:07:57'),(179,'license_created','{\"amount\": 49.99, \"channel\": \"direct\", \"currency\": \"USD\", \"payment_id\": \"cmdsharp_single_1752583114_1315\", \"license_key\": \"CMDSHARP-****\", \"ls_order_id\": \"\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:07:57'),(180,'lemonsqueezy_webhook_received','{\"event_name\": \"order_created\", \"webhook_id\": \"5952992\", \"custom_data\": {\"channel\": \"direct\", \"currency\": \"USD\", \"timestamp\": \"2025-07-15 13:26:06\", \"payment_id\": \"cmdsharp_single_1752585966_2141\", \"license_type\": \"single\"}}',NULL,NULL,NULL,NULL,'2025-07-15 13:28:28'),(181,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:28:32'),(182,'license_created','{\"amount\": 49.99, \"channel\": \"direct\", \"currency\": \"USD\", \"payment_id\": \"cmdsharp_single_1752585966_2141\", \"license_key\": \"CMDSHARP-****\", \"ls_order_id\": \"\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:28:32'),(183,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:35:18'),(184,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:35:18'),(185,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:35:51'),(186,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:35:51'),(187,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"539\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752586884_1241&pf_payment_id=2612201&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=499.00&amount_fee=-11.48&amount_net=487.52&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-15+13%3A41%3A24&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=4d3419dc922538220700b4eb55af02ab\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"4d3419dc922538220700b4eb55af02ab\", \"amount_fee\": \"-11.48\", \"amount_net\": \"487.52\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-15 13:41:24\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"499.00\", \"m_payment_id\": \"cmdsharp_single_1752586884_1241\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2612201\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-15 13:41:35'),(188,'webhook_data_extracted','{\"amount\": 499, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752586884_1241\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:41:35'),(189,'attempting_email_send','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:41:35'),(190,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:41:38'),(191,'license_created','{\"amount\": 499, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752586884_1241\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:41:38'),(192,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:49:49'),(193,'license_activated','{\"channel\": \"direct\", \"device_id\": \"device_57cfbc223cc606d4_1752587389\", \"user_email\": \"\", \"device_name\": \"Unknown Device\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 13:49:49'),(194,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 14:16:18'),(195,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 14:16:18'),(196,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 14:32:45'),(197,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 14:32:45'),(198,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 15:55:41'),(199,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 15:55:41'),(200,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:00:44'),(201,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:00:44'),(202,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:27:31'),(203,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:27:31'),(204,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:27:53'),(205,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:27:53'),(206,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:31:09'),(207,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:31:09'),(208,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:32:11'),(209,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:32:11'),(210,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:32:16'),(211,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:32:16'),(212,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:58:25'),(213,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 16:58:25'),(214,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 17:02:31'),(215,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 17:02:31'),(216,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 17:03:10'),(217,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 17:03:10'),(218,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 17:52:22'),(219,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-15 17:52:22'),(220,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 06:33:09'),(221,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 06:33:09'),(222,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 06:56:37'),(223,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 06:56:37'),(224,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 07:02:25'),(225,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 07:02:25'),(226,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 07:19:14'),(227,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 07:19:14'),(228,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 07:38:49'),(229,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 07:38:49'),(230,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 07:54:14'),(231,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 07:54:14'),(232,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 08:20:16'),(233,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 08:20:16'),(234,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 08:47:40'),(235,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 08:47:40'),(236,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 08:56:52'),(237,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 08:56:52'),(238,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 09:12:08'),(239,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 09:12:08'),(240,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 09:27:01'),(241,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 09:27:01'),(242,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 10:21:46'),(243,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 10:21:46'),(244,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 10:39:13'),(245,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 10:39:13'),(246,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 10:46:40'),(247,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 10:46:40'),(248,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 11:18:04'),(249,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 11:18:04'),(250,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 11:26:34'),(251,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 11:26:34'),(252,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 11:38:59'),(253,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 11:38:59'),(254,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:02:18'),(255,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:02:18'),(256,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:04:15'),(257,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:04:15'),(258,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:18:51'),(259,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:18:51'),(260,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:31:10'),(261,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:31:10'),(262,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:51:57'),(263,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 12:51:57'),(264,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:01:05'),(265,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:01:05'),(266,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:09:19'),(267,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:09:19'),(268,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:14:49'),(269,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:14:49'),(270,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:42:56'),(271,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:42:56'),(272,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:59:00'),(273,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 13:59:00'),(274,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 14:17:19'),(275,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 14:17:20'),(276,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 14:32:24'),(277,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 14:32:24'),(278,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 14:35:53'),(279,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 14:35:53'),(280,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 14:48:52'),(281,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 14:48:52'),(282,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 15:07:13'),(283,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 15:07:13'),(284,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 15:41:33'),(285,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 15:41:33'),(286,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 16:02:45'),(287,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 16:02:45'),(288,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 16:08:04'),(289,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 16:08:04'),(290,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 16:12:01'),(291,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 16:12:01'),(292,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 16:26:52'),(293,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 16:26:52'),(294,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 17:18:55'),(295,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 17:18:55'),(296,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 17:30:01'),(297,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 17:30:01'),(298,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 17:36:39'),(299,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 17:36:39'),(300,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 17:40:33'),(301,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 17:40:33'),(302,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 18:40:34'),(303,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 18:40:34'),(304,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 19:40:33'),(305,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 19:40:33'),(306,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 21:19:04'),(307,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 21:19:04'),(308,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 22:28:36'),(309,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 22:28:36'),(310,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 23:33:02'),(311,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-16 23:33:02'),(312,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 00:37:29'),(313,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 00:37:29'),(314,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 01:43:58'),(315,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 01:43:58'),(316,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 02:44:17'),(317,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 02:44:17'),(318,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 03:45:11'),(319,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 03:45:11'),(320,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 04:45:15'),(321,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 04:45:15'),(322,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 05:45:44'),(323,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 05:45:44'),(324,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 06:49:57'),(325,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 06:49:57'),(326,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:08:09'),(327,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:08:09'),(328,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:16:56'),(329,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:16:56'),(330,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:26:43'),(331,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:26:43'),(332,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:38:41'),(333,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:38:41'),(334,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:44:44'),(335,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:44:44'),(336,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:48:51'),(337,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 07:48:51'),(338,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 08:02:16'),(339,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 08:02:16'),(340,'appsumo_license_activation_error','{\"data\": {\"error\": \"Failed to create license in database: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`proviska_ai`.`licenses`, CONSTRAINT `licenses_ibfk_1` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`payment_id`) ON DELETE SET NULL)\", \"trace\": \"#0 /var/www/html/proviska-ai/lib/AppSumoService.php(57): AppSumoService->createLicense()\\n#1 /var/www/html/proviska-ai/api/appsumo-test.php(106): AppSumoService->processLicenseActivation()\\n#2 /var/www/html/proviska-ai/api/appsumo-test.php(33): simulateWebhookCall()\\n#3 {main}\", \"source\": \"webhook\"}, \"event\": \"LICENSE_ACTIVATION_ERROR\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 09:13:20'),(341,'appsumo_license_created','{\"email\": \"olwagenw@gmail.com\", \"source\": \"webhook\", \"payment_id\": \"appsumo_webhook_1752744614_5808\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 09:30:14'),(342,'appsumo_email_sent','{\"data\": {\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"buyer_name\": \"AppSumo Test\"}, \"event\": \"EMAIL_SENT\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 09:30:18'),(343,'appsumo_license_activated','{\"data\": {\"source\": \"webhook\", \"license\": {\"source\": \"appsumo_webhook\", \"status\": \"active\", \"channel\": \"app_sumo\", \"payment_id\": \"appsumo_webhook_1752744614_5808\", \"license_key\": \"CMDSHARP-2OA2-3JH3-3JY7\", \"license_type\": \"single\", \"customer_name\": \"AppSumo Test\", \"customer_email\": \"olwagenw@gmail.com\", \"max_activations\": 99}, \"email_sent\": true, \"user_email\": \"olwagenw@gmail.com\"}, \"event\": \"LICENSE_ACTIVATED\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 09:30:18'),(344,'appsumo_license_created','{\"email\": \"olwagenw@gmail.com\", \"source\": \"webhook\", \"payment_id\": \"appsumo_webhook_1752747530_9335\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 10:18:50'),(345,'appsumo_email_sent','{\"data\": {\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"buyer_name\": \"Wouter Olwagen\"}, \"event\": \"EMAIL_SENT\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 10:18:54'),(346,'appsumo_license_activated','{\"data\": {\"source\": \"webhook\", \"license\": {\"source\": \"appsumo_webhook\", \"status\": \"active\", \"channel\": \"app_sumo\", \"payment_id\": \"appsumo_webhook_1752747530_9335\", \"license_key\": \"CMDSHARP-8DK8-1LX0-9P9M\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\", \"max_activations\": 99}, \"email_sent\": true, \"user_email\": \"olwagenw@gmail.com\"}, \"event\": \"LICENSE_ACTIVATED\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 10:18:54'),(347,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 10:53:47'),(348,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 10:53:47'),(349,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 11:21:09'),(350,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 11:21:09'),(351,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 12:21:10'),(352,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 12:21:10'),(353,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"539\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752756680_7226&pf_payment_id=2705533&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=499.00&amount_fee=-11.48&amount_net=487.52&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-17+12%3A51%3A20&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=dd65f35c2e9262231aa975125f89ad29\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"dd65f35c2e9262231aa975125f89ad29\", \"amount_fee\": \"-11.48\", \"amount_net\": \"487.52\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-17 12:51:20\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"499.00\", \"m_payment_id\": \"cmdsharp_single_1752756680_7226\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2705533\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-17 12:51:30'),(354,'webhook_data_extracted','{\"amount\": 499, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752756680_7226\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\"}',NULL,NULL,NULL,NULL,'2025-07-17 12:51:30'),(355,'attempting_email_send','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-17 12:51:30'),(356,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 12:51:34'),(357,'license_created','{\"amount\": 499, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752756680_7226\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-17 12:51:34'),(358,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:04:17'),(359,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:04:17'),(360,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:05:25'),(361,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:05:25'),(362,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:09:33'),(363,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:09:33'),(364,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:14:05'),(365,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:14:05'),(366,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:27:49'),(367,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:27:49'),(368,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"app_sumo\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 13:55:29'),(369,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"activate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 14:14:18'),(370,'license_activated','{\"channel\": \"direct\", \"device_id\": \"device_b277769550bbde04_1752761658\", \"user_email\": \"\", \"device_name\": \"Unknown Device\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 14:14:18'),(371,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 14:14:39'),(372,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 14:14:39'),(373,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 15:14:40'),(374,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 15:14:40'),(375,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 16:53:12'),(376,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 16:53:12'),(377,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 17:11:17'),(378,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 17:11:17'),(379,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 17:17:48'),(380,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 17:17:48'),(381,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 17:43:50'),(382,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 17:43:50'),(383,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 18:18:28'),(384,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 18:18:28'),(385,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 18:42:31'),(386,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 18:42:31'),(387,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 18:46:32'),(388,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 18:46:32'),(389,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 18:57:54'),(390,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 18:57:54'),(391,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 19:10:21'),(392,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 19:10:21'),(393,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 19:23:27'),(394,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 19:23:27'),(395,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 19:45:21'),(396,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 19:45:21'),(397,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:01:23'),(398,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:01:23'),(399,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:03:39'),(400,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:03:39'),(401,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:03:56'),(402,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:03:56'),(403,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:42:07'),(404,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:42:07'),(405,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:55:44'),(406,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 20:55:44'),(407,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 22:57:00'),(408,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-17 22:57:00'),(409,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 00:33:01'),(410,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 00:33:01'),(411,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 01:33:46'),(412,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 01:33:46'),(413,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 02:35:44'),(414,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 02:35:44'),(415,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 03:39:07'),(416,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 03:39:07'),(417,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 04:39:16'),(418,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 04:39:16'),(419,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 05:42:25'),(420,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 05:42:25'),(421,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 06:45:50'),(422,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 06:45:50'),(423,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 07:49:18'),(424,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 07:49:18'),(425,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 09:14:59'),(426,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 09:14:59'),(427,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 09:19:03'),(428,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 09:19:03'),(429,'license_request','{\"ip\": \"102.132.218.135\", \"action\": \"validate\", \"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 09:46:28'),(430,'license_validated','{\"app_id\": \"cmdsharp\", \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 09:46:28'),(431,'payfast_webhook_received','{\"headers\": {\"Host\": \"ai.proviska.com\", \"Accept\": \"*/*\", \"Referer\": \"https://www.payfast.co.za\", \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0\", \"Content-Type\": \"application/x-www-form-urlencoded\", \"Content-Length\": \"539\"}, \"raw_data\": \"m_payment_id=cmdsharp_single_1752842571_9630&pf_payment_id=2707041&payment_status=COMPLETE&item_name=cmdsharp+Single+License&item_description=Voice-powered+invoicing+system+license&amount_gross=499.00&amount_fee=-11.48&amount_net=487.52&custom_str1=single&custom_str2=direct&custom_str3=ZAR&custom_str4=2025-07-18+12%3A42%3A51&custom_str5=&custom_int1=&custom_int2=&custom_int3=&custom_int4=&custom_int5=&name_first=Wouter&name_last=Olwagen&email_address=olwagenw%40gmail.com&merchant_id=10033492&signature=537a179a9911f03bbda783dfc507c993\", \"post_data\": {\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"537a179a9911f03bbda783dfc507c993\", \"amount_fee\": \"-11.48\", \"amount_net\": \"487.52\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-18 12:42:51\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"499.00\", \"m_payment_id\": \"cmdsharp_single_1752842571_9630\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2707041\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}}',NULL,NULL,NULL,NULL,'2025-07-18 12:43:00'),(432,'webhook_data_extracted','{\"amount\": 499, \"channel\": \"direct\", \"payment_id\": \"cmdsharp_single_1752842571_9630\", \"license_type\": \"single\", \"customer_name\": \"Wouter Olwagen\", \"customer_email\": \"olwagenw@gmail.com\"}',NULL,NULL,NULL,NULL,'2025-07-18 12:43:00'),(433,'attempting_email_send','{\"email\": \"olwagenw@gmail.com\", \"channel\": \"direct\", \"license_type\": \"single\", \"license_key_start\": \"CMDSHARP\"}',NULL,NULL,NULL,NULL,'2025-07-18 12:43:00'),(434,'license_email_sent','{\"email\": \"olwagenw@gmail.com\", \"result\": {\"method\": \"smtp\", \"success\": true}, \"channel\": \"direct\", \"license_key\": \"CMDSHARP-****\"}',NULL,NULL,NULL,NULL,'2025-07-18 12:43:04'),(435,'license_created','{\"amount\": 499, \"channel\": \"direct\", \"currency\": \"ZAR\", \"payment_id\": \"cmdsharp_single_1752842571_9630\", \"license_key\": \"CMDSHARP-****\", \"license_type\": \"single\"}',NULL,NULL,NULL,NULL,'2025-07-18 12:43:04');

--
-- Table structure for table `app_versions`
--

CREATE TABLE `app_versions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_id` varchar(100) NOT NULL DEFAULT 'cmdsharp',
  `version` varchar(50) NOT NULL,
  `build_number` int NOT NULL,
  `channel` enum('direct','app_sumo','google_play') NOT NULL DEFAULT 'direct',
  `apk_url` varchar(500) DEFAULT NULL,
  `apk_size` bigint DEFAULT NULL,
  `release_notes` text,
  `is_active` tinyint(1) DEFAULT '1',
  `min_api_level` int DEFAULT '21',
  `target_api_level` int DEFAULT '34',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_version_channel` (`app_id`,`version`,`channel`),
  KEY `idx_app_channel` (`app_id`,`channel`),
  KEY `idx_active` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `app_versions`
--

INSERT INTO `app_versions` VALUES (1,'cmdsharp','1.0.0',1,'direct','https://ai.proviska.com/api/app-update.php?channel=direct',NULL,'Direct sales version',1,21,34,'2025-07-12 09:53:57','2025-07-12 09:53:57'),(2,'cmdsharp','1.0.0',1,'app_sumo','https://ai.proviska.com/api/app-update.php?channel=app_sumo',NULL,'AppSumo partner version',1,21,34,'2025-07-12 09:53:57','2025-07-12 09:53:57'),(3,'cmdsharp','1.0.0',1,'google_play','https://play.google.com/store/apps/details?id=com.proviska.cmdsharp',NULL,'Google Play Store version',1,21,34,'2025-07-12 09:53:57','2025-07-12 09:53:57');

--
-- Table structure for table `appsumo_codes`
--

CREATE TABLE `appsumo_codes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `license_key` varchar(255) DEFAULT NULL,
  `redeemed_at` timestamp NULL DEFAULT NULL,
  `redeemed_by_email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `idx_code` (`code`),
  KEY `idx_license_key` (`license_key`),
  CONSTRAINT `appsumo_codes_ibfk_1` FOREIGN KEY (`license_key`) REFERENCES `licenses` (`license_key`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `appsumo_codes`
--


--
-- Table structure for table `branding_config`
--

CREATE TABLE `branding_config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `logo_url` varchar(500) DEFAULT NULL,
  `brand_name` varchar(255) DEFAULT 'CmdSharp',
  `brand_tagline` varchar(500) DEFAULT 'Voice-Powered Invoicing System',
  `primary_color` varchar(7) DEFAULT '#667eea',
  `secondary_color` varchar(7) DEFAULT '#ffd700',
  `success_redirect` varchar(500) DEFAULT 'https://cmdsharp.com/success.html',
  `cancel_redirect` varchar(500) DEFAULT 'https://cmdsharp.com/cancel.html',
  `download_page` varchar(500) DEFAULT 'https://cmdsharp.com/download',
  `support_email` varchar(255) DEFAULT 'support@proviska.com',
  `active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_active` (`active`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `branding_config`
--

INSERT INTO `branding_config` VALUES (1,'https://ai.proviska.com/assets/cmdsharp-logo.png','CmdSharp','Voice-Powered Invoicing System','#667eea','#ffd700','https://cmdsharp.com/success.html','https://cmdsharp.com/cancel.html','https://cmdsharp.com/download','support@proviska.com',0,'2025-07-12 08:59:53','2025-07-12 09:15:15'),(2,'https://ai.proviska.com/assets/uploads/logo_1752311711_6872279f3fc12.png','CmdSharp','Voice-Powered Invoicing System','#667eea','#ffd700','https://cmdsharp.com/success.html','https://cmdsharp.com/cancel.html','https://cmdsharp.com/download','support@proviska.com',1,'2025-07-12 09:15:15','2025-07-12 09:15:15'),(3,'https://ai.proviska.com/assets/cmdsharp-logo.png','CmdSharp','Voice-Powered Invoicing System','#667eea','#ffd700','https://cmdsharp.com/success.html','https://cmdsharp.com/cancel.html','https://cmdsharp.com/download','support@proviska.com',1,'2025-07-12 13:59:14','2025-07-12 13:59:14');

--
-- Table structure for table `cron_jobs`
--

CREATE TABLE `cron_jobs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `command` text NOT NULL,
  `schedule` varchar(100) NOT NULL,
  `description` text,
  `is_active` tinyint(1) DEFAULT '1',
  `last_run` timestamp NULL DEFAULT NULL,
  `last_status` enum('success','failed','running') DEFAULT NULL,
  `last_output` text,
  `next_run` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_active` (`is_active`),
  KEY `idx_next_run` (`next_run`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cron_jobs`
--

INSERT INTO `cron_jobs` VALUES (1,'Queue Cleanup','php /var/www/html/proviska/proviska-ai/api/queue-admin.php cleanup','0 */6 * * *','Clean old queue entries every 6 hours',1,NULL,NULL,NULL,NULL,'2025-07-12 08:59:53','2025-07-12 08:59:53'),(2,'Health Check','php /var/www/html/proviska/proviska-ai/api/queue-health.php','*/5 * * * *','Health check every 5 minutes',1,NULL,NULL,NULL,NULL,'2025-07-12 08:59:53','2025-07-12 08:59:53'),(3,'Cache Cleanup','find /var/www/html/proviska/proviska-ai/cache -name \"*.cache\" -mtime +1 -delete','0 2 * * *','Clean old cache files daily at 2am',1,NULL,NULL,NULL,NULL,'2025-07-12 08:59:53','2025-07-12 08:59:53'),(4,'Queue Cleanup','php /var/www/html/proviska/proviska-ai/api/queue-admin.php cleanup','0 */6 * * *','Clean old queue entries every 6 hours',1,NULL,NULL,NULL,NULL,'2025-07-12 13:59:14','2025-07-12 13:59:14'),(5,'Health Check','php /var/www/html/proviska/proviska-ai/api/queue-health.php','*/5 * * * *','Health check every 5 minutes',1,NULL,NULL,NULL,NULL,'2025-07-12 13:59:14','2025-07-12 13:59:14'),(6,'Cache Cleanup','find /var/www/html/proviska/proviska-ai/cache -name \"*.cache\" -mtime +1 -delete','0 2 * * *','Clean old cache files daily at 2am',1,NULL,NULL,NULL,NULL,'2025-07-12 13:59:14','2025-07-12 13:59:14');

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `template_name` varchar(100) NOT NULL,
  `channel` enum('app_sumo','direct','google_play','all') NOT NULL DEFAULT 'all',
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_name` (`template_name`),
  KEY `idx_template_name` (`template_name`),
  KEY `idx_channel` (`channel`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` VALUES (1,'license_purchased','direct','Your cmdsharp License Key','<!DOCTYPE html>\n<html>\n<head>\n    <style>\n        body { font-family: Arial, sans-serif; color: #333; }\n        .header { background: #304c67; color: white; padding: 20px; text-align: center; }\n        .content { padding: 20px; }\n        .license-key { background: #f8f9fa; padding: 15px; border-radius: 5px; font-family: monospace; font-size: 18px; text-align: center; margin: 20px 0; border: 2px solid #304c67; }\n        .footer { background: #f8f9fa; padding: 20px; text-align: center; font-size: 12px; color: #666; }\n    </style>\n</head>\n<body>\n    <div class=\"header\">\n        <h1>Welcome to cmdsharp!</h1>\n    </div>\n    <div class=\"content\">\n        <h2>Thank you for your purchase!</h2>\n        <p>Your cmdsharp license has been successfully created. Here are your details:</p>\n        \n        <div class=\"license-key\">\n            <strong>{{LICENSE_KEY}}</strong>\n        </div>\n        \n        <p><strong>License Type:</strong> {{LICENSE_TYPE}}</p>\n        <p><strong>Valid For:</strong> {{MAX_ACTIVATIONS}} device(s)</p>\n        \n        <h3>How to activate:</h3>\n        <ol>\n            <li>Download cmdsharp from <a href=\"https://cmdsharp.com/download\">cmdsharp.com</a></li>\n            <li>Open the app and enter your license key</li>\n            <li>Start commanding your invoicing!</li>\n        </ol>\n        \n        <p>Need help? Contact us at <a href=\"mailto:support@cmdsharp.com\">support@cmdsharp.com</a></p>\n    </div>\n    <div class=\"footer\">\n        <p>© 2024 cmdsharp. All rights reserved.</p>\n    </div>\n</body>\n</html>',1,'2025-07-11 15:10:23','2025-07-11 15:10:23'),(2,'license_activated','all','cmdsharp License Activated','<!DOCTYPE html>\n<html>\n<head>\n    <style>\n        body { font-family: Arial, sans-serif; color: #333; }\n        .header { background: #304c67; color: white; padding: 20px; text-align: center; }\n        .content { padding: 20px; }\n        .success { background: #d4edda; color: #155724; padding: 15px; border-radius: 5px; margin: 20px 0; }\n        .footer { background: #f8f9fa; padding: 20px; text-align: center; font-size: 12px; color: #666; }\n    </style>\n</head>\n<body>\n    <div class=\"header\">\n        <h1>License Activated!</h1>\n    </div>\n    <div class=\"content\">\n        <div class=\"success\">\n            <strong>✅ Success!</strong> Your cmdsharp license has been activated on this device.\n        </div>\n        \n        <p>Your license details:</p>\n        <ul>\n            <li><strong>License Key:</strong> {{LICENSE_KEY}}</li>\n            <li><strong>Device:</strong> {{DEVICE_NAME}}</li>\n            <li><strong>Activated:</strong> {{ACTIVATED_AT}}</li>\n        </ul>\n        \n        <p>You can now enjoy all cmdsharp features including:</p>\n        <ul>\n            <li>Voice-powered invoice creation</li>\n            <li>AI magic shortcuts</li>\n            <li>Programmable templates</li>\n            <li>Export and reporting</li>\n        </ul>\n        \n        <p>Happy invoicing!</p>\n    </div>\n    <div class=\"footer\">\n        <p>© 2024 cmdsharp. All rights reserved.</p>\n    </div>\n</body>\n</html>',1,'2025-07-11 15:10:23','2025-07-11 15:10:23');

--
-- Table structure for table `license_activations`
--

CREATE TABLE `license_activations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `license_key` varchar(255) NOT NULL,
  `device_id` varchar(255) NOT NULL,
  `device_name` varchar(255) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text,
  `app_version` varchar(50) DEFAULT NULL,
  `activated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `last_seen` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_license_device` (`license_key`,`device_id`),
  KEY `idx_license_key` (`license_key`),
  KEY `idx_device_id` (`device_id`),
  KEY `idx_activated_at` (`activated_at`),
  KEY `idx_activations_license_last_seen` (`license_key`,`last_seen`),
  CONSTRAINT `license_activations_ibfk_1` FOREIGN KEY (`license_key`) REFERENCES `licenses` (`license_key`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `license_activations`
--

INSERT INTO `license_activations` VALUES (1,'CMDSHARP-27CU-4NBQ-BZE7','device_7d6fce8f65a91041_1752404722','Unknown Device','102.132.218.135','Dart/3.8 (dart:io)','1.0.0','2025-07-13 11:05:22','2025-07-13 11:05:22'),(2,'CMDSHARP-RF5E-2UGT-HVFP','device_997400ddb25404f1_1752519476','Unknown Device','102.132.218.135','Dart/3.8 (dart:io)','1.0.0','2025-07-14 18:57:56','2025-07-14 18:57:56'),(3,'CMDSHARP-WRDX-D8DI-6V31','device_f8d6d7a783b9614d_1752582686','Unknown Device','102.132.218.135','Dart/3.8 (dart:io)','1.0.0','2025-07-15 12:31:26','2025-07-15 12:31:26'),(4,'CMDSHARP-U4EN-1V7R-UR8F','device_57cfbc223cc606d4_1752587389','Unknown Device','102.132.218.135','Dart/3.8 (dart:io)','1.0.0','2025-07-15 13:49:49','2025-07-15 13:49:49'),(5,'CMDSHARP-J08K-FP0R-AJ4E','device_b277769550bbde04_1752761658','Unknown Device','102.132.218.135','Dart/3.8 (dart:io)','1.0.0','2025-07-17 14:14:18','2025-07-17 14:14:18');

--
-- Table structure for table `licenses`
--

CREATE TABLE `licenses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `license_key` varchar(255) NOT NULL,
  `license_type` enum('single','team') NOT NULL,
  `channel` enum('app_sumo','direct','google_play') NOT NULL,
  `status` enum('active','inactive','expired','suspended') NOT NULL DEFAULT 'active',
  `max_activations` int NOT NULL DEFAULT '1',
  `current_activations` int NOT NULL DEFAULT '0',
  `customer_email` varchar(255) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `license_key` (`license_key`),
  KEY `idx_license_key` (`license_key`),
  KEY `idx_channel` (`channel`),
  KEY `idx_status` (`status`),
  KEY `idx_customer_email` (`customer_email`),
  KEY `payment_id` (`payment_id`),
  KEY `idx_licenses_channel_status` (`channel`,`status`),
  CONSTRAINT `licenses_ibfk_1` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`payment_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `licenses`
--

INSERT INTO `licenses` VALUES (1,'CMDSHARP-X8ET-MCVG-VZSO','single','direct','active',1,0,'olwagenw@gmail.com',NULL,NULL,NULL,'2025-07-13 09:13:16','2025-07-13 09:13:16'),(2,'CMDSHARP-27CU-4NBQ-BZE7','single','direct','active',1,1,'olwagenw@gmail.com',NULL,NULL,NULL,'2025-07-13 09:19:37','2025-07-14 18:49:10'),(3,'CMDSHARP-X5VM-GNA9-UAV8','single','direct','active',1,0,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752437305_1020',NULL,'2025-07-13 20:08:33','2025-07-13 20:08:33'),(4,'CMDSHARP-AUA4-VH2W-PI4B','single','direct','active',1,0,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752437984_7138',NULL,'2025-07-13 20:19:53','2025-07-13 20:19:53'),(5,'CMDSHARP-VBU7-H39C-V67H','single','direct','active',1,0,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752438656_8955',NULL,'2025-07-13 20:31:06','2025-07-13 20:31:06'),(6,'CMDSHARP-NPEZ-MG16-F220','single','direct','active',1,0,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752439224_8062',NULL,'2025-07-13 20:40:35','2025-07-13 20:40:35'),(7,'CMDSHARP-H7K0-88OS-W0UB','single','direct','active',1,0,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752440186_3284',NULL,'2025-07-13 20:56:35','2025-07-13 20:56:35'),(8,'CMDSHARP-WRDX-D8DI-6V31','single','direct','active',1,1,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752441111_8871',NULL,'2025-07-13 21:12:00','2025-07-17 13:27:49'),(9,'CMDSHARP-RF5E-2UGT-HVFP','single','direct','active',1,1,'gerda@micode.co.za','Gerda Vermeulen','cmdsharp_single_1752479321_7859',NULL,'2025-07-14 07:48:58','2025-07-15 07:57:53'),(10,'CMDSHARP-KI82-28JC-M44L','single','direct','active',1,0,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752484326_4644',NULL,'2025-07-14 09:12:19','2025-07-14 09:12:19'),(11,'CMDSHARP-WLDZ-U943-XL2L','single','direct','active',1,0,'support@proviska.com','Wouter Olwagen','cmdsharp_single_1752583114_1315',NULL,'2025-07-15 13:07:54','2025-07-15 13:07:54'),(12,'CMDSHARP-CZ82-7BFC-M89K','single','direct','active',1,0,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752585966_2141',NULL,'2025-07-15 13:28:28','2025-07-15 13:28:28'),(13,'CMDSHARP-U4EN-1V7R-UR8F','single','direct','active',1,1,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752586884_1241',NULL,'2025-07-15 13:41:35','2025-07-16 07:19:14'),(15,'CMDSHARP-2OA2-3JH3-3JY7','single','app_sumo','active',99,0,'olwagenw@gmail.com','AppSumo Test','appsumo_webhook_1752744614_5808',NULL,'2025-07-17 09:30:14','2025-07-17 09:30:14'),(16,'CMDSHARP-8DK8-1LX0-9P9M','single','app_sumo','active',99,0,'olwagenw@gmail.com','Wouter Olwagen','appsumo_webhook_1752747530_9335',NULL,'2025-07-17 10:18:50','2025-07-17 10:18:50'),(17,'CMDSHARP-J08K-FP0R-AJ4E','single','direct','active',3,1,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752756680_7226',NULL,'2025-07-17 12:51:30','2025-07-18 09:46:28'),(18,'CMDSHARP-HSN6-DH4V-H1X7','single','direct','active',3,0,'olwagenw@gmail.com','Wouter Olwagen','cmdsharp_single_1752842571_9630',NULL,'2025-07-18 12:43:00','2025-07-18 12:43:00');

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payment_id` varchar(255) NOT NULL,
  `license_type` enum('single','team') NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `provider` enum('payfast','lemonsqueezy','appsumo') NOT NULL,
  `status` enum('pending','completed','failed','cancelled') NOT NULL,
  `customer_email` varchar(255) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `provider_transaction_id` varchar(255) DEFAULT NULL,
  `webhook_data` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_id` (`payment_id`),
  KEY `idx_payment_id` (`payment_id`),
  KEY `idx_status` (`status`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_payments_provider_status` (`provider`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` VALUES (25,'cmdsharp_single_1752430075_6434','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-13 18:07:55','2025-07-13 18:07:55'),(26,'cmdsharp_single_1752431307_5099','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-13 18:28:27','2025-07-13 18:28:27'),(27,'cmdsharp_single_1752431929_4550','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-13 18:38:49','2025-07-13 18:38:49'),(28,'cmdsharp_single_1752432499_9449','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-13 18:48:19','2025-07-13 18:48:19'),(29,'cmdsharp_single_1752433730_1043','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-13 19:08:50','2025-07-13 19:08:50'),(30,'cmdsharp_single_1752434245_4807','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-13 19:17:25','2025-07-13 19:17:25'),(31,'cmdsharp_single_1752434747_2944','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-13 19:25:47','2025-07-13 19:25:47'),(32,'cmdsharp_single_1752436565_2572','single',399.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2609271','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"9e74ae2f7a50401c64a222575414ed23\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"\", \"custom_str2\": \"\", \"custom_str3\": \"\", \"custom_str4\": \"\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752436565_2572\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609271\", \"payment_status\": \"COMPLETE\", \"item_description\": \"\"}','2025-07-13 19:56:05','2025-07-13 19:56:19'),(33,'cmdsharp_single_1752437305_1020','single',399.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2609275','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"914b4cc5b4022c0b15047e3e7b5cfe5e\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:08:25\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752437305_1020\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609275\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-13 20:08:25','2025-07-13 20:08:33'),(34,'cmdsharp_single_1752437984_7138','single',399.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2609280','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"f442530227e69b1c41a8180f09b3f714\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:19:44\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752437984_7138\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609280\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-13 20:19:44','2025-07-13 20:19:53'),(35,'cmdsharp_single_1752438656_8955','single',399.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2609283','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"b264dbce8893abc743b81af8e4eac562\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:30:56\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752438656_8955\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609283\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-13 20:30:56','2025-07-13 20:31:06'),(36,'cmdsharp_single_1752439224_8062','single',399.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2609285','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"09b59e9791da9d72699aa057304fa5da\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:40:24\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752439224_8062\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609285\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-13 20:40:24','2025-07-13 20:40:35'),(37,'cmdsharp_single_1752440186_3284','single',399.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2609290','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"9c6dfa6cc7094b3b5347d3da6ab7ea3d\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 20:56:26\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752440186_3284\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609290\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-13 20:56:26','2025-07-13 20:56:35'),(38,'cmdsharp_single_1752441111_8871','single',399.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2609293','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"aad825eec86fef88dd69d5d9da285160\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-13 21:11:51\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752441111_8871\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609293\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-13 21:11:51','2025-07-13 21:12:00'),(39,'cmdsharp_single_1752479249_6414','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-14 07:47:29','2025-07-14 07:47:29'),(40,'cmdsharp_single_1752479321_7859','single',399.00,'ZAR','payfast','completed','gerda@micode.co.za','Gerda Vermeulen','2609531','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Vermeulen\", \"signature\": \"9bdacb71faf4b6f6b9452d7e8d7f61fe\", \"amount_fee\": \"-9.18\", \"amount_net\": \"389.82\", \"name_first\": \"Gerda\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-14 07:48:41\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"399.00\", \"m_payment_id\": \"cmdsharp_single_1752479321_7859\", \"email_address\": \"gerda@micode.co.za\", \"pf_payment_id\": \"2609531\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-14 07:48:41','2025-07-14 07:48:58'),(41,'cmdsharp_single_1752483366_6461','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-14 08:56:06','2025-07-14 08:56:06'),(42,'cmdsharp_single_1752483546_7305','single',399.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-14 08:59:06','2025-07-14 08:59:06'),(43,'cmdsharp_single_1752484326_4644','single',499.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2609709','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"8c0eeefbf8d934c7ef26e0015fdb6eda\", \"amount_fee\": \"-11.48\", \"amount_net\": \"487.52\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-14 09:12:06\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"499.00\", \"m_payment_id\": \"cmdsharp_single_1752484326_4644\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2609709\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-14 09:12:06','2025-07-14 09:12:19'),(44,'cmdsharp_single_1752575653_6485','single',499.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-15 10:34:13','2025-07-15 10:34:13'),(45,'cmdsharp_single_1752581778_2406','single',49.99,'USD','lemonsqueezy','pending',NULL,NULL,NULL,NULL,'2025-07-15 12:16:19','2025-07-15 12:16:19'),(46,'cmdsharp_single_1752581897_9506','single',49.99,'USD','lemonsqueezy','pending',NULL,NULL,NULL,NULL,'2025-07-15 12:18:18','2025-07-15 12:18:18'),(47,'cmdsharp_single_1752583114_1315','single',49.99,'USD','lemonsqueezy','completed','support@proviska.com','Wouter Olwagen','','{\"data\": {\"id\": \"5952850\", \"type\": \"orders\", \"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952850\"}, \"attributes\": {\"tax\": 0, \"urls\": {\"receipt\": \"https://app.lemonsqueezy.com/my-orders/0cbfd90a-1c9b-4040-beeb-e229d66a44f9?expires=1752606473&signature=988e076c8360fde68b75de8eb9e6c8307781be435d9e7a008502fc690e457adb\"}, \"total\": 4999, \"status\": \"paid\", \"tax_usd\": 0, \"currency\": \"USD\", \"refunded\": false, \"store_id\": 195742, \"subtotal\": 4999, \"tax_name\": \"VAT\", \"tax_rate\": 0, \"setup_fee\": 0, \"test_mode\": true, \"total_usd\": 4999, \"user_name\": \"Wouter Olwagen\", \"created_at\": \"2025-07-15T13:07:51.000000Z\", \"identifier\": \"0cbfd90a-1c9b-4040-beeb-e229d66a44f9\", \"updated_at\": \"2025-07-15T13:07:53.000000Z\", \"user_email\": \"support@proviska.com\", \"customer_id\": 6313454, \"refunded_at\": null, \"order_number\": 1957421, \"subtotal_usd\": 4999, \"currency_rate\": \"1.00000000\", \"setup_fee_usd\": 0, \"tax_formatted\": \"$0.00\", \"tax_inclusive\": false, \"discount_total\": 0, \"refunded_amount\": 0, \"total_formatted\": \"$49.99\", \"first_order_item\": {\"id\": 5891892, \"price\": 4999, \"order_id\": 5952850, \"price_id\": 1393571, \"quantity\": 1, \"test_mode\": true, \"created_at\": \"2025-07-15T13:07:53.000000Z\", \"product_id\": 578107, \"updated_at\": \"2025-07-15T13:07:53.000000Z\", \"variant_id\": 901330, \"product_name\": \"CmdSharp\", \"variant_name\": \"Single License\"}, \"status_formatted\": \"Paid\", \"discount_total_usd\": 0, \"subtotal_formatted\": \"$49.99\", \"refunded_amount_usd\": 0, \"setup_fee_formatted\": \"$0.00\", \"discount_total_formatted\": \"$0.00\", \"refunded_amount_formatted\": \"$0.00\"}, \"relationships\": {\"store\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952850/relationships/store\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952850/store\"}}, \"customer\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952850/relationships/customer\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952850/customer\"}}, \"order-items\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952850/relationships/order-items\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952850/order-items\"}}, \"license-keys\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952850/relationships/license-keys\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952850/license-keys\"}}, \"subscriptions\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952850/relationships/subscriptions\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952850/subscriptions\"}}, \"discount-redemptions\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952850/relationships/discount-redemptions\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952850/discount-redemptions\"}}}}, \"meta\": {\"test_mode\": true, \"event_name\": \"order_created\", \"webhook_id\": \"f35b657d-cf45-409b-ae39-1f8208ce989a\", \"custom_data\": {\"channel\": \"direct\", \"currency\": \"USD\", \"timestamp\": \"2025-07-15 12:38:34\", \"payment_id\": \"cmdsharp_single_1752583114_1315\", \"license_type\": \"single\"}}}','2025-07-15 12:38:35','2025-07-15 13:07:54'),(48,'cmdsharp_single_1752585907_4752','single',499.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-15 13:25:07','2025-07-15 13:25:07'),(49,'cmdsharp_single_1752585943_4297','single',49.99,'USD','lemonsqueezy','pending',NULL,NULL,NULL,NULL,'2025-07-15 13:25:43','2025-07-15 13:25:43'),(50,'cmdsharp_single_1752585966_2141','single',49.99,'USD','lemonsqueezy','completed','olwagenw@gmail.com','Wouter Olwagen','','{\"data\": {\"id\": \"5952992\", \"type\": \"orders\", \"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952992\"}, \"attributes\": {\"tax\": 0, \"urls\": {\"receipt\": \"https://app.lemonsqueezy.com/my-orders/7cc970d9-0dd6-4715-a559-47c7e9efe1d3?expires=1752607708&signature=eae5a813e2fda5de1f9fe94bc51573c640792d577907bc64cd26efec9124c3f9\"}, \"total\": 4999, \"status\": \"paid\", \"tax_usd\": 0, \"currency\": \"USD\", \"refunded\": false, \"store_id\": 195742, \"subtotal\": 4999, \"tax_name\": \"VAT\", \"tax_rate\": 0, \"setup_fee\": 0, \"test_mode\": true, \"total_usd\": 4999, \"user_name\": \"Wouter Olwagen\", \"created_at\": \"2025-07-15T13:28:27.000000Z\", \"identifier\": \"7cc970d9-0dd6-4715-a559-47c7e9efe1d3\", \"updated_at\": \"2025-07-15T13:28:28.000000Z\", \"user_email\": \"olwagenw@gmail.com\", \"customer_id\": 6313593, \"refunded_at\": null, \"order_number\": 1957422, \"subtotal_usd\": 4999, \"currency_rate\": \"1.00000000\", \"setup_fee_usd\": 0, \"tax_formatted\": \"$0.00\", \"tax_inclusive\": false, \"discount_total\": 0, \"refunded_amount\": 0, \"total_formatted\": \"$49.99\", \"first_order_item\": {\"id\": 5892034, \"price\": 4999, \"order_id\": 5952992, \"price_id\": 1393571, \"quantity\": 1, \"test_mode\": true, \"created_at\": \"2025-07-15T13:28:28.000000Z\", \"product_id\": 578107, \"updated_at\": \"2025-07-15T13:28:28.000000Z\", \"variant_id\": 901330, \"product_name\": \"CmdSharp\", \"variant_name\": \"Single License\"}, \"status_formatted\": \"Paid\", \"discount_total_usd\": 0, \"subtotal_formatted\": \"$49.99\", \"refunded_amount_usd\": 0, \"setup_fee_formatted\": \"$0.00\", \"discount_total_formatted\": \"$0.00\", \"refunded_amount_formatted\": \"$0.00\"}, \"relationships\": {\"store\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952992/relationships/store\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952992/store\"}}, \"customer\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952992/relationships/customer\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952992/customer\"}}, \"order-items\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952992/relationships/order-items\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952992/order-items\"}}, \"license-keys\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952992/relationships/license-keys\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952992/license-keys\"}}, \"subscriptions\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952992/relationships/subscriptions\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952992/subscriptions\"}}, \"discount-redemptions\": {\"links\": {\"self\": \"https://api.lemonsqueezy.com/v1/orders/5952992/relationships/discount-redemptions\", \"related\": \"https://api.lemonsqueezy.com/v1/orders/5952992/discount-redemptions\"}}}}, \"meta\": {\"test_mode\": true, \"event_name\": \"order_created\", \"webhook_id\": \"069833de-cdeb-4601-acf3-da2f772b6ded\", \"custom_data\": {\"channel\": \"direct\", \"currency\": \"USD\", \"timestamp\": \"2025-07-15 13:26:06\", \"payment_id\": \"cmdsharp_single_1752585966_2141\", \"license_type\": \"single\"}}}','2025-07-15 13:26:07','2025-07-15 13:28:28'),(51,'cmdsharp_single_1752586884_1241','single',499.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2612201','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"4d3419dc922538220700b4eb55af02ab\", \"amount_fee\": \"-11.48\", \"amount_net\": \"487.52\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-15 13:41:24\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"499.00\", \"m_payment_id\": \"cmdsharp_single_1752586884_1241\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2612201\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-15 13:41:24','2025-07-15 13:41:35'),(52,'cmdsharp_single_1752587797_8310','single',49.99,'USD','lemonsqueezy','pending',NULL,NULL,NULL,NULL,'2025-07-15 13:56:38','2025-07-15 13:56:38'),(53,'cmdsharp_single_1752587855_3833','single',49.99,'USD','lemonsqueezy','pending',NULL,NULL,NULL,NULL,'2025-07-15 13:57:36','2025-07-15 13:57:36'),(54,'cmdsharp_single_1752594290_5785','single',49.99,'USD','lemonsqueezy','pending',NULL,NULL,NULL,NULL,'2025-07-15 15:44:50','2025-07-15 15:44:50'),(55,'appsumo_webhook_1752744614_5808','single',0.00,'USD','appsumo','completed','olwagenw@gmail.com','AppSumo Test',NULL,'{\"test\": true, \"event\": \"activate\", \"user_name\": \"AppSumo Test\", \"user_email\": \"olwagenw@gmail.com\", \"license_key\": \"\", \"event_timestamp\": \"2025-07-17 09:30:14\"}','2025-07-17 09:30:14','2025-07-17 09:30:14'),(56,'appsumo_webhook_1752747530_9335','single',49.99,'USD','appsumo','completed','olwagenw@gmail.com','Wouter Olwagen',NULL,'{\"test\": true, \"event\": \"activate\", \"user_name\": \"Wouter Olwagen\", \"user_email\": \"olwagenw@gmail.com\", \"license_key\": \"\", \"event_timestamp\": \"2025-07-17 10:18:50\"}','2025-07-17 10:18:50','2025-07-17 10:18:50'),(57,'cmdsharp_single_1752756680_7226','single',499.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2705533','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"dd65f35c2e9262231aa975125f89ad29\", \"amount_fee\": \"-11.48\", \"amount_net\": \"487.52\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-17 12:51:20\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"499.00\", \"m_payment_id\": \"cmdsharp_single_1752756680_7226\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2705533\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-17 12:51:20','2025-07-17 12:51:30'),(58,'cmdsharp_single_1752836213_4158','single',49.00,'USD','lemonsqueezy','pending',NULL,NULL,NULL,NULL,'2025-07-18 10:56:54','2025-07-18 10:56:54'),(59,'cmdsharp_single_1752836250_6117','single',499.00,'ZAR','payfast','pending',NULL,NULL,NULL,NULL,'2025-07-18 10:57:30','2025-07-18 10:57:30'),(60,'cmdsharp_single_1752842571_9630','single',499.00,'ZAR','payfast','completed','olwagenw@gmail.com','Wouter Olwagen','2707041','{\"item_name\": \"cmdsharp Single License\", \"name_last\": \"Olwagen\", \"signature\": \"537a179a9911f03bbda783dfc507c993\", \"amount_fee\": \"-11.48\", \"amount_net\": \"487.52\", \"name_first\": \"Wouter\", \"custom_int1\": \"\", \"custom_int2\": \"\", \"custom_int3\": \"\", \"custom_int4\": \"\", \"custom_int5\": \"\", \"custom_str1\": \"single\", \"custom_str2\": \"direct\", \"custom_str3\": \"ZAR\", \"custom_str4\": \"2025-07-18 12:42:51\", \"custom_str5\": \"\", \"merchant_id\": \"10033492\", \"amount_gross\": \"499.00\", \"m_payment_id\": \"cmdsharp_single_1752842571_9630\", \"email_address\": \"olwagenw@gmail.com\", \"pf_payment_id\": \"2707041\", \"payment_status\": \"COMPLETE\", \"item_description\": \"Voice-powered invoicing system license\"}','2025-07-18 12:42:51','2025-07-18 12:43:00');

--
-- Table structure for table `queue_requests`
--

CREATE TABLE `queue_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `request_type` varchar(100) NOT NULL,
  `request_data` json DEFAULT NULL,
  `status` enum('pending','processing','completed','failed') DEFAULT 'pending',
  `priority` int DEFAULT '5',
  `attempts` int DEFAULT '0',
  `max_attempts` int DEFAULT '3',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `processed_at` timestamp NULL DEFAULT NULL,
  `error_message` text,
  PRIMARY KEY (`id`),
  KEY `idx_status` (`status`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `queue_requests`
--


--
-- Table structure for table `system_status`
--

CREATE TABLE `system_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `component` varchar(100) NOT NULL,
  `status` enum('healthy','warning','critical') NOT NULL,
  `message` text,
  `metrics` json DEFAULT NULL,
  `checked_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_component` (`component`),
  KEY `idx_checked_at` (`checked_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `system_status`
--



