osticket-wTix.dump

-- MySQL dump 10.13  Distrib 8.0.42, for Linux (x86_64)
--
-- Host: localhost    Database: osticket
-- ------------------------------------------------------
-- Server version	8.0.42-0ubuntu0.22.04.1

/*!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 */;
/*!50503 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 `ost__search`
--

DROP TABLE IF EXISTS `ost__search`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost__search` (
  `object_type` varchar(8) NOT NULL,
  `object_id` int unsigned NOT NULL,
  `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  PRIMARY KEY (`object_type`,`object_id`),
  FULLTEXT KEY `search` (`title`,`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost__search`
--

LOCK TABLES `ost__search` WRITE;
/*!40000 ALTER TABLE `ost__search` DISABLE KEYS */;
INSERT INTO `ost__search` VALUES ('H',1,'osTicket Installed!','Thank you for choosing osTicket. Please make sure you join the osTicket forums and our mailing list to stay up to date on the latest news, security alerts and updates. The osTicket forums are also a great place to get assistance, guidance, tips, and help from other osTicket users. In addition to the forums, the osTicket Docs provides a useful collection of educational materials, documentation, and notes from the community. We welcome your contributions to the osTicket community. If you are looking for a greater level of support, we provide professional services and commercial support with guaranteed response times, and access to the core development team. We can also help customize osTicket or even add new features to the system to meet your unique needs. If the idea of managing and upgrading this osTicket installation is daunting, you can try osTicket as a hosted service at https://supportsystem.com/ -- no installation required and we can import your data! With SupportSystem\'s turnkey infrastructure, you get osTicket at its best, leaving you free to focus on your customers without the burden of making sure the application is stable, maintained, and secure. Cheers, - osTicket Team - https://osticket.com/ PS. Don\'t just make customers happy, make happy customers!');
INSERT INTO `ost__search` VALUES ('H',2,'','I was just using my computer when out of nowhere my screen turned black and a ransom demand came up. There is a bitcoin address to send 2BTC to and a counter is running. I\'m sending this ticket from my phone, since I can\'t login to my computer anymore. What do I do!?');
INSERT INTO `ost__search` VALUES ('H',3,'','Our automated backups of the database server are not able to complete within our one hour assigned window. This appears to be due to a massive increase in database field alterations sometime in the past couple of days. I don\'t know what\'s going on over in sales, but the sysadmin team really needs to be kept in the loop on major changes. In any case, it would be greatly appreciated if the security team could advocate for boosting the datacenter bandwidth allocation. Not having backups complete is a security issue as well as an IT one!');
INSERT INTO `ost__search` VALUES ('H',4,'','Hey could one of you security folks put in the password to spotify? I really need it to do my work and the IT team never responds to me. I keep getting prompted to enter the Administrator credentials while I\'m listening to my tunes and it\'s really annoying!');
INSERT INTO `ost__search` VALUES ('H',5,'','I got an email from Steve asking if I know the Spotify password. I think Steve works remotely, but I\'ve never met him. Is this a Phish?');
INSERT INTO `ost__search` VALUES ('O',1,'osTicket','');
INSERT INTO `ost__search` VALUES ('T',1,'746387 osTicket Installed!','');
INSERT INTO `ost__search` VALUES ('T',2,'734178 RANSOMWARE!','RANSOMWARE!');
INSERT INTO `ost__search` VALUES ('T',3,'961243 More bandwidth needed','More bandwidth needed');
INSERT INTO `ost__search` VALUES ('T',4,'874781 Spotify Install','Spotify Install');
INSERT INTO `ost__search` VALUES ('T',5,'688039 Phish?','Phish?');
INSERT INTO `ost__search` VALUES ('U',1,'osTicket Team','feedback@osticket.com');
INSERT INTO `ost__search` VALUES ('U',2,'Todd Tamile','555-1553 todd@sales.localhost\ntodd@sales.localhost');
INSERT INTO `ost__search` VALUES ('U',3,'Horatio Ham','555-1390 horatio@sysadmin.localhost\nhoratio@sysadmin.localhost');
INSERT INTO `ost__search` VALUES ('U',4,'Steve Sanders','555-1901 steve@sales.localhost\nsteve@sales.localhost');
INSERT INTO `ost__search` VALUES ('U',5,'Lilly Lamil','555-1290 lilly@accounting.localhost\nlilly@accounting.localhost');
/*!40000 ALTER TABLE `ost__search` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_api_key`
--

DROP TABLE IF EXISTS `ost_api_key`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_api_key` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `isactive` tinyint(1) NOT NULL DEFAULT '1',
  `ipaddr` varchar(64) NOT NULL,
  `apikey` varchar(255) NOT NULL,
  `can_create_tickets` tinyint unsigned NOT NULL DEFAULT '1',
  `can_exec_cron` tinyint unsigned NOT NULL DEFAULT '1',
  `notes` text,
  `updated` datetime NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `apikey` (`apikey`),
  KEY `ipaddr` (`ipaddr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_api_key`
--

LOCK TABLES `ost_api_key` WRITE;
/*!40000 ALTER TABLE `ost_api_key` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_api_key` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_attachment`
--

DROP TABLE IF EXISTS `ost_attachment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_attachment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `object_id` int unsigned NOT NULL,
  `type` char(1) NOT NULL,
  `file_id` int unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `inline` tinyint unsigned NOT NULL DEFAULT '0',
  `lang` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `file-type` (`object_id`,`file_id`,`type`),
  UNIQUE KEY `file_object` (`file_id`,`object_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_attachment`
--

LOCK TABLES `ost_attachment` WRITE;
/*!40000 ALTER TABLE `ost_attachment` DISABLE KEYS */;
INSERT INTO `ost_attachment` VALUES (1,1,'C',2,NULL,0,NULL);
INSERT INTO `ost_attachment` VALUES (2,8,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (3,9,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (4,10,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (5,11,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (6,12,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (7,13,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (8,14,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (9,16,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (10,17,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (11,18,'T',1,NULL,1,NULL);
INSERT INTO `ost_attachment` VALUES (12,19,'T',1,NULL,1,NULL);
/*!40000 ALTER TABLE `ost_attachment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_canned_response`
--

DROP TABLE IF EXISTS `ost_canned_response`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_canned_response` (
  `canned_id` int unsigned NOT NULL AUTO_INCREMENT,
  `dept_id` int unsigned NOT NULL DEFAULT '0',
  `isenabled` tinyint unsigned NOT NULL DEFAULT '1',
  `title` varchar(255) NOT NULL DEFAULT '',
  `response` text NOT NULL,
  `lang` varchar(16) NOT NULL DEFAULT 'en_US',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`canned_id`),
  UNIQUE KEY `title` (`title`),
  KEY `dept_id` (`dept_id`),
  KEY `active` (`isenabled`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_canned_response`
--

LOCK TABLES `ost_canned_response` WRITE;
/*!40000 ALTER TABLE `ost_canned_response` DISABLE KEYS */;
INSERT INTO `ost_canned_response` VALUES (1,0,1,'What is osTicket (sample)?','osTicket is a widely-used open source support ticket system, an\nattractive alternative to higher-cost and complex customer support\nsystems - simple, lightweight, reliable, open source, web-based and easy\nto setup and use.','en_US',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_canned_response` VALUES (2,0,1,'Sample (with variables)','Hi %{ticket.name.first},\n<br>\n<br>\nYour ticket #%{ticket.number} created on %{ticket.create_date} is in\n%{ticket.dept.name} department.','en_US',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
/*!40000 ALTER TABLE `ost_canned_response` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_config`
--

DROP TABLE IF EXISTS `ost_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_config` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(64) NOT NULL,
  `key` varchar(64) NOT NULL,
  `value` text NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `namespace` (`namespace`,`key`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_config`
--

LOCK TABLES `ost_config` WRITE;
/*!40000 ALTER TABLE `ost_config` DISABLE KEYS */;
INSERT INTO `ost_config` VALUES (1,'core','admin_email','soc-user@ticketing.localhost','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (2,'core','helpdesk_url','http://ticketing.localhost/','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (3,'core','helpdesk_title','SOC-Desk','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (4,'core','schema_signature','5fb92bef17f3b603659e024c01cc7a59','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (5,'schedule.1','configuration','{\"holidays\":[4]}','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (6,'core','time_format','hh:mm a','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (7,'core','date_format','MM/dd/y','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (8,'core','datetime_format','MM/dd/y h:mm a','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (9,'core','daydatetime_format','EEE, MMM d y h:mm a','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (10,'core','default_priority_id','2','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (11,'core','enable_daylight_saving','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (12,'core','reply_separator','-- reply above this line --','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (13,'core','isonline','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (14,'core','staff_ip_binding','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (15,'core','staff_max_logins','4','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (16,'core','staff_login_timeout','2','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (17,'core','staff_session_timeout','30','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (18,'core','passwd_reset_period','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (19,'core','client_max_logins','4','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (20,'core','client_login_timeout','2','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (21,'core','client_session_timeout','30','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (22,'core','max_page_size','25','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (23,'core','max_open_tickets','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (24,'core','autolock_minutes','3','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (25,'core','default_smtp_id','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (26,'core','use_email_priority','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (27,'core','enable_kb','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (28,'core','enable_premade','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (29,'core','enable_captcha','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (30,'core','enable_auto_cron','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (31,'core','enable_mail_polling','','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (32,'core','send_sys_errors','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (33,'core','send_sql_errors','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (34,'core','send_login_errors','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (35,'core','save_email_headers','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (36,'core','strip_quoted_reply','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (37,'core','ticket_autoresponder','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (38,'core','message_autoresponder','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (39,'core','ticket_notice_active','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (40,'core','ticket_alert_active','0','2025-05-23 15:24:28');
INSERT INTO `ost_config` VALUES (41,'core','ticket_alert_admin','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (42,'core','ticket_alert_dept_manager','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (43,'core','ticket_alert_dept_members','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (44,'core','message_alert_active','0','2025-05-23 15:24:28');
INSERT INTO `ost_config` VALUES (45,'core','message_alert_laststaff','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (46,'core','message_alert_assigned','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (47,'core','message_alert_dept_manager','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (48,'core','note_alert_active','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (49,'core','note_alert_laststaff','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (50,'core','note_alert_assigned','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (51,'core','note_alert_dept_manager','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (52,'core','transfer_alert_active','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (53,'core','transfer_alert_assigned','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (54,'core','transfer_alert_dept_manager','1','2025-05-22 21:32:40');
INSERT INTO `ost_config` VALUES (55,'core','transfer_alert_dept_members','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (56,'core','overdue_alert_active','0','2025-05-23 15:24:29');
INSERT INTO `ost_config` VALUES (57,'core','overdue_alert_assigned','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (58,'core','overdue_alert_dept_manager','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (59,'core','overdue_alert_dept_members','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (60,'core','assigned_alert_active','0','2025-05-23 15:24:29');
INSERT INTO `ost_config` VALUES (61,'core','assigned_alert_staff','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (62,'core','assigned_alert_team_lead','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (63,'core','assigned_alert_team_members','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (64,'core','auto_claim_tickets','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (65,'core','auto_refer_closed','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (66,'core','collaborator_ticket_visibility','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (67,'core','require_topic_to_close','','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (68,'core','show_related_tickets','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (69,'core','show_assigned_tickets','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (70,'core','show_answered_tickets','','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (71,'core','hide_staff_name','','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (72,'core','disable_agent_collabs','','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (73,'core','overlimit_notice_active','0','2025-05-23 15:22:42');
INSERT INTO `ost_config` VALUES (74,'core','email_attachments','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (75,'core','ticket_number_format','######','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (76,'core','ticket_sequence_id','','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (77,'core','queue_bucket_counts','','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (78,'core','allow_external_images','','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (79,'core','task_number_format','#','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (80,'core','task_sequence_id','2','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (81,'core','log_level','2','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (82,'core','log_graceperiod','12','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (83,'core','client_registration','public','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (84,'core','default_ticket_queue','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (85,'core','embedded_domain_whitelist','youtube.com, dailymotion.com, vimeo.com, player.vimeo.com, web.microsoftstream.com','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (86,'core','max_file_size','1048576','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (87,'core','landing_page_id','1','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (88,'core','thank-you_page_id','2','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (89,'core','offline_page_id','3','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (90,'core','system_language','en_US','2025-05-22 21:32:41');
INSERT INTO `ost_config` VALUES (91,'mysqlsearch','reindex','0','2025-05-23 15:13:10');
INSERT INTO `ost_config` VALUES (92,'core','default_email_id','1','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (93,'core','alert_email_id','2','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (94,'core','default_dept_id','1','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (95,'core','default_sla_id','1','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (96,'core','schedule_id','1','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (97,'core','default_template_id','1','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (98,'core','default_timezone','America/New_York','2025-05-22 21:32:42');
INSERT INTO `ost_config` VALUES (99,'core','message_autoresponder_collabs','0','2025-05-23 15:24:28');
INSERT INTO `ost_config` VALUES (100,'core','ticket_alert_acct_manager','0','2025-05-23 15:24:28');
INSERT INTO `ost_config` VALUES (101,'core','message_alert_acct_manager','0','2025-05-23 15:24:28');
/*!40000 ALTER TABLE `ost_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_content`
--

DROP TABLE IF EXISTS `ost_content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_content` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `isactive` tinyint unsigned NOT NULL DEFAULT '0',
  `type` varchar(32) NOT NULL DEFAULT 'other',
  `name` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_content`
--

LOCK TABLES `ost_content` WRITE;
/*!40000 ALTER TABLE `ost_content` DISABLE KEYS */;
INSERT INTO `ost_content` VALUES (1,1,'landing','Landing','<h1>Welcome to the Support Center</h1> <p> In order to streamline support requests and better serve you, we utilize a support ticket system. Every support request is assigned a unique ticket number which you can use to track the progress and responses online. For your reference we provide complete archives and history of all your support requests. A valid email address is required to submit a ticket. </p>','The Landing Page refers to the content of the Customer Portal\'s initial view. The template modifies the content seen above the two links <strong>Open a New Ticket</strong> and <strong>Check Ticket Status</strong>.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (2,1,'thank-you','Thank You','<div>%{ticket.name},\n<br>\n<br>\nThank you for contacting us.\n<br>\n<br>\nA support ticket request has been created and a representative will be\ngetting back to you shortly if necessary.</p>\n<br>\n<br>\nSupport Team\n</div>','This template defines the content displayed on the Thank-You page after a\nClient submits a new ticket in the Client Portal.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (3,1,'offline','Offline','<div><h1>\n<span style=\"font-size: medium\">Support Ticket System Offline</span>\n</h1>\n<p>Thank you for your interest in contacting us.</p>\n<p>Our helpdesk is offline at the moment, please check back at a later\ntime.</p>\n</div>','The Offline Page appears in the Customer Portal when the Help Desk is offline.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (4,1,'registration-staff','Welcome to osTicket','<h3><strong>Hi %{recipient.name.first},</strong></h3> <div> We\'ve created an account for you at our help desk at %{url}.<br /> <br /> Please follow the link below to confirm your account and gain access to your tickets.<br /> <br /> <a href=\"%{link}\">%{link}</a><br /> <br /> <em style=\"font-size: small\">Your friendly Customer Support System<br /> %{company.name}</em> </div>','This template defines the initial email (optional) sent to Agents when an account is created on their behalf.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (5,1,'pwreset-staff','osTicket Staff Password Reset','<h3><strong>Hi %{staff.name.first},</strong></h3> <div> A password reset request has been submitted on your behalf for the helpdesk at %{url}.<br /> <br /> If you feel that this has been done in error, delete and disregard this email. Your account is still secure and no one has been given access to it. It is not locked and your password has not been reset. Someone could have mistakenly entered your email address.<br /> <br /> Follow the link below to login to the help desk and change your password.<br /> <br /> <a href=\"%{link}\">%{link}</a><br /> <br /> <em style=\"font-size: small\">Your friendly Customer Support System</em> <br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" alt=\"Powered by osTicket\" width=\"126\" height=\"19\" style=\"width: 126px\" /> </div>','This template defines the email sent to Staff who select the <strong>Forgot My Password</strong> link on the Staff Control Panel Log In page.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (6,1,'banner-staff','Authentication Required','','This is the initial message and banner shown on the Staff Log In page. The first input field refers to the red-formatted text that appears at the top. The latter textarea is for the banner content which should serve as a disclaimer.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (7,1,'registration-client','Welcome to %{company.name}','<h3><strong>Hi %{recipient.name.first},</strong></h3> <div> We\'ve created an account for you at our help desk at %{url}.<br /> <br /> Please follow the link below to confirm your account and gain access to your tickets.<br /> <br /> <a href=\"%{link}\">%{link}</a><br /> <br /> <em style=\"font-size: small\">Your friendly Customer Support System <br /> %{company.name}</em> </div>','This template defines the email sent to Clients when their account has been created in the Client Portal or by an Agent on their behalf. This email serves as an email address verification. Please use %{link} somewhere in the body.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (8,1,'pwreset-client','%{company.name} Help Desk Access','<h3><strong>Hi %{user.name.first},</strong></h3> <div> A password reset request has been submitted on your behalf for the helpdesk at %{url}.<br /> <br /> If you feel that this has been done in error, delete and disregard this email. Your account is still secure and no one has been given access to it. It is not locked and your password has not been reset. Someone could have mistakenly entered your email address.<br /> <br /> Follow the link below to login to the help desk and change your password.<br /> <br /> <a href=\"%{link}\">%{link}</a><br /> <br /> <em style=\"font-size: small\">Your friendly Customer Support System <br /> %{company.name}</em> </div>','This template defines the email sent to Clients who select the <strong>Forgot My Password</strong> link on the Client Log In page.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (9,1,'banner-client','Sign in to %{company.name}','To better serve you, we encourage our Clients to register for an account.','This composes the header on the Client Log In page. It can be useful to inform your Clients about your log in and registration policies.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (10,1,'registration-confirm','Account registration','<div><strong>Thanks for registering for an account.</strong><br/> <br /> We\'ve just sent you an email to the address you entered. Please follow the link in the email to confirm your account and gain access to your tickets. </div>','This templates defines the page shown to Clients after completing the registration form. The template should mention that the system is sending them an email confirmation link and what is the next step in the registration process.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (11,1,'registration-thanks','Account Confirmed!','<div> <strong>Thanks for registering for an account.</strong><br /> <br /> You\'ve confirmed your email address and successfully activated your account. You may proceed to open a new ticket or manage existing tickets.<br /> <br /> <em>Your friendly support center</em><br /> %{company.name} </div>','This template defines the content displayed after Clients successfully register by confirming their account. This page should inform the user that registration is complete and that the Client can now submit a ticket or access existing tickets.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (12,1,'access-link','Ticket [#%{ticket.number}] Access Link','<h3><strong>Hi %{recipient.name.first},</strong></h3> <div> An access link request for ticket #%{ticket.number} has been submitted on your behalf for the helpdesk at %{url}.<br /> <br /> Follow the link below to check the status of the ticket #%{ticket.number}.<br /> <br /> <a href=\"%{recipient.ticket_link}\">%{recipient.ticket_link}</a><br /> <br /> If you <strong>did not</strong> make the request, please delete and disregard this email. Your account is still secure and no one has been given access to the ticket. Someone could have mistakenly entered your email address.<br /> <br /> --<br /> %{company.name} </div>','This template defines the notification for Clients that an access link was sent to their email. The ticket number and email address trigger the access link.','2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_content` VALUES (13,1,'email2fa-staff','osTicket Two Factor Authentication','<h3><strong>Hi %{staff.name.first},</strong></h3> <div> You have just logged into for the helpdesk at %{url}.<br /> <br /> Use the verification code below to finish logging into the helpdesk.<br /> <br /> %{otp}<br /> <br /> <em style=\"font-size: small\">Your friendly Customer Support System</em> <br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" alt=\"Powered by osTicket\" width=\"126\" height=\"19\" style=\"width: 126px\" /> </div>','This template defines the email sent to Staff who use Email for Two Factor Authentication','2025-05-22 17:32:41','2025-05-22 17:32:41');
/*!40000 ALTER TABLE `ost_content` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_department`
--

DROP TABLE IF EXISTS `ost_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_department` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pid` int unsigned DEFAULT NULL,
  `tpl_id` int unsigned NOT NULL DEFAULT '0',
  `sla_id` int unsigned NOT NULL DEFAULT '0',
  `schedule_id` int unsigned NOT NULL DEFAULT '0',
  `email_id` int unsigned NOT NULL DEFAULT '0',
  `autoresp_email_id` int unsigned NOT NULL DEFAULT '0',
  `manager_id` int unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL DEFAULT '',
  `signature` text NOT NULL,
  `ispublic` tinyint unsigned NOT NULL DEFAULT '1',
  `group_membership` tinyint(1) NOT NULL DEFAULT '0',
  `ticket_auto_response` tinyint(1) NOT NULL DEFAULT '1',
  `message_auto_response` tinyint(1) NOT NULL DEFAULT '0',
  `path` varchar(128) NOT NULL DEFAULT '/',
  `updated` datetime NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`,`pid`),
  KEY `manager_id` (`manager_id`),
  KEY `autoresp_email_id` (`autoresp_email_id`),
  KEY `tpl_id` (`tpl_id`),
  KEY `flags` (`flags`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_department`
--

LOCK TABLES `ost_department` WRITE;
/*!40000 ALTER TABLE `ost_department` DISABLE KEYS */;
INSERT INTO `ost_department` VALUES (1,NULL,0,0,0,0,0,0,4,'Support','Support Department',1,1,1,1,'/1/','2025-05-22 17:32:37','2025-05-22 17:32:37');
INSERT INTO `ost_department` VALUES (2,NULL,0,1,0,0,0,0,4,'Sales','Sales and Customer Retention',1,1,1,1,'/2/','2025-05-22 17:32:37','2025-05-22 17:32:37');
INSERT INTO `ost_department` VALUES (3,NULL,0,0,0,0,0,0,4,'Maintenance','Maintenance Department',1,0,1,1,'/3/','2025-05-22 17:32:37','2025-05-22 17:32:37');
/*!40000 ALTER TABLE `ost_department` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_draft`
--

DROP TABLE IF EXISTS `ost_draft`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_draft` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int unsigned NOT NULL,
  `namespace` varchar(32) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `extra` text,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`),
  KEY `namespace` (`namespace`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_draft`
--

LOCK TABLES `ost_draft` WRITE;
/*!40000 ALTER TABLE `ost_draft` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_draft` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_email`
--

DROP TABLE IF EXISTS `ost_email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_email` (
  `email_id` int unsigned NOT NULL AUTO_INCREMENT,
  `noautoresp` tinyint unsigned NOT NULL DEFAULT '0',
  `priority_id` int unsigned NOT NULL DEFAULT '2',
  `dept_id` int unsigned NOT NULL DEFAULT '0',
  `topic_id` int unsigned NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`email_id`),
  UNIQUE KEY `email` (`email`),
  KEY `priority_id` (`priority_id`),
  KEY `dept_id` (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_email`
--

LOCK TABLES `ost_email` WRITE;
/*!40000 ALTER TABLE `ost_email` DISABLE KEYS */;
INSERT INTO `ost_email` VALUES (1,0,2,1,0,'soc-desk@ticketing.localhost','Support',NULL,'2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_email` VALUES (2,0,2,1,0,'alerts@ticketing.localhost','osTicket Alerts',NULL,'2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_email` VALUES (3,0,2,1,0,'noreply@ticketing.localhost','',NULL,'2025-05-22 17:32:42','2025-05-22 17:32:42');
/*!40000 ALTER TABLE `ost_email` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_email_account`
--

DROP TABLE IF EXISTS `ost_email_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_email_account` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `email_id` int unsigned NOT NULL,
  `type` enum('mailbox','smtp') NOT NULL DEFAULT 'mailbox',
  `auth_bk` varchar(128) NOT NULL,
  `auth_id` varchar(16) DEFAULT NULL,
  `active` tinyint unsigned NOT NULL DEFAULT '0',
  `host` varchar(128) NOT NULL DEFAULT '',
  `port` int NOT NULL,
  `folder` varchar(255) DEFAULT NULL,
  `protocol` enum('IMAP','POP','SMTP','OTHER') NOT NULL DEFAULT 'OTHER',
  `encryption` enum('NONE','AUTO','SSL') NOT NULL DEFAULT 'AUTO',
  `fetchfreq` tinyint unsigned NOT NULL DEFAULT '5',
  `fetchmax` tinyint unsigned DEFAULT '30',
  `postfetch` enum('archive','delete','nothing') NOT NULL DEFAULT 'nothing',
  `archivefolder` varchar(255) DEFAULT NULL,
  `allow_spoofing` tinyint unsigned DEFAULT '0',
  `num_errors` int unsigned NOT NULL DEFAULT '0',
  `last_error_msg` tinytext,
  `last_error` datetime DEFAULT NULL,
  `last_activity` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `email_id` (`email_id`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_email_account`
--

LOCK TABLES `ost_email_account` WRITE;
/*!40000 ALTER TABLE `ost_email_account` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_email_account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_email_template`
--

DROP TABLE IF EXISTS `ost_email_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_email_template` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tpl_id` int unsigned NOT NULL,
  `code_name` varchar(32) NOT NULL,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_lookup` (`tpl_id`,`code_name`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_email_template`
--

LOCK TABLES `ost_email_template` WRITE;
/*!40000 ALTER TABLE `ost_email_template` DISABLE KEYS */;
INSERT INTO `ost_email_template` VALUES (1,1,'ticket.autoresp','Support Ticket Opened [#%{ticket.number}]','<h3><strong>Dear %{recipient.name.first},</strong></h3> <p>A request for support has been created and assigned #%{ticket.number}. A representative will follow-up with you as soon as possible. You can <a href=\"%{recipient.ticket_link}\">view this ticket\'s progress online</a>. </p> <br /> <div style=\"color:rgb(127, 127, 127)\">Your %{company.name} Team, <br /> %{signature} </div> <hr /> <div style=\"color:rgb(127, 127, 127);font-size:small\"><em>If you wish to provide additional comments or information regarding the issue, please reply to this email or <a href=\"%{recipient.ticket_link}\"><span style=\"color:rgb(84, 141, 212)\">login to your account</span></a> for a complete archive of your support requests.</em></div>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (2,1,'ticket.autoreply','Re: %{ticket.subject} [#%{ticket.number}]','<h3><strong>Dear %{recipient.name.first},</strong></h3> A request for support has been created and assigned ticket <a href=\"%{recipient.ticket_link}\">#%{ticket.number}</a> with the following automatic reply <br /> <br /> Topic: <strong>%{ticket.topic.name}</strong> <br /> Subject: <strong>%{ticket.subject}</strong> <br /> <br /> %{response} <br /> <br /> <div style=\"color:rgb(127, 127, 127)\">Your %{company.name} Team,<br /> %{signature}</div> <hr /> <div style=\"color:rgb(127, 127, 127);font-size:small\"><em>We hope this response has sufficiently answered your questions. If you wish to provide additional comments or information, please reply to this email or <a href=\"%{recipient.ticket_link}\"><span style=\"color:rgb(84, 141, 212)\">login to your account</span></a> for a complete archive of your support requests.</em></div>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (3,1,'message.autoresp','Message Confirmation','<h3><strong>Dear %{recipient.name.first},</strong></h3> Your reply to support request <a href=\"%{recipient.ticket_link}\">#%{ticket.number}</a> has been noted <br /> <br /> <div style=\"color:rgb(127, 127, 127)\">Your %{company.name} Team,<br /> %{signature} </div> <hr /> <div style=\"color:rgb(127, 127, 127);font-size:small;text-align:center\"><em>You can view the support request progress <a href=\"%{recipient.ticket_link}\">online here</a></em> </div>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (4,1,'ticket.notice','%{ticket.subject} [#%{ticket.number}]','<h3><strong>Dear %{recipient.name.first},</strong></h3> Our customer care team has created a ticket, <a href=\"%{recipient.ticket_link}\">#%{ticket.number}</a> on your behalf, with the following details and summary: <br /> <br /> Topic: <strong>%{ticket.topic.name}</strong> <br /> Subject: <strong>%{ticket.subject}</strong> <br /> <br /> %{message} <br /> <br /> %{response} <br /> <br /> If need be, a representative will follow-up with you as soon as possible. You can also <a href=\"%{recipient.ticket_link}\">view this ticket\'s progress online</a>. <br /> <br /> <div style=\"color:rgb(127, 127, 127)\">Your %{company.name} Team,<br /> %{signature}</div> <hr /> <div style=\"color:rgb(127, 127, 127);font-size:small\"><em>If you wish to provide additional comments or information regarding the issue, please reply to this email or <a href=\"%{recipient.ticket_link}\"><span style=\"color:rgb(84, 141, 212)\">login to your account</span></a> for a complete archive of your support requests.</em></div>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (5,1,'ticket.overlimit','Open Tickets Limit Reached','<h3><strong>Dear %{ticket.name.first},</strong></h3> You have reached the maximum number of open tickets allowed. To be able to open another ticket, one of your pending tickets must be closed. To update or add comments to an open ticket simply <a href=\"%{url}/tickets.php?e=%{ticket.email}\">login to our helpdesk</a>. <br /> <br /> Thank you,<br /> Support Ticket System',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (6,1,'ticket.reply','Re: %{ticket.subject} [#%{ticket.number}]','<h3><strong>Dear %{recipient.name.first},</strong></h3> %{response} <br /> <br /> <div style=\"color:rgb(127, 127, 127)\">Your %{company.name} Team,<br /> %{signature} </div> <hr /> <div style=\"color:rgb(127, 127, 127);font-size:small;text-align:center\"><em>We hope this response has sufficiently answered your questions. If not, please do not send another email. Instead, reply to this email or <a href=\"%{recipient.ticket_link}\" style=\"color:rgb(84, 141, 212)\">login to your account</a> for a complete archive of all your support requests and responses.</em></div>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (7,1,'ticket.activity.notice','Re: %{ticket.subject} [#%{ticket.number}]','<h3><strong>Dear %{recipient.name.first},</strong></h3> <div><em>%{poster.name}</em> just logged a message to a ticket in which you participate. </div> <br /> %{message} <br /> <br /> <hr /> <div style=\"color:rgb(127, 127, 127);font-size:small;text-align:center\"><em>You\'re getting this email because you are a collaborator on ticket <a href=\"%{recipient.ticket_link}\" style=\"color:rgb(84, 141, 212)\">#%{ticket.number}</a>. To participate, simply reply to this email or <a href=\"%{recipient.ticket_link}\" style=\"color:rgb(84, 141, 212)\">click here</a> for a complete archive of the ticket thread.</em> </div>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (8,1,'ticket.alert','New Ticket Alert','<h2>Hi %{recipient.name},</h2> New ticket #%{ticket.number} created <br /> <br /> <table><tbody><tr><td><strong>From</strong>: </td> <td>%{ticket.name} &lt;%{ticket.email}&gt; </td> </tr> <tr><td><strong>Department</strong>: </td> <td>%{ticket.dept.name} </td> </tr> </tbody> </table> <br /> %{message} <br /> <br /> <hr /> <div>To view or respond to the ticket, please <a href=\"%{ticket.staff_link}\">login</a> to the support ticket system</div> <em style=\"font-size:small\">Your friendly Customer Support System</em> <br /> <a href=\"https://osticket.com/\"><img width=\"126\" height=\"19\" style=\"width:126px\" alt=\"Powered By osTicket\" src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" /></a>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (9,1,'message.alert','New Message Alert','<h3><strong>Hi %{recipient.name},</strong></h3> New message appended to ticket <a href=\"%{ticket.staff_link}\">#%{ticket.number}</a> <br /> <br /> <table><tbody><tr><td><strong>From</strong>: </td> <td>%{poster.name} &lt;%{ticket.email}&gt; </td> </tr> <tr><td><strong>Department</strong>: </td> <td>%{ticket.dept.name} </td> </tr> </tbody> </table> <br /> %{message} <br /> <br /> <hr /> <div>To view or respond to the ticket, please <a href=\"%{ticket.staff_link}\"><span style=\"color:rgb(84, 141, 212)\">login</span></a> to the support ticket system</div> <em style=\"color:rgb(127,127,127);font-size:small\">Your friendly Customer Support System</em><br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" alt=\"Powered by osTicket\" width=\"126\" height=\"19\" style=\"width:126px\" />',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (10,1,'note.alert','New Internal Activity Alert','<h3><strong>Hi %{recipient.name},</strong></h3> An agent has logged activity on ticket <a href=\"%{ticket.staff_link}\">#%{ticket.number}</a> <br /> <br /> <table><tbody><tr><td><strong>From</strong>: </td> <td>%{note.poster} </td> </tr> <tr><td><strong>Title</strong>: </td> <td>%{note.title} </td> </tr> </tbody> </table> <br /> %{note.message} <br /> <br /> <hr /> To view/respond to the ticket, please <a href=\"%{ticket.staff_link}\">login</a> to the support ticket system <br /> <br /> <em style=\"font-size:small\">Your friendly Customer Support System</em> <br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" alt=\"Powered by osTicket\" width=\"126\" height=\"19\" style=\"width:126px\" />',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (11,1,'assigned.alert','Ticket Assigned to you','<h3><strong>Hi %{assignee.name.first},</strong></h3> Ticket <a href=\"%{ticket.staff_link}\">#%{ticket.number}</a> has been assigned to you by %{assigner.name.short} <br /> <br /> <table><tbody><tr><td><strong>From</strong>: </td> <td>%{ticket.name} &lt;%{ticket.email}&gt; </td> </tr> <tr><td><strong>Subject</strong>: </td> <td>%{ticket.subject} </td> </tr> </tbody> </table> <br /> %{comments} <br /> <br /> <hr /> <div>To view/respond to the ticket, please <a href=\"%{ticket.staff_link}\"><span style=\"color:rgb(84, 141, 212)\">login</span></a> to the support ticket system</div> <em style=\"font-size:small\">Your friendly Customer Support System</em> <br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" alt=\"Powered by osTicket\" width=\"126\" height=\"19\" style=\"width:126px\" />',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (12,1,'transfer.alert','Ticket #%{ticket.number} transfer - %{ticket.dept.name}','<h3>Hi %{recipient.name},</h3> Ticket <a href=\"%{ticket.staff_link}\">#%{ticket.number}</a> has been transferred to the %{ticket.dept.name} department by <strong>%{staff.name.short}</strong> <br /> <br /> <blockquote><div>%{comments} </div></blockquote> <hr /> <div>To view or respond to the ticket, please <a href=\"%{ticket.staff_link}\">login</a> to the support ticket system. </div> <em style=\"font-size:small\">Your friendly Customer Support System</em> <br /> <a href=\"https://osticket.com/\"><img width=\"126\" height=\"19\" alt=\"Powered By osTicket\" style=\"width:126px\" src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" /></a>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (13,1,'ticket.overdue','Stale Ticket Alert','<h3><strong>Hi %{recipient.name}</strong>,</h3> A ticket, <a href=\"%{ticket.staff_link}\">#%{ticket.number}</a> is seriously overdue. <br /> <br /> We should all work hard to guarantee that all tickets are being addressed in a timely manner. <br /> <br /> Signed,<br /> %{ticket.dept.manager.name} <hr /> <div>To view or respond to the ticket, please <a href=\"%{ticket.staff_link}\"><span style=\"color:rgb(84, 141, 212)\">login</span></a> to the support ticket system. You\'re receiving this notice because the ticket is assigned directly to you or to a team or department of which you\'re a member.</div> <em style=\"font-size:small\">Your friendly <span style=\"font-size:smaller\">(although with limited patience)</span> Customer Support System</em><br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" height=\"19\" alt=\"Powered by osTicket\" width=\"126\" style=\"width:126px\" />',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (14,1,'task.alert','New Task Alert','<h2>Hi %{recipient.name},</h2> New task <a href=\"%{task.staff_link}\">#%{task.number}</a> created <br /> <br /> <table><tbody><tr><td><strong>Department</strong>: </td> <td>%{task.dept.name} </td> </tr> </tbody> </table> <br /> %{task.description} <br /> <br /> <hr /> <div>To view or respond to the task, please <a href=\"%{task.staff_link}\">login</a> to the support system</div> <em style=\"font-size:small\">Your friendly Customer Support System</em> <br /> <a href=\"https://osticket.com/\"><img width=\"126\" height=\"19\" style=\"width:126px\" alt=\"Powered By osTicket\" src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" /></a>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (15,1,'task.activity.notice','Re: %{task.title} [#%{task.number}]','<h3><strong>Dear %{recipient.name.first},</strong></h3> <div><em>%{poster.name}</em> just logged a message to a task in which you participate. </div> <br /> %{message} <br /> <br /> <hr /> <div style=\"color:rgb(127, 127, 127);font-size:small;text-align:center\"><em>You\'re getting this email because you are a collaborator on task #%{task.number}. To participate, simply reply to this email.</em> </div>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (16,1,'task.activity.alert','Task Activity [#%{task.number}] - %{activity.title}','<h3><strong>Hi %{recipient.name},</strong></h3> Task <a href=\"%{task.staff_link}\">#%{task.number}</a> updated: %{activity.description} <br /> <br /> %{message} <br /> <br /> <hr /> <div>To view or respond to the task, please <a href=\"%{task.staff_link}\"><span style=\"color:rgb(84, 141, 212)\">login</span></a> to the support system</div> <em style=\"color:rgb(127,127,127);font-size:small\">Your friendly Customer Support System</em><br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" alt=\"Powered by osTicket\" width=\"126\" height=\"19\" style=\"width:126px\" />',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (17,1,'task.assignment.alert','Task Assigned to you','<h3><strong>Hi %{assignee.name.first},</strong></h3> Task <a href=\"%{task.staff_link}\">#%{task.number}</a> has been assigned to you by %{assigner.name.short} <br /> <br /> %{comments} <br /> <br /> <hr /> <div>To view/respond to the task, please <a href=\"%{task.staff_link}\"><span style=\"color:rgb(84, 141, 212)\">login</span></a> to the support system</div> <em style=\"font-size:small\">Your friendly Customer Support System</em> <br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" alt=\"Powered by osTicket\" width=\"126\" height=\"19\" style=\"width:126px\" />',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (18,1,'task.transfer.alert','Task #%{task.number} transfer - %{task.dept.name}','<h3>Hi %{recipient.name},</h3> Task <a href=\"%{task.staff_link}\">#%{task.number}</a> has been transferred to the %{task.dept.name} department by <strong>%{staff.name.short}</strong> <br /> <br /> <blockquote><div>%{comments} </div></blockquote> <hr /> <div>To view or respond to the task, please <a href=\"%{task.staff_link}\">login</a> to the support system. </div> <em style=\"font-size:small\">Your friendly Customer Support System</em> <br /> <a href=\"https://osticket.com/\"><img width=\"126\" height=\"19\" alt=\"Powered By osTicket\" style=\"width:126px\" src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" /></a>',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
INSERT INTO `ost_email_template` VALUES (19,1,'task.overdue.alert','Stale Task Alert','<h3><strong>Hi %{recipient.name}</strong>,</h3> A task, <a href=\"%{task.staff_link}\">#%{task.number}</a> is seriously overdue. <br /> <br /> We should all work hard to guarantee that all tasks are being addressed in a timely manner. <br /> <br /> Signed,<br /> %{task.dept.manager.name} <hr /> <div>To view or respond to the task, please <a href=\"%{task.staff_link}\"><span style=\"color:rgb(84, 141, 212)\">login</span></a> to the support system. You\'re receiving this notice because the task is assigned directly to you or to a team or department of which you\'re a member.</div> <em style=\"font-size:small\">Your friendly <span style=\"font-size:smaller\">(although with limited patience)</span> Customer Support System</em><br /> <img src=\"cid:b56944cb4722cc5cda9d1e23a3ea7fbc\" height=\"19\" alt=\"Powered by osTicket\" width=\"126\" style=\"width:126px\" />',NULL,'2025-05-22 17:32:41','2025-05-22 17:32:41');
/*!40000 ALTER TABLE `ost_email_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_email_template_group`
--

DROP TABLE IF EXISTS `ost_email_template_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_email_template_group` (
  `tpl_id` int NOT NULL AUTO_INCREMENT,
  `isactive` tinyint unsigned NOT NULL DEFAULT '0',
  `name` varchar(32) NOT NULL DEFAULT '',
  `lang` varchar(16) NOT NULL DEFAULT 'en_US',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL,
  PRIMARY KEY (`tpl_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_email_template_group`
--

LOCK TABLES `ost_email_template_group` WRITE;
/*!40000 ALTER TABLE `ost_email_template_group` DISABLE KEYS */;
INSERT INTO `ost_email_template_group` VALUES (1,1,'osTicket Default Template (HTML)','en_US','Default osTicket templates','2025-05-22 17:32:41','2025-05-22 21:32:41');
/*!40000 ALTER TABLE `ost_email_template_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_event`
--

DROP TABLE IF EXISTS `ost_event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_event` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL,
  `description` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_event`
--

LOCK TABLES `ost_event` WRITE;
/*!40000 ALTER TABLE `ost_event` DISABLE KEYS */;
INSERT INTO `ost_event` VALUES (1,'created',NULL);
INSERT INTO `ost_event` VALUES (2,'closed',NULL);
INSERT INTO `ost_event` VALUES (3,'reopened',NULL);
INSERT INTO `ost_event` VALUES (4,'assigned',NULL);
INSERT INTO `ost_event` VALUES (5,'released',NULL);
INSERT INTO `ost_event` VALUES (6,'transferred',NULL);
INSERT INTO `ost_event` VALUES (7,'referred',NULL);
INSERT INTO `ost_event` VALUES (8,'overdue',NULL);
INSERT INTO `ost_event` VALUES (9,'edited',NULL);
INSERT INTO `ost_event` VALUES (10,'viewed',NULL);
INSERT INTO `ost_event` VALUES (11,'error',NULL);
INSERT INTO `ost_event` VALUES (12,'collab',NULL);
INSERT INTO `ost_event` VALUES (13,'resent',NULL);
INSERT INTO `ost_event` VALUES (14,'deleted',NULL);
INSERT INTO `ost_event` VALUES (15,'merged',NULL);
INSERT INTO `ost_event` VALUES (16,'unlinked',NULL);
INSERT INTO `ost_event` VALUES (17,'linked',NULL);
INSERT INTO `ost_event` VALUES (18,'login',NULL);
INSERT INTO `ost_event` VALUES (19,'logout',NULL);
INSERT INTO `ost_event` VALUES (20,'message',NULL);
INSERT INTO `ost_event` VALUES (21,'note',NULL);
/*!40000 ALTER TABLE `ost_event` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_faq`
--

DROP TABLE IF EXISTS `ost_faq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_faq` (
  `faq_id` int unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int unsigned NOT NULL DEFAULT '0',
  `ispublished` tinyint unsigned NOT NULL DEFAULT '0',
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  `keywords` tinytext,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`faq_id`),
  UNIQUE KEY `question` (`question`),
  KEY `category_id` (`category_id`),
  KEY `ispublished` (`ispublished`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_faq`
--

LOCK TABLES `ost_faq` WRITE;
/*!40000 ALTER TABLE `ost_faq` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_faq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_faq_category`
--

DROP TABLE IF EXISTS `ost_faq_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_faq_category` (
  `category_id` int unsigned NOT NULL AUTO_INCREMENT,
  `category_pid` int unsigned DEFAULT NULL,
  `ispublic` tinyint unsigned NOT NULL DEFAULT '0',
  `name` varchar(125) DEFAULT NULL,
  `description` text NOT NULL,
  `notes` tinytext NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`category_id`),
  KEY `ispublic` (`ispublic`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_faq_category`
--

LOCK TABLES `ost_faq_category` WRITE;
/*!40000 ALTER TABLE `ost_faq_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_faq_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_faq_topic`
--

DROP TABLE IF EXISTS `ost_faq_topic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_faq_topic` (
  `faq_id` int unsigned NOT NULL,
  `topic_id` int unsigned NOT NULL,
  PRIMARY KEY (`faq_id`,`topic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_faq_topic`
--

LOCK TABLES `ost_faq_topic` WRITE;
/*!40000 ALTER TABLE `ost_faq_topic` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_faq_topic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_file`
--

DROP TABLE IF EXISTS `ost_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_file` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ft` char(1) NOT NULL DEFAULT 'T',
  `bk` char(1) NOT NULL DEFAULT 'D',
  `type` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `size` bigint unsigned NOT NULL DEFAULT '0',
  `key` varchar(86) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `signature` varchar(86) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `attrs` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ft` (`ft`),
  KEY `key` (`key`),
  KEY `signature` (`signature`),
  KEY `type` (`type`),
  KEY `created` (`created`),
  KEY `size` (`size`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_file`
--

LOCK TABLES `ost_file` WRITE;
/*!40000 ALTER TABLE `ost_file` DISABLE KEYS */;
INSERT INTO `ost_file` VALUES (1,'T','D','image/png',9452,'b56944cb4722cc5cda9d1e23a3ea7fbc','gjMyblHhAxCQvzLfPBW3EjMUY1AmQQmz','powered-by-osticket.png',NULL,'2025-05-22 17:32:39');
INSERT INTO `ost_file` VALUES (2,'T','D','text/plain',24,'G1YvoMWtx86n3ccfeGGNagoRoTDtol7o','MWtx86n3ccfeGGNafaacpitTxmJ4h3Ls','osTicket.txt',NULL,'2025-05-22 17:32:41');
/*!40000 ALTER TABLE `ost_file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_file_chunk`
--

DROP TABLE IF EXISTS `ost_file_chunk`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_file_chunk` (
  `file_id` int NOT NULL,
  `chunk_id` int NOT NULL,
  `filedata` longblob NOT NULL,
  PRIMARY KEY (`file_id`,`chunk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_file_chunk`
--

LOCK TABLES `ost_file_chunk` WRITE;
/*!40000 ALTER TABLE `ost_file_chunk` DISABLE KEYS */;
INSERT INTO `ost_file_chunk` VALUES (1,0,_binary '‰PNG\r\n\Z\n\0\0\0\rIHDR\0\0\0\Ú\0\0\0(\0\0\0˜G\ä\É\0\0\nCiCCPICC profile\0\0xڝSwX“\÷>\ß\÷eVB\Ø\ð±—l\0\"#¬\ÈY¢’\0a„@Ņˆ\nVœHUĂ\Õ\nHˆ\â (¸gAŠˆZ‹U\\8\îܧµ}z\ï\í\íû\×û¼\çœ\çü\Îy\Ï€&‘\æ¢j\09R…<:\؏OH\Äɽ€H\à \æ\Ë\Âg\Å\0\0\ðyx~t°?ü
¯o\0\0p\Õ.$\Ç\áÿƒºP&W\0 ‘\0\à\"\ç
R\0\È.T\È\0\È\0°S³d\n\0”\0\0ly|B\"\0ª\r\0\ì\ôI>\0Ø©“\Ü\0Ø¢©\0
\0™(G$@»\0`UR,À\Â\0 ¬@\".À®
€Y¶2G€½\0vŽX@`\0€™B,\Ì\0 8\0C\Í L 0Ò¿\à©_p…¸H
\0À˕͗K\Ò3¸•\Ð\Zw\ò\ð\à\â!\â\Âl±Ba)f	\ä\"œ—›#H\çL\Î\0\0\Zù\ÑÁþ8?\ç\æ\ä\á\æf\çl\ï\ôÅ¢þk\ðo\">!\ñ\ßþ¼Œ\0N\Ï\ï\Ú_\å\å\Öp\Ç
°u¿k©[\0\ÚV\0h\ßù]3\Û	 Z\n\Ðzù‹y8ü@ž¡P\È<\n\í%b¡½0\ã‹>ÿ3\áo\à‹~\öü@þ\Ûz\ð\0qš@™­À£ƒýqanv®RŽ\ç\ËB1n\÷\ç#þDžýŽ)\Ñ\â4±\\,Š\ñX‰¸P\"M\Çy¹R‘D!ɕ\â\é2\ñ–ý	“w\r\0¬†OÀN¶µ\ËlÀ~\î
‹X\Òv\0@~\ó-Œ\Z‘\0g42y\÷\0\0“¿ù@+
\0͗¤\ã\0\0¼\è\\¨”L\Æ\0\0D *°AÁ¬ÀœÁ¼ÀaD@$À<B\ä€\n¡–ATÀ:\ص°\Z š\á´Á18\r\ç\à\\\ëp`ž\¼†	A\Èa!:ˆbŽ\Ø\"\ΙŽ\"aH4’€¤ \éˆQ\"\Å\Èr¤©Bj‘]H#\ò-r9\\@ú\Û\È 2ŠüŠ¼G1”²Q\Ôu@¹¨\ZŠÆ s\Ñt4]€–¢k\Ñ\Z´=€¶¢§\ÑK\èut\0}ŠŽc€\Ñ1fŒ\Ùa\\Œ‡E`‰X\Z&\Çc\åX5V5cX7vÀža\ï$‹€\ì^„\Âl‚GXLXC¨%\ì#´ºW	ƒ„1\Â\'\"“¨O´%zù\Äxb:±XF¬&\î!!ž%^\'_“H$ɒ\äN\n!%2IIkH\ÛH-¤S¤>\ÒiœL&\ëm\É\Þ\ä²€¬ —‘·O’û\É\Ã\ä·:ň\âL	¢$R¤”J5e?\奟2B™ ªQÍ©ž\Ôªˆ:ŸZIm vP/S‡©4uš%͛Cˤ-£\ÕКigi\÷h/\étº	݃E—З\Òk\è\é\ç\éƒ\ôw\r†\rƒ\ÇHb(k{§·/™L¦ӗ™\ÈT0\×2™g˜˜oUX*\ö*|‘\Ê•:•V•~•\çªTUsU?\ÕyªT«U«^V}¦FU³P\ã©	\Ô«Õ©U»©6®\ÎRwRP\ÏQ_£¾_ý‚úc\r²†…F †H£Tc·\ƍ!\Æ2e\ñXB\ÖrV\ë,k˜Mb[²ù\ìLvûv/{LSCsªf¬f‘f\æq\Í
Ʊ\à\ð9ٜJ\Î!\Î\r\Î{--?-±\Öj­f­~­7\ÚzÚ¾\Úb\ír\í\í\ë\Ú\ïup@,\õ:m:\÷u	º6ºQº…º\Ûu\Ï\ê>\Óc\ëy\é	\õ\Ê\õ\é\Ý\ÑG\õm\ô£\õ\ê\ï\Ö\ï\Ñ7046l18c\ð̐c\èk˜i¸\Ñ\ð„\á¨\Ëhº‘\Äh£\ÑI£\'¸&\î‡g\ã5x>f¬ob¬4\Þe\Ük<abi2ۤĤ\Å\ä¾)͔kšfºÑ´\Ót\Ì\Ì\È,ܬج\É\ìŽ9՜kža¾Ù¼\Ûü…¥Eœ\ÅJ‹6‹Ç–Ú–|\Ë–M–\÷¬˜V>VyV\õV׬I\Ö\\\ë,\ëm\ÖWlPW››:›Ë¶¨­›­\Äv›m\ß\â)\Ò)\õSn\Ú1\ìü\ì\n\ìš\ì\í9\öa\ö%\öm\ö\Ï\Ì\Ö;t;|rtu\Ìvlp¼\ë¤\á4éĩ\Ã\éWgg¡s\ó5¦K\Ë—v—Sm§Š§nŸz˕\å\Z\îºÒµ\Ó\õ£›»›Ü­\Ùm\Ô\Ý\Ì=\Å}«ûM.›\É]\Ã=\ïA\ô\ð\÷X\âq\Ì㝧›§\Â\ó\ç/^v^Y^û½O³œ&ž\Ö0m\È\Û\Ä[\à½\Ë{`:>=eú\Î\é>\Æ>ŸzŸ‡¾¦¾\"\ß=¾#~\Ö~™~üžû;ú\Ëýø¿\áy\ò\ñN`
Á
\å
½\Z³k™¥5»/>B	\rYr“oÀ\òùc3\Üg,š\Ñ\ʝZú0\Ì&L\ÖŽ†\Ï\ß~o¦ùL\é̶ˆ\àGlˆ¸i™ù})*2ª.\êQ´Stqt\÷,Ö¬\äYûg½Žñ©Œ¹;\Ûj¶rvg¬jlRlc웸€¸ª¸x‡øE\ñ—t$	\í‰\ä\Ä\Ø\Ä=‰\ãs\çlš3œ\äšT–tc®\åÜ¢¹\æ\é\Î˞w<Y5Y|8…˜—²?\åƒ BP/O\å§nMò„›…OE¾¢¢Q±·¸J<’\æV•\ö8\Ý;}Cúh†OFu\Æ3	OR+y‘’¹#\óMVD\ÖÞ¬\Ï\Ùq\Ù-9”œ”œ£R\ri–´+\×0·(·Of++“\r\äy\æm\Ê“‡\Ê\÷\ä#ùs\ó\Ûl…LÑ£´R®PL/¨+x[[x¸H½HZ\Ô3\ßfþ\êù#‚|½°P¸°³Ø¸xY\ñ\à\"¿E»#‹Sw.1]Rºdxi\ð\Ò}\Ëh˲–ýP\âXRU\òjy\Ü\òŽRƒÒ¥¥C+‚W4•©”\É\Ën®\ôZ¹ca•dU\ïj—\Õ[V*•_¬p¬¨®ø°F¸\æ\âWN_\Õ|\õym\Ú\Ú\ÞJ·\Ê\í\ëH\ë¤\ën¬\÷Y¿¯J½jA\ÕІ\ð\r­\ñ\å_mJ\Þt¡zj\õŽÍ´\Í\Ê\Í5a5\í[̶¬\Û\ò¡6£\öz]\ËVý­«·¾\Ù&\ÚÖ¿\Ýw{\óƒ;\Þ\ï”ì¼µ+xWk½E}\õn\Ò\î‚ݏ\Zbº¿\æ~ݸGwOޏ{¥{\öE\ï\ëjtolܯ¿¿²	mR6H:p囀oڛ\íšwµpZ*\ÂA\åÁ\'ߦ|{\ãP\è¡\Î\Ã\Ü\Ã\Íߙ·\õ\ëHy+\Ò:¿u¬-£m =¡½\ï茣^G¾·ÿ~\ï1\ãcu\Ç5Wž (=\ñù䂓\ã§d§žN?=ԙ\Üy\÷Lü™k]Q]½gCϞ?t\îL·_\÷\É\ó\Þ\ç]\ð¼p\ô\"\÷b\Û%·K­=®=G~pý\áH¯[o\ëe\÷\Ë\íW<®t\ôM\ë;\Ñ\ï\ÓújÀ\Õs\×ø\×.]Ÿy½\ï\Æ\ì·n&\ݸ%º\õøv\ö\íw\n\îL\Ü]zx¯ü¾\Úý\êú\ê´þ±eÀm\àø`À`\Ï\ÃY\ï	‡žþ”ÿӇ\á\ÒG\ÌG\Õ#F#\r\Z½\òdΓ᧲§\Ï\Ê~Vÿy\ës«\ç\ßý\âûK\ÏXü\Ø\ðù‹Ï¿®y©\órï«©¯:\Ç#\Ǽ\Îy=\ñ¦ü­\Î\Û}\ï¸\ïº\ßǽ™(ü@þP\ó\Ñúcǧ\ÐO\÷>\ç|þü/\÷„\óû€9%\0\0\0tEXtSoftware\0Adobe ImageReadyq\Ée<\0\0(iTXtXML:com.adobe.xmp\0\0\0\0\0<?xpacket begin=\"\" id=\"W5M0MpCehiHzreSzNTczkc9d\"?> <x:xmpmeta xmlns:x=\"adobe:ns:meta/\" x:xmptk=\"Adobe XMP Core 5.6-c014 79.156797, 2014/08/20-09:53:02        \"> <rdf:RDF xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\"> <rdf:Description rdf:about=\"\" xmlns:xmp=\"http://ns.adobe.com/xap/1.0/\" xmlns:xmpMM=\"http://ns.adobe.com/xap/1.0/mm/\" xmlns:stRef=\"http://ns.adobe.com/xap/1.0/sType/ResourceRef#\" xmp:CreatorTool=\"Adobe Photoshop CC 2014 (Macintosh)\" xmpMM:InstanceID=\"xmp.iid:6E2C95DEA67311E4BDCDDF91FAF94DA5\" xmpMM:DocumentID=\"xmp.did:6E2C95DFA67311E4BDCDDF91FAF94DA5\"> <xmpMM:DerivedFrom stRef:instanceID=\"xmp.iid:CFA74E4FA67111E4BDCDDF91FAF94DA5\" stRef:documentID=\"xmp.did:CFA74E50A67111E4BDCDDF91FAF94DA5\"/> </rdf:Description> </rdf:RDF> </x:xmpmeta> <?xpacket end=\"r\"?>‹þ\ö\Ê\0\0IDATx\Ú\ì]	œS\Õ\Õ?/{2\Édf€aq]67\ÐÏ­(*¨-\n\ö\ó³¶.\õ+\Öօº nµJÁ­\öS‹R´\Õ:VDT¤,e\Ñ2¨l‚ ¬‚\ì‹3\Ì\ÂL’—\÷ݛüos\æN’\ÉPq\Ìùý$“—\÷\î»\÷ü\ÏùŸs\ï»1†NY96¤\Út\Ò\Ø\î\ïS±/Q\Äý]k~K¡“…\îz›\Ð\í>ƒ%4ߤ\Ò5ºú­<²\Ù,²\ÍclmY\ó\Î\Ê’„ž\'\ô\ÇB¯h\ô·£B\óLZ¸\ÞM?›¤°\0]s
™G\Ö>¾\×\âZ(4W¨]h\r\"Ò¾&F4™]þ¶?JKD$úF>Yd-}QŠZY e\å»)­„ž*t€\Ðӄ¶\ê\à$»‰\r	=(t•\Ð\éBg	=Á¹\íø_‚´¢Ñ”Q\0m\ÆV\í+³SvaŠD›W\Çg\öýŽB¯ú¿B»eø\ÞB¯ºL\èH¡\Ò›#t\ó»B\Ç	ýmFW’\0;t\È _Ž\Ù\ì@–\Íњ¿x„\Þ.t!¿[\Î!#\à\\¡\÷\ã|\É\äWˆ’:\÷\Ø\rG³ I³·9\é‰\Ò*ʍ6ˁ\È­ùJk¡S…þA\èqGÀN
¼\09¤›EB\ïM¹~-4?홝\Õ~\ã I‹}\Ô&·y\åeY\ê\Øü\å¡o\n\íu„\Ï{.r»½Bk
¸\Öiv?Š—úLG·´Ñ”µj\È-+\ß‘Q散\02%>\ä|™\Ê\ï(^\Í›’\ß\n\êX\è\Ær³\æT\Ò\ÏR\Ç\æ-’*\öÿ–®-\ã\ÑR¡Ë…V±¿\ËBI\Ë:G\ÊT\Ì#þ\É5iþ\ZE\"F\ó”lD;\æ\\_\äp¾ýsj\Êd\ñ‘“\õB\"t‡\ÐB)\ô2\äw\ß\Ä\ïϊ»\÷`”\æ­\ôФ•^š¶\ÑMnA!\æ<¬Y\Ë>†¼ž¥’\í§\ö\n«kt\õM\æJw%ù»œ<.ÿ\Ý\Â\ÃB¿U\\G\ñBI?禓]\0\Ìo\Æ\Ð\ô\å^ý\ô¥ºeF&.\÷‘\×a‘\Ça5\ï±Íš\÷±#Ò£o>¤=L^«\Ñþ]FŽž\Ú\ßJ…N\0ƒG¹ùㅾV‡\Zú¢!q#!\Å–\Û\éÀ6=X\ê§9›\\T2\Èﲨ{«™c\Ñ捳,Ў)zak³l´ú@1\õ\Ï\ß{¡„^£ýMF”¡_b\Õ\æ(7ý9¡£­‘+\'J«\Ö{h\ñ—n\ꐡ[\\\ôhiµ\óGc41\'\'±M\ëû1¶Ž³\Ï>;k\áǐL›¿Œ\Þ\Ü݋ú·\Ø$\Ü|\Æ~\ð,Š—Ý•”
x\ß ¶l\Ú\â(4W.\Ó\ZAjՈ\Âr\â\ãsr\ÉWµ\ÉM\ÐW”r\Ý\"zµhž«>²\í;™§Y”窊E,0ތ\\¾\\1\ïb\ﺯ\å\"\á\'„¾‘Áx\Ëü\êu\ÐLY\ÌÈ£x9\ß)´ù^[\0›P\ôXV\ç‚NX\á¥Í»T(\"Y¶‰u‹\ßWevŠÝˆRU\ØC55A\ò\ØC™\ÐGY6?‘½ÿ@\è«\Ú1k„VS|‚9\ÈI\îX\Ê\è£\Ä*rD\Ê\"€\öL¡ƒ„ÎŽ
=*@4\é«=N\ÊwZj‰9¾%p\É\ö\Ê%a\í\ñ~\ÐyBe–•˜ø\íµ´¢¢\r•\ì\ìK\Ã;HT\ëo\è+ƒ)¾Q\É_Ÿt¡\Ô\ë‰cI\ìUžÈ±B\"”VÚª\ÈVg>L\ÊvW¦S\â1›|\òX»¶\îpÑ°\Éy´\í Zx£rR­\Å\'·# °)ý\ÅWšHª[ ԍ\ö\ʺ±	\Ý(#\ò=B2ŠûC¡Û²@\ËJL,H$\Ëݵ(\ñŸN)2š©°\'¿›ä˜®\Zµ\Ô/*\Ï\ð\'rZŸKD\ÜûV((\ß\Õg	Œ²Å›{€\ÆP“]aY\Ç ¹jߊ=B³\n\"4~n€VnwR\÷¶‘XŽF\ñUÿrQsΐJd\ä\Ü\Zz¾\ô7\"\ày¡7e©cVŽŠ¸ª\éý½\Ý\è\ä\à\ê%”BþT`\Ë…S\òO\Ð;]NNy±X\Þz7\â¶s´\Ñ}\ó\ô\ä‡~j/¨ß¬\rnª´·\ÒF\Ãz\×\Ð\È*ˆ\Äf–ۉ洌5)\×\ÜEž\è¡EK|\ô\Öj·4\Èù
4\rI.\ò–”x¶\Í\Û\Ä.ŒjÀ6ˆ¨GJŽG_\÷†Ó˜‘Zz1`Nx\ãPŠ\ã<8¦^þ\È$6“v\ÔhUY\õ\n\ìG¶\ä\ójrÞ¬/^\ïDŽ¥‹¤a\ÝSš£ÛšIm·Lœ•\Zû^ fZ\ˆA36ºck \å{,\Z9 Rܱ@WµQ% °Z\äd\ó·\×\ãWm\ö†ož–\'rKŠ\ÇJ\öŠ\öU0\Ã7YÞ§D~&*¯\Ø\ò\Ñÿ•‡1~ÿ\é…&=PH:	\ï\ÇeÖ°È~
¹|\Ôd4ş:\æ҇\â\ë\n\Û\ã˜{Ž\ÔÅ£Tǹ+h²,\ó‹ˆ\Ö9wwª\Íz\äüX\0¯¿ý\Ò\å-‡K€\ÌN/R\Û\ð\Í\Ï\Ì\Ì\r\Ý3-H…h+Ÿapymv+\Ò\Êgɧ¥7·\òE#\ó¶:\é\ê’*¹\ò€\Û\êZ;xù\×΁w\É*‰¯Kq¨8W\àQ€\̀ȶ<\ð{Xž&Ò£”xPTR\Ï;Pđ ü#œ—›š²%·\'\í\ÈH/¼d–¢&A\ñy©ø?™• ²\åLjȇ6\á=\"²9¡t9\Z_¨»2I$\Û\õ\0\éK\í,\Ú-\"\Ùh
²žùg.\Ýþv°°8ß¼\Éa‹=¨Ùž]MV*D-z²c0:\òz7y\ßÉ£Gϯ(/y=¿|Ò§^[¹Óº¶ca\äq>ѺQj‹\Ð\Ç)¾bD—¯\ÙkyƒŸJ@\ãý\Öc˜\å¤K–·¡ £leh\rK„\Ñ\Å)¨\ãAxnývF8\r“J¶Bww*%Gl^͖̋*ùDûLV\Üþ†ª —)Q\ÓxÀ\æ1\×NT\ñ7o\æ\Ñ.\ß|\Îe§S¢V\ì>^„\Ñ\Èü\èB/‘\ZŽÒ½\Ç\ÍqSE\Þ\ö\Å>;-\Þ\î41út¯\ö¡¦iD\Å瓍8U”}\'\Ñ\"\ôOB\Ïz–#\ñœ\Í\Å\Þw¢ø–v8;¹„\ìIºF>\È:Ô¹³㰀\âO4D\å\å³r—‚\Ö\áŒ\ÆS\Ým\ò.¦øF!%¦8䊛I¬‚y\"úº“†§‹\á„e\Û*H\àNE\Ãf£t5\Å\çK#Á®L’›B\â\ç\ÅEÁ3\ã\Ù6P• \Ëý$ŠV72\ö\ã;\Ü\èP\"1úÓȹ ù\à\ò\Ä¡Ú¹ƒ\Ô\\y¨\Õ \ä(ªrÿ\"ªW²>•ƒª\ÝzúS\ñ}‹\ê|?AŸ\È6N£øŠy΋p9H«’\0¢­Š\Ä6\Â1‹6ʧP\ÔZ}i\Í\"§²R7\Å%’\ÞO\Þ\èčû\íыkCU!j/@61\à²z	\Ê\'\ó‰[„~¥\åw×£ú7V\0q_®+\ö}\ê˜o^e4\"6¶‰Ž½Â¨\ôs„þ¶\ô!\Å\×\\r\â\ÊkžJN­T\ò—$@“Q\÷Nª¿®S\Éù ¥\é\æ\Ì$yZ(_\õ:\ë{\éÀ\äW
,”¤\r·
/ƒ¹u¹\Zs\Öx†\çÑ°qh\è\Ø\æ‚\ç«\Ð.Ÿ\Þ}	žŠ‹\ìg(¾b[\Z\Ös\ðL7\ãüRF¡\ä+¯%¡(Á\ßG\Ã8\"\ð4¤r\ê)\Ú5V\‚6I\ÙF\õ\r:\ï XR>9±\ÚQ;G)Ú´\ï\ï¦øÀ^–\ÓLÈ°R\Æ#‹\Ì\Ó.c\à/ \õÀ5/d\ÔIzf9¹,\ç›\æ}Og+>{8¾²¾xq\ï*\ê\îÀk¹‚^\ßZ`5¢\Êr¹uÀ\ÜuúºÊ ¾\è\"’I\ÍE[uT‹\\µ\n\ÑqŒ\È\ßf\åº-\éϵ\âͺ/I4%8´{0\Æ7\"W+k «
¼T…ŒGa_\édC:¶\ö¨2\Ù\Æ\á¸\ßv\0\ÝY\ì\óµ\È-»£\ß{À¶ú0ǟN\ì6Vý\ñ\Â\àû!1ýšyˆ
š\0@LF™y\è@:\ö:x\æ:¬/+EŸÃ®u.^f=0	²W\ÈV\"b…¦K\Ð5¬3G \í„ht¸#À+Á\õ>?\÷\àǽ=‚\ö˜0Ž}0ž\Ît É¼\×´u\rþVˆ¶\Ê9¬)ŒftѼ~;¼žWŸ9Xt\ÈtƊ#)\n6Exý9r¢\ó\á8¸¼\ë_K€\Ì¥g\è‘—\æDûŠœ\쬚¿+	ȸ¼\n\ì\áZ­\ôþuš\ï-@\ßG\ð\ÝL\Ê\ò©¢\ÝM\Z\È\Â`\Ò\ñ^N\ñ\r‚^F¥È«	\Ç\Ý\È\Þ\Ï` #¸\ÎbL\åFD\Ú~”x֎@7Ÿ„\Ó:\É\Ûþ!l\ò1Àl\Z—•\'þ9@p)‹b\á
PbN\æUP®\óq¬\â¬\÷
\ñþt€\è8’\"–\'ª\r\\&!ª²·\ã&OGGׂb\Þnf`]\Ê0\ç\èN=m?‘\Ïk\õ\Â\ë\ÛX\ïF$?µ±2übP\n±Áؕp¶0˜\ë{\õEAoh¿Œ|®\êdùY\ë·E,\ÇqjQe˜0\×\íT`\Ò\ËK|4bf.\äD\Éf‹\õ‡Œ\Úo³\èžN\ÔDøÁª\Òý=l,uف1¹\\£¤•v\ßU‹‹¼\îP°šwÀB®G_û)1§\0»NŸo©°¡–¥C\Ø\ç\Ä\Æ\ç&ҁû\Ø痁\Í<
Pq~ÿ6ª®²cmZ˜žÀ\æb>\Æ	”\\£U†\ñ£ÿ‚\' øyø>!ܶF¾\äG´,\ÍG\ä²\ÊMO\Éf \Ê
uQ\ç\ìÀ\Õ\àýnxª©ˆŠªH\ðrL<\Ü4Š?f/\å qR¦ƒ\êJÊ¿É¤%e\"£‰\È2Žs!Ö§Œ!¨¯\'\ó~\Ë\ëp\r#Je\å¹+R=u\Ëúm£^J¾‚U’|¨²\ÊF\ïop“C¼\öú(h_oI3™\Ì]puB4û+®q.¢\ÖC—¶I[\ÙIM›gTm(‹üF\ò‡Fœg/\"\êX–·®Aÿ\ð]™¯\03#°¨)I\Î5\ã­r\Ø
¬ÀcÓ¨}ʪ\ãG\Úû…@©@Q¾|\0º\ÂE
(ˆN‘ž\åw”\ØÌ¥þuD\ÎK\0–þh\Ô*\äYªC¥.ƒ1\Û\àUrX4<žy¢\Å̐;²\Èù_B¿@‡D1p~mx\ÞV\ËÞ¯\è»g´5Ze\ò+x\Ð\ã\àH¶\Ì\'\ÃP\rD龬Ÿ\ë€lw­Ÿú\öP\Í\Ìdùx\ì>]h\÷ü­B‹°›\ÕG¼¾\ÔG¯­\ðR·Âˆ|\È\Ò`ýœ\éQ\ì\êv\ð¢\ÛÓ ÀB¿†C,EROøg*µ\÷/6\òû9 pª8!Ä­Œ\æ씯 q\"BZ45xH2Å¢-G: ™I83%©¾\Õ$\ñ‚|™‹aY\Û\0
<Ü´¤Z½\ÈW³›\Ø0\ì&ª\Ñ\æ\ÏaTn\Í\àU¹\Øâ\ÓZtš¦epª\Z\Ø\Ôi#E¿™ŒF¨6\Îý\é*\Û\í\\\ç\óo¾­&H\'	=\Ðc6¹m\"Ķ6¨W\é\Æ\ÜJVQSq*겨b§“¦,\óQ› ©žd¶±{\Î4\Ò\ð{r²±\Êu!Ʋ\è\×F¡n£¦-赒\Ì–7a®\íL­¸‘ƒ\ê7i@\ã{PžL閮%$\Â(\Ð\ô\'qû°c¶€\Ãw`ž”`@ùˆ5	´e\öÀ°\Ô\ã\Z—²\È\ò9ÀfÕ£¡š—V%\õ®¯¢“M(–ëúq\Îa\ðú\ês¾\ß\÷Q€\è¨w^\Ë“w\Ò\nRZ0Dz‹E\ÍO\àtn`Ň\Å藸eY=\Þm.ù\÷’\'2_ªýCN`Æ®Š(!–k\ÇûM\Ðčû4u›º%¼4)±H¦[ø\Ð/ª;
\õý}\\Œþ8›*\äXüŒ\Ô=Mwh\r\Zt\n\Ñ\\\'\"\Ü\nƄ\ìZ~M3µ-9\Ù8\ÚR8‰¤g†_@uWNÀ\æ4º²ê“šÏ¹›5b5\Ë\óT^RcSVh§b\à>b\0#\ä\Ø5:¡,ûw\ÌcT§¨Pma\×ù¢ú¼\'¦ þE	e0\ÃXԎBI‹Fx\\y¾•ÀU\ì\õ\"­8¡rŽ\ã\õ[ü„E\Þr:!5ˆdIA–\Çh\í\'Z4Wt°¶¶¯g\Î4醲\öv\ä<\ÇQý]ˆ-\ôÿ\\\â\ØA(5`m,¯	皌‰’V¨\ZúXd¯\Ñ*¦\çPbŽ\õ<¦B%+û#c.V* \é\íPŽ”˜,Vՙy(:Œ\0°F#\"|Fu7†™Áªl+\0(¿–´\ïŀ\ôb\󟲂\Ì`xڗPRý7՝*)ù.^U(\è\\ŽÎœŠ\÷;
†¶è„«PЙ\0ƒy—\ZÀ™\ê\Ç\ñ\èü\0ˆj\Ë\ì8™§ý\Z\Ç\Ð\ó“\Þ\Ýy
\Ùd…Q\æe©Ÿ®Z\ó	\ÆEOÀ·ý\Ûh\Âu)ˆ\Ð\Ðîµ´h»3¶!›[SU\Ä\'¨\á_Œˆqü¢\õ\Ç(.ý”RO¯B\Ñb\òºW›Ѷh\ï¯Ô‹G\r\ÈN«\ÖÀ)ž\Î\î\é|V¦FühÿÁ&D]\î\ô\êE4 ky6hw\â\õ =\ß\à\Ä?D©½\'›³¹•uüb-\áTsû˜G•²”y­yˆ¬`8—¢\ß\Ç<…\na+V\Â\rh\÷2	\óxš«1\×іMA¼y—)l\Þk$¸ü³¬H‘\Ãy™7üýt\r¢•j\ËH\ô
/6-\ÓJÀu&<}\"¢Qĕn@{³j\ðK\Zµ.`-N±Bچ\éšÓ«hµM/^•‚\\߀1vS\Ã/GJP”!½6#¢½£9¶:Cbý±\ö\ð€\æDčR\Ý_\Ì9ø†C\r‹þSU]SE4;¼\ò\ÐBªo¯\"¢(ùø\÷Px)\'Œ\å̵pʲ\Ô	ޝӜ{
ˆP\ï4	þ\å0,@:\ÑL•\\j\Õ_\ðùgù08‚0\îc‹\"!\Ü\ë,x77®\ñ\Z\n\ðdû\"~h\àƒ\ç“\çºù\Þ~P•9I¸ý,FS\ç\Ô;km@F2?\n%û5z|:ú¸5h\ÐD\í\ÛC\ØtG\ÂTET“\å}-þ\Ëqz\ç{\n¥ûiI\î³Q¿3þ#\æ\Ìdtþ-\Æ!\ÙDWD\Ò#w#e&°š\Z\ñÀQNDûw•€Ý”j\íq²¢\Ô{p¤£k›§£+܏{gZÇ«rÐ¥l«Á\"ülŽm$l\Ûp$I?€1»`<\Éø\Ë:$“\ê\ìBi\æb–B“c]š\Î݀k8q°vC”d’W“\èxU\Þ\'¹yž¿À¡¬ \ðQ’\é.ˆ=o…3µV…˜ %–þ|F\õ\×=ŠV\Ê+­ž$‹E\'^9O\õ7K\í
\ÏL\õƒè½²Z…\äÈ«³I\Î4xø‡a°\Ï\ÂA•\á>\Î\ÄgÐ·³³¾\0`_c:\ZÁ˜\rF´(D\ä~@3Ñ·3)±¾S:¸\ß _?𵀓\\¨M)\è´\î8\Ö~x/\Æ\ïÁ\ÆF!\ÕPn\ép/ؽ\å\Ø%h[p݋Xes,ھđ¢\nieL\Ó˜\ÉD\÷JKKr\Öu”A˜)JÀw\"\öd´±þ\ò¥x^¶\Ì\âW\Èû\np\Ó\É\æ$¹\Æ\0D\÷(¢-‹]]¢\Ó:†hk¹\çi„üd3þ¿ª\ñ+\ð\î;\Ø\ßUnþ4\nKɶP(P\Çhý\ë\×\n;^»Æ²”,]|ž
„X¾Ë«±Tw	Vž\Æ\Þv\0¼uª¿à¾žbS(Á\ÕٖZ?=g`x’\ÚÑ¡5ÀMY9\Z’ƒ\\Sl3¨e:Y	j\æBn©v¡J5—sûz\ҝS\Ð\Æ.\'\Ô\Ò%›jh̜€\0Z=_\ð\Z¢\ó¥˜\öh
`oe[š\âº\Ë)\ñ#\ñ2§i°\읟M\É7יŽbV\÷\õ«„N@t\òSý_]Š\ëýÿwfHu͙He¦\ãm\Ð\éÿ\ÛHk ZµDÛ½ø\î\'(˜ƒŠ¹NT»\ç|_;\ç\"´\ëVJLÉ”i¾\ñ\ò\Ë/\÷BhŒ ‘³¸8\â\"©\Æ/\á!w\Âûš\ìÀ\ë\ÊF5\åüvT!+QÁ­/A“FOҘ\Ò\ê4›CŸ\Zp0jC•\nJ\Ì\'6¸£Qš~\Ô7vD3/\ØB5¨ª\Õ@\ÛZ p\É\ã\Ëþ_€
\0³à¯˜s]Jý\0\0\0\0IEND®B`‚');
INSERT INTO `ost_file_chunk` VALUES (2,0,_binary 'Canned Attachments Rock!');
/*!40000 ALTER TABLE `ost_file_chunk` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_filter`
--

DROP TABLE IF EXISTS `ost_filter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_filter` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `execorder` int unsigned NOT NULL DEFAULT '99',
  `isactive` tinyint unsigned NOT NULL DEFAULT '1',
  `flags` int unsigned DEFAULT '0',
  `status` int unsigned NOT NULL DEFAULT '0',
  `match_all_rules` tinyint unsigned NOT NULL DEFAULT '0',
  `stop_onmatch` tinyint unsigned NOT NULL DEFAULT '0',
  `target` enum('Any','Web','Email','API') NOT NULL DEFAULT 'Any',
  `email_id` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(32) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `target` (`target`),
  KEY `email_id` (`email_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_filter`
--

LOCK TABLES `ost_filter` WRITE;
/*!40000 ALTER TABLE `ost_filter` DISABLE KEYS */;
INSERT INTO `ost_filter` VALUES (1,99,1,0,0,0,0,'Email',0,'SYSTEM BAN LIST','Internal list for email banning. Do not remove','2025-05-22 17:32:39','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_filter` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_filter_action`
--

DROP TABLE IF EXISTS `ost_filter_action`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_filter_action` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `filter_id` int unsigned NOT NULL,
  `sort` int unsigned NOT NULL DEFAULT '0',
  `type` varchar(24) NOT NULL,
  `configuration` text,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `filter_id` (`filter_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_filter_action`
--

LOCK TABLES `ost_filter_action` WRITE;
/*!40000 ALTER TABLE `ost_filter_action` DISABLE KEYS */;
INSERT INTO `ost_filter_action` VALUES (1,1,1,'reject','[]','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_filter_action` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_filter_rule`
--

DROP TABLE IF EXISTS `ost_filter_rule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_filter_rule` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `filter_id` int unsigned NOT NULL DEFAULT '0',
  `what` varchar(32) NOT NULL,
  `how` enum('equal','not_equal','contains','dn_contain','starts','ends','match','not_match') NOT NULL,
  `val` varchar(255) NOT NULL,
  `isactive` tinyint unsigned NOT NULL DEFAULT '1',
  `notes` tinytext NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `filter` (`filter_id`,`what`,`how`,`val`),
  KEY `filter_id` (`filter_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_filter_rule`
--

LOCK TABLES `ost_filter_rule` WRITE;
/*!40000 ALTER TABLE `ost_filter_rule` DISABLE KEYS */;
INSERT INTO `ost_filter_rule` VALUES (1,1,'email','equal','test@example.com',1,'','0000-00-00 00:00:00','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_filter_rule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_form`
--

DROP TABLE IF EXISTS `ost_form`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_form` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pid` int unsigned DEFAULT NULL,
  `type` varchar(8) NOT NULL DEFAULT 'G',
  `flags` int unsigned NOT NULL DEFAULT '1',
  `title` varchar(255) NOT NULL,
  `instructions` varchar(512) DEFAULT NULL,
  `name` varchar(64) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_form`
--

LOCK TABLES `ost_form` WRITE;
/*!40000 ALTER TABLE `ost_form` DISABLE KEYS */;
INSERT INTO `ost_form` VALUES (1,NULL,'U',1,'Contact Information',NULL,'',NULL,'2025-05-22 17:32:37','2025-05-22 17:32:37');
INSERT INTO `ost_form` VALUES (2,NULL,'T',1,'Ticket Details','<p>Please Describe Your Issue</p>','','&lt;p&gt;This form will be attached to every ticket, regardless of its source. You can add any fields to this form and they will be available to all tickets, and will be searchable with advanced search and filterable.&lt;/p&gt;','2025-05-22 17:32:38','2025-05-23 11:17:24');
INSERT INTO `ost_form` VALUES (3,NULL,'C',1,'Company Information','Details available in email templates','',NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form` VALUES (4,NULL,'O',1,'Organization Information','Details on user organization','',NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form` VALUES (5,NULL,'A',1,'Task Details','Please Describe The Issue','','This form is used to create a task.','2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form` VALUES (6,NULL,'L1',0,'Ticket Status Properties','Properties that can be set on a ticket status.','',NULL,'2025-05-22 17:32:39','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_form` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_form_entry`
--

DROP TABLE IF EXISTS `ost_form_entry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_form_entry` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int unsigned NOT NULL,
  `object_id` int unsigned DEFAULT NULL,
  `object_type` char(1) NOT NULL DEFAULT 'T',
  `sort` int unsigned NOT NULL DEFAULT '1',
  `extra` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `entry_lookup` (`object_type`,`object_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_form_entry`
--

LOCK TABLES `ost_form_entry` WRITE;
/*!40000 ALTER TABLE `ost_form_entry` DISABLE KEYS */;
INSERT INTO `ost_form_entry` VALUES (1,4,1,'O',1,NULL,'2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_form_entry` VALUES (2,3,NULL,'C',1,NULL,'2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_form_entry` VALUES (3,1,1,'U',1,NULL,'2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_form_entry` VALUES (4,2,1,'T',0,'{\"disable\":[]}','2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_form_entry` VALUES (5,1,2,'U',1,NULL,'2025-05-23 11:26:27','2025-05-23 11:26:27');
INSERT INTO `ost_form_entry` VALUES (6,2,2,'T',0,'{\"disable\":[]}','2025-05-23 11:26:27','2025-05-23 11:26:27');
INSERT INTO `ost_form_entry` VALUES (7,1,3,'U',1,NULL,'2025-05-23 11:32:26','2025-05-23 11:32:26');
INSERT INTO `ost_form_entry` VALUES (8,2,3,'T',0,'{\"disable\":[]}','2025-05-23 11:32:26','2025-05-23 11:32:26');
INSERT INTO `ost_form_entry` VALUES (9,1,4,'U',1,NULL,'2025-05-23 11:36:03','2025-05-23 11:36:03');
INSERT INTO `ost_form_entry` VALUES (10,2,4,'T',0,'{\"disable\":[]}','2025-05-23 11:36:03','2025-05-23 11:36:03');
INSERT INTO `ost_form_entry` VALUES (11,1,5,'U',1,NULL,'2025-05-23 11:40:16','2025-05-23 11:40:16');
INSERT INTO `ost_form_entry` VALUES (12,2,5,'T',0,'{\"disable\":[]}','2025-05-23 11:40:16','2025-05-23 11:40:16');
/*!40000 ALTER TABLE `ost_form_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_form_entry_values`
--

DROP TABLE IF EXISTS `ost_form_entry_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_form_entry_values` (
  `entry_id` int unsigned NOT NULL,
  `field_id` int unsigned NOT NULL,
  `value` text,
  `value_id` int DEFAULT NULL,
  PRIMARY KEY (`entry_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_form_entry_values`
--

LOCK TABLES `ost_form_entry_values` WRITE;
/*!40000 ALTER TABLE `ost_form_entry_values` DISABLE KEYS */;
INSERT INTO `ost_form_entry_values` VALUES (2,23,'SOC-Desk',NULL);
INSERT INTO `ost_form_entry_values` VALUES (2,24,NULL,NULL);
INSERT INTO `ost_form_entry_values` VALUES (2,25,NULL,NULL);
INSERT INTO `ost_form_entry_values` VALUES (2,26,NULL,NULL);
INSERT INTO `ost_form_entry_values` VALUES (4,20,'osTicket Installed!',NULL);
INSERT INTO `ost_form_entry_values` VALUES (5,3,'5551553',NULL);
INSERT INTO `ost_form_entry_values` VALUES (5,4,NULL,NULL);
INSERT INTO `ost_form_entry_values` VALUES (6,20,'RANSOMWARE!',NULL);
INSERT INTO `ost_form_entry_values` VALUES (6,22,'Normal',2);
INSERT INTO `ost_form_entry_values` VALUES (6,36,'2',NULL);
INSERT INTO `ost_form_entry_values` VALUES (7,3,'5551390',NULL);
INSERT INTO `ost_form_entry_values` VALUES (7,4,NULL,NULL);
INSERT INTO `ost_form_entry_values` VALUES (8,20,'More bandwidth needed',NULL);
INSERT INTO `ost_form_entry_values` VALUES (8,22,'Normal',2);
INSERT INTO `ost_form_entry_values` VALUES (8,36,'3',NULL);
INSERT INTO `ost_form_entry_values` VALUES (9,3,'5551901',NULL);
INSERT INTO `ost_form_entry_values` VALUES (9,4,NULL,NULL);
INSERT INTO `ost_form_entry_values` VALUES (10,20,'Spotify Install',NULL);
INSERT INTO `ost_form_entry_values` VALUES (10,22,'Normal',2);
INSERT INTO `ost_form_entry_values` VALUES (10,36,'2',NULL);
INSERT INTO `ost_form_entry_values` VALUES (11,3,'5551290',NULL);
INSERT INTO `ost_form_entry_values` VALUES (11,4,NULL,NULL);
INSERT INTO `ost_form_entry_values` VALUES (12,20,'Phish?',NULL);
INSERT INTO `ost_form_entry_values` VALUES (12,22,'Normal',2);
INSERT INTO `ost_form_entry_values` VALUES (12,36,'3',NULL);
/*!40000 ALTER TABLE `ost_form_entry_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_form_field`
--

DROP TABLE IF EXISTS `ost_form_field`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_form_field` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int unsigned NOT NULL,
  `flags` int unsigned DEFAULT '1',
  `type` varchar(255) NOT NULL DEFAULT 'text',
  `label` varchar(255) NOT NULL,
  `name` varchar(64) NOT NULL,
  `configuration` text,
  `sort` int unsigned NOT NULL,
  `hint` varchar(512) DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `form_id` (`form_id`),
  KEY `sort` (`sort`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_form_field`
--

LOCK TABLES `ost_form_field` WRITE;
/*!40000 ALTER TABLE `ost_form_field` DISABLE KEYS */;
INSERT INTO `ost_form_field` VALUES (1,1,489395,'text','Email Address','email','{\"size\":40,\"length\":64,\"validator\":\"email\"}',1,NULL,'2025-05-22 17:32:37','2025-05-22 17:32:37');
INSERT INTO `ost_form_field` VALUES (2,1,489395,'text','Full Name','name','{\"size\":40,\"length\":64}',2,NULL,'2025-05-22 17:32:37','2025-05-22 17:32:37');
INSERT INTO `ost_form_field` VALUES (3,1,13057,'phone','Phone Number','phone',NULL,3,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (4,1,12289,'memo','Internal Notes','notes','{\"rows\":4,\"cols\":40}',4,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (20,2,489265,'text','Issue Summary','subject','{\"size\":40,\"length\":50}',2,NULL,'2025-05-22 17:32:38','2025-05-23 11:17:24');
INSERT INTO `ost_form_field` VALUES (21,2,480547,'thread','Issue Details','message',NULL,3,'Details on the reason(s) for opening the ticket.','2025-05-22 17:32:38','2025-05-23 11:17:24');
INSERT INTO `ost_form_field` VALUES (22,2,274609,'priority','Priority Level','priority',NULL,4,NULL,'2025-05-22 17:32:38','2025-05-23 11:17:24');
INSERT INTO `ost_form_field` VALUES (23,3,291249,'text','Company Name','name','{\"size\":40,\"length\":64}',1,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (24,3,274705,'text','Website','website','{\"size\":40,\"length\":64}',2,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (25,3,274705,'phone','Phone Number','phone','{\"ext\":false}',3,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (26,3,12545,'memo','Address','address','{\"rows\":2,\"cols\":40,\"html\":false,\"length\":100}',4,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (27,4,489395,'text','Name','name','{\"size\":40,\"length\":64}',1,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (28,4,13057,'memo','Address','address','{\"rows\":2,\"cols\":40,\"length\":100,\"html\":false}',2,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (29,4,13057,'phone','Phone','phone',NULL,3,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (30,4,13057,'text','Website','website','{\"size\":40,\"length\":0}',4,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (31,4,12289,'memo','Internal Notes','notes','{\"rows\":4,\"cols\":40}',5,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (32,5,487601,'text','Title','title','{\"size\":40,\"length\":50}',1,NULL,'2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (33,5,413939,'thread','Description','description',NULL,2,'Details on the reason(s) for creating the task.','2025-05-22 17:32:38','2025-05-22 17:32:38');
INSERT INTO `ost_form_field` VALUES (34,6,487665,'state','State','state','{\"prompt\":\"State of a ticket\"}',1,NULL,'2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_form_field` VALUES (35,6,471073,'memo','Description','description','{\"rows\":\"2\",\"cols\":\"40\",\"html\":\"\",\"length\":\"100\"}',3,NULL,'2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_form_field` VALUES (36,2,13057,'department','Department','',NULL,1,NULL,'2025-05-23 11:17:24','2025-05-23 11:17:24');
/*!40000 ALTER TABLE `ost_form_field` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_group`
--

DROP TABLE IF EXISTS `ost_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int unsigned NOT NULL,
  `flags` int unsigned NOT NULL DEFAULT '1',
  `name` varchar(120) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_group`
--

LOCK TABLES `ost_group` WRITE;
/*!40000 ALTER TABLE `ost_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_help_topic`
--

DROP TABLE IF EXISTS `ost_help_topic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_help_topic` (
  `topic_id` int unsigned NOT NULL AUTO_INCREMENT,
  `topic_pid` int unsigned NOT NULL DEFAULT '0',
  `ispublic` tinyint unsigned NOT NULL DEFAULT '1',
  `noautoresp` tinyint unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned DEFAULT '0',
  `status_id` int unsigned NOT NULL DEFAULT '0',
  `priority_id` int unsigned NOT NULL DEFAULT '0',
  `dept_id` int unsigned NOT NULL DEFAULT '0',
  `staff_id` int unsigned NOT NULL DEFAULT '0',
  `team_id` int unsigned NOT NULL DEFAULT '0',
  `sla_id` int unsigned NOT NULL DEFAULT '0',
  `page_id` int unsigned NOT NULL DEFAULT '0',
  `sequence_id` int unsigned NOT NULL DEFAULT '0',
  `sort` int unsigned NOT NULL DEFAULT '0',
  `topic` varchar(128) NOT NULL DEFAULT '',
  `number_format` varchar(32) DEFAULT NULL,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`topic_id`),
  UNIQUE KEY `topic` (`topic`,`topic_pid`),
  KEY `topic_pid` (`topic_pid`),
  KEY `priority_id` (`priority_id`),
  KEY `dept_id` (`dept_id`),
  KEY `staff_id` (`staff_id`,`team_id`),
  KEY `sla_id` (`sla_id`),
  KEY `page_id` (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_help_topic`
--

LOCK TABLES `ost_help_topic` WRITE;
/*!40000 ALTER TABLE `ost_help_topic` DISABLE KEYS */;
INSERT INTO `ost_help_topic` VALUES (1,0,1,0,2,0,2,0,0,0,0,0,0,1,'General Inquiry',NULL,'Questions about products or services','2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_help_topic` VALUES (2,0,1,0,2,0,1,0,0,0,0,0,0,0,'Feedback',NULL,'Tickets that primarily concern the sales and billing departments','2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_help_topic` VALUES (10,0,1,0,2,0,2,3,0,0,0,0,0,0,'Report a Problem',NULL,'Product, service, or equipment related issues','2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_help_topic` VALUES (11,10,1,0,2,0,3,0,0,0,1,0,0,1,'Access Issue',NULL,'Report an inability access a physical or virtual asset','2025-05-22 17:32:39','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_help_topic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_help_topic_form`
--

DROP TABLE IF EXISTS `ost_help_topic_form`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_help_topic_form` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int unsigned NOT NULL DEFAULT '0',
  `form_id` int unsigned NOT NULL DEFAULT '0',
  `sort` int unsigned NOT NULL DEFAULT '1',
  `extra` text,
  PRIMARY KEY (`id`),
  KEY `topic-form` (`topic_id`,`form_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_help_topic_form`
--

LOCK TABLES `ost_help_topic_form` WRITE;
/*!40000 ALTER TABLE `ost_help_topic_form` DISABLE KEYS */;
INSERT INTO `ost_help_topic_form` VALUES (1,1,2,1,'{\"disable\":[]}');
INSERT INTO `ost_help_topic_form` VALUES (2,2,2,1,'{\"disable\":[]}');
INSERT INTO `ost_help_topic_form` VALUES (3,10,2,1,'{\"disable\":[]}');
INSERT INTO `ost_help_topic_form` VALUES (4,11,2,1,'{\"disable\":[]}');
/*!40000 ALTER TABLE `ost_help_topic_form` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_list`
--

DROP TABLE IF EXISTS `ost_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_list` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `name_plural` varchar(255) DEFAULT NULL,
  `sort_mode` enum('Alpha','-Alpha','SortCol') NOT NULL DEFAULT 'Alpha',
  `masks` int unsigned NOT NULL DEFAULT '0',
  `type` varchar(16) DEFAULT NULL,
  `configuration` text NOT NULL,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_list`
--

LOCK TABLES `ost_list` WRITE;
/*!40000 ALTER TABLE `ost_list` DISABLE KEYS */;
INSERT INTO `ost_list` VALUES (1,'Ticket Status','Ticket Statuses','SortCol',13,'ticket-status','{\"handler\":\"TicketStatusList\"}','Ticket statuses','2025-05-22 17:32:39','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_list_items`
--

DROP TABLE IF EXISTS `ost_list_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_list_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `list_id` int DEFAULT NULL,
  `status` int unsigned NOT NULL DEFAULT '1',
  `value` varchar(255) NOT NULL,
  `extra` varchar(255) DEFAULT NULL,
  `sort` int NOT NULL DEFAULT '1',
  `properties` text,
  PRIMARY KEY (`id`),
  KEY `list_item_lookup` (`list_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_list_items`
--

LOCK TABLES `ost_list_items` WRITE;
/*!40000 ALTER TABLE `ost_list_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_list_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_lock`
--

DROP TABLE IF EXISTS `ost_lock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_lock` (
  `lock_id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int unsigned NOT NULL DEFAULT '0',
  `expire` datetime DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`lock_id`),
  KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_lock`
--

LOCK TABLES `ost_lock` WRITE;
/*!40000 ALTER TABLE `ost_lock` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_lock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_note`
--

DROP TABLE IF EXISTS `ost_note`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_note` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pid` int unsigned DEFAULT NULL,
  `staff_id` int unsigned NOT NULL DEFAULT '0',
  `ext_id` varchar(10) DEFAULT NULL,
  `body` text,
  `status` int unsigned NOT NULL DEFAULT '0',
  `sort` int unsigned NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ext_id` (`ext_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_note`
--

LOCK TABLES `ost_note` WRITE;
/*!40000 ALTER TABLE `ost_note` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_note` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_organization`
--

DROP TABLE IF EXISTS `ost_organization`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_organization` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '',
  `manager` varchar(16) NOT NULL DEFAULT '',
  `status` int unsigned NOT NULL DEFAULT '0',
  `domain` varchar(256) NOT NULL DEFAULT '',
  `extra` text,
  `created` timestamp NULL DEFAULT NULL,
  `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_organization`
--

LOCK TABLES `ost_organization` WRITE;
/*!40000 ALTER TABLE `ost_organization` DISABLE KEYS */;
INSERT INTO `ost_organization` VALUES (1,'osTicket','',8,'',NULL,'2025-05-22 21:32:39',NULL);
/*!40000 ALTER TABLE `ost_organization` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_organization__cdata`
--

DROP TABLE IF EXISTS `ost_organization__cdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_organization__cdata` (
  `org_id` int unsigned NOT NULL,
  `name` mediumtext,
  `address` mediumtext,
  `phone` mediumtext,
  `website` mediumtext,
  `notes` mediumtext,
  PRIMARY KEY (`org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_organization__cdata`
--

LOCK TABLES `ost_organization__cdata` WRITE;
/*!40000 ALTER TABLE `ost_organization__cdata` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_organization__cdata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_plugin`
--

DROP TABLE IF EXISTS `ost_plugin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_plugin` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `install_path` varchar(60) NOT NULL,
  `isphar` tinyint(1) NOT NULL DEFAULT '0',
  `isactive` tinyint(1) NOT NULL DEFAULT '0',
  `version` varchar(64) DEFAULT NULL,
  `notes` text,
  `installed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `install_path` (`install_path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_plugin`
--

LOCK TABLES `ost_plugin` WRITE;
/*!40000 ALTER TABLE `ost_plugin` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_plugin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_plugin_instance`
--

DROP TABLE IF EXISTS `ost_plugin_instance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_plugin_instance` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plugin_id` int unsigned NOT NULL,
  `flags` int NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plugin_id` (`plugin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_plugin_instance`
--

LOCK TABLES `ost_plugin_instance` WRITE;
/*!40000 ALTER TABLE `ost_plugin_instance` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_plugin_instance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_queue`
--

DROP TABLE IF EXISTS `ost_queue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_queue` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int unsigned NOT NULL DEFAULT '0',
  `columns_id` int unsigned DEFAULT NULL,
  `sort_id` int unsigned DEFAULT NULL,
  `flags` int unsigned NOT NULL DEFAULT '0',
  `staff_id` int unsigned NOT NULL DEFAULT '0',
  `sort` int unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) DEFAULT NULL,
  `config` text,
  `filter` varchar(64) DEFAULT NULL,
  `root` varchar(32) DEFAULT NULL,
  `path` varchar(80) NOT NULL DEFAULT '/',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_queue`
--

LOCK TABLES `ost_queue` WRITE;
/*!40000 ALTER TABLE `ost_queue` DISABLE KEYS */;
INSERT INTO `ost_queue` VALUES (1,0,NULL,1,3,0,1,'Open','[[\"status__state\",\"includes\",{\"open\":\"Open\"}]]',NULL,'T','/','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (2,1,NULL,4,43,0,1,'Open','{\"criteria\":[[\"isanswered\",\"nset\",null]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (3,1,NULL,4,43,0,2,'Answered','{\"criteria\":[[\"isanswered\",\"set\",null]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (4,1,NULL,4,43,0,3,'Overdue','{\"criteria\":[[\"isoverdue\",\"set\",null]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (5,0,NULL,3,3,0,3,'My Tickets','{\"criteria\":[[\"assignee\",\"includes\",{\"M\":\"Me\",\"T\":\"One of my teams\"}],[\"status__state\",\"includes\",{\"open\":\"Open\"}]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (6,5,NULL,NULL,43,0,1,'Assigned to Me','{\"criteria\":[[\"assignee\",\"includes\",{\"M\":\"Me\"}]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (7,5,NULL,NULL,43,0,2,'Assigned to Teams','{\"criteria\":[[\"assignee\",\"!includes\",{\"M\":\"Me\"}]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (8,0,NULL,5,3,0,4,'Closed','{\"criteria\":[[\"status__state\",\"includes\",{\"closed\":\"Closed\"}]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (9,8,NULL,5,43,0,1,'Today','{\"criteria\":[[\"closed\",\"period\",\"td\"]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:40','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (10,8,NULL,5,43,0,2,'Yesterday','{\"criteria\":[[\"closed\",\"period\",\"yd\"]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:40','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (11,8,NULL,5,43,0,3,'This Week','{\"criteria\":[[\"closed\",\"period\",\"tw\"]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:40','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (12,8,NULL,5,43,0,4,'This Month','{\"criteria\":[[\"closed\",\"period\",\"tm\"]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:40','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (13,8,NULL,6,43,0,5,'This Quarter','{\"criteria\":[[\"closed\",\"period\",\"tq\"]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:40','0000-00-00 00:00:00');
INSERT INTO `ost_queue` VALUES (14,8,NULL,7,43,0,6,'This Year','{\"criteria\":[[\"closed\",\"period\",\"ty\"]],\"conditions\":[]}',NULL,'T','/','2025-05-22 17:32:40','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `ost_queue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_queue_column`
--

DROP TABLE IF EXISTS `ost_queue_column`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_queue_column` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `flags` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(64) NOT NULL DEFAULT '',
  `primary` varchar(64) NOT NULL DEFAULT '',
  `secondary` varchar(64) DEFAULT NULL,
  `filter` varchar(32) DEFAULT NULL,
  `truncate` varchar(16) DEFAULT NULL,
  `annotations` text,
  `conditions` text,
  `extra` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_queue_column`
--

LOCK TABLES `ost_queue_column` WRITE;
/*!40000 ALTER TABLE `ost_queue_column` DISABLE KEYS */;
INSERT INTO `ost_queue_column` VALUES (1,0,'Ticket #','number',NULL,'link:ticketP','wrap','[{\"c\":\"TicketSourceDecoration\",\"p\":\"b\"}]','[{\"crit\":[\"isanswered\",\"nset\",null],\"prop\":{\"font-weight\":\"bold\"}}]',NULL);
INSERT INTO `ost_queue_column` VALUES (2,0,'Date Created','created',NULL,'date:full','wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (3,0,'Subject','cdata__subject',NULL,'link:ticket','ellipsis','[{\"c\":\"TicketThreadCount\",\"p\":\">\"},{\"c\":\"ThreadAttachmentCount\",\"p\":\"a\"},{\"c\":\"OverdueFlagDecoration\",\"p\":\"<\"},{\"c\":\"LockDecoration\",\"p\":\"<\"}]','[{\"crit\":[\"isanswered\",\"nset\",null],\"prop\":{\"font-weight\":\"bold\"}}]',NULL);
INSERT INTO `ost_queue_column` VALUES (4,0,'User Name','user__name',NULL,NULL,'wrap','[{\"c\":\"ThreadCollaboratorCount\",\"p\":\">\"}]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (5,0,'Priority','cdata__priority',NULL,NULL,'wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (6,0,'Status','status__id',NULL,NULL,'wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (7,0,'Close Date','closed',NULL,'date:full','wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (8,0,'Assignee','assignee',NULL,NULL,'wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (9,0,'Due Date','duedate','est_duedate','date:human','wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (10,0,'Last Updated','lastupdate',NULL,'date:full','wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (11,0,'Department','dept_id',NULL,NULL,'wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (12,0,'Last Message','thread__lastmessage',NULL,'date:human','wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (13,0,'Last Response','thread__lastresponse',NULL,'date:human','wrap','[]','[]',NULL);
INSERT INTO `ost_queue_column` VALUES (14,0,'Team','team_id',NULL,NULL,'wrap','[]','[]',NULL);
/*!40000 ALTER TABLE `ost_queue_column` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_queue_columns`
--

DROP TABLE IF EXISTS `ost_queue_columns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_queue_columns` (
  `queue_id` int unsigned NOT NULL,
  `column_id` int unsigned NOT NULL,
  `staff_id` int unsigned NOT NULL,
  `bits` int unsigned NOT NULL DEFAULT '0',
  `sort` int unsigned NOT NULL DEFAULT '1',
  `heading` varchar(64) DEFAULT NULL,
  `width` int unsigned NOT NULL DEFAULT '100',
  PRIMARY KEY (`queue_id`,`column_id`,`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_queue_columns`
--

LOCK TABLES `ost_queue_columns` WRITE;
/*!40000 ALTER TABLE `ost_queue_columns` DISABLE KEYS */;
INSERT INTO `ost_queue_columns` VALUES (1,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (1,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (1,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (1,5,0,1,5,'Priority',85);
INSERT INTO `ost_queue_columns` VALUES (1,8,0,1,6,'Assigned To',160);
INSERT INTO `ost_queue_columns` VALUES (1,10,0,1,2,'Last Updated',150);
INSERT INTO `ost_queue_columns` VALUES (2,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (2,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (2,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (2,5,0,1,5,'Priority',85);
INSERT INTO `ost_queue_columns` VALUES (2,8,0,1,6,'Assigned To',160);
INSERT INTO `ost_queue_columns` VALUES (2,10,0,1,2,'Last Updated',150);
INSERT INTO `ost_queue_columns` VALUES (3,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (3,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (3,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (3,5,0,1,5,'Priority',85);
INSERT INTO `ost_queue_columns` VALUES (3,8,0,1,6,'Assigned To',160);
INSERT INTO `ost_queue_columns` VALUES (3,10,0,1,2,'Last Updated',150);
INSERT INTO `ost_queue_columns` VALUES (4,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (4,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (4,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (4,5,0,1,5,'Priority',85);
INSERT INTO `ost_queue_columns` VALUES (4,8,0,1,6,'Assigned To',160);
INSERT INTO `ost_queue_columns` VALUES (4,9,0,1,9,'Due Date',150);
INSERT INTO `ost_queue_columns` VALUES (5,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (5,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (5,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (5,5,0,1,5,'Priority',85);
INSERT INTO `ost_queue_columns` VALUES (5,10,0,1,2,'Last Update',150);
INSERT INTO `ost_queue_columns` VALUES (5,11,0,1,6,'Department',160);
INSERT INTO `ost_queue_columns` VALUES (6,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (6,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (6,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (6,5,0,1,5,'Priority',85);
INSERT INTO `ost_queue_columns` VALUES (6,10,0,1,2,'Last Update',150);
INSERT INTO `ost_queue_columns` VALUES (6,11,0,1,6,'Department',160);
INSERT INTO `ost_queue_columns` VALUES (7,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (7,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (7,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (7,5,0,1,5,'Priority',85);
INSERT INTO `ost_queue_columns` VALUES (7,10,0,1,2,'Last Update',150);
INSERT INTO `ost_queue_columns` VALUES (7,14,0,1,6,'Team',160);
INSERT INTO `ost_queue_columns` VALUES (8,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (8,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (8,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (8,7,0,1,2,'Date Closed',150);
INSERT INTO `ost_queue_columns` VALUES (8,8,0,1,6,'Closed By',160);
INSERT INTO `ost_queue_columns` VALUES (9,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (9,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (9,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (9,7,0,1,2,'Date Closed',150);
INSERT INTO `ost_queue_columns` VALUES (9,8,0,1,6,'Closed By',160);
INSERT INTO `ost_queue_columns` VALUES (10,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (10,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (10,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (10,7,0,1,2,'Date Closed',150);
INSERT INTO `ost_queue_columns` VALUES (10,8,0,1,6,'Closed By',160);
INSERT INTO `ost_queue_columns` VALUES (11,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (11,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (11,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (11,7,0,1,2,'Date Closed',150);
INSERT INTO `ost_queue_columns` VALUES (11,8,0,1,6,'Closed By',160);
INSERT INTO `ost_queue_columns` VALUES (12,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (12,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (12,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (12,7,0,1,2,'Date Closed',150);
INSERT INTO `ost_queue_columns` VALUES (12,8,0,1,6,'Closed By',160);
INSERT INTO `ost_queue_columns` VALUES (13,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (13,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (13,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (13,7,0,1,2,'Date Closed',150);
INSERT INTO `ost_queue_columns` VALUES (13,8,0,1,6,'Closed By',160);
INSERT INTO `ost_queue_columns` VALUES (14,1,0,1,1,'Ticket',100);
INSERT INTO `ost_queue_columns` VALUES (14,3,0,1,3,'Subject',300);
INSERT INTO `ost_queue_columns` VALUES (14,4,0,1,4,'From',185);
INSERT INTO `ost_queue_columns` VALUES (14,7,0,1,2,'Date Closed',150);
INSERT INTO `ost_queue_columns` VALUES (14,8,0,1,6,'Closed By',160);
/*!40000 ALTER TABLE `ost_queue_columns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_queue_config`
--

DROP TABLE IF EXISTS `ost_queue_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_queue_config` (
  `queue_id` int unsigned NOT NULL,
  `staff_id` int unsigned NOT NULL,
  `setting` text,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`queue_id`,`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_queue_config`
--

LOCK TABLES `ost_queue_config` WRITE;
/*!40000 ALTER TABLE `ost_queue_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_queue_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_queue_export`
--

DROP TABLE IF EXISTS `ost_queue_export`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_queue_export` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `queue_id` int unsigned NOT NULL,
  `path` varchar(64) NOT NULL DEFAULT '',
  `heading` varchar(64) DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `queue_id` (`queue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_queue_export`
--

LOCK TABLES `ost_queue_export` WRITE;
/*!40000 ALTER TABLE `ost_queue_export` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_queue_export` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_queue_sort`
--

DROP TABLE IF EXISTS `ost_queue_sort`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_queue_sort` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `root` varchar(32) DEFAULT NULL,
  `name` varchar(64) NOT NULL DEFAULT '',
  `columns` text,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_queue_sort`
--

LOCK TABLES `ost_queue_sort` WRITE;
/*!40000 ALTER TABLE `ost_queue_sort` DISABLE KEYS */;
INSERT INTO `ost_queue_sort` VALUES (1,NULL,'Priority + Most Recently Updated','[\"-cdata__priority\",\"-lastupdate\"]','2025-05-22 17:32:39');
INSERT INTO `ost_queue_sort` VALUES (2,NULL,'Priority + Most Recently Created','[\"-cdata__priority\",\"-created\"]','2025-05-22 17:32:39');
INSERT INTO `ost_queue_sort` VALUES (3,NULL,'Priority + Due Date','[\"-cdata__priority\",\"-est_duedate\"]','2025-05-22 17:32:39');
INSERT INTO `ost_queue_sort` VALUES (4,NULL,'Due Date','[\"-est_duedate\"]','2025-05-22 17:32:39');
INSERT INTO `ost_queue_sort` VALUES (5,NULL,'Closed Date','[\"-closed\"]','2025-05-22 17:32:39');
INSERT INTO `ost_queue_sort` VALUES (6,NULL,'Create Date','[\"-created\"]','2025-05-22 17:32:39');
INSERT INTO `ost_queue_sort` VALUES (7,NULL,'Update Date','[\"-lastupdate\"]','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_queue_sort` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_queue_sorts`
--

DROP TABLE IF EXISTS `ost_queue_sorts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_queue_sorts` (
  `queue_id` int unsigned NOT NULL,
  `sort_id` int unsigned NOT NULL,
  `bits` int unsigned NOT NULL DEFAULT '0',
  `sort` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`queue_id`,`sort_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_queue_sorts`
--

LOCK TABLES `ost_queue_sorts` WRITE;
/*!40000 ALTER TABLE `ost_queue_sorts` DISABLE KEYS */;
INSERT INTO `ost_queue_sorts` VALUES (1,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (1,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (1,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (1,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (1,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (1,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (5,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (5,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (5,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (5,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (5,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (5,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (6,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (6,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (6,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (6,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (6,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (6,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (7,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (7,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (7,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (7,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (7,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (7,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (8,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (8,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (8,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (8,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (8,5,0,0);
INSERT INTO `ost_queue_sorts` VALUES (8,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (8,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (9,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (9,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (9,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (9,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (9,5,0,0);
INSERT INTO `ost_queue_sorts` VALUES (9,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (9,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (10,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (10,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (10,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (10,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (10,5,0,0);
INSERT INTO `ost_queue_sorts` VALUES (10,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (10,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (11,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (11,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (11,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (11,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (11,5,0,0);
INSERT INTO `ost_queue_sorts` VALUES (11,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (11,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (12,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (12,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (12,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (12,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (12,5,0,0);
INSERT INTO `ost_queue_sorts` VALUES (12,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (12,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (13,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (13,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (13,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (13,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (13,5,0,0);
INSERT INTO `ost_queue_sorts` VALUES (13,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (13,7,0,0);
INSERT INTO `ost_queue_sorts` VALUES (14,1,0,0);
INSERT INTO `ost_queue_sorts` VALUES (14,2,0,0);
INSERT INTO `ost_queue_sorts` VALUES (14,3,0,0);
INSERT INTO `ost_queue_sorts` VALUES (14,4,0,0);
INSERT INTO `ost_queue_sorts` VALUES (14,5,0,0);
INSERT INTO `ost_queue_sorts` VALUES (14,6,0,0);
INSERT INTO `ost_queue_sorts` VALUES (14,7,0,0);
/*!40000 ALTER TABLE `ost_queue_sorts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_role`
--

DROP TABLE IF EXISTS `ost_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_role` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `flags` int unsigned NOT NULL DEFAULT '1',
  `name` varchar(64) DEFAULT NULL,
  `permissions` text,
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_role`
--

LOCK TABLES `ost_role` WRITE;
/*!40000 ALTER TABLE `ost_role` DISABLE KEYS */;
INSERT INTO `ost_role` VALUES (1,1,'All Access','{\"ticket.assign\":1,\"ticket.close\":1,\"ticket.create\":1,\"ticket.delete\":1,\"ticket.edit\":1,\"thread.edit\":1,\"ticket.link\":1,\"ticket.markanswered\":1,\"ticket.merge\":1,\"ticket.reply\":1,\"ticket.refer\":1,\"ticket.release\":1,\"ticket.transfer\":1,\"task.assign\":1,\"task.close\":1,\"task.create\":1,\"task.delete\":1,\"task.edit\":1,\"task.reply\":1,\"task.transfer\":1,\"canned.manage\":1}','Role with unlimited access','2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_role` VALUES (2,1,'Expanded Access','{\"ticket.assign\":1,\"ticket.close\":1,\"ticket.create\":1,\"ticket.edit\":1,\"ticket.link\":1,\"ticket.merge\":1,\"ticket.reply\":1,\"ticket.refer\":1,\"ticket.release\":1,\"ticket.transfer\":1,\"task.assign\":1,\"task.close\":1,\"task.create\":1,\"task.edit\":1,\"task.reply\":1,\"task.transfer\":1,\"canned.manage\":1}','Role with expanded access','2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_role` VALUES (3,1,'Limited Access','{\"ticket.assign\":1,\"ticket.create\":1,\"ticket.link\":1,\"ticket.merge\":1,\"ticket.refer\":1,\"ticket.release\":1,\"ticket.transfer\":1,\"task.assign\":1,\"task.reply\":1,\"task.transfer\":1}','Role with limited access','2025-05-22 17:32:39','2025-05-22 17:32:39');
INSERT INTO `ost_role` VALUES (4,1,'View only',NULL,'Simple role with no permissions','2025-05-22 17:32:39','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_schedule`
--

DROP TABLE IF EXISTS `ost_schedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_schedule` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `flags` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `timezone` varchar(64) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_schedule`
--

LOCK TABLES `ost_schedule` WRITE;
/*!40000 ALTER TABLE `ost_schedule` DISABLE KEYS */;
INSERT INTO `ost_schedule` VALUES (1,1,'Monday - Friday 8am - 5pm with U.S. Holidays',NULL,'','2025-05-22 17:32:40','2025-05-22 17:32:40');
INSERT INTO `ost_schedule` VALUES (2,1,'24/7',NULL,'','2025-05-22 17:32:40','2025-05-22 17:32:40');
INSERT INTO `ost_schedule` VALUES (3,1,'24/5',NULL,'','2025-05-22 17:32:40','2025-05-22 17:32:40');
INSERT INTO `ost_schedule` VALUES (4,0,'U.S. Holidays',NULL,'','2025-05-22 17:32:40','2025-05-22 17:32:40');
/*!40000 ALTER TABLE `ost_schedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_schedule_entry`
--

DROP TABLE IF EXISTS `ost_schedule_entry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_schedule_entry` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `schedule_id` int unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '0',
  `sort` tinyint unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `repeats` varchar(16) NOT NULL DEFAULT 'never',
  `starts_on` date DEFAULT NULL,
  `starts_at` time DEFAULT NULL,
  `ends_on` date DEFAULT NULL,
  `ends_at` time DEFAULT NULL,
  `stops_on` datetime DEFAULT NULL,
  `day` tinyint DEFAULT NULL,
  `week` tinyint DEFAULT NULL,
  `month` tinyint DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `schedule_id` (`schedule_id`),
  KEY `repeats` (`repeats`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_schedule_entry`
--

LOCK TABLES `ost_schedule_entry` WRITE;
/*!40000 ALTER TABLE `ost_schedule_entry` DISABLE KEYS */;
INSERT INTO `ost_schedule_entry` VALUES (1,1,0,0,'Monday','weekly','2019-01-07','08:00:00','2019-01-07','17:00:00',NULL,1,NULL,NULL,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (2,1,0,0,'Tuesday','weekly','2019-01-08','08:00:00','2019-01-08','17:00:00',NULL,2,NULL,NULL,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (3,1,0,0,'Wednesday','weekly','2019-01-09','08:00:00','2019-01-09','17:00:00',NULL,3,NULL,NULL,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (4,1,0,0,'Thursday','weekly','2019-01-10','08:00:00','2019-01-10','17:00:00',NULL,4,NULL,NULL,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (5,1,0,0,'Friday','weekly','2019-01-11','08:00:00','2019-01-11','17:00:00',NULL,5,NULL,NULL,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (6,2,0,0,'Daily','daily','2019-01-01','00:00:00','2019-01-01','23:59:59',NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (7,3,0,0,'Weekdays','weekdays','2019-01-01','00:00:00','2019-01-01','23:59:59',NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (8,4,0,0,'New Year\'s Day','yearly','2019-01-01','00:00:00','2019-01-01','23:59:59',NULL,1,NULL,1,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (9,4,0,0,'MLK Day','yearly','2019-01-21','00:00:00','2019-01-21','23:59:59',NULL,1,3,1,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (10,4,0,0,'Memorial Day','yearly','2019-05-27','00:00:00','2019-05-27','23:59:59',NULL,1,-1,5,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (11,4,0,0,'Independence Day (4th of July)','yearly','2019-07-04','00:00:00','2019-07-04','23:59:59',NULL,4,NULL,7,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (12,4,0,0,'Labor Day','yearly','2019-09-02','00:00:00','2019-09-02','23:59:59',NULL,1,1,9,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (13,4,0,0,'Indigenous Peoples\' Day (Whodat Columbus)','yearly','2019-10-14','00:00:00','2019-10-14','23:59:59',NULL,1,2,10,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (14,4,0,0,'Veterans Day','yearly','2019-11-11','00:00:00','2019-11-11','23:59:59',NULL,11,NULL,11,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (15,4,0,0,'Thanksgiving Day','yearly','2019-11-28','00:00:00','2019-11-28','23:59:59',NULL,4,4,11,'0000-00-00 00:00:00','2025-05-22 17:32:40');
INSERT INTO `ost_schedule_entry` VALUES (16,4,0,0,'Christmas Day','yearly','2019-11-25','00:00:00','2019-11-25','23:59:59',NULL,25,NULL,12,'0000-00-00 00:00:00','2025-05-22 17:32:40');
/*!40000 ALTER TABLE `ost_schedule_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_sequence`
--

DROP TABLE IF EXISTS `ost_sequence`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_sequence` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  `flags` int unsigned DEFAULT NULL,
  `next` bigint unsigned NOT NULL DEFAULT '1',
  `increment` int DEFAULT '1',
  `padding` char(1) DEFAULT '0',
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_sequence`
--

LOCK TABLES `ost_sequence` WRITE;
/*!40000 ALTER TABLE `ost_sequence` DISABLE KEYS */;
INSERT INTO `ost_sequence` VALUES (1,'General Tickets',1,1,1,'0','0000-00-00 00:00:00');
INSERT INTO `ost_sequence` VALUES (2,'Tasks Sequence',1,1,1,'0','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `ost_sequence` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_session`
--

DROP TABLE IF EXISTS `ost_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_session` (
  `session_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `session_data` blob,
  `session_expire` datetime DEFAULT NULL,
  `session_updated` datetime DEFAULT NULL,
  `user_id` varchar(16) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0' COMMENT 'osTicket staff/client ID',
  `user_ip` varchar(64) COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_agent` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`session_id`),
  KEY `updated` (`session_updated`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_session`
--

LOCK TABLES `ost_session` WRITE;
/*!40000 ALTER TABLE `ost_session` DISABLE KEYS */;
INSERT INTO `ost_session` VALUES ('147soikquj9cl7ujd6h9p5jej4',_binary 'csrf|a:2:{s:5:\"token\";s:40:\"cdd79a518e456b1bac2408378f264979f8303260\";s:4:\"time\";i:1748014828;}_auth|a:1:{s:5:\"staff\";a:3:{s:2:\"id\";i:1;s:3:\"key\";s:14:\"local:soc-user\";s:3:\"2fa\";N;}}:token|a:1:{s:5:\"staff\";s:76:\"65d61e3d5d300963d45e36059c391673:1748014819:f528764d624db129b32c21fbca0cb8d6\";}TIME_BOMB|i:1748015747;::Q:T|i:1;sort|a:1:{i:1;a:2:{s:9:\"queuesort\";O:9:\"QueueSort\":7:{s:2:\"ht\";a:5:{s:2:\"id\";i:1;s:4:\"root\";N;s:4:\"name\";s:32:\"Priority + Most Recently Updated\";s:7:\"columns\";s:34:\"[\"-cdata__priority\",\"-lastupdate\"]\";s:7:\"updated\";s:19:\"2025-05-22 17:32:39\";}s:5:\"dirty\";a:0:{}s:7:\"__new__\";b:0;s:11:\"__deleted__\";b:0;s:12:\"__deferred__\";a:0:{}s:8:\"_columns\";a:2:{s:15:\"cdata__priority\";b:1;s:10:\"lastupdate\";b:1;}s:6:\"_extra\";N;}s:3:\"dir\";i:0;}}cfg:core|a:1:{s:11:\"db_timezone\";s:16:\"America/New_York\";}lastcroncall|i:1748014820;','2025-05-23 12:10:19','2025-05-23 11:40:28','1','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:132.0) Gecko/20100101 Firefox/132.0');
INSERT INTO `ost_session` VALUES ('gbs5bldbeucn1rji92ctr7ufja',_binary 'csrf|a:2:{s:5:\"token\";s:40:\"525675c2f1b0a35e1d975ffb345774b6a7dfb7d5\";s:4:\"time\";i:1748013941;}_auth|a:1:{s:5:\"staff\";a:3:{s:2:\"id\";i:1;s:3:\"key\";s:14:\"local:soc-user\";s:3:\"2fa\";N;}}:token|a:1:{s:5:\"staff\";s:76:\"9b1a9cc2685cdc1b6a5308bcaeb49eb5:1748013899:f528764d624db129b32c21fbca0cb8d6\";}TIME_BOMB|i:1748013909;::Q:T|i:1;sort|a:1:{i:1;a:2:{s:9:\"queuesort\";O:9:\"QueueSort\":7:{s:2:\"ht\";a:5:{s:2:\"id\";i:1;s:4:\"root\";N;s:4:\"name\";s:32:\"Priority + Most Recently Updated\";s:7:\"columns\";s:34:\"[\"-cdata__priority\",\"-lastupdate\"]\";s:7:\"updated\";s:19:\"2025-05-22 17:32:39\";}s:5:\"dirty\";a:0:{}s:7:\"__new__\";b:0;s:11:\"__deleted__\";b:0;s:12:\"__deferred__\";a:0:{}s:8:\"_columns\";a:2:{s:15:\"cdata__priority\";b:1;s:10:\"lastupdate\";b:1;}s:6:\"_extra\";N;}s:3:\"dir\";i:0;}}cfg:core|a:1:{s:11:\"db_timezone\";s:16:\"America/New_York\";}lastcroncall|i:1748013899;TTD|i:1748014067;','2025-05-23 11:27:47','2025-05-23 11:25:47','1','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:132.0) Gecko/20100101 Firefox/132.0');
INSERT INTO `ost_session` VALUES ('ntgl5blu8reggncq48ssuohp5j',_binary 'csrf|a:2:{s:5:\"token\";s:40:\"47f7cefd03323a3ba9c293b648e705d0aa624a1d\";s:4:\"time\";i:1748013194;}_auth|a:1:{s:5:\"staff\";a:3:{s:2:\"id\";i:1;s:3:\"key\";s:14:\"local:soc-user\";s:3:\"2fa\";N;}}:token|a:1:{s:5:\"staff\";s:76:\"916891afe54fef291347dd75e94ed142:1748013190:f528764d624db129b32c21fbca0cb8d6\";}TIME_BOMB|i:1748013200;::Q:T|i:1;sort|a:1:{i:1;a:2:{s:9:\"queuesort\";O:9:\"QueueSort\":7:{s:2:\"ht\";a:5:{s:2:\"id\";i:1;s:4:\"root\";N;s:4:\"name\";s:32:\"Priority + Most Recently Updated\";s:7:\"columns\";s:34:\"[\"-cdata__priority\",\"-lastupdate\"]\";s:7:\"updated\";s:19:\"2025-05-22 17:32:39\";}s:5:\"dirty\";a:0:{}s:7:\"__new__\";b:0;s:11:\"__deleted__\";b:0;s:12:\"__deferred__\";a:0:{}s:8:\"_columns\";a:2:{s:15:\"cdata__priority\";b:1;s:10:\"lastupdate\";b:1;}s:6:\"_extra\";N;}s:3:\"dir\";i:0;}}cfg:core|a:1:{s:11:\"db_timezone\";s:16:\"America/New_York\";}lastcroncall|i:1748013190;TTD|i:1748013321;','2025-05-23 11:15:21','2025-05-23 11:13:21','1','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:132.0) Gecko/20100101 Firefox/132.0');
INSERT INTO `ost_session` VALUES ('tkmtvph3k3sda739as1ipm3lo6',_binary 'csrf|a:2:{s:5:\"token\";s:40:\"272989ecddc25bcd309ccec6aefdf30a189bbae3\";s:4:\"time\";i:1748012336;}','2025-05-24 10:58:56','2025-05-23 10:58:56','0','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:132.0) Gecko/20100101 Firefox/132.0');
/*!40000 ALTER TABLE `ost_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_sla`
--

DROP TABLE IF EXISTS `ost_sla`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_sla` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `schedule_id` int unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '3',
  `grace_period` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(64) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_sla`
--

LOCK TABLES `ost_sla` WRITE;
/*!40000 ALTER TABLE `ost_sla` DISABLE KEYS */;
INSERT INTO `ost_sla` VALUES (1,0,3,18,'Default SLA',NULL,'2025-05-22 17:32:37','2025-05-22 17:32:37');
/*!40000 ALTER TABLE `ost_sla` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_staff`
--

DROP TABLE IF EXISTS `ost_staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_staff` (
  `staff_id` int unsigned NOT NULL AUTO_INCREMENT,
  `dept_id` int unsigned NOT NULL DEFAULT '0',
  `role_id` int unsigned NOT NULL DEFAULT '0',
  `username` varchar(32) NOT NULL DEFAULT '',
  `firstname` varchar(32) DEFAULT NULL,
  `lastname` varchar(32) DEFAULT NULL,
  `passwd` varchar(128) DEFAULT NULL,
  `backend` varchar(32) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(24) NOT NULL DEFAULT '',
  `phone_ext` varchar(6) DEFAULT NULL,
  `mobile` varchar(24) NOT NULL DEFAULT '',
  `signature` text NOT NULL,
  `lang` varchar(16) DEFAULT NULL,
  `timezone` varchar(64) DEFAULT NULL,
  `locale` varchar(16) DEFAULT NULL,
  `notes` text,
  `isactive` tinyint(1) NOT NULL DEFAULT '1',
  `isadmin` tinyint(1) NOT NULL DEFAULT '0',
  `isvisible` tinyint unsigned NOT NULL DEFAULT '1',
  `onvacation` tinyint unsigned NOT NULL DEFAULT '0',
  `assigned_only` tinyint unsigned NOT NULL DEFAULT '0',
  `show_assigned_tickets` tinyint unsigned NOT NULL DEFAULT '0',
  `change_passwd` tinyint unsigned NOT NULL DEFAULT '0',
  `max_page_size` int unsigned NOT NULL DEFAULT '0',
  `auto_refresh_rate` int unsigned NOT NULL DEFAULT '0',
  `default_signature_type` enum('none','mine','dept') NOT NULL DEFAULT 'none',
  `default_paper_size` enum('Letter','Legal','Ledger','A4','A3') NOT NULL DEFAULT 'Letter',
  `extra` text,
  `permissions` text,
  `created` datetime NOT NULL,
  `lastlogin` datetime DEFAULT NULL,
  `passwdreset` datetime DEFAULT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`staff_id`),
  UNIQUE KEY `username` (`username`),
  KEY `dept_id` (`dept_id`),
  KEY `issuperuser` (`isadmin`),
  KEY `isactive` (`isactive`),
  KEY `onvacation` (`onvacation`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_staff`
--

LOCK TABLES `ost_staff` WRITE;
/*!40000 ALTER TABLE `ost_staff` DISABLE KEYS */;
INSERT INTO `ost_staff` VALUES (1,1,1,'soc-user','SOC','User','$2a$08$eC7kr/61oVcv4dIq3wNYfu0.xM47bzgVcEA6mKaQCXBU.m30s6i82',NULL,'soc-user@ticketing.localhost','',NULL,'','',NULL,NULL,NULL,NULL,1,1,1,0,0,0,0,25,0,'none','Letter','{\"browser_lang\":\"en_US\"}','{\"user.create\":1,\"user.delete\":1,\"user.edit\":1,\"user.manage\":1,\"user.dir\":1,\"org.create\":1,\"org.delete\":1,\"org.edit\":1,\"faq.manage\":1,\"visibility.agents\":1,\"emails.banlist\":1,\"visibility.departments\":1}','2025-05-22 17:32:42','2025-05-23 11:24:59','2025-05-22 17:32:42','2025-05-23 11:24:59');
/*!40000 ALTER TABLE `ost_staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_staff_dept_access`
--

DROP TABLE IF EXISTS `ost_staff_dept_access`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_staff_dept_access` (
  `staff_id` int unsigned NOT NULL DEFAULT '0',
  `dept_id` int unsigned NOT NULL DEFAULT '0',
  `role_id` int unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`staff_id`,`dept_id`),
  KEY `dept_id` (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_staff_dept_access`
--

LOCK TABLES `ost_staff_dept_access` WRITE;
/*!40000 ALTER TABLE `ost_staff_dept_access` DISABLE KEYS */;
INSERT INTO `ost_staff_dept_access` VALUES (1,2,1,1);
INSERT INTO `ost_staff_dept_access` VALUES (1,3,1,1);
/*!40000 ALTER TABLE `ost_staff_dept_access` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_syslog`
--

DROP TABLE IF EXISTS `ost_syslog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_syslog` (
  `log_id` int unsigned NOT NULL AUTO_INCREMENT,
  `log_type` enum('Debug','Warning','Error') NOT NULL,
  `title` varchar(255) NOT NULL,
  `log` text NOT NULL,
  `logger` varchar(64) NOT NULL,
  `ip_address` varchar(64) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`log_id`),
  KEY `log_type` (`log_type`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_syslog`
--

LOCK TABLES `ost_syslog` WRITE;
/*!40000 ALTER TABLE `ost_syslog` DISABLE KEYS */;
INSERT INTO `ost_syslog` VALUES (1,'Debug','osTicket installed!','Congratulations osTicket basic installation completed!\n\nThank you for choosing osTicket!','','127.0.0.1','2025-05-22 17:32:43','2025-05-22 17:32:43');
INSERT INTO `ost_syslog` VALUES (2,'Warning','Invalid CSRF Token __CSRFToken__','Invalid CSRF token [47f7cefd03323a3ba9c293b648e705d0aa624a1d] on http://ticketing.localhost/open.php','','127.0.0.1','2025-05-23 11:25:41','2025-05-23 11:25:41');
/*!40000 ALTER TABLE `ost_syslog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_task`
--

DROP TABLE IF EXISTS `ost_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_task` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `object_id` int NOT NULL DEFAULT '0',
  `object_type` char(1) NOT NULL,
  `number` varchar(20) DEFAULT NULL,
  `dept_id` int unsigned NOT NULL DEFAULT '0',
  `staff_id` int unsigned NOT NULL DEFAULT '0',
  `team_id` int unsigned NOT NULL DEFAULT '0',
  `lock_id` int unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '0',
  `duedate` datetime DEFAULT NULL,
  `closed` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `dept_id` (`dept_id`),
  KEY `staff_id` (`staff_id`),
  KEY `team_id` (`team_id`),
  KEY `created` (`created`),
  KEY `object` (`object_id`,`object_type`),
  KEY `flags` (`flags`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_task`
--

LOCK TABLES `ost_task` WRITE;
/*!40000 ALTER TABLE `ost_task` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_task` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_task__cdata`
--

DROP TABLE IF EXISTS `ost_task__cdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_task__cdata` (
  `task_id` int unsigned NOT NULL,
  `title` mediumtext,
  PRIMARY KEY (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_task__cdata`
--

LOCK TABLES `ost_task__cdata` WRITE;
/*!40000 ALTER TABLE `ost_task__cdata` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_task__cdata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_team`
--

DROP TABLE IF EXISTS `ost_team`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_team` (
  `team_id` int unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` int unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '1',
  `name` varchar(125) NOT NULL DEFAULT '',
  `notes` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`team_id`),
  UNIQUE KEY `name` (`name`),
  KEY `lead_id` (`lead_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_team`
--

LOCK TABLES `ost_team` WRITE;
/*!40000 ALTER TABLE `ost_team` DISABLE KEYS */;
INSERT INTO `ost_team` VALUES (1,0,1,'Level I Support','Tier 1 support, responsible for the initial iteraction with customers','2025-05-22 17:32:39','2025-05-22 17:32:39');
/*!40000 ALTER TABLE `ost_team` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_team_member`
--

DROP TABLE IF EXISTS `ost_team_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_team_member` (
  `team_id` int unsigned NOT NULL DEFAULT '0',
  `staff_id` int unsigned NOT NULL,
  `flags` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`team_id`,`staff_id`),
  KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_team_member`
--

LOCK TABLES `ost_team_member` WRITE;
/*!40000 ALTER TABLE `ost_team_member` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_team_member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_thread`
--

DROP TABLE IF EXISTS `ost_thread`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_thread` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `object_id` int unsigned NOT NULL,
  `object_type` char(1) NOT NULL,
  `extra` text,
  `lastresponse` datetime DEFAULT NULL,
  `lastmessage` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `object_id` (`object_id`),
  KEY `object_type` (`object_type`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_thread`
--

LOCK TABLES `ost_thread` WRITE;
/*!40000 ALTER TABLE `ost_thread` DISABLE KEYS */;
INSERT INTO `ost_thread` VALUES (1,1,'T',NULL,NULL,'2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_thread` VALUES (2,2,'T',NULL,NULL,'2025-05-23 11:26:27','2025-05-23 11:26:27');
INSERT INTO `ost_thread` VALUES (3,3,'T',NULL,NULL,'2025-05-23 11:32:26','2025-05-23 11:32:26');
INSERT INTO `ost_thread` VALUES (4,4,'T',NULL,NULL,'2025-05-23 11:36:03','2025-05-23 11:36:03');
INSERT INTO `ost_thread` VALUES (5,5,'T',NULL,NULL,'2025-05-23 11:40:16','2025-05-23 11:40:16');
/*!40000 ALTER TABLE `ost_thread` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_thread_collaborator`
--

DROP TABLE IF EXISTS `ost_thread_collaborator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_thread_collaborator` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `flags` int unsigned NOT NULL DEFAULT '1',
  `thread_id` int unsigned NOT NULL DEFAULT '0',
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `role` char(1) NOT NULL DEFAULT 'M',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `collab` (`thread_id`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_thread_collaborator`
--

LOCK TABLES `ost_thread_collaborator` WRITE;
/*!40000 ALTER TABLE `ost_thread_collaborator` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_thread_collaborator` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_thread_entry`
--

DROP TABLE IF EXISTS `ost_thread_entry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_thread_entry` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pid` int unsigned NOT NULL DEFAULT '0',
  `thread_id` int unsigned NOT NULL DEFAULT '0',
  `staff_id` int unsigned NOT NULL DEFAULT '0',
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `type` char(1) NOT NULL DEFAULT '',
  `flags` int unsigned NOT NULL DEFAULT '0',
  `poster` varchar(128) NOT NULL DEFAULT '',
  `editor` int unsigned DEFAULT NULL,
  `editor_type` char(1) DEFAULT NULL,
  `source` varchar(32) NOT NULL DEFAULT '',
  `title` varchar(255) DEFAULT NULL,
  `body` text NOT NULL,
  `format` varchar(16) NOT NULL DEFAULT 'html',
  `ip_address` varchar(64) NOT NULL DEFAULT '',
  `extra` text,
  `recipients` text,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `thread_id` (`thread_id`),
  KEY `staff_id` (`staff_id`),
  KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_thread_entry`
--

LOCK TABLES `ost_thread_entry` WRITE;
/*!40000 ALTER TABLE `ost_thread_entry` DISABLE KEYS */;
INSERT INTO `ost_thread_entry` VALUES (1,0,1,0,1,'M',65,'osTicket Team',NULL,NULL,'Web','osTicket Installed!',' <p>Thank you for choosing osTicket. </p> <p>Please make sure you join the <a href=\"https://forum.osticket.com\">osTicket forums</a> and our <a href=\"https://osticket.com\">mailing list</a> to stay up to date on the latest news, security alerts and updates. The osTicket forums are also a great place to get assistance, guidance, tips, and help from other osTicket users. In addition to the forums, the <a href=\"https://docs.osticket.com\">osTicket Docs</a> provides a useful collection of educational materials, documentation, and notes from the community. We welcome your contributions to the osTicket community. </p> <p>If you are looking for a greater level of support, we provide professional services and commercial support with guaranteed response times, and access to the core development team. We can also help customize osTicket or even add new features to the system to meet your unique needs. </p> <p>If the idea of managing and upgrading this osTicket installation is daunting, you can try osTicket as a hosted service at <a href=\"https://supportsystem.com\">https://supportsystem.com/</a> -- no installation required and we can import your data! With SupportSystem\'s turnkey infrastructure, you get osTicket at its best, leaving you free to focus on your customers without the burden of making sure the application is stable, maintained, and secure. </p> <p>Cheers, </p> <p>-<br /> osTicket Team - https://osticket.com/ </p> <p><strong>PS.</strong> Don\'t just make customers happy, make happy customers! </p>','html','127.0.0.1',NULL,NULL,'2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_thread_entry` VALUES (2,0,2,0,2,'M',65,'Todd Tamile',NULL,NULL,'',NULL,'<p>I was just using my computer when out of nowhere my screen turned black and a ransom demand came up. There is a bitcoin address to send 2BTC to and a counter is running. I\'m sending this ticket from my phone, since I can\'t login to my computer anymore. What do I do!?</p>','html','127.0.0.1',NULL,NULL,'2025-05-23 11:26:27','2025-05-23 11:26:27');
INSERT INTO `ost_thread_entry` VALUES (3,0,3,0,3,'M',65,'Horatio Ham',NULL,NULL,'',NULL,'Our automated backups of the database server are not able to complete within our one hour assigned window. This appears to be due to a massive increase in database field alterations sometime in the past couple of days. I&nbsp;don\'t know what\'s going on over in sales, but the sysadmin team really needs to be kept in the loop on major changes. In any case, it would be greatly appreciated if the security team could advocate for boosting the datacenter bandwidth allocation. Not having backups complete is a security issue as well as an IT one!','html','127.0.0.1',NULL,NULL,'2025-05-23 11:32:26','2025-05-23 11:32:26');
INSERT INTO `ost_thread_entry` VALUES (4,0,4,0,4,'M',65,'Steve Sanders',NULL,NULL,'',NULL,'Hey could one of you security folks put in the password to spotify?&nbsp;I really need it to do my work and the IT team never responds to me. I keep getting prompted to enter the Administrator credentials while I\'m listening to my tunes and it\'s really annoying!','html','127.0.0.1',NULL,NULL,'2025-05-23 11:36:03','2025-05-23 11:36:03');
INSERT INTO `ost_thread_entry` VALUES (5,0,5,0,5,'M',65,'Lilly Lamil',NULL,NULL,'',NULL,'<p>I got an email from Steve asking if I know the Spotify password. I think Steve works remotely, but I\'ve never met him. Is this a Phish?&nbsp;</p>','html','127.0.0.1',NULL,NULL,'2025-05-23 11:40:16','2025-05-23 11:40:16');
/*!40000 ALTER TABLE `ost_thread_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_thread_entry_email`
--

DROP TABLE IF EXISTS `ost_thread_entry_email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_thread_entry_email` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `thread_entry_id` int unsigned NOT NULL,
  `email_id` int unsigned DEFAULT NULL,
  `mid` varchar(255) NOT NULL,
  `headers` text,
  PRIMARY KEY (`id`),
  KEY `thread_entry_id` (`thread_entry_id`),
  KEY `mid` (`mid`),
  KEY `email_id` (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_thread_entry_email`
--

LOCK TABLES `ost_thread_entry_email` WRITE;
/*!40000 ALTER TABLE `ost_thread_entry_email` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_thread_entry_email` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_thread_entry_merge`
--

DROP TABLE IF EXISTS `ost_thread_entry_merge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_thread_entry_merge` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `thread_entry_id` int unsigned NOT NULL,
  `data` text,
  PRIMARY KEY (`id`),
  KEY `thread_entry_id` (`thread_entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_thread_entry_merge`
--

LOCK TABLES `ost_thread_entry_merge` WRITE;
/*!40000 ALTER TABLE `ost_thread_entry_merge` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_thread_entry_merge` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_thread_event`
--

DROP TABLE IF EXISTS `ost_thread_event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_thread_event` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `thread_id` int unsigned NOT NULL DEFAULT '0',
  `thread_type` char(1) NOT NULL DEFAULT '',
  `event_id` int unsigned DEFAULT NULL,
  `staff_id` int unsigned NOT NULL,
  `team_id` int unsigned NOT NULL,
  `dept_id` int unsigned NOT NULL,
  `topic_id` int unsigned NOT NULL,
  `data` varchar(1024) DEFAULT NULL COMMENT 'Encoded differences',
  `username` varchar(128) NOT NULL DEFAULT 'SYSTEM',
  `uid` int unsigned DEFAULT NULL,
  `uid_type` char(1) NOT NULL DEFAULT 'S',
  `annulled` tinyint unsigned NOT NULL DEFAULT '0',
  `timestamp` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_state` (`thread_id`,`event_id`,`timestamp`),
  KEY `ticket_stats` (`timestamp`,`event_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_thread_event`
--

LOCK TABLES `ost_thread_event` WRITE;
/*!40000 ALTER TABLE `ost_thread_event` DISABLE KEYS */;
INSERT INTO `ost_thread_event` VALUES (1,1,'T',1,0,0,1,1,NULL,'SYSTEM',1,'U',0,'2025-05-22 17:32:42');
INSERT INTO `ost_thread_event` VALUES (2,2,'T',1,0,0,3,10,NULL,'SYSTEM',2,'U',0,'2025-05-23 11:26:27');
INSERT INTO `ost_thread_event` VALUES (3,3,'T',1,0,0,3,10,NULL,'SYSTEM',3,'U',0,'2025-05-23 11:32:26');
INSERT INTO `ost_thread_event` VALUES (4,4,'T',1,0,0,1,1,NULL,'SYSTEM',4,'U',0,'2025-05-23 11:36:03');
INSERT INTO `ost_thread_event` VALUES (5,5,'T',1,0,0,3,10,NULL,'SYSTEM',5,'U',0,'2025-05-23 11:40:16');
/*!40000 ALTER TABLE `ost_thread_event` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_thread_referral`
--

DROP TABLE IF EXISTS `ost_thread_referral`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_thread_referral` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `thread_id` int unsigned NOT NULL,
  `object_id` int unsigned NOT NULL,
  `object_type` char(1) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ref` (`object_id`,`object_type`,`thread_id`),
  KEY `thread_id` (`thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_thread_referral`
--

LOCK TABLES `ost_thread_referral` WRITE;
/*!40000 ALTER TABLE `ost_thread_referral` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_thread_referral` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_ticket`
--

DROP TABLE IF EXISTS `ost_ticket`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_ticket` (
  `ticket_id` int unsigned NOT NULL AUTO_INCREMENT,
  `ticket_pid` int unsigned DEFAULT NULL,
  `number` varchar(20) DEFAULT NULL,
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `user_email_id` int unsigned NOT NULL DEFAULT '0',
  `status_id` int unsigned NOT NULL DEFAULT '0',
  `dept_id` int unsigned NOT NULL DEFAULT '0',
  `sla_id` int unsigned NOT NULL DEFAULT '0',
  `topic_id` int unsigned NOT NULL DEFAULT '0',
  `staff_id` int unsigned NOT NULL DEFAULT '0',
  `team_id` int unsigned NOT NULL DEFAULT '0',
  `email_id` int unsigned NOT NULL DEFAULT '0',
  `lock_id` int unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '0',
  `sort` int unsigned NOT NULL DEFAULT '0',
  `ip_address` varchar(64) NOT NULL DEFAULT '',
  `source` enum('Web','Email','Phone','API','Other') NOT NULL DEFAULT 'Other',
  `source_extra` varchar(40) DEFAULT NULL,
  `isoverdue` tinyint unsigned NOT NULL DEFAULT '0',
  `isanswered` tinyint unsigned NOT NULL DEFAULT '0',
  `duedate` datetime DEFAULT NULL,
  `est_duedate` datetime DEFAULT NULL,
  `reopened` datetime DEFAULT NULL,
  `closed` datetime DEFAULT NULL,
  `lastupdate` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`ticket_id`),
  KEY `user_id` (`user_id`),
  KEY `dept_id` (`dept_id`),
  KEY `staff_id` (`staff_id`),
  KEY `team_id` (`team_id`),
  KEY `status_id` (`status_id`),
  KEY `created` (`created`),
  KEY `closed` (`closed`),
  KEY `duedate` (`duedate`),
  KEY `topic_id` (`topic_id`),
  KEY `sla_id` (`sla_id`),
  KEY `ticket_pid` (`ticket_pid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_ticket`
--

LOCK TABLES `ost_ticket` WRITE;
/*!40000 ALTER TABLE `ost_ticket` DISABLE KEYS */;
INSERT INTO `ost_ticket` VALUES (1,NULL,'746387',1,0,1,1,1,1,0,0,0,0,0,0,'127.0.0.1','Web',NULL,0,0,NULL,'2025-05-27 17:00:00',NULL,NULL,'2025-05-22 17:32:42','2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_ticket` VALUES (2,NULL,'734178',2,0,1,3,1,10,0,0,0,0,0,0,'127.0.0.1','Web',NULL,0,0,NULL,'2025-05-28 11:26:27',NULL,NULL,'2025-05-23 11:26:27','2025-05-23 11:26:27','2025-05-23 11:26:27');
INSERT INTO `ost_ticket` VALUES (3,NULL,'961243',3,0,1,3,1,10,0,0,0,0,0,0,'127.0.0.1','Web',NULL,0,0,NULL,'2025-05-28 11:32:26',NULL,NULL,'2025-05-23 11:32:26','2025-05-23 11:32:26','2025-05-23 11:32:26');
INSERT INTO `ost_ticket` VALUES (4,NULL,'874781',4,0,1,1,1,1,0,0,0,0,0,0,'127.0.0.1','Web',NULL,0,0,NULL,'2025-05-28 11:36:03',NULL,NULL,'2025-05-23 11:36:03','2025-05-23 11:36:03','2025-05-23 11:36:03');
INSERT INTO `ost_ticket` VALUES (5,NULL,'688039',5,0,1,3,1,10,0,0,0,0,0,0,'127.0.0.1','Web',NULL,0,0,NULL,'2025-05-28 11:40:16',NULL,NULL,'2025-05-23 11:40:16','2025-05-23 11:40:16','2025-05-23 11:40:17');
/*!40000 ALTER TABLE `ost_ticket` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_ticket__cdata`
--

DROP TABLE IF EXISTS `ost_ticket__cdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_ticket__cdata` (
  `ticket_id` int unsigned NOT NULL,
  `subject` mediumtext,
  `priority` mediumtext,
  `field_1` mediumtext,
  PRIMARY KEY (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_ticket__cdata`
--

LOCK TABLES `ost_ticket__cdata` WRITE;
/*!40000 ALTER TABLE `ost_ticket__cdata` DISABLE KEYS */;
INSERT INTO `ost_ticket__cdata` VALUES (1,'osTicket Installed!',NULL,NULL);
INSERT INTO `ost_ticket__cdata` VALUES (2,'RANSOMWARE!','2',NULL);
INSERT INTO `ost_ticket__cdata` VALUES (3,'More bandwidth needed','2',NULL);
INSERT INTO `ost_ticket__cdata` VALUES (4,'Spotify Install','2',NULL);
INSERT INTO `ost_ticket__cdata` VALUES (5,'Phish?','2',NULL);
/*!40000 ALTER TABLE `ost_ticket__cdata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_ticket_priority`
--

DROP TABLE IF EXISTS `ost_ticket_priority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_ticket_priority` (
  `priority_id` tinyint NOT NULL AUTO_INCREMENT,
  `priority` varchar(60) NOT NULL DEFAULT '',
  `priority_desc` varchar(30) NOT NULL DEFAULT '',
  `priority_color` varchar(7) NOT NULL DEFAULT '',
  `priority_urgency` tinyint unsigned NOT NULL DEFAULT '0',
  `ispublic` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`priority_id`),
  UNIQUE KEY `priority` (`priority`),
  KEY `priority_urgency` (`priority_urgency`),
  KEY `ispublic` (`ispublic`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_ticket_priority`
--

LOCK TABLES `ost_ticket_priority` WRITE;
/*!40000 ALTER TABLE `ost_ticket_priority` DISABLE KEYS */;
INSERT INTO `ost_ticket_priority` VALUES (1,'low','Low','#DDFFDD',4,1);
INSERT INTO `ost_ticket_priority` VALUES (2,'normal','Normal','#FFFFF0',3,1);
INSERT INTO `ost_ticket_priority` VALUES (3,'high','High','#FEE7E7',2,1);
INSERT INTO `ost_ticket_priority` VALUES (4,'emergency','Emergency','#FEE7E7',1,1);
/*!40000 ALTER TABLE `ost_ticket_priority` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_ticket_status`
--

DROP TABLE IF EXISTS `ost_ticket_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_ticket_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  `state` varchar(16) DEFAULT NULL,
  `mode` int unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '0',
  `sort` int unsigned NOT NULL DEFAULT '0',
  `properties` text NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `state` (`state`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_ticket_status`
--

LOCK TABLES `ost_ticket_status` WRITE;
/*!40000 ALTER TABLE `ost_ticket_status` DISABLE KEYS */;
INSERT INTO `ost_ticket_status` VALUES (1,'Open','open',3,0,1,'{\"description\":\"Open tickets.\"}','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_ticket_status` VALUES (2,'Resolved','closed',1,0,2,'{\"allowreopen\":true,\"reopenstatus\":0,\"description\":\"Resolved tickets\"}','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_ticket_status` VALUES (3,'Closed','closed',3,0,3,'{\"allowreopen\":true,\"reopenstatus\":0,\"description\":\"Closed tickets. Tickets will still be accessible on client and staff panels.\"}','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_ticket_status` VALUES (4,'Archived','archived',3,0,4,'{\"description\":\"Tickets only adminstratively available but no longer accessible on ticket queues and client panel.\"}','2025-05-22 17:32:39','0000-00-00 00:00:00');
INSERT INTO `ost_ticket_status` VALUES (5,'Deleted','deleted',3,0,5,'{\"description\":\"Tickets queued for deletion. Not accessible on ticket queues.\"}','2025-05-22 17:32:39','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `ost_ticket_status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_translation`
--

DROP TABLE IF EXISTS `ost_translation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_translation` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `object_hash` char(16) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `type` enum('phrase','article','override') DEFAULT NULL,
  `flags` int unsigned NOT NULL DEFAULT '0',
  `revision` int unsigned DEFAULT NULL,
  `agent_id` int unsigned NOT NULL DEFAULT '0',
  `lang` varchar(16) NOT NULL DEFAULT '',
  `text` mediumtext NOT NULL,
  `source_text` text,
  `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `type` (`type`,`lang`),
  KEY `object_hash` (`object_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_translation`
--

LOCK TABLES `ost_translation` WRITE;
/*!40000 ALTER TABLE `ost_translation` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_translation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_user`
--

DROP TABLE IF EXISTS `ost_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_user` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `org_id` int unsigned NOT NULL,
  `default_email_id` int NOT NULL,
  `status` int unsigned NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `org_id` (`org_id`),
  KEY `default_email_id` (`default_email_id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_user`
--

LOCK TABLES `ost_user` WRITE;
/*!40000 ALTER TABLE `ost_user` DISABLE KEYS */;
INSERT INTO `ost_user` VALUES (1,1,1,0,'osTicket Team','2025-05-22 17:32:42','2025-05-22 17:32:42');
INSERT INTO `ost_user` VALUES (2,0,2,0,'Todd Tamile','2025-05-23 11:26:27','2025-05-23 11:26:27');
INSERT INTO `ost_user` VALUES (3,0,3,0,'Horatio Ham','2025-05-23 11:32:26','2025-05-23 11:32:26');
INSERT INTO `ost_user` VALUES (4,0,4,0,'Steve Sanders','2025-05-23 11:36:03','2025-05-23 11:36:03');
INSERT INTO `ost_user` VALUES (5,0,5,0,'Lilly Lamil','2025-05-23 11:40:16','2025-05-23 11:40:16');
/*!40000 ALTER TABLE `ost_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_user__cdata`
--

DROP TABLE IF EXISTS `ost_user__cdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_user__cdata` (
  `user_id` int unsigned NOT NULL,
  `email` mediumtext,
  `name` mediumtext,
  `phone` mediumtext,
  `notes` mediumtext,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_user__cdata`
--

LOCK TABLES `ost_user__cdata` WRITE;
/*!40000 ALTER TABLE `ost_user__cdata` DISABLE KEYS */;
INSERT INTO `ost_user__cdata` VALUES (2,NULL,NULL,'5551553','');
INSERT INTO `ost_user__cdata` VALUES (3,NULL,NULL,'5551390','');
INSERT INTO `ost_user__cdata` VALUES (4,NULL,NULL,'5551901','');
INSERT INTO `ost_user__cdata` VALUES (5,NULL,NULL,'5551290','');
/*!40000 ALTER TABLE `ost_user__cdata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_user_account`
--

DROP TABLE IF EXISTS `ost_user_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_user_account` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `status` int unsigned NOT NULL DEFAULT '0',
  `timezone` varchar(64) DEFAULT NULL,
  `lang` varchar(16) DEFAULT NULL,
  `username` varchar(64) DEFAULT NULL,
  `passwd` varchar(128) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `backend` varchar(32) DEFAULT NULL,
  `extra` text,
  `registered` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_user_account`
--

LOCK TABLES `ost_user_account` WRITE;
/*!40000 ALTER TABLE `ost_user_account` DISABLE KEYS */;
/*!40000 ALTER TABLE `ost_user_account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ost_user_email`
--

DROP TABLE IF EXISTS `ost_user_email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ost_user_email` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `flags` int unsigned NOT NULL DEFAULT '0',
  `address` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `address` (`address`),
  KEY `user_email_lookup` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ost_user_email`
--

LOCK TABLES `ost_user_email` WRITE;
/*!40000 ALTER TABLE `ost_user_email` DISABLE KEYS */;
INSERT INTO `ost_user_email` VALUES (1,1,0,'feedback@osticket.com');
INSERT INTO `ost_user_email` VALUES (2,2,0,'todd@sales.localhost');
INSERT INTO `ost_user_email` VALUES (3,3,0,'horatio@sysadmin.localhost');
INSERT INTO `ost_user_email` VALUES (4,4,0,'steve@sales.localhost');
INSERT INTO `ost_user_email` VALUES (5,5,0,'lilly@accounting.localhost');
/*!40000 ALTER TABLE `ost_user_email` 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 2025-05-23 11:47:26