--
-- Host: localhost    Database: laravel
-- ------------------------------------------------------


--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('billing','business','contract','mailing','pickup','residential','shipping','') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `province_id` int unsigned DEFAULT NULL,
  `postalcode` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(384) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `addresses_country_id_foreign` (`country_id`),
  CONSTRAINT `addresses_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addresses`
--

INSERT INTO `addresses` VALUES (3,'billing','Agency Pulse','CA',NULL,'90210','SOmecity','133 Somestreet','2026-02-12 20:15:08','2026-02-12 20:15:08',NULL),(4,'billing','Agency Pulse','CA',NULL,'90210','SOmecity','133 Somestreet','2026-02-12 20:17:27','2026-02-12 20:17:27',NULL),(5,'billing','Agency Pulse','CA',NULL,'90210','SOmecity','133 Somestreet','2026-02-12 20:17:31','2026-02-12 20:17:31',NULL),(6,'billing','Agency Pulse','CA',NULL,'90210','SOmecity','133 Somestreet','2026-02-12 20:18:38','2026-02-12 20:18:38',NULL),(7,'billing','Agency Pulse','CA',NULL,'90210','SOmecity','133 Somestreet','2026-02-23 03:37:02','2026-02-23 03:37:02',NULL),(8,'billing','Agency Pulse','CA',72,'90210','SOmecity','133 Somestreet','2026-02-23 20:59:16','2026-02-23 21:42:12',NULL),(9,'billing','Agency Pulse','CA',66,'90210','SOmecity','133 Somestreet','2026-02-23 21:13:20','2026-02-23 21:13:20',NULL),(10,'billing','Agency Pulse','CA',66,'90210','SOmecity','133 Somestreet','2026-02-23 21:20:47','2026-02-23 21:20:47',NULL);

--
-- Table structure for table `adjustments`
--

CREATE TABLE `adjustments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `adjustable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `adjustable_id` bigint unsigned NOT NULL,
  `adjuster` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `origin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` json DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `is_locked` tinyint(1) NOT NULL DEFAULT '0',
  `is_included` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `adjustments`
--


--
-- Table structure for table `billpayers`
--

CREATE TABLE `billpayers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(22) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'First name',
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Last name',
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_nr` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tax/VAT Identification Number',
  `registration_nr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Company/Trade Registration Number',
  `is_eu_registered` tinyint(1) NOT NULL DEFAULT '0',
  `is_organization` tinyint(1) NOT NULL DEFAULT '0',
  `address_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `billpayers_address_id_foreign` (`address_id`),
  CONSTRAINT `billpayers_address_id_foreign` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billpayers`
--

INSERT INTO `billpayers` VALUES (2,'gwa.gjp@gmail.com',NULL,'gwa.gjp@gmail.com','',NULL,NULL,NULL,0,0,2,'2026-02-12 18:58:28','2026-02-12 18:58:28'),(3,'agencypulsewp+1@gmail.com',NULL,'Agency','Pulse',NULL,NULL,NULL,0,0,6,'2026-02-12 20:18:38','2026-02-12 20:18:38'),(4,'gwa.gjp+1@gmail.com',NULL,'Agency','Pulse',NULL,NULL,NULL,0,0,7,'2026-02-23 03:37:02','2026-02-23 03:37:02'),(5,'agencypulsewp+1@gmail.com',NULL,'Agency','Pulse',NULL,NULL,NULL,0,0,8,'2026-02-23 20:59:16','2026-02-23 20:59:16'),(6,'agencypulsewp+1@gmail.com',NULL,'Agency','Pulse',NULL,NULL,NULL,0,0,9,'2026-02-23 21:13:20','2026-02-23 21:13:20'),(7,'agencypulsewp+1@gmail.com',NULL,'Agency','Pulse',NULL,NULL,NULL,0,0,10,'2026-02-23 21:20:47','2026-02-23 21:20:47');

--
-- Table structure for table `carriers`
--

CREATE TABLE `carriers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `configuration` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `carriers`
--


--
-- Table structure for table `cart_items`
--

CREATE TABLE `cart_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `cart_id` int unsigned NOT NULL,
  `product_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` int unsigned NOT NULL,
  `quantity` int unsigned NOT NULL,
  `price` decimal(15,4) NOT NULL,
  `configuration` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_items`
--

INSERT INTO `cart_items` VALUES (8,3,'product',5,1,5.0000,'[]','2026-02-14 19:48:31','2026-02-14 19:48:47'),(9,3,'product',1,1,7.0000,'[]','2026-02-14 20:15:04','2026-02-14 20:15:04'),(10,4,'product',5,1,5.0000,'[]','2026-02-14 20:48:05','2026-02-14 20:48:05'),(11,5,'product',1,1,7.0000,'[]','2026-02-16 13:18:55','2026-02-16 13:18:55'),(18,6,'product',5,1,5.0000,'[]','2026-02-23 04:40:35','2026-02-23 04:40:35');

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `carts`
--

INSERT INTO `carts` VALUES (1,3,'2026-02-12 12:39:25','2026-02-12 12:40:02','active'),(2,NULL,'2026-02-12 20:14:19','2026-02-12 21:04:41','active'),(3,4,'2026-02-14 19:48:31','2026-02-14 19:48:31','active'),(4,2,'2026-02-14 20:48:05','2026-02-14 20:48:05','active'),(5,2,'2026-02-16 13:18:55','2026-02-16 13:18:55','active'),(6,NULL,'2026-02-22 20:44:11','2026-02-23 06:02:21','active'),(7,4,'2026-02-23 20:39:37','2026-02-23 20:39:37','active');

--
-- Table structure for table `channels`
--

CREATE TABLE `channels` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `configuration` json DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `channels_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channels`
--


--
-- Table structure for table `chat_messages`
--

