Warning : session_start(): Session cannot be started after headers have already been sent in /home/tvrreohg/public_html/manga.php on line 13 sasafsafsf
',NULL,'2024-04-03 01:48:18','2024-04-03 01:48:18'),(2,2,1,'test
',NULL,'2024-04-03 02:14:18','2024-04-03 02:14:18');
/*!40000 ALTER TABLE `ticket_comments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ticket_hours`
--
DROP TABLE IF EXISTS `ticket_hours`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticket_hours` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`value` double(8,2) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`comment` longtext DEFAULT NULL,
`activity_id` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ticket_hours_ticket_id_foreign` (`ticket_id`),
KEY `ticket_hours_user_id_foreign` (`user_id`),
KEY `ticket_hours_activity_id_foreign` (`activity_id`),
CONSTRAINT `ticket_hours_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`),
CONSTRAINT `ticket_hours_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`),
CONSTRAINT `ticket_hours_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ticket_hours`
--
LOCK TABLES `ticket_hours` WRITE;
/*!40000 ALTER TABLE `ticket_hours` DISABLE KEYS */;
/*!40000 ALTER TABLE `ticket_hours` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ticket_priorities`
--
DROP TABLE IF EXISTS `ticket_priorities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticket_priorities` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`color` varchar(255) NOT NULL DEFAULT '#cecece',
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ticket_priorities`
--
LOCK TABLES `ticket_priorities` WRITE;
/*!40000 ALTER TABLE `ticket_priorities` DISABLE KEYS */;
INSERT INTO `ticket_priorities` VALUES (1,'Low','#008000',0,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57'),(2,'Normal','#CECECE',1,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57'),(3,'High','#ff0000',0,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57');
/*!40000 ALTER TABLE `ticket_priorities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ticket_relations`
--
DROP TABLE IF EXISTS `ticket_relations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticket_relations` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) unsigned NOT NULL,
`relation_id` bigint(20) unsigned NOT NULL,
`type` varchar(255) NOT NULL,
`sort` int(11) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ticket_relations_ticket_id_foreign` (`ticket_id`),
KEY `ticket_relations_relation_id_foreign` (`relation_id`),
CONSTRAINT `ticket_relations_relation_id_foreign` FOREIGN KEY (`relation_id`) REFERENCES `tickets` (`id`),
CONSTRAINT `ticket_relations_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ticket_relations`
--
LOCK TABLES `ticket_relations` WRITE;
/*!40000 ALTER TABLE `ticket_relations` DISABLE KEYS */;
/*!40000 ALTER TABLE `ticket_relations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ticket_statuses`
--
DROP TABLE IF EXISTS `ticket_statuses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticket_statuses` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`color` varchar(255) NOT NULL DEFAULT '#cecece',
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 1,
`project_id` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ticket_statuses_project_id_foreign` (`project_id`),
CONSTRAINT `ticket_statuses_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ticket_statuses`
--
LOCK TABLES `ticket_statuses` WRITE;
/*!40000 ALTER TABLE `ticket_statuses` DISABLE KEYS */;
INSERT INTO `ticket_statuses` VALUES (1,'Todo','#cecece',1,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57',1,NULL),(2,'In progress','#ff7f00',0,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57',2,NULL),(3,'Done','#008000',0,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57',3,NULL),(4,'Archived','#ff0000',0,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57',4,NULL);
/*!40000 ALTER TABLE `ticket_statuses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ticket_subscribers`
--
DROP TABLE IF EXISTS `ticket_subscribers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticket_subscribers` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`ticket_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ticket_subscribers_user_id_foreign` (`user_id`),
KEY `ticket_subscribers_ticket_id_foreign` (`ticket_id`),
CONSTRAINT `ticket_subscribers_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`),
CONSTRAINT `ticket_subscribers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ticket_subscribers`
--
LOCK TABLES `ticket_subscribers` WRITE;
/*!40000 ALTER TABLE `ticket_subscribers` DISABLE KEYS */;
/*!40000 ALTER TABLE `ticket_subscribers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ticket_types`
--
DROP TABLE IF EXISTS `ticket_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticket_types` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`icon` varchar(255) NOT NULL,
`color` varchar(255) NOT NULL DEFAULT '#cecece',
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ticket_types`
--
LOCK TABLES `ticket_types` WRITE;
/*!40000 ALTER TABLE `ticket_types` DISABLE KEYS */;
INSERT INTO `ticket_types` VALUES (1,'Task','heroicon-o-check-circle','#00FFFF',1,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57'),(2,'Evolution','heroicon-o-clipboard-list','#008000',0,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57'),(3,'Bug','heroicon-o-x','#ff0000',0,NULL,'2024-04-03 01:25:57','2024-04-03 01:25:57');
/*!40000 ALTER TABLE `ticket_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tickets`
--
DROP TABLE IF EXISTS `tickets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tickets` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`content` longtext NOT NULL,
`owner_id` bigint(20) unsigned NOT NULL,
`responsible_id` bigint(20) unsigned DEFAULT NULL,
`status_id` bigint(20) unsigned NOT NULL,
`project_id` bigint(20) unsigned NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`code` varchar(255) NOT NULL,
`type_id` bigint(20) unsigned NOT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`priority_id` bigint(20) unsigned NOT NULL,
`estimation` double(8,2) DEFAULT NULL,
`epic_id` bigint(20) unsigned DEFAULT NULL,
`sprint_id` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `tickets_owner_id_foreign` (`owner_id`),
KEY `tickets_responsible_id_foreign` (`responsible_id`),
KEY `tickets_status_id_foreign` (`status_id`),
KEY `tickets_project_id_foreign` (`project_id`),
KEY `tickets_type_id_foreign` (`type_id`),
KEY `tickets_priority_id_foreign` (`priority_id`),
KEY `tickets_epic_id_foreign` (`epic_id`),
KEY `tickets_sprint_id_foreign` (`sprint_id`),
CONSTRAINT `tickets_epic_id_foreign` FOREIGN KEY (`epic_id`) REFERENCES `epics` (`id`),
CONSTRAINT `tickets_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`),
CONSTRAINT `tickets_priority_id_foreign` FOREIGN KEY (`priority_id`) REFERENCES `ticket_priorities` (`id`),
CONSTRAINT `tickets_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`),
CONSTRAINT `tickets_responsible_id_foreign` FOREIGN KEY (`responsible_id`) REFERENCES `users` (`id`),
CONSTRAINT `tickets_sprint_id_foreign` FOREIGN KEY (`sprint_id`) REFERENCES `sprints` (`id`),
CONSTRAINT `tickets_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `ticket_statuses` (`id`),
CONSTRAINT `tickets_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `ticket_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tickets`
--
LOCK TABLES `tickets` WRITE;
/*!40000 ALTER TABLE `tickets` DISABLE KEYS */;
INSERT INTO `tickets` VALUES (1,'Maddie / Madeline Pratt - Rent The Table','As discussed, the readability of the website font is an issue. You can explore the Google Fonts link provided below to review and select a suitable font for the entire website:
Browse Fonts - Google Fonts
Please proceed with choosing a font that addresses the readability concerns.
',1,2,1,1,NULL,'2024-04-03 01:47:22','2024-04-03 01:47:22','DS-1',1,0,2,2.00,1,NULL),(2,'testttt','test
',1,4,1,1,NULL,'2024-04-03 02:11:57','2024-04-03 02:11:57','DS-2',1,1,2,NULL,1,NULL);
/*!40000 ALTER TABLE `tickets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`two_factor_secret` text DEFAULT NULL,
`two_factor_recovery_codes` text DEFAULT NULL,
`two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`creation_token` char(36) DEFAULT NULL,
`type` varchar(255) NOT NULL DEFAULT 'db',
`oidc_username` varchar(255) DEFAULT NULL,
`oidc_sub` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'John DOE','john.doe@helper.app','2024-04-03 01:25:55','$2y$10$AVRFIpzL.EGpaHK9/5BdkOv/lgIocpqa0xf28QqiSE9YmtjNVdsvm',NULL,NULL,NULL,'vSkFIPIm19Y8MX9i5Js2yTt592o2ypCELGYtdDmGxCOlo0ahyXhILcEtsaWf','2024-04-03 01:25:55','2024-04-03 01:25:55',NULL,NULL,'db',NULL,NULL),(2,'Habib','ds.dev.habib@gmail.com',NULL,'$2y$10$AVRFIpzL.EGpaHK9/5BdkOv/lgIocpqa0xf28QqiSE9YmtjNVdsvm',NULL,NULL,NULL,NULL,'2024-04-03 01:30:33','2024-04-03 01:50:21','2024-04-03 01:50:21',NULL,'db',NULL,NULL),(4,'Habib','ds.dev.habib@gmail.com',NULL,'$2y$10$AVRFIpzL.EGpaHK9/5BdkOv/lgIocpqa0xf28QqiSE9YmtjNVdsvm',NULL,NULL,NULL,NULL,'2024-04-03 01:56:50','2024-04-03 01:56:50',NULL,NULL,'db',NULL,NULL);
/*!40000 ALTER TABLE `users` 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-06-18 21:55:56
![](\"https://www.gstatic.com/images/icons/material/apps/fonts/1x/catalog/v5/favicon.svg\"){kind=icon}