-- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for osx10.10 (x86_64) -- -- Host: localhost Database: whatsomni -- ------------------------------------------------------ -- Server version 10.4.28-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `admin_notifications` -- DROP TABLE IF EXISTS `admin_notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `admin_notifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `body` text NOT NULL, `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data`)), `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `admin_notifications_read_at_index` (`read_at`), KEY `admin_notifications_created_at_index` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admin_notifications` -- LOCK TABLES `admin_notifications` WRITE; /*!40000 ALTER TABLE `admin_notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `admin_notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ai_agent_channels` -- DROP TABLE IF EXISTS `ai_agent_channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ai_agent_channels` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ai_agent_id` bigint(20) unsigned NOT NULL, `channel_connection_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `agent_channel_unique` (`ai_agent_id`,`channel_connection_id`), KEY `ai_agent_channels_channel_connection_id_foreign` (`channel_connection_id`), CONSTRAINT `ai_agent_channels_ai_agent_id_foreign` FOREIGN KEY (`ai_agent_id`) REFERENCES `ai_agents` (`id`) ON DELETE CASCADE, CONSTRAINT `ai_agent_channels_channel_connection_id_foreign` FOREIGN KEY (`channel_connection_id`) REFERENCES `channel_connections` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ai_agent_channels` -- LOCK TABLES `ai_agent_channels` WRITE; /*!40000 ALTER TABLE `ai_agent_channels` DISABLE KEYS */; /*!40000 ALTER TABLE `ai_agent_channels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ai_agent_logs` -- DROP TABLE IF EXISTS `ai_agent_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ai_agent_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ai_agent_id` bigint(20) unsigned NOT NULL, `conversation_id` bigint(20) unsigned DEFAULT NULL, `request_tokens` int(11) NOT NULL DEFAULT 0, `response_tokens` int(11) NOT NULL DEFAULT 0, `estimated_cost` decimal(10,6) NOT NULL DEFAULT 0.000000, `model_used` varchar(255) NOT NULL, `latency_ms` int(10) unsigned NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `ai_agent_logs_conversation_id_foreign` (`conversation_id`), KEY `ai_agent_logs_ai_agent_id_created_at_index` (`ai_agent_id`,`created_at`), CONSTRAINT `ai_agent_logs_ai_agent_id_foreign` FOREIGN KEY (`ai_agent_id`) REFERENCES `ai_agents` (`id`) ON DELETE CASCADE, CONSTRAINT `ai_agent_logs_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ai_agent_logs` -- LOCK TABLES `ai_agent_logs` WRITE; /*!40000 ALTER TABLE `ai_agent_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `ai_agent_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ai_agents` -- DROP TABLE IF EXISTS `ai_agents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ai_agents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL DEFAULT 'inbound', `trigger_type` varchar(50) NOT NULL DEFAULT 'inbound_message', `ai_provider_config_id` bigint(20) unsigned DEFAULT NULL, `provider` varchar(255) DEFAULT NULL, `model` varchar(255) DEFAULT NULL, `system_prompt` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `business_hours` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`business_hours`)), `fallback_message` text DEFAULT NULL, `handoff_rules` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`handoff_rules`)), `flow_id` bigint(20) unsigned DEFAULT NULL, `knowledge_base_id` bigint(20) unsigned DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ai_agents_ai_provider_config_id_foreign` (`ai_provider_config_id`), KEY `ai_agents_flow_id_foreign` (`flow_id`), KEY `ai_agents_knowledge_base_id_foreign` (`knowledge_base_id`), KEY `ai_agents_created_by_foreign` (`created_by`), KEY `ai_agents_tenant_id_status_index` (`tenant_id`,`status`), CONSTRAINT `ai_agents_ai_provider_config_id_foreign` FOREIGN KEY (`ai_provider_config_id`) REFERENCES `ai_provider_configs` (`id`) ON DELETE SET NULL, CONSTRAINT `ai_agents_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tenant_users` (`id`) ON DELETE SET NULL, CONSTRAINT `ai_agents_flow_id_foreign` FOREIGN KEY (`flow_id`) REFERENCES `flows` (`id`) ON DELETE SET NULL, CONSTRAINT `ai_agents_knowledge_base_id_foreign` FOREIGN KEY (`knowledge_base_id`) REFERENCES `knowledge_bases` (`id`) ON DELETE SET NULL, CONSTRAINT `ai_agents_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ai_agents` -- LOCK TABLES `ai_agents` WRITE; /*!40000 ALTER TABLE `ai_agents` DISABLE KEYS */; /*!40000 ALTER TABLE `ai_agents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ai_provider_configs` -- DROP TABLE IF EXISTS `ai_provider_configs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ai_provider_configs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `provider_name` varchar(255) NOT NULL, `api_key` text NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `enabled_models` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`enabled_models`)), `default_model` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ai_provider_configs_tenant_id_provider_name_unique` (`tenant_id`,`provider_name`), CONSTRAINT `ai_provider_configs_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ai_provider_configs` -- LOCK TABLES `ai_provider_configs` WRITE; /*!40000 ALTER TABLE `ai_provider_configs` DISABLE KEYS */; /*!40000 ALTER TABLE `ai_provider_configs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `appointments` -- DROP TABLE IF EXISTS `appointments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `appointments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `contact_id` bigint(20) unsigned NOT NULL, `booking_link_id` bigint(20) unsigned DEFAULT NULL, `staff_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `resource_name` varchar(255) DEFAULT NULL, `google_event_id` varchar(255) DEFAULT NULL, `start_time` datetime NOT NULL, `end_time` datetime NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'scheduled', `notes` text DEFAULT NULL, `meeting_link` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `appointments_contact_id_foreign` (`contact_id`), KEY `appointments_booking_link_id_foreign` (`booking_link_id`), KEY `appointments_tenant_id_start_time_index` (`tenant_id`,`start_time`), KEY `appointments_user_id_foreign` (`user_id`), KEY `appointments_staff_id_foreign` (`staff_id`), CONSTRAINT `appointments_booking_link_id_foreign` FOREIGN KEY (`booking_link_id`) REFERENCES `booking_links` (`id`) ON DELETE SET NULL, CONSTRAINT `appointments_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE, CONSTRAINT `appointments_staff_id_foreign` FOREIGN KEY (`staff_id`) REFERENCES `staff_members` (`id`) ON DELETE SET NULL, CONSTRAINT `appointments_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `appointments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tenant_users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `appointments` -- LOCK TABLES `appointments` WRITE; /*!40000 ALTER TABLE `appointments` DISABLE KEYS */; /*!40000 ALTER TABLE `appointments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `audit_logs` -- DROP TABLE IF EXISTS `audit_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `audit_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `actor_type` varchar(255) NOT NULL, `actor_id` bigint(20) unsigned NOT NULL, `action` varchar(255) NOT NULL, `subject_type` varchar(255) DEFAULT NULL, `subject_id` bigint(20) unsigned DEFAULT NULL, `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)), `ip_address` varchar(45) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `audit_logs` -- LOCK TABLES `audit_logs` WRITE; /*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `booking_links` -- DROP TABLE IF EXISTS `booking_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `booking_links` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `staff_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `slug` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `duration` int(11) NOT NULL DEFAULT 30, `buffer_before` int(11) NOT NULL DEFAULT 0, `buffer_after` int(11) NOT NULL DEFAULT 0, `working_hours` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`working_hours`)), `is_active` tinyint(1) NOT NULL DEFAULT 1, `assign_mode` varchar(255) NOT NULL DEFAULT 'single', `resource_pool` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`resource_pool`)), `location_type` varchar(255) NOT NULL DEFAULT 'none', `custom_location` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `booking_links_tenant_id_slug_unique` (`tenant_id`,`slug`), KEY `booking_links_user_id_foreign` (`user_id`), KEY `booking_links_staff_id_foreign` (`staff_id`), CONSTRAINT `booking_links_staff_id_foreign` FOREIGN KEY (`staff_id`) REFERENCES `staff_members` (`id`) ON DELETE SET NULL, CONSTRAINT `booking_links_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `booking_links_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tenant_users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `booking_links` -- LOCK TABLES `booking_links` WRITE; /*!40000 ALTER TABLE `booking_links` DISABLE KEYS */; /*!40000 ALTER TABLE `booking_links` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaign_dispatches` -- DROP TABLE IF EXISTS `campaign_dispatches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `campaign_dispatches` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `campaign_id` bigint(20) unsigned NOT NULL, `contact_id` bigint(20) unsigned NOT NULL, `message_id` bigint(20) unsigned DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'queued', `error_message` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `campaign_dispatches_campaign_id_foreign` (`campaign_id`), KEY `campaign_dispatches_contact_id_foreign` (`contact_id`), KEY `campaign_dispatches_message_id_foreign` (`message_id`), CONSTRAINT `campaign_dispatches_campaign_id_foreign` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE, CONSTRAINT `campaign_dispatches_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE, CONSTRAINT `campaign_dispatches_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaign_dispatches` -- LOCK TABLES `campaign_dispatches` WRITE; /*!40000 ALTER TABLE `campaign_dispatches` DISABLE KEYS */; /*!40000 ALTER TABLE `campaign_dispatches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaigns` -- DROP TABLE IF EXISTS `campaigns`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `campaigns` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `channel_connection_id` bigint(20) unsigned NOT NULL, `audience_filter` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`audience_filter`)), `source_type` varchar(255) NOT NULL, `message_template_id` bigint(20) unsigned DEFAULT NULL, `ai_agent_id` bigint(20) unsigned DEFAULT NULL, `flow_id` bigint(20) unsigned DEFAULT NULL, `schedule_type` varchar(255) NOT NULL, `scheduled_at` timestamp NULL DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'draft', `total_contacts` int(11) NOT NULL DEFAULT 0, `sent_count` int(11) NOT NULL DEFAULT 0, `delivered_count` int(11) NOT NULL DEFAULT 0, `read_count` int(11) NOT NULL DEFAULT 0, `replied_count` int(11) NOT NULL DEFAULT 0, `failed_count` int(11) NOT NULL DEFAULT 0, `error_log` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `campaigns_tenant_id_foreign` (`tenant_id`), KEY `campaigns_channel_connection_id_foreign` (`channel_connection_id`), KEY `campaigns_message_template_id_foreign` (`message_template_id`), KEY `campaigns_ai_agent_id_foreign` (`ai_agent_id`), KEY `campaigns_flow_id_foreign` (`flow_id`), CONSTRAINT `campaigns_ai_agent_id_foreign` FOREIGN KEY (`ai_agent_id`) REFERENCES `ai_agents` (`id`) ON DELETE CASCADE, CONSTRAINT `campaigns_channel_connection_id_foreign` FOREIGN KEY (`channel_connection_id`) REFERENCES `channel_connections` (`id`) ON DELETE CASCADE, CONSTRAINT `campaigns_flow_id_foreign` FOREIGN KEY (`flow_id`) REFERENCES `flows` (`id`) ON DELETE SET NULL, CONSTRAINT `campaigns_message_template_id_foreign` FOREIGN KEY (`message_template_id`) REFERENCES `message_templates` (`id`) ON DELETE CASCADE, CONSTRAINT `campaigns_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaigns` -- LOCK TABLES `campaigns` WRITE; /*!40000 ALTER TABLE `campaigns` DISABLE KEYS */; /*!40000 ALTER TABLE `campaigns` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `channel_connections` -- DROP TABLE IF EXISTS `channel_connections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `channel_connections` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `channel_type` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'connected', `credentials` text NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `channel_connections_tenant_id_foreign` (`tenant_id`), CONSTRAINT `channel_connections_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `channel_connections` -- LOCK TABLES `channel_connections` WRITE; /*!40000 ALTER TABLE `channel_connections` DISABLE KEYS */; /*!40000 ALTER TABLE `channel_connections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_activities` -- DROP TABLE IF EXISTS `contact_activities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_activities` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `contact_id` bigint(20) unsigned NOT NULL, `type` varchar(255) NOT NULL, `description` text NOT NULL, `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)), `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `contact_activities_tenant_id_foreign` (`tenant_id`), KEY `contact_activities_contact_id_foreign` (`contact_id`), KEY `contact_activities_created_by_foreign` (`created_by`), CONSTRAINT `contact_activities_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE, CONSTRAINT `contact_activities_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tenant_users` (`id`) ON DELETE SET NULL, CONSTRAINT `contact_activities_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_activities` -- LOCK TABLES `contact_activities` WRITE; /*!40000 ALTER TABLE `contact_activities` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_activities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contacts` -- DROP TABLE IF EXISTS `contacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contacts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `lifecycle_stage` varchar(255) NOT NULL DEFAULT 'lead', `opted_out_channels` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`opted_out_channels`)), `custom_fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`custom_fields`)), `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tags`)), `is_muted` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `contacts_tenant_id_email_index` (`tenant_id`,`email`), KEY `contacts_tenant_id_phone_index` (`tenant_id`,`phone`), CONSTRAINT `contacts_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contacts` -- LOCK TABLES `contacts` WRITE; /*!40000 ALTER TABLE `contacts` DISABLE KEYS */; /*!40000 ALTER TABLE `contacts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conversations` -- DROP TABLE IF EXISTS `conversations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `channel_connection_id` bigint(20) unsigned NOT NULL, `contact_id` bigint(20) unsigned DEFAULT NULL, `external_chat_id` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'open', `assigned_user_id` bigint(20) unsigned DEFAULT NULL, `assigned_team_id` bigint(20) unsigned DEFAULT NULL, `ai_active` tinyint(1) NOT NULL DEFAULT 0, `ai_agent_id` bigint(20) unsigned DEFAULT NULL, `last_message_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `conversations_channel_connection_id_external_chat_id_unique` (`channel_connection_id`,`external_chat_id`), KEY `conversations_tenant_id_foreign` (`tenant_id`), KEY `conversations_contact_id_foreign` (`contact_id`), KEY `conversations_assigned_user_id_foreign` (`assigned_user_id`), KEY `conversations_assigned_team_id_foreign` (`assigned_team_id`), KEY `conversations_ai_agent_id_foreign` (`ai_agent_id`), CONSTRAINT `conversations_ai_agent_id_foreign` FOREIGN KEY (`ai_agent_id`) REFERENCES `ai_agents` (`id`) ON DELETE SET NULL, CONSTRAINT `conversations_assigned_team_id_foreign` FOREIGN KEY (`assigned_team_id`) REFERENCES `teams` (`id`) ON DELETE SET NULL, CONSTRAINT `conversations_assigned_user_id_foreign` FOREIGN KEY (`assigned_user_id`) REFERENCES `tenant_users` (`id`) ON DELETE SET NULL, CONSTRAINT `conversations_channel_connection_id_foreign` FOREIGN KEY (`channel_connection_id`) REFERENCES `channel_connections` (`id`) ON DELETE CASCADE, CONSTRAINT `conversations_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE SET NULL, CONSTRAINT `conversations_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conversations` -- LOCK TABLES `conversations` WRITE; /*!40000 ALTER TABLE `conversations` DISABLE KEYS */; /*!40000 ALTER TABLE `conversations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `crm_integrations` -- DROP TABLE IF EXISTS `crm_integrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `crm_integrations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `provider` varchar(255) NOT NULL, `access_token` text DEFAULT NULL, `refresh_token` text DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `field_mapping` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`field_mapping`)), `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)), `sync_direction` varchar(255) NOT NULL DEFAULT 'bidirectional', `last_sync_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `crm_integrations_tenant_id_provider_unique` (`tenant_id`,`provider`), CONSTRAINT `crm_integrations_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `crm_integrations` -- LOCK TABLES `crm_integrations` WRITE; /*!40000 ALTER TABLE `crm_integrations` DISABLE KEYS */; /*!40000 ALTER TABLE `crm_integrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `crm_sync_logs` -- DROP TABLE IF EXISTS `crm_sync_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `crm_sync_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `crm_integration_id` bigint(20) unsigned NOT NULL, `contact_id` bigint(20) unsigned DEFAULT NULL, `external_id` varchar(255) DEFAULT NULL, `action` varchar(255) NOT NULL, `status` varchar(255) NOT NULL, `error_message` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `crm_sync_logs_tenant_id_foreign` (`tenant_id`), KEY `crm_sync_logs_crm_integration_id_foreign` (`crm_integration_id`), KEY `crm_sync_logs_contact_id_foreign` (`contact_id`), CONSTRAINT `crm_sync_logs_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE, CONSTRAINT `crm_sync_logs_crm_integration_id_foreign` FOREIGN KEY (`crm_integration_id`) REFERENCES `crm_integrations` (`id`) ON DELETE CASCADE, CONSTRAINT `crm_sync_logs_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `crm_sync_logs` -- LOCK TABLES `crm_sync_logs` WRITE; /*!40000 ALTER TABLE `crm_sync_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `crm_sync_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `currencies` -- DROP TABLE IF EXISTS `currencies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `currencies` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(3) NOT NULL, `symbol` varchar(10) NOT NULL, `name` varchar(50) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `is_default` tinyint(1) 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`), UNIQUE KEY `currencies_code_unique` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `currencies` -- LOCK TABLES `currencies` WRITE; /*!40000 ALTER TABLE `currencies` DISABLE KEYS */; INSERT INTO `currencies` VALUES (1,'USD','$','US Dollar',1,1,'2026-08-25 03:57:57','2026-08-25 03:57:57',NULL); /*!40000 ALTER TABLE `currencies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `custom_pages` -- DROP TABLE IF EXISTS `custom_pages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `custom_pages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `content` longtext NOT NULL, `meta_description` text DEFAULT NULL, `is_published` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `custom_pages_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `custom_pages` -- LOCK TABLES `custom_pages` WRITE; /*!40000 ALTER TABLE `custom_pages` DISABLE KEYS */; INSERT INTO `custom_pages` VALUES (1,'about','About Us','

About WhatsOmni

WhatsOmni is the next-generation omnichannel marketing, sales CRM, and AI automation platform built for modern businesses, agencies, and SaaS operators.

','Discover the story, mission, and technology behind WhatsOmni.',1,'2026-08-25 03:57:57','2026-08-25 03:57:57'),(2,'privacy','Privacy Policy','

1. Data We Collect

We collect information you provide directly to us when creating an account, connecting messaging channels, or communicating with customer support.

2. Data Security

All sensitive credentials and API keys are protected using AES-256 encryption at rest.

','Learn how WhatsOmni protects and manages your data privacy.',1,'2026-08-25 03:57:57','2026-08-25 03:57:57'),(3,'terms','Terms & Conditions','

1. Acceptance of Terms

By accessing and using WhatsOmni, you agree to be bound by these Terms of Service. If you do not agree to these terms, please do not use our services.

2. Use of Service

You agree to use WhatsOmni only for lawful purposes and in accordance with all applicable laws and regulations.

','Official terms and conditions for using WhatsOmni platform services.',1,'2026-08-25 03:57:57','2026-08-25 03:57:57'); /*!40000 ALTER TABLE `custom_pages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `deals` -- DROP TABLE IF EXISTS `deals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `deals` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `contact_id` bigint(20) unsigned DEFAULT NULL, `title` varchar(255) NOT NULL, `amount` decimal(15,2) NOT NULL DEFAULT 0.00, `stage` varchar(255) NOT NULL DEFAULT 'lead', `pipeline_stage_order` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `deals_contact_id_foreign` (`contact_id`), KEY `deals_tenant_id_stage_index` (`tenant_id`,`stage`), CONSTRAINT `deals_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE SET NULL, CONSTRAINT `deals_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `deals` -- LOCK TABLES `deals` WRITE; /*!40000 ALTER TABLE `deals` DISABLE KEYS */; /*!40000 ALTER TABLE `deals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_abandoned_carts` -- DROP TABLE IF EXISTS `ecommerce_abandoned_carts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ecommerce_abandoned_carts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `contact_id` bigint(20) unsigned DEFAULT NULL, `cart_token` varchar(255) NOT NULL, `checkout_url` text NOT NULL, `total_price` decimal(10,2) NOT NULL, `items_summary` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`items_summary`)), `recovery_status` varchar(255) NOT NULL DEFAULT 'pending', `recovered_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ecommerce_abandoned_carts_cart_token_unique` (`cart_token`), KEY `ecommerce_abandoned_carts_tenant_id_foreign` (`tenant_id`), KEY `ecommerce_abandoned_carts_contact_id_foreign` (`contact_id`), CONSTRAINT `ecommerce_abandoned_carts_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE SET NULL, CONSTRAINT `ecommerce_abandoned_carts_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_abandoned_carts` -- LOCK TABLES `ecommerce_abandoned_carts` WRITE; /*!40000 ALTER TABLE `ecommerce_abandoned_carts` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_abandoned_carts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_connections` -- DROP TABLE IF EXISTS `ecommerce_connections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ecommerce_connections` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `platform` varchar(255) NOT NULL, `store_url` varchar(255) NOT NULL, `credentials` text NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `webhook_secret` varchar(255) DEFAULT NULL, `last_synced_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_connections_tenant_id_foreign` (`tenant_id`), KEY `ecommerce_connections_store_url_index` (`store_url`), CONSTRAINT `ecommerce_connections_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_connections` -- LOCK TABLES `ecommerce_connections` WRITE; /*!40000 ALTER TABLE `ecommerce_connections` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_connections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_orders` -- DROP TABLE IF EXISTS `ecommerce_orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ecommerce_orders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `ecommerce_connection_id` bigint(20) unsigned NOT NULL, `external_order_id` varchar(255) NOT NULL, `order_number` varchar(255) NOT NULL, `customer_email` varchar(255) NOT NULL, `customer_phone` varchar(255) DEFAULT NULL, `total_price` decimal(10,2) NOT NULL, `financial_status` varchar(255) NOT NULL, `fulfillment_status` varchar(255) NOT NULL, `tracking_number` varchar(255) DEFAULT NULL, `tracking_url` varchar(255) DEFAULT NULL, `items_summary` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`items_summary`)), `external_created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_orders_tenant_id_foreign` (`tenant_id`), KEY `ecommerce_orders_ecommerce_connection_id_foreign` (`ecommerce_connection_id`), KEY `ecommerce_orders_external_order_id_index` (`external_order_id`), KEY `ecommerce_orders_order_number_index` (`order_number`), KEY `ecommerce_orders_customer_email_index` (`customer_email`), KEY `ecommerce_orders_customer_phone_index` (`customer_phone`), CONSTRAINT `ecommerce_orders_ecommerce_connection_id_foreign` FOREIGN KEY (`ecommerce_connection_id`) REFERENCES `ecommerce_connections` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_orders_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_orders` -- LOCK TABLES `ecommerce_orders` WRITE; /*!40000 ALTER TABLE `ecommerce_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email_verification_tokens` -- DROP TABLE IF EXISTS `email_verification_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `email_verification_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `email_verification_tokens_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `email_verification_tokens` -- LOCK TABLES `email_verification_tokens` WRITE; /*!40000 ALTER TABLE `email_verification_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `email_verification_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `flow_execution_logs` -- DROP TABLE IF EXISTS `flow_execution_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `flow_execution_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `flow_execution_id` bigint(20) unsigned NOT NULL, `node_id` varchar(100) NOT NULL, `node_type` varchar(100) NOT NULL, `node_title` varchar(255) NOT NULL, `status` varchar(50) NOT NULL, `execution_time_ms` int(10) unsigned NOT NULL DEFAULT 0, `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`details`)), `error_message` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `flow_execution_logs_flow_execution_id_index` (`flow_execution_id`), CONSTRAINT `flow_execution_logs_flow_execution_id_foreign` FOREIGN KEY (`flow_execution_id`) REFERENCES `flow_executions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `flow_execution_logs` -- LOCK TABLES `flow_execution_logs` WRITE; /*!40000 ALTER TABLE `flow_execution_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `flow_execution_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `flow_executions` -- DROP TABLE IF EXISTS `flow_executions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `flow_executions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `flow_version_id` bigint(20) unsigned NOT NULL, `contact_id` bigint(20) unsigned NOT NULL, `conversation_id` bigint(20) unsigned DEFAULT NULL, `status` varchar(50) NOT NULL DEFAULT 'running', `current_node_id` varchar(100) NOT NULL, `context` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`context`)), `resume_after` timestamp NULL DEFAULT NULL, `last_error` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `flow_executions_tenant_id_foreign` (`tenant_id`), KEY `flow_executions_flow_version_id_foreign` (`flow_version_id`), KEY `flow_executions_contact_id_foreign` (`contact_id`), KEY `flow_executions_conversation_id_foreign` (`conversation_id`), KEY `flow_executions_status_resume_after_index` (`status`,`resume_after`), CONSTRAINT `flow_executions_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE, CONSTRAINT `flow_executions_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE SET NULL, CONSTRAINT `flow_executions_flow_version_id_foreign` FOREIGN KEY (`flow_version_id`) REFERENCES `flow_versions` (`id`) ON DELETE CASCADE, CONSTRAINT `flow_executions_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `flow_executions` -- LOCK TABLES `flow_executions` WRITE; /*!40000 ALTER TABLE `flow_executions` DISABLE KEYS */; /*!40000 ALTER TABLE `flow_executions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `flow_versions` -- DROP TABLE IF EXISTS `flow_versions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `flow_versions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `flow_id` bigint(20) unsigned NOT NULL, `version_number` int(10) unsigned NOT NULL, `definition` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`definition`)), `is_published` tinyint(1) NOT NULL DEFAULT 0, `created_by` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `flow_versions_flow_id_version_number_unique` (`flow_id`,`version_number`), KEY `flow_versions_created_by_foreign` (`created_by`), CONSTRAINT `flow_versions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tenant_users` (`id`) ON DELETE CASCADE, CONSTRAINT `flow_versions_flow_id_foreign` FOREIGN KEY (`flow_id`) REFERENCES `flows` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `flow_versions` -- LOCK TABLES `flow_versions` WRITE; /*!40000 ALTER TABLE `flow_versions` DISABLE KEYS */; /*!40000 ALTER TABLE `flow_versions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `flows` -- DROP TABLE IF EXISTS `flows`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `flows` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `trigger_type` varchar(50) NOT NULL, `channel_type` varchar(50) NOT NULL DEFAULT 'omnichannel', `is_active` tinyint(1) NOT NULL DEFAULT 0, `current_published_version_id` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `flows_tenant_id_is_active_index` (`tenant_id`,`is_active`), KEY `flows_current_published_version_id_foreign` (`current_published_version_id`), CONSTRAINT `flows_current_published_version_id_foreign` FOREIGN KEY (`current_published_version_id`) REFERENCES `flow_versions` (`id`) ON DELETE SET NULL, CONSTRAINT `flows_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `flows` -- LOCK TABLES `flows` WRITE; /*!40000 ALTER TABLE `flows` DISABLE KEYS */; /*!40000 ALTER TABLE `flows` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `knowledge_bases` -- DROP TABLE IF EXISTS `knowledge_bases`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `knowledge_bases` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `knowledge_bases_tenant_id_foreign` (`tenant_id`), CONSTRAINT `knowledge_bases_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `knowledge_bases` -- LOCK TABLES `knowledge_bases` WRITE; /*!40000 ALTER TABLE `knowledge_bases` DISABLE KEYS */; /*!40000 ALTER TABLE `knowledge_bases` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `knowledge_chunks` -- DROP TABLE IF EXISTS `knowledge_chunks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `knowledge_chunks` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `knowledge_source_id` bigint(20) unsigned NOT NULL, `chunk_index` int(11) NOT NULL, `content` longtext NOT NULL, `embedding` longtext NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `knowledge_chunks_knowledge_source_id_foreign` (`knowledge_source_id`), CONSTRAINT `knowledge_chunks_knowledge_source_id_foreign` FOREIGN KEY (`knowledge_source_id`) REFERENCES `knowledge_sources` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `knowledge_chunks` -- LOCK TABLES `knowledge_chunks` WRITE; /*!40000 ALTER TABLE `knowledge_chunks` DISABLE KEYS */; /*!40000 ALTER TABLE `knowledge_chunks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `knowledge_sources` -- DROP TABLE IF EXISTS `knowledge_sources`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `knowledge_sources` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `knowledge_base_id` bigint(20) unsigned NOT NULL, `source_type` varchar(255) NOT NULL, `source_name` varchar(255) NOT NULL, `source_metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`source_metadata`)), `status` varchar(255) NOT NULL DEFAULT 'pending', `error_reason` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `knowledge_sources_knowledge_base_id_foreign` (`knowledge_base_id`), CONSTRAINT `knowledge_sources_knowledge_base_id_foreign` FOREIGN KEY (`knowledge_base_id`) REFERENCES `knowledge_bases` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `knowledge_sources` -- LOCK TABLES `knowledge_sources` WRITE; /*!40000 ALTER TABLE `knowledge_sources` DISABLE KEYS */; /*!40000 ALTER TABLE `knowledge_sources` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `message_templates` -- DROP TABLE IF EXISTS `message_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `message_templates` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `channel_connection_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `category` varchar(255) NOT NULL DEFAULT 'utility', `language` varchar(255) NOT NULL DEFAULT 'en', `status` varchar(255) NOT NULL DEFAULT 'draft', `meta_template_id` varchar(255) DEFAULT NULL, `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`content`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `message_templates_channel_connection_id_foreign` (`channel_connection_id`), KEY `message_templates_tenant_id_type_index` (`tenant_id`,`type`), CONSTRAINT `message_templates_channel_connection_id_foreign` FOREIGN KEY (`channel_connection_id`) REFERENCES `channel_connections` (`id`) ON DELETE SET NULL, CONSTRAINT `message_templates_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `message_templates` -- LOCK TABLES `message_templates` WRITE; /*!40000 ALTER TABLE `message_templates` DISABLE KEYS */; /*!40000 ALTER TABLE `message_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `messages` -- DROP TABLE IF EXISTS `messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `conversation_id` bigint(20) unsigned NOT NULL, `direction` varchar(255) NOT NULL, `message_type` varchar(255) NOT NULL DEFAULT 'text', `sender_identifier` varchar(255) DEFAULT NULL, `body` text DEFAULT NULL, `media_url` varchar(255) DEFAULT NULL, `external_message_id` varchar(255) DEFAULT NULL, `delivery_status` varchar(255) NOT NULL DEFAULT 'sent', `error_message` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `messages_conversation_id_foreign` (`conversation_id`), KEY `messages_external_message_id_index` (`external_message_id`), CONSTRAINT `messages_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `messages` -- LOCK TABLES `messages` WRITE; /*!40000 ALTER TABLE `messages` DISABLE KEYS */; /*!40000 ALTER TABLE `messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'0001_01_01_000001_create_cache_table',1),(2,'0001_01_01_000002_create_jobs_table',1),(3,'2026_07_02_103141_create_personal_access_tokens_table',1),(4,'2026_07_08_000000_create_base_platform_tables',1),(5,'2026_07_08_000001_create_tenant_users_table',1),(6,'2026_07_09_000000_create_saas_admin_tables',1),(7,'2026_07_09_000001_add_stripe_product_id_to_plans_table',1),(8,'2026_07_09_000002_create_ai_provider_configs_table',1),(9,'2026_07_09_000003_create_rbac_and_teams_tables',1),(10,'2026_07_10_000000_create_crm_tables',1),(11,'2026_07_11_000000_create_pipeline_stages_table',1),(12,'2026_07_12_000000_create_tenant_google_tokens_table',1),(13,'2026_07_13_000000_create_channels_and_messages_tables',1),(14,'2026_07_14_000000_add_inbox_fields_to_conversations_table',1),(15,'2026_07_14_000001_create_rag_knowledge_tables',1),(16,'2026_07_15_000000_create_flows_tables',1),(17,'2026_07_15_000001_create_ai_agents_tables',1),(18,'2026_07_15_000002_create_message_templates_table',1),(19,'2026_07_15_000003_create_campaigns_tables',1),(20,'2026_07_15_095235_add_channel_type_to_flows_table',1),(21,'2026_07_15_103800_add_is_muted_to_contacts',1),(22,'2026_07_15_110140_create_crm_integrations_and_sync_logs_tables',1),(23,'2026_07_15_111737_add_metadata_to_crm_integrations_table',1),(24,'2026_07_15_160000_create_appointments_and_booking_tables',1),(25,'2026_07_15_170000_add_google_event_id_to_appointments',1),(26,'2026_07_15_180000_add_type_to_tenant_google_tokens',1),(27,'2026_07_15_190000_add_meeting_fields_to_bookings_and_appointments',1),(28,'2026_07_15_191000_create_tenant_meeting_tokens_table',1),(29,'2026_07_15_192000_backfill_type_in_tenant_google_tokens',1),(30,'2026_07_15_200000_add_language_to_tenant_users',1),(31,'2026_07_15_300000_create_notifications_table',1),(32,'2026_07_16_000000_create_support_tickets_tables',1),(33,'2026_07_18_000000_create_ecommerce_tables',1),(34,'2026_07_19_041211_create_saas_admin_settings_tables',1),(35,'2026_07_20_000001_create_admin_notifications_table',1),(36,'2026_07_21_000000_create_custom_pages_table',1),(37,'2026_08_11_170000_add_flow_id_to_campaigns_table',1),(38,'2026_08_23_000001_add_trigger_type_to_ai_agents_table',1),(39,'2026_08_23_173000_add_staff_and_resource_to_appointments_and_booking_links',1),(40,'2026_08_23_174000_create_staff_members_table',1),(41,'2026_08_23_181500_add_google_calendar_to_staff_members_table',1),(42,'2026_08_24_000001_add_flow_credits_to_plans_and_tenants',1),(43,'2026_08_24_000002_add_ai_operational_settings',1),(44,'2026_08_24_000003_add_provider_to_ai_agents_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `title` varchar(255) NOT NULL, `body` text NOT NULL, `type` varchar(255) NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_tenant_id_foreign` (`tenant_id`), KEY `notifications_user_id_foreign` (`user_id`), CONSTRAINT `notifications_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tenant_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_resets` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` text NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`), KEY `personal_access_tokens_expires_at_index` (`expires_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pipeline_stages` -- DROP TABLE IF EXISTS `pipeline_stages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pipeline_stages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `key` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `color` varchar(255) NOT NULL DEFAULT 'bg-zinc-100 text-zinc-700', `sort_order` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pipeline_stages_tenant_id_key_unique` (`tenant_id`,`key`), KEY `pipeline_stages_key_index` (`key`), CONSTRAINT `pipeline_stages_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pipeline_stages` -- LOCK TABLES `pipeline_stages` WRITE; /*!40000 ALTER TABLE `pipeline_stages` DISABLE KEYS */; /*!40000 ALTER TABLE `pipeline_stages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plan_prices` -- DROP TABLE IF EXISTS `plan_prices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `plan_prices` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `plan_id` bigint(20) unsigned NOT NULL, `currency_id` bigint(20) unsigned NOT NULL, `amount` int(11) NOT NULL, `stripe_price_id` varchar(255) DEFAULT NULL, `billing_interval` varchar(255) NOT NULL DEFAULT 'month', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `plan_prices_stripe_price_id_unique` (`stripe_price_id`), KEY `plan_prices_plan_id_foreign` (`plan_id`), KEY `plan_prices_currency_id_foreign` (`currency_id`), CONSTRAINT `plan_prices_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `plan_prices_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plan_prices` -- LOCK TABLES `plan_prices` WRITE; /*!40000 ALTER TABLE `plan_prices` DISABLE KEYS */; /*!40000 ALTER TABLE `plan_prices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plans` -- DROP TABLE IF EXISTS `plans`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `plans` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `stripe_product_id` varchar(255) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `trial_days` int(11) NOT NULL DEFAULT 0, `max_team_members` int(11) NOT NULL DEFAULT 1, `max_campaigns` int(11) NOT NULL DEFAULT 0, `max_integrations` int(11) NOT NULL DEFAULT 0, `own_crm_access` tinyint(1) NOT NULL DEFAULT 0, `max_channels` int(11) NOT NULL DEFAULT 0, `max_automations` int(11) NOT NULL DEFAULT 0, `flow_credits` int(11) NOT NULL DEFAULT 50, `sort_order` int(11) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plans` -- LOCK TABLES `plans` WRITE; /*!40000 ALTER TABLE `plans` DISABLE KEYS */; /*!40000 ALTER TABLE `plans` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `platform_settings` -- DROP TABLE IF EXISTS `platform_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `platform_settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `key` varchar(255) NOT NULL, `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`value`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `platform_settings_key_unique` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `platform_settings` -- LOCK TABLES `platform_settings` WRITE; /*!40000 ALTER TABLE `platform_settings` DISABLE KEYS */; INSERT INTO `platform_settings` VALUES (1,'ai_operational_model','\"byok\"','2026-08-25 03:57:57','2026-08-25 03:57:57',NULL),(2,'ai_providers_keys','{\"openai\":\"\",\"anthropic\":\"\",\"gemini\":\"\",\"groq\":\"\",\"deepseek\":\"\",\"xai\":\"\",\"mistral\":\"\",\"openrouter\":\"\"}','2026-08-25 03:57:57','2026-08-25 03:57:57',NULL),(3,'ai_feature_routing','{\"prompt_to_flow\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"flow_ai_condition\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"flow_ai_prompt\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"flow_rag_query\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"ai_agents\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"inbox_smart_reply\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"inbox_conversation_summary\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"contact_sentiment_analysis\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"knowledge_base_rag\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"},\"campaign_copywriter\":{\"provider\":\"openai\",\"model\":\"gpt-4o-mini\"}}','2026-08-25 03:57:57','2026-08-25 03:57:57',NULL),(4,'branding_name','\"WhatsOmni\"','2026-08-25 03:57:57','2026-08-25 03:57:57',NULL),(5,'branding_tagline','\"All-in-One Omnichannel Marketing, CRM & AI Automation Platform\"','2026-08-25 03:57:57','2026-08-25 03:57:57',NULL),(6,'support_email','\"support@whatsomni.com\"','2026-08-25 03:57:57','2026-08-25 03:57:57',NULL); /*!40000 ALTER TABLE `platform_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, `display_name` varchar(255) NOT NULL, `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `roles_tenant_id_foreign` (`tenant_id`), CONSTRAINT `roles_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,NULL,'owner','Owner','{\"dashboard\":[\"view\"],\"inbox\":[\"read\",\"write\"],\"contacts\":[\"read\",\"write\"],\"campaigns\":[\"read\",\"write\"],\"flows\":[\"read\",\"write\"],\"settings\":[\"read\",\"write\"]}','2026-08-25 03:57:57','2026-08-25 03:57:57'),(2,NULL,'admin','Admin','{\"dashboard\":[\"view\"],\"inbox\":[\"read\",\"write\"],\"contacts\":[\"read\",\"write\"],\"campaigns\":[\"read\",\"write\"],\"flows\":[\"read\",\"write\"],\"settings\":[\"read\",\"write\"]}','2026-08-25 03:57:57','2026-08-25 03:57:57'),(3,NULL,'manager','Manager','{\"dashboard\":[\"view\"],\"inbox\":[\"read\",\"write\"],\"contacts\":[\"read\",\"write\"],\"campaigns\":[\"read\",\"write\"],\"flows\":[\"read\",\"write\"],\"settings\":[\"read\"]}','2026-08-25 03:57:57','2026-08-25 03:57:57'),(4,NULL,'agent','Agent','{\"dashboard\":[\"view\"],\"inbox\":[\"read\",\"write\"],\"contacts\":[\"read\"],\"campaigns\":[],\"flows\":[],\"settings\":[]}','2026-08-25 03:57:57','2026-08-25 03:57:57'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `saas_admin_invitations` -- DROP TABLE IF EXISTS `saas_admin_invitations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `saas_admin_invitations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, `role_id` bigint(20) unsigned NOT NULL, `token` varchar(255) NOT NULL, `expires_at` datetime NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `saas_admin_invitations_email_unique` (`email`), UNIQUE KEY `saas_admin_invitations_token_unique` (`token`), KEY `saas_admin_invitations_role_id_foreign` (`role_id`), CONSTRAINT `saas_admin_invitations_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `saas_admin_roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `saas_admin_invitations` -- LOCK TABLES `saas_admin_invitations` WRITE; /*!40000 ALTER TABLE `saas_admin_invitations` DISABLE KEYS */; /*!40000 ALTER TABLE `saas_admin_invitations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `saas_admin_roles` -- DROP TABLE IF EXISTS `saas_admin_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `saas_admin_roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)), `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `saas_admin_roles` -- LOCK TABLES `saas_admin_roles` WRITE; /*!40000 ALTER TABLE `saas_admin_roles` DISABLE KEYS */; INSERT INTO `saas_admin_roles` VALUES (1,'Super Admin','[\"*\"]','2026-08-25 03:57:55','2026-08-25 03:57:55',NULL); /*!40000 ALTER TABLE `saas_admin_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `saas_admins` -- DROP TABLE IF EXISTS `saas_admins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `saas_admins` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` bigint(20) unsigned NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `last_login_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 `saas_admins_email_unique` (`email`), KEY `saas_admins_role_id_foreign` (`role_id`), CONSTRAINT `saas_admins_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `saas_admin_roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `saas_admins` -- LOCK TABLES `saas_admins` WRITE; /*!40000 ALTER TABLE `saas_admins` DISABLE KEYS */; INSERT INTO `saas_admins` VALUES (1,1,'Super','Admin','admin@whatsomni.com','$2y$12$WJoILjEEqjKX7zOwSecrxObJjeNlKQHUy/zlWjInMtUuGNVQ6LDka','active',NULL,'2026-08-25 03:57:57','2026-08-25 03:57:57',NULL); /*!40000 ALTER TABLE `saas_admins` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `staff_members` -- DROP TABLE IF EXISTS `staff_members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `staff_members` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `type` varchar(255) NOT NULL DEFAULT 'staff', `color` varchar(255) DEFAULT NULL, `avatar_url` text DEFAULT NULL, `working_hours` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`working_hours`)), `google_calendar_id` varchar(255) DEFAULT NULL, `google_sync_enabled` tinyint(1) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `staff_members_user_id_foreign` (`user_id`), KEY `staff_members_tenant_id_type_is_active_index` (`tenant_id`,`type`,`is_active`), CONSTRAINT `staff_members_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `staff_members_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tenant_users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `staff_members` -- LOCK TABLES `staff_members` WRITE; /*!40000 ALTER TABLE `staff_members` DISABLE KEYS */; /*!40000 ALTER TABLE `staff_members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `support_ticket_messages` -- DROP TABLE IF EXISTS `support_ticket_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `support_ticket_messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `support_ticket_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `message` text NOT NULL, `is_admin_reply` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `support_ticket_messages_support_ticket_id_foreign` (`support_ticket_id`), KEY `support_ticket_messages_user_id_foreign` (`user_id`), CONSTRAINT `support_ticket_messages_support_ticket_id_foreign` FOREIGN KEY (`support_ticket_id`) REFERENCES `support_tickets` (`id`) ON DELETE CASCADE, CONSTRAINT `support_ticket_messages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tenant_users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `support_ticket_messages` -- LOCK TABLES `support_ticket_messages` WRITE; /*!40000 ALTER TABLE `support_ticket_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `support_ticket_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `support_tickets` -- DROP TABLE IF EXISTS `support_tickets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `support_tickets` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `subject` varchar(255) NOT NULL, `description` text NOT NULL, `type` varchar(255) NOT NULL DEFAULT 'general', `status` varchar(255) NOT NULL DEFAULT 'open', `priority` varchar(255) NOT NULL DEFAULT 'medium', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `support_tickets_tenant_id_foreign` (`tenant_id`), KEY `support_tickets_user_id_foreign` (`user_id`), CONSTRAINT `support_tickets_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `support_tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tenant_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `support_tickets` -- LOCK TABLES `support_tickets` WRITE; /*!40000 ALTER TABLE `support_tickets` DISABLE KEYS */; /*!40000 ALTER TABLE `support_tickets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team_invitations` -- DROP TABLE IF EXISTS `team_invitations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `team_invitations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `email` varchar(255) NOT NULL, `role_id` bigint(20) unsigned NOT NULL, `team_id` bigint(20) unsigned DEFAULT NULL, `token` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `expires_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `team_invitations_token_unique` (`token`), KEY `team_invitations_tenant_id_foreign` (`tenant_id`), KEY `team_invitations_role_id_foreign` (`role_id`), KEY `team_invitations_team_id_foreign` (`team_id`), CONSTRAINT `team_invitations_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE, CONSTRAINT `team_invitations_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE SET NULL, CONSTRAINT `team_invitations_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team_invitations` -- LOCK TABLES `team_invitations` WRITE; /*!40000 ALTER TABLE `team_invitations` DISABLE KEYS */; /*!40000 ALTER TABLE `team_invitations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team_tenant_user` -- DROP TABLE IF EXISTS `team_tenant_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `team_tenant_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_user_id` bigint(20) unsigned NOT NULL, `team_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `team_tenant_user_tenant_user_id_foreign` (`tenant_user_id`), KEY `team_tenant_user_team_id_foreign` (`team_id`), CONSTRAINT `team_tenant_user_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE CASCADE, CONSTRAINT `team_tenant_user_tenant_user_id_foreign` FOREIGN KEY (`tenant_user_id`) REFERENCES `tenant_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team_tenant_user` -- LOCK TABLES `team_tenant_user` WRITE; /*!40000 ALTER TABLE `team_tenant_user` DISABLE KEYS */; /*!40000 ALTER TABLE `team_tenant_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `teams` -- DROP TABLE IF EXISTS `teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `teams` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `teams_tenant_id_foreign` (`tenant_id`), CONSTRAINT `teams_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `teams` -- LOCK TABLES `teams` WRITE; /*!40000 ALTER TABLE `teams` DISABLE KEYS */; /*!40000 ALTER TABLE `teams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tenant_google_tokens` -- DROP TABLE IF EXISTS `tenant_google_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tenant_google_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `type` varchar(255) DEFAULT NULL, `access_token` text NOT NULL, `refresh_token` text DEFAULT NULL, `expires_at` datetime NOT NULL, `email` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `tenant_google_tokens_tenant_id_foreign` (`tenant_id`), CONSTRAINT `tenant_google_tokens_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tenant_google_tokens` -- LOCK TABLES `tenant_google_tokens` WRITE; /*!40000 ALTER TABLE `tenant_google_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `tenant_google_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tenant_meeting_tokens` -- DROP TABLE IF EXISTS `tenant_meeting_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tenant_meeting_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `provider` varchar(255) NOT NULL, `access_token` text NOT NULL, `refresh_token` text DEFAULT NULL, `expires_at` datetime NOT NULL, `email` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tenant_meeting_tokens_tenant_id_provider_unique` (`tenant_id`,`provider`), CONSTRAINT `tenant_meeting_tokens_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tenant_meeting_tokens` -- LOCK TABLES `tenant_meeting_tokens` WRITE; /*!40000 ALTER TABLE `tenant_meeting_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `tenant_meeting_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tenant_users` -- DROP TABLE IF EXISTS `tenant_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tenant_users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint(20) unsigned NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `role_id` bigint(20) unsigned DEFAULT NULL, `language` varchar(5) NOT NULL DEFAULT 'en', `status` varchar(255) NOT NULL DEFAULT 'pending', `email_verified_at` timestamp NULL DEFAULT NULL, `last_login_at` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) 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 `tenant_users_email_unique` (`email`), KEY `tenant_users_tenant_id_foreign` (`tenant_id`), KEY `tenant_users_role_id_foreign` (`role_id`), CONSTRAINT `tenant_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE SET NULL, CONSTRAINT `tenant_users_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tenant_users` -- LOCK TABLES `tenant_users` WRITE; /*!40000 ALTER TABLE `tenant_users` DISABLE KEYS */; /*!40000 ALTER TABLE `tenant_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tenants` -- DROP TABLE IF EXISTS `tenants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tenants` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `company_name` varchar(255) NOT NULL, `team_size` varchar(255) DEFAULT NULL, `industry_category` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'trial', `onboarding_step` varchar(255) NOT NULL DEFAULT '1', `currency_id` bigint(20) unsigned DEFAULT NULL, `stripe_customer_id` varchar(255) DEFAULT NULL, `stripe_subscription_id` varchar(255) DEFAULT NULL, `plan_id` bigint(20) unsigned DEFAULT NULL, `used_flow_credits` int(11) NOT NULL DEFAULT 0, `default_language` varchar(5) NOT NULL DEFAULT 'en', `custom_mailer_type` varchar(255) DEFAULT NULL, `custom_mailer_config` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `tenants_currency_id_foreign` (`currency_id`), KEY `tenants_plan_id_foreign` (`plan_id`), CONSTRAINT `tenants_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE SET NULL, CONSTRAINT `tenants_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tenants` -- LOCK TABLES `tenants` WRITE; /*!40000 ALTER TABLE `tenants` DISABLE KEYS */; /*!40000 ALTER TABLE `tenants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_sessions` -- DROP TABLE IF EXISTS `user_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `user_sessions_user_id_foreign` (`user_id`), KEY `user_sessions_last_activity_index` (`last_activity`), CONSTRAINT `user_sessions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tenant_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_sessions` -- LOCK TABLES `user_sessions` WRITE; /*!40000 ALTER TABLE `user_sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `user_sessions` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-08-25 14:58:06