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

CREATE TABLE `profiles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `bio` text,
  `avatar_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `profiles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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


--
-- Table structure for table `project_members`
--

CREATE TABLE `project_members` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `user_id` int NOT NULL,
  `role` enum('owner','collaborator','viewer') NOT NULL DEFAULT 'collaborator',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_project_user` (`project_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `project_members`
--

INSERT INTO `project_members` VALUES (1,1,1,'owner');

--
-- Table structure for table `project_parts`
--

CREATE TABLE `project_parts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `progress` int NOT NULL DEFAULT '0',
  `sort_order` int NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`),
  CONSTRAINT `project_parts_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `project_parts`
--

INSERT INTO `project_parts` VALUES (1,1,'LivingWorld','the games world lives and changes towns  can be built along with economies that effect the actual players world.',0,1,'2026-01-12 00:01:06','2026-01-12 00:01:19'),(2,1,'RecruitableCastNpcs','random npc generation for side cast recruitable characters that age and evoloved if they die their child takes over or their student.',0,2,'2026-01-12 00:03:33',NULL),(3,1,'ABS sprites','sprites for the active battle system secret of mana style',0,3,'2026-01-13 05:40:12',NULL),(4,1,'Live title screen','the title screen is actually a previous experienced event scenario replay loop...',0,4,'2026-01-13 05:41:55',NULL),(5,1,'OnlineCo-op','ability to have friends join you online with cross character progression',0,5,'2026-01-13 05:42:53',NULL),(6,1,'Split Screen','allows for couch coop split screen ????',0,6,'2026-01-13 05:43:44',NULL);

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `status` enum('planned','active','on_hold','completed','cancelled') NOT NULL DEFAULT 'planned',
  `priority` enum('low','normal','high','critical') NOT NULL DEFAULT 'normal',
  `owner_id` int NOT NULL,
  `client_user_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `progress` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES (1,'RpgGame 1','based off in progress nameless book','planned','normal',1,NULL,'2026-01-11 23:14:26','2026-01-13 05:43:44','2022-12-04',NULL,0);

--
-- Table structure for table `remote_audit_logs`
--

CREATE TABLE `remote_audit_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `session_id` int DEFAULT NULL,
  `connection_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `action` varchar(80) NOT NULL,
  `ip_address` varchar(64) DEFAULT NULL,
  `user_agent` text,
  `details` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_remote_audit_session` (`session_id`),
  KEY `idx_remote_audit_action` (`action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_audit_logs`
--


--
-- Table structure for table `remote_connections`
--

CREATE TABLE `remote_connections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `protocol` enum('rdp','vnc','ssh') NOT NULL DEFAULT 'rdp',
  `hostname` varchar(255) NOT NULL,
  `port` int NOT NULL DEFAULT '3389',
  `username` varchar(255) DEFAULT NULL,
  `password_encrypted` text,
  `domain_name` varchar(255) DEFAULT NULL,
  `security_mode` varchar(50) DEFAULT NULL,
  `ignore_cert` tinyint(1) NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `notes` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_connections`
--


--
-- Table structure for table `remote_screenshare_sessions`
--

CREATE TABLE `remote_screenshare_sessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `remote_session_id` int DEFAULT NULL,
  `ticket_id` int DEFAULT NULL,
  `customer_user_id` int DEFAULT NULL,
  `technician_user_id` int DEFAULT NULL,
  `requested_by` int DEFAULT NULL,
  `share_token` varchar(128) NOT NULL,
  `technician_token` varchar(128) NOT NULL,
  `status` enum('pending','waiting','active','ended','expired','revoked','denied') NOT NULL DEFAULT 'pending',
  `customer_started_at` datetime DEFAULT NULL,
  `technician_joined_at` datetime DEFAULT NULL,
  `ended_at` datetime DEFAULT NULL,
  `expires_at` datetime NOT NULL,
  `customer_note` text,
  `internal_note` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `share_token` (`share_token`),
  UNIQUE KEY `technician_token` (`technician_token`),
  KEY `idx_screenshare_status` (`status`),
  KEY `idx_screenshare_expires` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_screenshare_sessions`
--


--
-- Table structure for table `remote_screenshare_signals`
--

CREATE TABLE `remote_screenshare_signals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `screenshare_id` int NOT NULL,
  `sender` enum('customer','technician') NOT NULL,
  `receiver` enum('customer','technician') NOT NULL,
  `signal_type` varchar(50) NOT NULL,
  `payload` longtext NOT NULL,
  `consumed` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_signal_session_receiver` (`screenshare_id`,`receiver`,`consumed`),
  CONSTRAINT `fk_screenshare_signals_session` FOREIGN KEY (`screenshare_id`) REFERENCES `remote_screenshare_sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_screenshare_signals`
--


--
-- Table structure for table `remote_sessions`
--

CREATE TABLE `remote_sessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `connection_id` int NOT NULL,
  `ticket_id` int DEFAULT NULL,
  `customer_user_id` int DEFAULT NULL,
  `technician_user_id` int DEFAULT NULL,
  `requested_by` int DEFAULT NULL,
  `approval_token` varchar(128) NOT NULL,
  `launch_token` varchar(128) DEFAULT NULL,
  `status` enum('pending','approved','active','ended','expired','revoked','denied') NOT NULL DEFAULT 'pending',
  `customer_approved_at` datetime DEFAULT NULL,
  `technician_started_at` datetime DEFAULT NULL,
  `ended_at` datetime DEFAULT NULL,
  `expires_at` datetime NOT NULL,
  `customer_note` text,
  `internal_note` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `approval_token` (`approval_token`),
  UNIQUE KEY `launch_token` (`launch_token`),
  KEY `idx_remote_sessions_status` (`status`),
  KEY `idx_remote_sessions_expires` (`expires_at`),
  KEY `fk_remote_sessions_connection` (`connection_id`),
  CONSTRAINT `fk_remote_sessions_connection` FOREIGN KEY (`connection_id`) REFERENCES `remote_connections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_sessions`
--


--
-- Table structure for table `room_members`
--

CREATE TABLE `room_members` (
  `id` int NOT NULL AUTO_INCREMENT,
  `room_id` int NOT NULL,
  `user_id` int NOT NULL,
  `joined_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_membership` (`room_id`,`user_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `room_members_ibfk_1` FOREIGN KEY (`room_id`) REFERENCES `chat_rooms` (`id`),
  CONSTRAINT `room_members_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `room_members`
--


--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `visibility` enum('public','sales','staff','admin','private') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'public',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` VALUES (1,'General','2025-11-30 09:00:42','public'),(2,'TechSupport','2025-11-30 09:06:01','public'),(3,'Investment Project','2025-12-23 12:49:22','public'),(4,'Sales Questions','2026-01-07 00:26:22','public');

--
-- Table structure for table `sales_activity`
--

CREATE TABLE `sales_activity` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sales_id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `detail` text,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sales_activity`
--


--
-- Table structure for table `sales_inquiries`
--

CREATE TABLE `sales_inquiries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `build_id` int NOT NULL,
  `room` varchar(100) NOT NULL,
  `initial_message` text NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sales_inquiries`
--

INSERT INTO `sales_inquiries` VALUES (1,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 00:44:30'),(2,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 00:46:26'),(3,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:18:40'),(4,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:21:30'),(5,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:23:07'),(6,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:24:18'),(7,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:29:46'),(8,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:43:03'),(9,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:43:26'),(10,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 05:32:00'),(11,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 05:47:17'),(12,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 05:56:44'),(13,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 06:02:25'),(14,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 06:08:59');

--
-- Table structure for table `sales_notes`
--

CREATE TABLE `sales_notes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sales_id` int NOT NULL,
  `user_id` int NOT NULL,
  `note` text NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sales_notes`
--


--
-- Table structure for table `sales_queue`
--

CREATE TABLE `sales_queue` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `build_id` int DEFAULT NULL,
  `message` text,
  `status` enum('lead','qualified','quote_sent','negotiation','closed_won','closed_lost') DEFAULT 'lead',
  `assigned_to` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sales_queue`
--

INSERT INTO `sales_queue` VALUES (3,3,'Henrietta Williams','henrietta.williams@testemail.com','18035651866',NULL,'New sales lead created. $350 dollar laptop package refurbished with 2 year warranty','lead',NULL,'2026-01-23 00:06:36','2026-01-23 00:08:54');

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `price` decimal(10,2) NOT NULL,
  `active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (1,'Virus Removal Tier 1','We will scan your computer for viruses with a deeper scanner and attempt to remove the virus. This is the non intrusive method.',50.00,1),(2,'Wireless Security Camera Install','<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>ieGeek Wireless Security Camera Breakdown</title>\r\n\r\n<style>\r\nbody{\r\n    font-family: Arial, sans-serif;\r\n    background:#f4f6f9;\r\n    color:#222;\r\n    margin:0;\r\n    padding:0;\r\n    line-height:1.6;\r\n}\r\n\r\n.container{\r\n    width:90%;\r\n    max-width:1200px;\r\n    margin:auto;\r\n    padding:40px 20px;\r\n}\r\n\r\n.hero{\r\n    text-align:center;\r\n    padding:60px 20px;\r\n    background:linear-gradient(135deg,#0d1b2a,#1b263b);\r\n    color:white;\r\n    border-radius:12px;\r\n    margin-bottom:40px;\r\n}\r\n\r\n.hero h1{\r\n    font-size:48px;\r\n    margin-bottom:15px;\r\n}\r\n\r\n.hero p{\r\n    font-size:18px;\r\n    max-width:800px;\r\n    margin:auto;\r\n}\r\n\r\n.section-title{\r\n    font-size:32px;\r\n    margin-bottom:20px;\r\n    color:#0d1b2a;\r\n}\r\n\r\n.features{\r\n    display:grid;\r\n    grid-template-columns:repeat(auto-fit,minmax(250px,1fr));\r\n    gap:25px;\r\n    margin-bottom:50px;\r\n}\r\n\r\n.card{\r\n    background:white;\r\n    border-radius:12px;\r\n    overflow:hidden;\r\n    box-shadow:0 4px 12px rgba(0,0,0,0.1);\r\n    transition:0.3s;\r\n}\r\n\r\n.card:hover{\r\n    transform:translateY(-5px);\r\n}\r\n\r\n.card img{\r\n    width:100%;\r\n    height:220px;\r\n    object-fit:cover;\r\n}\r\n\r\n.card-content{\r\n    padding:20px;\r\n}\r\n\r\n.card h3{\r\n    margin-top:0;\r\n    color:#1b263b;\r\n}\r\n\r\n.pros-cons{\r\n    display:grid;\r\n    grid-template-columns:1fr 1fr;\r\n    gap:30px;\r\n    margin-top:40px;\r\n}\r\n\r\n.box{\r\n    background:white;\r\n    padding:25px;\r\n    border-radius:12px;\r\n    box-shadow:0 4px 10px rgba(0,0,0,0.08);\r\n}\r\n\r\n.box h3{\r\n    margin-top:0;\r\n}\r\n\r\nul{\r\n    padding-left:20px;\r\n}\r\n\r\ntable{\r\n    width:100%;\r\n    border-collapse:collapse;\r\n    background:white;\r\n    margin-top:40px;\r\n    border-radius:12px;\r\n    overflow:hidden;\r\n    box-shadow:0 4px 12px rgba(0,0,0,0.08);\r\n}\r\n\r\ntable th, table td{\r\n    padding:15px;\r\n    border-bottom:1px solid #ddd;\r\n    text-align:left;\r\n}\r\n\r\ntable th{\r\n    background:#1b263b;\r\n    color:white;\r\n}\r\n\r\n.footer{\r\n    text-align:center;\r\n    padding:40px 20px;\r\n    color:#777;\r\n}\r\n</style>\r\n</head>\r\n\r\n<body>\r\n\r\n<div class=\"container\">\r\n\r\n    <div class=\"hero\">\r\n        <h1>ieGeek Wireless Security Cameras</h1>\r\n        <p>\r\n            Affordable smart home surveillance featuring wireless installation,\r\n            solar-powered operation, AI motion detection, and HD night vision monitoring.\r\n        </p>\r\n    </div>\r\n\r\n    <h2 class=\"section-title\">Top Features</h2>\r\n\r\n    <div class=\"features\">\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1558002038-1055907df827?q=80&w=1200&auto=format&fit=crop\" alt=\"Outdoor Security Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>2K HD Video</h3>\r\n                <p>\r\n                    Crystal-clear video quality with enhanced color night vision\r\n                    for detailed monitoring day and night.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1509395176047-4a66953fd231?q=80&w=1200&auto=format&fit=crop\" alt=\"Solar Powered Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>Solar Powered</h3>\r\n                <p>\r\n                    Long-lasting rechargeable battery systems with optional solar charging\r\n                    reduce maintenance and downtime.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1516321318423-f06f85e504b3?q=80&w=1200&auto=format&fit=crop\" alt=\"Mobile App Monitoring\">\r\n            <div class=\"card-content\">\r\n                <h3>Smart App Control</h3>\r\n                <p>\r\n                    Monitor your property remotely through mobile apps with instant\r\n                    push notifications and live video access.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1520607162513-77705c0f0d4a?q=80&w=1200&auto=format&fit=crop\" alt=\"AI Motion Detection\">\r\n            <div class=\"card-content\">\r\n                <h3>AI Motion Detection</h3>\r\n                <p>\r\n                    Intelligent motion tracking helps detect people, vehicles,\r\n                    and suspicious activity while reducing false alerts.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n    </div>\r\n\r\n    <h2 class=\"section-title\">Popular ieGeek Models</h2>\r\n\r\n    <div class=\"features\">\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1557324232-b8917d3c3dcb?q=80&w=1200&auto=format&fit=crop\" alt=\"Outdoor Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>ieGeek Solar Camera Q11</h3>\r\n                <p>\r\n                    Wireless outdoor security camera with solar charging,\r\n                    360° PTZ rotation, and 2K HD video recording.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1495435229349-e86db7bfa013?q=80&w=1200&auto=format&fit=crop\" alt=\"4G LTE Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>ieGeek 4G LTE Camera</h3>\r\n                <p>\r\n                    Perfect for farms, cabins, RVs, and remote areas without Wi-Fi\r\n                    using built-in cellular connectivity.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1516321497487-e288fb19713f?q=80&w=1200&auto=format&fit=crop\" alt=\"Indoor Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>ieGeek Indoor PTZ Camera</h3>\r\n                <p>\r\n                    Compact indoor monitoring system with smart tracking,\r\n                    pet monitoring, and two-way audio support.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n    </div>\r\n\r\n    <div class=\"pros-cons\">\r\n\r\n        <div class=\"box\">\r\n            <h3>Pros</h3>\r\n            <ul>\r\n                <li>Easy wireless installation</li>\r\n                <li>Affordable pricing</li>\r\n                <li>Solar charging options</li>\r\n                <li>AI smart motion detection</li>\r\n                <li>Color night vision support</li>\r\n                <li>Mobile app monitoring</li>\r\n            </ul>\r\n        </div>\r\n\r\n        <div class=\"box\">\r\n            <h3>Considerations</h3>\r\n            <ul>\r\n                <li>Requires stable Wi-Fi for most models</li>\r\n                <li>Cloud storage may require subscription</li>\r\n                <li>Battery life varies with activity</li>\r\n                <li>Some advanced features depend on app updates</li>\r\n            </ul>\r\n        </div>\r\n\r\n    </div>\r\n\r\n    <h2 class=\"section-title\">Feature Comparison</h2>\r\n\r\n    <table>\r\n        <tr>\r\n            <th>Feature</th>\r\n            <th>Q11 Solar</th>\r\n            <th>4G LTE</th>\r\n            <th>Indoor PTZ</th>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Resolution</td>\r\n            <td>2K HD</td>\r\n            <td>2K HD</td>\r\n            <td>2.5K HD</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Connectivity</td>\r\n            <td>Wi-Fi</td>\r\n            <td>4G LTE</td>\r\n            <td>Wi-Fi</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Solar Powered</td>\r\n            <td>Yes</td>\r\n            <td>Yes</td>\r\n            <td>No</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>PTZ Rotation</td>\r\n            <td>360°</td>\r\n            <td>360°</td>\r\n            <td>360°</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Night Vision</td>\r\n            <td>Color</td>\r\n            <td>Color</td>\r\n            <td>Infrared</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Best Use</td>\r\n            <td>Home Security</td>\r\n            <td>Remote Locations</td>\r\n            <td>Indoor Monitoring</td>\r\n        </tr>\r\n    </table>\r\n\r\n    <div class=\"footer\">\r\n        © 2026 ieGeek Camera Breakdown — Smart Wireless Home Security\r\n    </div>\r\n\r\n</div>\r\n\r\n</body>\r\n</html>requires a onsite review first to see where camera can be mounted and what will be needed for full install.',130.00,1);

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

CREATE TABLE `settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` varchar(255) NOT NULL,
  `site_name` varchar(255) NOT NULL DEFAULT 'ZPanel Omega',
  `maintenance` tinyint(1) NOT NULL DEFAULT '0',
  `current_version` varchar(50) NOT NULL DEFAULT '1.0.0',
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_key` (`setting_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `settings` VALUES (1,'','','ZPanel Omega',0,'1.0.0',NULL);

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int NOT NULL,
  `site_name` varchar(255) NOT NULL DEFAULT 'ZPanel Omega',
  `maintenance` tinyint(1) NOT NULL DEFAULT '0',
  `current_version` varchar(50) NOT NULL DEFAULT '1.0.0',
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` VALUES (1,'StudioExceliaZeroLLC',0,'1.0.0','2026-06-02 23:37:41');

--
-- Table structure for table `subscription_billing`
--

CREATE TABLE `subscription_billing` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subscription_id` int NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `billing_status` varchar(30) NOT NULL DEFAULT 'pending',
  `paid_at` datetime DEFAULT NULL,
  `gateway` varchar(50) DEFAULT 'manual',
  `transaction_ref` varchar(150) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_subscription_billing_subscription` (`subscription_id`),
  CONSTRAINT `fk_subscription_billing_subscription` FOREIGN KEY (`subscription_id`) REFERENCES `customer_subscriptions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subscription_billing`
--


--
-- Table structure for table `subscription_features`
--

CREATE TABLE `subscription_features` (
  `id` int NOT NULL AUTO_INCREMENT,
  `plan_id` int NOT NULL,
  `feature_name` varchar(150) NOT NULL,
  `feature_value` varchar(150) DEFAULT '',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_subscription_features_plan` (`plan_id`),
  CONSTRAINT `fk_subscription_features_plan` FOREIGN KEY (`plan_id`) REFERENCES `subscription_plans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subscription_features`
--

INSERT INTO `subscription_features` VALUES (1,1,'Priority Support','Included','2026-04-01 00:41:22'),(2,1,'Malware Cleanup','Included','2026-04-01 00:41:22'),(3,2,'Performance Tuning','Included','2026-04-01 00:41:22'),(4,2,'Upgrade Guidance','Included','2026-04-01 00:41:22'),(5,3,'Managed Device Support','Included','2026-04-01 00:41:22'),(6,3,'Priority Ticket Queue','Included','2026-04-01 00:41:22');

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `tagline` varchar(150) DEFAULT NULL,
  `description` text,
  `monthly_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `yearly_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subscription_plans`
--

INSERT INTO `subscription_plans` VALUES (1,'Home Care','Best for home users','Routine care, security cleanup, and faster support response.',10.99,100.99,1,1,'2026-04-01 00:41:22'),(2,'Power User','For gamers and creators','Performance tuning, upgrade guidance, and priority support.',39.99,399.99,2,1,'2026-04-01 00:41:22'),(3,'Small Business IT','Managed support for business devices','Workstation support, maintenance coverage, and ticket priority.',99.99,999.99,3,1,'2026-04-01 00:41:22');

--
-- Table structure for table `system_versions`
--

CREATE TABLE `system_versions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `version` varchar(50) NOT NULL,
  `description` text,
  `backup_path` varchar(255) DEFAULT NULL,
  `applied_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `status` enum('applied','rolled_back') DEFAULT 'applied',
  `folders` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `system_versions`
--


--
-- Table structure for table `task_comments`
--

CREATE TABLE `task_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `task_id` int NOT NULL,
  `user_id` int NOT NULL,
  `comment` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `task_comments`
--


--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `status` enum('backlog','in_progress','in_review','done') NOT NULL DEFAULT 'backlog',
  `priority` enum('low','normal','high','critical') NOT NULL DEFAULT 'normal',
  `assignee_id` int DEFAULT NULL,
  `created_by` int NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `related_ticket_id` int DEFAULT NULL,
  `related_build_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tasks`
--


--
-- Table structure for table `technician_certificates`
--

CREATE TABLE `technician_certificates` (
  `technician_id` int NOT NULL,
  `certificate_id` int NOT NULL,
  PRIMARY KEY (`technician_id`,`certificate_id`),
  KEY `certificate_id` (`certificate_id`),
  CONSTRAINT `technician_certificates_ibfk_1` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE,
  CONSTRAINT `technician_certificates_ibfk_2` FOREIGN KEY (`certificate_id`) REFERENCES `certificates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `technician_certificates`
--


--
-- Table structure for table `technician_certifications`
--

CREATE TABLE `technician_certifications` (
  `technician_id` int NOT NULL,
  `certification_id` int NOT NULL,
  PRIMARY KEY (`technician_id`,`certification_id`),
  KEY `certification_id` (`certification_id`),
  CONSTRAINT `technician_certifications_ibfk_1` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE,
  CONSTRAINT `technician_certifications_ibfk_2` FOREIGN KEY (`certification_id`) REFERENCES `certifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `technician_certifications`
--


--
-- Table structure for table `technician_events`
--

CREATE TABLE `technician_events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `technician_id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `technician_id` (`technician_id`),
  CONSTRAINT `technician_events_ibfk_1` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `technician_events`
--


--
-- Table structure for table `technicians`
--

CREATE TABLE `technicians` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(150) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `specialty` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `user_id` (`user_id`),
  CONSTRAINT `fk_technician_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `technicians`
--

INSERT INTO `technicians` VALUES (1,'Jarvis Jones','bluecometspt@gmail.com','8037201716','repair','2025-11-24 04:45:26',1);

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `dir` varchar(255) DEFAULT NULL,
  `css` text,
  `layout_config` json DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `image_url` varchar(255) DEFAULT NULL,
  `primary_color` varchar(50) DEFAULT 'dark',
  `banner_image` varchar(255) DEFAULT NULL,
  `active` tinyint(1) DEFAULT '0',
  `color` varchar(20) NOT NULL DEFAULT '#333',
  `banner` varchar(255) NOT NULL DEFAULT '/assets/images/default-banner.jpg',
  `is_default` tinyint(1) DEFAULT '0',
  `layout_style` enum('vertical_nav','horizontal_nav') NOT NULL DEFAULT 'vertical_nav',
  `debug_mode` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `themes_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` VALUES (20,'ZPanelOmega Default',NULL,NULL,NULL,NULL,'2025-11-25 10:23:03',NULL,'dark',NULL,0,'#333','/assets/images/zpobanner2.png',1,'vertical_nav',0),(21,'Default Theme',NULL,NULL,NULL,NULL,'2025-11-25 10:45:22',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',NULL,'vertical_nav',0),(22,'ZPanelOmega Blue',NULL,NULL,NULL,NULL,'2025-11-25 10:45:58',NULL,'dark',NULL,0,'#0066cc','/assets/images/zpobanner2.png',0,'vertical_nav',0),(26,'Random Theme',NULL,NULL,NULL,NULL,'2025-11-27 14:55:55',NULL,'danger','https://source.unsplash.com/1200x300/?network',0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(29,'DIY PC Build',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'info','/assets/images/pc_build.jpg',0,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(30,'ZPanel Classic',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'primary','/assets/images/zpanel.jpg',0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(31,'gamer-neon',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'danger','themes/gamer-neon/assets/images/gamer_neon.png',0,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(32,'Coding Matrix',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'success','https://source.unsplash.com/1200x300/?coding',0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(33,'Server Rack',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'secondary','https://source.unsplash.com/1200x300/?server',0,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(34,'Mahan',NULL,NULL,NULL,NULL,'2025-11-29 13:27:37',NULL,'dark','https://zpanelomega.exodusblue.com/themes/Mahan/assets/images/banner1Solomon.png',0,'#333','https://zpanelomega.exodusblue.com/themes/Mahan/assets/images/banner1Solomon.png',0,'vertical_nav',0),(35,'MidnightGlass',NULL,NULL,NULL,NULL,'2026-01-11 12:23:03',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(36,'AdminDash_default',NULL,NULL,NULL,NULL,'2026-01-11 12:51:32',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(37,'xenogearsgodandmind',NULL,NULL,NULL,NULL,'2026-01-20 02:08:37',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(41,'MidnightRepairPro',NULL,NULL,NULL,NULL,'2026-03-28 16:04:53',NULL,'dark',NULL,1,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(42,'RepairMidnightPro',NULL,NULL,NULL,NULL,'2026-03-28 16:15:19',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0);

--
-- Table structure for table `ticket_comments`
--

CREATE TABLE `ticket_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ticket_id` int NOT NULL,
  `user_id` int NOT NULL,
  `username` varchar(100) NOT NULL,
  `comment` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `ticket_comments_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ticket_comments_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ticket_comments`
--

INSERT INTO `ticket_comments` VALUES (1,1,1,'admin','test','2025-12-01 00:49:52');

--
-- Table structure for table `ticket_replies`
--

CREATE TABLE `ticket_replies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ticket_id` int NOT NULL,
  `user_id` int NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `ticket_replies_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ticket_replies_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ticket_replies`
--


--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int DEFAULT NULL,
  `sales_id` int DEFAULT NULL,
  `build_id` int DEFAULT NULL,
  `submitted_by` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `problem_description` text,
  `notes` text,
  `priority` enum('Low','Medium','High','Critical') DEFAULT 'Low',
  `status` enum('Open','Closed') DEFAULT 'Open',
  `user_id` int NOT NULL,
  `technician_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `assigned_to` int DEFAULT NULL,
  `ticket_type` varchar(50) DEFAULT 'General Support',
  `subscription_id` int DEFAULT NULL,
  `service_level` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `technician_id` (`technician_id`),
  CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`technician_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` VALUES (1,NULL,NULL,NULL,'','test ticket','test ticket is a ticket test',NULL,NULL,'Low','Closed',1,NULL,'2025-11-25 03:50:20',NULL,NULL,'General Support',NULL,NULL),(2,NULL,NULL,NULL,'','test ticket','test ticket is a ticket test',NULL,NULL,'Low','Closed',1,NULL,'2025-11-25 03:51:10',NULL,NULL,'General Support',NULL,NULL),(3,NULL,NULL,NULL,'','test ticket','test ticket is a ticket test',NULL,NULL,'Low','Closed',1,2,'2025-11-25 03:51:17','2026-01-17 22:38:28',NULL,'General Support',NULL,NULL),(4,9,NULL,NULL,'admin','Laptop Purchase','Laptop Purchase compeleted for henrietta williams usb wireless used for internet adaptation. Purchase of firestick and antenna will complete order and those will be payed for.','Laptop Purchase compeleted for henrietta williams usb wireless used for internet adaptation. Purchase of firestick and antenna will complete order and those will be payed for.','Laptop Purchase compeleted for henrietta williams usb wireless used for internet adaptation. Purchase of firestick and antenna will complete order and those will be payed for.','Low','Open',1,1,'2026-01-20 01:43:26','2026-03-29 21:12:57',1,'General Support',NULL,NULL),(5,10,NULL,NULL,'damedash666','Computer Ransomware atempt','Hey J I made a mistake and let some people into my pc and need you to help me get it fixed thanks so much!','Hey J I made a mistake and let some people into my pc and need you to help me get it fixed thanks so much!','system reimaged updated to windows 11 and 12gb of ram. antivirus installed and user personal files restored from one drive. Remote assistances apps also installed incase customer needs further remote assistance. Completed and Installed on site Malbytes antimalware added to system $100','High','Closed',10,1,'2026-03-22 00:50:37','2026-03-29 18:13:02',1,'General Support',NULL,NULL),(19,NULL,NULL,NULL,'admin','Wireless Security Camera Install - test','test','test','Service Type: Wireless Security Camera Install\nCustomer: test\nEmail: bluecometspt@gmail.com\nPhone: 8037201716\nDevice: ','Medium','Open',1,NULL,'2026-05-25 20:54:00','2026-05-25 20:54:00',NULL,'General Support',NULL,'Standard'),(20,NULL,NULL,NULL,'admin','Wireless Security Camera Install - test','test','test','Service Type: Wireless Security Camera Install\nCustomer: test\nEmail: bluecometspt@gmail.com\nPhone: 8037201716\nDevice: ','Medium','Open',1,NULL,'2026-05-25 21:06:13','2026-05-25 21:06:13',NULL,'General Support',NULL,'Standard'),(21,NULL,NULL,NULL,'admin','Wireless Security Camera Install - wireless set','I am inquiring about the wireless security setup','I am inquiring about the wireless security setup','Service Type: Wireless Security Camera Install\nCustomer: test\nEmail: temoneyn@yahoo.com\nPhone: 8037201716\nDevice: ','Medium','Open',1,NULL,'2026-05-30 22:20:05','2026-05-30 22:20:05',NULL,'General Support',NULL,'Standard');

--
-- Table structure for table `tos_acceptance`
--

CREATE TABLE `tos_acceptance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `tos_version` varchar(20) NOT NULL,
  `accepted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `tos_acceptance_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tos_acceptance`
--


--
-- Table structure for table `tos_versions`
--

CREATE TABLE `tos_versions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `version` varchar(20) NOT NULL,
  `content` longtext NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tos_versions`
--


--
-- Table structure for table `twitch_settings`
--

CREATE TABLE `twitch_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `channel_name` varchar(255) DEFAULT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `client_secret` varchar(255) DEFAULT NULL,
  `access_token` varchar(255) DEFAULT NULL,
  `rotation_streams` text,
  `token_expires_at` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `twitch_settings`
--

INSERT INTO `twitch_settings` VALUES (1,'xowilough','c40ga904vv7xjhau98lclt3p9qsb8c','u18659uiw25azhh4cdbd9kbb7wmhvv','8rjdjx39f93i17t1s7bd25csr16kf1','nekrotechie,babybaby1111,xowilough',1778993625);

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `avatar_url` varchar(255) DEFAULT NULL,
  `role` enum('admin','editor','technician','user') DEFAULT 'user',
  `status` enum('online','offline') DEFAULT 'offline',
  `last_seen` timestamp NULL DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `bio` text,
  `skills` varchar(255) DEFAULT NULL,
  `online` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'admin','$2y$10$Qc5tMVu7kGj/.6SPuO6wf.BnwFMZsgDgDhUgc/vGEy3uBauCusXRi','bluecometspt@gmail.com','https://preview.redd.it/48ptt9a8r3g41.jpg?width=640&crop=smart&auto=webp&s=ba84923ca410f172ffd4d7b2c23340468a7945c8','admin','online','2026-06-13 21:41:58','2025-11-24 02:36:31','',NULL,0),(2,'nekrotechie','$2y$10$LyrQdLkIblE4TD8J7JjSeeYvXzAywHdrxoPXDVmQeG5aYXh5UBnQy','jphgfx@gmail.com','','technician','offline','2026-01-19 11:46:39','2025-11-24 03:01:49','','[]',0),(3,'testsuer','$2y$10$aO.Ets9cJy5Z.k1hXHdxre0/Sc6cqCH.OWCHYh646ejrTLCzcT.1y','teseruser@email.com',NULL,'user','online','2026-01-11 21:34:49','2025-12-01 01:30:01',NULL,NULL,0),(4,'nightmare5575','$2y$10$jrSX9QASf3QsP0SpM2oSPe.Em4WX6pJnUBKFNcQE2.JDYJgwM7J46','kimgillie14@gmail.com',NULL,'user','online','2025-12-06 16:01:52','2025-12-06 14:10:29',NULL,NULL,0),(5,'test2','$2y$10$DvBaBnazIhMNMyX38D74n.btMBbYbDkTPHHhbl/bh55pJHyBblqyu','teseruser@email.com',NULL,'user','offline','2026-01-11 13:26:34','2026-01-11 13:26:34',NULL,NULL,0),(6,'theroninweb','$2y$10$GXHPQEU8O.WK6vtfWl6RJenrJodoC7ZLOKgCxNAnwD.KkcZKt2MfO','bluecometspt@gmail.com','https://preview.redd.it/48ptt9a8r3g41.jpg?width=640&crop=smart&auto=webp&s=ba84923ca410f172ffd4d7b2c23340468a7945c8','technician','offline','2026-01-18 13:26:27','2026-01-18 05:54:41','',NULL,0),(7,'ninamarie78','$2y$10$j0s81S7vOxWJp3FprU5fKuC.sbTCDzFgHMpYrkCMXClFGtljuqrpW','mrsprodigyiloveu143@gmail.com',NULL,'user','offline','2026-01-20 03:50:30','2026-01-20 03:49:57',NULL,NULL,0),(8,'henrietta','$2y$10$eR3olVNBtnALuqkF.cbPuuZTpfbOgkhGngv87p8le/qFdkhTg/OdO','henrietta.williams@testemail.com',NULL,'user','offline','2026-01-22 23:21:48','2026-01-22 23:21:48',NULL,NULL,0),(9,'Hentietta','$2y$10$1y/S.nOHEXdtsoKw5MCoreNsG3FZj7PpMIisVqAIQiddkH6fxYzk2','meshennie60@yahoo.com',NULL,'user','offline','2026-02-26 21:24:56','2026-02-26 21:22:29',NULL,NULL,0),(10,'damedash666','$2y$10$gMyD0BzqCPuie8cMkruTtebDMFZVVQZPHE.tuB8fo0lBs1bUMAI32','damedash666@yahoo.com',NULL,'user','online','2026-05-28 03:45:51','2026-03-22 00:35:57',NULL,NULL,0);

--
-- Table structure for table `vendor_sources`
--

CREATE TABLE `vendor_sources` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vendor` varchar(50) NOT NULL,
  `category` enum('CPU','Motherboard','RAM','GPU','PSU','OS') NOT NULL,
  `endpoint` varchar(500) NOT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vendor_sources`
--


--
-- Dumping events for database 'zpanelomega_db'
--

--
-- Dumping routines for database 'zpanelomega_db'
--


