-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.12.0.7122
-- --------------------------------------------------------



-- Dumping database structure for cms_db
CREATE DATABASE IF NOT EXISTS `cms_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `cms_db`;

-- Dumping structure for table cms_db.audit_logs
CREATE TABLE IF NOT EXISTS `audit_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `action` varchar(100) NOT NULL,
  `target_type` varchar(100) DEFAULT NULL,
  `target_id` int(11) DEFAULT NULL,
  `target_name` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_action` (`action`),
  KEY `idx_target_type` (`target_type`),
  KEY `idx_target_id` (`target_id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_audit_logs_user_action_created` (`user_id`,`action`,`created_at`),
  CONSTRAINT `audit_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `audit_logs_ibfk_2` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.audit_logs: ~11 rows (approximately)
INSERT IGNORE INTO `audit_logs` (`id`, `user_id`, `action`, `target_type`, `target_id`, `target_name`, `details`, `ip_address`, `user_agent`, `created_at`) VALUES
	(1, 2, 'USER_UPDATED', 'user', 2, 'Super Admin', 'name from "Admiral Sheikh Nazrul Islam" to "Super Admin"; ', NULL, NULL, '2025-10-07 11:41:54'),
	(2, 3, 'USER_UPDATED', 'user', 3, 'Admin', 'name from "Rear Admiral Mohammad Ali" to "Admin"; ', NULL, NULL, '2025-10-07 11:41:58'),
	(3, 4, 'USER_UPDATED', 'user', 4, 'Nave HQ', 'name from "User" to "Nave HQ"; ', NULL, NULL, '2025-10-09 19:51:36'),
	(4, 4, 'USER_UPDATED', 'user', 4, 'Nave HQ', 'email from "user@gmail.com" to "naveadmin@gmail.com"; ', NULL, NULL, '2025-10-09 19:52:32'),
	(5, 26, 'USER_UPDATED', 'user', 26, 'Commander Lisa Davis1111', 'name from "Commander Lisa Davis" to "Commander Lisa Davis1111"; ', NULL, NULL, '2025-10-10 11:41:06'),
	(6, 26, 'USER_UPDATED', 'user', 26, 'Commander Lisa Davis1111', 'phone from "+880211111123" to "+88021111112334343";', NULL, NULL, '2025-10-10 12:02:08'),
	(7, 4, 'USER_UPDATED', 'user', 4, 'NHQ Admin', 'name from "Nave HQ" to "NHQ Admin"; ', NULL, NULL, '2025-10-10 15:02:18'),
	(8, 4, 'USER_UPDATED', 'user', 4, 'NHQ Admin', 'phone from "01756265856" to "+8809654545";', NULL, NULL, '2025-10-10 15:02:33'),
	(9, 4, 'USER_UPDATED', 'user', 4, 'NHQ Admin', 'email from "naveadmin@gmail.com" to "nhqadmin@gmail.com"; ', NULL, NULL, '2025-10-10 15:02:37'),
	(10, 24, 'USER_UPDATED', 'user', 24, 'Captain John Smith', 'email from "john.smith@navy.mil" to "navy@gmail.com"; ', NULL, NULL, '2025-10-10 15:03:07'),
	(11, 24, 'USER_UPDATED', 'user', 24, 'User', 'name from "Captain John Smith" to "User"; ', NULL, NULL, '2025-10-10 15:03:36'),
	(12, 75, 'USER_UPDATED', 'user', 75, 'SO (Sig)1', 'name from "SO (Sig)" to "SO (Sig)1"; ', NULL, NULL, '2025-10-11 12:59:23'),
	(13, 92, 'USER_UPDATED', 'user', 92, 'ACNS (O)', 'name from "ACNS (O) 1" to "ACNS (O)"; ', NULL, NULL, '2025-10-11 13:00:56'),
	(14, 93, 'USER_UPDATED', 'user', 93, 'Coord to ACNS (O)', 'name from "Coord to ACNS (O) 1" to "Coord to ACNS (O)"; ', NULL, NULL, '2025-10-11 13:00:59');

