-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------


-- Dumping structure for table helper.activities
CREATE TABLE IF NOT EXISTS `activities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.activities: ~5 rows (approximately)
INSERT INTO `activities` (`id`, `name`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Programming', 'Programming related activities', '2025-11-19 18:20:29', '2025-11-19 18:20:29', NULL),
	(2, 'Testing', 'Testing related activities', '2025-11-19 18:20:29', '2025-11-19 18:20:29', NULL),
	(3, 'Learning', 'Activities related to learning and training', '2025-11-19 18:20:29', '2025-11-19 18:20:29', NULL),
	(4, 'Research', 'Activities related to research', '2025-11-19 18:20:29', '2025-11-19 18:20:29', NULL),
	(5, 'Other', 'Other activities', '2025-11-19 18:20:29', '2025-11-19 18:20:29', NULL);

-- Dumping structure for table helper.epics
CREATE TABLE IF NOT EXISTS `epics` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `starts_at` date NOT NULL,
  `ends_at` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `parent_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `epics_project_id_foreign` (`project_id`),
  KEY `epics_parent_id_foreign` (`parent_id`),
  CONSTRAINT `epics_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `epics` (`id`),
  CONSTRAINT `epics_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.epics: ~0 rows (approximately)

-- Dumping structure for table helper.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table helper.jobs
CREATE TABLE IF NOT EXISTS `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.jobs: ~0 rows (approximately)

-- Dumping structure for table helper.media
CREATE TABLE IF NOT EXISTS `media` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint unsigned NOT NULL,
  `manipulations` json NOT NULL,
  `custom_properties` json NOT NULL,
  `generated_conversions` json NOT NULL,
  `responsive_images` json NOT NULL,
  `order_column` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `media_uuid_unique` (`uuid`),
  KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  KEY `media_order_column_index` (`order_column`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.media: ~1 rows (approximately)
INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
	(1, 'App\\Models\\Project', 1, '7b72b810-fc46-48b4-bc64-66650ab640db', 'default', 'logo', 'FFf9jpxDzYTpW4AAblpDBDSmKRZmKk-metabG9nby5wbmc=-.png', 'image/png', 'public', 'public', 92903, '[]', '[]', '[]', '[]', 1, '2025-11-19 18:30:12', '2025-11-19 18:30:12');

-- Dumping structure for table helper.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.migrations: ~0 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_000000_create_users_table', 1),
	(2, '2014_10_12_100000_create_password_resets_table', 1),
	(3, '2019_08_19_000000_create_failed_jobs_table', 1),
	(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(5, '2022_11_02_111430_add_two_factor_columns_to_table', 1),
	(6, '2022_11_02_113007_create_permission_tables', 1),
	(7, '2022_11_02_124027_create_project_statuses_table', 1),
	(8, '2022_11_02_124028_create_projects_table', 1),
	(9, '2022_11_02_131753_create_project_users_table', 1),
	(10, '2022_11_02_134510_create_media_table', 1),
	(11, '2022_11_02_152359_create_project_favorites_table', 1),
	(12, '2022_11_02_193241_create_ticket_statuses_table', 1),
	(13, '2022_11_02_193242_create_tickets_table', 1),
	(14, '2022_11_06_155109_add_tickets_prefix_to_projects', 1),
	(15, '2022_11_06_163226_add_code_to_tickets', 1),
	(16, '2022_11_06_164004_create_ticket_types_table', 1),
	(17, '2022_11_06_165400_add_type_to_ticket', 1),
	(18, '2022_11_06_173220_add_order_to_tickets', 1),
	(19, '2022_11_06_184448_add_order_to_ticket_statuses', 1),
	(20, '2022_11_06_193051_create_ticket_activities_table', 1),
	(21, '2022_11_06_194000_create_ticket_priorities_table', 1),
	(22, '2022_11_06_194728_add_priority_to_tickets', 1),
	(23, '2022_11_06_203702_add_status_type_to_project', 1),
	(24, '2022_11_06_204227_add_project_to_ticket_statuses', 1),
	(25, '2022_11_07_064347_create_ticket_comments_table', 1),
	(26, '2022_11_08_084509_create_ticket_subscribers_table', 1),
	(27, '2022_11_08_144611_create_notifications_table', 1),
	(28, '2022_11_08_150309_create_jobs_table', 1),
	(29, '2022_11_08_163244_create_ticket_relations_table', 1),
	(30, '2022_11_08_172846_create_settings_table', 1),
	(31, '2022_11_08_173004_general_settings', 1),
	(32, '2022_11_08_173852_create_general_settings', 1),
	(33, '2022_11_09_085506_create_socialite_users_table', 1),
	(34, '2022_11_09_085638_make_user_password_nullable', 1),
	(35, '2022_11_09_110740_remove_unique_from_users', 1),
	(36, '2022_11_09_110955_add_soft_deletes_to_users', 1),
	(37, '2022_11_09_173852_add_social_login_to_general_settings', 1),
	(38, '2022_11_10_193214_create_ticket_hours_table', 1),
	(39, '2022_11_10_200608_add_estimation_to_tickets', 1),
	(40, '2022_11_12_134201_add_creation_token_to_users', 1),
	(41, '2022_11_12_142644_create_pending_user_emails_table', 1),
	(42, '2022_11_12_173852_add_default_role_to_general_settings', 1),
	(43, '2022_11_12_173852_add_login_form_oidc_enabled_flags_to_general_settings', 1),
	(44, '2022_11_12_173852_add_site_language_to_general_settings', 1),
	(45, '2022_12_15_100852_create_epics_table', 1),
	(46, '2022_12_15_101035_add_epic_to_ticket', 1),
	(47, '2022_12_16_133836_add_parent_to_epics', 1),
	(48, '2022_12_27_082239_add_comment_to_ticket_hours', 1),
	(49, '2023_01_05_182946_add_attachments_to_tickets', 1),
	(50, '2023_01_09_113159_create_activities_table', 1),
	(51, '2023_01_09_113847_add_activity_to_ticket_hours_table', 1),
	(52, '2023_01_12_203211_remove_unique_constraint_from_users', 1),
	(53, '2023_01_12_204221_drop_attachments', 1),
	(54, '2023_01_15_201358_add_type_to_projects', 1),
	(55, '2023_01_15_202225_create_sprints_table', 1),
	(56, '2023_01_15_204606_add_sprint_to_tickets', 1),
	(57, '2023_01_15_214849_add_epic_to_sprints', 1),
	(58, '2023_01_16_085329_add_started_ended_at_to_sprints', 1),
	(59, '2023_01_24_084637_update_users_for_oidc', 1),
	(60, '2023_04_10_123922_add_unique_ticket_prefix_to_projects_table', 1);

-- Dumping structure for table helper.model_has_permissions
CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.model_has_permissions: ~0 rows (approximately)

-- Dumping structure for table helper.model_has_roles
CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.model_has_roles: ~0 rows (approximately)
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
	(1, 'App\\Models\\User', 1);

-- Dumping structure for table helper.notifications
CREATE TABLE IF NOT EXISTS `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.notifications: ~1 rows (approximately)
INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
	('2dd796ba-9c7e-4106-9aed-83cfb4d1c7d1', 'App\\Notifications\\TicketCreated', 'App\\Models\\User', 1, '{"actions":[{"name":"view","color":null,"event":null,"eventData":[],"extraAttributes":[],"icon":"heroicon-s-eye","iconPosition":null,"isOutlined":false,"isDisabled":false,"label":"View","shouldCloseNotification":false,"shouldOpenUrlInNewTab":false,"size":null,"url":"http:\\/\\/helper.test\\/tickets\\/share\\/LGB-1","view":"notifications::actions.link-action"}],"body":"rrf sdf sd fsd fsdfsdfsdf sdfs","duration":"persistent","icon":"heroicon-o-ticket","iconColor":"secondary","title":"New ticket created","format":"filament"}', NULL, '2025-11-19 18:32:00', '2025-11-19 18:32:00');

