# ************************************************************
# Sequel Ace SQL dump
# Version 20109
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# Host: 127.0.0.1 (MySQL 9.5.0)
# Database: trainingmanagement
# Generation Time: 2026-09-23 02:49:50 +0000
# ************************************************************


/*!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 */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table activity_logs
# ------------------------------------------------------------

DROP TABLE IF EXISTS `activity_logs`;

CREATE TABLE `activity_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_id` bigint unsigned DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `device_fingerprint` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_logs_user_id_foreign` (`user_id`),
  KEY `activity_logs_company_id_created_at_index` (`company_id`,`created_at`),
  CONSTRAINT `activity_logs_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE SET NULL,
  CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `activity_logs` WRITE;
/*!40000 ALTER TABLE `activity_logs` DISABLE KEYS */;

INSERT INTO `activity_logs` (`id`, `company_id`, `user_id`, `action`, `subject_type`, `subject_id`, `description`, `device_fingerprint`, `created_at`, `updated_at`)
VALUES
	(14,1,2,'created','Role',1,'Created Role: Smoke Role Co1',NULL,'2026-09-22 10:12:15','2026-09-22 10:12:15'),
	(15,2,2,'created','Role',2,'Created Role: Smoke Role Co2',NULL,'2026-09-22 10:12:15','2026-09-22 10:12:15'),
	(16,2,2,'deleted','Role',2,'Deleted Role: Smoke Role Co2',NULL,'2026-09-22 10:12:16','2026-09-22 10:12:16'),
	(17,1,2,'deleted','Role',1,'Deleted Role: Smoke Role Co1',NULL,'2026-09-22 10:12:16','2026-09-22 10:12:16'),
	(18,2,2,'deleted','Role',2,'Deleted Role: Smoke Role Co2',NULL,'2026-09-22 10:12:16','2026-09-22 10:12:16'),
	(19,1,2,'created','Role',3,'Created Role: For Copanu',NULL,'2026-09-22 10:27:54','2026-09-22 10:27:54'),
	(20,1,2,'updated','Role',3,'Updated Role: For Company',NULL,'2026-09-22 10:28:18','2026-09-22 10:28:18'),
	(21,2,2,'created','Role',4,'Created Role: For User',NULL,'2026-09-22 10:29:19','2026-09-22 10:29:19'),
	(22,1,NULL,'updated','Role',5,'Updated Role: Smoke Restricted',NULL,'2026-09-22 10:34:46','2026-09-22 10:34:46'),
	(23,1,NULL,'created','Training',2,'Created Training: Smoke Training',NULL,'2026-09-22 10:34:46','2026-09-22 10:34:46'),
	(24,1,NULL,'deleted','Training',2,'Deleted Training: Smoke Training',NULL,'2026-09-22 10:34:46','2026-09-22 10:34:46'),
	(25,1,2,'login','User',2,'Logged in from 203.0.113.42',NULL,'2026-09-22 13:13:31','2026-09-22 13:13:31'),
	(31,1,10,'login','User',10,'Logged in from 127.0.0.1',NULL,'2026-09-22 14:51:57','2026-09-22 14:51:57'),
	(32,1,10,'logout','User',10,'Logged out from 127.0.0.1',NULL,'2026-09-22 14:52:12','2026-09-22 14:52:12'),
	(33,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 14:52:18','2026-09-22 14:52:18'),
	(38,2,2,'created','Trainer',2,'Created Trainer: Jonisha Subedi',NULL,'2026-09-22 15:11:04','2026-09-22 15:11:04'),
	(39,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:11:25','2026-09-22 15:11:25'),
	(40,1,2,'updated','Student',5,'Updated Student: Activity Smoke 2 Updated',NULL,'2026-09-22 15:17:28','2026-09-22 15:17:28'),
	(41,1,2,'updated','Student',4,'Updated Student: Activity Smoke Updated',NULL,'2026-09-22 15:17:43','2026-09-22 15:17:43'),
	(42,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:21:30','2026-09-22 15:21:30'),
	(43,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:22:28','2026-09-22 15:22:28'),
	(44,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:26:14','2026-09-22 15:26:14'),
	(45,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:27:19','2026-09-22 15:27:19'),
	(46,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:28:07','2026-09-22 15:28:07'),
	(47,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:34:07','2026-09-22 15:34:07'),
	(48,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:34:42','2026-09-22 15:34:42'),
	(49,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:35:48','2026-09-22 15:35:48'),
	(50,1,2,'updated','Student',2,'Updated Student: Test Student',NULL,'2026-09-22 15:41:44','2026-09-22 15:41:44'),
	(51,2,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:47:49','2026-09-22 15:47:49'),
	(52,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:51:19','2026-09-22 15:51:19'),
	(53,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:52:28','2026-09-22 15:52:28'),
	(54,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:53:08','2026-09-22 15:53:08'),
	(55,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:54:30','2026-09-22 15:54:30'),
	(56,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:54:38','2026-09-22 15:54:38'),
	(57,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:55:12','2026-09-22 15:55:12'),
	(58,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:55:14','2026-09-22 15:55:14'),
	(59,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 15:55:39','2026-09-22 15:55:39'),
	(60,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 18:36:38','2026-09-22 18:36:38'),
	(61,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-22 18:36:46','2026-09-22 18:36:46'),
	(62,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-23 01:06:49','2026-09-23 01:06:49'),
	(63,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-23 01:07:12','2026-09-23 01:07:12'),
	(64,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-23 01:07:57','2026-09-23 01:07:57'),
	(65,1,2,'login','User',2,'Logged in from 127.0.0.1',NULL,'2026-09-23 01:08:10','2026-09-23 01:08:10'),
	(66,1,2,'login','User',2,'Logged in from 127.0.0.1 (new device)','1g0607m','2026-09-23 01:15:22','2026-09-23 01:15:22'),
	(67,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','1g0607m','2026-09-23 01:15:34','2026-09-23 01:15:34'),
	(68,1,2,'logout','User',2,'Logged out from 127.0.0.1',NULL,'2026-09-23 01:16:54','2026-09-23 01:16:54'),
	(69,1,2,'login','User',2,'Logged in from 127.0.0.1 (new device)','v9ig0y','2026-09-23 01:16:59','2026-09-23 01:16:59'),
	(70,1,2,'login','User',2,'Logged in from 127.0.0.1 (new device)','a4w6dk','2026-09-23 01:23:05','2026-09-23 01:23:05'),
	(71,1,2,'print_students','UI Action',NULL,'Printed the student records list',NULL,'2026-09-23 01:23:06','2026-09-23 01:23:06'),
	(72,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','a4w6dk','2026-09-23 01:23:27','2026-09-23 01:23:27'),
	(73,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','a4w6dk','2026-09-23 01:24:11','2026-09-23 01:24:11'),
	(74,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','a4w6dk','2026-09-23 01:24:59','2026-09-23 01:24:59'),
	(76,1,2,'create_student','UI Action',NULL,'Created student \"क्लिक-लग परीक्षण\"',NULL,'2026-09-23 01:25:00','2026-09-23 01:25:00'),
	(78,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','a4w6dk','2026-09-23 01:25:51','2026-09-23 01:25:51'),
	(80,1,2,'create_student','UI Action',NULL,'Created student \"क्लिक-लग परीक्षण\"',NULL,'2026-09-23 01:25:53','2026-09-23 01:25:53'),
	(82,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','a4w6dk','2026-09-23 01:26:11','2026-09-23 01:26:11'),
	(84,1,2,'create_student','UI Action',NULL,'Created student \"क्लिक-लग परीक्षण\"',NULL,'2026-09-23 01:26:12','2026-09-23 01:26:12'),
	(92,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','v9ig0y','2026-09-23 01:27:56','2026-09-23 01:27:56'),
	(93,1,2,'view_palika_details','UI Action',NULL,'Viewed palika details for \"Sundarhaicha\"',NULL,'2026-09-23 01:29:45','2026-09-23 01:29:45'),
	(94,1,2,'view_palika_details','UI Action',NULL,'Viewed palika details for \"Sundarhaicha\"',NULL,'2026-09-23 01:29:45','2026-09-23 01:29:45'),
	(95,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','1g0607m','2026-09-23 01:30:04','2026-09-23 01:30:04'),
	(96,1,2,'view_palika_details','UI Action',NULL,'Viewed palika details for \"Sundarhaicha\"',NULL,'2026-09-23 01:30:05','2026-09-23 01:30:05'),
	(97,1,2,'view_palika_details','UI Action',NULL,'Viewed palika details for \"Sundarhaicha\"',NULL,'2026-09-23 01:30:05','2026-09-23 01:30:05'),
	(98,1,2,'view_palika_details','UI Action',NULL,'Viewed palika details for \"Sundarhaicha\"',NULL,'2026-09-23 01:35:53','2026-09-23 01:35:53'),
	(99,1,2,'view_palika_details','UI Action',NULL,'Viewed palika details for \"Sundarhaicha\"',NULL,'2026-09-23 01:35:53','2026-09-23 01:35:53'),
	(100,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','v9ig0y','2026-09-23 02:08:15','2026-09-23 02:08:15'),
	(101,1,2,'view_palika_details','UI Action',NULL,'Viewed palika details for \"Sundarhaicha\"',NULL,'2026-09-23 02:11:26','2026-09-23 02:11:26'),
	(102,1,2,'view_palika_details','UI Action',NULL,'Viewed palika details for \"Sundarhaicha\"',NULL,'2026-09-23 02:11:26','2026-09-23 02:11:26'),
	(103,1,2,'login','User',2,'Logged in from 127.0.0.1 (new device)','bz60wy','2026-09-23 02:15:11','2026-09-23 02:15:11'),
	(105,1,2,'create_palika','UI Action',NULL,'Created palika \"बिलिङ्गुअल परीक्षण पालिका\"',NULL,'2026-09-23 02:15:14','2026-09-23 02:15:14'),
	(108,1,2,'login','User',2,'Logged in from 127.0.0.1 (known device)','bz60wy','2026-09-23 02:19:30','2026-09-23 02:19:30'),
	(109,1,2,'created','Palika',3,'Created Palika: Bhaktapur',NULL,'2026-09-23 02:19:32','2026-09-23 02:19:32'),
	(110,1,2,'create_palika','UI Action',NULL,'Created palika \"भक्तपुर\"',NULL,'2026-09-23 02:19:32','2026-09-23 02:19:32');

/*!40000 ALTER TABLE `activity_logs` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table cache
# ------------------------------------------------------------

DROP TABLE IF EXISTS `cache`;

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table cache_locks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `cache_locks`;

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table certificates
# ------------------------------------------------------------

DROP TABLE IF EXISTS `certificates`;

CREATE TABLE `certificates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `training_operation_id` bigint unsigned NOT NULL,
  `certificate_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `certificates_training_operation_id_unique` (`training_operation_id`),
  KEY `certificates_company_id_foreign` (`company_id`),
  KEY `certificates_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `certificates_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `certificates_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `certificates_training_operation_id_foreign` FOREIGN KEY (`training_operation_id`) REFERENCES `training_operations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `certificates` WRITE;
/*!40000 ALTER TABLE `certificates` DISABLE KEYS */;

INSERT INTO `certificates` (`id`, `company_id`, `training_operation_id`, `certificate_type`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(1,1,4,'तालिम सम्पन्न प्रमाणपत्र','2026-09-18 01:31:09','2026-09-18 12:17:13',NULL,NULL),
	(2,1,5,'योग्यता प्रमाणपत्र','2026-09-18 02:24:12','2026-09-18 02:24:12',NULL,NULL);

/*!40000 ALTER TABLE `certificates` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table companies
# ------------------------------------------------------------

DROP TABLE IF EXISTS `companies`;

CREATE TABLE `companies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name_np` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_np` text COLLATE utf8mb4_unicode_ci,
  `address_en` text COLLATE utf8mb4_unicode_ci,
  `registration_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pan_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `logo_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `companies_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `companies_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;

INSERT INTO `companies` (`id`, `name_np`, `name_en`, `address_np`, `address_en`, `registration_number`, `pan_number`, `status`, `logo_path`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(1,'इटिसी नेपाल','ETC Nepal','सुन्दरहरैँचा','Sundarhaciah',NULL,NULL,'active','logos/AaMlApVAgnvht2zOrFq9mUmSn4ty4b7qZbSnZAN6.jpg','2026-09-17 12:46:30','2026-09-17 12:46:30',NULL,NULL),
	(2,'Fucker','Fucker','Fucker','Fucker',NULL,NULL,'active',NULL,'2026-09-17 14:31:24','2026-09-17 14:31:24',NULL,NULL);

/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table company_user
# ------------------------------------------------------------

DROP TABLE IF EXISTS `company_user`;

CREATE TABLE `company_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `company_user_company_id_user_id_unique` (`company_id`,`user_id`),
  KEY `company_user_user_id_foreign` (`user_id`),
  KEY `company_user_role_id_foreign` (`role_id`),
  CONSTRAINT `company_user_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `company_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE SET NULL,
  CONSTRAINT `company_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `company_user` WRITE;
/*!40000 ALTER TABLE `company_user` DISABLE KEYS */;

INSERT INTO `company_user` (`id`, `company_id`, `user_id`, `role_id`, `created_at`, `updated_at`)
VALUES
	(1,1,2,NULL,'2026-09-17 12:46:30','2026-09-17 12:46:30'),
	(2,2,2,NULL,'2026-09-17 14:31:24','2026-09-17 14:31:24'),
	(11,2,6,NULL,'2026-09-22 09:55:26','2026-09-22 09:55:26'),
	(15,2,1,NULL,'2026-09-22 10:10:01','2026-09-22 10:10:01'),
	(18,1,10,3,'2026-09-22 10:30:50','2026-09-22 10:30:50');

/*!40000 ALTER TABLE `company_user` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table failed_jobs
# ------------------------------------------------------------

DROP TABLE IF EXISTS `failed_jobs`;

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(255) 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`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table fiscal_years
# ------------------------------------------------------------

DROP TABLE IF EXISTS `fiscal_years`;

CREATE TABLE `fiscal_years` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fiscal_years_company_id_foreign` (`company_id`),
  KEY `fiscal_years_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `fiscal_years_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fiscal_years_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `fiscal_years` WRITE;
/*!40000 ALTER TABLE `fiscal_years` DISABLE KEYS */;

INSERT INTO `fiscal_years` (`id`, `company_id`, `name`, `status`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(1,1,'२०८३।०८४','active','2026-09-17 12:47:29','2026-09-17 12:47:29',NULL,NULL);

/*!40000 ALTER TABLE `fiscal_years` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table job_batches
# ------------------------------------------------------------

DROP TABLE IF EXISTS `job_batches`;

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table jobs
# ------------------------------------------------------------

DROP TABLE IF EXISTS `jobs`;

CREATE TABLE `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` smallint 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table migrations
# ------------------------------------------------------------

DROP TABLE IF EXISTS `migrations`;

CREATE TABLE `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;

INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES
	(1,'0001_01_01_000000_create_users_table',1),
	(2,'0001_01_01_000001_create_cache_table',1),
	(3,'0001_01_01_000002_create_jobs_table',1),
	(4,'2026_09_16_054521_create_personal_access_tokens_table',1),
	(5,'2026_09_16_064713_create_companies_table',1),
	(6,'2026_09_16_065827_add_current_company_id_to_users_table',1),
	(7,'2026_09_16_065828_create_company_user_table',1),
	(8,'2026_09_16_074403_add_status_to_companies_table',1),
	(9,'2026_09_16_082633_create_fiscal_years_table',1),
	(10,'2026_09_16_083648_create_roles_table',1),
	(11,'2026_09_16_083649_add_role_id_to_company_user_table',1),
	(12,'2026_09_16_090156_create_palikas_table',1),
	(13,'2026_09_16_091906_create_trainings_table',1),
	(14,'2026_09_16_091907_create_training_signatories_table',1),
	(15,'2026_09_16_100525_add_bilingual_name_and_address_to_companies_table',1),
	(16,'2026_09_17_043513_create_students_table',1),
	(17,'2026_09_17_070928_add_gender_to_students_table',1),
	(18,'2026_09_17_071155_add_father_name_en_to_students_table',1),
	(19,'2026_09_17_123120_add_status_to_trainings_table',1),
	(20,'2026_09_17_123121_remove_extra_fields_from_trainings_table',1),
	(21,'2026_09_17_123122_drop_training_signatories_table',1),
	(22,'2026_09_17_123903_add_name_en_to_trainings_table',1),
	(23,'2026_09_17_125431_remove_training_id_add_contact_fields_to_students_table',1),
	(24,'2026_09_17_130608_change_contact_no_and_email_to_text_on_students_table',1),
	(25,'2026_09_17_132738_create_training_operations_table',1),
	(26,'2026_09_17_135544_convert_document_path_to_documents_on_training_operations_table',1),
	(27,'2026_09_17_140135_create_student_training_operation_table',2),
	(28,'2026_09_18_010240_add_status_to_training_operations_table',2),
	(29,'2026_09_18_010705_add_status_to_students_table',2),
	(30,'2026_09_18_012903_create_certificates_table',2),
	(31,'2026_09_22_081912_add_identity_fields_to_students_table',3),
	(32,'2026_09_22_082422_rework_citizenship_issue_date_on_students_table',4),
	(33,'2026_09_22_085308_add_family_and_ethnicity_fields_to_students_table',5),
	(34,'2026_09_22_085704_add_spouse_name_to_students_table',6),
	(35,'2026_09_22_090704_add_soft_deletes_to_core_tables',7),
	(36,'2026_09_22_090705_add_is_superadmin_to_users_table',7),
	(37,'2026_09_22_091933_add_deleted_by_to_core_tables',8),
	(38,'2026_09_22_091934_create_activity_logs_table',8),
	(39,'2026_09_22_122900_add_last_login_fields_to_users_table',9),
	(40,'2026_09_22_145841_create_trainers_table',10),
	(41,'2026_09_23_011328_add_device_fingerprint_to_users_table',11),
	(42,'2026_09_23_011329_add_device_fingerprint_to_activity_logs_table',11),
	(43,'2026_09_23_021258_add_address_hierarchy_to_palikas_table',12);

/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table palikas
# ------------------------------------------------------------

DROP TABLE IF EXISTS `palikas`;

CREATE TABLE `palikas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_np` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_np` text COLLATE utf8mb4_unicode_ci,
  `address_en` text COLLATE utf8mb4_unicode_ci,
  `province_np` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district_np` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `local_level_np` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `local_level_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ward_no` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nepal_logo_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `palika_logo_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `palikas_company_id_foreign` (`company_id`),
  KEY `palikas_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `palikas_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `palikas_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `palikas` WRITE;
/*!40000 ALTER TABLE `palikas` DISABLE KEYS */;

INSERT INTO `palikas` (`id`, `company_id`, `type`, `name_np`, `name_en`, `address_np`, `address_en`, `province_np`, `province_en`, `district_np`, `district_en`, `local_level_np`, `local_level_en`, `ward_no`, `nepal_logo_path`, `palika_logo_path`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(1,1,'नगरपालिका','सुन्दरहरैँचा','Sundarhaicha','सुन्दरहरैँचा','Sundarhaicha',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-09-17 12:47:56','2026-09-17 12:47:56',NULL,NULL);

/*!40000 ALTER TABLE `palikas` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table password_reset_tokens
# ------------------------------------------------------------

DROP TABLE IF EXISTS `password_reset_tokens`;

CREATE TABLE `password_reset_tokens` (
  `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 (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table personal_access_tokens
# ------------------------------------------------------------

DROP TABLE IF EXISTS `personal_access_tokens`;

CREATE TABLE `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` text 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`),
  KEY `personal_access_tokens_expires_at_index` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table roles
# ------------------------------------------------------------

DROP TABLE IF EXISTS `roles`;

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_company_id_name_unique` (`company_id`,`name`),
  KEY `roles_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `roles_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `roles_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;

INSERT INTO `roles` (`id`, `company_id`, `name`, `permissions`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(1,1,'Smoke Role Co1','[\"reports\"]','2026-09-22 10:12:16','2026-09-22 10:12:16',NULL,2),
	(2,2,'Smoke Role Co2','[]','2026-09-22 10:12:16','2026-09-22 10:12:16','2026-09-22 10:12:16',2),
	(3,1,'For Company','[\"training_details.add\", \"training_details.print\", \"training_details.filter\", \"training_details.view\", \"training_details.edit\", \"training_details.delete\", \"students.add\", \"students.print\", \"students.filter\", \"students.view\", \"students.edit\", \"students.delete\", \"training_operations.add\", \"training_operations.print\", \"training_operations.filter\", \"training_operations.view\", \"training_operations.edit\", \"training_operations.delete\", \"training_operations.students\", \"certificates.add\", \"certificates.filter\", \"certificates.print_all\", \"certificates.certificate\", \"certificates.edit\", \"certificates.delete\", \"settings_palika.add\", \"settings_palika.edit\", \"settings_palika.delete\"]','2026-09-22 10:27:54','2026-09-22 10:28:18',NULL,NULL),
	(4,2,'For User','[\"training_details.add\", \"training_details.print\", \"training_details.filter\", \"training_details.view\", \"training_details.edit\", \"training_details.delete\", \"students.add\", \"students.print\", \"students.filter\", \"students.view\", \"students.edit\", \"students.delete\", \"training_operations.add\", \"training_operations.print\", \"training_operations.filter\", \"training_operations.view\", \"training_operations.edit\", \"training_operations.delete\", \"training_operations.students\", \"certificates.add\", \"certificates.filter\", \"certificates.print_all\", \"certificates.certificate\", \"certificates.edit\", \"certificates.delete\", \"settings_fiscal_year.add\", \"settings_palika.add\", \"settings_palika.edit\", \"settings_palika.delete\"]','2026-09-22 10:29:19','2026-09-22 10:29:19',NULL,NULL);

/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sessions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sessions`;

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`)
VALUES
	('4hlTZlGQVl6LTANZJ6vVqwspo8z62SHIO5NcYlCV',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36','eyJfdG9rZW4iOiJLM2I0cnMyR3I5eHpHSG1zdkE2VEJhZXhGTWlZNkh3NnRMTWJPYUZ0IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdDo4MDAwXC9hcGlcL3VzZXIiLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1790129710),
	('E3LmLsNKV9osz88SKOZPCKQetN2XnTlvJoa8tZDh',2,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36','eyJfdG9rZW4iOiJPRnBocEcxQmVCQ3JLS2hOVU9yZEk2T0FmUktxWjBIWWZZT2tySEtlIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdDo4MDAwXC9hcGlcL3BhbGlrYXMiLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjIsInBhc3N3b3JkX2hhc2hfd2ViIjoiYjRmZDMxZjQ2MzJjZGMyZDI2NDUwYzUzNTVkYTE0ZTIzYThmNTM1MWEyMWZjOWI4NGQ4YTViYTNjZGJkMGU3MSJ9',1790129714),
	('LjXeDfIDQYyvXlHt6YCGhjREWkyg9kcoQXmsBDiM',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36','eyJfdG9rZW4iOiJBMlNjamZwT1VETmJxY3NlM0lFeTRkYnB1WE9wU2VicWpIRUlHOEtzIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdDo4MDAwXC9hcGlcL3VzZXIiLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1790129969),
	('Pm6T8F9MfjscPDOXtIj72STeYxRlpcAzrs98JGs3',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJvdDdkcThDVkJwS0pJQUNFeERRZGhXcktzdm5SSUVYY3VkWnc1ZjN3IiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1790130629),
	('v0oSh27Y35ZFZBHbffFKVTqu9tZ4hQoRVDs4EkqI',2,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36','eyJfdG9rZW4iOiJjUzlKYnRMbGxwcExvOXJmOUVFeUtBOHNvZDNsempRZGRiUzQ1ZHI5IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdDo4MDAwXC9hcGlcL3BhbGlrYXMiLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjIsInBhc3N3b3JkX2hhc2hfd2ViIjoiYjRmZDMxZjQ2MzJjZGMyZDI2NDUwYzUzNTVkYTE0ZTIzYThmNTM1MWEyMWZjOWI4NGQ4YTViYTNjZGJkMGU3MSJ9',1790129972),
	('yVdu515WhQnr2lbVq7xQQeGVBlIiWR2aCXSuLKLd',2,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiI4Y0RlbEZUc2h6aWhmQktPcGpBb2tUVm9LOHBXaXd1VHVyWGcyTU9SIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdDo4MDAwXC9hcGlcL3BhbGlrYXMiLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjIsInBhc3N3b3JkX2hhc2hfd2ViIjoiYjRmZDMxZjQ2MzJjZGMyZDI2NDUwYzUzNTVkYTE0ZTIzYThmNTM1MWEyMWZjOWI4NGQ4YTViYTNjZGJkMGU3MSJ9',1790129984);

/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table student_training_operation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `student_training_operation`;

CREATE TABLE `student_training_operation` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint unsigned NOT NULL,
  `training_operation_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `student_training_operation_unique` (`student_id`,`training_operation_id`),
  KEY `student_training_operation_training_operation_id_foreign` (`training_operation_id`),
  CONSTRAINT `student_training_operation_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE,
  CONSTRAINT `student_training_operation_training_operation_id_foreign` FOREIGN KEY (`training_operation_id`) REFERENCES `training_operations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `student_training_operation` WRITE;
/*!40000 ALTER TABLE `student_training_operation` DISABLE KEYS */;

INSERT INTO `student_training_operation` (`id`, `student_id`, `training_operation_id`, `created_at`, `updated_at`)
VALUES
	(2,1,5,'2026-09-17 14:15:31','2026-09-17 14:15:31'),
	(3,1,4,'2026-09-17 14:26:20','2026-09-17 14:26:20'),
	(4,1,8,'2026-09-18 01:21:00','2026-09-18 01:21:00'),
	(5,2,8,'2026-09-18 01:21:00','2026-09-18 01:21:00');

/*!40000 ALTER TABLE `student_training_operation` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table students
# ------------------------------------------------------------

DROP TABLE IF EXISTS `students`;

CREATE TABLE `students` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `name_np` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `father_name_np` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `father_name_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_name_np` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_name_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marital_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `spouse_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ethnicity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_no` text COLLATE utf8mb4_unicode_ci,
  `email` text COLLATE utf8mb4_unicode_ci,
  `citizenship_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `citizenship_issue_date_bs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `citizenship_issue_date_ad` date DEFAULT NULL,
  `citizenship_issue_district` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_id_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passport_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `local_level` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ward_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tole` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plus_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'सक्रिय',
  `photo_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birth_certificate_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `citizenship_certificate_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `students_company_id_foreign` (`company_id`),
  KEY `students_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `students_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `students_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `students` WRITE;
/*!40000 ALTER TABLE `students` DISABLE KEYS */;

INSERT INTO `students` (`id`, `company_id`, `name_np`, `name_en`, `father_name_np`, `father_name_en`, `mother_name_np`, `mother_name_en`, `marital_status`, `spouse_name`, `ethnicity`, `contact_no`, `email`, `citizenship_no`, `citizenship_issue_date_bs`, `citizenship_issue_date_ad`, `citizenship_issue_district`, `national_id_no`, `passport_no`, `gender`, `province`, `district`, `local_level`, `ward_no`, `tole`, `plus_code`, `status`, `photo_path`, `birth_certificate_path`, `citizenship_certificate_path`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(1,1,'कृष्ण न्यौपाने','Krishna Neupane','गोपाल प्रसाद नेउपाने','Gopal Prasad Neupane',NULL,NULL,NULL,NULL,NULL,'[\"9842402471\"]','[\"krishnane2030@gmail.com\"]',NULL,NULL,NULL,NULL,NULL,NULL,'पुरूष','कोशी प्रदेश','मोरङ','बेलबारी','2','लालभित्ती',NULL,'सक्रिय','students/qFugRtHIg3lgBzOH5CGAq46JRWSbdEMRkDa4iU7V.jpg',NULL,NULL,'2026-09-17 13:39:39','2026-09-18 01:14:01',NULL,NULL),
	(2,1,'टेस्ट विद्यार्थी','Test Student','बुबा',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'महिला',NULL,NULL,NULL,NULL,NULL,NULL,'सक्रिय',NULL,NULL,NULL,'2026-09-18 01:08:19','2026-09-22 15:41:44',NULL,NULL),
	(4,1,'टेस्ट','Activity Smoke Updated','बुवा',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'महिला',NULL,NULL,NULL,NULL,NULL,NULL,'सक्रिय',NULL,NULL,NULL,'2026-09-22 09:21:28','2026-09-22 15:17:43',NULL,2),
	(5,1,'टेस्ट','Activity Smoke 2 Updated','बुवा',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'पुरूष',NULL,NULL,NULL,NULL,NULL,NULL,'सक्रिय',NULL,NULL,NULL,'2026-09-22 09:22:27','2026-09-22 15:17:28',NULL,2);

/*!40000 ALTER TABLE `students` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table trainers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `trainers`;

CREATE TABLE `trainers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `name_np` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob_bs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob_ad` date DEFAULT NULL,
  `father_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marital_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `local_level` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ward_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tole` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `citizenship_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `citizenship_issue_district` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `citizenship_issue_date_bs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `citizenship_issue_date_ad` date DEFAULT NULL,
  `academic_qualification` text COLLATE utf8mb4_unicode_ci,
  `training_details_obtained` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'सक्रिय',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trainers_company_id_foreign` (`company_id`),
  KEY `trainers_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `trainers_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trainers_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `trainers` WRITE;
/*!40000 ALTER TABLE `trainers` DISABLE KEYS */;

INSERT INTO `trainers` (`id`, `company_id`, `name_np`, `name_en`, `gender`, `dob_bs`, `dob_ad`, `father_name`, `mother_name`, `contact_no`, `email`, `marital_status`, `province`, `district`, `local_level`, `ward_no`, `tole`, `citizenship_no`, `citizenship_issue_district`, `citizenship_issue_date_bs`, `citizenship_issue_date_ad`, `academic_qualification`, `training_details_obtained`, `status`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(2,2,'जोनिशा सुवेदी','Jonisha Subedi','महिला','2059/10/21','2003-02-04','जगतमणी सुवेदी','निर्मला सुवेदी','9819090978','subedijonisha105@gmail.com','विवाहित','कोशी प्रदेश','मोरङ','बेलबारी','2','लालभित्ती','05-01-70-00001','मोरङ','2079/06/05','2022-09-21',NULL,NULL,'सक्रिय','2026-09-22 15:11:04','2026-09-22 15:11:04',NULL,NULL);

/*!40000 ALTER TABLE `trainers` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table training_operations
# ------------------------------------------------------------

DROP TABLE IF EXISTS `training_operations`;

CREATE TABLE `training_operations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `fiscal_year_id` bigint unsigned DEFAULT NULL,
  `agreement_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreement_party` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date_bs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date_ad` date DEFAULT NULL,
  `end_date_bs` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_date_ad` date DEFAULT NULL,
  `agreement_committee` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreement_amount` decimal(15,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'सक्रिय',
  `documents` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `training_operations_company_id_foreign` (`company_id`),
  KEY `training_operations_fiscal_year_id_foreign` (`fiscal_year_id`),
  KEY `training_operations_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `training_operations_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `training_operations_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `training_operations_fiscal_year_id_foreign` FOREIGN KEY (`fiscal_year_id`) REFERENCES `fiscal_years` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `training_operations` WRITE;
/*!40000 ALTER TABLE `training_operations` DISABLE KEYS */;

INSERT INTO `training_operations` (`id`, `company_id`, `fiscal_year_id`, `agreement_date`, `agreement_party`, `training_name`, `start_date_bs`, `start_date_ad`, `end_date_bs`, `end_date_ad`, `agreement_committee`, `agreement_amount`, `status`, `documents`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(4,1,1,'2083/06/01','सुन्दरहरैँचा','६० दिने वेकरी तालिम','2083/06/05','2026-09-21','2083/07/18','2026-11-04',NULL,410112.14,'सक्रिय',NULL,'2026-09-17 13:53:21','2026-09-22 09:16:55','2026-09-22 09:16:55',NULL),
	(5,1,1,NULL,'सुन्दरहरैँचा','६० दिने वेकरी तालिम','2083/04/01','2026-07-17','2083/05/01','2026-08-17',NULL,NULL,'सक्रिय','[{\"name\": \"valid_small1.pdf\", \"path\": \"training-operations/MbMKsQqc1IOhJKhZWFafs0fMELuR4MVhW7pfaoCd.pdf\"}, {\"name\": \"valid_small2.pdf\", \"path\": \"training-operations/PWgGKOmYNMTy0N4e0Bl075c53eBdGLYJ0bOpbKpC.pdf\"}]','2026-09-17 13:58:36','2026-09-17 14:29:57',NULL,NULL),
	(7,1,1,NULL,'सुन्दरहरैँचा','६० दिने वेकरी तालिम',NULL,NULL,'२०८२/०१/०१',NULL,NULL,NULL,'सक्रिय',NULL,'2026-09-18 01:05:28','2026-09-18 01:05:28',NULL,NULL),
	(8,1,1,NULL,'सुन्दरहरैँचा','६० दिने वेकरी तालिम','2083/06/21','2026-10-07','2083/06/23','2026-10-09',NULL,0.00,'सक्रिय',NULL,'2026-09-18 01:20:39','2026-09-18 01:20:39',NULL,NULL);

/*!40000 ALTER TABLE `training_operations` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table trainings
# ------------------------------------------------------------

DROP TABLE IF EXISTS `trainings`;

CREATE TABLE `trainings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `batch_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'सक्रिय',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trainings_company_id_foreign` (`company_id`),
  KEY `trainings_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `trainings_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trainings_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `trainings` WRITE;
/*!40000 ALTER TABLE `trainings` DISABLE KEYS */;

INSERT INTO `trainings` (`id`, `company_id`, `batch_code`, `batch_name`, `name_en`, `status`, `created_at`, `updated_at`, `deleted_at`, `deleted_by`)
VALUES
	(1,1,'60 Bikari','६० दिने वेकरी तालिम','60 days Bakari training','सक्रिय','2026-09-17 12:48:23','2026-09-17 12:48:23',NULL,NULL);

/*!40000 ALTER TABLE `trainings` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `current_company_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_superadmin` tinyint(1) NOT NULL DEFAULT '0',
  `last_login_at` timestamp NULL DEFAULT NULL,
  `last_login_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login_user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login_device_fingerprint` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_current_company_id_foreign` (`current_company_id`),
  CONSTRAINT `users_current_company_id_foreign` FOREIGN KEY (`current_company_id`) REFERENCES `companies` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;

INSERT INTO `users` (`id`, `current_company_id`, `name`, `email`, `is_superadmin`, `last_login_at`, `last_login_ip`, `last_login_user_agent`, `last_login_device_fingerprint`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`)
VALUES
	(1,2,'Test User','test@example.com',0,NULL,NULL,NULL,NULL,'2026-09-17 12:17:44','$2y$12$MZVkWkku9PQkYjn5cqlLEeguO91dUnYnmWDhkUSLoGThTASYElL/m','LIXVWtjqEHpb1F9fgl1NTMvg2eLrk0t8KkOInySZq6P2jc5tlqsB2BpL0ITF','2026-09-17 12:17:45','2026-09-22 10:10:23'),
	(2,1,'Super Admin','superadmin@trainingmanagement.local',1,'2026-09-23 02:19:30','127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36','bz60wy',NULL,'$2y$12$3CZMoBp0w7iqkaTPVk/YbuCOTNMgUcy2v5N3iYctaAUFdApXjDsB2',NULL,'2026-09-17 12:21:11','2026-09-23 02:19:30'),
	(6,2,'Krishna Khana','krishnakhanal11@gmail.com',0,NULL,NULL,NULL,NULL,NULL,'$2y$12$6gtYZGM8oSFEjgOHHFMrzu7o02C4ZKRriKruklON5kmUHIjJYFeEi',NULL,'2026-09-22 09:55:26','2026-09-22 09:55:26'),
	(10,1,'Testing1','testing1@gmail.com',0,'2026-09-22 14:51:57','127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36',NULL,NULL,'$2y$12$Mjnr3NL1oEtTdEJYk5CgNeUlkuVHNY8WIhsOElb9fv6fwu4JLTZJ6',NULL,'2026-09-22 10:30:50','2026-09-22 14:51:57');

/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;