CREATE TABLE `chat_messages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `chat_id` bigint unsigned NOT NULL,
  `sender_type` enum('customer','agent') COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender_id` bigint unsigned DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chat_messages_sender_id_foreign` (`sender_id`),
  KEY `chat_messages_chat_id_index` (`chat_id`),
  KEY `chat_messages_sender_type_index` (`sender_type`),
  KEY `chat_messages_created_at_index` (`created_at`),
  CONSTRAINT `chat_messages_chat_id_foreign` FOREIGN KEY (`chat_id`) REFERENCES `chats` (`id`) ON DELETE CASCADE,
  CONSTRAINT `chat_messages_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chat_messages`
--


--
-- Table structure for table `checkout_tax_rates`
--

CREATE TABLE `checkout_tax_rates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CA',
  `province` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(8,4) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `checkout_tax_rates_country_index` (`country`),
  KEY `checkout_tax_rates_province_index` (`province`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `checkout_tax_rates`
--

INSERT INTO `checkout_tax_rates` VALUES (1,'CA','Ontario','HST',0.1300,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(2,'CA','Nova Scotia','HST',0.1500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(3,'CA','New Brunswick','HST',0.1500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(5,'CA','Prince Edward Island','HST',0.1500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(6,'CA','Alberta','GST',0.0500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(7,'CA','British Columbia','GST',0.0500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(8,'CA','Saskatchewan','GST',0.0500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(9,'CA','Manitoba','GST',0.0500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(10,'CA','Quebec','GST',0.0500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(11,'US',NULL,'Tax',0.0000,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(12,'*',NULL,'Tax',0.0000,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(13,'CA','Newfoundland','HST',0.1500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(14,'CA','Northwest Territories','GST',0.0500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(15,'CA','Nunavut','GST',0.0500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24'),(16,'CA','Yukon','GST',0.0500,1,'2026-02-23 20:48:24','2026-02-23 20:48:24');

--
-- Table structure for table `conversations`
--

CREATE TABLE `conversations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `escalated` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `conversations_user_id_foreign` (`user_id`),
  CONSTRAINT `conversations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `conversations`
--

INSERT INTO `conversations` VALUES (1,NULL,'john@example.com',NULL,0,'2026-02-24 02:02:04','2026-02-24 02:02:04'),(2,NULL,'john@example.com',NULL,1,'2026-02-24 02:02:39','2026-02-24 02:02:40'),(3,4,'agencypulsewp+1@gmail.com',NULL,1,'2026-02-24 02:17:23','2026-02-24 02:17:25'),(4,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-02-24 19:06:57','2026-02-24 19:06:57'),(5,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-02-25 01:14:41','2026-02-25 01:14:41'),(6,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-02-25 02:14:40','2026-02-25 02:14:40'),(7,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-02-25 02:15:40','2026-02-25 02:15:40'),(8,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-02-25 02:16:34','2026-02-25 02:16:34'),(9,4,'agencypulsewp+1@gmail.com',NULL,1,'2026-02-25 02:41:27','2026-02-25 02:43:55'),(10,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-02-25 02:45:23','2026-02-25 02:45:23'),(11,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-02-25 02:51:53','2026-02-25 02:51:53'),(12,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-04 03:10:22','2026-03-04 03:10:22'),(13,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 01:21:46','2026-03-07 01:21:46'),(14,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 01:27:07','2026-03-07 01:27:07'),(15,5,'gwa.gjp+1@gmail.com',NULL,1,'2026-03-07 01:30:13','2026-03-07 01:32:11'),(16,5,'gwa.gjp+1@gmail.com',NULL,1,'2026-03-07 01:33:32','2026-03-07 01:33:32'),(17,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 01:34:59','2026-03-07 01:34:59'),(18,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 01:41:15','2026-03-07 01:41:15'),(19,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 01:43:00','2026-03-07 01:43:00'),(20,5,'gwa.gjp+1@gmail.com',NULL,1,'2026-03-07 01:47:08','2026-03-07 01:47:08'),(21,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 01:51:39','2026-03-07 01:51:39'),(22,5,'gwa.gjp+1@gmail.com',NULL,1,'2026-03-07 01:54:42','2026-03-07 01:54:43'),(23,5,'gwa.gjp+1@gmail.com',NULL,1,'2026-03-07 01:56:48','2026-03-07 01:56:48'),(24,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 02:00:54','2026-03-07 02:00:54'),(25,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 02:55:36','2026-03-07 02:55:36'),(26,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 02:57:33','2026-03-07 02:57:33'),(27,5,'gwa.gjp+1@gmail.com',NULL,0,'2026-03-07 02:59:37','2026-03-07 02:59:37'),(28,2,'agencypulsewp@gmail.com',NULL,1,'2026-03-07 12:10:23','2026-03-07 12:11:46'),(29,2,'agencypulsewp@gmail.com',NULL,1,'2026-03-07 14:35:29','2026-03-07 14:39:14'),(30,NULL,NULL,NULL,0,'2026-03-07 15:14:13','2026-03-07 17:38:25'),(31,NULL,'gwa.gjp+3@gmail.com','Agency Pulse WP',0,'2026-03-07 17:38:45','2026-03-07 18:08:26'),(32,NULL,NULL,NULL,0,'2026-03-07 18:09:00','2026-03-07 19:08:49'),(33,NULL,'gwa.gjp+6@gmail.com','Agency Pulse WP',0,'2026-03-07 19:09:34','2026-03-07 20:15:41'),(34,2,'agencypulsewp@gmail.com','AgencyPulseWP',0,'2026-03-07 20:15:55','2026-03-07 20:15:55'),(35,NULL,'gwa.gjp@gmail.com','Agency Pulse WP',0,'2026-03-07 20:20:42','2026-03-07 20:56:23'),(36,NULL,'gwa.gjp@gmail.com','Email & Privacy Policy',0,'2026-03-07 20:56:36','2026-03-07 21:03:56'),(37,NULL,NULL,NULL,0,'2026-03-07 21:08:05','2026-03-07 21:15:45'),(38,5,'gwa.gjp+1@gmail.com',NULL,1,'2026-03-07 21:54:15','2026-03-07 21:55:29'),(39,2,'agencypulsewp@gmail.com','AgencyPulseWP',0,'2026-03-07 21:57:09','2026-03-07 21:57:09'),(40,NULL,'gwa.gjp@gmail.com',NULL,0,'2026-03-07 23:22:50','2026-03-07 23:22:50'),(41,NULL,NULL,NULL,0,'2026-03-08 00:24:33','2026-03-08 00:24:33');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phonecode` int NOT NULL,
  `is_eu_member` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES ('AD','Andorra',376,0),('AE','United Arab Emirates',971,0),('AF','Afghanistan',93,0),('AG','Antigua and Barbuda',1268,0),('AI','Anguilla',1264,0),('AL','Albania',355,0),('AM','Armenia',374,0),('AN','Netherlands Antilles',599,0),('AO','Angola',244,0),('AP','Asia / Pacific Region',0,0),('AQ','Antarctica',0,0),('AR','Argentina',54,0),('AS','American Samoa',1684,0),('AT','Austria',43,1),('AU','Australia',61,0),('AW','Aruba',297,0),('AX','Aland Islands',358,0),('AZ','Azerbaijan',994,0),('BA','Bosnia and Herzegovina',387,0),('BB','Barbados',1246,0),('BD','Bangladesh',880,0),('BE','Belgium',32,1),('BF','Burkina Faso',226,0),('BG','Bulgaria',359,1),('BH','Bahrain',973,0),('BI','Burundi',257,0),('BJ','Benin',229,0),('BL','Saint Barthelemy',590,0),('BM','Bermuda',1441,0),('BN','Brunei Darussalam',673,0),('BO','Bolivia',591,0),('BQ','Bonaire, Sint Eustatius and Saba',599,0),('BR','Brazil',55,0),('BS','Bahamas',1242,0),('BT','Bhutan',975,0),('BV','Bouvet Island',0,0),('BW','Botswana',267,0),('BY','Belarus',375,0),('BZ','Belize',501,0),('CA','Canada',1,0),('CC','Cocos (Keeling) Islands',672,0),('CD','Congo, the Democratic Republic of the',243,0),('CF','Central African Republic',236,0),('CG','Congo',242,0),('CH','Switzerland',41,0),('CI','Cote D\'Ivoire',225,0),('CK','Cook Islands',682,0),('CL','Chile',56,0),('CM','Cameroon',237,0),('CN','China',86,0),('CO','Colombia',57,0),('CR','Costa Rica',506,0),('CU','Cuba',53,0),('CV','Cape Verde',238,0),('CW','Curacao',599,0),('CX','Christmas Island',61,0),('CY','Cyprus',357,1),('CZ','Czech Republic',420,1),('DE','Germany',49,1),('DJ','Djibouti',253,0),('DK','Denmark',45,1),('DM','Dominica',1767,0),('DO','Dominican Republic',1809,0),('DZ','Algeria',213,0),('EC','Ecuador',593,0),('EE','Estonia',372,1),('EG','Egypt',20,0),('EH','Western Sahara',212,0),('ER','Eritrea',291,0),('ES','Spain',34,1),('ET','Ethiopia',251,0),('FI','Finland',358,1),('FJ','Fiji',679,0),('FK','Falkland Islands (Malvinas)',500,0),('FM','Micronesia, Federated States of',691,0),('FO','Faroe Islands',298,0),('FR','France',33,1),('GA','Gabon',241,0),('GB','United Kingdom',44,0),('GD','Grenada',1473,0),('GE','Georgia',995,0),('GF','French Guiana',594,0),('GG','Guernsey',44,0),('GH','Ghana',233,0),('GI','Gibraltar',350,0),('GL','Greenland',299,0),('GM','Gambia',220,0),('GN','Guinea',224,0),('GP','Guadeloupe',590,0),('GQ','Equatorial Guinea',240,0),('GR','Greece',30,1),('GS','South Georgia and the South Sandwich Islands',0,0),('GT','Guatemala',502,0),('GU','Guam',1671,0),('GW','Guinea-Bissau',245,0),('GY','Guyana',592,0),('HK','Hong Kong',852,0),('HM','Heard Island and Mcdonald Islands',0,0),('HN','Honduras',504,0),('HR','Croatia',385,1),('HT','Haiti',509,0),('HU','Hungary',36,1),('ID','Indonesia',62,0),('IE','Ireland',353,1),('IL','Israel',972,0),('IM','Isle of Man',44,0),('IN','India',91,0),('IO','British Indian Ocean Territory',246,0),('IQ','Iraq',964,0),('IR','Iran, Islamic Republic of',98,0),('IS','Iceland',354,0),('IT','Italy',39,1),('JE','Jersey',44,0),('JM','Jamaica',1876,0),('JO','Jordan',962,0),('JP','Japan',81,0),('KE','Kenya',254,0),('KG','Kyrgyzstan',996,0),('KH','Cambodia',855,0),('KI','Kiribati',686,0),('KM','Comoros',269,0),('KN','Saint Kitts and Nevis',1869,0),('KP','Korea, Democratic People\'s Republic of',850,0),('KR','Korea, Republic of',82,0),('KW','Kuwait',965,0),('KY','Cayman Islands',1345,0),('KZ','Kazakhstan',7,0),('LA','Lao People\'s Democratic Republic',856,0),('LB','Lebanon',961,0),('LC','Saint Lucia',1758,0),('LI','Liechtenstein',423,0),('LK','Sri Lanka',94,0),('LR','Liberia',231,0),('LS','Lesotho',266,0),('LT','Lithuania',370,1),('LU','Luxembourg',352,1),('LV','Latvia',371,1),('LY','Libyan Arab Jamahiriya',218,0),('MA','Morocco',212,0),('MC','Monaco',377,0),('MD','Moldova, Republic of',373,0),('ME','Montenegro',382,0),('MF','Saint Martin',590,0),('MG','Madagascar',261,0),('MH','Marshall Islands',692,0),('MK','North Macedonia',389,0),('ML','Mali',223,0),('MM','Myanmar',95,0),('MN','Mongolia',976,0),('MO','Macao',853,0),('MP','Northern Mariana Islands',1670,0),('MQ','Martinique',596,0),('MR','Mauritania',222,0),('MS','Montserrat',1664,0),('MT','Malta',356,1),('MU','Mauritius',230,0),('MV','Maldives',960,0),('MW','Malawi',265,0),('MX','Mexico',52,0),('MY','Malaysia',60,0),('MZ','Mozambique',258,0),('NA','Namibia',264,0),('NC','New Caledonia',687,0),('NE','Niger',227,0),('NF','Norfolk Island',672,0),('NG','Nigeria',234,0),('NI','Nicaragua',505,0),('NL','Netherlands',31,1),('NO','Norway',47,0),('NP','Nepal',977,0),('NR','Nauru',674,0),('NU','Niue',683,0),('NZ','New Zealand',64,0),('OM','Oman',968,0),('PA','Panama',507,0),('PE','Peru',51,0),('PF','French Polynesia',689,0),('PG','Papua New Guinea',675,0),('PH','Philippines',63,0),('PK','Pakistan',92,0),('PL','Poland',48,1),('PM','Saint Pierre and Miquelon',508,0),('PN','Pitcairn',0,0),('PR','Puerto Rico',1787,0),('PS','Palestinian Territory, Occupied',970,0),('PT','Portugal',351,1),('PW','Palau',680,0),('PY','Paraguay',595,0),('QA','Qatar',974,0),('RE','Reunion',262,0),('RO','Romania',40,1),('RS','Serbia',381,0),('RU','Russian Federation',7,0),('RW','Rwanda',250,0),('SA','Saudi Arabia',966,0),('SB','Solomon Islands',677,0),('SC','Seychelles',248,0),('SD','Sudan',249,0),('SE','Sweden',46,1),('SG','Singapore',65,0),('SH','Saint Helena',290,0),('SI','Slovenia',386,1),('SJ','Svalbard and Jan Mayen',47,0),('SK','Slovakia',421,1),('SL','Sierra Leone',232,0),('SM','San Marino',378,0),('SN','Senegal',221,0),('SO','Somalia',252,0),('SR','Suriname',597,0),('SS','South Sudan',211,0),('ST','Sao Tome and Principe',239,0),('SV','El Salvador',503,0),('SX','Sint Maarten',1,0),('SY','Syrian Arab Republic',963,0),('SZ','Swaziland',268,0),('TC','Turks and Caicos Islands',1649,0),('TD','Chad',235,0),('TF','French Southern Territories',0,0),('TG','Togo',228,0),('TH','Thailand',66,0),('TJ','Tajikistan',992,0),('TK','Tokelau',690,0),('TL','Timor-Leste',670,0),('TM','Turkmenistan',7370,0),('TN','Tunisia',216,0),('TO','Tonga',676,0),('TR','Turkey',90,0),('TT','Trinidad and Tobago',1868,0),('TV','Tuvalu',688,0),('TW','Taiwan, Province of China',886,0),('TZ','Tanzania, United Republic of',255,0),('UA','Ukraine',380,0),('UG','Uganda',256,0),('UM','United States Minor Outlying Islands',1,0),('US','United States',1,0),('UY','Uruguay',598,0),('UZ','Uzbekistan',998,0),('VA','Holy See (Vatican City State)',39,0),('VC','Saint Vincent and the Grenadines',1784,0),('VE','Venezuela',58,0),('VG','Virgin Islands, British',1284,0),('VI','Virgin Islands, U.s.',1340,0),('VN','Viet Nam',84,0),('VU','Vanuatu',678,0),('WF','Wallis and Futuna',681,0),('WS','Samoa',684,0),('XK','Kosovo',381,0),('YE','Yemen',967,0),('YT','Mayotte',269,0),('ZA','South Africa',27,0),('ZM','Zambia',260,0),('ZW','Zimbabwe',263,0);

--
-- Table structure for table `customer_addresses`
--

CREATE TABLE `customer_addresses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int unsigned NOT NULL,
  `address_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_addresses`
--

INSERT INTO `customer_addresses` VALUES (2,5,7,'2026-02-23 03:37:02','2026-02-23 03:37:02',NULL),(3,4,8,'2026-02-23 20:59:16','2026-02-23 20:59:16',NULL);

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'organization',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(22) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'First name',
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Last name',
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_nr` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tax/VAT Identification Number',
  `registration_nr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Company/Trade Registration Number',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timezone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `ltv` decimal(15,4) NOT NULL DEFAULT '0.0000' COMMENT 'Customer Lifetime Value',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_purchase_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customers`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `gifted_products`
--

CREATE TABLE `gifted_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `product_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gifted_products_user_id_index` (`user_id`),
  KEY `gifted_products_product_type_product_id_index` (`product_type`,`product_id`),
  KEY `gifted_products_created_by_foreign` (`created_by`),
  CONSTRAINT `gifted_products_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `gifted_products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gifted_products`
--

INSERT INTO `gifted_products` VALUES (2,2,'App\\Models\\Product',5,'AgencyPulseWP Multi-Currency','apwp-mc','2026-02-14 00:00:00','2026-03-14 00:00:00',2,'2026-02-14 16:57:15','2026-02-14 16:57:15'),(4,4,'App\\Models\\Product',5,'AgencyPulseWP Multi-Currency','apwp-mc','2026-02-16 00:00:00','2026-03-22 00:00:00',2,'2026-02-16 23:11:54','2026-02-23 21:08:29'),(7,2,'App\\Models\\Product',1,'AgencyPulseWP Invoice Enhancements Plugin','apwp-ie','2026-02-24 00:00:00','2026-03-24 00:00:00',2,'2026-02-24 01:15:16','2026-02-24 01:15:16'),(8,5,'App\\Models\\Product',2,'AgencyPulseWP Client Portal Plugin','apwp-cp','2026-03-03 00:00:00','2026-04-03 00:00:00',2,'2026-03-03 11:56:58','2026-03-03 11:56:58');

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` VALUES (2,'default','{\"uuid\":\"a302ae99-3ef6-4e01-8515-0fe234d172b3\",\"displayName\":\"App\\\\Mail\\\\PurchaseAccountCreated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":15:{s:8:\\\"mailable\\\";O:31:\\\"App\\\\Mail\\\\PurchaseAccountCreated\\\":5:{s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:4;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"resetToken\\\";s:64:\\\"2a4fd6b42e916cc63a50b6683a321f81595681c5aa2f870327bd4c7c1098905c\\\";s:5:\\\"order\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:25:\\\"Vanilo\\\\Order\\\\Models\\\\Order\\\";s:2:\\\"id\\\";i:5;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:25:\\\"agencypulsewp+1@gmail.com\\\";}}s:6:\\\"mailer\\\";s:4:\\\"smtp\\\";}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"maxExceptions\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:3:\\\"job\\\";N;}\"}}',0,NULL,1771880364,1771880364),(3,'default','{\"uuid\":\"83eda737-e56f-4dfd-8a91-d30e57be5ed2\",\"displayName\":\"App\\\\Mail\\\\PurchaseAccountCreated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":15:{s:8:\\\"mailable\\\";O:31:\\\"App\\\\Mail\\\\PurchaseAccountCreated\\\":5:{s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:4;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"resetToken\\\";s:64:\\\"47104045d0af312e2a9a6a2628808a191796817f044f608519461903fd351322\\\";s:5:\\\"order\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:25:\\\"Vanilo\\\\Order\\\\Models\\\\Order\\\";s:2:\\\"id\\\";i:6;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:25:\\\"agencypulsewp+1@gmail.com\\\";}}s:6:\\\"mailer\\\";s:4:\\\"smtp\\\";}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"maxExceptions\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:3:\\\"job\\\";N;}\"}}',0,NULL,1771881208,1771881208),(4,'default','{\"uuid\":\"970d4977-1a78-48bf-8302-41e9d5ae4c49\",\"displayName\":\"App\\\\Mail\\\\PurchaseAccountCreated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":15:{s:8:\\\"mailable\\\";O:31:\\\"App\\\\Mail\\\\PurchaseAccountCreated\\\":5:{s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:4;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"resetToken\\\";s:64:\\\"cc1b9498c54f84152167bc9326607399ef8adbf61bbfefa3d1ceb1372bff7065\\\";s:5:\\\"order\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:25:\\\"Vanilo\\\\Order\\\\Models\\\\Order\\\";s:2:\\\"id\\\";i:7;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:25:\\\"agencypulsewp+1@gmail.com\\\";}}s:6:\\\"mailer\\\";s:4:\\\"smtp\\\";}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"maxExceptions\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:3:\\\"job\\\";N;}\"}}',0,NULL,1771881655,1771881655);

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `native_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--


--
-- Table structure for table `laravelticket`
--

CREATE TABLE `laravelticket` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `html` longtext COLLATE utf8mb4_unicode_ci,
  `status_id` int unsigned NOT NULL,
  `priority_id` int unsigned NOT NULL,
  `user_id` int unsigned NOT NULL,
  `agent_id` int unsigned NOT NULL,
  `category_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `laravelticket_subject_index` (`subject`),
  KEY `laravelticket_status_id_index` (`status_id`),
  KEY `laravelticket_priority_id_index` (`priority_id`),
  KEY `laravelticket_user_id_index` (`user_id`),
  KEY `laravelticket_agent_id_index` (`agent_id`),
  KEY `laravelticket_category_id_index` (`category_id`),
  KEY `laravelticket_completed_at_index` (`completed_at`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laravelticket`
--

INSERT INTO `laravelticket` VALUES (1,'Test Issue','This is a test message from the bubble.','This is a test message from the bubble.',1,2,2,2,1,'2026-02-24 00:33:03','2026-02-24 00:37:16','2026-02-24 00:37:15'),(2,'Test Issue','FROM GUEST: Test User <test@example.com>\n\nThis is a test message from the bubble.','FROM GUEST: Test User &lt;test@example.com&gt;<br />\n<br />\nThis is a test message from the bubble.',1,2,2,2,1,'2026-02-24 00:34:24','2026-02-24 02:25:14','2026-02-24 02:25:14'),(3,'Test Issue','FROM GUEST: Test User <test@example.com>\n\nThis is a test message from the bubble.','FROM GUEST: Test User &lt;test@example.com&gt;<br />\n<br />\nThis is a test message from the bubble.',1,2,2,2,1,'2026-02-24 00:34:38','2026-02-24 02:25:10','2026-02-24 02:25:10'),(4,'Test Issue','FROM GUEST: Test User <test@example.com>\n\nThis is a test message from the bubble.','FROM GUEST: Test User &lt;test@example.com&gt;<br />\n<br />\nThis is a test message from the bubble.',1,2,2,2,1,'2026-02-24 00:34:56','2026-02-24 02:25:06','2026-02-24 02:25:06'),(5,'help','me','me',1,2,4,2,1,'2026-02-24 00:35:36','2026-02-24 02:24:57','2026-02-24 02:24:57'),(6,'AI Escalation: I cannot find my password reset button','ESCALATED CONVERSATION:\n\nUSER: I cannot find my password reset button\n\nASSISTANT: I\'m connecting you to a human agent.','ESCALATED CONVERSATION:<br />\n<br />\nUSER: I cannot find my password reset button<br />\n<br />\nASSISTANT: I&#039;m connecting you to a human agent.',1,2,2,2,1,'2026-02-24 02:02:39','2026-02-24 02:25:02','2026-02-24 02:25:02'),(7,'what is this','SOURCE: AI Support Chat\nUSER: Agency Pulse\n-----------------------------------\n\nUSER: what is this site about.\n\nASSISTANT: I\'m connecting you to a human agent.','SOURCE: AI Support Chat<br />\nUSER: Agency Pulse<br />\n-----------------------------------<br />\n<br />\nUSER: what is this site about.<br />\n<br />\nASSISTANT: I&#039;m connecting you to a human agent.',1,2,4,2,1,'2026-02-24 02:17:24','2026-02-24 02:24:53','2026-02-24 02:24:53'),(8,'AI Escalation: can i talk to a person...','SOURCE: AI Support Chat\nUSER: Agency Pulse\n-----------------------------------\n\nUSER: what is this plugin\n\nASSISTANT: AgencyPulseWP is a WordPress plugin designed to help agencies manage their projects, clients, and team members more effectively.\n\nUSER: what can it do\n\nASSISTANT: AgencyPulseWP helps you manage your projects, clients, and team members. This includes features for:\n\n*   Project tracking\n*   Client communication\n*   Team collaboration\n*   Task assignment\n*   Reporting\n\nUSER: can i talk to a person\n\nASSISTANT: I\'ll connect you with a human agent.','SOURCE: AI Support Chat<br />\nUSER: Agency Pulse<br />\n-----------------------------------<br />\n<br />\nUSER: what is this plugin<br />\n<br />\nASSISTANT: AgencyPulseWP is a WordPress plugin designed to help agencies manage their projects, clients, and team members more effectively.<br />\n<br />\nUSER: what can it do<br />\n<br />\nASSISTANT: AgencyPulseWP helps you manage your projects, clients, and team members. This includes features for:<br />\n<br />\n*   Project tracking<br />\n*   Client communication<br />\n*   Team collaboration<br />\n*   Task assignment<br />\n*   Reporting<br />\n<br />\nUSER: can i talk to a person<br />\n<br />\nASSISTANT: I&#039;ll connect you with a human agent.',1,2,4,2,1,'2026-02-25 02:43:55','2026-02-25 02:43:55',NULL),(9,'AI Escalation: what page is this...','SOURCE: AI Support Chat\nUSER: Agency Pulse\n-----------------------------------\n\nUSER: what page of plugin is this\n\nASSISTANT: This is the `agency_pulse_invoice_page_invoice_dashboard` page.\n\nUSER: describe this page\n\nASSISTANT: I couldn\'t find that in the documentation.\n\nUSER: what option on this page\n\nASSISTANT: I couldn\'t find that in the documentation.\n\nUSER: what page is this\n\nASSISTANT: \nYou are a support assistant for AgencyPulseWP.\n\nYour job is to help users understand how to use the plugins.\n\nRules:\n- Only answer using the provided documentation context.\n- If the answer is not in the documentation, say:\n  \'I couldn\'t find that in the documentation.\'\n- Do not invent features or settings.\n- Keep responses short and clear.\n- Prefer bullet points for instructions.\n\nContext information:\nPlugin: agency-pulse-invoice\nPage: agency_pulse_invoice_page_invoice_dashboard\n\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.\n\nIf the user asks for a human, or appears frustrated, respond exactly:\nI\'ll connect you with a human agent.\n','SOURCE: AI Support Chat<br />\nUSER: Agency Pulse<br />\n-----------------------------------<br />\n<br />\nUSER: what page of plugin is this<br />\n<br />\nASSISTANT: This is the `agency_pulse_invoice_page_invoice_dashboard` page.<br />\n<br />\nUSER: describe this page<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation.<br />\n<br />\nUSER: what option on this page<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation.<br />\n<br />\nUSER: what page is this<br />\n<br />\nASSISTANT: <br />\nYou are a support assistant for AgencyPulseWP.<br />\n<br />\nYour job is to help users understand how to use the plugins.<br />\n<br />\nRules:<br />\n- Only answer using the provided documentation context.<br />\n- If the answer is not in the documentation, say:<br />\n  &#039;I couldn&#039;t find that in the documentation.&#039;<br />\n- Do not invent features or settings.<br />\n- Keep responses short and clear.<br />\n- Prefer bullet points for instructions.<br />\n<br />\nContext information:<br />\nPlugin: agency-pulse-invoice<br />\nPage: agency_pulse_invoice_page_invoice_dashboard<br />\n<br />\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.<br />\n<br />\nIf the user asks for a human, or appears frustrated, respond exactly:<br />\nI&#039;ll connect you with a human agent.<br />\n',1,2,5,2,1,'2026-03-07 01:32:11','2026-03-07 01:32:11',NULL),(10,'AI Escalation: help me here...','SOURCE: AI Support Chat\nUSER: Agency Pulse\n-----------------------------------\n\nUSER: help me here\n\nASSISTANT: \nYou are a support assistant for AgencyPulseWP.\n\nYour job is to help users understand how to use the plugins.\n\nRules:\n- Only answer using the provided documentation context.\n- If the answer is not in the documentation, say:\n  \'I couldn\'t find that in the documentation.\'\n- Do not invent features or settings.\n- Keep responses short and clear.\n- Prefer bullet points for instructions.\n\nContext information:\nPlugin: agency-pulse-invoice\nPage: agency_pulse_invoice_page_invoice_dashboard\n\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.\n\nIf the user asks for a human, or appears frustrated, respond exactly:\nI\'ll connect you with a human agent.\n','SOURCE: AI Support Chat<br />\nUSER: Agency Pulse<br />\n-----------------------------------<br />\n<br />\nUSER: help me here<br />\n<br />\nASSISTANT: <br />\nYou are a support assistant for AgencyPulseWP.<br />\n<br />\nYour job is to help users understand how to use the plugins.<br />\n<br />\nRules:<br />\n- Only answer using the provided documentation context.<br />\n- If the answer is not in the documentation, say:<br />\n  &#039;I couldn&#039;t find that in the documentation.&#039;<br />\n- Do not invent features or settings.<br />\n- Keep responses short and clear.<br />\n- Prefer bullet points for instructions.<br />\n<br />\nContext information:<br />\nPlugin: agency-pulse-invoice<br />\nPage: agency_pulse_invoice_page_invoice_dashboard<br />\n<br />\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.<br />\n<br />\nIf the user asks for a human, or appears frustrated, respond exactly:<br />\nI&#039;ll connect you with a human agent.<br />\n',1,2,5,2,1,'2026-03-07 01:33:32','2026-03-07 01:33:32',NULL),(11,'AI Escalation: help page plugin...','SOURCE: AI Support Chat\nUSER: Agency Pulse\n-----------------------------------\n\nUSER: help page plugin\n\nASSISTANT: [{\"role\":\"user\",\"parts\":[{\"text\":\"SYSTEM INSTRUCTION: \\nYou are a support assistant for AgencyPulseWP.\\n\\nYour job is to help users understand how to use the plugins.\\n\\nRules:\\n- Only answer using the provided documentation context.\\n- If the answer is not in the documentation, say:\\n  \'I couldn\'t find that in the documentation.\'\\n- Do not invent features or settings.\\n- Keep responses short and clear.\\n- Prefer bullet points for instructions.\\n\\nContext information:\\nPlugin: agency-pulse-invoice\\nPage: agency_pulse_invoice_page_invoice_dashboard\\n\\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.\\n\\nIf the user asks for a human, or appears frustrated, respond exactly:\\nI\'ll connect you with a human agent.\\n\"}]},{\"role\":\"model\",\"parts\":[{\"text\":\"Understood. I will act as a support assistant for AgencyPulseWP following those rules.\"}]},{\"role\":\"user\",\"parts\":[{\"text\":\"Documentation context:\\n\\nSection: Searching for Invoices\\nUse the search bar at the top of the dashboard Enter customer name, email, or invoice ID Optionally select specific status filters Click Search to display matching results Click Clear to reset filters and view all invoices\\n\\nSection: Key Sections & Features\\nAt the top of the dashboard, you\'ll find a comprehensive search and filter section with the following fields: Customer Name - Search invoices by customer name Email - Filter invoices by customer email address Invoice ID - Find specific invoices by number (supports autocomplete) Status Filter - Multi-select dropdown to filter by invoice status:\\n                \\n                    Draft - Invoices not yet published\\n                    Pro-forma - Preliminary invoices for quotation\\n                    Unpaid - Invoices awaiting payment\\n                    Partial - Invoices with partial payments received\\n                    Paid - Fully paid invoices Draft - Invoices not yet published Pro-forma - Preliminary invoices for quotation Unpaid - Invoices awaiting payment Partial - Invoices with\\n\\nSection: Browser Persistence\\nThe dashboard saves your preferences in your browser\'s local storage: Accordion section states (expanded\\/collapsed) are remembered between sessions Your last search filters are retained Dashboard layout preferences persist across visits\\n\\n\"}]},{\"role\":\"model\",\"parts\":[{\"text\":\"Got it. I will use this documentation to answer questions.\"}]},{\"role\":\"user\",\"parts\":[{\"text\":\"help page plugin\"}]}]','SOURCE: AI Support Chat<br />\nUSER: Agency Pulse<br />\n-----------------------------------<br />\n<br />\nUSER: help page plugin<br />\n<br />\nASSISTANT: [{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;SYSTEM INSTRUCTION: \\nYou are a support assistant for AgencyPulseWP.\\n\\nYour job is to help users understand how to use the plugins.\\n\\nRules:\\n- Only answer using the provided documentation context.\\n- If the answer is not in the documentation, say:\\n  &#039;I couldn&#039;t find that in the documentation.&#039;\\n- Do not invent features or settings.\\n- Keep responses short and clear.\\n- Prefer bullet points for instructions.\\n\\nContext information:\\nPlugin: agency-pulse-invoice\\nPage: agency_pulse_invoice_page_invoice_dashboard\\n\\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.\\n\\nIf the user asks for a human, or appears frustrated, respond exactly:\\nI&#039;ll connect you with a human agent.\\n&quot;}]},{&quot;role&quot;:&quot;model&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Understood. I will act as a support assistant for AgencyPulseWP following those rules.&quot;}]},{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Documentation context:\\n\\nSection: Searching for Invoices\\nUse the search bar at the top of the dashboard Enter customer name, email, or invoice ID Optionally select specific status filters Click Search to display matching results Click Clear to reset filters and view all invoices\\n\\nSection: Key Sections &amp; Features\\nAt the top of the dashboard, you&#039;ll find a comprehensive search and filter section with the following fields: Customer Name - Search invoices by customer name Email - Filter invoices by customer email address Invoice ID - Find specific invoices by number (supports autocomplete) Status Filter - Multi-select dropdown to filter by invoice status:\\n                \\n                    Draft - Invoices not yet published\\n                    Pro-forma - Preliminary invoices for quotation\\n                    Unpaid - Invoices awaiting payment\\n                    Partial - Invoices with partial payments received\\n                    Paid - Fully paid invoices Draft - Invoices not yet published Pro-forma - Preliminary invoices for quotation Unpaid - Invoices awaiting payment Partial - Invoices with\\n\\nSection: Browser Persistence\\nThe dashboard saves your preferences in your browser&#039;s local storage: Accordion section states (expanded\\/collapsed) are remembered between sessions Your last search filters are retained Dashboard layout preferences persist across visits\\n\\n&quot;}]},{&quot;role&quot;:&quot;model&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Got it. I will use this documentation to answer questions.&quot;}]},{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;help page plugin&quot;}]}]',1,2,5,2,1,'2026-03-07 01:47:08','2026-03-07 01:47:08',NULL),(12,'AI Escalation: what do i see on this page of the plugin...','SOURCE: AI Support Chat\nUSER: Agency Pulse\n-----------------------------------\n\nUSER: what do i see on this page of the plugin\n\nASSISTANT: [{\"role\":\"user\",\"parts\":[{\"text\":\"SYSTEM INSTRUCTION: \\nYou are a support assistant for AgencyPulseWP.\\n\\nYour job is to help users understand how to use the plugins.\\n\\nRules:\\n- Only answer using the provided documentation context.\\n- If the answer is not in the documentation, say:\\n  \'I couldn\'t find that in the documentation.\'\\n- Do not invent features or settings.\\n- Keep responses short and clear.\\n- Prefer bullet points for instructions.\\n\\nContext information:\\nPlugin: agency-pulse-invoice\\nPage: agency_pulse_invoice_page_invoice_dashboard\\n\\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.\\n\\nIf the user asks for a human, or appears frustrated, respond exactly:\\nI\'ll connect you with a human agent.\\n\"}]},{\"role\":\"model\",\"parts\":[{\"text\":\"Understood. I will act as a support assistant for AgencyPulseWP following those rules.\"}]},{\"role\":\"user\",\"parts\":[{\"text\":\"Documentation context:\\n\\nSection: Data Displayed on Dashboard\\nData Element Purpose Invoice Count per Status Shows how many invoices are in each status category (displayed in section headers) Invoice Number Unique identifier for each invoice; includes \\\"Draft\\\" indicator if not yet published Assigned User WordPress user responsible for the invoice Customer Information Name and email for direct communication Invoice Amount Total value; for partial payments, shows amount still owed Dates Creation date, due date (unpaid) or paid date (paid invoices) Payment Status Visual indicator of invoice payment state Payment Method How the invoice was paid (for manually recorded payments)\\n\\nSection: Key Sections & Features\\n Fully paid invoices. Archived view for completed transactions. Each invoice row displays the following key information: Invoice Number - Clickable link to edit or view the invoice WP User - WordPress user assigned to the invoice Customer Name - Name of the customer\\/client Customer Email - Email address for the customer Amount - Total invoice amount (shows balance owed for partial payments) Date Created - When the invoice was created Due Date \\/ Paid Date - Payment deadline or date invoice was paid Action Buttons - Quick action buttons for invoice management Each invoice row includes action buttons for common tasks: Action Description Available For VIEW Opens the invoice in the customer portal (new tab\\/window) All invoices SEND Opens modal to preview and send invoice email to customer All\\n\\nSection: Key Sections & Features\\n partial payments received Paid - Fully paid invoices Search Button - Executes the search with all selected filters Clear Button - Resets all filters and search fields The dashboard organizes invoices into four collapsible accordion sections. Click any section header to expand or collapse it. Your expanded\\/collapsed state is automatically saved: Status Section Invoice Count Description Draft Invoices Displayed in header Invoices created but not yet sent to customers. Can be edited and customized before sending. Pro-forma Invoices Displayed in header Preliminary or quotation invoices sent for review before creating the official invoice. Unpaid Invoices Displayed in header Active invoices awaiting payment. Includes both unpaid and partially paid invoices. Paid Invoices Displayed in header\\n\\n\"}]},{\"role\":\"model\",\"parts\":[{\"text\":\"Got it. I will use this documentation to answer questions.\"}]},{\"role\":\"user\",\"parts\":[{\"text\":\"what do i see on this page of the plugin\"}]}]','SOURCE: AI Support Chat<br />\nUSER: Agency Pulse<br />\n-----------------------------------<br />\n<br />\nUSER: what do i see on this page of the plugin<br />\n<br />\nASSISTANT: [{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;SYSTEM INSTRUCTION: \\nYou are a support assistant for AgencyPulseWP.\\n\\nYour job is to help users understand how to use the plugins.\\n\\nRules:\\n- Only answer using the provided documentation context.\\n- If the answer is not in the documentation, say:\\n  &#039;I couldn&#039;t find that in the documentation.&#039;\\n- Do not invent features or settings.\\n- Keep responses short and clear.\\n- Prefer bullet points for instructions.\\n\\nContext information:\\nPlugin: agency-pulse-invoice\\nPage: agency_pulse_invoice_page_invoice_dashboard\\n\\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.\\n\\nIf the user asks for a human, or appears frustrated, respond exactly:\\nI&#039;ll connect you with a human agent.\\n&quot;}]},{&quot;role&quot;:&quot;model&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Understood. I will act as a support assistant for AgencyPulseWP following those rules.&quot;}]},{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Documentation context:\\n\\nSection: Data Displayed on Dashboard\\nData Element Purpose Invoice Count per Status Shows how many invoices are in each status category (displayed in section headers) Invoice Number Unique identifier for each invoice; includes \\&quot;Draft\\&quot; indicator if not yet published Assigned User WordPress user responsible for the invoice Customer Information Name and email for direct communication Invoice Amount Total value; for partial payments, shows amount still owed Dates Creation date, due date (unpaid) or paid date (paid invoices) Payment Status Visual indicator of invoice payment state Payment Method How the invoice was paid (for manually recorded payments)\\n\\nSection: Key Sections &amp; Features\\n Fully paid invoices. Archived view for completed transactions. Each invoice row displays the following key information: Invoice Number - Clickable link to edit or view the invoice WP User - WordPress user assigned to the invoice Customer Name - Name of the customer\\/client Customer Email - Email address for the customer Amount - Total invoice amount (shows balance owed for partial payments) Date Created - When the invoice was created Due Date \\/ Paid Date - Payment deadline or date invoice was paid Action Buttons - Quick action buttons for invoice management Each invoice row includes action buttons for common tasks: Action Description Available For VIEW Opens the invoice in the customer portal (new tab\\/window) All invoices SEND Opens modal to preview and send invoice email to customer All\\n\\nSection: Key Sections &amp; Features\\n partial payments received Paid - Fully paid invoices Search Button - Executes the search with all selected filters Clear Button - Resets all filters and search fields The dashboard organizes invoices into four collapsible accordion sections. Click any section header to expand or collapse it. Your expanded\\/collapsed state is automatically saved: Status Section Invoice Count Description Draft Invoices Displayed in header Invoices created but not yet sent to customers. Can be edited and customized before sending. Pro-forma Invoices Displayed in header Preliminary or quotation invoices sent for review before creating the official invoice. Unpaid Invoices Displayed in header Active invoices awaiting payment. Includes both unpaid and partially paid invoices. Paid Invoices Displayed in header\\n\\n&quot;}]},{&quot;role&quot;:&quot;model&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Got it. I will use this documentation to answer questions.&quot;}]},{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;what do i see on this page of the plugin&quot;}]}]',1,2,5,2,1,'2026-03-07 01:54:43','2026-03-07 01:54:43',NULL),(13,'AI Escalation: what do i see on this page...','SOURCE: AI Support Chat\nUSER: Agency Pulse\n-----------------------------------\n\nUSER: what do i see on this page\n\nASSISTANT: [{\"role\":\"user\",\"parts\":[{\"text\":\"SYSTEM INSTRUCTION: \\nYou are a support assistant for AgencyPulseWP.\\n\\nYour job is to help users understand how to use the plugins.\\n\\nRules:\\n- Only answer using the provided documentation context.\\n- If the answer is not in the documentation, say:\\n  \'I couldn\'t find that in the documentation.\'\\n- Do not invent features or settings.\\n- Keep responses short and clear.\\n- Prefer bullet points for instructions.\\n\\nContext information:\\nPlugin: agency-pulse-invoice\\nPage: agency_pulse_invoice_page_invoice_dashboard\\n\\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.\\n\\nIf the user asks for a human, or appears frustrated, respond exactly:\\nI\'ll connect you with a human agent.\\n\"}]},{\"role\":\"model\",\"parts\":[{\"text\":\"Understood. I will act as a support assistant for AgencyPulseWP following those rules.\"}]},{\"role\":\"user\",\"parts\":[{\"text\":\"Documentation context:\\n\\nSection: Data Displayed on Dashboard\\nData Element Purpose Invoice Count per Status Shows how many invoices are in each status category (displayed in section headers) Invoice Number Unique identifier for each invoice; includes \\\"Draft\\\" indicator if not yet published Assigned User WordPress user responsible for the invoice Customer Information Name and email for direct communication Invoice Amount Total value; for partial payments, shows amount still owed Dates Creation date, due date (unpaid) or paid date (paid invoices) Payment Status Visual indicator of invoice payment state Payment Method How the invoice was paid (for manually recorded payments)\\n\\nSection: Key Sections & Features\\n partial payments received Paid - Fully paid invoices Search Button - Executes the search with all selected filters Clear Button - Resets all filters and search fields The dashboard organizes invoices into four collapsible accordion sections. Click any section header to expand or collapse it. Your expanded\\/collapsed state is automatically saved: Status Section Invoice Count Description Draft Invoices Displayed in header Invoices created but not yet sent to customers. Can be edited and customized before sending. Pro-forma Invoices Displayed in header Preliminary or quotation invoices sent for review before creating the official invoice. Unpaid Invoices Displayed in header Active invoices awaiting payment. Includes both unpaid and partially paid invoices. Paid Invoices Displayed in header\\n\\nSection: Key Sections & Features\\nAt the top of the dashboard, you\'ll find a comprehensive search and filter section with the following fields: Customer Name - Search invoices by customer name Email - Filter invoices by customer email address Invoice ID - Find specific invoices by number (supports autocomplete) Status Filter - Multi-select dropdown to filter by invoice status:\\n                \\n                    Draft - Invoices not yet published\\n                    Pro-forma - Preliminary invoices for quotation\\n                    Unpaid - Invoices awaiting payment\\n                    Partial - Invoices with partial payments received\\n                    Paid - Fully paid invoices Draft - Invoices not yet published Pro-forma - Preliminary invoices for quotation Unpaid - Invoices awaiting payment Partial - Invoices with\\n\\n\"}]},{\"role\":\"model\",\"parts\":[{\"text\":\"Got it. I will use this documentation to answer questions.\"}]},{\"role\":\"user\",\"parts\":[{\"text\":\"what do i see on this page\"}]}]','SOURCE: AI Support Chat<br />\nUSER: Agency Pulse<br />\n-----------------------------------<br />\n<br />\nUSER: what do i see on this page<br />\n<br />\nASSISTANT: [{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;SYSTEM INSTRUCTION: \\nYou are a support assistant for AgencyPulseWP.\\n\\nYour job is to help users understand how to use the plugins.\\n\\nRules:\\n- Only answer using the provided documentation context.\\n- If the answer is not in the documentation, say:\\n  &#039;I couldn&#039;t find that in the documentation.&#039;\\n- Do not invent features or settings.\\n- Keep responses short and clear.\\n- Prefer bullet points for instructions.\\n\\nContext information:\\nPlugin: agency-pulse-invoice\\nPage: agency_pulse_invoice_page_invoice_dashboard\\n\\nIf the user asks about another plugin or unrelated topic, politely explain that this chat is limited to the current plugin page.\\n\\nIf the user asks for a human, or appears frustrated, respond exactly:\\nI&#039;ll connect you with a human agent.\\n&quot;}]},{&quot;role&quot;:&quot;model&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Understood. I will act as a support assistant for AgencyPulseWP following those rules.&quot;}]},{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Documentation context:\\n\\nSection: Data Displayed on Dashboard\\nData Element Purpose Invoice Count per Status Shows how many invoices are in each status category (displayed in section headers) Invoice Number Unique identifier for each invoice; includes \\&quot;Draft\\&quot; indicator if not yet published Assigned User WordPress user responsible for the invoice Customer Information Name and email for direct communication Invoice Amount Total value; for partial payments, shows amount still owed Dates Creation date, due date (unpaid) or paid date (paid invoices) Payment Status Visual indicator of invoice payment state Payment Method How the invoice was paid (for manually recorded payments)\\n\\nSection: Key Sections &amp; Features\\n partial payments received Paid - Fully paid invoices Search Button - Executes the search with all selected filters Clear Button - Resets all filters and search fields The dashboard organizes invoices into four collapsible accordion sections. Click any section header to expand or collapse it. Your expanded\\/collapsed state is automatically saved: Status Section Invoice Count Description Draft Invoices Displayed in header Invoices created but not yet sent to customers. Can be edited and customized before sending. Pro-forma Invoices Displayed in header Preliminary or quotation invoices sent for review before creating the official invoice. Unpaid Invoices Displayed in header Active invoices awaiting payment. Includes both unpaid and partially paid invoices. Paid Invoices Displayed in header\\n\\nSection: Key Sections &amp; Features\\nAt the top of the dashboard, you&#039;ll find a comprehensive search and filter section with the following fields: Customer Name - Search invoices by customer name Email - Filter invoices by customer email address Invoice ID - Find specific invoices by number (supports autocomplete) Status Filter - Multi-select dropdown to filter by invoice status:\\n                \\n                    Draft - Invoices not yet published\\n                    Pro-forma - Preliminary invoices for quotation\\n                    Unpaid - Invoices awaiting payment\\n                    Partial - Invoices with partial payments received\\n                    Paid - Fully paid invoices Draft - Invoices not yet published Pro-forma - Preliminary invoices for quotation Unpaid - Invoices awaiting payment Partial - Invoices with\\n\\n&quot;}]},{&quot;role&quot;:&quot;model&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;Got it. I will use this documentation to answer questions.&quot;}]},{&quot;role&quot;:&quot;user&quot;,&quot;parts&quot;:[{&quot;text&quot;:&quot;what do i see on this page&quot;}]}]',1,2,5,2,1,'2026-03-07 01:56:48','2026-03-07 01:56:48',NULL),(14,'AI Escalation: what can this plugin do for me...','SOURCE: AI Support Chat\nUSER: AgencyPulseWP\n-----------------------------------\n\nUSER: list of pages in this plugin\n\nUSER: what capabilities\n\nASSISTANT: I couldn\'t find that in the documentation.\n\nUSER: what can this plugin do for me\n\nASSISTANT: This plugin offers the following core features:\n\n*   **Multi-Currency Support**: Prices are automatically formatted based on currency settings.\n*   **Shopping Cart Integration**: Products are available for public shopping cart and checkout.\n*   **Internal Notes**: Hidden notes visible only to staff for product information.\n\nIt also integrates with:\n\n*   Digital products, including download link generation.\n*   Product categories for filtering.\n*   Coupons to apply discounts to cart totals.','SOURCE: AI Support Chat<br />\nUSER: AgencyPulseWP<br />\n-----------------------------------<br />\n<br />\nUSER: list of pages in this plugin<br />\n<br />\nUSER: what capabilities<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation.<br />\n<br />\nUSER: what can this plugin do for me<br />\n<br />\nASSISTANT: This plugin offers the following core features:<br />\n<br />\n*   **Multi-Currency Support**: Prices are automatically formatted based on currency settings.<br />\n*   **Shopping Cart Integration**: Products are available for public shopping cart and checkout.<br />\n*   **Internal Notes**: Hidden notes visible only to staff for product information.<br />\n<br />\nIt also integrates with:<br />\n<br />\n*   Digital products, including download link generation.<br />\n*   Product categories for filtering.<br />\n*   Coupons to apply discounts to cart totals.',1,2,2,2,1,'2026-03-07 12:11:46','2026-03-07 12:11:46',NULL),(15,'AI Escalation: do invoice support multi-currency...','SOURCE: AI Support Chat\nUSER: AgencyPulseWP\n-----------------------------------\n\nUSER: what option exist on this page\n\nASSISTANT: On the invoice editor page, you have the following options:\n\n*   **Accessing the Editor**:\n    *   Create New Invoice: Go to Invoices > Invoices and click Add New.\n    *   Edit Existing Invoice: Go to Invoices > Invoices, find the invoice in the list, and click on it.\n*   **Main Metaboxes**:\n    *   **User Selector**: Dropdown to select a WordPress user responsible for the invoice.\n    *   **File Upload**: Upload associated documents with Media Library integration.\n    *   **Notes Field**: Rich text editor for internal notes (not shown to customers).\n    *   **Issue Button**: Changes invoice status from Draft to active, generates an invoice number, and makes it visible to customers.\n    *   **Revoke Button**: Changes an issued invoice\'s status back to Draft (for Draft invoices only).\n    *   **Invoice Number**: Auto-generated when issued (read-only).\n    *   **Status**: Current invoice status (Draft, Pro-forma, Unpaid, Partial, Paid).\n    *   **Due Date**: Payment due date (date picker).\n    *   **Total Amount**: Automatically calculated total (read-only).\n    *   **Amount Paid**: Tracks total payments received.\n    *   **Company Selector**: Dropdown to select a company (configured in Invoices > Settings > General Settings).\n    *   **Tax Rate Checkboxes**: Select applicable tax rates (can also be applied to individual line items).\n    *   **Country**: Country selection (AJAX-enabled with subdivision support).\n    *   **zip code**\n\nUSER: is there file storage support on invoices\n\nASSISTANT: Yes, there is file storage support for invoices.\n\n*   **File Upload**: You can upload associated documents.\n*   **Media Library Integration**: You can browse and select files from the media library.\n*   Files are displayed alongside the invoice for customers.\n*   This is useful for attachments like quotes, specifications, or supporting documents.\n\nUSER: can we use secure external file storage\n\nASSISTANT: I couldn\'t find that in the documentation.\n\nUSER: what does invoice enhancement plugin do\n\nASSISTANT: I couldn\'t find that in the documentation. I couldn\'t find that in the documentation.\n\nUSER: do invoice support multi-currency\n\nASSISTANT: I couldn\'t find that in the documentation.','SOURCE: AI Support Chat<br />\nUSER: AgencyPulseWP<br />\n-----------------------------------<br />\n<br />\nUSER: what option exist on this page<br />\n<br />\nASSISTANT: On the invoice editor page, you have the following options:<br />\n<br />\n*   **Accessing the Editor**:<br />\n    *   Create New Invoice: Go to Invoices &gt; Invoices and click Add New.<br />\n    *   Edit Existing Invoice: Go to Invoices &gt; Invoices, find the invoice in the list, and click on it.<br />\n*   **Main Metaboxes**:<br />\n    *   **User Selector**: Dropdown to select a WordPress user responsible for the invoice.<br />\n    *   **File Upload**: Upload associated documents with Media Library integration.<br />\n    *   **Notes Field**: Rich text editor for internal notes (not shown to customers).<br />\n    *   **Issue Button**: Changes invoice status from Draft to active, generates an invoice number, and makes it visible to customers.<br />\n    *   **Revoke Button**: Changes an issued invoice&#039;s status back to Draft (for Draft invoices only).<br />\n    *   **Invoice Number**: Auto-generated when issued (read-only).<br />\n    *   **Status**: Current invoice status (Draft, Pro-forma, Unpaid, Partial, Paid).<br />\n    *   **Due Date**: Payment due date (date picker).<br />\n    *   **Total Amount**: Automatically calculated total (read-only).<br />\n    *   **Amount Paid**: Tracks total payments received.<br />\n    *   **Company Selector**: Dropdown to select a company (configured in Invoices &gt; Settings &gt; General Settings).<br />\n    *   **Tax Rate Checkboxes**: Select applicable tax rates (can also be applied to individual line items).<br />\n    *   **Country**: Country selection (AJAX-enabled with subdivision support).<br />\n    *   **zip code**<br />\n<br />\nUSER: is there file storage support on invoices<br />\n<br />\nASSISTANT: Yes, there is file storage support for invoices.<br />\n<br />\n*   **File Upload**: You can upload associated documents.<br />\n*   **Media Library Integration**: You can browse and select files from the media library.<br />\n*   Files are displayed alongside the invoice for customers.<br />\n*   This is useful for attachments like quotes, specifications, or supporting documents.<br />\n<br />\nUSER: can we use secure external file storage<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation.<br />\n<br />\nUSER: what does invoice enhancement plugin do<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation. I couldn&#039;t find that in the documentation.<br />\n<br />\nUSER: do invoice support multi-currency<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation.',1,2,2,2,1,'2026-03-07 14:39:14','2026-03-07 14:39:14',NULL),(16,'AI Escalation: how are overdue emails scheduled...','SOURCE: AI Support Chat\nUSER: Guest ()\n-----------------------------------\n\nUSER: what are scheduled missions\n\nASSISTANT: Scheduled missions are emails that are:\n\n*   Displayed in real-time in the Live Mission Queue.\n*   Fetched from an external server.\n*   Automatically scheduled in two phases (Reminder and Overdue) based on the invoice due date.\n*   Tracked with a calculated next scheduled send time.\n\nUSER: are these paid options\n\nASSISTANT: I couldn\'t find that in the documentation.\n\nUSER: what can we do with these missions\n\nASSISTANT: With these missions, you can:\n*   Fetch them from an external server via API.\n*   Enrich them with local data.\n*   Render them in the admin UI.\n*   Orchestrate their creation and termination.\n*   Handle them as \"Reminder\" (before due date) or \"Overdue\" (after due date) types.\n\nUSER: what are the mission type details\n\nASSISTANT: The documentation mentions the following mission types:\n\n*   **Reminder**: Used for missions before the due date.\n*   **Overdue**: Used for missions after the due date.\n\nIt also lists `type` as the \"Original mission type from server\".\n\nUSER: how are overdue emails scheduled\n\nASSISTANT: Missions allow you to:\n*   See which invoices have received payment reminders and when the next reminder is scheduled.\n*   Monitor overdue email delivery and see how many more will be sent after an invoice passes its due date.\n\nOverdue emails are scheduled:\n*   Based on the `due_date`, plus an interval calculated by `(sent_count + 1) × interval`.\n*   The `Next Send` is subject to day/count limits.\n*   Sending stops after reaching the maximum email count or maximum days after the due date, whichever comes first.\n*   The specific time of day to send overdue emails is `overdue_send_time`.\n*   Configuration is controlled by Portal > Settings > Payment Overdue tab.','SOURCE: AI Support Chat<br />\nUSER: Guest ()<br />\n-----------------------------------<br />\n<br />\nUSER: what are scheduled missions<br />\n<br />\nASSISTANT: Scheduled missions are emails that are:<br />\n<br />\n*   Displayed in real-time in the Live Mission Queue.<br />\n*   Fetched from an external server.<br />\n*   Automatically scheduled in two phases (Reminder and Overdue) based on the invoice due date.<br />\n*   Tracked with a calculated next scheduled send time.<br />\n<br />\nUSER: are these paid options<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation.<br />\n<br />\nUSER: what can we do with these missions<br />\n<br />\nASSISTANT: With these missions, you can:<br />\n*   Fetch them from an external server via API.<br />\n*   Enrich them with local data.<br />\n*   Render them in the admin UI.<br />\n*   Orchestrate their creation and termination.<br />\n*   Handle them as &quot;Reminder&quot; (before due date) or &quot;Overdue&quot; (after due date) types.<br />\n<br />\nUSER: what are the mission type details<br />\n<br />\nASSISTANT: The documentation mentions the following mission types:<br />\n<br />\n*   **Reminder**: Used for missions before the due date.<br />\n*   **Overdue**: Used for missions after the due date.<br />\n<br />\nIt also lists `type` as the &quot;Original mission type from server&quot;.<br />\n<br />\nUSER: how are overdue emails scheduled<br />\n<br />\nASSISTANT: Missions allow you to:<br />\n*   See which invoices have received payment reminders and when the next reminder is scheduled.<br />\n*   Monitor overdue email delivery and see how many more will be sent after an invoice passes its due date.<br />\n<br />\nOverdue emails are scheduled:<br />\n*   Based on the `due_date`, plus an interval calculated by `(sent_count + 1) × interval`.<br />\n*   The `Next Send` is subject to day/count limits.<br />\n*   Sending stops after reaching the maximum email count or maximum days after the due date, whichever comes first.<br />\n*   The specific time of day to send overdue emails is `overdue_send_time`.<br />\n*   Configuration is controlled by Portal &gt; Settings &gt; Payment Overdue tab.',1,2,2,2,1,'2026-03-07 16:48:07','2026-03-07 16:48:07',NULL),(17,'AI Escalation: what are some limitations that exist...','SOURCE: AI Support Chat\nUSER: Guest (gwa.gjp+3@gmail.com)\n-----------------------------------\n\nUSER: how do i schedule overdue msgs\n\nASSISTANT: To schedule overdue messages:\n\n*   **Due Date Arrival:** The system identifies an invoice as past due when its due date is reached.\n*   **Interval Scheduling:** An external server schedules the first overdue email for the due date + your configured send interval (e.g., 3 days after).\n*   **Recurring Schedule:** Subsequent overdue emails are scheduled for due date + (interval × count).\n\nUSER: how to schedule reminder messages\n\nASSISTANT: I couldn\'t find that in the documentation.\n\nUSER: tell me about integration points\n\nASSISTANT: I couldn\'t find that in the documentation.\n\nUSER: how about manual sending options\n\nASSISTANT: You can manually send an overdue payment email for an invoice from the invoice editor or dashboard:\n*   Navigate to Invoices > All Invoices or open the invoice editor.\n*   Find the invoice needing a reminder.\n*   Click the \"Send Overdue Email\" button (usually on the dashboard metabox).\n*   The email is composed using the current configured subject and body.\n*   The email is sent immediately to the customer (not queued to send time).\n*   Manual sends don\'t count against automated overdue limits.\n\nUSER: what tags can i put in emails\n\nASSISTANT: You can use the following placeholders in your email subject and body:\n*   `{customer_name}`: First and last name of customer/client\n*   `{customer_email}`: Customer email address\n*   `{invoice_number}`: Invoice number/reference\n*   `{amount_due}` or `{invoice_amount}`: Total invoice amount with currency\n*   `{due_date}`: Invoice due date\n*   `{days_until_due}`: Number of days remaining until due date (shows 0 for overdue phase)\n*   `{days_overdue}`: Number of days past due date\n\nI couldn\'t find information about integration points in the documentation.\n\nUSER: what data storage references exist\n\nASSISTANT: I couldn\'t find information about integration points in the documentation.\n\nRegarding data storage references, the following placeholders are available for invoices:\n*   `_invoice_client_email`: Customer email for sending overdue email.\n*   `_invoice_number`: Invoice number for `{invoice_number}` placeholder.\n*   `_invoice_total`: Total amount for `{amount_due}` placeholder.\n*   `_invoice_due_date`: Due date for `{due_date}` and `{days_overdue}` placeholders.\n*   `_invoice_access_token`: Secure token for `{payment_link}` placeholder.\n\nUSER: what are some limitations that exist\n\nASSISTANT: The following limitations exist:\n*   Portal API client must be configured; without it, missions cannot be scheduled.\n*   Email subject is limited to plain text (no HTML tags or formatting).\n*   Overdue settings are configured globally, meaning all invoices use the same interval, limits, and send time.\n*   Daily Send Time applies to ALL overdue emails; you cannot send at different times based on overdue age.\n*   The minute selector only allows 15-minute increments (0, 15, 30, 45).\n*   An external server processes missions every minute, so the actual send may be ±1 minute from the configured time.\n*   Overdue emails don\'t send for paid invoices; the mission is automatically cancelled when an invoice is marked paid.\n*   Stop conditions are checked after each send; if the email count reaches the limit on the same day as the day limit, it stops immediately.\n*   There is no way to send overdue emails for invoices with deleted customers.\n*   Interval calculation is fixed; you cannot vary the interval based on overdue age.\n*   There is no built-in email bounce handling or unsubscribe.','SOURCE: AI Support Chat<br />\nUSER: Guest (gwa.gjp+3@gmail.com)<br />\n-----------------------------------<br />\n<br />\nUSER: how do i schedule overdue msgs<br />\n<br />\nASSISTANT: To schedule overdue messages:<br />\n<br />\n*   **Due Date Arrival:** The system identifies an invoice as past due when its due date is reached.<br />\n*   **Interval Scheduling:** An external server schedules the first overdue email for the due date + your configured send interval (e.g., 3 days after).<br />\n*   **Recurring Schedule:** Subsequent overdue emails are scheduled for due date + (interval × count).<br />\n<br />\nUSER: how to schedule reminder messages<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation.<br />\n<br />\nUSER: tell me about integration points<br />\n<br />\nASSISTANT: I couldn&#039;t find that in the documentation.<br />\n<br />\nUSER: how about manual sending options<br />\n<br />\nASSISTANT: You can manually send an overdue payment email for an invoice from the invoice editor or dashboard:<br />\n*   Navigate to Invoices &gt; All Invoices or open the invoice editor.<br />\n*   Find the invoice needing a reminder.<br />\n*   Click the &quot;Send Overdue Email&quot; button (usually on the dashboard metabox).<br />\n*   The email is composed using the current configured subject and body.<br />\n*   The email is sent immediately to the customer (not queued to send time).<br />\n*   Manual sends don&#039;t count against automated overdue limits.<br />\n<br />\nUSER: what tags can i put in emails<br />\n<br />\nASSISTANT: You can use the following placeholders in your email subject and body:<br />\n*   `{customer_name}`: First and last name of customer/client<br />\n*   `{customer_email}`: Customer email address<br />\n*   `{invoice_number}`: Invoice number/reference<br />\n*   `{amount_due}` or `{invoice_amount}`: Total invoice amount with currency<br />\n*   `{due_date}`: Invoice due date<br />\n*   `{days_until_due}`: Number of days remaining until due date (shows 0 for overdue phase)<br />\n*   `{days_overdue}`: Number of days past due date<br />\n<br />\nI couldn&#039;t find information about integration points in the documentation.<br />\n<br />\nUSER: what data storage references exist<br />\n<br />\nASSISTANT: I couldn&#039;t find information about integration points in the documentation.<br />\n<br />\nRegarding data storage references, the following placeholders are available for invoices:<br />\n*   `_invoice_client_email`: Customer email for sending overdue email.<br />\n*   `_invoice_number`: Invoice number for `{invoice_number}` placeholder.<br />\n*   `_invoice_total`: Total amount for `{amount_due}` placeholder.<br />\n*   `_invoice_due_date`: Due date for `{due_date}` and `{days_overdue}` placeholders.<br />\n*   `_invoice_access_token`: Secure token for `{payment_link}` placeholder.<br />\n<br />\nUSER: what are some limitations that exist<br />\n<br />\nASSISTANT: The following limitations exist:<br />\n*   Portal API client must be configured; without it, missions cannot be scheduled.<br />\n*   Email subject is limited to plain text (no HTML tags or formatting).<br />\n*   Overdue settings are configured globally, meaning all invoices use the same interval, limits, and send time.<br />\n*   Daily Send Time applies to ALL overdue emails; you cannot send at different times based on overdue age.<br />\n*   The minute selector only allows 15-minute increments (0, 15, 30, 45).<br />\n*   An external server processes missions every minute, so the actual send may be ±1 minute from the configured time.<br />\n*   Overdue emails don&#039;t send for paid invoices; the mission is automatically cancelled when an invoice is marked paid.<br />\n*   Stop conditions are checked after each send; if the email count reaches the limit on the same day as the day limit, it stops immediately.<br />\n*   There is no way to send overdue emails for invoices with deleted customers.<br />\n*   Interval calculation is fixed; you cannot vary the interval based on overdue age.<br />\n*   There is no built-in email bounce handling or unsubscribe.',1,2,2,2,1,'2026-03-07 18:03:07','2026-03-07 18:03:07',NULL),(18,'AI Escalation: gggggggggggggggggggggggggggggggggggggggg...','SOURCE: AI Support Chat\nUSER: Guest (gwa.gjp+6@gmail.com)\n-----------------------------------\n\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg\n\nASSISTANT: Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?\n\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg\n\nASSISTANT: To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.\n\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','SOURCE: AI Support Chat<br />\nUSER: Guest (gwa.gjp+6@gmail.com)<br />\n-----------------------------------<br />\n<br />\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg<br />\n<br />\nASSISTANT: Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?<br />\n<br />\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg<br />\n<br />\nASSISTANT: To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.<br />\n<br />\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: ggggggggggggggggggggggggggggggggggggggggggggggggg<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.',1,2,2,2,1,'2026-03-07 19:10:12','2026-03-07 19:10:12',NULL),(19,'AI Escalation: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa...','SOURCE: AI Support Chat\nUSER: Guest (gwa.gjp@gmail.com)\n-----------------------------------\n\nUSER: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\n\nASSISTANT: Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?\n\nUSER: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\n\nASSISTANT: To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.\n\nUSER: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','SOURCE: AI Support Chat<br />\nUSER: Guest (gwa.gjp@gmail.com)<br />\n-----------------------------------<br />\n<br />\nUSER: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz<br />\n<br />\nASSISTANT: Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?<br />\n<br />\nUSER: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz<br />\n<br />\nASSISTANT: To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.<br />\n<br />\nUSER: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.',1,2,2,2,1,'2026-03-07 20:55:44','2026-03-07 20:55:44',NULL),(20,'AI Escalation: http://127.0.0.1/admin/mailing-list/1...','SOURCE: AI Support Chat\nUSER: Guest (gwa.gjp@gmail.com)\n-----------------------------------\n\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\n\nASSISTANT: Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?\n\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\naaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\naaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\n\nASSISTANT: To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.\n\nUSER: Email & Privacy Policy Email & Privacy Policy\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: Email & Privacy Policy Email & Privacy Policy\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: Email & Privacy Policy\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: http://127.0.0.1/admin/mailing-list/1\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: http://127.0.0.1/admin/mailing-list/1\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','SOURCE: AI Support Chat<br />\nUSER: Guest (gwa.gjp@gmail.com)<br />\n-----------------------------------<br />\n<br />\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br />\n<br />\nASSISTANT: Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?<br />\n<br />\nUSER: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br />\naaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br />\naaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa<br />\n<br />\nASSISTANT: To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.<br />\n<br />\nUSER: Email &amp; Privacy Policy Email &amp; Privacy Policy<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: Email &amp; Privacy Policy Email &amp; Privacy Policy<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: Email &amp; Privacy Policy<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: http://127.0.0.1/admin/mailing-list/1<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: http://127.0.0.1/admin/mailing-list/1<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.',1,2,2,2,1,'2026-03-07 21:03:17','2026-03-07 21:03:17',NULL),(21,'AI Escalation: support-chatsupport-chatsupport-chatsupp...','SOURCE: AI Support Chat\nUSER: Agency Pulse\n-----------------------------------\n\nUSER: what is the pro connector used for\n\nASSISTANT: Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?\n\nUSER: can you use it for anything else\n\nASSISTANT: To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.\n\nUSER: support-chatsupport-chatsupport-chatsupport-chat\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: support-chatsupport-chatsupport-chatsupport-chat\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.\n\nUSER: support-chatsupport-chatsupport-chatsupport-chat\n\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','SOURCE: AI Support Chat<br />\nUSER: Agency Pulse<br />\n-----------------------------------<br />\n<br />\nUSER: what is the pro connector used for<br />\n<br />\nASSISTANT: Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?<br />\n<br />\nUSER: can you use it for anything else<br />\n<br />\nASSISTANT: To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.<br />\n<br />\nUSER: support-chatsupport-chatsupport-chatsupport-chat<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: support-chatsupport-chatsupport-chatsupport-chat<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.<br />\n<br />\nUSER: support-chatsupport-chatsupport-chatsupport-chat<br />\n<br />\nASSISTANT: Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.',1,2,5,2,1,'2026-03-07 21:55:29','2026-03-07 21:55:29',NULL),(22,'Guest Support: oidrhsv w;kje th sd;k d ;skja vdgv da rg...','SOURCE: Support Form (Guest)\nNAME: dsgasfabdbadbd\nEMAIL: gwa.gjp+11@gmail.com\nPLUGIN: agency-pulse-invoice\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal\n-----------------------------------\n\noidrhsv w;kje th sd;k d ;skja vdgv da rgj','SOURCE: Support Form (Guest)<br />\nNAME: dsgasfabdbadbd<br />\nEMAIL: gwa.gjp+11@gmail.com<br />\nPLUGIN: agency-pulse-invoice<br />\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal<br />\n-----------------------------------<br />\n<br />\noidrhsv w;kje th sd;k d ;skja vdgv da rgj',1,2,2,2,1,'2026-03-07 23:41:42','2026-03-07 23:41:42',NULL),(23,'Guest Support: support-bubble-submitsupport-bubble-subm...','SOURCE: Support Form (Guest)\nNAME: support-bubble-submit\nEMAIL: gwa.gjp+12@gmail.com\nPLUGIN: agency-pulse-invoice\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal\n-----------------------------------\n\nsupport-bubble-submitsupport-bubble-submitsupport-bubble-submitsupport-bubble-submitsupport-bubble-submit','SOURCE: Support Form (Guest)<br />\nNAME: support-bubble-submit<br />\nEMAIL: gwa.gjp+12@gmail.com<br />\nPLUGIN: agency-pulse-invoice<br />\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal<br />\n-----------------------------------<br />\n<br />\nsupport-bubble-submitsupport-bubble-submitsupport-bubble-submitsupport-bubble-submitsupport-bubble-submit',1,2,2,2,1,'2026-03-07 23:54:12','2026-03-07 23:54:12',NULL),(24,'Guest Support: {\n    \"reply\": \"Thank you for contacting...','SOURCE: Support Form (Guest)\nNAME: gasfsdsd\nEMAIL: gwa.gjp+74@gmail.com\nPLUGIN: agency-pulse-invoice\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal\n-----------------------------------\n\n{\n    \"reply\": \"Thank you for contacting support. We\'ve created ticket #23 and will respond to gwa.gjp+12@gmail.com shortly.\",\n    \"conversation_id\": null,\n    \"escalated\": true,\n    \"freshly_escalated\": true\n}','SOURCE: Support Form (Guest)<br />\nNAME: gasfsdsd<br />\nEMAIL: gwa.gjp+74@gmail.com<br />\nPLUGIN: agency-pulse-invoice<br />\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal<br />\n-----------------------------------<br />\n<br />\n{<br />\n    &quot;reply&quot;: &quot;Thank you for contacting support. We&#039;ve created ticket #23 and will respond to gwa.gjp+12@gmail.com shortly.&quot;,<br />\n    &quot;conversation_id&quot;: null,<br />\n    &quot;escalated&quot;: true,<br />\n    &quot;freshly_escalated&quot;: true<br />\n}',1,2,2,2,1,'2026-03-07 23:59:28','2026-03-07 23:59:28',NULL),(25,'Guest Support: dz{\n    \"reply\": \"Thank you for contacti...','SOURCE: Support Form (Guest)\nNAME: xdfsg svsdf\nEMAIL: gwa.gjp+82@gmail.com\nPLUGIN: agency-pulse-invoice\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal\n-----------------------------------\n\ndz{\n    \"reply\": \"Thank you for contacting support. We\'ve created ticket #23 and will respond to gwa.gjp+12@gmail.com shortly.\",\n    \"conversation_id\": null,\n    \"escalated\": true,\n    \"freshly_escalated\": true\n}{\n    \"reply\": \"Thank you for contacting support. We\'ve created ticket #23 and will respond to gwa.gjp+12@gmail.com shortly.\",\n    \"conversation_id\": null,\n    \"escalated\": true,\n    \"freshly_escalated\": true\n}{\n    \"reply\": \"Thank you for contacting support. We\'ve created ticket #23 and will respond to gwa.gjp+12@gmail.com shortly.\",\n    \"conversation_id\": null,\n    \"escalated\": true,\n    \"freshly_escalated\": true\n}','SOURCE: Support Form (Guest)<br />\nNAME: xdfsg svsdf<br />\nEMAIL: gwa.gjp+82@gmail.com<br />\nPLUGIN: agency-pulse-invoice<br />\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal<br />\n-----------------------------------<br />\n<br />\ndz{<br />\n    &quot;reply&quot;: &quot;Thank you for contacting support. We&#039;ve created ticket #23 and will respond to gwa.gjp+12@gmail.com shortly.&quot;,<br />\n    &quot;conversation_id&quot;: null,<br />\n    &quot;escalated&quot;: true,<br />\n    &quot;freshly_escalated&quot;: true<br />\n}{<br />\n    &quot;reply&quot;: &quot;Thank you for contacting support. We&#039;ve created ticket #23 and will respond to gwa.gjp+12@gmail.com shortly.&quot;,<br />\n    &quot;conversation_id&quot;: null,<br />\n    &quot;escalated&quot;: true,<br />\n    &quot;freshly_escalated&quot;: true<br />\n}{<br />\n    &quot;reply&quot;: &quot;Thank you for contacting support. We&#039;ve created ticket #23 and will respond to gwa.gjp+12@gmail.com shortly.&quot;,<br />\n    &quot;conversation_id&quot;: null,<br />\n    &quot;escalated&quot;: true,<br />\n    &quot;freshly_escalated&quot;: true<br />\n}',1,2,2,2,1,'2026-03-08 00:10:30','2026-03-08 00:10:30',NULL),(26,'Guest Support: spatie-support-bubble__inputspatie-suppo...','SOURCE: Support Form (Guest)\nNAME: spatie-support-bubble__input\nEMAIL: gwa.gjp+83@gmail.com\nPLUGIN: agency-pulse-invoice\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal\n-----------------------------------\n\nspatie-support-bubble__inputspatie-support-bubble__inputspatie-support-bubble__inputspatie-support-bubble__input','SOURCE: Support Form (Guest)<br />\nNAME: spatie-support-bubble__input<br />\nEMAIL: gwa.gjp+83@gmail.com<br />\nPLUGIN: agency-pulse-invoice<br />\nPAGE: agency_pulse_invoice_page_agency_pulse_invoice_gateway_paypal<br />\n-----------------------------------<br />\n<br />\nspatie-support-bubble__inputspatie-support-bubble__inputspatie-support-bubble__inputspatie-support-bubble__input',1,2,2,2,1,'2026-03-08 00:17:43','2026-03-08 00:17:43',NULL),(27,'Chat from Guest','Customer: Guest (guest@example.com)\n\nConversation:\n--------------------------------------------------\n\n[2026-03-08 01:37:04] Guest:\ntery again you pos good luck times two\n\n[2026-03-08 01:37:32] AgencyPulseWP:\nDid you type that!\n\n',NULL,1,2,2,2,1,'2026-03-08 02:35:18','2026-03-08 02:35:18',NULL);

--
-- Table structure for table `laravelticket_audits`
--

CREATE TABLE `laravelticket_audits` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `operation` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int unsigned NOT NULL,
  `ticket_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laravelticket_audits`
--


--
-- Table structure for table `laravelticket_categories`
--

CREATE TABLE `laravelticket_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laravelticket_categories`
--

INSERT INTO `laravelticket_categories` VALUES (1,'Pro Connector','#000000'),(2,'Invoice Plugin','#000000'),(3,'Add-Ons','#000000');

--
-- Table structure for table `laravelticket_categories_users`
--

CREATE TABLE `laravelticket_categories_users` (
  `category_id` int unsigned NOT NULL,
  `user_id` int unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laravelticket_categories_users`
--

INSERT INTO `laravelticket_categories_users` VALUES (1,2);

--
-- Table structure for table `laravelticket_comments`
--

CREATE TABLE `laravelticket_comments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `html` longtext COLLATE utf8mb4_unicode_ci,
  `user_id` int unsigned NOT NULL,
  `ticket_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `laravelticket_comments_user_id_index` (`user_id`),
  KEY `laravelticket_comments_ticket_id_index` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laravelticket_comments`
--


--
-- Table structure for table `laravelticket_priorities`
--

CREATE TABLE `laravelticket_priorities` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laravelticket_priorities`
--

INSERT INTO `laravelticket_priorities` VALUES (1,'High','#000000'),(2,'Medium','#000000'),(3,'Low','#000000');

--
-- Table structure for table `laravelticket_settings`
--

CREATE TABLE `laravelticket_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `default` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `laravelticket_settings_slug_unique` (`slug`),
  UNIQUE KEY `laravelticket_settings_lang_unique` (`lang`),
  KEY `laravelticket_settings_lang_index` (`lang`),
  KEY `laravelticket_settings_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laravelticket_settings`
--

INSERT INTO `laravelticket_settings` VALUES (1,NULL,'main_route','tickets','tickets','2026-02-23 05:32:40','2026-02-23 05:32:40'),(2,NULL,'main_route_path','tickets','tickets','2026-02-23 05:32:40','2026-02-23 05:32:40'),(3,NULL,'admin_route','tickets-admin','tickets-admin','2026-02-23 05:32:40','2026-02-23 05:32:40'),(4,NULL,'admin_route_path','tickets-admin','tickets-admin','2026-02-23 05:32:40','2026-02-23 05:32:40'),(5,NULL,'master_template','helpdesk','helpdesk','2026-02-23 05:32:40','2026-02-23 05:32:40'),(6,NULL,'bootstrap_version','4','4','2026-02-23 05:32:40','2026-02-23 05:32:40'),(7,NULL,'email.template','laravelticket::emails.templates.laravelticket','laravelticket::emails.templates.laravelticket','2026-02-23 05:32:40','2026-02-23 05:32:40'),(8,NULL,'email.header','Ticket Update','Ticket Update','2026-02-23 05:32:40','2026-02-23 05:32:40'),(9,NULL,'email.signoff','Thank you for your patience!','Thank you for your patience!','2026-02-23 05:32:40','2026-02-23 05:32:40'),(10,NULL,'email.signature','Your friends','Your friends','2026-02-23 05:32:40','2026-02-23 05:32:40'),(11,NULL,'email.dashboard','My Dashboard','My Dashboard','2026-02-23 05:32:40','2026-02-23 05:32:40'),(12,NULL,'email.google_plus_link','#','#','2026-02-23 05:32:40','2026-02-23 05:32:40'),(13,NULL,'email.facebook_link','#','#','2026-02-23 05:32:40','2026-02-23 05:32:40'),(14,NULL,'email.twitter_link','#','#','2026-02-23 05:32:40','2026-02-23 05:32:40'),(15,NULL,'email.footer','Powered by LaravelTicket','Powered by LaravelTicket','2026-02-23 05:32:40','2026-02-23 05:32:40'),(16,NULL,'email.footer_link','https://github.com/binshops/laravel-ticket','https://github.com/binshops/laravel-ticket','2026-02-23 05:32:40','2026-02-23 05:32:40'),(17,NULL,'email.color_body_bg','#FFFFFF','#FFFFFF','2026-02-23 05:32:40','2026-02-23 05:32:40'),(18,NULL,'email.color_header_bg','#44B7B7','#44B7B7','2026-02-23 05:32:40','2026-02-23 05:32:40'),(19,NULL,'email.color_content_bg','#F46B45','#F46B45','2026-02-23 05:32:40','2026-02-23 05:32:40'),(20,NULL,'email.color_footer_bg','#414141','#414141','2026-02-23 05:32:40','2026-02-23 05:32:40'),(21,NULL,'email.color_button_bg','#AC4D2F','#AC4D2F','2026-02-23 05:32:40','2026-02-23 05:32:40'),(22,NULL,'default_status_id','1','1','2026-02-23 05:32:40','2026-02-23 05:32:40'),(23,NULL,'default_close_status_id','0','0','2026-02-23 05:32:40','2026-02-23 05:32:40'),(24,NULL,'default_reopen_status_id','0','0','2026-02-23 05:32:40','2026-02-23 05:32:40'),(25,NULL,'paginate_items','10','10','2026-02-23 05:32:40','2026-02-23 05:32:40'),(26,NULL,'length_menu','a:2:{i:0;a:3:{i:0;i:10;i:1;i:50;i:2;i:100;}i:1;a:3:{i:0;i:10;i:1;i:50;i:2;i:100;}}','a:2:{i:0;a:3:{i:0;i:10;i:1;i:50;i:2;i:100;}i:1;a:3:{i:0;i:10;i:1;i:50;i:2;i:100;}}','2026-02-23 05:32:40','2026-02-23 05:32:40'),(27,NULL,'status_notification','0','1','2026-02-23 05:32:40','2026-02-23 05:32:40'),(28,NULL,'comment_notification','0','1','2026-02-23 05:32:40','2026-02-23 05:32:40'),(29,NULL,'queue_emails','0','0','2026-02-23 05:32:40','2026-02-23 05:32:40'),(30,NULL,'assigned_notification','0','1','2026-02-23 05:32:40','2026-02-23 05:32:40'),(31,NULL,'agent_restrict','0','0','2026-02-23 05:32:40','2026-02-23 05:32:40'),(32,NULL,'close_ticket_perm','a:3:{s:5:\"owner\";b:1;s:5:\"agent\";b:1;s:5:\"admin\";b:1;}','a:3:{s:5:\"owner\";b:1;s:5:\"agent\";b:1;s:5:\"admin\";b:1;}','2026-02-23 05:32:40','2026-02-23 05:32:40'),(33,NULL,'reopen_ticket_perm','a:3:{s:5:\"owner\";b:1;s:5:\"agent\";b:1;s:5:\"admin\";b:1;}','a:3:{s:5:\"owner\";b:1;s:5:\"agent\";b:1;s:5:\"admin\";b:1;}','2026-02-23 05:32:40','2026-02-23 05:32:40'),(34,NULL,'delete_modal_type','builtin','builtin','2026-02-23 05:32:40','2026-02-23 05:32:40'),(35,NULL,'editor_enabled','1','1','2026-02-23 05:32:40','2026-02-23 05:32:40'),(36,NULL,'include_font_awesome','1','1','2026-02-23 05:32:40','2026-02-23 05:32:40'),(37,NULL,'summernote_locale','en','en','2026-02-23 05:32:40','2026-02-23 05:32:40'),(38,NULL,'editor_html_highlighter','1','1','2026-02-23 05:32:40','2026-02-23 05:32:40'),(39,NULL,'codemirror_theme','monokai','monokai','2026-02-23 05:32:40','2026-02-23 05:32:40'),(40,NULL,'summernote_options_json_file','vendor/binshops/laravel-ticket/src/JSON/summernote_init.json','vendor/binshops/laravel-ticket/src/JSON/summernote_init.json','2026-02-23 05:32:40','2026-02-23 05:32:40'),(41,NULL,'purifier_config','a:3:{s:15:\"HTML.SafeIframe\";s:4:\"true\";s:20:\"URI.SafeIframeRegexp\";s:72:\"%^(http://|https://|//)(www.youtube.com/embed/|player.vimeo.com/video/)%\";s:18:\"URI.AllowedSchemes\";a:5:{s:4:\"data\";b:1;s:4:\"http\";b:1;s:5:\"https\";b:1;s:6:\"mailto\";b:1;s:3:\"ftp\";b:1;}}','a:3:{s:15:\"HTML.SafeIframe\";s:4:\"true\";s:20:\"URI.SafeIframeRegexp\";s:72:\"%^(http://|https://|//)(www.youtube.com/embed/|player.vimeo.com/video/)%\";s:18:\"URI.AllowedSchemes\";a:5:{s:4:\"data\";b:1;s:4:\"http\";b:1;s:5:\"https\";b:1;s:6:\"mailto\";b:1;s:3:\"ftp\";b:1;}}','2026-02-23 05:32:40','2026-02-23 05:32:40'),(42,NULL,'routes','/var/www/html/vendor/binshops/laravel-ticket/src/routes.php','/var/www/html/vendor/binshops/laravel-ticket/src/routes.php','2026-02-23 05:32:40','2026-02-23 05:32:40');

--
-- Table structure for table `laravelticket_statuses`
--

CREATE TABLE `laravelticket_statuses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laravelticket_statuses`
--

INSERT INTO `laravelticket_statuses` VALUES (1,'New','#000000'),(2,'Accepted','#000000'),(3,'Answered','#000000');

--
-- Table structure for table `link_group_items`
--

CREATE TABLE `link_group_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `link_group_id` bigint unsigned NOT NULL,
  `linkable_id` bigint unsigned NOT NULL,
  `linkable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `link_group_items_link_group_id_linkable_id_linkable_type_unique` (`link_group_id`,`linkable_id`,`linkable_type`),
  CONSTRAINT `link_group_items_link_group_id_foreign` FOREIGN KEY (`link_group_id`) REFERENCES `link_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `link_group_items`
--


--
-- Table structure for table `link_groups`
--

CREATE TABLE `link_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `link_type_id` bigint unsigned NOT NULL,
  `property_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `link_groups_link_type_id_foreign` (`link_type_id`),
  KEY `link_groups_property_id_foreign` (`property_id`),
  CONSTRAINT `link_groups_link_type_id_foreign` FOREIGN KEY (`link_type_id`) REFERENCES `link_types` (`id`),
  CONSTRAINT `link_groups_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `link_groups`
--


--
-- Table structure for table `link_types`
--

CREATE TABLE `link_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `link_types_name_unique` (`name`),
  UNIQUE KEY `link_types_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `link_types`
--


--
-- Table structure for table `mailing_list_emails`
--

CREATE TABLE `mailing_list_emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mailing_list_id` bigint unsigned DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscribed` tinyint DEFAULT '1',
  `data` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mailing_list_emails_mailing_list_id_foreign` (`mailing_list_id`),
  CONSTRAINT `mailing_list_emails_mailing_list_id_foreign` FOREIGN KEY (`mailing_list_id`) REFERENCES `mailing_lists` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mailing_list_emails`
--

INSERT INTO `mailing_list_emails` VALUES (2,'gwa.gjp@gmail.com',1,'Email','& Privacy Policy','Docs AI Chat',0,'null','2026-03-07 21:01:44','2026-03-07 21:01:44'),(3,'gwa.gjp+12@gmail.com',2,'support-bubble-submit',NULL,'Guest Support Ticket',0,'null','2026-03-07 23:54:12','2026-03-07 23:54:12'),(4,'gwa.gjp+74@gmail.com',2,'gasfsdsd',NULL,'Guest Support Ticket',0,'null','2026-03-07 23:59:28','2026-03-07 23:59:28'),(5,'gwa.gjp+82@gmail.com',2,'xdfsg','svsdf','Guest Support Ticket',0,'null','2026-03-08 00:10:30','2026-03-08 00:10:30'),(6,'gwa.gjp+83@gmail.com',2,'spatie-support-bubble__input',NULL,'Guest Support Ticket',0,'null','2026-03-08 00:17:43','2026-03-08 00:17:43');

--
-- Table structure for table `mailing_lists`
--

CREATE TABLE `mailing_lists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mailing_lists`
--

INSERT INTO `mailing_lists` VALUES (1,'AgencyPulseWP','null','2026-03-07 19:37:55','2026-03-07 19:37:55'),(2,'Guest Support','null','2026-03-07 23:43:03','2026-03-07 23:43:03');

--
-- Table structure for table `master_product_variants`
--

CREATE TABLE `master_product_variants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `master_product_id` bigint unsigned NOT NULL,
  `sku` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `price` decimal(15,4) DEFAULT NULL,
  `original_price` decimal(15,4) DEFAULT NULL,
  `stock` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `weight` decimal(15,4) DEFAULT NULL,
  `height` decimal(15,4) DEFAULT NULL,
  `width` decimal(15,4) DEFAULT NULL,
  `length` decimal(15,4) DEFAULT NULL,
  `units_sold` int unsigned NOT NULL DEFAULT '0',
  `last_sale_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_category_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `master_product_variants`
--


--
-- Table structure for table `master_products`
--

CREATE TABLE `master_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(15,4) DEFAULT NULL,
  `original_price` decimal(15,4) DEFAULT NULL,
  `excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `weight` decimal(15,4) DEFAULT NULL,
  `height` decimal(15,4) DEFAULT NULL,
  `width` decimal(15,4) DEFAULT NULL,
  `length` decimal(15,4) DEFAULT NULL,
  `ext_title` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tax_category_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `master_products`
--


--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  `collection_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int unsigned NOT NULL,
  `manipulations` json NOT NULL,
  `custom_properties` json NOT NULL,
  `responsive_images` json NOT NULL,
  `order_column` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `conversions_disk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generated_conversions` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_unique_uuid` (`uuid`),
  KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--


--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `conversation_id` bigint unsigned NOT NULL,
  `role` enum('user','assistant') COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `messages_conversation_id_foreign` (`conversation_id`),
  CONSTRAINT `messages_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` VALUES (1,35,'user','zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz','2026-03-07 20:20:42','2026-03-07 20:20:42'),(2,35,'assistant','Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?','2026-03-07 20:20:42','2026-03-07 20:20:42'),(3,35,'user','zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz','2026-03-07 20:20:45','2026-03-07 20:20:45'),(4,35,'assistant','To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.','2026-03-07 20:20:45','2026-03-07 20:20:45'),(5,35,'user','zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz','2026-03-07 20:20:55','2026-03-07 20:20:55'),(6,35,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 20:20:55','2026-03-07 20:20:55'),(7,35,'user','zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz','2026-03-07 20:20:58','2026-03-07 20:20:58'),(8,35,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 20:20:58','2026-03-07 20:20:58'),(9,35,'user','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2026-03-07 20:55:39','2026-03-07 20:55:39'),(10,35,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 20:55:39','2026-03-07 20:55:39'),(11,35,'user','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2026-03-07 20:55:41','2026-03-07 20:55:41'),(12,35,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 20:55:42','2026-03-07 20:55:42'),(13,35,'user','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2026-03-07 20:55:44','2026-03-07 20:55:44'),(14,35,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 20:55:44','2026-03-07 20:55:44'),(15,35,'assistant','(System: Ticket #19 created.)','2026-03-07 20:55:44','2026-03-07 20:55:44'),(16,35,'user','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2026-03-07 20:56:08','2026-03-07 20:56:08'),(17,35,'assistant','We have previously created a support ticket for you and you will hear from us shortly.','2026-03-07 20:56:08','2026-03-07 20:56:08'),(18,36,'user','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2026-03-07 20:56:36','2026-03-07 20:56:36'),(19,36,'assistant','Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?','2026-03-07 20:56:36','2026-03-07 20:56:36'),(20,36,'user','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\naaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\naaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2026-03-07 20:56:46','2026-03-07 20:56:46'),(21,36,'assistant','To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.','2026-03-07 20:56:46','2026-03-07 20:56:46'),(22,36,'user','Email & Privacy Policy Email & Privacy Policy','2026-03-07 21:01:14','2026-03-07 21:01:14'),(23,36,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 21:01:14','2026-03-07 21:01:14'),(24,36,'user','Email & Privacy Policy Email & Privacy Policy','2026-03-07 21:01:18','2026-03-07 21:01:18'),(25,36,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 21:01:18','2026-03-07 21:01:18'),(26,36,'user','Email & Privacy Policy','2026-03-07 21:01:44','2026-03-07 21:01:44'),(27,36,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 21:01:44','2026-03-07 21:01:44'),(28,36,'user','http://127.0.0.1/admin/mailing-list/1','2026-03-07 21:03:14','2026-03-07 21:03:14'),(29,36,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 21:03:14','2026-03-07 21:03:14'),(30,36,'user','http://127.0.0.1/admin/mailing-list/1','2026-03-07 21:03:17','2026-03-07 21:03:17'),(31,36,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 21:03:17','2026-03-07 21:03:17'),(32,36,'assistant','(System: Ticket #20 created.)','2026-03-07 21:03:17','2026-03-07 21:03:17'),(33,37,'user','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2026-03-07 21:08:05','2026-03-07 21:08:05'),(34,37,'assistant','Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?','2026-03-07 21:08:05','2026-03-07 21:08:05'),(35,37,'user','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2026-03-07 21:08:08','2026-03-07 21:08:08'),(36,37,'assistant','To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.','2026-03-07 21:08:08','2026-03-07 21:08:08'),(37,38,'user','what is the pro connector used for','2026-03-07 21:54:15','2026-03-07 21:54:15'),(38,38,'assistant','Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?','2026-03-07 21:54:15','2026-03-07 21:54:15'),(39,38,'user','can you use it for anything else','2026-03-07 21:55:04','2026-03-07 21:55:04'),(40,38,'assistant','To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.','2026-03-07 21:55:04','2026-03-07 21:55:04'),(41,38,'user','support-chatsupport-chatsupport-chatsupport-chat','2026-03-07 21:55:21','2026-03-07 21:55:21'),(42,38,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 21:55:21','2026-03-07 21:55:21'),(43,38,'user','support-chatsupport-chatsupport-chatsupport-chat','2026-03-07 21:55:26','2026-03-07 21:55:26'),(44,38,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 21:55:26','2026-03-07 21:55:26'),(45,38,'user','support-chatsupport-chatsupport-chatsupport-chat','2026-03-07 21:55:29','2026-03-07 21:55:29'),(46,38,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-07 21:55:29','2026-03-07 21:55:29'),(47,38,'assistant','(System: Ticket #21 created.)','2026-03-07 21:55:29','2026-03-07 21:55:29'),(48,39,'user','support-chatsupport-chatsupport-chatsupport-chatsupport-chatsupport-chatsupport-chatsupport-chatsupport-chatsupport-chatsupport-chatsupport-chat','2026-03-07 21:57:09','2026-03-07 21:57:09'),(49,39,'assistant','Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?','2026-03-07 21:57:09','2026-03-07 21:57:09'),(50,40,'user','dslkjn kjsf  ksjbdgkf  i ghwrh ewr','2026-03-07 23:22:50','2026-03-07 23:22:50'),(51,40,'assistant','Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?','2026-03-07 23:22:50','2026-03-07 23:22:50'),(52,41,'user','is this a separate plugin','2026-03-08 00:24:33','2026-03-08 00:24:33'),(53,41,'assistant','Sure! I can help with that. This plugin lets you create and send professional invoices directly from WordPress. What specifically would you like to know?','2026-03-08 00:24:33','2026-03-08 00:24:33'),(54,41,'user','{!! __(\'support-bubble::support-bubble.intro_guest\') !!}','2026-03-08 00:25:31','2026-03-08 00:25:31'),(55,41,'assistant','To configure the invoice template, go to **Agency Pulse → Settings → Invoice Template**. You can set your logo, colour scheme, and footer text there.','2026-03-08 00:25:31','2026-03-08 00:25:31'),(56,41,'user','{!! __(\'support-bubble::support-bubble.intro_guest\') !!}','2026-03-08 00:25:34','2026-03-08 00:25:34'),(57,41,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-08 00:25:34','2026-03-08 00:25:34'),(58,41,'user','what is this one for','2026-03-08 01:10:36','2026-03-08 01:10:36'),(59,41,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-08 01:10:36','2026-03-08 01:10:36'),(60,41,'user','what are you today not romorrow','2026-03-08 01:13:48','2026-03-08 01:13:48'),(61,41,'assistant','Great question. Tax rates are managed under **Agency Pulse → Tax Rates**. You can define multiple rates and assign them per line item or globally.','2026-03-08 01:13:48','2026-03-08 01:13:48');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2016_11_24_104017_create_countries_table',1),(4,'2016_11_24_104459_create_provinces_table',1),(5,'2016_12_03_110323_create_addresses_table',1),(6,'2016_12_04_104214_create_persons_table',1),(7,'2016_12_04_191141_create_organizations_table',1),(8,'2016_12_18_113707_extend_users_table',1),(9,'2016_12_18_121118_create_profiles_table',1),(10,'2017_07_24_194147_create_customers_table',1),(11,'2017_09_26_145245_create_customer_addresses_table',1),(12,'2017_10_07_133259_create_products_table',1),(13,'2017_10_28_111947_create_carts_table',1),(14,'2017_10_29_224033_create_cart_items_table',1),(15,'2017_11_27_131854_create_billpayers_table',1),(16,'2017_11_27_131855_create_orders_table',1),(17,'2017_11_27_145105_create_order_items_table',1),(18,'2018_05_12_100622_create_media_table',1),(19,'2018_08_24_160805_create_taxonomies_table',1),(20,'2018_08_24_165408_create_taxons_table',1),(21,'2018_10_15_224808_add_cart_state',1),(22,'2018_11_01_181324_add_last_purchase_date_to_customer_table',1),(23,'2018_11_04_211505_create_model_taxons_table',1),(24,'2018_11_10_204207_add_sales_attributes_to_products',1),(25,'2018_12_08_111450_create_properties_table',1),(26,'2018_12_08_112321_create_property_values_table',1),(27,'2018_12_08_124157_create_model_property_values_table',1),(28,'2019_02_16_082635_create_shipments_table',1),(29,'2019_04_08_000000_add_stock_field_to_products_table',1),(30,'2019_06_29_215847_convert_user_type_to_varchar',1),(31,'2019_07_30_040905_create_channels_table',1),(32,'2019_08_10_175251_streamline_provinces_table',1),(33,'2019_08_19_000000_create_failed_jobs_table',1),(34,'2019_12_14_000001_create_personal_access_tokens_table',1),(35,'2019_12_17_093757_create_payment_methods_table',1),(36,'2019_12_17_094730_create_payments_table',1),(37,'2020_10_02_230537_upgrade_media_table_to_v8',1),(38,'2020_12_08_150233_upgrade_media_table_to_v9',1),(39,'2020_12_18_140413_create_invitations_table',1),(40,'2020_12_29_124643_add_unique_index_to_order_numbers',1),(41,'2021_02_28_161404_add_status_message_to_payments_table',1),(42,'2021_03_21_102944_create_payment_history_table',1),(43,'2021_05_20_174749_add_remote_id_to_payments_table',1),(44,'2021_05_27_113135_create_adjustments_table',1),(45,'2022_02_11_181838_create_link_types_table',1),(46,'2022_02_16_092027_create_link_group_tables',1),(47,'2022_02_28_160230_add_original_price_field_to_products_table',1),(48,'2022_02_28_163548_add_dimensions_to_products_table',1),(49,'2022_02_28_220149_create_carriers_table',1),(50,'2022_02_28_221239_add_carrier_id_to_shipments_table',1),(51,'2022_03_15_170852_extend_customers_table_with_ltv_currency_and_timezone',1),(52,'2022_03_26_144125_create_shipping_methods_table',1),(53,'2022_06_13_090450_create_master_products_table',1),(54,'2022_06_13_090835_create_master_product_variants_table',1),(55,'2022_07_05_154855_add_channel_id_to_orders_table',1),(56,'2022_11_09_141850_add_active_flag_to_shipping_methods_table',1),(57,'2023_01_12_123641_add_cart_item_configuration',1),(58,'2023_01_19_121154_add_order_item_configuration',1),(59,'2023_01_25_114755_add_description_to_variants_table',1),(60,'2023_02_20_094957_add_reference_number_to_shipments_table',1),(61,'2023_02_20_104644_create_shippables_table',1),(62,'2023_02_20_145123_add_fulfillment_status_to_orders',1),(63,'2023_02_20_153027_add_fulfillment_status_to_order_items',1),(64,'2023_02_22_180720_add_language_and_ordered_at_fields_to_the_orders_table',1),(65,'2023_02_22_191444_add_shipping_method_and_customer_to_the_orders_table',1),(66,'2023_02_26_090848_create_zone_tables',1),(67,'2023_02_27_183045_add_zone_to_shipping_methods_table',1),(68,'2023_03_06_203615_add_payable_remote_id_to_the_orders_table',1),(69,'2023_03_06_205137_add_subtype_to_payments_table',1),(70,'2023_03_12_093217_add_zones_foreign_key_to_shipping_methods_table',1),(71,'2023_03_17_150427_create_tax_categories_table',1),(72,'2023_03_25_201501_add_tax_category_id_to_products',1),(73,'2023_03_26_085056_create_tax_rates_table',1),(74,'2023_03_28_195634_add_extend_the_shipments_table',1),(75,'2023_04_08_104809_create_languages_table',1),(76,'2018_02_26_213828_create_gears_tables',2),(77,'2026_02_12_014830_add_is_admin_to_users_table',3),(78,'2017_05_31_113121_create_acl_tables',4),(79,'2017_06_12_073443_create_appshell_permissions',4),(80,'2017_10_19_192447_create_vanilo_permissions',4),(81,'2018_05_13_105644_create_media_permissions',4),(82,'2018_05_27_210939_create_settings_permissions',4),(83,'2018_09_22_092746_create_category_permissions',4),(84,'2018_12_09_193651_create_property_permissions',4),(85,'2019_07_30_071633_create_channel_permissions',4),(86,'2020_05_24_204911_fix_accidental_taxa_named_permissions',4),(87,'2020_10_25_101244_update_permissions_to_appshell_v2',4),(88,'2020_12_08_162243_add_payment_method_permissions',4),(89,'2020_12_19_013824_add_invitation_permissions',4),(90,'2022_03_12_165912_add_customer_id_to_users_table',4),(91,'2023_01_25_133735_add_shipping_method_permissions',4),(92,'2023_01_25_161641_add_carrier_permissions',4),(93,'2023_03_10_110949_add_zone_permissions',4),(94,'2019_05_03_000001_create_customer_columns',5),(95,'2019_05_03_000002_create_subscriptions_table',5),(96,'2019_05_03_000003_create_subscription_items_table',5),(97,'2026_02_11_000001_add_sales_count_to_products_table',6),(98,'2026_02_11_000002_create_payments_table',7),(99,'2026_02_11_000003_add_subscription_and_expiry_to_payments_table',7),(100,'2026_02_11_000004_create_product_user_table',8),(101,'2026_02_12_000005_update_payments_table_add_fields',9),(102,'2026_02_12_000006_add_missing_fields_to_payments_table',9),(103,'2026_02_12_000007_safe_payments_table_migration',9),(104,'2026_02_12_000008_add_payment_method_id_to_payments_table',10),(105,'2026_02_12_000001_add_people_permissions',11),(106,'2026_02_12_000002_grant_list_users_to_admin_users',12),(107,'2026_02_12_000003_add_plugin_key_to_users',12),(108,'2026_02_12_000004_populate_plugin_keys',12),(109,'2026_02_12_000005_add_plugin_revoked_at_to_users',13),(110,'2026_02_12_000006_add_plugin_auth_fields_to_users',14),(111,'2026_02_12_000007_add_plugin_last_connected_at_to_users',15),(112,'2026_02_13_000001_add_plugin_domain_hash_to_users',16),(113,'2026_02_13_000002_add_domain_reset_fields_to_users',16),(114,'2026_02_14_000001_create_gifted_products_table',17),(115,'2026_02_15_000000_add_user_keypair_columns',18),(116,'2026_02_16_000000_change_plugin_key_to_text',19),(117,'2026_02_17_183303_add_plugin_key_hash_to_users_table',20),(118,'2026_02_20_000001_create_plugin_coupons_table',21),(119,'2026_02_20_000002_create_plugin_email_missions_table',22),(120,'2026_02_23_024322_create_jobs_table',23),(121,'2015_07_22_115516_create_laravelticket_tables',24),(122,'2015_07_22_123254_alter_users_table',24),(123,'2015_09_29_123456_add_completed_at_column_to_laravelticket_table',24),(124,'2015_10_08_123457_create_settings_table',24),(125,'2016_01_15_002617_add_htmlcontent_to_laravelticket_and_comments',24),(126,'2016_01_15_040207_enlarge_settings_columns',24),(127,'2016_01_15_120557_add_indexes',24),(128,'2026_02_23_182449_create_checkout_tax_rates_table',25),(129,'2026_02_23_183013_add_tax_fields_to_payments_table',26),(130,'2026_02_23_222550_create_conversations_table',27),(131,'2026_02_23_222605_create_messages_table',27),(132,'2026_02_24_014627_create_conversations_table',28),(133,'2026_02_24_014628_create_messages_table',28),(134,'2026_02_27_000000_create_plugin_downloads_table',29),(135,'2026_03_07_174845_add_name_to_conversations_table',30),(136,'2021_05_03_170948_create_mailing_lists_table',31),(137,'2021_05_03_171125_create_mailing_list_emails_table',31),(138,'2026_03_07_175000_create_chats_table',32),(139,'2026_03_07_175001_create_chat_messages_table',32),(140,'2026_03_07_175002_add_is_available_to_users_table',32);

--
-- Table structure for table `model_permissions`
--

CREATE TABLE `model_permissions` (
  `permission_id` int unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_permissions_model_type_model_id_index` (`model_type`,`model_id`),
  CONSTRAINT `model_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_permissions`
--

INSERT INTO `model_permissions` VALUES (121,'App\\Models\\User',2);

--
-- Table structure for table `model_property_values`
--

CREATE TABLE `model_property_values` (
  `property_value_id` int unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`property_value_id`,`model_id`,`model_type`),
  KEY `model_property_values_model_type_model_id_index` (`model_type`,`model_id`),
  CONSTRAINT `model_property_values_property_value_id_foreign` FOREIGN KEY (`property_value_id`) REFERENCES `property_values` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_property_values`
--


--
-- Table structure for table `model_roles`
--

CREATE TABLE `model_roles` (
  `role_id` int unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_roles_model_type_model_id_index` (`model_type`,`model_id`),
  CONSTRAINT `model_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_roles`
--

INSERT INTO `model_roles` VALUES (1,'App\\Models\\User',2),(2,'App\\Models\\User',2);

--
-- Table structure for table `model_taxons`
--

CREATE TABLE `model_taxons` (
  `taxon_id` int unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`taxon_id`,`model_id`,`model_type`),
  KEY `model_taxons_model_type_model_id_index` (`model_type`,`model_id`),
  CONSTRAINT `model_taxons_taxon_id_foreign` FOREIGN KEY (`taxon_id`) REFERENCES `taxons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_taxons`
--

INSERT INTO `model_taxons` VALUES (1,'Vanilo\\Foundation\\Models\\Product',1,NULL,NULL);

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `product_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The product name at the moment of buying',
  `fulfillment_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unfulfilled',
  `quantity` int NOT NULL,
  `price` decimal(15,4) NOT NULL,
  `configuration` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` VALUES (2,2,'Vanilo\\Foundation\\Models\\Product',1,'AgencyPulseWP Invoice Enhancements Plugin','unfulfilled',1,7.0000,'[]','2026-02-12 20:18:47','2026-02-12 20:18:47'),(4,4,'Vanilo\\Foundation\\Models\\Product',1,'AgencyPulseWP Invoice Enhancements Plugin','unfulfilled',1,7.0000,'[]','2026-02-23 03:37:09','2026-02-23 03:37:09'),(5,5,'Vanilo\\Foundation\\Models\\Product',4,'AgencyPulseWP Line Item Tax Rates','unfulfilled',1,7.0000,'[]','2026-02-23 20:59:24','2026-02-23 20:59:24'),(6,6,'Vanilo\\Foundation\\Models\\Product',3,'AgencyPulseWP Products Plugin','unfulfilled',1,15.0000,'[]','2026-02-23 21:13:28','2026-02-23 21:13:28'),(7,7,'Vanilo\\Foundation\\Models\\Product',2,'AgencyPulseWP Client Portal Plugin','unfulfilled',1,15.0000,'[]','2026-02-23 21:20:55','2026-02-23 21:20:55');

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fulfillment_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unfulfilled',
  `language` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The two letter ISO 639-1 language code',
  `user_id` bigint unsigned DEFAULT NULL,
  `billpayer_id` int unsigned DEFAULT NULL,
  `customer_id` int unsigned DEFAULT NULL,
  `shipping_address_id` int unsigned DEFAULT NULL,
  `shipping_method_id` bigint unsigned DEFAULT NULL,
  `channel_id` int unsigned DEFAULT NULL,
  `payable_remote_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The remote id used by the payment subsystem',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ordered_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_number_unique` (`number`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_billpayer_id_foreign` (`billpayer_id`),
  KEY `orders_shipping_address_id_foreign` (`shipping_address_id`),
  KEY `orders_customer_id_foreign` (`customer_id`),
  KEY `orders_shipping_method_id_foreign` (`shipping_method_id`),
  CONSTRAINT `orders_billpayer_id_foreign` FOREIGN KEY (`billpayer_id`) REFERENCES `billpayers` (`id`),
  CONSTRAINT `orders_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  CONSTRAINT `orders_shipping_address_id_foreign` FOREIGN KEY (`shipping_address_id`) REFERENCES `addresses` (`id`),
  CONSTRAINT `orders_shipping_method_id_foreign` FOREIGN KEY (`shipping_method_id`) REFERENCES `shipping_methods` (`id`),
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (2,'698e35a711fbd','completed','unfulfilled',NULL,4,3,NULL,NULL,NULL,NULL,NULL,'Stripe Transaction: 11','2026-02-12 20:18:47','2026-02-12 20:18:47','2026-02-12 20:18:47',NULL),(4,'699bcb659f748','completed','unfulfilled',NULL,5,4,NULL,NULL,NULL,NULL,NULL,'Stripe Transaction: 12','2026-02-23 03:37:09','2026-02-23 03:37:09','2026-02-23 03:37:09',NULL),(5,'699cbfacbedd4','completed','unfulfilled',NULL,4,5,NULL,NULL,NULL,NULL,NULL,'Stripe Transaction: 13','2026-02-23 20:59:24','2026-02-23 20:59:24','2026-02-23 20:59:24',NULL),(6,'699cc2f83a847','completed','unfulfilled',NULL,4,6,NULL,NULL,NULL,NULL,NULL,'Stripe Transaction: 14','2026-02-23 21:13:28','2026-02-23 21:13:28','2026-02-23 21:13:28',NULL),(7,'699cc4b7daab1','completed','unfulfilled',NULL,4,7,NULL,NULL,NULL,NULL,NULL,'Stripe Transaction: 15','2026-02-23 21:20:55','2026-02-23 21:20:55','2026-02-23 21:20:55',NULL);

--
-- Table structure for table `organizations`
--

CREATE TABLE `organizations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_nr` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tax/VAT Identification Number',
  `registration_nr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Company/Trade Registration Number',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(22) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organizations`
--


--
-- Table structure for table `payment_history`
--

CREATE TABLE `payment_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` bigint NOT NULL,
  `old_status` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_status` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `native_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_amount` decimal(15,4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_history`
--


--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `gateway` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `configuration` json NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `transaction_count` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` VALUES (1,'stripe',NULL,'stripe','{}',1,1,NULL,NULL,NULL);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'list products','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(2,'create products','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(3,'view products','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(4,'edit products','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(5,'delete products','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(6,'list orders','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(7,'create orders','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(8,'view orders','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(9,'edit orders','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(10,'delete orders','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(11,'list media','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(12,'create media','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(13,'view media','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(14,'edit media','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(15,'delete media','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(16,'list taxonomies','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(17,'create taxonomies','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(18,'view taxonomies','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(19,'edit taxonomies','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(20,'delete taxonomies','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(21,'list taxa','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(22,'create taxa','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(23,'view taxa','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(24,'edit taxa','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(25,'delete taxa','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(26,'list properties','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(27,'create properties','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(28,'view properties','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(29,'edit properties','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(30,'delete properties','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(31,'list propertyvalues','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(32,'create propertyvalues','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(33,'view propertyvalues','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(34,'edit propertyvalues','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(35,'delete propertyvalues','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(36,'list channels','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(37,'create channels','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(38,'view channels','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(39,'edit channels','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(40,'delete channels','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(41,'list payment-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(42,'create payment-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(43,'view payment-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(44,'edit payment-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(45,'delete payment-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(46,'list shipping-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(47,'create shipping-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(48,'view shipping-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(49,'edit shipping-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(50,'delete shipping-methods','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(51,'list carriers','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(52,'create carriers','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(53,'view carriers','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(54,'edit carriers','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(55,'delete carriers','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(56,'list zones','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(57,'create zones','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(58,'view zones','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(59,'edit zones','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(60,'delete zones','web','2026-02-12 12:18:46','2026-02-12 12:18:46'),(61,'list products','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(62,'create products','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(63,'view products','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(64,'edit products','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(65,'delete products','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(66,'list orders','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(67,'create orders','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(68,'view orders','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(69,'edit orders','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(70,'delete orders','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(71,'list media','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(72,'create media','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(73,'view media','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(74,'edit media','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(75,'delete media','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(76,'list taxonomies','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(77,'create taxonomies','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(78,'view taxonomies','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(79,'edit taxonomies','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(80,'delete taxonomies','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(81,'list taxa','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(82,'create taxa','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(83,'view taxa','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(84,'edit taxa','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(85,'delete taxa','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(86,'list properties','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(87,'create properties','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(88,'view properties','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(89,'edit properties','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(90,'delete properties','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(91,'list propertyvalues','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(92,'create propertyvalues','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(93,'view propertyvalues','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(94,'edit propertyvalues','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(95,'delete propertyvalues','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(96,'list channels','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(97,'create channels','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(98,'view channels','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(99,'edit channels','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(100,'delete channels','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(101,'list payment-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(102,'create payment-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(103,'view payment-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(104,'edit payment-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(105,'delete payment-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(106,'list shipping-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(107,'create shipping-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(108,'view shipping-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(109,'edit shipping-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(110,'delete shipping-methods','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(111,'list carriers','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(112,'create carriers','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(113,'view carriers','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(114,'edit carriers','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(115,'delete carriers','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(116,'list zones','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(117,'create zones','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(118,'view zones','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(119,'edit zones','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(120,'delete zones','admin','2026-02-12 12:27:56','2026-02-12 12:27:56'),(121,'list users','web','2026-02-12 22:37:04','2026-02-12 22:37:04'),(122,'create users','web','2026-02-12 22:37:04','2026-02-12 22:37:04'),(123,'view users','web','2026-02-12 22:37:04','2026-02-12 22:37:04'),(124,'edit users','web','2026-02-12 22:37:04','2026-02-12 22:37:04'),(125,'delete users','web','2026-02-12 22:37:04','2026-02-12 22:37:04');

--
-- Table structure for table `persons`
--

CREATE TABLE `persons` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'First name',
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Last Name',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(22) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `gender` enum('','m','f') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nin` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'National Identification Number',
  `nameorder` enum('western','eastern') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'western' COMMENT 'western: First Last, eastern: Last First',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `persons`
--


--
-- Table structure for table `plugin_coupons`
--

CREATE TABLE `plugin_coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('percentage','fixed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'percentage',
  `value` decimal(15,2) NOT NULL,
  `starts_at` datetime DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  `max_uses` int DEFAULT NULL,
  `use_count` int NOT NULL DEFAULT '0',
  `product_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plugin_coupons_user_id_code_unique` (`user_id`,`code`),
  KEY `plugin_coupons_code_index` (`code`),
  KEY `plugin_coupons_product_id_index` (`product_id`),
  KEY `plugin_coupons_client_id_index` (`client_id`),
  CONSTRAINT `plugin_coupons_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plugin_coupons`
--

INSERT INTO `plugin_coupons` VALUES (1,4,'SUMMER2024','percentage',50.00,'2026-02-18 00:00:00','2026-02-27 00:00:00',NULL,3,NULL,NULL,1,'2026-02-20 15:02:17','2026-02-20 22:47:39'),(2,4,'CLIENT SWE','fixed',33.00,NULL,NULL,5,0,NULL,'77',1,'2026-02-20 16:15:53','2026-02-20 16:15:53');

--
-- Table structure for table `plugin_downloads`
--

CREATE TABLE `plugin_downloads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `downloaded_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plugin_downloads_user_id_index` (`user_id`),
  KEY `plugin_downloads_user_id_sku_index` (`user_id`,`sku`),
  KEY `plugin_downloads_downloaded_at_index` (`downloaded_at`),
  CONSTRAINT `plugin_downloads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plugin_downloads`
--

INSERT INTO `plugin_downloads` VALUES (3,5,'apwp-ie','apwp-ie.zip','192.168.16.2','WordPress/6.9.1; https://localhost','2026-02-28 07:47:56','2026-02-28 07:47:56','2026-02-28 07:47:56');

--
-- Table structure for table `plugin_email_missions`
--

CREATE TABLE `plugin_email_missions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `invoice_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `due_date` date NOT NULL,
  `reminder_rules` json DEFAULT NULL,
  `reminder_send_time` time NOT NULL DEFAULT '09:00:00',
  `overdue_interval` int NOT NULL DEFAULT '0',
  `overdue_stop_after_days` int NOT NULL DEFAULT '0',
  `overdue_stop_after_count` int NOT NULL DEFAULT '0',
  `overdue_send_time` time NOT NULL DEFAULT '09:00:00',
  `reminders_sent` json DEFAULT NULL,
  `overdue_sent_count` int NOT NULL DEFAULT '0',
  `last_processed_at` timestamp NULL DEFAULT NULL,
  `status` enum('active','completed','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plugin_email_missions_user_id_invoice_id_unique` (`user_id`,`invoice_id`),
  KEY `plugin_email_missions_invoice_id_index` (`invoice_id`),
  KEY `plugin_email_missions_client_id_index` (`client_id`),
  CONSTRAINT `plugin_email_missions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plugin_email_missions`
--

INSERT INTO `plugin_email_missions` VALUES (4,4,'805',NULL,'2026-02-24','[3, 1]','21:18:56',0,0,0,'09:00:00','[3]',0,'2026-02-21 21:26:59','cancelled','2026-02-21 20:04:32','2026-02-22 01:09:21'),(5,4,'829','77','2026-02-22','[\"7\", \"2\"]','03:00:00',7,14,1,'03:00:00',NULL,0,NULL,'cancelled','2026-02-22 01:22:49','2026-02-22 15:52:11'),(6,4,'834','77','2026-02-28','[\"7\", \"2\"]','03:00:00',7,14,1,'03:00:00',NULL,0,NULL,'cancelled','2026-02-22 01:54:22','2026-02-22 16:22:55'),(7,4,'837','76','2026-03-08','[\"7\", \"2\"]','03:00:00',7,14,1,'03:00:00',NULL,0,NULL,'active','2026-02-22 17:28:17','2026-02-22 17:28:17'),(8,5,'871',NULL,'2026-03-14','[\"7\", \"2\"]','03:00:00',7,14,1,'03:00:00',NULL,0,NULL,'cancelled','2026-03-03 11:57:33','2026-03-03 17:27:21'),(9,5,'875',NULL,'2026-03-15','[\"7\", \"2\"]','03:00:00',7,14,1,'03:00:00',NULL,0,NULL,'cancelled','2026-03-03 21:23:36','2026-03-04 02:31:11'),(10,5,'885',NULL,'2026-03-15','[\"7\", \"2\"]','03:00:00',7,14,1,'03:00:00',NULL,0,NULL,'cancelled','2026-03-04 03:14:32','2026-03-04 03:22:12'),(11,5,'888','76','2026-03-13','[\"7\", \"2\"]','03:00:00',7,14,1,'03:00:00',NULL,0,NULL,'cancelled','2026-03-04 03:28:52','2026-03-04 03:29:48'),(12,5,'892',NULL,'2026-03-07','[\"7\", \"2\"]','03:00:00',7,14,1,'03:00:00',NULL,0,NULL,'active','2026-03-04 17:19:01','2026-03-04 17:19:01');

--
-- Table structure for table `product_user`
--

CREATE TABLE `product_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `payment_id` bigint unsigned DEFAULT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_user_user_id_foreign` (`user_id`),
  CONSTRAINT `product_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_user`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sku` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(15,4) DEFAULT NULL,
  `original_price` decimal(15,4) DEFAULT NULL,
  `excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `state` enum('draft','inactive','active','unavailable','retired') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `length` decimal(15,4) DEFAULT NULL,
  `width` decimal(15,4) DEFAULT NULL,
  `height` decimal(15,4) DEFAULT NULL,
  `weight` decimal(15,4) DEFAULT NULL,
  `ext_title` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `units_sold` int unsigned NOT NULL DEFAULT '0',
  `last_sale_at` datetime DEFAULT NULL,
  `stock` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `tax_category_id` bigint unsigned DEFAULT NULL,
  `sales_count` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,'AgencyPulseWP Invoice Enhancements Plugin','agencypulsewp-invoice-enhancements-plugin','apwp-ie',7.0000,7.0000,NULL,'<ul style=\"padding-left:20px;margin-left:0px;list-style: circle;\">\r\n<li> Custom invoice numbering format.</li>\r\n<li> Create custom client invoice templates.</li>\r\n<li> Secure file storage and signed links.</li>\r\n<li> Manage multiple company invoices.</li>\r\n</ul>','active',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-02-12 12:33:42','2026-02-18 00:49:25',0,NULL,0.0000,NULL,0),(2,'AgencyPulseWP Client Portal Plugin','agencypulsewp-client-portal','apwp-cp',15.0000,15.0000,NULL,'Client Portal','active',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-02-12 12:34:17','2026-02-12 12:34:46',0,NULL,0.0000,NULL,0),(3,'AgencyPulseWP Products Plugin','agencypulsewp-products-cart-plugin','apwp-pc',15.0000,15.0000,NULL,'<ul style=\"padding-left:20px;margin-left:0px;list-style: circle;\">\r\n<li> Create a product catalogue for invoices.</li>\r\n<li> Offer secured digital product  downloads.</li>\r\n<li> Manage and apply coupons and discounts.</li>\r\n<li> Use a featured shopping cart and orders.</li>\r\n</ul>','active',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-02-12 12:35:50','2026-02-20 16:25:52',0,NULL,0.0000,NULL,0),(4,'AgencyPulseWP Line Item Tax Rates','agencypulsewp-line-item-tax-rates','apwp-li',7.0000,7.0000,NULL,'Line Item Tax Rates','active',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-02-12 12:36:35','2026-02-12 12:36:35',0,NULL,0.0000,NULL,0),(5,'AgencyPulseWP Multi-Currency','agencypulsewp-multi-currency','apwp-mc',5.0000,5.0000,NULL,'<ul style=\"padding-left:20px;margin-left:0px;list-style: circle;\">\r\n<li>Choose and set a base currency & more.</li>\r\n<li>Set per invoice and per client currencies.</li>\r\n<li>See and pay totals in their own currency.</li>\r\n<li>Always uses live exchange rates.</li>\r\n</ul>','active',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-02-12 12:37:13','2026-02-18 00:50:47',0,NULL,0.0000,NULL,0);

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `person_id` int unsigned NOT NULL,
  `avatar_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `profiles_user_id_foreign` (`user_id`),
  KEY `profiles_person_id_foreign` (`person_id`),
  CONSTRAINT `profiles_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `profiles`
--


--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `configuration` json DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `properties_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `properties`
--


--
-- Table structure for table `property_values`
--

CREATE TABLE `property_values` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `property_id` int unsigned NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` int DEFAULT NULL,
  `settings` json DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `property_values_property_id_foreign` (`property_id`),
  KEY `property_values_priority_index` (`priority`),
  CONSTRAINT `property_values_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_values`
--


--
-- Table structure for table `provinces`
--

CREATE TABLE `provinces` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `country_id` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'province',
  `code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'National identification code',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `provinces_country_id_code_index` (`country_id`,`code`),
  KEY `provinces_code_index` (`code`),
  KEY `provinces_parent_id_foreign` (`parent_id`),
  CONSTRAINT `provinces_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `provinces_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provinces`
--

INSERT INTO `provinces` VALUES (1,'US','state','AL','Alabama',NULL),(2,'US','state','AK','Alaska',NULL),(3,'US','state','AZ','Arizona',NULL),(4,'US','state','AR','Arkansas',NULL),(5,'US','state','CA','California',NULL),(6,'US','state','CO','Colorado',NULL),(7,'US','state','CT','Connecticut',NULL),(8,'US','state','DE','Delaware',NULL),(9,'US','state','FL','Florida',NULL),(10,'US','state','GA','Georgia',NULL),(11,'US','state','HI','Hawaii',NULL),(12,'US','state','ID','Idaho',NULL),(13,'US','state','IL','Illinois',NULL),(14,'US','state','IN','Indiana',NULL),(15,'US','state','IA','Iowa',NULL),(16,'US','state','KS','Kansas',NULL),(17,'US','state','KY','Kentucky',NULL),(18,'US','state','LA','Louisiana',NULL),(19,'US','state','ME','Maine',NULL),(20,'US','state','MD','Maryland',NULL),(21,'US','state','MA','Massachusetts',NULL),(22,'US','state','MI','Michigan',NULL),(23,'US','state','MN','Minnesota',NULL),(24,'US','state','MS','Mississippi',NULL),(25,'US','state','MO','Missouri',NULL),(26,'US','state','MT','Montana',NULL),(27,'US','state','NE','Nebraska',NULL),(28,'US','state','NV','Nevada',NULL),(29,'US','state','NH','New Hampshire',NULL),(30,'US','state','NJ','New Jersey',NULL),(31,'US','state','NM','New Mexico',NULL),(32,'US','state','NY','New York',NULL),(33,'US','state','NC','North Carolina',NULL),(34,'US','state','ND','North Dakota',NULL),(35,'US','state','OH','Ohio',NULL),(36,'US','state','OK','Oklahoma',NULL),(37,'US','state','OR','Oregon',NULL),(38,'US','state','PA','Pennsylvania',NULL),(39,'US','state','RI','Rhode Island',NULL),(40,'US','state','SC','South Carolina',NULL),(41,'US','state','SD','South Dakota',NULL),(42,'US','state','TN','Tennessee',NULL),(43,'US','state','TX','Texas',NULL),(44,'US','state','UT','Utah',NULL),(45,'US','state','VT','Vermont',NULL),(46,'US','state','VA','Virginia',NULL),(47,'US','state','WA','Washington',NULL),(48,'US','state','WV','West Virginia',NULL),(49,'US','state','WI','Wisconsin',NULL),(50,'US','state','WY','Wyoming',NULL),(51,'US','federal_district','DC','District of Columbia',NULL),(52,'US','territory','AS','American Samoa',NULL),(53,'US','territory','GU','Guam',NULL),(54,'US','territory','MP','Northern Mariana Islands',NULL),(55,'US','territory','PR','Puerto Rico',NULL),(56,'US','territory','VI','Virgin Islands',NULL),(57,'US','military','AA','Armed Forces Americas (except Canada)',NULL),(58,'US','military','AE','Armed Forces Europe, the Middle East, and Canada',NULL),(59,'US','military','AP','Armed Forces Pacific',NULL),(60,'CA','province','AB','Alberta',NULL),(61,'CA','province','BC','British Columbia',NULL),(62,'CA','province','MB','Manitoba',NULL),(63,'CA','province','NB','New Brunswick',NULL),(64,'CA','province','NL','Newfoundland',NULL),(65,'CA','province','NS','Nova Scotia',NULL),(66,'CA','province','ON','Ontario',NULL),(67,'CA','province','PE','Prince Edward Island',NULL),(68,'CA','province','QC','Quebec',NULL),(69,'CA','province','SK','Saskatchewan',NULL),(70,'CA','territory','NT','Northwest Territories',NULL),(71,'CA','territory','NU','Nunavut',NULL),(72,'CA','territory','YT','Yukon',NULL),(73,'BE','region','BRU','Brussels',NULL),(74,'BE','region','VLG','Flanders',NULL),(75,'BE','region','WAL','Wallonia',NULL),(76,'BE','province','VAN','Antwerp',74),(77,'BE','province','VOV','East Flanders',74),(78,'BE','province','VBR','Flemish Brabant',74),(79,'BE','province','VLI','Limburg',74),(80,'BE','province','VWV','West Flanders',74),(81,'BE','province','WHT','Hainaut',75),(82,'BE','province','WLG','Liège',75),(83,'BE','province','WLX','Luxembourg',75),(84,'BE','province','WNA','Namur',75),(85,'BE','province','WBR','Walloon Brabant',75);

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `permission_id` int unsigned NOT NULL,
  `role_id` int unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_permissions`
--

INSERT INTO `role_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(51,1),(52,1),(53,1),(54,1),(55,1),(56,1),(57,1),(58,1),(59,1),(60,1),(121,1),(122,1),(123,1),(124,1),(125,1),(1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(16,2),(17,2),(18,2),(19,2),(20,2),(21,2),(22,2),(23,2),(24,2),(25,2),(26,2),(27,2),(28,2),(29,2),(30,2),(31,2),(32,2),(33,2),(34,2),(35,2),(36,2),(37,2),(38,2),(39,2),(40,2),(41,2),(42,2),(43,2),(44,2),(45,2),(46,2),(47,2),(48,2),(49,2),(50,2),(51,2),(52,2),(53,2),(54,2),(55,2),(56,2),(57,2),(58,2),(59,2),(60,2),(61,2),(62,2),(63,2),(64,2),(65,2),(66,2),(67,2),(68,2),(69,2),(70,2),(71,2),(72,2),(73,2),(74,2),(75,2),(76,2),(77,2),(78,2),(79,2),(80,2),(81,2),(82,2),(83,2),(84,2),(85,2),(86,2),(87,2),(88,2),(89,2),(90,2),(91,2),(92,2),(93,2),(94,2),(95,2),(96,2),(97,2),(98,2),(99,2),(100,2),(101,2),(102,2),(103,2),(104,2),(105,2),(106,2),(107,2),(108,2),(109,2),(110,2),(111,2),(112,2),(113,2),(114,2),(115,2),(116,2),(117,2),(118,2),(119,2),(120,2);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'admin','web','2026-02-12 12:02:02','2026-02-12 12:02:02'),(2,'admin','admin','2026-02-12 12:07:11','2026-02-12 12:07:11'),(3,'superadmin','admin','2026-02-12 12:07:11','2026-02-12 12:07:11');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--


--
-- Table structure for table `shipments`
--

CREATE TABLE `shipments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tracking_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_id` int unsigned NOT NULL,
  `carrier_id` bigint unsigned DEFAULT NULL,
  `is_trackable` tinyint(1) NOT NULL DEFAULT '1',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
  `weight` decimal(15,4) DEFAULT NULL,
  `height` decimal(15,4) DEFAULT NULL,
  `width` decimal(15,4) DEFAULT NULL,
  `length` decimal(15,4) DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `configuration` json DEFAULT NULL,
  `label_base64` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `label_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `carrier_cost` decimal(15,4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shipments_address_id_foreign` (`address_id`),
  CONSTRAINT `shipments_address_id_foreign` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipments`
--


--
-- Table structure for table `shippables`
--

CREATE TABLE `shippables` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `shipment_id` bigint unsigned NOT NULL,
  `shippable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shippable_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shippables_shipment_id_foreign` (`shipment_id`),
  CONSTRAINT `shippables_shipment_id_foreign` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shippables`
--


--
-- Table structure for table `shipping_methods`
--

CREATE TABLE `shipping_methods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `carrier_id` bigint unsigned DEFAULT NULL,
  `calculator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zone_id` bigint unsigned DEFAULT NULL,
  `configuration` json DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shipping_methods_carrier_id_foreign` (`carrier_id`),
  KEY `shipping_methods_zone_id_foreign` (`zone_id`),
  CONSTRAINT `shipping_methods_carrier_id_foreign` FOREIGN KEY (`carrier_id`) REFERENCES `carriers` (`id`),
  CONSTRAINT `shipping_methods_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping_methods`
--


--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint unsigned NOT NULL,
  `stripe_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_product` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_items_subscription_id_stripe_price_unique` (`subscription_id`,`stripe_price`),
  UNIQUE KEY `subscription_items_stripe_id_unique` (`stripe_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_items`
--

INSERT INTO `subscription_items` VALUES (1,1,'si_Txo0jB1qN6Nxln','prod_Txo0NjrJguF577','price_1SzsOOEZddBvNOgsN9wkxtzI',1,'2026-02-12 05:24:49','2026-02-12 05:24:49'),(2,2,'si_Txo39Pru0MC2Sx','prod_Txo37VygSjPj3Z','price_1SzsRhEZddBvNOgsw7Nxd5Ga',1,'2026-02-12 05:28:14','2026-02-12 05:28:14'),(3,3,'si_Txv1zX3A6MjF8v','prod_Txv1S30TBCto4D','price_1SzzBeEZddBvNOgsswq5u3BF',1,'2026-02-12 12:40:10','2026-02-12 12:40:10'),(4,4,'si_Txv4dqkPk7fnVx','prod_Txv4ZP8KJWkC8b','price_1SzzENEZddBvNOgsGGW96q0m',1,'2026-02-12 12:42:58','2026-02-12 12:42:58'),(5,5,'si_Txv7j2zwZPmWUG','prod_Txv71LIhugY1jA','price_1SzzGxEZddBvNOgsRXKybttz',1,'2026-02-12 12:45:37','2026-02-12 12:45:37'),(6,6,'si_Txv9BzEfBHvRq5','prod_Txv9gIvEkiFJ4s','price_1SzzJMEZddBvNOgs5mdlNIQl',1,'2026-02-12 12:48:07','2026-02-12 12:48:07'),(7,7,'si_TxvCxmrkOkSh8D','prod_TxvCcDGz499jSK','price_1SzzLuEZddBvNOgsZN5cHvSw',1,'2026-02-12 12:50:45','2026-02-12 12:50:45'),(8,8,'si_TxvHtD13W3V5HC','prod_TxvHWj2zXaB8th','price_1SzzQsEZddBvNOgsg0hE47k9',1,'2026-02-12 12:55:53','2026-02-12 12:55:53'),(9,9,'si_TxvUdTvC6VmJ3v','prod_TxvU6nKqIGvs1L','price_1Szzd9EZddBvNOgsnRamWGFN',1,'2026-02-12 13:08:34','2026-02-12 13:08:34'),(10,10,'si_TxvWL7m7Ox5wER','prod_TxvWAbDNk4wR3p','price_1SzzfBEZddBvNOgszoCnkkA7',1,'2026-02-12 13:10:40','2026-02-12 13:10:40'),(11,11,'si_Ty2Qwt1vCQEgiL','prod_Ty2QE9ZifRdZG7','price_1T06LTEZddBvNOgsHjNCjItS',1,'2026-02-12 20:18:47','2026-02-12 20:18:47'),(12,12,'si_U1tkWbieoHVksE','prod_U1tkUaCk0qZ6KC','price_1T3pxDEZddBvNOgs4zef6W2v',1,'2026-02-23 03:37:09','2026-02-23 03:37:09'),(13,13,'si_U2AZl4Vx8GBs0c','prod_U2AYcwDvMM5ljV','price_1T46DpEZddBvNOgs147wyppE',1,'2026-02-23 20:59:24','2026-02-23 20:59:24'),(14,14,'si_U2AnGWJOnhSy0J','prod_U2AnB4W3YjeaI6','price_1T46RREZddBvNOgslSYsUPtk',1,'2026-02-23 21:13:28','2026-02-23 21:13:28'),(15,15,'si_U2Au240ygEGhcK','prod_U2AuS5S0GOHoO0','price_1T46YeEZddBvNOgsp4J1sllQ',1,'2026-02-23 21:20:55','2026-02-23 21:20:55');

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriptions_stripe_id_unique` (`stripe_id`),
  KEY `subscriptions_user_id_stripe_status_index` (`user_id`,`stripe_status`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` VALUES (1,1,'default','sub_1SzsOREZddBvNOgsDqJuIXgP','active','price_1SzsOOEZddBvNOgsN9wkxtzI',1,NULL,NULL,'2026-02-12 05:24:49','2026-02-12 05:24:49'),(2,1,'default','sub_1SzsRkEZddBvNOgsRugEkM4u','active','price_1SzsRhEZddBvNOgsw7Nxd5Ga',1,NULL,NULL,'2026-02-12 05:28:14','2026-02-12 05:28:14'),(3,3,'default','sub_1SzzBiEZddBvNOgsDfcXq0do','active','price_1SzzBeEZddBvNOgsswq5u3BF',1,NULL,NULL,'2026-02-12 12:40:10','2026-02-12 12:40:10'),(4,3,'default','sub_1SzzEQEZddBvNOgsELIdfijN','active','price_1SzzENEZddBvNOgsGGW96q0m',1,NULL,NULL,'2026-02-12 12:42:58','2026-02-12 12:42:58'),(5,3,'default','sub_1SzzH0EZddBvNOgsPLL25Z70','active','price_1SzzGxEZddBvNOgsRXKybttz',1,NULL,NULL,'2026-02-12 12:45:37','2026-02-12 12:45:37'),(6,3,'default','sub_1SzzJPEZddBvNOgsNqMcMhFK','active','price_1SzzJMEZddBvNOgs5mdlNIQl',1,NULL,NULL,'2026-02-12 12:48:07','2026-02-12 12:48:07'),(7,3,'default','sub_1SzzLxEZddBvNOgsxWLbX9EJ','active','price_1SzzLuEZddBvNOgsZN5cHvSw',1,NULL,NULL,'2026-02-12 12:50:44','2026-02-12 12:50:44'),(8,3,'default','sub_1SzzQwEZddBvNOgsRGoZ7WU5','active','price_1SzzQsEZddBvNOgsg0hE47k9',1,NULL,NULL,'2026-02-12 12:55:53','2026-02-12 12:55:53'),(9,3,'default','sub_1SzzdCEZddBvNOgsNbwoM2bj','active','price_1Szzd9EZddBvNOgsnRamWGFN',1,NULL,NULL,'2026-02-12 13:08:34','2026-02-12 13:08:34'),(10,3,'default','sub_1SzzfFEZddBvNOgsOtokshfR','active','price_1SzzfBEZddBvNOgszoCnkkA7',1,NULL,NULL,'2026-02-12 13:10:40','2026-02-12 13:10:40'),(11,4,'default','sub_1T06LXEZddBvNOgsWAiSX9Hp','active','price_1T06LTEZddBvNOgsHjNCjItS',1,NULL,NULL,'2026-02-12 20:18:47','2026-02-12 20:18:47'),(12,5,'default','sub_1T3pxGEZddBvNOgsf05gVWed','active','price_1T3pxDEZddBvNOgs4zef6W2v',1,NULL,NULL,'2026-02-23 03:37:09','2026-02-23 03:37:09'),(13,4,'default','sub_1T46DtEZddBvNOgselGH71Hl','active','price_1T46DpEZddBvNOgs147wyppE',1,NULL,NULL,'2026-02-23 20:59:24','2026-02-23 20:59:24'),(14,4,'default','sub_1T46RVEZddBvNOgsRmuBpbDl','active','price_1T46RREZddBvNOgslSYsUPtk',1,NULL,NULL,'2026-02-23 21:13:28','2026-02-23 21:13:28'),(15,4,'default','sub_1T46YiEZddBvNOgsScqk1Ja3','active','price_1T46YeEZddBvNOgsp4J1sllQ',1,NULL,NULL,'2026-02-23 21:20:55','2026-02-23 21:20:55');

--
-- Table structure for table `tax_categories`
--

CREATE TABLE `tax_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tax_categories`
--


--
-- Table structure for table `tax_rates`
--

CREATE TABLE `tax_rates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_category_id` bigint unsigned DEFAULT NULL,
  `zone_id` bigint unsigned DEFAULT NULL,
  `rate` decimal(15,4) NOT NULL,
  `calculator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `configuration` json DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `valid_from` timestamp NULL DEFAULT NULL,
  `valid_until` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tax_rates_tax_category_id_foreign` (`tax_category_id`),
  KEY `tax_rates_zone_id_foreign` (`zone_id`),
  CONSTRAINT `tax_rates_tax_category_id_foreign` FOREIGN KEY (`tax_category_id`) REFERENCES `tax_categories` (`id`),
  CONSTRAINT `tax_rates_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tax_rates`
--


--
-- Table structure for table `taxonomies`
--

CREATE TABLE `taxonomies` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `taxonomies_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `taxonomies`
--

INSERT INTO `taxonomies` VALUES (1,'WordPress Invoice Plugin','wordpress-invoice-plugin','2026-02-12 18:16:13','2026-02-12 18:28:01');

--
-- Table structure for table `taxons`
--

CREATE TABLE `taxons` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `taxonomy_id` int unsigned NOT NULL,
  `parent_id` int unsigned DEFAULT NULL,
  `priority` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ext_title` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `taxons_taxonomy_id_slug_parent_id_unique` (`taxonomy_id`,`slug`,`parent_id`),
  KEY `taxons_parent_id_foreign` (`parent_id`),
  KEY `taxons_priority_index` (`priority`),
  CONSTRAINT `taxons_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `taxons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `taxons_taxonomy_id_foreign` FOREIGN KEY (`taxonomy_id`) REFERENCES `taxonomies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `taxons`
--

INSERT INTO `taxons` VALUES (1,1,NULL,NULL,'Software','software',NULL,NULL,NULL,'2026-02-12 18:16:13','2026-02-12 18:16:13'),(2,1,NULL,NULL,'Plugins','plugins',NULL,NULL,NULL,'2026-02-12 18:16:13','2026-02-12 18:16:13'),(3,1,NULL,NULL,'Themes','themes',NULL,NULL,NULL,'2026-02-12 18:16:13','2026-02-12 18:16:13');

--
-- Table structure for table `zone_members`
--

CREATE TABLE `zone_members` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `zone_id` bigint unsigned NOT NULL,
  `member_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `member_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `zone_members_zone_id_foreign` (`zone_id`),
  CONSTRAINT `zone_members_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zone_members`
--


--
-- Table structure for table `zones`
--

CREATE TABLE `zones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `scope` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'shipping',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zones`
--