-- Dumping structure for table helper.password_resets
CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.password_resets: ~0 rows (approximately)

-- Dumping structure for table helper.pending_user_emails
CREATE TABLE IF NOT EXISTS `pending_user_emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pending_user_emails_user_type_user_id_index` (`user_type`,`user_id`),
  KEY `pending_user_emails_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.pending_user_emails: ~0 rows (approximately)

-- Dumping structure for table helper.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.permissions: ~59 rows (approximately)
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'List permissions', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(2, 'View permission', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(3, 'Create permission', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(4, 'Update permission', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(5, 'Delete permission', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(6, 'List projects', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(7, 'View project', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(8, 'Create project', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(9, 'Update project', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(10, 'Delete project', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(11, 'List project statuses', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(12, 'View project status', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(13, 'Create project status', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(14, 'Update project status', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(15, 'Delete project status', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(16, 'List roles', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(17, 'View role', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(18, 'Create role', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(19, 'Update role', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(20, 'Delete role', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(21, 'List tickets', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(22, 'View ticket', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(23, 'Create ticket', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(24, 'Update ticket', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(25, 'Delete ticket', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(26, 'List ticket priorities', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(27, 'View ticket priority', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(28, 'Create ticket priority', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(29, 'Update ticket priority', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(30, 'Delete ticket priority', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(31, 'List ticket statuses', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(32, 'View ticket status', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(33, 'Create ticket status', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(34, 'Update ticket status', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(35, 'Delete ticket status', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(36, 'List ticket types', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(37, 'View ticket type', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(38, 'Create ticket type', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(39, 'Update ticket type', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(40, 'Delete ticket type', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(41, 'List users', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(42, 'View user', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(43, 'Create user', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(44, 'Update user', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(45, 'Delete user', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(46, 'List activities', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(47, 'View activity', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(48, 'Create activity', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(49, 'Update activity', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(50, 'Delete activity', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(51, 'List sprints', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(52, 'View sprint', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(53, 'Create sprint', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(54, 'Update sprint', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(55, 'Delete sprint', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(56, 'Manage general settings', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(57, 'Import from Jira', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(58, 'List timesheet data', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28'),
	(59, 'View timesheet dashboard', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28');

-- Dumping structure for table helper.personal_access_tokens
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.personal_access_tokens: ~0 rows (approximately)

-- Dumping structure for table helper.projects
CREATE TABLE IF NOT EXISTS `projects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `owner_id` bigint unsigned NOT NULL,
  `status_id` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ticket_prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'kanban',
  PRIMARY KEY (`id`),
  UNIQUE KEY `projects_ticket_prefix_unique` (`ticket_prefix`),
  KEY `projects_owner_id_foreign` (`owner_id`),
  KEY `projects_status_id_foreign` (`status_id`),
  CONSTRAINT `projects_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`),
  CONSTRAINT `projects_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `project_statuses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.projects: ~0 rows (approximately)