-- Dumping structure for table cms_db.conversations
CREATE TABLE IF NOT EXISTS `conversations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('direct','group') NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_type` (`type`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_created_by` (`created_by`),
  KEY `idx_created_at` (`created_at`),
  CONSTRAINT `conversations_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `conversations_ibfk_2` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.conversations: ~2 rows (approximately)
INSERT IGNORE INTO `conversations` (`id`, `type`, `name`, `organization_id`, `created_by`, `created_at`, `updated_at`) VALUES
	(1, 'direct', NULL, 1, 2, '2025-10-10 11:19:08', '2025-10-10 11:19:08'),
	(2, 'direct', NULL, 1, 2, '2025-10-10 11:19:08', '2025-10-10 11:19:08');

-- Dumping structure for table cms_db.conversation_participants
CREATE TABLE IF NOT EXISTS `conversation_participants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `conversation_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `joined_at` timestamp NULL DEFAULT current_timestamp(),
  `last_read_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_participant` (`conversation_id`,`user_id`),
  KEY `idx_conversation_id` (`conversation_id`),
  KEY `idx_user_id` (`user_id`),
  CONSTRAINT `conversation_participants_ibfk_1` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `conversation_participants_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.conversation_participants: ~4 rows (approximately)
INSERT IGNORE INTO `conversation_participants` (`id`, `conversation_id`, `user_id`, `joined_at`, `last_read_at`) VALUES
	(1, 1, 2, '2025-10-10 11:19:08', NULL),
	(2, 1, 3, '2025-10-10 11:19:08', NULL),
	(3, 2, 2, '2025-10-10 11:19:08', NULL),
	(4, 2, 3, '2025-10-10 11:19:08', NULL);

-- Dumping structure for view cms_db.conversation_summary
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `conversation_summary` (
	`id` INT(11) NOT NULL,
	`type` ENUM('direct','group') NOT NULL COLLATE 'utf8mb4_general_ci',
	`name` VARCHAR(1) NULL COLLATE 'utf8mb4_general_ci',
	`participant_count` BIGINT(21) NOT NULL,
	`message_count` BIGINT(21) NOT NULL,
	`last_message_at` TIMESTAMP NULL,
	`created_at` TIMESTAMP NULL,
	`updated_at` TIMESTAMP NULL
);

-- Dumping structure for procedure cms_db.CreateDirectConversation
DELIMITER //
CREATE PROCEDURE `CreateDirectConversation`(
    IN p_user1_id INT,
    IN p_user2_id INT
)
BEGIN
    DECLARE v_conversation_id INT;
    DECLARE v_existing_conversation INT DEFAULT 0;

    -- Check if a conversation already exists between the two users
    SELECT COUNT(*) INTO v_existing_conversation
    FROM conversations c
    JOIN conversation_participants cp1 ON c.id = cp1.conversation_id
    JOIN conversation_participants cp2 ON c.id = cp2.conversation_id
    WHERE c.type = 'direct'
      AND ((cp1.user_id = p_user1_id AND cp2.user_id = p_user2_id)
        OR (cp1.user_id = p_user2_id AND cp2.user_id = p_user1_id));

    IF v_existing_conversation = 0 THEN
        -- Create a new direct conversation
        INSERT INTO conversations (type, created_by) VALUES ('direct', p_user1_id);
        SET v_conversation_id = LAST_INSERT_ID();

        -- Add both participants
        INSERT INTO conversation_participants (conversation_id, user_id)
        VALUES (v_conversation_id, p_user1_id),
               (v_conversation_id, p_user2_id);
    END IF;
END//
DELIMITER ;

-- Dumping structure for procedure cms_db.CreateUser
DELIMITER //
CREATE PROCEDURE `CreateUser`(
    IN p_name VARCHAR(255),
    IN p_rank_id INT,
    IN p_service_no VARCHAR(50),
    IN p_unit_id INT,
    IN p_department_id INT,
    IN p_role_id INT,
    IN p_designation_id INT,
    IN p_phone VARCHAR(20),
    IN p_mobile VARCHAR(20),
    IN p_alternative_mobile VARCHAR(20),
    IN p_email VARCHAR(255),
    IN p_password_hash VARCHAR(255)
)
BEGIN
    DECLARE EXIT HANDLER FOR SQLEXCEPTION
    BEGIN
        ROLLBACK;
        RESIGNAL;
    END;

    START TRANSACTION;

    INSERT INTO users (
        name, rank_id, service_no, unit_id, department_id,
        role_id, designation_id, phone, mobile, alternative_mobile, email, password_hash
    ) VALUES (
        p_name, p_rank_id, p_service_no, p_unit_id, p_department_id,
        p_role_id, p_designation_id, p_phone, p_mobile, p_alternative_mobile, p_email, p_password_hash
    );

    -- Log the user creation
    INSERT INTO audit_logs (user_id, action, target_type, target_name, details)
    VALUES (LAST_INSERT_ID(), 'USER_CREATED', 'user', p_name, 'User account created');

    COMMIT;
END//
DELIMITER ;

-- Dumping structure for table cms_db.departments
CREATE TABLE IF NOT EXISTS `departments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `parent_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT 1,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`),
  KEY `idx_is_active` (`is_active`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_parent_id` (`parent_id`),
  CONSTRAINT `departments_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL,
  CONSTRAINT `departments_ibfk_3` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- NOTE: unit_id removed from departments; omit legacy seed data
	(22, 'CNS Sectt', 1, 1, NULL, 1, NULL, 1, '2025-10-11 04:48:55', '2025-10-11 04:48:55'),
	(23, 'NS', 1, 1, NULL, 1, NULL, 1, '2025-10-11 04:49:22', '2025-10-11 04:49:22'),
	(24, 'Drafting Authority', 1, 1, NULL, 1, NULL, 1, '2025-10-11 04:49:42', '2025-10-11 04:49:42'),
	(25, 'JAG', 1, 1, NULL, 1, NULL, 1, '2025-10-11 04:49:51', '2025-10-11 04:49:51'),
	(26, 'Operations', 1, 1, NULL, 1, NULL, 1, '2025-10-11 04:50:02', '2025-10-11 04:50:02'),
	(27, 'Personnel', 1, 1, NULL, 1, NULL, 1, '2025-10-11 04:50:14', '2025-10-11 04:50:14'),
	(28, 'Material', 1, 1, NULL, 1, NULL, 1, '2025-10-11 04:50:26', '2025-10-11 04:50:26'),
	(29, 'Logistics', 1, 1, NULL, 1, NULL, 1, '2025-10-11 04:50:46', '2025-10-11 04:50:46'),
	(30, 'ACNS', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:26:57', '2025-10-11 05:26:57'),
	(31, 'DNO', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:31:14', '2025-10-11 05:31:14'),
	(32, 'DNI', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:31:30', '2025-10-11 05:31:30'),
	(33, 'DNP', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:31:45', '2025-10-11 05:31:45'),
	(34, 'D SIG', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:32:02', '2025-10-11 05:32:02'),
	(35, 'D Works', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:32:15', '2025-10-11 05:32:15'),
	(36, 'Naval Avn', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:32:29', '2025-10-11 05:32:29'),
	(37, 'D Hydro', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:32:45', '2025-10-11 05:32:45'),
	(38, 'D Sub', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:32:56', '2025-10-11 05:32:56'),
	(39, 'D Spl Ops', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:34:01', '2025-10-11 05:34:01'),
	(40, 'SD & Cer', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:34:24', '2025-10-11 05:34:24'),
	(41, 'Overseas Op', 1, 1, 26, 1, NULL, 1, '2025-10-11 05:34:48', '2025-10-11 05:34:48'),
	(43, 'ACNS', 1, 1, 27, 1, NULL, 1, '2025-10-11 09:34:11', '2025-10-11 11:46:56'),
	(44, 'DPS', 1, 1, 27, 1, NULL, 1, '2025-10-11 09:36:05', '2025-10-11 09:36:05'),
	(45, 'DNT', 1, 1, 27, NULL, NULL, 1, '2025-10-11 09:58:41', '2025-10-11 09:58:41'),
	(46, 'D Wel', 1, 1, 27, NULL, NULL, 1, '2025-10-11 10:00:14', '2025-10-11 10:00:14'),
	(47, 'DMS', 1, 1, 27, NULL, NULL, 1, '2025-10-11 10:01:17', '2025-10-11 10:01:17'),
	(48, 'D Edn', 1, 1, 27, NULL, NULL, 1, '2025-10-11 10:04:50', '2025-10-11 10:04:50'),
	(49, 'D Civ Pres', 1, 1, 27, NULL, NULL, 1, '2025-10-11 10:06:14', '2025-10-11 10:06:14'),
	(51, 'ACNS', 1, 1, 28, NULL, NULL, 1, '2025-10-11 10:15:22', '2025-10-11 11:46:27'),
	(53, 'DNO', 1, 1, 28, NULL, NULL, 1, '2025-10-11 10:16:55', '2025-10-11 11:46:37'),
	(55, 'DNI', 1, 1, 28, NULL, NULL, 1, '2025-10-11 10:22:05', '2025-10-11 11:46:42'),
	(56, 'DNP', 1, 1, 28, NULL, NULL, 1, '2025-10-11 10:24:04', '2025-10-11 11:46:48'),
	(58, 'D SIG', 1, 1, 28, NULL, NULL, 1, '2025-10-11 10:56:12', '2025-10-11 11:47:02'),
	(59, 'D Works', 1, 1, 28, NULL, NULL, 1, '2025-10-11 10:57:31', '2025-10-11 11:47:06'),
	(60, 'Naval Avn', 1, 1, 28, NULL, NULL, 1, '2025-10-11 10:58:32', '2025-10-11 11:47:09'),
	(61, 'D Hydro', 1, 1, 28, NULL, NULL, 1, '2025-10-11 10:59:27', '2025-10-11 11:47:11'),
	(62, 'D Sub', 1, 1, 28, NULL, NULL, 1, '2025-10-11 11:00:31', '2025-10-11 11:47:14'),
	(63, 'D Spl Ops', 1, 1, 28, NULL, NULL, 1, '2025-10-11 11:01:59', '2025-10-11 11:47:17'),
	(64, 'SD & Cer', 1, 1, 28, NULL, NULL, 1, '2025-10-11 11:03:15', '2025-10-11 11:47:21'),
	(66, 'Overseas Op', 1, 1, 28, NULL, NULL, 1, '2025-10-11 11:04:21', '2025-10-11 11:47:24'),
	(68, 'ACNS', 1, 1, 29, NULL, NULL, 1, '2025-10-11 11:31:16', '2025-10-11 11:47:27'),
	(69, 'DNO', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:34:15', '2025-10-11 12:34:15'),
	(70, 'DNI', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:37:54', '2025-10-11 12:37:54'),
	(71, 'DNP', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:38:50', '2025-10-11 12:38:50'),
	(72, 'D SIG', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:39:07', '2025-10-11 12:39:07'),
	(73, 'D Works', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:39:35', '2025-10-11 12:39:35'),
	(74, 'Naval Avn', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:39:51', '2025-10-11 12:39:51'),
	(75, 'D Hydro', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:40:08', '2025-10-11 12:40:08'),
	(76, 'D Sub', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:40:30', '2025-10-11 12:40:30'),
	(77, 'D Spl Ops', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:40:55', '2025-10-11 12:40:55'),
	(78, 'SD & Cer', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:41:18', '2025-10-11 12:41:18'),
	(79, 'Overseas Op', 1, 1, 29, NULL, NULL, 1, '2025-10-11 12:41:43', '2025-10-11 12:41:43');

-- Dumping structure for table cms_db.designations
CREATE TABLE IF NOT EXISTS `designations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `department_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT 1,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_department_parent` (`name`,`department_id`,`parent_id`),
  KEY `idx_name` (`name`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_department_id` (`department_id`),
  KEY `idx_parent_id` (`parent_id`),
  KEY `idx_is_active` (`is_active`),
  CONSTRAINT `designations_ibfk_1` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `designations_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `designations` (`id`) ON DELETE SET NULL,
  CONSTRAINT `designations_ibfk_3` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.designations: ~122 rows (approximately)
INSERT IGNORE INTO `designations` (`id`, `name`, `organization_id`, `department_id`, `parent_id`, `order_id`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
	(1, 'CNS', 1, 22, NULL, 1, NULL, 1, '2025-10-11 04:52:04', '2025-10-11 04:52:04'),
	(2, 'Secy to CNS', 1, 22, NULL, 1, NULL, 1, '2025-10-11 04:52:40', '2025-10-11 04:52:40'),
	(3, 'Asst Secy', 1, 22, NULL, 1, NULL, 1, '2025-10-11 04:53:09', '2025-10-11 04:53:09'),
	(4, 'Flag Lt', 1, 22, NULL, 1, NULL, 1, '2025-10-11 04:53:27', '2025-10-11 04:53:27'),
	(5, 'Protocol Offr', 1, 22, NULL, 1, NULL, 1, '2025-10-11 04:54:05', '2025-10-11 04:54:05'),
	(6, 'Escort Offr', 1, 22, NULL, 1, NULL, 1, '2025-10-11 04:54:24', '2025-10-11 04:54:24'),
	(7, 'NS', 1, 23, NULL, 1, NULL, 1, '2025-10-11 05:16:29', '2025-10-11 05:16:29'),
	(8, 'SONA-1', 1, 23, NULL, 1, NULL, 1, '2025-10-11 05:16:45', '2025-10-11 05:16:45'),
	(9, 'SONA-1 (Tec)', 1, 23, NULL, 1, NULL, 1, '2025-10-11 05:17:07', '2025-10-11 05:17:07'),
	(10, 'SONA-2', 1, 23, NULL, 1, NULL, 1, '2025-10-11 05:17:20', '2025-10-11 05:17:20'),
	(11, 'SONA-2 (Plans)', 1, 23, NULL, 1, NULL, 1, '2025-10-11 05:17:57', '2025-10-11 05:17:57'),
	(12, 'SO Tec', 1, 23, NULL, 1, NULL, 1, '2025-10-11 05:18:09', '2025-10-11 05:18:09'),
	(13, 'DA', 1, 24, NULL, 1, NULL, 1, '2025-10-11 05:18:35', '2025-10-11 05:18:35'),
	(14, 'DD Drafting', 1, 24, NULL, 1, NULL, 1, '2025-10-11 05:18:49', '2025-10-11 05:18:49'),
	(15, 'Sec Comd-1', 1, 24, NULL, 1, NULL, 1, '2025-10-11 05:19:11', '2025-10-11 05:19:11'),
	(16, 'Sec Comd-2', 1, 24, NULL, 1, NULL, 1, '2025-10-11 05:19:32', '2025-10-11 05:19:32'),
	(17, 'Sec Comd-3', 1, 24, NULL, 1, NULL, 1, '2025-10-11 05:19:59', '2025-10-11 05:19:59'),
	(18, 'JAG', 1, 25, NULL, 1, NULL, 1, '2025-10-11 05:23:40', '2025-10-11 05:23:40'),
	(19, 'DD JAG', 1, 25, NULL, 1, NULL, 1, '2025-10-11 05:23:54', '2025-10-11 05:23:54'),
	(20, 'SO (JAG)', 1, 25, NULL, 1, NULL, 1, '2025-10-11 05:24:08', '2025-10-11 05:24:08'),
	(21, 'ACNS (O)', 1, 30, NULL, 1, NULL, 1, '2025-10-11 05:27:42', '2025-10-11 05:27:42'),
	(22, 'Coord to ACNS (O)', 1, 30, NULL, 1, NULL, 1, '2025-10-11 05:30:00', '2025-10-11 05:30:00'),
	(23, 'DDNO', 1, 31, NULL, 1, NULL, 1, '2025-10-11 05:36:19', '2025-10-11 05:36:19'),
	(24, 'SO (O)', 1, 31, NULL, 1, NULL, 1, '2025-10-11 05:36:38', '2025-10-11 05:36:38'),
	(25, 'SO (Ops Plan)', 1, 31, NULL, 1, NULL, 1, '2025-10-11 05:37:08', '2025-10-11 05:37:08'),
	(26, 'DDNI', 1, 32, NULL, 1, NULL, 1, '2025-10-11 05:39:20', '2025-10-11 05:39:20'),
	(27, 'SO (l)', 1, 32, NULL, 1, NULL, 1, '2025-10-11 05:39:42', '2025-10-11 05:39:42'),
	(28, 'SO (Cl)', 1, 32, NULL, 1, NULL, 1, '2025-10-11 05:39:59', '2025-10-11 05:39:59'),
	(29, 'SO (Tec)', 1, 32, NULL, 1, NULL, 1, '2025-10-11 05:40:13', '2025-10-11 05:40:13'),
	(30, 'SO (Media)', 1, 32, NULL, 1, NULL, 1, '2025-10-11 05:40:31', '2025-10-11 05:40:31'),
	(31, 'DDNP', 1, 33, NULL, 1, NULL, 1, '2025-10-11 05:41:08', '2025-10-11 05:41:08'),
	(32, 'SO (Plan-1)', 1, 33, NULL, 1, NULL, 1, '2025-10-11 05:41:30', '2025-10-11 05:41:30'),
	(33, 'SO (Plans-2)', 1, 33, NULL, 1, NULL, 1, '2025-10-11 05:41:55', '2025-10-11 05:41:55'),
	(34, 'DD Sig', 1, 34, NULL, 1, NULL, 1, '2025-10-11 05:42:19', '2025-10-11 05:42:19'),
	(35, 'SO (Sig)', 1, 34, NULL, 1, NULL, 1, '2025-10-11 05:42:33', '2025-10-11 05:42:33'),
	(36, 'DD Works', 1, 35, NULL, 1, NULL, 1, '2025-10-11 05:43:06', '2025-10-11 05:43:06'),
	(37, 'SO (Works)', 1, 35, NULL, 1, NULL, 1, '2025-10-11 05:43:25', '2025-10-11 05:43:25'),
	(38, 'DD Nav', 1, 36, NULL, 1, NULL, 1, '2025-10-11 05:43:50', '2025-10-11 05:43:50'),
	(39, 'SO (Nav)', 1, 36, NULL, 1, NULL, 1, '2025-10-11 05:44:01', '2025-10-11 05:44:01'),
	(40, 'DD Hydro', 1, 37, NULL, 1, NULL, 1, '2025-10-11 05:45:04', '2025-10-11 05:45:04'),
	(41, 'SO (Hydro)', 1, 37, NULL, 1, NULL, 1, '2025-10-11 05:45:32', '2025-10-11 05:45:32'),
	(42, 'Capt Staff', 1, 38, NULL, 1, NULL, 1, '2025-10-11 05:46:28', '2025-10-11 05:46:28'),
	(43, 'DD Sub', 1, 38, NULL, 1, NULL, 1, '2025-10-11 05:46:37', '2025-10-11 05:46:37'),
	(44, 'DD Sub (Tec)', 1, 38, NULL, 1, NULL, 1, '2025-10-11 05:46:54', '2025-10-11 05:46:54'),
	(45, 'So (Sub)', 1, 38, NULL, 1, NULL, 1, '2025-10-11 05:47:17', '2025-10-11 05:47:17'),
	(46, 'DD Spl Ops', 1, 39, NULL, 1, NULL, 1, '2025-10-11 05:48:10', '2025-10-11 05:48:10'),
	(47, 'SO (Spl Ops)', 1, 39, NULL, 1, NULL, 1, '2025-10-11 05:48:44', '2025-10-11 05:48:44'),
	(48, 'DD SD & C', 1, 40, NULL, 1, NULL, 1, '2025-10-11 05:49:32', '2025-10-11 05:49:32'),
	(49, 'SO (SD & C)', 1, 40, NULL, 1, NULL, 1, '2025-10-11 05:49:48', '2025-10-11 05:49:48'),
	(50, 'DDONO', 1, 41, NULL, 1, NULL, 1, '2025-10-11 05:50:13', '2025-10-11 05:50:13'),
	(51, 'SO (ONO)', 1, 41, NULL, 1, NULL, 1, '2025-10-11 05:50:31', '2025-10-11 05:50:31'),
	(52, 'ACNS (O) 1', 1, 43, NULL, 1, NULL, 1, '2025-10-11 09:35:22', '2025-10-11 09:35:22'),
	(53, 'Coord to ACNS (O) 1', 1, 43, NULL, 1, NULL, 1, '2025-10-11 09:35:41', '2025-10-11 09:35:41'),
	(54, 'DDNPS', 1, 44, NULL, 1, NULL, 1, '2025-10-11 09:37:09', '2025-10-11 09:37:09'),
	(55, 'SO (Pers)', 1, 44, NULL, 1, NULL, 1, '2025-10-11 09:57:23', '2025-10-11 09:57:23'),
	(56, 'DDNT', 1, 45, NULL, 1, NULL, 1, '2025-10-11 09:59:06', '2025-10-11 09:59:06'),
	(57, 'SO (T-1)', 1, 45, NULL, 1, NULL, 1, '2025-10-11 09:59:27', '2025-10-11 09:59:27'),
	(58, 'SO (T-2)', 1, 45, NULL, 1, NULL, 1, '2025-10-11 09:59:47', '2025-10-11 09:59:47'),
	(59, 'SO', 1, 45, NULL, 1, NULL, 1, '2025-10-11 09:59:54', '2025-10-11 09:59:54'),
	(60, 'DD Wel', 1, 46, NULL, 1, NULL, 1, '2025-10-11 10:00:42', '2025-10-11 10:00:42'),
	(61, 'SO (Wel)', 1, 46, NULL, 1, NULL, 1, '2025-10-11 10:00:58', '2025-10-11 10:00:58'),
	(62, 'DDMS', 1, 47, NULL, 1, NULL, 1, '2025-10-11 10:04:14', '2025-10-11 10:04:14'),
	(63, 'SO', 1, 47, NULL, 1, NULL, 1, '2025-10-11 10:04:24', '2025-10-11 10:04:24'),
	(64, 'DD Edn', 1, 48, NULL, 1, NULL, 1, '2025-10-11 10:05:15', '2025-10-11 10:05:15'),
	(65, 'SO (Edn)', 1, 48, NULL, 1, NULL, 1, '2025-10-11 10:05:27', '2025-10-11 10:05:27'),
	(66, 'DD Nav', 1, 49, NULL, 1, NULL, 1, '2025-10-11 10:06:54', '2025-10-11 10:06:54'),
	(67, 'SO (Nav)', 1, 49, NULL, 1, NULL, 1, '2025-10-11 10:07:11', '2025-10-11 10:07:11'),
	(68, 'ACNS (O)', 1, 51, NULL, 1, NULL, 1, '2025-10-11 10:15:49', '2025-10-11 10:15:49'),
	(69, 'Coord to ACNS (O)', 1, 51, NULL, 1, NULL, 1, '2025-10-11 10:16:15', '2025-10-11 10:16:15'),
	(70, 'DDNO', 1, 53, NULL, 1, NULL, 1, '2025-10-11 10:20:49', '2025-10-11 10:20:49'),
	(71, 'SO (O)', 1, 53, NULL, 1, NULL, 1, '2025-10-11 10:21:05', '2025-10-11 10:21:05'),
	(72, 'SO (Ops Plan)', 1, 53, NULL, 1, NULL, 1, '2025-10-11 10:21:28', '2025-10-11 10:21:28'),
	(73, 'DDNI', 1, 55, NULL, 1, NULL, 1, '2025-10-11 10:22:24', '2025-10-11 10:22:24'),
	(74, 'SO (l)', 1, 55, NULL, 1, NULL, 1, '2025-10-11 10:22:43', '2025-10-11 10:22:43'),
	(75, 'SO (Cl)', 1, 55, NULL, 1, NULL, 1, '2025-10-11 10:22:59', '2025-10-11 10:22:59'),
	(76, 'SO (Tec)', 1, 55, NULL, 1, NULL, 1, '2025-10-11 10:23:11', '2025-10-11 10:23:11'),
	(77, 'SO (Media)', 1, 55, NULL, 1, NULL, 1, '2025-10-11 10:23:25', '2025-10-11 10:23:25'),
	(78, 'DDNP', 1, 56, NULL, 1, NULL, 1, '2025-10-11 10:24:21', '2025-10-11 10:24:21'),
	(79, 'SO (Plan-1)', 1, 56, NULL, 1, NULL, 1, '2025-10-11 10:24:42', '2025-10-11 10:24:42'),
	(80, 'SO (Plans-2)', 1, 56, NULL, 1, NULL, 1, '2025-10-11 10:24:59', '2025-10-11 10:24:59'),
	(81, 'DD Sig', 1, 58, NULL, 1, NULL, 1, '2025-10-11 10:56:52', '2025-10-11 10:56:52'),
	(82, 'SO (Sig)', 1, 58, NULL, 1, NULL, 1, '2025-10-11 10:57:09', '2025-10-11 10:57:09'),
	(83, 'DD Works', 1, 59, NULL, 1, NULL, 1, '2025-10-11 10:57:52', '2025-10-11 10:57:52'),
	(84, 'SO (Works)', 1, 59, NULL, 1, NULL, 1, '2025-10-11 10:58:10', '2025-10-11 10:58:10'),
	(85, 'DD Nav', 1, 60, NULL, 1, NULL, 1, '2025-10-11 10:58:55', '2025-10-11 10:58:55'),
	(86, 'SO (Nav)', 1, 60, NULL, 1, NULL, 1, '2025-10-11 10:59:08', '2025-10-11 10:59:08'),
	(87, 'DD Hydro', 1, 61, NULL, 1, NULL, 1, '2025-10-11 10:59:47', '2025-10-11 10:59:47'),
	(88, 'SO (Hydro)', 1, 61, NULL, 1, NULL, 1, '2025-10-11 11:00:02', '2025-10-11 11:00:02'),
	(89, 'Capt Staff', 1, 62, NULL, 1, NULL, 1, '2025-10-11 11:00:51', '2025-10-11 11:00:51'),
	(90, 'DD Sub', 1, 62, NULL, 1, NULL, 1, '2025-10-11 11:01:00', '2025-10-11 11:01:00'),
	(91, 'DD Sub (Tec)', 1, 62, NULL, 1, NULL, 1, '2025-10-11 11:01:19', '2025-10-11 11:01:19'),
	(92, 'So (Sub)', 1, 62, NULL, 1, NULL, 1, '2025-10-11 11:01:38', '2025-10-11 11:01:38'),
	(93, 'DD Spl Ops', 1, 63, NULL, 1, NULL, 1, '2025-10-11 11:02:28', '2025-10-11 11:02:28'),
	(94, 'SO (Spl Ops)', 1, 63, NULL, 1, NULL, 1, '2025-10-11 11:02:47', '2025-10-11 11:02:47'),
	(95, 'DD SD & C', 1, 64, NULL, 1, NULL, 1, '2025-10-11 11:03:35', '2025-10-11 11:03:35'),
	(96, 'SO (SD & C)', 1, 64, NULL, 1, NULL, 1, '2025-10-11 11:03:51', '2025-10-11 11:03:51'),
	(97, 'Overseas Op', 1, 66, NULL, 1, NULL, 1, '2025-10-11 11:04:38', '2025-10-11 11:04:38'),
	(98, 'ACNS (O)', 1, 68, NULL, 1, NULL, 1, '2025-10-11 12:14:46', '2025-10-11 12:14:46'),
	(99, 'Coord to ACNS (O)', 1, 68, NULL, 1, NULL, 1, '2025-10-11 12:24:18', '2025-10-11 12:24:18'),
	(100, 'DDNO', 1, 69, NULL, 1, NULL, 1, '2025-10-11 12:34:34', '2025-10-11 12:34:34'),
	(101, 'SO (O)', 1, 69, NULL, 1, NULL, 1, '2025-10-11 12:36:15', '2025-10-11 12:36:15'),
	(102, 'SO (Ops Plan)', 1, 69, NULL, 1, NULL, 1, '2025-10-11 12:36:43', '2025-10-11 12:36:43'),
	(103, 'DDNI', 1, 70, NULL, 1, NULL, 1, '2025-10-11 12:42:38', '2025-10-11 12:42:38'),
	(104, 'SO (I)', 1, 70, NULL, 1, NULL, 1, '2025-10-11 12:42:56', '2025-10-11 12:42:56'),
	(105, 'SO (Cl)', 1, 70, NULL, 1, NULL, 1, '2025-10-11 12:43:19', '2025-10-11 12:43:19'),
	(106, 'SO (Tec)', 1, 70, NULL, 1, NULL, 1, '2025-10-11 12:43:36', '2025-10-11 12:43:36'),
	(107, 'SO (Media)', 1, 70, NULL, 1, NULL, 1, '2025-10-11 12:43:54', '2025-10-11 12:43:54'),
	(108, 'DDNP', 1, 71, NULL, 1, NULL, 1, '2025-10-11 12:44:54', '2025-10-11 12:44:54'),
	(109, 'SO (Plan-1)', 1, 71, NULL, 1, NULL, 1, '2025-10-11 12:45:16', '2025-10-11 12:45:16'),
	(110, 'SO (Plans-2)', 1, 71, NULL, 1, NULL, 1, '2025-10-11 12:45:45', '2025-10-11 12:45:45'),
	(111, 'DD Sig', 1, 72, NULL, 1, NULL, 1, '2025-10-11 12:46:38', '2025-10-11 12:46:38'),
	(112, 'SO (Sig)', 1, 72, NULL, 1, NULL, 1, '2025-10-11 12:47:11', '2025-10-11 12:47:11'),
	(113, 'DD Works', 1, 73, NULL, 1, NULL, 1, '2025-10-11 12:47:52', '2025-10-11 12:47:52'),
	(114, 'SO (Works)', 1, 73, NULL, 1, NULL, 1, '2025-10-11 12:48:09', '2025-10-11 12:48:09'),
	(115, 'DD Nav', 1, 74, NULL, 1, NULL, 1, '2025-10-11 12:48:45', '2025-10-11 12:48:45'),
	(116, 'SO (Nav)', 1, 74, NULL, 1, NULL, 1, '2025-10-11 12:49:03', '2025-10-11 12:49:03'),
	(117, 'DD Hydro', 1, 75, NULL, 1, NULL, 1, '2025-10-11 12:49:38', '2025-10-11 12:49:38'),
	(118, 'SO (Hydro)', 1, 75, NULL, 1, NULL, 1, '2025-10-11 12:49:54', '2025-10-11 12:49:54'),
	(119, 'Capt Staff', 1, 76, NULL, 1, NULL, 1, '2025-10-11 12:50:32', '2025-10-11 12:50:32'),
	(120, 'DD Sub', 1, 76, NULL, 1, NULL, 1, '2025-10-11 12:50:43', '2025-10-11 12:50:43'),
	(121, 'DD Sub (Tec)', 1, 76, NULL, 1, NULL, 1, '2025-10-11 12:51:46', '2025-10-11 12:51:46'),
	(122, 'So (Sub)', 1, 76, NULL, 1, NULL, 1, '2025-10-11 12:52:08', '2025-10-11 12:52:08'),
	(123, 'DD Spl Ops', 1, 77, NULL, 1, NULL, 1, '2025-10-11 12:53:06', '2025-10-11 12:53:06'),
	(124, 'SO (Spl Ops)', 1, 77, NULL, 1, NULL, 1, '2025-10-11 12:53:34', '2025-10-11 12:53:34'),
	(125, 'DD SD & C', 1, 78, NULL, 1, NULL, 1, '2025-10-11 12:54:20', '2025-10-11 12:54:20'),
	(126, 'SO (SD & C)', 1, 78, NULL, 1, NULL, 1, '2025-10-11 12:54:48', '2025-10-11 12:54:48');

-- Dumping structure for table cms_db.feedback
CREATE TABLE IF NOT EXISTS `feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `rating` int(11) NOT NULL,
  `category` varchar(100) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `satisfaction` enum('Very Satisfied','Satisfied','Neutral','Dissatisfied','Very Dissatisfied') NOT NULL,
  `recommend` enum('Definitely','Probably','Not Sure','Probably Not','Definitely Not') NOT NULL,
  `improvements` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`improvements`)),
  `anonymous` tinyint(1) NOT NULL DEFAULT 0,
  `status` enum('pending','reviewed','resolved') NOT NULL DEFAULT 'pending',
  `reviewed_by` int(11) DEFAULT NULL,
  `reviewed_at` timestamp NULL DEFAULT NULL,
  `resolution_notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `reviewed_by` (`reviewed_by`),
  KEY `idx_email` (`email`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_rating` (`rating`),
  KEY `idx_category` (`category`),
  KEY `idx_status` (`status`),
  KEY `idx_anonymous` (`anonymous`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_feedback_status_created` (`status`,`created_at`),
  CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`reviewed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`),
  CHECK (`rating` >= 1 and `rating` <= 5)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.feedback: ~0 rows (approximately)

-- Dumping structure for procedure cms_db.LogUserActivity
DELIMITER //
CREATE PROCEDURE `LogUserActivity`(
    IN p_user_id INT,
    IN p_action VARCHAR(100),
    IN p_target_type VARCHAR(100),
    IN p_target_id INT,
    IN p_target_name VARCHAR(255),
    IN p_details TEXT,
    IN p_ip_address VARCHAR(45),
    IN p_user_agent TEXT
)
BEGIN
    INSERT INTO audit_logs (
        user_id, action, target_type, target_id, target_name,
        details, ip_address, user_agent
    ) VALUES (
        p_user_id, p_action, p_target_type, p_target_id, p_target_name,
        p_details, p_ip_address, p_user_agent
    );
END//
DELIMITER ;

-- Dumping structure for table cms_db.messages
CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `conversation_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `type` enum('text','system') NOT NULL DEFAULT 'text',
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_conversation_id` (`conversation_id`),
  KEY `idx_sender_id` (`sender_id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_is_read` (`is_read`),
  KEY `idx_messages_conversation_created` (`conversation_id`,`created_at`),
  CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.messages: ~0 rows (approximately)

-- Dumping structure for view cms_db.message_statistics
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `message_statistics` (
	`message_date` DATE NULL,
	`total_messages` BIGINT(21) NOT NULL,
	`text_messages` BIGINT(21) NOT NULL,
	`system_messages` BIGINT(21) NOT NULL,
	`unique_senders` BIGINT(21) NOT NULL
);

-- Dumping structure for table cms_db.notifications
CREATE TABLE IF NOT EXISTS `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `type` enum('info','warning','error','success') NOT NULL DEFAULT 'info',
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `action_url` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `read_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_type` (`type`),
  KEY `idx_is_read` (`is_read`),
  KEY `idx_created_at` (`created_at`),
  CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notifications_ibfk_2` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.notifications: ~0 rows (approximately)

-- Dumping structure for table cms_db.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `resource` varchar(100) NOT NULL,
  `action` varchar(50) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_permission` (`resource`,`action`),
  KEY `idx_name` (`name`),
  KEY `idx_resource` (`resource`),
  KEY `idx_action` (`action`),
  KEY `idx_is_active` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;



-- Dumping structure for table cms_db.ranks
CREATE TABLE IF NOT EXISTS `ranks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `level` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `idx_name` (`name`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_level` (`level`),
  KEY `idx_is_active` (`is_active`),
  CONSTRAINT `ranks_ibfk_1` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.ranks: ~17 rows (approximately)
INSERT IGNORE INTO `ranks` (`id`, `name`, `organization_id`, `level`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
	(1, 'Admiral', 1, 1, 'Highest naval rank', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(2, 'Vice Admiral', 1, 2, 'Senior flag officer', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(3, 'Rear Admiral', 1, 3, 'Flag officer', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(4, 'Commodore', 1, 4, 'Senior captain', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(5, 'Captain', 1, 5, 'Ship commanding officer', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(6, 'Commander', 1, 6, 'Senior officer', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(7, 'Lieutenant Commander', 1, 7, 'Mid-level officer', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(8, 'Lieutenant', 1, 8, 'Junior officer', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(9, 'Sub Lieutenant', 1, 9, 'Entry-level officer', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(10, 'Acting Sub Lieutenant', 1, 10, 'Probationary officer', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(11, 'Warrant Officer', 1, 11, 'Senior enlisted', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(12, 'Chief Petty Officer', 1, 12, 'Senior enlisted', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(13, 'Petty Officer', 1, 13, 'Mid-level enlisted', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(14, 'Leading Seaman', 1, 14, 'Junior enlisted', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(15, 'Able Seaman', 1, 15, 'Basic enlisted', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(16, 'Ordinary Seaman', 1, 16, 'Entry-level enlisted', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11'),
	(17, 'Major', 1, 6, 'Army equivalent rank', 1, '2025-10-10 11:40:11', '2025-10-10 11:40:11');

-- Dumping structure for table cms_db.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `description` text DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `idx_name` (`name`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_level` (`level`),
  KEY `idx_is_active` (`is_active`),
  CONSTRAINT `roles_ibfk_1` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.roles: ~6 rows (approximately)
INSERT IGNORE INTO `roles` (`id`, `name`, `organization_id`, `description`, `level`, `is_active`, `created_at`, `updated_at`) VALUES
	(1, 'Super Admin', 1, 'Super Administrator with full system access and control', 100, 1, '2025-10-09 17:22:14', '2025-10-10 05:20:18'),
	(2, 'Admin', 1, 'Administrator with elevated privileges and management access', 50, 1, '2025-10-09 17:22:14', '2025-10-09 17:22:14'),
	(3, 'User', 1, 'Manager with departmental oversight and user management', 30, 1, '2025-10-09 17:22:14', '2025-10-11 13:25:14'),
	(4, 'Officer', 1, 'Officer with operational access and reporting capabilities', 20, 1, '2025-10-09 17:22:14', '2025-10-09 17:22:14'),
	(5, 'Manager', 1, 'Regular user with standard access and basic permissions', 10, 1, '2025-10-09 17:22:14', '2025-10-10 15:04:40'),
	(6, 'Navy_admin', 1, 'Navy Admin', 50, 1, '2025-10-09 19:45:56', '2025-10-12 04:37:41');

-- Dumping structure for table cms_db.role_permissions
CREATE TABLE IF NOT EXISTS `role_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_role_permission` (`role_id`,`permission_id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_permission_id` (`permission_id`),
  CONSTRAINT `role_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_permissions_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2636 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.role_permissions: ~392 rows (approximately)
INSERT IGNORE INTO `role_permissions` (`id`, `role_id`, `permission_id`, `created_at`) VALUES
	(105, 2, 1, '2025-10-09 17:22:14'),
	(106, 2, 2, '2025-10-09 17:22:14'),
	(107, 2, 3, '2025-10-09 17:22:14'),
	(108, 2, 6, '2025-10-09 17:22:14'),
	(109, 2, 7, '2025-10-09 17:22:14'),
	(110, 2, 8, '2025-10-09 17:22:14'),
	(111, 2, 9, '2025-10-09 17:22:14'),
	(112, 2, 10, '2025-10-09 17:22:14'),
	(113, 2, 11, '2025-10-09 17:22:14'),
	(114, 2, 12, '2025-10-09 17:22:14'),
	(115, 2, 13, '2025-10-09 17:22:14'),
	(116, 2, 14, '2025-10-09 17:22:14'),
	(117, 2, 15, '2025-10-09 17:22:14'),
	(118, 2, 16, '2025-10-09 17:22:14'),
	(119, 2, 17, '2025-10-09 17:22:14'),
	(120, 2, 18, '2025-10-09 17:22:14'),
	(121, 2, 19, '2025-10-09 17:22:14'),
	(122, 2, 20, '2025-10-09 17:22:14'),
	(123, 2, 21, '2025-10-09 17:22:14'),
	(124, 2, 22, '2025-10-09 17:22:14'),
	(125, 2, 23, '2025-10-09 17:22:14'),
	(126, 2, 24, '2025-10-09 17:22:14'),
	(127, 2, 25, '2025-10-09 17:22:14'),
	(128, 2, 26, '2025-10-09 17:22:14'),
	(129, 2, 27, '2025-10-09 17:22:14'),
	(130, 2, 28, '2025-10-09 17:22:14'),
	(131, 2, 29, '2025-10-09 17:22:14'),
	(132, 2, 30, '2025-10-09 17:22:14'),
	(133, 2, 31, '2025-10-09 17:22:14'),
	(134, 2, 32, '2025-10-09 17:22:14'),
	(135, 2, 33, '2025-10-09 17:22:14'),
	(136, 2, 34, '2025-10-09 17:22:14'),
	(137, 2, 35, '2025-10-09 17:22:14'),
	(138, 2, 36, '2025-10-09 17:22:14'),
	(139, 2, 37, '2025-10-09 17:22:14'),
	(140, 2, 38, '2025-10-09 17:22:14'),
	(141, 2, 39, '2025-10-09 17:22:14'),
	(142, 2, 40, '2025-10-09 17:22:14'),
	(143, 2, 41, '2025-10-09 17:22:14'),
	(144, 2, 42, '2025-10-09 17:22:14'),
	(145, 2, 43, '2025-10-09 17:22:14'),
	(146, 2, 44, '2025-10-09 17:22:14'),
	(147, 2, 45, '2025-10-09 17:22:14'),
	(148, 2, 46, '2025-10-09 17:22:14'),
	(149, 2, 47, '2025-10-09 17:22:14'),
	(150, 2, 48, '2025-10-09 17:22:14'),
	(151, 2, 49, '2025-10-09 17:22:14'),
	(152, 2, 50, '2025-10-09 17:22:14'),
	(153, 2, 52, '2025-10-09 17:22:14'),
	(154, 2, 53, '2025-10-09 17:22:14'),
	(155, 2, 57, '2025-10-09 17:22:14'),
	(156, 2, 58, '2025-10-09 17:22:14'),
	(157, 2, 59, '2025-10-09 17:22:14'),
	(158, 2, 60, '2025-10-09 17:22:14'),
	(159, 2, 61, '2025-10-09 17:22:14'),
	(160, 2, 62, '2025-10-09 17:22:14'),
	(161, 2, 63, '2025-10-09 17:22:14'),
	(162, 2, 64, '2025-10-09 17:22:14'),
	(163, 2, 65, '2025-10-09 17:22:14'),
	(164, 2, 66, '2025-10-09 17:22:14'),
	(165, 2, 67, '2025-10-09 17:22:14'),
	(166, 2, 68, '2025-10-09 17:22:14'),
	(167, 2, 69, '2025-10-09 17:22:14'),
	(168, 2, 70, '2025-10-09 17:22:14'),
	(169, 2, 71, '2025-10-09 17:22:14'),
	(170, 2, 72, '2025-10-09 17:22:14'),
	(171, 2, 73, '2025-10-09 17:22:14'),
	(172, 2, 75, '2025-10-09 17:22:14'),
	(173, 2, 76, '2025-10-09 17:22:14'),
	(174, 2, 78, '2025-10-09 17:22:14'),
	(175, 2, 80, '2025-10-09 17:22:14'),
	(176, 2, 81, '2025-10-09 17:22:14'),
	(177, 2, 83, '2025-10-09 17:22:14'),
	(178, 2, 84, '2025-10-09 17:22:14'),
	(179, 2, 85, '2025-10-09 17:22:14'),
	(180, 2, 86, '2025-10-09 17:22:14'),
	(181, 2, 87, '2025-10-09 17:22:14'),
	(182, 2, 88, '2025-10-09 17:22:14'),
	(183, 2, 89, '2025-10-09 17:22:14'),
	(184, 2, 90, '2025-10-09 17:22:14'),
	(185, 2, 91, '2025-10-09 17:22:14'),
	(186, 2, 92, '2025-10-09 17:22:14'),
	(187, 2, 93, '2025-10-09 17:22:14'),
	(188, 2, 94, '2025-10-09 17:22:14'),
	(189, 2, 95, '2025-10-09 17:22:14'),
	(190, 2, 96, '2025-10-09 17:22:14'),
	(191, 2, 97, '2025-10-09 17:22:14'),
	(192, 2, 98, '2025-10-09 17:22:14'),
	(193, 2, 99, '2025-10-09 17:22:14'),
	(194, 2, 100, '2025-10-09 17:22:14'),
	(195, 2, 101, '2025-10-09 17:22:14'),
	(196, 2, 102, '2025-10-09 17:22:14'),
	(197, 2, 103, '2025-10-09 17:22:14'),
	(198, 2, 104, '2025-10-09 17:22:14'),
	(268, 4, 2, '2025-10-09 17:22:14'),
	(269, 4, 9, '2025-10-09 17:22:14'),
	(270, 4, 13, '2025-10-09 17:22:14'),
	(271, 4, 17, '2025-10-09 17:22:14'),
	(272, 4, 21, '2025-10-09 17:22:14'),
	(273, 4, 25, '2025-10-09 17:22:14'),
	(274, 4, 26, '2025-10-09 17:22:14'),
	(275, 4, 30, '2025-10-09 17:22:14'),
	(276, 4, 31, '2025-10-09 17:22:14'),
	(277, 4, 32, '2025-10-09 17:22:14'),
	(278, 4, 33, '2025-10-09 17:22:14'),
	(279, 4, 35, '2025-10-09 17:22:14'),
	(280, 4, 36, '2025-10-09 17:22:14'),
	(281, 4, 37, '2025-10-09 17:22:14'),
	(282, 4, 41, '2025-10-09 17:22:14'),
	(283, 4, 42, '2025-10-09 17:22:14'),
	(284, 4, 45, '2025-10-09 17:22:14'),
	(285, 4, 46, '2025-10-09 17:22:14'),
	(286, 4, 47, '2025-10-09 17:22:14'),
	(287, 4, 57, '2025-10-09 17:22:14'),
	(288, 4, 58, '2025-10-09 17:22:14'),
	(289, 4, 61, '2025-10-09 17:22:14'),
	(290, 4, 62, '2025-10-09 17:22:14'),
	(291, 4, 65, '2025-10-09 17:22:14'),
	(292, 4, 66, '2025-10-09 17:22:14'),
	(293, 4, 67, '2025-10-09 17:22:14'),
	(294, 4, 68, '2025-10-09 17:22:14'),
	(295, 4, 69, '2025-10-09 17:22:14'),
	(296, 4, 70, '2025-10-09 17:22:14'),
	(297, 4, 71, '2025-10-09 17:22:14'),
	(298, 4, 72, '2025-10-09 17:22:14'),
	(299, 4, 73, '2025-10-09 17:22:14'),
	(300, 4, 86, '2025-10-09 17:22:14'),
	(301, 4, 87, '2025-10-09 17:22:14'),
	(302, 4, 88, '2025-10-09 17:22:14'),
	(303, 4, 90, '2025-10-09 17:22:14'),
	(304, 4, 91, '2025-10-09 17:22:14'),
	(305, 4, 93, '2025-10-09 17:22:14'),
	(306, 4, 94, '2025-10-09 17:22:14'),
	(307, 4, 96, '2025-10-09 17:22:14'),
	(308, 4, 97, '2025-10-09 17:22:14'),
	(309, 4, 99, '2025-10-09 17:22:14'),
	(310, 4, 100, '2025-10-09 17:22:14'),
	(311, 4, 101, '2025-10-09 17:22:14'),
	(312, 5, 2, '2025-10-09 17:22:14'),
	(313, 5, 9, '2025-10-09 17:22:14'),
	(314, 5, 13, '2025-10-09 17:22:14'),
	(315, 5, 17, '2025-10-09 17:22:14'),
	(316, 5, 21, '2025-10-09 17:22:14'),
	(317, 5, 25, '2025-10-09 17:22:14'),
	(318, 5, 30, '2025-10-09 17:22:14'),
	(319, 5, 31, '2025-10-09 17:22:14'),
	(320, 5, 32, '2025-10-09 17:22:14'),
	(321, 5, 33, '2025-10-09 17:22:14'),
	(322, 5, 35, '2025-10-09 17:22:14'),
	(323, 5, 36, '2025-10-09 17:22:14'),
	(324, 5, 37, '2025-10-09 17:22:14'),
	(325, 5, 41, '2025-10-09 17:22:14'),
	(326, 5, 42, '2025-10-09 17:22:14'),
	(327, 5, 45, '2025-10-09 17:22:14'),
	(328, 5, 46, '2025-10-09 17:22:14'),
	(329, 5, 57, '2025-10-09 17:22:15'),
	(330, 5, 61, '2025-10-09 17:22:15'),
	(331, 5, 62, '2025-10-09 17:22:15'),
	(332, 5, 65, '2025-10-09 17:22:15'),
	(333, 5, 66, '2025-10-09 17:22:15'),
	(334, 5, 67, '2025-10-09 17:22:15'),
	(335, 5, 68, '2025-10-09 17:22:15'),
	(336, 5, 69, '2025-10-09 17:22:15'),
	(337, 5, 70, '2025-10-09 17:22:15'),
	(338, 5, 71, '2025-10-09 17:22:15'),
	(339, 5, 72, '2025-10-09 17:22:15'),
	(340, 5, 73, '2025-10-09 17:22:15'),
	(341, 5, 86, '2025-10-09 17:22:15'),
	(342, 5, 87, '2025-10-09 17:22:15'),
	(343, 5, 90, '2025-10-09 17:22:15'),
	(344, 5, 93, '2025-10-09 17:22:15'),
	(345, 5, 94, '2025-10-09 17:22:15'),
	(346, 5, 96, '2025-10-09 17:22:15'),
	(347, 5, 97, '2025-10-09 17:22:15'),
	(348, 5, 99, '2025-10-09 17:22:15'),
	(349, 5, 100, '2025-10-09 17:22:15'),
	(350, 5, 101, '2025-10-09 17:22:15'),
	(364, 2, 110, '2025-10-09 18:35:05'),
	(365, 2, 115, '2025-10-09 18:35:05'),
	(366, 2, 116, '2025-10-09 18:35:05'),
	(367, 2, 117, '2025-10-09 18:35:05'),
	(368, 2, 118, '2025-10-09 18:35:05'),
	(2224, 1, 1, '2025-10-10 05:20:18'),
	(2225, 1, 2, '2025-10-10 05:20:18'),
	(2226, 1, 3, '2025-10-10 05:20:18'),
	(2227, 1, 4, '2025-10-10 05:20:18'),
	(2228, 1, 5, '2025-10-10 05:20:18'),
	(2229, 1, 6, '2025-10-10 05:20:18'),
	(2230, 1, 7, '2025-10-10 05:20:18'),
	(2231, 1, 8, '2025-10-10 05:20:18'),
	(2232, 1, 9, '2025-10-10 05:20:18'),
	(2233, 1, 10, '2025-10-10 05:20:18'),
	(2234, 1, 11, '2025-10-10 05:20:18'),
	(2235, 1, 12, '2025-10-10 05:20:18'),
	(2236, 1, 13, '2025-10-10 05:20:18'),
	(2237, 1, 14, '2025-10-10 05:20:18'),
	(2238, 1, 15, '2025-10-10 05:20:18'),
	(2239, 1, 16, '2025-10-10 05:20:18'),
	(2240, 1, 17, '2025-10-10 05:20:18'),
	(2241, 1, 18, '2025-10-10 05:20:18'),
	(2242, 1, 19, '2025-10-10 05:20:18'),
	(2243, 1, 20, '2025-10-10 05:20:18'),
	(2244, 1, 21, '2025-10-10 05:20:18'),
	(2245, 1, 22, '2025-10-10 05:20:18'),
	(2246, 1, 23, '2025-10-10 05:20:18'),
	(2247, 1, 24, '2025-10-10 05:20:18'),
	(2248, 1, 25, '2025-10-10 05:20:18'),
	(2249, 1, 26, '2025-10-10 05:20:18'),
	(2250, 1, 27, '2025-10-10 05:20:18'),
	(2251, 1, 28, '2025-10-10 05:20:18'),
	(2252, 1, 29, '2025-10-10 05:20:18'),
	(2253, 1, 30, '2025-10-10 05:20:18'),
	(2254, 1, 31, '2025-10-10 05:20:18'),
	(2255, 1, 32, '2025-10-10 05:20:18'),
	(2256, 1, 33, '2025-10-10 05:20:18'),
	(2257, 1, 34, '2025-10-10 05:20:18'),
	(2258, 1, 35, '2025-10-10 05:20:18'),
	(2259, 1, 36, '2025-10-10 05:20:18'),
	(2260, 1, 37, '2025-10-10 05:20:18'),
	(2261, 1, 38, '2025-10-10 05:20:18'),
	(2262, 1, 39, '2025-10-10 05:20:18'),
	(2263, 1, 40, '2025-10-10 05:20:18'),
	(2264, 1, 41, '2025-10-10 05:20:18'),
	(2265, 1, 42, '2025-10-10 05:20:18'),
	(2266, 1, 43, '2025-10-10 05:20:18'),
	(2267, 1, 44, '2025-10-10 05:20:18'),
	(2268, 1, 45, '2025-10-10 05:20:18'),
	(2269, 1, 46, '2025-10-10 05:20:18'),
	(2270, 1, 47, '2025-10-10 05:20:18'),
	(2271, 1, 48, '2025-10-10 05:20:18'),
	(2272, 1, 49, '2025-10-10 05:20:18'),
	(2273, 1, 50, '2025-10-10 05:20:18'),
	(2274, 1, 51, '2025-10-10 05:20:18'),
	(2275, 1, 52, '2025-10-10 05:20:18'),
	(2276, 1, 53, '2025-10-10 05:20:18'),
	(2277, 1, 54, '2025-10-10 05:20:18'),
	(2278, 1, 55, '2025-10-10 05:20:18'),
	(2279, 1, 56, '2025-10-10 05:20:18'),
	(2280, 1, 57, '2025-10-10 05:20:18'),
	(2281, 1, 58, '2025-10-10 05:20:18'),
	(2282, 1, 59, '2025-10-10 05:20:18'),
	(2283, 1, 60, '2025-10-10 05:20:18'),
	(2284, 1, 61, '2025-10-10 05:20:18'),
	(2285, 1, 62, '2025-10-10 05:20:18'),
	(2286, 1, 63, '2025-10-10 05:20:18'),
	(2287, 1, 83, '2025-10-10 05:20:18'),
	(2288, 1, 85, '2025-10-10 05:20:18'),
	(2289, 1, 84, '2025-10-10 05:20:18'),
	(2348, 1, 74, '2025-10-10 06:19:03'),
	(2349, 1, 76, '2025-10-10 06:19:03'),
	(2350, 1, 77, '2025-10-10 06:19:03'),
	(2351, 1, 75, '2025-10-10 06:19:03'),
	(2536, 3, 24, '2025-10-11 13:25:14'),
	(2537, 3, 25, '2025-10-11 13:25:15'),
	(2538, 3, 65, '2025-10-11 13:25:15'),
	(2539, 3, 66, '2025-10-11 13:25:15'),
	(2540, 3, 67, '2025-10-11 13:25:15'),
	(2541, 3, 86, '2025-10-11 13:25:15'),
	(2542, 3, 87, '2025-10-11 13:25:15'),
	(2543, 3, 88, '2025-10-11 13:25:15'),
	(2544, 3, 89, '2025-10-11 13:25:15'),
	(2545, 3, 99, '2025-10-11 13:25:15'),
	(2546, 3, 100, '2025-10-11 13:25:15'),
	(2547, 3, 101, '2025-10-11 13:25:15'),
	(2548, 3, 130, '2025-10-11 13:25:15'),
	(2549, 3, 135, '2025-10-11 13:25:15'),
	(2550, 3, 136, '2025-10-11 13:25:15'),
	(2551, 3, 137, '2025-10-11 13:25:15'),
	(2552, 3, 138, '2025-10-11 13:25:15'),
	(2553, 3, 139, '2025-10-11 13:25:15'),
	(2554, 3, 140, '2025-10-11 13:25:15'),
	(2555, 3, 141, '2025-10-11 13:25:15'),
	(2556, 3, 142, '2025-10-11 13:25:15'),
	(2557, 3, 143, '2025-10-11 13:25:15'),
	(2558, 3, 144, '2025-10-11 13:25:15'),
	(2559, 3, 145, '2025-10-11 13:25:15'),
	(2560, 3, 146, '2025-10-11 13:25:15'),
	(2561, 3, 147, '2025-10-11 13:25:15'),
	(2562, 3, 148, '2025-10-11 13:25:15'),
	(2563, 3, 9, '2025-10-11 13:25:15'),
	(2564, 6, 1, '2025-10-12 04:37:41'),
	(2565, 6, 2, '2025-10-12 04:37:41'),
	(2566, 6, 3, '2025-10-12 04:37:41'),
	(2567, 6, 4, '2025-10-12 04:37:41'),
	(2568, 6, 5, '2025-10-12 04:37:41'),
	(2569, 6, 6, '2025-10-12 04:37:41'),
	(2570, 6, 7, '2025-10-12 04:37:41'),
	(2571, 6, 8, '2025-10-12 04:37:41'),
	(2572, 6, 9, '2025-10-12 04:37:41'),
	(2573, 6, 10, '2025-10-12 04:37:41'),
	(2574, 6, 11, '2025-10-12 04:37:41'),
	(2575, 6, 12, '2025-10-12 04:37:41'),
	(2576, 6, 13, '2025-10-12 04:37:41'),
	(2577, 6, 14, '2025-10-12 04:37:41'),
	(2578, 6, 15, '2025-10-12 04:37:41'),
	(2579, 6, 16, '2025-10-12 04:37:41'),
	(2580, 6, 17, '2025-10-12 04:37:41'),
	(2581, 6, 18, '2025-10-12 04:37:41'),
	(2582, 6, 19, '2025-10-12 04:37:41'),
	(2583, 6, 20, '2025-10-12 04:37:41'),
	(2584, 6, 21, '2025-10-12 04:37:41'),
	(2585, 6, 22, '2025-10-12 04:37:41'),
	(2586, 6, 23, '2025-10-12 04:37:41'),
	(2587, 6, 24, '2025-10-12 04:37:41'),
	(2588, 6, 25, '2025-10-12 04:37:41'),
	(2589, 6, 26, '2025-10-12 04:37:41'),
	(2590, 6, 27, '2025-10-12 04:37:41'),
	(2591, 6, 28, '2025-10-12 04:37:41'),
	(2592, 6, 29, '2025-10-12 04:37:41'),
	(2593, 6, 50, '2025-10-12 04:37:41'),
	(2594, 6, 51, '2025-10-12 04:37:41'),
	(2595, 6, 52, '2025-10-12 04:37:41'),
	(2596, 6, 57, '2025-10-12 04:37:41'),
	(2597, 6, 61, '2025-10-12 04:37:41'),
	(2598, 6, 62, '2025-10-12 04:37:41'),
	(2599, 6, 63, '2025-10-12 04:37:41'),
	(2600, 6, 64, '2025-10-12 04:37:41'),
	(2601, 6, 65, '2025-10-12 04:37:41'),
	(2602, 6, 66, '2025-10-12 04:37:41'),
	(2603, 6, 67, '2025-10-12 04:37:41'),
	(2604, 6, 83, '2025-10-12 04:37:41'),
	(2605, 6, 84, '2025-10-12 04:37:41'),
	(2606, 6, 85, '2025-10-12 04:37:41'),
	(2607, 6, 86, '2025-10-12 04:37:41'),
	(2608, 6, 87, '2025-10-12 04:37:41'),
	(2609, 6, 88, '2025-10-12 04:37:41'),
	(2610, 6, 89, '2025-10-12 04:37:41'),
	(2611, 6, 99, '2025-10-12 04:37:41'),
	(2612, 6, 100, '2025-10-12 04:37:41'),
	(2613, 6, 101, '2025-10-12 04:37:41'),
	(2614, 6, 113, '2025-10-12 04:37:41'),
	(2615, 6, 121, '2025-10-12 04:37:41'),
	(2616, 6, 123, '2025-10-12 04:37:41'),
	(2617, 6, 129, '2025-10-12 04:37:41'),
	(2618, 6, 130, '2025-10-12 04:37:41'),
	(2619, 6, 131, '2025-10-12 04:37:41'),
	(2620, 6, 132, '2025-10-12 04:37:41'),
	(2621, 6, 135, '2025-10-12 04:37:41'),
	(2622, 6, 136, '2025-10-12 04:37:41'),
	(2623, 6, 137, '2025-10-12 04:37:41'),
	(2624, 6, 138, '2025-10-12 04:37:41'),
	(2625, 6, 139, '2025-10-12 04:37:41'),
	(2626, 6, 140, '2025-10-12 04:37:41'),
	(2627, 6, 141, '2025-10-12 04:37:41'),
	(2628, 6, 142, '2025-10-12 04:37:41'),
	(2629, 6, 143, '2025-10-12 04:37:41'),
	(2630, 6, 144, '2025-10-12 04:37:41'),
	(2631, 6, 145, '2025-10-12 04:37:41'),
	(2632, 6, 146, '2025-10-12 04:37:41'),
	(2633, 6, 147, '2025-10-12 04:37:41'),
	(2634, 6, 148, '2025-10-12 04:37:41'),
	(2635, 6, 133, '2025-10-12 04:37:41');

-- Dumping structure for table cms_db.system_settings
CREATE TABLE IF NOT EXISTS `system_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` enum('string','number','boolean','json') NOT NULL DEFAULT 'string',
  `description` text DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT 0,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_key` (`setting_key`),
  KEY `updated_by` (`updated_by`),
  KEY `idx_setting_key` (`setting_key`),
  KEY `idx_is_public` (`is_public`),
  CONSTRAINT `system_settings_ibfk_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.system_settings: ~0 rows (approximately)

-- ========================================================================
-- MULTI-ORGANIZATION SUPPORT
-- ========================================================================
-- This database supports multiple organizations. The 'organizations' table
-- is the root table for organizational hierarchy. The following tables have
-- organization_id foreign keys to support multi-organization data isolation:
--   - organizations (root table)
--   - units (organizational units per organization)
--   - departments (departments per organization)
--   - designations (designations per organization)
--   - ranks (military ranks per organization)
--   - roles (user roles per organization)
--   - users (users belong to an organization)
--   - conversations (messaging conversations per organization)
--   - notifications (user notifications per organization)
--   - feedback (user feedback per organization)
--   - audit_logs (activity logs per organization)
-- 
-- All organization_id fields have a DEFAULT value of 1 (Bangladesh Navy)
-- 
-- Organizational Hierarchy:
--   Organizations → Units → Departments → Designations → Users
--   Organizations → Ranks
--   Organizations → Roles → Users
-- ========================================================================

-- Dumping structure for table cms_db.organizations
CREATE TABLE IF NOT EXISTS `organizations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `code` varchar(50) NOT NULL,
  `type` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `logo` varchar(500) DEFAULT NULL,
  `theme` varchar(500) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `idx_name` (`name`),
  KEY `idx_code` (`code`),
  KEY `idx_is_active` (`is_active`),
  KEY `idx_created_by` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.organizations: ~1 row (approximately)
INSERT IGNORE INTO `organizations` (`id`, `name`, `code`, `type`, `description`, `address`, `phone`, `email`, `website`, `logo`, `is_active`, `created_by`, `created_at`, `updated_at`) VALUES
	(1, 'Bangladesh Navy', 'BN', 'Military', 'Naval Forces of Bangladesh', 'Naval Headquarters, Dhaka', '+880-2-9853871', 'info@navy.mil.bd', 'https://www.navy.mil.bd', NULL, 1, NULL, '2025-10-20 00:00:00', '2025-10-20 00:00:00');

-- Dumping structure for table cms_db.units
CREATE TABLE IF NOT EXISTS `units` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `code` varchar(20) NOT NULL,
  `description` text DEFAULT NULL,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `parent_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT 1,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `idx_name` (`name`),
  KEY `idx_is_active` (`is_active`),
  KEY `idx_organization_id` (`organization_id`),
  KEY `idx_parent_id` (`parent_id`),
  KEY `idx_created_by` (`created_by`),
  CONSTRAINT `units_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `units` (`id`) ON DELETE SET NULL,
  CONSTRAINT `units_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `units_ibfk_3` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.units: ~7 rows (approximately)
INSERT IGNORE INTO `units` (`id`, `name`, `code`, `description`, `organization_id`, `parent_id`, `order_id`, `is_active`, `created_by`, `created_at`, `updated_at`) VALUES
	(1, 'NHQ', 'NHQ', 'Naval Headquarters', 1, NULL, 1, 1, 1, '2025-10-07 09:50:31', '2025-10-11 09:49:25'),
	(2, 'Dhaka Naval Area', 'DNA', 'Dhaka Naval Area Command', 1, NULL, 2, 1, 1, '2025-10-07 09:50:31', '2025-10-11 09:54:32'),
	(3, 'Chittagong Naval Area', 'CNA', 'Chittagong Naval Area Command', 1, NULL, 3, 1, 1, '2025-10-07 09:50:31', '2025-10-11 09:55:17'),
	(4, 'Khulna Naval Area', 'KNA', 'Khulna Naval Area Command', 1, NULL, 4, 1, 1, '2025-10-07 09:50:31', '2025-10-11 09:49:36');

-- Dumping structure for table cms_db.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `login_id` varchar(100) DEFAULT NULL,
  `rank_id` int(11) DEFAULT NULL,
  `service_no` varchar(50) DEFAULT NULL,
  `unit_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL DEFAULT 1,
  `organization_id` int(11) NOT NULL DEFAULT 1,
  `department_id` int(11) DEFAULT NULL,
  `role_id` int(11) NOT NULL DEFAULT 3,
  `designation_id` int(11) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `alternative_mobile` varchar(20) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `avatar` varchar(500) DEFAULT NULL,
  `status` enum('online','offline','busy') NOT NULL DEFAULT 'offline',
  `last_seen` timestamp NULL DEFAULT NULL,
  `password_hash` varchar(255) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `service_no` (`service_no`),
  UNIQUE KEY `login_id` (`login_id`),
  UNIQUE KEY `unique_login_id` (`login_id`),
  KEY `idx_service_no` (`service_no`),
  KEY `idx_email` (`email`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_status` (`status`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_users_role_status` (`role_id`,`status`),
  KEY `idx_users_status_updated` (`status`,`updated_at`),
  KEY `idx_rank_id` (`rank_id`),
  KEY `idx_unit_id` (`unit_id`),
  KEY `idx_department_id` (`department_id`),
  KEY `idx_designation_id` (`designation_id`),
  KEY `idx_parent_id` (`parent_id`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`rank_id`) REFERENCES `ranks` (`id`) ON DELETE SET NULL,
  CONSTRAINT `users_ibfk_2` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`),
  CONSTRAINT `users_ibfk_3` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL,
  CONSTRAINT `users_ibfk_4` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`),
  CONSTRAINT `users_ibfk_5` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `users_ibfk_6` FOREIGN KEY (`parent_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.users: ~145 rows (approximately)
INSERT IGNORE INTO `users` (`id`, `name`, `login_id`, `rank_id`, `service_no`, `unit_id`, `order_id`, `organization_id`, `department_id`, `role_id`, `designation_id`, `phone`, `mobile`, `alternative_mobile`, `email`, `avatar`, `status`, `last_seen`, `password_hash`, `parent_id`, `is_active`, `created_at`, `updated_at`) VALUES
	(2, 'Super Admin', 's_admin', 1, 'BN10001', 1, 1, 1, 1, 1, 1, '+880211111111', '+8801811111111', '+8801811111111', 's_admin@gmail.com', NULL, 'offline', '2025-10-12 00:21:39', '$2a$10$wSP7ffhG.pqpil3rC9UkMehi/7unt3FNjAqIWadpa19AzQpONmNtG', NULL, 1, '2025-10-07 09:56:54', '2025-10-12 06:21:39'),
	(3, 'Admin', 'admin', 2, 'BN10002', 1, 1, 1, 1, 2, 2, '+880211111112', '+8801811111112', '+8801811111112', 'admin@gmail.com', NULL, 'offline', '2025-10-09 13:39:04', '$2a$10$kMUlyMUgmH.i7hWMsa7KzeCYGIzs.uSgzZOVbVE3PipWOfh0lueyO', NULL, 1, '2025-10-07 09:56:54', '2025-10-10 12:08:05'),
	(4, 'NHQ Admin', 'nhq_admin', NULL, 'SVC1760039398510', 1, 1, 1, 3, 6, 15, '+8809654545', '+02323123', '123123123213', 'nhqadmin@gmail.com', NULL, 'offline', '2025-10-12 00:29:17', '$2a$12$H1xV2g/k4lP.k8rdhICFiu7Lmu0Y6RQJxlP13NM.hmU7dSBFEekNe', NULL, 1, '2025-10-09 19:49:58', '2025-10-12 06:29:17'),
	(24, 'User', 'nhq_user', 5, 'BN10010', 1, 1, 1, 2, 3, 25, '+880211111120', '+8801811111120', '+8801811111120', 'navy@gmail.com', NULL, 'offline', '2025-10-12 00:26:16', '$2a$10$IRwspfCD3SYWvfJ.YSgYPeecZj4vEfmyV7ud2hLqoo5rCWtY.xrVy', NULL, 1, '2025-10-10 11:40:36', '2025-10-12 06:26:16'),
	(25, 'Major Sarah Johnson', NULL, 17, 'BN10011', 2, 1, 1, 2, 3, 35, '+880211111121', '+8801811111121', '', 'sarah.johnson@navy.mil', NULL, 'offline', NULL, '$2a$10$sA5oDFxi0AJb3eftRXSSzOOe1Oq/oMhm6frCITnbonmKal0VQiYX2', NULL, 0, '2025-10-10 11:40:36', '2025-10-11 13:01:44'),
	(26, 'Commander Lisa Davis1111', NULL, 6, 'BN10013', 1, 1, 1, 2, 2, 10, '+88021111112334343', '+8801811111123', '34343434', 'lisa.davis@navy.mil', NULL, 'offline', NULL, '$2a$10$QKGprACWWgpam74qaoAxVuAD7H0Nc2M4KB5Alb2NzPz34CRQ1nKYG', NULL, 1, '2025-10-10 11:40:37', '2025-10-10 14:33:13'),
	(27, 'Lieutenant Colonel Tom Wilson', NULL, 8, 'BN10014', 4, 1, 1, 3, 3, 14, '+880211111124', '+8801811111124', '+8801811111124', 'tom.wilson@navy.mil', NULL, 'offline', NULL, '$2a$10$acDQ0Tdj38PtvhzMQ.3bI.tLlHcby01.eqifvzbd.JAu7Ju8ut6hS', NULL, 0, '2025-10-10 11:40:37', '2025-10-10 12:01:46'),
	(28, 'Flag Lt', 'user_1760109368576_ini79qw3k', NULL, 'BN66278', 1, 1, 1, 1, 3, 4, '+880211366278', NULL, NULL, 'user66278@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$XeTGnzk/Pwa2aY.cYUp3YOXBw9vOzKSxPlynl2//Xc.BtPdv38/za', NULL, 1, '2025-10-10 15:16:08', '2025-10-10 15:16:08'),
	(29, 'Asst. Secy', 'user_1760109393375_usbb3p2ll', NULL, 'BN91200', 1, 1, 1, 1, 3, 3, '+880211391200', NULL, NULL, 'user91200@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$anawAojA4Fs38X/Dg05pw.I5tssYlD0SedWffkumzEIWcBK4ogwZu', NULL, 1, '2025-10-10 15:16:33', '2025-10-10 15:16:33'),
	(30, 'Protocol Offr', 'user_1760109412425_let0goucj', NULL, 'BN11062', 1, 1, 1, 1, 3, 5, '+880211411062', NULL, NULL, 'user11062@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$R0nvRGvkr7HtEidqb8bTAubX9Go.gA2hqIHa2Hxld5PKXUc0oGOqS', NULL, 1, '2025-10-10 15:16:52', '2025-10-10 15:16:52'),
	(31, 'Escort Offr', 'user_1760109426698_5fksk53ke', NULL, 'BN24309', 1, 1, 1, 1, 3, 6, '+880211424309', NULL, NULL, 'user24309@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$YhdBRqvnq8b7wri0Lec0VO4W7sUpof3fAEdNaMdDtm/1iW3XmyiK2', NULL, 1, '2025-10-10 15:17:06', '2025-10-10 15:17:06'),
	(32, 'NS', 'user_1760109464236_uidbzyl8b', NULL, 'BN62633', 1, 1, 1, 2, 3, 7, '+880211462633', NULL, NULL, 'user62633@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$tE/YIocR.gitvzl7nw.KieD.jxsnzl2O5LMv2kh5bXudtYgiDOLiC', NULL, 1, '2025-10-10 15:17:44', '2025-10-10 15:17:44'),
	(33, 'SONA-1', 'user_1760109498346_mg4abrz2s', NULL, 'BN96903', 1, 1, 1, 2, 3, 8, '+880211496903', NULL, NULL, 'user96903@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$x01YdJ0w6hDnMJ0IEJ3c7ebdaLQSOooytCAEQ0cV4jUFsRigWAQWS', NULL, 1, '2025-10-10 15:18:18', '2025-10-10 15:18:18'),
	(34, 'SONA-1 (Tec)', 'user_1760109513496_bnjfgx1ir', NULL, 'BN11309', 1, 1, 1, 2, 3, 9, '+880211511309', NULL, NULL, 'user11309@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$DrV8jy0ZApdevwjt9n1tqOY0GWBR1KLnRHaeQ2QZHCoTrp/9HUJBi', NULL, 1, '2025-10-10 15:18:33', '2025-10-10 15:18:33'),
	(35, 'SONA-2 (Plans)', 'user_1760109541487_9t5fx1mn1', NULL, 'BN39590', 1, 1, 1, 2, 3, 11, '+880211539590', NULL, NULL, 'user39590@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$NHL51JhY/I9tDulHccJk5O9h5Y2k6NVHKwKr56QVWmMkrfxFD1buG', NULL, 1, '2025-10-10 15:19:01', '2025-10-10 15:19:01'),
	(36, 'SO Tec', 'user_1760109567263_cdzul43a4', NULL, 'BN64973', 1, 1, 1, 2, 3, 12, '+880211564973', NULL, NULL, 'user64973@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$sT.CN7q3JEcssRBZkkz3COa0Pm43THWtuQgkOIXeagD53z3ntnuNy', NULL, 1, '2025-10-10 15:19:27', '2025-10-10 15:19:27'),
	(37, 'DA', 'user_1760109595256_n3sg72ltr', NULL, 'BN93019', 1, 1, 1, 3, 3, 13, '+880211593019', NULL, NULL, 'user93019@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$m.11t8zWzoVl7bi5fGHnQuhrp0ZcBJE9MPjq2sHyuwgwHpZCWNP3W', NULL, 1, '2025-10-10 15:19:55', '2025-10-10 15:19:55'),
	(38, 'DD Drafting', 'user_1760109607055_x8h5qidm3', NULL, 'BN4873', 1, 1, 1, 3, 3, 14, '+880211604873', NULL, NULL, 'user4873@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$OLiaRJPfSYjzFqww8pAte.gBNcWG.TR1Q4LUgbJSrn29un4zNolja', NULL, 1, '2025-10-10 15:20:07', '2025-10-10 15:20:07'),
	(39, 'Sec Comd-2', 'user_1760109628735_p5ya1vimo', NULL, 'BN26110', 1, 1, 1, 3, 3, 16, '+880211626110', NULL, NULL, 'user26110@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$zltRwxSbq3kngdqw387EP.2uvj10jji0PsZN93SGM.voUozJwkcxO', NULL, 1, '2025-10-10 15:20:28', '2025-10-10 15:20:28'),
	(40, 'Sec Comd-3', 'user_1760109642604_4jzzme7gy', NULL, 'BN40250', 1, 1, 1, 3, 3, 17, '+880211640250', NULL, NULL, 'user40250@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Fk0n5W/OhcdzgVEDOYZ7ReNNM.CnAkaX42LV.Ywq.hdJ7uVBcMfRa', NULL, 1, '2025-10-10 15:20:42', '2025-10-10 15:20:42'),
	(41, 'CNS', 'user_1760159045342_5dgoj5isz', NULL, 'BN44281', 1, 1, 1, 22, 3, 1, '+88021144281', NULL, NULL, 'user44281@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Z2YzA/.6NcNZshrqvmctM.QCTBvs9VvXqLtNfVtFzgXIInifhkil.', NULL, 1, '2025-10-11 05:04:05', '2025-10-11 05:04:05'),
	(42, 'Secy to CNS', 'user_1760159062119_yxhhau22g', NULL, 'BN61002', 1, 1, 1, 22, 3, 2, '+88021161002', NULL, NULL, 'user61002@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$YTyClQ.tW4VEIpu3jSR6ceFLoEEVjDJvZqk.ZtnDEOQpSdLt12X5W', NULL, 1, '2025-10-11 05:04:22', '2025-10-11 05:04:22'),
	(43, 'Asst Secy', 'user_1760159081380_0gctoj0yw', NULL, 'BN80411', 1, 1, 1, 22, 3, 3, '+88021180411', NULL, NULL, 'user80411@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$vwLKkXtpCQdZ/h/cPm52MO6g/Hl8o9N9juN4wzepf1XS9Xij/y6FS', NULL, 1, '2025-10-11 05:04:41', '2025-10-11 05:04:41'),
	(44, 'Flag Lt', 'user_1760159092352_2ktv2nex7', NULL, 'BN89993', 1, 1, 1, 22, 3, 4, '+88021189993', NULL, NULL, 'user89993@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$zO8UDNed9JoGNFI5goJmAOZT44jZT5ctDUXjimOJcaHxhafL/zXWu', NULL, 1, '2025-10-11 05:04:52', '2025-10-11 05:04:52'),
	(45, 'Protocol Offr', 'user_1760159112863_7w2zhfvbh', NULL, 'BN7597', 1, 1, 1, 22, 3, 5, '+880211107597', NULL, NULL, 'user7597@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$I2K2IqVm.z3NSJqvM70nVOa1zYhswdrV/30yJNI4vg5ixGGAaIIFS', NULL, 1, '2025-10-11 05:05:13', '2025-10-11 05:05:13'),
	(46, 'Escort Offr', 'user_1760159120802_wopvlf75w', NULL, 'BN19644', 1, 1, 1, 22, 3, 6, '+880211119644', NULL, NULL, 'user19644@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$M40WENjExnZy5SN0UGvfmO.zJ4bMEwaI2Uaz32r4j4QtKj2HxOlK6', NULL, 1, '2025-10-11 05:05:21', '2025-10-11 05:05:21'),
	(47, 'NS', 'user_1760160018439_l34j38vr5', NULL, 'BN16621', 1, 1, 1, 23, 3, 7, '+88021116621', NULL, NULL, 'user16621@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$R76MQMQsuJV69.ZJe6vPR..KeGvKSXfxRriCGDTGXeKr6oWEsJMFy', NULL, 1, '2025-10-11 05:20:18', '2025-10-11 05:20:18'),
	(48, 'SONA-1', 'user_1760160031194_op05ui2hd', NULL, 'BN29467', 1, 1, 1, 23, 3, 8, '+88021129467', NULL, NULL, 'user29467@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$07f1oAYREt1h.pLNNLE1/uonneTkMPT3Z4sOI/ma3IZQY1OiX7v2q', NULL, 1, '2025-10-11 05:20:31', '2025-10-11 05:20:31'),
	(49, 'SONA-1 (Tec)', 'user_1760160041797_srt5gr9oj', NULL, 'BN40018', 1, 1, 1, 23, 3, 9, '+88021140018', NULL, NULL, 'user40018@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$VGVqnIeQb.MQ4OrhJ0WMguhAWsAtoyGoj0nEjfd9wWSOZHerX27vK', NULL, 1, '2025-10-11 05:20:42', '2025-10-11 05:20:42'),
	(50, 'SONA-2', 'user_1760160049328_jyysiofac', NULL, 'BN48052', 1, 1, 1, 23, 3, 10, '+88021148052', NULL, NULL, 'user48052@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$I3DFmmGsZDeNLbEI0TfnyunRAiLvo57SsE/OHh3EXnfL/tqFyYksu', NULL, 1, '2025-10-11 05:20:49', '2025-10-11 05:20:49'),
	(51, 'SONA-2 (Plans)', 'user_1760160101819_i8gepnidv', NULL, 'BN392', 1, 1, 1, 23, 3, 11, '+880211100392', NULL, NULL, 'user392@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$/EdCx3NTWfTs2JMaVVbTluv9FssrZi5QFxXft8MLw9A5EYfBrYTre', NULL, 1, '2025-10-11 05:21:42', '2025-10-11 05:21:42'),
	(52, 'SO Tec', 'user_1760160134354_oc8kqz9qo', NULL, 'BN32923', 1, 1, 1, 23, 3, 12, '+880211132923', NULL, NULL, 'user32923@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$HXBN8LxuWUIDtgvFO3db5OedUNIHeGVkelGqeoV2pQGJMTYUdxvcy', NULL, 1, '2025-10-11 05:22:14', '2025-10-11 05:22:14'),
	(53, 'DA', 'user_1760160156190_xzrqsjqxz', NULL, 'BN54418', 1, 1, 1, 24, 3, 13, '+880211154418', NULL, NULL, 'user54418@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Wm8pKSsTbylcPTmhyQ.wWOqo1PHhBgsxrp/CHC1yOTcO1mfOrkXQy', NULL, 1, '2025-10-11 05:22:36', '2025-10-11 05:22:36'),
	(54, 'DD Drafting', 'user_1760160166230_czyc7zsa4', NULL, 'BN64341', 1, 1, 1, 24, 3, 14, '+880211164341', NULL, NULL, 'user64341@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$AEUPz9Ez4PBXWRXQN3mVeuMqPT0PhoYcSCQzCWTLSiO05MYZZ2Wwq', NULL, 1, '2025-10-11 05:22:46', '2025-10-11 05:22:46'),
	(55, 'Sec Comd-1', 'user_1760160173915_8anvhddv7', NULL, 'BN72014', 1, 1, 1, 24, 3, 15, '+880211172014', NULL, NULL, 'user72014@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$54G77ZnFPeOeNSYIkVItpuj/8eCciOmjK8YMdtpNzwDdBhzp2.MSu', NULL, 1, '2025-10-11 05:22:54', '2025-10-11 05:22:54'),
	(56, 'Sec Comd-2', 'user_1760160178848_ale54mk5s', NULL, 'BN77776', 1, 1, 1, 24, 3, 16, '+880211177776', NULL, NULL, 'user77776@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$yNwEU2uTfWEp8SvEs6Ixk.7gmmWYN/kADGLUQcIQvGOMRQqdbo/XW', NULL, 1, '2025-10-11 05:22:59', '2025-10-11 05:22:59'),
	(57, 'Sec Comd-3', 'user_1760160183959_6ciu4044x', NULL, 'BN82987', 1, 1, 1, 24, 3, 17, '+880211182987', NULL, NULL, 'user82987@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$qLnsXLFjBk4z5C2f1HR.EupIcVi3HWkDbR37ucJsDQfpcvkg4ez1y', NULL, 1, '2025-10-11 05:23:04', '2025-10-11 05:23:04'),
	(58, 'JAG', 'user_1760160275936_hnxd69nb2', NULL, 'BN74758', 1, 1, 1, 25, 3, 18, '+880211274758', NULL, NULL, 'user74758@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Z5jCs6OGJkLPEBG73gDvpum1m4xXGQbY2b6ZL7Y.e4VZDYPpugwDy', NULL, 1, '2025-10-11 05:24:36', '2025-10-11 05:24:36'),
	(59, 'DD JAG', 'user_1760160286863_d6cj6f40y', NULL, 'BN85851', 1, 1, 1, 25, 3, 19, '+880211285851', NULL, NULL, 'user85851@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$flZ0aj21z6ZZXUsdK0tgM.QOPKsIsxDDTKoeZp87dqmnPMigQxJVy', NULL, 1, '2025-10-11 05:24:47', '2025-10-11 05:24:47'),
	(60, 'SO (JAG)', 'user_1760160296324_mrt6fwk37', NULL, 'BN94481', 1, 1, 1, 25, 3, 20, '+880211294481', NULL, NULL, 'user94481@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$JC3Y5CimOlwGasP.0jsT2.VI7.byRm7J0UI1OvahuUphG9IcFGj3G', NULL, 1, '2025-10-11 05:24:56', '2025-10-11 05:24:56'),
	(61, 'ACNS (O)', 'user_1760160548832_179h8amqg', NULL, 'BN46999', 1, 1, 1, 30, 3, 21, '+880211546999', NULL, NULL, 'user46999@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$K9RuvqlP8x8fn0XP2t6.cuqV1sxIAO2ft7/liVXeHT3dgA3WtQW0i', NULL, 1, '2025-10-11 05:29:09', '2025-10-11 05:29:09'),
	(62, 'Coord to ACNS (O)', 'user_1760160618355_eofekhch9', NULL, 'BN16595', 1, 1, 1, 30, 3, 22, '+880211616595', NULL, NULL, 'user16595@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$LYuPhO6KUiMv5XW45MhNyeMUlWcajSE4r9zaXy0bfJlVvA9f26Jx6', NULL, 1, '2025-10-11 05:30:18', '2025-10-11 05:30:18'),
	(63, 'DDNO', 'user_1760161874061_phqiuk1be', NULL, 'BN73004', 1, 1, 1, 31, 3, 23, '+880211873004', NULL, NULL, 'user73004@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$NCEmfoNVo752C/vGUa6AIOfQfvdqwmLM4EwyEzwRVR4sp2IoRsXri', NULL, 1, '2025-10-11 05:51:14', '2025-10-11 05:51:14'),
	(64, 'SO (O)', 'user_1760161883821_wgrxh9nkw', NULL, 'BN82792', 1, 1, 1, 31, 3, 24, '+880211882792', NULL, NULL, 'user82792@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$kiO/HWKOX/Khzy3vxXrT8.xkoP/UY6eAEUC/cwUyWBIXOBZSXQcRC', NULL, 1, '2025-10-11 05:51:24', '2025-10-11 05:51:24'),
	(65, 'SO (Ops Plan)', 'user_1760161890978_k0sysl0sa', NULL, 'BN89945', 1, 1, 1, 31, 3, 25, '+880211889945', NULL, NULL, 'user89945@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$DFxPmmk/cxCq7hVKKU9Yt.Jr3GRBVCb.K8qliWB9YYpFSY/SoKbKG', NULL, 1, '2025-10-11 05:51:31', '2025-10-11 05:51:31'),
	(66, 'DDNI', 'user_1760161910904_78w00pwc1', NULL, 'BN9031', 1, 1, 1, 32, 3, 26, '+880211909031', NULL, NULL, 'user9031@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$/7QoUcDp9kMTV8DTBlMv/u2BLmsBo2aW/1MdMOuFRsEwpAwMRcOW6', NULL, 1, '2025-10-11 05:51:51', '2025-10-11 05:51:51'),
	(67, 'SO (l)', 'user_1760161926518_40m1b5hxn', NULL, 'BN24250', 1, 1, 1, 32, 3, 27, '+880211924250', NULL, NULL, 'user24250@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Nl.EaSx.BvVtldzsIGHZmexm2p7KENMseUGv.cODap4YbsIpLvyfG', NULL, 1, '2025-10-11 05:52:06', '2025-10-11 05:52:06'),
	(68, 'SO (Cl)', 'user_1760161942545_j5rhksje3', NULL, 'BN40366', 1, 1, 1, 32, 3, 28, '+880211940366', NULL, NULL, 'user40366@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$lCxo/DuY3isrzKlpEHtU1uqvqNKtYMiwjxsRwymD//eLPQfvepMGe', NULL, 1, '2025-10-11 05:52:22', '2025-10-11 05:52:22'),
	(69, 'SO (Tec)', 'user_1760161959113_3g9ijt0ee', NULL, 'BN57990', 1, 1, 1, 32, 3, 29, '+880211957990', NULL, NULL, 'user57990@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$OXx1MfzSmtGXBsITRNxVgutUbYEDm62TxQ2XKF6IKRyMCqde1n3ti', NULL, 1, '2025-10-11 05:52:39', '2025-10-11 05:52:39'),
	(70, 'SO (Media)', 'user_1760161968258_fk7oofbfa', NULL, 'BN67246', 1, 1, 1, 32, 3, 30, '+880211967246', NULL, NULL, 'user67246@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$.6bYJiOGsGMVrr5mBC9vE.ytvRAj4I5kXLXZYdS4C029VeJmPmvte', NULL, 1, '2025-10-11 05:52:48', '2025-10-11 05:52:48'),
	(71, 'DDNP', 'user_1760161992809_3xx64szut', NULL, 'BN90663', 1, 1, 1, 33, 3, 31, '+880211990663', NULL, NULL, 'user90663@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$mBdnmgqGYP03vrHo5sCFbuUCrzUB.TTo0Tx.5MJ0C3yNa.f7IlXnW', NULL, 1, '2025-10-11 05:53:13', '2025-10-11 05:53:13'),
	(72, 'SO (Plan-1)', 'user_1760162003101_fqu9sgabt', NULL, 'BN1166', 1, 1, 1, 33, 3, 32, '+8802111166', NULL, NULL, 'user1166@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$jSAHCk/cA/cO59LiY.mREe6ykGmNe3GXEAqZ81bk1B9TP/ufQuN7G', NULL, 1, '2025-10-11 05:53:23', '2025-10-11 05:53:23'),
	(73, 'SO (Plans-2)', 'user_1760162011127_cyq5v55il', NULL, 'BN8429', 1, 1, 1, 33, 3, 33, '+8802118429', NULL, NULL, 'user8429@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$I1QzRHQf11GCHX7qkQY2xOv2zHb.sntMjCSiO30Tkab5onvmdWtt2', NULL, 1, '2025-10-11 05:53:31', '2025-10-11 05:53:31'),
	(74, 'DD Sig', 'user_1760162043961_3lluolmbl', NULL, 'BN41640', 1, 1, 1, 34, 3, 34, '+88021141640', NULL, NULL, 'user41640@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$HsXXBDMYLvEu1mouuRt02OSdI9RjsdgqSdLWpPFJS8.xdiPQCwb2i', NULL, 1, '2025-10-11 05:54:04', '2025-10-11 05:54:04'),
	(75, 'SO (Sig)1', 'user_1760162051954_12r0akwxk', NULL, 'BN50045', 1, 1, 1, 34, 3, 35, '+88021150045', NULL, NULL, 'user50045@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$7SfJrEbpfCHjTNm4TUrY1ekfvuPwWrFilLS1QmgTfvVGTfiCkYf5C', NULL, 0, '2025-10-11 05:54:12', '2025-10-11 12:59:23'),
	(76, 'DD Works', 'user_1760162072302_pb1ofsb9v', NULL, 'BN71113', 1, 1, 1, 35, 3, 36, '+88021171113', NULL, NULL, 'user71113@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$seoJUCl2DllqGNcKhYKqZ.CqJS9trd7kOldy.Sen5Gxk/YDSOtx.i', NULL, 1, '2025-10-11 05:54:32', '2025-10-11 05:54:32'),
	(77, 'SO (Works)', 'user_1760162078532_03lgebeh9', NULL, 'BN77463', 1, 1, 1, 35, 3, 37, '+88021177463', NULL, NULL, 'user77463@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$dsbnwfTvXQLIiXASOTgTnu0GS35NFh0rzrE9iUvwP3xtGNBPpjeI6', NULL, 1, '2025-10-11 05:54:38', '2025-10-11 05:54:38'),
	(78, 'DD Nav', 'user_1760162100171_bnz59mt2l', NULL, 'BN94949', 1, 1, 1, 36, 3, 38, '+88021194949', NULL, NULL, 'user94949@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$85FjhYzv5/XEBMXfbYW5R.ecFDcEiouvlxl5h.Zaf3F/ghqXKVuYu', NULL, 1, '2025-10-11 05:55:00', '2025-10-11 05:55:00'),
	(79, 'SO (Nav)', 'user_1760162106779_85byuu19j', NULL, 'BN5665', 1, 1, 1, 36, 3, 39, '+880211105665', NULL, NULL, 'user5665@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$R0rtqlbtHXZJ0r2cMPv93uPTBwlrBKn2LNcpcntitfUvO.bzN06Oq', NULL, 1, '2025-10-11 05:55:07', '2025-10-11 05:55:07'),
	(80, 'DD Hydro', 'user_1760162133342_xgpjnw4zb', NULL, 'BN31489', 1, 1, 1, 37, 3, 40, '+880211131489', NULL, NULL, 'user31489@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$ObcuFlK..NuPZZe1G9/xSeIJ90R2iQtsK5jnzFQXttid8DlliDLu.', NULL, 1, '2025-10-11 05:55:33', '2025-10-11 05:55:33'),
	(81, 'SO (Hydro)', 'user_1760162142877_62i6slwon', NULL, 'BN41816', 1, 1, 1, 37, 3, 41, '+880211141816', NULL, NULL, 'user41816@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$xh7DdsxDx6tLfdBloKSZceO6sJeDHiNuC/rKnC.DOXjTpWb4IDIaS', NULL, 1, '2025-10-11 05:55:43', '2025-10-11 05:55:43'),
	(82, 'Capt Staff', 'user_1760162161891_kfpioap9g', NULL, 'BN60703', 1, 1, 1, 38, 3, 42, '+880211160703', NULL, NULL, 'user60703@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$pIN8aLwqoXWN27l8cNjUZuVePGyeXA5NipB0uHco0zrTXhOn99ZH2', NULL, 1, '2025-10-11 05:56:02', '2025-10-11 05:56:02'),
	(83, 'DD Sub', 'user_1760162172191_00weglpz8', NULL, 'BN71051', 1, 1, 1, 38, 3, 43, '+880211171051', NULL, NULL, 'user71051@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$tY017uZaueHM0OEvhNOgWuJ33W8YiYmtGgWRDYkU4lmfJ6LpIcu5O', NULL, 1, '2025-10-11 05:56:12', '2025-10-11 05:56:12'),
	(84, 'DD Sub (Tec)', 'user_1760162182269_jdjc11mko', NULL, 'BN80878', 1, 1, 1, 38, 3, 44, '+880211180878', NULL, NULL, 'user80878@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Lex3lofwNuniRH7pgQHKeeek9bHUl.qAPIMUbAywg6HXHgBldGZdq', NULL, 1, '2025-10-11 05:56:22', '2025-10-11 05:56:22'),
	(85, 'So (Sub)', 'user_1760162189641_2gc2uax5h', NULL, 'BN88481', 1, 1, 1, 38, 3, 45, '+880211188481', NULL, NULL, 'user88481@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$KuU/gico0VIeVdi5vgfrceQhd0BRWRfYk/KobwJnRkmGsYzNGRltu', NULL, 1, '2025-10-11 05:56:29', '2025-10-11 05:56:29'),
	(86, 'DD Spl Ops', 'user_1760162213164_yvu2kd3be', NULL, 'BN11757', 1, 1, 1, 39, 3, 46, '+880211211757', NULL, NULL, 'user11757@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Kctjp/t/JQSG1TT/WAy74Obn9WJ9tLYMxzAD2o2LCFJn5FehPuwgy', NULL, 1, '2025-10-11 05:56:53', '2025-10-11 05:56:53'),
	(87, 'SO (Spl Ops)', 'user_1760162226136_f7oi2bi9v', NULL, 'BN24385', 1, 1, 1, 39, 3, 47, '+880211224385', NULL, NULL, 'user24385@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$zQwQLGEAcDP.1bLBvKfpk.8lrTfpsHol09hpPqU/CnKlmniBkwTom', NULL, 1, '2025-10-11 05:57:06', '2025-10-11 05:57:06'),
	(88, 'DD SD & C', 'user_1760162240354_l52avcdr2', NULL, 'BN38545', 1, 1, 1, 40, 3, 48, '+880211238545', NULL, NULL, 'user38545@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$WwS65MT00NZyNNlQhZsLMuTzNX.RsAvdpI4EQnUwMRBS8Cy6Xs9w6', NULL, 1, '2025-10-11 05:57:20', '2025-10-11 05:57:20'),
	(89, 'SO (SD & C)', 'user_1760162252923_geug61ao0', NULL, 'BN51024', 1, 1, 1, 40, 3, 49, '+880211251024', NULL, NULL, 'user51024@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$GZYvvwsEr0Zfjbn3WEd7Yuqf4EFtk5EXPvqqvpudQtOk5w/vxrMW6', NULL, 1, '2025-10-11 05:57:33', '2025-10-11 05:57:33'),
	(90, 'DDONO', 'user_1760162266374_et8xkmpjn', NULL, 'BN64159', 1, 1, 1, 41, 3, 50, '+880211264159', NULL, NULL, 'user64159@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Id/O3sx30CYwFNPxdlgkaOLkTDbn/rqfc.aM53t7bPByCD/wWxGKS', NULL, 1, '2025-10-11 05:57:46', '2025-10-11 05:57:46'),
	(91, 'SO (ONO)', 'user_1760162275609_kmep4031q', NULL, 'BN73437', 1, 1, 1, 41, 3, 51, '+880211273437', NULL, NULL, 'user73437@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$1Q8PK1U4AdKLbSZMmvz9ceLIFjNSCSCsNT07daJzAaMOuqWx7z2D.', NULL, 1, '2025-10-11 05:57:55', '2025-10-11 05:57:55'),
	(92, 'ACNS (O)', 'user_1760177439827_r9fgomp3n', NULL, 'BN38649', 1, 1, 1, 43, 3, 52, '+880211438649', NULL, NULL, 'user38649@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$SHvjQjJQWegIWLmJH/wlIuTY2zxYlaReJWMqVQxWAoFUsa4v7iFOy', NULL, 1, '2025-10-11 10:10:40', '2025-10-11 13:00:56'),
	(93, 'Coord to ACNS (O)', 'user_1760177447688_ygpmdehep', NULL, 'BN46743', 1, 1, 1, 43, 3, 53, '+880211446743', NULL, NULL, 'user46743@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$s/GYShunYDESQMqRkLMDXuErSgo8vt4iE.ljkOqVTY9a8ZMQH7F1K', NULL, 1, '2025-10-11 10:10:47', '2025-10-11 13:00:59'),
	(94, 'DDNPS', 'user_1760177470084_svwx9mw89', NULL, 'BN68279', 1, 1, 1, 44, 3, 54, '+880211468279', NULL, NULL, 'user68279@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$TTCfXWFEAAgHHmBZlN.1wuGPfbGWYTGLepSdoJU/9OOtKw1kN.nmm', NULL, 1, '2025-10-11 10:11:10', '2025-10-11 10:11:10'),
	(95, 'SO (Pers)', 'user_1760177488145_fn3lyuc4o', NULL, 'BN86071', 1, 1, 1, 44, 3, 55, '+880211486071', NULL, NULL, 'user86071@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$VCu1sC6l2uUSVr1aa58E4ORlJmyBxfiQzC6JoqB4WJas4U4lFEBCy', NULL, 1, '2025-10-11 10:11:28', '2025-10-11 10:11:28'),
	(96, 'DDNT', 'user_1760177503493_fp3v6zz89', NULL, 'BN2572', 1, 1, 1, 45, 3, 56, '+880211502572', NULL, NULL, 'user2572@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$XcXUilgD.Cj3JX17x3i21.HGSXOOmMsRccgXvf5TH2u23E2PynhMi', NULL, 1, '2025-10-11 10:11:43', '2025-10-11 10:11:43'),
	(97, 'SO (T-1)', 'user_1760177514240_tp5zlgnsb', NULL, 'BN12593', 1, 1, 1, 45, 3, 57, '+880211512593', NULL, NULL, 'user12593@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$zlzWRJxvyEh5bpmBx9MDYe7VliiAolp0sN48UK942ihvtSZT2Jqv.', NULL, 1, '2025-10-11 10:11:54', '2025-10-11 10:11:54'),
	(98, 'SO (T-2)', 'user_1760177524217_wmekqd69z', NULL, 'BN22162', 1, 1, 1, 45, 3, 58, '+880211522162', NULL, NULL, 'user22162@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$hHoQFoIItqiP/SPTsOVM7e1Y2HveLgc88mpVp9psM9j/LYZfO3.YK', NULL, 1, '2025-10-11 10:12:04', '2025-10-11 10:12:04'),
	(99, 'SO', 'user_1760177533536_602wvigzw', NULL, 'BN30872', 1, 1, 1, 45, 3, 59, '+880211530872', NULL, NULL, 'user30872@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$hUugLeQ2hG/zpDoZSqvRTe10YWCaf1IBZdzIFk8E5FfP0elmKJDDq', NULL, 1, '2025-10-11 10:12:13', '2025-10-11 10:12:13'),
	(100, 'DD Wel', 'user_1760177554873_guwuoqmb4', NULL, 'BN52828', 1, 1, 1, 46, 3, 60, '+880211552828', NULL, NULL, 'user52828@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$I.nWbM3KQuGPhlXGYEQ1JOX6I7o2RAdtldsINbd6LHyUK0yoZLR0a', NULL, 1, '2025-10-11 10:12:35', '2025-10-11 10:12:35'),
	(101, 'SO (Wel)', 'user_1760177564863_9tucn3pt0', NULL, 'BN63596', 1, 1, 1, 46, 3, 61, '+880211563596', NULL, NULL, 'user63596@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$f95h8oeIBIH4Xz3Rf3muneMv4OEKTiMKhEPLwNd7z5SobiNw5gYQC', NULL, 1, '2025-10-11 10:12:45', '2025-10-11 10:12:45'),
	(102, 'DDMS', 'user_1760177580192_5oqiw1s71', NULL, 'BN78481', 1, 1, 1, 47, 3, 62, '+880211578481', NULL, NULL, 'user78481@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$6pU6nENQuFB/fGEfdh8opuWDBC3oTFucg9pkHLcpYiXkV7C9rAOqe', NULL, 1, '2025-10-11 10:13:00', '2025-10-11 10:13:00'),
	(103, 'SO', 'user_1760177588140_o5suyvfnn', NULL, 'BN87163', 1, 1, 1, 47, 3, 63, '+880211587163', NULL, NULL, 'user87163@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$bnw3knTmuuwN8nzI2hZX2eFAUlJBfWp5KWYulr5CnNl.f1LyYpLci', NULL, 1, '2025-10-11 10:13:08', '2025-10-11 10:13:08'),
	(104, 'DD Edn', 'user_1760177614056_s7g0d2mwt', NULL, 'BN12444', 1, 1, 1, 48, 3, 64, '+880211612444', NULL, NULL, 'user12444@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$MAGgaKZsqxS463tirlr8Susc2s0S3Lc8zSybie3d8qucwFoJ78zt.', NULL, 1, '2025-10-11 10:13:34', '2025-10-11 10:13:34'),
	(105, 'SO (Edn)', 'user_1760177622960_7c3jpiecu', NULL, 'BN22081', 1, 1, 1, 48, 3, 65, '+880211622081', NULL, NULL, 'user22081@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$JQiyoJdkwAHXHjyNK2rl6.cU3cA4MPglFVItmEvq2AkhytWuye6z2', NULL, 1, '2025-10-11 10:13:43', '2025-10-11 10:13:43'),
	(106, 'DD Nav', 'user_1760177641198_f3cjjo9jq', NULL, 'BN39579', 1, 1, 1, 49, 3, 66, '+880211639579', NULL, NULL, 'user39579@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$5IG0Oli8Myd4QH/s2yc29uRe/F53t3BVSbSXYZsP54TJYkqN6Imoe', NULL, 1, '2025-10-11 10:14:01', '2025-10-11 10:14:01'),
	(107, 'SO (Nav)', 'user_1760177651422_s1fz922nc', NULL, 'BN50573', 1, 1, 1, 49, 3, 67, '+880211650573', NULL, NULL, 'user50573@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$YWYoIyzRU8jfSWz6z1kxMOidmYxWL8j5l//AB9BOjNpU.i.D5Ijm2', NULL, 1, '2025-10-11 10:14:11', '2025-10-11 10:14:11'),
	(108, 'ACNS (O)', 'user_1760180704303_edeauobja', NULL, 'BN3284', 1, 1, 1, 51, 3, 68, '+880211703284', NULL, NULL, 'user3284@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$QU5meHwWpX3xW2sNlXTKCurMADyEJiQ2zfBe3X5gbgPxGrV2LvSqe', NULL, 1, '2025-10-11 11:05:04', '2025-10-11 11:05:04'),
	(109, 'Coord to ACNS (O)', 'user_1760180711272_7q1j530yv', NULL, 'BN10130', 1, 1, 1, 51, 3, 69, '+880211710130', NULL, NULL, 'user10130@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$0tNmGurIGkTKamrYrG.nf.BMsl7eNNGfwGIN/B4Ocyo3RPbWIJQc6', NULL, 1, '2025-10-11 11:05:11', '2025-10-11 11:05:11'),
	(110, 'DDNO', 'user_1760180724939_50on028eb', NULL, 'BN22932', 1, 1, 1, 53, 3, 70, '+880211722932', NULL, NULL, 'user22932@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$KlaR11huyIAiDajopxqZ2uu2JIKrRlPv.URDMMtpBTySLQDtmRIUW', NULL, 1, '2025-10-11 11:05:25', '2025-10-11 11:05:25'),
	(111, 'SO (O)', 'user_1760180735750_jj8793oga', NULL, 'BN34194', 1, 1, 1, 53, 3, 71, '+880211734194', NULL, NULL, 'user34194@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$7gk2ONl9sCnPpJu4QCoMLulYCoBXJI.OvXAUogm6rfgCHIPvaPdfK', NULL, 1, '2025-10-11 11:05:35', '2025-10-11 11:05:35'),
	(112, 'SO (Ops Plan)', 'user_1760180744499_rhhf1f9fk', NULL, 'BN43534', 1, 1, 1, 53, 3, 72, '+880211743534', NULL, NULL, 'user43534@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$2NDnaYAAlNJWcCNt2NhS5.RTQPlTXp5QUHhPR4FsRSmLVfWUCEGTe', NULL, 1, '2025-10-11 11:05:44', '2025-10-11 11:05:44'),
	(113, 'DDNI', 'user_1760180759754_gj26v445a', NULL, 'BN58033', 1, 1, 1, 55, 3, 73, '+880211758033', NULL, NULL, 'user58033@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$zEcAMAikGVLDxfOy2U4CMeZ0virRLJXf86pUJKl.kMx0wV3fidWCy', NULL, 1, '2025-10-11 11:05:59', '2025-10-11 11:05:59'),
	(114, 'SO (l)', 'user_1760180770372_a4i7t372p', NULL, 'BN68616', 1, 1, 1, 55, 3, 74, '+880211768616', NULL, NULL, 'user68616@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$cnRiCAMrJGBnREIkTPh1KOsKlmjRN37Q43BBu9SFBqxqp.tLuI/WO', NULL, 1, '2025-10-11 11:06:10', '2025-10-11 11:06:10'),
	(115, 'SO (Cl)', 'user_1760180781244_pew6u0tbi', NULL, 'BN79437', 1, 1, 1, 55, 3, 75, '+880211779437', NULL, NULL, 'user79437@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$KmB5z/S.tGU64IMjRMns0Obcd/ueYP0M9bxMx.HAMM7RTKILj2y2G', NULL, 1, '2025-10-11 11:06:21', '2025-10-11 11:06:21'),
	(116, 'SO (Tec)', 'user_1760180789113_61npbp31z', NULL, 'BN88028', 1, 1, 1, 55, 3, 76, '+880211788028', NULL, NULL, 'user88028@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$6VogsCk5tM6VuaPl3zK1pu0uFL.pvHXmwom6MaJr4MBTk5TGLWlx2', NULL, 1, '2025-10-11 11:06:29', '2025-10-11 11:06:29'),
	(117, 'SO (Media)', 'user_1760180794173_gdpx6ytxm', NULL, 'BN93156', 1, 1, 1, 55, 3, 77, '+880211793156', NULL, NULL, 'user93156@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$jZBWSbOCMsLt0GLknygpQug2ZMpgcRDSgX9OfYlQvNgdmOnx/se82', NULL, 1, '2025-10-11 11:06:34', '2025-10-11 11:06:34'),
	(118, 'DDNP', 'user_1760180812272_kesf0w13k', NULL, 'BN10526', 1, 1, 1, 56, 3, 78, '+880211810526', NULL, NULL, 'user10526@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$T4XRTTnZCTS1cu/8jupDJe9wfsdAZ9uxQxXIZTMNVW1yM9pHb8T46', NULL, 1, '2025-10-11 11:06:52', '2025-10-11 11:06:52'),
	(119, 'SO (Plan-1)', 'user_1760180818283_jfdszuk4d', NULL, 'BN17173', 1, 1, 1, 56, 3, 79, '+880211817173', NULL, NULL, 'user17173@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$gMi5Q5ZincmBDdkorEqcsum1qhP50DKHqaVnBVYuoUJMtJkqRwSdG', NULL, 1, '2025-10-11 11:06:58', '2025-10-11 11:06:58'),
	(120, 'SO (Plans-2)', 'user_1760180823323_urdc0xu7y', NULL, 'BN22324', 1, 1, 1, 56, 3, 80, '+880211822324', NULL, NULL, 'user22324@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$2UBtSnitLobBXmihV2bZuOBgc/E2izPzhfQy.HTB3Wxvn4UqgB1Te', NULL, 1, '2025-10-11 11:07:03', '2025-10-11 11:07:03'),
	(121, 'DD Sig', 'user_1760180836850_xxkebp8w2', NULL, 'BN33725', 1, 1, 1, 58, 3, 81, '+880211833725', NULL, NULL, 'user33725@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$LBWXDE5GWlEBXjnmKe4b1.gLka5ouS8q2wU5PXl84GOOXMfhXV3t2', NULL, 1, '2025-10-11 11:07:17', '2025-10-11 11:07:17'),
	(122, 'SO (Sig)', 'user_1760180844159_cfz842mn0', NULL, 'BN43206', 1, 1, 1, 58, 3, 82, '+880211843206', NULL, NULL, 'user43206@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$1o6GoQp4eEnQpomvHMR64e7IwiX8fmSdjIaIykGccMfas/GegCv5C', NULL, 1, '2025-10-11 11:07:24', '2025-10-11 11:07:24'),
	(123, 'DD Works', 'user_1760180867241_ye75l04mh', NULL, 'BN66215', 1, 1, 1, 59, 3, 83, '+880211866215', NULL, NULL, 'user66215@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Dfi0eJzpfVwJknsjakO17.hjpZ0xcFpGdNPgWEqTfPQtxnW0Q9zlm', NULL, 1, '2025-10-11 11:07:47', '2025-10-11 11:07:47'),
	(124, 'SO (Works)', 'user_1760180875980_zdde6xd44', NULL, 'BN75101', 1, 1, 1, 59, 3, 84, '+880211875101', NULL, NULL, 'user75101@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$8DopZy47nDX3WTkKy3YidumPQxY9.TDgmQMoh3crwpGShfPECr3f2', NULL, 1, '2025-10-11 11:07:56', '2025-10-11 11:07:56'),
	(125, 'DD Nav', 'user_1760180888968_0emu02vs7', NULL, 'BN86936', 1, 1, 1, 60, 3, 85, '+880211886936', NULL, NULL, 'user86936@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$LY9yLFwuZnuruRLpyljNs.IfDyhSGd9Bqz6c575kqPShjVWcrzlVe', NULL, 1, '2025-10-11 11:08:09', '2025-10-11 11:08:09'),
	(126, 'SO (Nav)', 'user_1760180896307_keoh6mn71', NULL, 'BN95440', 1, 1, 1, 60, 3, 86, '+880211895440', NULL, NULL, 'user95440@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$X9RDF9o.Yprl9mnutG642.fUBjGYlztbwPrUbPpPHf2oUL/7H/i8G', NULL, 1, '2025-10-11 11:08:16', '2025-10-11 11:08:16'),
	(127, 'DD Hydro', 'user_1760180912796_hgrc9gpe9', NULL, 'BN11316', 1, 1, 1, 61, 3, 87, '+880211911316', NULL, NULL, 'user11316@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$8sb10Cmez//jduGppaT5V.4aAuDFGY5ePJdXMhRzQsAq4hyap3VW.', NULL, 1, '2025-10-11 11:08:33', '2025-10-11 11:08:33'),
	(128, 'SO (Hydro)', 'user_1760180921098_ccx5weau8', NULL, 'BN20219', 1, 1, 1, 61, 3, 88, '+880211920219', NULL, NULL, 'user20219@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$gu9an6rGsYrQp/U8HftN/OFl06JJFmOVpZWPUNvuMJ1ei25dAf0oa', NULL, 1, '2025-10-11 11:08:41', '2025-10-11 11:08:41'),
	(129, 'Capt Staff', 'user_1760180942737_ss4nx5fgu', NULL, 'BN41487', 1, 1, 1, 62, 3, 89, '+880211941487', NULL, NULL, 'user41487@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$srLBJVhsSPecSEB7XyCw9eoC.IZQBNDy4gFngHUv6jpIDMgt4BEe2', NULL, 1, '2025-10-11 11:09:02', '2025-10-11 11:09:02'),
	(130, 'DD Sub', 'user_1760180955222_xelm61q2d', NULL, 'BN53215', 1, 1, 1, 62, 3, 90, '+880211953215', NULL, NULL, 'user53215@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$q7bs0uJw9nLrb7QG.fz/7uLxt5FSJjtws/PZCO2J6VDQRmY9JpO/6', NULL, 1, '2025-10-11 11:09:15', '2025-10-11 11:09:15'),
	(131, 'DD Sub (Tec)', 'user_1760180964475_iplgxyfxl', NULL, 'BN63620', 1, 1, 1, 62, 3, 91, '+880211963620', NULL, NULL, 'user63620@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$rRQ8XoeMNqIuE2unkH7rkeNEOlndOdPiYVysB3v8QMNN53vHGOQ/q', NULL, 1, '2025-10-11 11:09:24', '2025-10-11 11:09:24'),
	(132, 'So (Sub)', 'user_1760180976933_0sp1fhrtz', NULL, 'BN75148', 1, 1, 1, 62, 3, 92, '+880211975148', NULL, NULL, 'user75148@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$4KSQs3HdZ44Qi2TkuzaVLexDdxnZROKS//M7jQYlvwSLNhFG6CI/q', NULL, 1, '2025-10-11 11:09:37', '2025-10-11 11:09:37'),
	(133, 'DD Spl Ops', 'user_1760181000381_m8k30skmc', NULL, 'BN99476', 1, 1, 1, 63, 3, 93, '+880211999476', NULL, NULL, 'user99476@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$J3PrND1g2OKrez5YW0FNTOg6jz4RhBuhsoGQfpm1pXq3ymMdqOxym', NULL, 1, '2025-10-11 11:10:00', '2025-10-11 11:10:00'),
	(134, 'SO (Spl Ops)', 'user_1760181008283_f752d4gpu', NULL, 'BN7437', 1, 1, 1, 63, 3, 94, '+8802117437', NULL, NULL, 'user7437@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$RoBse2wvbUSLmbWF0WLnMOcIlBZo.a5G6QXPAeHYuCYBV17hhWp4W', NULL, 1, '2025-10-11 11:10:08', '2025-10-11 11:10:08'),
	(135, 'DD SD & C', 'user_1760181042250_8b2r4ixzr', NULL, 'BN40844', 1, 1, 1, 64, 3, 95, '+88021140844', NULL, NULL, 'user40844@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$n04DesYTwx1qQXl7jxpOjuz./BZuICshrIsQ/Z8k0tH3ZWmzhxxQu', NULL, 1, '2025-10-11 11:10:42', '2025-10-11 11:10:42'),
	(136, 'SO (SD & C)', 'user_1760181061561_ox8g3ct5w', NULL, 'BN60570', 1, 1, 1, 64, 3, 96, '+88021160570', NULL, NULL, 'user60570@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$cjk09rM3wrGzOD/d61tVk.YjBbh9Y6v7bCvgibhONehCXesl4PAQW', NULL, 1, '2025-10-11 11:11:01', '2025-10-11 11:11:01'),
	(137, 'ACNS (O)', 'user_1760186020587_4cmq9oe3q', NULL, 'BN19737', 1, 1, 1, 68, 3, 98, '+88021119737', NULL, NULL, 'user19737@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$q.H4Wf4VNm7bdXF1.OMFKe4uqoTcgGRrC7r90BpWekVstkhXMOsAK', NULL, 1, '2025-10-11 12:33:40', '2025-10-11 12:33:40'),
	(138, 'Coord to ACNS (O)', 'user_1760186029785_otr2ui7eh', NULL, 'BN28869', 1, 1, 1, 68, 3, 99, '+88021128869', NULL, NULL, 'user28869@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$wAHx6.orY836Ef007CYqJu9CTOMzed27UtzjYuCcfiy8JnuWpQEAC', NULL, 1, '2025-10-11 12:33:49', '2025-10-11 12:33:49'),
	(139, 'DDNO', 'user_1760186212955_15efnaeds', NULL, 'BN10944', 1, 1, 1, 69, 3, 100, '+880211210944', NULL, NULL, 'user10944@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$69cNbv0X51qgEF9Afqn6LOaokIlRct69YvDVmZWxnDFu2KX.WVQnC', NULL, 1, '2025-10-11 12:36:53', '2025-10-11 12:36:53'),
	(140, 'SO (O)', 'user_1760186219115_k5ll2mx29', NULL, 'BN18124', 1, 1, 1, 69, 3, 101, '+880211218124', NULL, NULL, 'user18124@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$4dZbgHGtajbsE.orgU6Heu50EeMsN7pAUBqsYVBV1aVjhXSibePui', NULL, 1, '2025-10-11 12:36:59', '2025-10-11 12:36:59'),
	(141, 'SO (Ops Plan)', 'user_1760186231732_kppiftdaf', NULL, 'BN26901', 1, 1, 1, 69, 3, 102, '+880211226901', NULL, NULL, 'user26901@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$3UJ.IZcDTtbUVSbwf68XqOfOWJw8xpcEildeUF4GRqSuJpVN2urPC', NULL, 1, '2025-10-11 12:37:11', '2025-10-11 12:37:11'),
	(142, 'DDNI', 'user_1760186644358_viszknyo3', NULL, 'BN41340', 1, 1, 1, 70, 3, 103, '+880211641340', NULL, NULL, 'user41340@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$HmaAVkvKqGzDGcP5OvTXKOcK7Mq3TlNaabFIORgXMJYWTFfjJzytW', NULL, 1, '2025-10-11 12:44:04', '2025-10-11 12:44:04'),
	(143, 'SO (I)', 'user_1760186653067_weghretz6', NULL, 'BN52080', 1, 1, 1, 70, 3, 104, '+880211652080', NULL, NULL, 'user52080@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$zPWOqoB4AHx31vVYSll4B.L44XuBXiJuqP2r7IBI4Eymq.niT0Z6y', NULL, 1, '2025-10-11 12:44:13', '2025-10-11 12:44:13'),
	(144, 'SO (Cl)', 'user_1760186658617_i4uu7ct0g', NULL, 'BN57588', 1, 1, 1, 70, 3, 105, '+880211657588', NULL, NULL, 'user57588@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$t32rC9BSxlLfZ3LPBGbhL.ru3YVS3P/jI87848yV82JSOTSFgvN9K', NULL, 1, '2025-10-11 12:44:18', '2025-10-11 12:44:18'),
	(145, 'SO (Tec)', 'user_1760186663646_b4vz0soen', NULL, 'BN62706', 1, 1, 1, 70, 3, 106, '+880211662706', NULL, NULL, 'user62706@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$WYAliHqNJybuSZhsM9NLAeOqhhTpYSLh5LZVpDca2SL33Z3ayet9K', NULL, 1, '2025-10-11 12:44:23', '2025-10-11 12:44:23'),
	(146, 'SO (Media)', 'user_1760186668116_p5x1pc7g3', NULL, 'BN67211', 1, 1, 1, 70, 3, 107, '+880211667211', NULL, NULL, 'user67211@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$aF70F/xPGnkRE.69osK5auOfNwO11Lxw/6zLNi32UD0TYlOtQ8yUq', NULL, 1, '2025-10-11 12:44:28', '2025-10-11 12:44:28'),
	(147, 'DDNP', 'user_1760186753012_32ac6vs9l', NULL, 'BN51983', 1, 1, 1, 71, 3, 108, '+880211751983', NULL, NULL, 'user51983@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$GEOxEnmp6ZLyUkNKrMtYZec3CsA3u5zLL854M2CkHhP0jZ9NtemMu', NULL, 1, '2025-10-11 12:45:53', '2025-10-11 12:45:53'),
	(148, 'SO (Plan-1)', 'user_1760186764491_m79kcsjqe', NULL, 'BN63377', 1, 1, 1, 71, 3, 109, '+880211763377', NULL, NULL, 'user63377@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$1XY6aHQpzIykUWbobq90POHfFk/w7gPJsY49HhP4FGjjHn1ZZct4.', NULL, 1, '2025-10-11 12:46:04', '2025-10-11 12:46:04'),
	(149, 'SO (Plans-2)', 'user_1760186772186_8q5nr69lk', NULL, 'BN71257', 1, 1, 1, 71, 3, 110, '+880211771257', NULL, NULL, 'user71257@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$mINOPd4l.eFECljRpK7O4eLHloXu2XuvonDU0bTv8NQnnrYR3C2i2', NULL, 1, '2025-10-11 12:46:12', '2025-10-11 12:46:12'),
	(150, 'DD Sig', 'user_1760186835934_nd86g7g0i', NULL, 'BN33995', 1, 1, 1, 72, 3, 111, '+880211833995', NULL, NULL, 'user33995@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$JGIH.CaOmW/.zdaH2rxEDec8qESe5U.MxMy1U4udp1X1oeMEwDgxC', NULL, 1, '2025-10-11 12:47:16', '2025-10-11 12:47:16'),
	(151, 'SO (Sig)', 'user_1760186845383_5e2s8jckt', NULL, 'BN42769', 1, 1, 1, 72, 3, 112, '+880211842769', NULL, NULL, 'user42769@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$BeQPcTQajYTvJbAqafSjH.HlVxDHpBzCEj4CSoOkmsvgHh5jcbuuy', NULL, 1, '2025-10-11 12:47:25', '2025-10-11 12:47:25'),
	(152, 'DD Works', 'user_1760186897492_3j00rd8y5', NULL, 'BN96217', 1, 1, 1, 73, 3, 113, '+880211896217', NULL, NULL, 'user96217@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$ySCvOU39bVvveXg2urrP9OsHCiC.ts3wYeKSMCWJ6vwpqBrZ/aBDe', NULL, 1, '2025-10-11 12:48:17', '2025-10-11 12:48:17'),
	(153, 'SO (Works)', 'user_1760186908062_m5a1xkiey', NULL, 'BN7110', 1, 1, 1, 73, 3, 114, '+880211907110', NULL, NULL, 'user7110@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$KYPllYFxE9FyL1vkJMIEOu9njzc8cd6YdwnEs5GBYk7E9r8Iszi/O', NULL, 1, '2025-10-11 12:48:28', '2025-10-11 12:48:28'),
	(154, 'DD Nav', 'user_1760186947152_mbhjp8z0o', NULL, 'BN46292', 1, 1, 1, 74, 3, 115, '+880211946292', NULL, NULL, 'user46292@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$ehleaVkpnA7z6OzJhGlD5eCHKAzmE3/WbLx2dZzuIn2AOcVd4mWvi', NULL, 1, '2025-10-11 12:49:07', '2025-10-11 12:49:07'),
	(155, 'SO (Nav)', 'user_1760186953771_jkv587zj4', NULL, 'BN52827', 1, 1, 1, 74, 3, 116, '+880211952827', NULL, NULL, 'user52827@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$fjuvOoQZO3h5C4ww1KXrh.2PJV.C4iFK9ryGeE9QCYRSxnL0W.2f2', NULL, 1, '2025-10-11 12:49:13', '2025-10-11 12:49:13'),
	(156, 'DD Hydro', 'user_1760186998566_p16trms93', NULL, 'BN97585', 1, 1, 1, 75, 3, 117, '+880211997585', NULL, NULL, 'user97585@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$QgBlDybohQnOWNZyiItWgO8YytoVJopzBZR2DY9EKvlhYtu2ZXZZW', NULL, 1, '2025-10-11 12:49:58', '2025-10-11 12:49:58'),
	(157, 'SO (Hydro)', 'user_1760187006095_6xvnv4l4r', NULL, 'BN4931', 1, 1, 1, 75, 3, 118, '+8802114931', NULL, NULL, 'user4931@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Aqm3aXIiariasrcoNi3YxuI7eEA7m9EhX/ocO.6Tbs2ImHxFBmS9e', NULL, 1, '2025-10-11 12:50:06', '2025-10-11 12:50:06'),
	(158, 'Capt Staff', 'user_1760187133172_51u7bovui', NULL, 'BN31615', 1, 1, 1, 76, 3, 119, '+880211131615', NULL, NULL, 'user31615@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$mGqcRI9YfMEeomTbQyG7ruFtgvIuyOzidwYChghcmD69.ywG1QKle', NULL, 1, '2025-10-11 12:52:13', '2025-10-11 12:52:13'),
	(159, 'DD Sub', 'user_1760187141122_rjglt6nw5', NULL, 'BN40182', 1, 1, 1, 76, 3, 120, '+880211140182', NULL, NULL, 'user40182@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$wFnZH.aFDbaNAItNbQxJXeXEOLX3MKiINnBBpySphnh1klYvNAipS', NULL, 1, '2025-10-11 12:52:21', '2025-10-11 12:52:21'),
	(160, 'DD Sub (Tec)', 'user_1760187149403_ynaptsz5g', NULL, 'BN48595', 1, 1, 1, 76, 3, 121, '+880211148595', NULL, NULL, 'user48595@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$9hW62fGiNFqEI9T1ZBWpYeIP8lWwfsoW2tUn80aeHIun9laO8ZPQK', NULL, 1, '2025-10-11 12:52:29', '2025-10-11 12:52:29'),
	(161, 'So (Sub)', 'user_1760187156190_fmh296fud', NULL, 'BN53662', 1, 1, 1, 76, 3, 122, '+880211153662', NULL, NULL, 'user53662@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$4QA65vMCKfxUPYdfnO6iDet0f1V4Ah0yq6OT1b1/.1RjtSbhsBIDK', NULL, 1, '2025-10-11 12:52:36', '2025-10-11 12:52:36'),
	(162, 'DD Spl Ops', 'user_1760187219405_y243j1vd5', NULL, 'BN17574', 1, 1, 1, 77, 3, 123, '+880211217574', NULL, NULL, 'user17574@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$tzeROYZnu2nPBdGoVbZGQedS9o3VLAD6HOaY6BK51wDYUURpL1qsa', NULL, 1, '2025-10-11 12:53:39', '2025-10-11 12:53:39'),
	(163, 'SO (Spl Ops)', 'user_1760187226320_2guc699n8', NULL, 'BN25452', 1, 1, 1, 77, 3, 124, '+880211225452', NULL, NULL, 'user25452@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$.8gT485yXdS4rBFDJduv1.lK5DLckr0lXdrfglpwgg.BxjT8WL9Fi', NULL, 1, '2025-10-11 12:53:46', '2025-10-11 12:53:46'),
	(164, 'DD SD & C', 'user_1760187305370_m1htdfprj', NULL, 'BN94503', 1, 1, 1, 78, 3, 125, '+880211294503', NULL, NULL, 'user94503@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$9Ol0OR62laS.BtcObYRfBulU5EnWT3nEQLTZbwdnLBcIDFpoKVZBa', NULL, 1, '2025-10-11 12:55:05', '2025-10-11 12:55:05'),
	(165, 'SO (SD & C)', 'user_1760187314464_9vhv745jz', NULL, 'BN10973', 1, 1, 1, 78, 3, 126, '+880211310973', NULL, NULL, 'user10973@navy.mil.bd', NULL, 'offline', NULL, '$2a$12$Wb.kQVB9eKMVl5.PsUI6/OtOjwjB6gGu33ALu/pSz8npaxzREIm52', NULL, 1, '2025-10-11 12:55:14', '2025-10-11 12:55:14');

-- Dumping structure for table cms_db.user_permissions
CREATE TABLE IF NOT EXISTS `user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `granted_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_permission` (`user_id`,`permission_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_permission_id` (`permission_id`),
  KEY `idx_granted_by` (`granted_by`),
  CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_permissions_ibfk_3` FOREIGN KEY (`granted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.user_permissions: ~0 rows (approximately)

-- Dumping structure for table cms_db.user_preferences
CREATE TABLE IF NOT EXISTS `user_preferences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `preference_key` varchar(100) NOT NULL,
  `preference_value` text DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_preference` (`user_id`,`preference_key`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_preference_key` (`preference_key`),
  CONSTRAINT `user_preferences_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.user_preferences: ~0 rows (approximately)

-- Dumping structure for table cms_db.user_sessions
CREATE TABLE IF NOT EXISTS `user_sessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `session_token` varchar(255) NOT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `expires_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `session_token` (`session_token`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_session_token` (`session_token`),
  KEY `idx_expires_at` (`expires_at`),
  CONSTRAINT `user_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table cms_db.user_sessions: ~0 rows (approximately)

-- Dumping structure for view cms_db.user_statistics
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `user_statistics` (
	`total_users` BIGINT(21) NOT NULL,
	`online_users` BIGINT(21) NOT NULL,
	`offline_users` BIGINT(21) NOT NULL,
	`busy_users` BIGINT(21) NOT NULL,
	`super_admins` BIGINT(21) NOT NULL,
	`admins` BIGINT(21) NOT NULL,
	`regular_users` BIGINT(21) NOT NULL
);

-- Dumping structure for trigger cms_db.log_user_update
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER `log_user_update` AFTER UPDATE ON `users` FOR EACH ROW BEGIN
    IF (OLD.name != NEW.name) OR (OLD.email != NEW.email) OR (OLD.phone != NEW.phone) THEN
        INSERT INTO audit_logs (user_id, action, target_type, target_id, target_name, details)
        VALUES (NEW.id, 'USER_UPDATED', 'user', NEW.id, NEW.name,
                CONCAT(
                    CASE WHEN OLD.name != NEW.name THEN CONCAT('name from \"', OLD.name, '\" to \"', NEW.name, '\"; ') ELSE '' END,
                    CASE WHEN OLD.email != NEW.email THEN CONCAT('email from \"', OLD.email, '\" to \"', NEW.email, '\"; ') ELSE '' END,
                    CASE WHEN OLD.phone != NEW.phone THEN CONCAT('phone from \"', OLD.phone, '\" to \"', NEW.phone, '\";') ELSE '' END
                ));
    END IF;
END//
DELIMITER ;

-- Dumping structure for trigger cms_db.update_last_seen_on_status_change
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER `update_last_seen_on_status_change` BEFORE UPDATE ON `users` FOR EACH ROW BEGIN
    IF NEW.status = 'online' AND OLD.status != 'online' THEN
        SET NEW.last_seen = CURRENT_TIMESTAMP;
    END IF;
END//
DELIMITER ;

-- Removing temporary table and create final VIEW structure
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `conversation_summary` AS select `c`.`id` AS `id`,`c`.`type` AS `type`,`c`.`name` AS `name`,count(distinct `cp`.`user_id`) AS `participant_count`,count(`m`.`id`) AS `message_count`,max(`m`.`created_at`) AS `last_message_at`,`c`.`created_at` AS `created_at`,`c`.`updated_at` AS `updated_at` from ((`conversations` `c` left join `conversation_participants` `cp` on((`c`.`id` = `cp`.`conversation_id`))) left join `messages` `m` on((`c`.`id` = `m`.`conversation_id`))) group by `c`.`id`,`c`.`type`,`c`.`name`,`c`.`created_at`,`c`.`updated_at` 
;

-- Removing temporary table and create final VIEW structure
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `message_statistics` AS select cast(`messages`.`created_at` as date) AS `message_date`,count(0) AS `total_messages`,count((case when (`messages`.`type` = 'text') then 1 end)) AS `text_messages`,count((case when (`messages`.`type` = 'system') then 1 end)) AS `system_messages`,count(distinct `messages`.`sender_id`) AS `unique_senders` from `messages` group by cast(`messages`.`created_at` as date) 
;

-- Removing temporary table and create final VIEW structure
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `user_statistics` AS select count(0) AS `total_users`,count((case when (`users`.`status` = 'online') then 1 end)) AS `online_users`,count((case when (`users`.`status` = 'offline') then 1 end)) AS `offline_users`,count((case when (`users`.`status` = 'busy') then 1 end)) AS `busy_users`,count((case when (`users`.`role_id` = 1) then 1 end)) AS `super_admins`,count((case when (`users`.`role_id` = 2) then 1 end)) AS `admins`,count((case when (`users`.`role_id` = 3) then 1 end)) AS `regular_users` from `users` where (`users`.`is_active` = true) 
;