INSERT INTO `projects` (`id`, `name`, `description`, `owner_id`, `status_id`, `deleted_at`, `created_at`, `updated_at`, `ticket_prefix`, `status_type`, `type`) VALUES
	(1, 'LotfiGED', NULL, 1, 1, NULL, '2025-11-19 18:30:12', '2025-11-19 18:30:12', 'LGB', 'default', 'kanban');

-- Dumping structure for table helper.project_favorites
CREATE TABLE IF NOT EXISTS `project_favorites` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `project_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_favorites_user_id_foreign` (`user_id`),
  KEY `project_favorites_project_id_foreign` (`project_id`),
  CONSTRAINT `project_favorites_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`),
  CONSTRAINT `project_favorites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.project_favorites: ~0 rows (approximately)

-- Dumping structure for table helper.project_statuses
CREATE TABLE IF NOT EXISTS `project_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.project_statuses: ~2 rows (approximately)
INSERT INTO `project_statuses` (`id`, `name`, `color`, `is_default`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'in progress', '#318cd6', 1, NULL, '2025-11-19 18:29:17', '2025-11-19 18:30:01'),
	(2, 'Terminated', '#29bf2b', 0, NULL, '2025-11-19 18:29:37', '2025-11-19 18:29:37');

-- Dumping structure for table helper.project_users
CREATE TABLE IF NOT EXISTS `project_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `project_id` bigint unsigned NOT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_users_user_id_foreign` (`user_id`),
  KEY `project_users_project_id_foreign` (`project_id`),
  CONSTRAINT `project_users_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`),
  CONSTRAINT `project_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.project_users: ~0 rows (approximately)

-- Dumping structure for table helper.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.roles: ~0 rows (approximately)
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'Default role', 'web', '2025-11-19 18:20:28', '2025-11-19 18:20:28');

-- Dumping structure for table helper.role_has_permissions
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.role_has_permissions: ~59 rows (approximately)
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
	(1, 1),
	(2, 1),
	(3, 1),
	(4, 1),
	(5, 1),
	(6, 1),
	(7, 1),
	(8, 1),
	(9, 1),
	(10, 1),
	(11, 1),
	(12, 1),
	(13, 1),
	(14, 1),
	(15, 1),
	(16, 1),
	(17, 1),
	(18, 1),
	(19, 1),
	(20, 1),
	(21, 1),
	(22, 1),
	(23, 1),
	(24, 1),
	(25, 1),
	(26, 1),
	(27, 1),
	(28, 1),
	(29, 1),
	(30, 1),
	(31, 1),
	(32, 1),
	(33, 1),
	(34, 1),
	(35, 1),
	(36, 1),
	(37, 1),
	(38, 1),
	(39, 1),
	(40, 1),
	(41, 1),
	(42, 1),
	(43, 1),
	(44, 1),
	(45, 1),
	(46, 1),
	(47, 1),
	(48, 1),
	(49, 1),
	(50, 1),
	(51, 1),
	(52, 1),
	(53, 1),
	(54, 1),
	(55, 1),
	(56, 1),
	(57, 1),
	(58, 1),
	(59, 1);

-- Dumping structure for table helper.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `payload` json NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `settings_group_index` (`group`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.settings: ~8 rows (approximately)
INSERT INTO `settings` (`id`, `group`, `name`, `locked`, `payload`, `created_at`, `updated_at`) VALUES
	(1, 'general', 'site_name', 0, '"TaskFlow"', '2025-11-19 18:20:27', '2025-11-19 18:34:45'),
	(2, 'general', 'site_logo', 0, 'null', '2025-11-19 18:20:27', '2025-11-19 18:34:45'),
	(3, 'general', 'enable_registration', 0, 'false', '2025-11-19 18:20:27', '2025-11-19 18:34:45'),
	(4, 'general', 'enable_social_login', 0, '""', '2025-11-19 18:20:27', '2025-11-19 18:34:45'),
	(5, 'general', 'default_role', 0, '"1"', '2025-11-19 18:20:27', '2025-11-19 18:34:45'),
	(6, 'general', 'enable_login_form', 0, '"1"', '2025-11-19 18:20:27', '2025-11-19 18:34:45'),
	(7, 'general', 'enable_oidc_login', 0, '""', '2025-11-19 18:20:27', '2025-11-19 18:34:45'),
	(8, 'general', 'site_language', 0, '"en"', '2025-11-19 18:20:27', '2025-11-19 18:34:45');

-- Dumping structure for table helper.socialite_users
CREATE TABLE IF NOT EXISTS `socialite_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `socialite_users_provider_provider_id_unique` (`provider`,`provider_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.socialite_users: ~0 rows (approximately)

-- Dumping structure for table helper.sprints
CREATE TABLE IF NOT EXISTS `sprints` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `starts_at` date NOT NULL,
  `ends_at` date NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `project_id` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `epic_id` bigint unsigned DEFAULT NULL,
  `started_at` datetime DEFAULT NULL,
  `ended_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sprints_project_id_foreign` (`project_id`),
  KEY `sprints_epic_id_foreign` (`epic_id`),
  CONSTRAINT `sprints_epic_id_foreign` FOREIGN KEY (`epic_id`) REFERENCES `epics` (`id`),
  CONSTRAINT `sprints_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.sprints: ~0 rows (approximately)

-- Dumping structure for table helper.tickets
CREATE TABLE IF NOT EXISTS `tickets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner_id` bigint unsigned NOT NULL,
  `responsible_id` bigint unsigned DEFAULT NULL,
  `status_id` bigint unsigned NOT NULL,
  `project_id` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_id` bigint unsigned NOT NULL,
  `order` int NOT NULL DEFAULT '0',
  `priority_id` bigint unsigned NOT NULL,
  `estimation` double(8,2) DEFAULT NULL,
  `epic_id` bigint unsigned DEFAULT NULL,
  `sprint_id` bigint 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.tickets: ~1 rows (approximately)
INSERT INTO `tickets` (`id`, `name`, `content`, `owner_id`, `responsible_id`, `status_id`, `project_id`, `deleted_at`, `created_at`, `updated_at`, `code`, `type_id`, `order`, `priority_id`, `estimation`, `epic_id`, `sprint_id`) VALUES
	(1, 'rrf sdf sd fsd fsdfsdfsdf sdfs', '<p>dfvdf vdfv dfvdfvdf</p>', 1, 1, 1, 1, NULL, '2025-11-19 18:31:54', '2025-11-19 18:31:54', 'LGB-1', 1, 0, 2, NULL, NULL, NULL);

-- Dumping structure for table helper.ticket_activities
CREATE TABLE IF NOT EXISTS `ticket_activities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint unsigned NOT NULL,
  `old_status_id` bigint unsigned NOT NULL,
  `new_status_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_activities_ticket_id_foreign` (`ticket_id`),
  KEY `ticket_activities_old_status_id_foreign` (`old_status_id`),
  KEY `ticket_activities_new_status_id_foreign` (`new_status_id`),
  KEY `ticket_activities_user_id_foreign` (`user_id`),
  CONSTRAINT `ticket_activities_new_status_id_foreign` FOREIGN KEY (`new_status_id`) REFERENCES `ticket_statuses` (`id`),
  CONSTRAINT `ticket_activities_old_status_id_foreign` FOREIGN KEY (`old_status_id`) REFERENCES `ticket_statuses` (`id`),
  CONSTRAINT `ticket_activities_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`),
  CONSTRAINT `ticket_activities_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.ticket_activities: ~0 rows (approximately)

-- Dumping structure for table helper.ticket_comments
CREATE TABLE IF NOT EXISTS `ticket_comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_comments_ticket_id_foreign` (`ticket_id`),
  KEY `ticket_comments_user_id_foreign` (`user_id`),
  CONSTRAINT `ticket_comments_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`),
  CONSTRAINT `ticket_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.ticket_comments: ~0 rows (approximately)

-- Dumping structure for table helper.ticket_hours
CREATE TABLE IF NOT EXISTS `ticket_hours` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `value` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `comment` longtext COLLATE utf8mb4_unicode_ci,
  `activity_id` bigint 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;

-- Dumping data for table helper.ticket_hours: ~0 rows (approximately)

-- Dumping structure for table helper.ticket_priorities
CREATE TABLE IF NOT EXISTS `ticket_priorities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci 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;

-- Dumping data for table helper.ticket_priorities: ~3 rows (approximately)
INSERT INTO `ticket_priorities` (`id`, `name`, `color`, `is_default`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'Low', '#008000', 0, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29'),
	(2, 'Normal', '#CECECE', 1, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29'),
	(3, 'High', '#ff0000', 0, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29');

-- Dumping structure for table helper.ticket_relations
CREATE TABLE IF NOT EXISTS `ticket_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint unsigned NOT NULL,
  `relation_id` bigint unsigned NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` int 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;

-- Dumping data for table helper.ticket_relations: ~0 rows (approximately)

-- Dumping structure for table helper.ticket_statuses
CREATE TABLE IF NOT EXISTS `ticket_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci 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 NOT NULL DEFAULT '1',
  `project_id` bigint 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;

-- Dumping data for table helper.ticket_statuses: ~4 rows (approximately)
INSERT INTO `ticket_statuses` (`id`, `name`, `color`, `is_default`, `deleted_at`, `created_at`, `updated_at`, `order`, `project_id`) VALUES
	(1, 'Todo', '#cecece', 1, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29', 1, NULL),
	(2, 'In progress', '#ff7f00', 0, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29', 2, NULL),
	(3, 'Done', '#008000', 0, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29', 3, NULL),
	(4, 'Archived', '#ff0000', 0, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29', 4, NULL);

-- Dumping structure for table helper.ticket_subscribers
CREATE TABLE IF NOT EXISTS `ticket_subscribers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `ticket_id` bigint 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;

-- Dumping data for table helper.ticket_subscribers: ~0 rows (approximately)

-- Dumping structure for table helper.ticket_types
CREATE TABLE IF NOT EXISTS `ticket_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci 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;

-- Dumping data for table helper.ticket_types: ~3 rows (approximately)
INSERT INTO `ticket_types` (`id`, `name`, `icon`, `color`, `is_default`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'Task', 'heroicon-o-check-circle', '#00FFFF', 1, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29'),
	(2, 'Evolution', 'heroicon-o-clipboard-list', '#008000', 0, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29'),
	(3, 'Bug', 'heroicon-o-x', '#ff0000', 0, NULL, '2025-11-19 18:20:29', '2025-11-19 18:20:29');

-- Dumping structure for table helper.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `two_factor_secret` text COLLATE utf8mb4_unicode_ci,
  `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci,
  `two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `creation_token` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'db',
  `oidc_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oidc_sub` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table helper.users: ~0 rows (approximately)
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `remember_token`, `created_at`, `updated_at`, `deleted_at`, `creation_token`, `type`, `oidc_username`, `oidc_sub`) VALUES
	(1, 'John DOE', 'john.doe@helper.app', '2025-11-19 18:20:28', '$2y$10$I7VeQ4zqWj/UYnpYhSz5WuXUnpBDXTpPcDdJgSlXk9PgPsLA/42NO', NULL, NULL, NULL, 'BT5bKlNpB4WmNdWEuilUE6vulCqyVf440mrq5jKgZgVA30cOZ3OwJoaa2k25', '2025-11-19 18:20:28', '2025-11-19 18:20:28', NULL, NULL, 'db', NULL, NULL),
	(2, 'mbz-solutions', 'mourad.bouzidi.1996@gmail.com', '2025-11-19 18:23:09', '$2y$10$P.BZ1QC5jNIsEQpauemNm.dSfuUjijFauxpZSOPtGqNp22BBBgF6q', NULL, NULL, NULL, 'bVZvh7p6C2w4G3ga6vzfA61zrPli4v0LxigM6HFvt4JMKTtrdycq6kTvdn3q', '2025-11-19 18:22:34', '2025-11-19 18:23:09', NULL, NULL, 'db', NULL, NULL);

