-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `mini`
--

-- --------------------------------------------------------

--
-- Table structure for table `isn_accommodation_types`
--

CREATE TABLE `isn_accommodation_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(30) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_accommodation_types`
--

INSERT INTO `isn_accommodation_types` (`id`, `name`, `color`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Dubai 2', 'red', NULL, 10, '2024-06-06 17:16:30', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Shareqa', 'green', NULL, 10, '2024-06-06 17:16:45', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_action`
--

CREATE TABLE `isn_action` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_action`
--

INSERT INTO `isn_action` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'create', NULL, NULL, '2024-05-21 19:09:01', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'get_all', NULL, NULL, '2024-05-21 19:30:48', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'delete', NULL, NULL, '2024-05-25 05:38:20', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(4, 'update', NULL, NULL, '2024-05-25 06:23:14', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 'restore', NULL, NULL, '2024-05-25 17:02:37', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(6, 'search', NULL, NULL, '2024-05-25 17:02:53', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_allowances`
--

CREATE TABLE `isn_allowances` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_allowances`
--

INSERT INTO `isn_allowances` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Housing Allowance', NULL, 10, '2024-06-06 19:16:11', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Transportation Allowance', NULL, 10, '2024-06-06 19:16:26', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'Communication Allowance', NULL, 10, '2024-06-06 19:16:47', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_approvals`
--

CREATE TABLE `isn_approvals` (
  `ID` int(11) NOT NULL,
  `rtable` int(11) NOT NULL,
  `record_id` int(11) NOT NULL,
  `Status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `Reply_by` int(11) DEFAULT NULL,
  `Reply_at` datetime DEFAULT NULL,
  `rejected_reason` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_approvals`
--

INSERT INTO `isn_approvals` (`ID`, `rtable`, `record_id`, `Status`, `Reply_by`, `Reply_at`, `rejected_reason`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 1, 1, 'rejected', 1, NULL, 'rejected', 39, '2024-06-16 18:51:28', '2024-06-16 18:54:25', 39, '2024-06-16 18:58:24', 39, '2024-06-16 18:58:52', 39, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_assessment_reading_type`
--

CREATE TABLE `isn_assessment_reading_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `unit_id` int(11) NOT NULL,
  `asset_id` int(11) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_assessment_reading_type`
--

INSERT INTO `isn_assessment_reading_type` (`id`, `name`, `description`, `color`, `unit_id`, `asset_id`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, '', 'test', NULL, 1, 1, 39, '2024-06-19 09:18:10', '2024-06-19 09:19:42', 39, '2024-06-19 09:30:22', 39, '2024-06-19 09:30:51', 39, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_assets`
--

CREATE TABLE `isn_assets` (
  `Id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `Title` varchar(255) NOT NULL,
  `Description` text DEFAULT NULL,
  `Serial_Number` varchar(255) DEFAULT NULL,
  `Model_id` int(11) NOT NULL,
  `manufacturer_id` int(11) NOT NULL,
  `Year` year(4) DEFAULT NULL,
  `asset_type_id` int(11) NOT NULL,
  `asset_barcode` varchar(255) DEFAULT NULL,
  `asset_status_id` int(11) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_assets`
--

INSERT INTO `isn_assets` (`Id`, `location_id`, `client_id`, `Title`, `Description`, `Serial_Number`, `Model_id`, `manufacturer_id`, `Year`, `asset_type_id`, `asset_barcode`, `asset_status_id`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 1, 1, 'My Asset 2024', 'test', NULL, 2, 1, NULL, 1, NULL, 1, 39, '2024-06-16 07:41:11', '2024-06-16 07:43:05', 39, '2024-06-16 07:57:06', 39, '2024-06-16 07:57:26', 39, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_assets_model`
--

CREATE TABLE `isn_assets_model` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_assets_model`
--

INSERT INTO `isn_assets_model` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'CoolBreeze 3000', NULL, NULL, 39, '2024-06-15 18:45:11', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'AquaChill 450', NULL, NULL, 39, '2024-06-15 18:46:15', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'EcoCool Pro', NULL, NULL, 39, '2024-06-15 18:46:26', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_assets_status`
--

CREATE TABLE `isn_assets_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_assets_status`
--

INSERT INTO `isn_assets_status` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'In Use', NULL, NULL, 39, '2024-06-15 18:50:15', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Available', NULL, NULL, 39, '2024-06-15 18:50:27', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'Under Maintenance', NULL, NULL, 39, '2024-06-15 18:50:38', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(4, 'Disposed', NULL, NULL, 39, '2024-06-15 18:50:51', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 'Lost', NULL, NULL, 39, '2024-06-15 18:50:58', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_assets_type`
--

CREATE TABLE `isn_assets_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_assets_type`
--

INSERT INTO `isn_assets_type` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Desktop Computer', NULL, NULL, 39, '2024-06-15 18:48:30', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Laptop Computer', NULL, NULL, 39, '2024-06-15 18:48:42', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'Printer', NULL, NULL, 39, '2024-06-15 18:48:50', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_attendance`
--

CREATE TABLE `isn_attendance` (
  `Id` int(11) NOT NULL,
  `emp_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `attended` tinyint(1) DEFAULT NULL,
  `is_holiday` tinyint(1) NOT NULL DEFAULT 0,
  `overtime` int(11) DEFAULT NULL,
  `cost` decimal(10,2) NOT NULL DEFAULT 0.00,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_attendance`
--

INSERT INTO `isn_attendance` (`Id`, `emp_id`, `date`, `attended`, `is_holiday`, `overtime`, `cost`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(3, 9, '2024-06-11', 1, 0, 4, 10000.00, 39, '2024-06-11 16:52:44', '2024-06-11 19:06:54', 39, '2024-06-11 17:14:56', 39, '2024-06-11 17:15:21', 39, 0, ' salary_per_day= 2000'),
(4, 8, '2024-06-09', 1, 0, 3, 6250.00, 39, '2024-06-11 16:58:53', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Worked on project XSun 1666.6666666667 6250'),
(5, 8, '2024-06-09', 1, 1, 3, 6250.00, 39, '2024-06-11 17:08:58', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Worked on project X salary_per_day= 1666.6666666667'),
(6, 8, '2024-06-11', 1, 0, 3, 5208.33, 39, '2024-06-11 17:09:32', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Worked on project X salary_per_day= 1666.6666666667'),
(7, 8, '2024-06-11', 1, 0, 3, 5208.33, 39, '2024-06-11 17:10:26', NULL, NULL, NULL, NULL, NULL, NULL, 0, ' salary_per_day= 1666.6666666667'),
(8, 8, '2024-06-11', 1, 0, 3, 5208.33, 39, '2024-06-11 17:33:43', NULL, NULL, NULL, NULL, NULL, NULL, 0, ' salary_per_day= 1666.6666666667');

-- --------------------------------------------------------

--
-- Table structure for table `isn_budget_status`
--

CREATE TABLE `isn_budget_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_budget_types`
--

CREATE TABLE `isn_budget_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_camps`
--

CREATE TABLE `isn_camps` (
  `Id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `city_id` int(11) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `map` varchar(255) DEFAULT NULL,
  `camp_supervisor` int(11) DEFAULT NULL,
  `camp_capacity` int(11) DEFAULT NULL,
  `camp_current_number_of_residents` int(11) DEFAULT NULL,
  `camp_code` varchar(255) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_camps`
--

INSERT INTO `isn_camps` (`Id`, `title`, `city_id`, `location`, `map`, `camp_supervisor`, `camp_capacity`, `camp_current_number_of_residents`, `camp_code`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Camp Alpha 2', 1, 'North Sector', 'http://maps.example.com/camp-alpha', 8, 200, NULL, '', 10, '2024-06-09 17:49:22', '2024-06-09 17:50:20', 10, '2024-06-09 17:50:54', 10, '2024-06-09 17:51:16', 10, 0, 'Nothing'),
(2, 'Camp 2', 1, 'North city', 'http://maps.example.com/camp-alpha', 10, 200, NULL, 'cam_2', 10, '2024-06-09 17:53:28', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_category_list`
--

CREATE TABLE `isn_category_list` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_city`
--

CREATE TABLE `isn_city` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_city`
--

INSERT INTO `isn_city` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Dubai', NULL, NULL, '2024-05-21 18:46:15', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'al-shareqa', NULL, 10, '2024-06-01 07:25:52', '2024-06-01 07:32:24', 10, '2024-06-01 07:46:36', 10, '2024-06-01 07:55:40', 10, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_clients`
--

CREATE TABLE `isn_clients` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_Addon` varchar(255) DEFAULT NULL,
  `Client_Code` varchar(255) NOT NULL,
  `Client_Type_id` int(11) NOT NULL,
  `Mobile` varchar(20) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `City_id` int(11) NOT NULL,
  `Address_Line_1` varchar(255) DEFAULT NULL,
  `Address_Line_2` varchar(255) DEFAULT NULL,
  `Client_Status_id` int(11) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_clients`
--

INSERT INTO `isn_clients` (`id`, `name`, `name_Addon`, `Client_Code`, `Client_Type_id`, `Mobile`, `Email`, `City_id`, `Address_Line_1`, `Address_Line_2`, `Client_Status_id`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Ali', NULL, 'cli_1', 1, NULL, 'dan@gmail.com', 1, 'Address_Line_1_value', NULL, 1, 10, '2024-06-03 19:35:25', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 'Mohammad', NULL, 'cli_2', 1, NULL, 'da1n@gmail.com', 1, 'Address_Line_1_value', NULL, 1, 10, '2024-06-03 19:40:32', '2024-06-03 19:42:04', 10, '2024-06-03 19:43:08', 10, '2024-06-03 19:43:32', 10, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_client_invoices_status`
--

CREATE TABLE `isn_client_invoices_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_client_status`
--

CREATE TABLE `isn_client_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_client_status`
--

INSERT INTO `isn_client_status` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'active', NULL, 'green', 10, '2024-06-03 18:56:43', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'inactive', NULL, 'red', 10, '2024-06-03 18:56:56', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_client_type`
--

CREATE TABLE `isn_client_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_client_type`
--

INSERT INTO `isn_client_type` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'company', NULL, NULL, 10, '2024-06-03 18:54:41', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_contracts`
--

CREATE TABLE `isn_contracts` (
  `id` int(11) NOT NULL,
  `contact_number` varchar(255) NOT NULL,
  `client_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `contract_type_id` int(11) NOT NULL,
  `contract_amount` decimal(10,2) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` enum('Active','Inactive','Expired') NOT NULL DEFAULT 'Active',
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_contracts`
--

INSERT INTO `isn_contracts` (`id`, `contact_number`, `client_id`, `start_date`, `end_date`, `contract_type_id`, `contract_amount`, `description`, `status`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'cnt_1', 5, '2024-06-01', '2025-06-01', 2, 15000.75, 'description', 'Inactive', 39, '2024-06-17 12:29:08', '2024-06-17 12:32:14', 39, '2024-06-17 12:32:36', 39, '2024-06-17 12:32:52', 39, 0, NULL),
(2, 'cnt_2', 5, '2024-06-01', '2025-06-01', 2, 15000.75, 'This contract', 'Active', 39, '2024-06-17 12:30:32', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_contract_types`
--

CREATE TABLE `isn_contract_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_contract_types`
--

INSERT INTO `isn_contract_types` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Annual Maintenance Contract (AMC)', NULL, NULL, 39, '2024-06-17 09:47:51', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Comprehensive Annual Maintenance Contract (CAMC)', NULL, NULL, 39, '2024-06-17 09:48:53', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'Quarterly Maintenance Contract', NULL, NULL, 39, '2024-06-17 09:49:07', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(4, 'Monthly Maintenance Contract', NULL, NULL, 39, '2024-06-17 09:49:21', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 'Ad-hoc Service Contract', NULL, NULL, 39, '2024-06-17 09:49:30', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(6, 'Emergency Service Contract', NULL, NULL, 39, '2024-06-17 09:49:42', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_department`
--

CREATE TABLE `isn_department` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_department`
--

INSERT INTO `isn_department` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'IT', NULL, NULL, '2024-05-21 18:46:33', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'finance', NULL, NULL, '2024-05-21 18:46:33', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_departments_codes`
--

CREATE TABLE `isn_departments_codes` (
  `Id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `dept_id` int(11) NOT NULL,
  `code_number` varchar(10) NOT NULL,
  `job_description` text DEFAULT NULL,
  `color` varchar(7) DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_departments_codes`
--

INSERT INTO `isn_departments_codes` (`Id`, `title`, `dept_id`, `code_number`, `job_description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Software Engineer 2024', 2, 'dc_1', 'Responsible for developing and maintaining software applications. 2024', '#FF0000', 10, '2024-06-06 18:57:24', '2024-06-06 19:04:02', 10, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Data Analyst', 0, 'dc_2', 'Analyzes data to support business decisions.', '#17A2B8', 10, '2024-06-06 18:57:57', NULL, NULL, '2024-06-06 19:04:41', 10, '2024-06-06 19:05:31', 10, 0, NULL),
(3, 'UI/UX Designer', 1, 'dc_3', 'Designs user interfaces and user experiences.', '#FFC107', 10, '2024-06-06 19:01:39', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_doc_types`
--

CREATE TABLE `isn_doc_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_doc_types`
--

INSERT INTO `isn_doc_types` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'cv', NULL, 10, '2024-06-06 16:41:22', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'certificate', NULL, 10, '2024-06-06 16:41:34', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'avatar', NULL, 10, '2024-06-06 16:41:47', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_enquery_locations`
--

CREATE TABLE `isn_enquery_locations` (
  `id` int(11) NOT NULL,
  `enquery_id` int(11) NOT NULL,
  `locations_id` int(11) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_enquiry`
--

CREATE TABLE `isn_enquiry` (
  `id` int(11) NOT NULL,
  `enquiry_number` varchar(255) NOT NULL,
  `client_id` int(11) NOT NULL,
  `requested_by` varchar(255) NOT NULL,
  `reported_by` int(11) NOT NULL,
  `priority_id` int(11) NOT NULL,
  `request_date` date NOT NULL,
  `expected_start_date` date DEFAULT NULL,
  `next_follow_up` date DEFAULT NULL,
  `contract_id` int(11) NOT NULL,
  `work_description` text NOT NULL,
  `special_instructions` text DEFAULT NULL,
  `status_id` int(11) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_enquiry`
--

INSERT INTO `isn_enquiry` (`id`, `enquiry_number`, `client_id`, `requested_by`, `reported_by`, `priority_id`, `request_date`, `expected_start_date`, `next_follow_up`, `contract_id`, `work_description`, `special_instructions`, `status_id`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'enq_1', 1, '', 8, 1, '2024-06-17', '2024-06-20', '2024-06-22', 2, 'Detailed description of the work requested', NULL, 2, 39, '2024-06-17 16:49:16', '2024-06-17 16:50:11', 39, '2024-06-17 16:50:49', 39, '2024-06-17 16:51:14', 39, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_enquiry_status`
--

CREATE TABLE `isn_enquiry_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_enquiry_status`
--

INSERT INTO `isn_enquiry_status` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Pending', NULL, 39, '2024-06-17 09:40:02', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Approved', NULL, 39, '2024-06-17 09:40:15', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'Rejected', NULL, 39, '2024-06-17 09:40:25', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(4, 'In Progress', NULL, 39, '2024-06-17 09:40:49', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 'Completed', NULL, 39, '2024-06-17 09:40:59', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(6, 'On Hold', NULL, 39, '2024-06-17 09:41:09', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(7, 'Cancelled', NULL, 39, '2024-06-17 09:41:18', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_estimation_line_type`
--

CREATE TABLE `isn_estimation_line_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_estimation_line_unit`
--

CREATE TABLE `isn_estimation_line_unit` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_estimation_status`
--

CREATE TABLE `isn_estimation_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_estimation_type`
--

CREATE TABLE `isn_estimation_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_estimation_types`
--

CREATE TABLE `isn_estimation_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_exclusions_list`
--

CREATE TABLE `isn_exclusions_list` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_expenses_category`
--

CREATE TABLE `isn_expenses_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_files`
--

CREATE TABLE `isn_files` (
  `id` int(11) NOT NULL,
  `table_id` int(11) NOT NULL,
  `record_id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `doc_type_id` int(11) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_files`
--

INSERT INTO `isn_files` (`id`, `table_id`, `record_id`, `file_name`, `description`, `title`, `doc_type_id`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(4, 1, 39, '6661dbb65aec2.png', NULL, 'dw', 3, 10, '2024-06-06 16:54:30', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 1, 39, '2024.pdf', NULL, 'dw', 1, 10, '2024-06-06 16:54:30', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_locations`
--

CREATE TABLE `isn_locations` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `city_id` int(11) NOT NULL,
  `address_line_1` varchar(255) NOT NULL,
  `address_line_2` varchar(255) DEFAULT NULL,
  `maps_url` varchar(255) DEFAULT NULL,
  `location_status_id` int(11) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_locations`
--

INSERT INTO `isn_locations` (`id`, `client_id`, `title`, `description`, `city_id`, `address_line_1`, `address_line_2`, `maps_url`, `location_status_id`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 1, 'Main Office 2024', 'Main corporate 2024', 1, '123 Main St 2024', 'Suite 2024', 'https://maps.example.com/?q=123+Main+St+New+York', 1, 39, '2024-06-14 19:34:05', '2024-06-14 19:35:34', 39, '2024-06-14 19:36:25', 39, '2024-06-14 19:36:45', 39, 0, 'No additional notes.');

-- --------------------------------------------------------

--
-- Table structure for table `isn_location_inventory_id`
--

CREATE TABLE `isn_location_inventory_id` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_location_status`
--

CREATE TABLE `isn_location_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_location_status`
--

INSERT INTO `isn_location_status` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'active', NULL, NULL, 39, '2024-06-14 19:13:15', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'inactive', NULL, NULL, 39, '2024-06-14 19:13:24', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_manufacturer`
--

CREATE TABLE `isn_manufacturer` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_manufacturer`
--

INSERT INTO `isn_manufacturer` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'LG Electronics', NULL, NULL, 39, '2024-06-15 18:36:35', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Samsung Electronics', NULL, NULL, 39, '2024-06-15 18:36:49', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'Daikin Industries', NULL, NULL, 39, '2024-06-15 18:36:59', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(4, 'Mitsubishi Electric', NULL, NULL, 39, '2024-06-15 18:37:14', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_payment_method`
--

CREATE TABLE `isn_payment_method` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_payment_term_list`
--

CREATE TABLE `isn_payment_term_list` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_permissions`
--

CREATE TABLE `isn_permissions` (
  `id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `table_id` int(11) NOT NULL,
  `action_id` int(11) NOT NULL,
  `allowed` tinyint(1) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_permissions`
--

INSERT INTO `isn_permissions` (`id`, `role_id`, `table_id`, `action_id`, `allowed`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 1, 1, 1, 1, 1, '2024-05-21 20:10:01', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 1, 1, 2, 1, NULL, '2024-05-21 19:31:03', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 2, 1, 2, 1, NULL, '2024-05-25 05:38:59', '2024-05-28 20:39:07', 10, NULL, NULL, NULL, NULL, 0, NULL),
(4, 1, 1, 4, 1, NULL, '2024-05-25 05:38:59', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 2, 1, 3, 1, NULL, '2024-05-25 05:38:59', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(6, 1, 1, 1, 1, 10, '2024-05-28 20:38:03', NULL, NULL, '2024-05-28 20:40:10', 10, '2024-05-28 20:42:07', 10, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_permission_roles`
--

CREATE TABLE `isn_permission_roles` (
  `id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_permission_roles`
--

INSERT INTO `isn_permission_roles` (`id`, `permission_id`, `role_id`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 1, 1, NULL, '2024-05-21 19:13:09', '2024-05-21 19:13:09', NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 2, 1, NULL, '2024-05-21 19:31:31', '2024-05-21 19:31:31', NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 3, 1, NULL, '2024-05-25 05:39:52', '2024-05-25 05:39:52', NULL, NULL, NULL, NULL, NULL, 0, NULL),
(4, 4, 1, NULL, '2024-05-25 05:39:52', '2024-05-25 05:39:52', NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 5, 2, NULL, '2024-05-25 05:39:52', '2024-05-25 17:00:36', NULL, NULL, NULL, NULL, NULL, 0, NULL),
(6, 3, 2, 10, '2024-05-28 20:52:31', '2024-05-28 19:55:05', 10, '2024-05-28 20:54:09', 10, '2024-05-28 20:55:05', 10, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_positions`
--

CREATE TABLE `isn_positions` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_positions`
--

INSERT INTO `isn_positions` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Project Manager', NULL, 10, '2024-06-06 19:09:22', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Data Analyst', NULL, 10, '2024-06-06 19:09:36', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'UI/UX Designer', NULL, 10, '2024-06-06 19:09:47', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_priority_list`
--

CREATE TABLE `isn_priority_list` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_priority_list`
--

INSERT INTO `isn_priority_list` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'High', NULL, NULL, 39, '2024-06-17 09:43:49', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Medium', NULL, NULL, 39, '2024-06-17 09:43:58', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'Low', NULL, NULL, 39, '2024-06-17 09:44:17', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(4, 'Urgent', NULL, NULL, 39, '2024-06-17 09:45:08', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(5, 'Routine', NULL, NULL, 39, '2024-06-17 09:45:13', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_promotion`
--

CREATE TABLE `isn_promotion` (
  `Id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `emp_id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `value` decimal(10,2) DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_promotion`
--

INSERT INTO `isn_promotion` (`Id`, `title`, `emp_id`, `description`, `value`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Senior Developer Promotion 2024', 8, NULL, 1800.00, 10, '2024-06-06 19:36:14', '2024-06-09 17:23:24', 10, '2024-06-09 17:30:02', 10, '2024-06-09 17:31:36', 10, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_roles`
--

CREATE TABLE `isn_roles` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_roles`
--

INSERT INTO `isn_roles` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'manager HR', NULL, 1, '2024-05-20 05:32:11', NULL, NULL, '2024-05-20 05:36:52', 1, NULL, NULL, 1, NULL),
(2, 'al-shareqa', 'operation department 2', 1, '2024-05-20 05:34:49', '2024-06-01 07:26:39', NULL, '2024-05-20 05:37:17', 1, NULL, NULL, 1, NULL),
(3, 'operation workers', NULL, 1, '2024-05-20 15:56:19', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(4, 'super admin', NULL, NULL, '2024-05-24 13:11:31', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(6, 'finance', 'invoices manager', 0, '2024-05-28 20:03:09', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(7, 'Workers 2', 'operation department 2', 10, '2024-05-28 20:06:31', '2024-05-28 20:17:57', 10, '2024-05-28 20:34:35', 10, '2024-05-28 20:34:15', 10, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_rule_evaluation_id`
--

CREATE TABLE `isn_rule_evaluation_id` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_rule_unit_id`
--

CREATE TABLE `isn_rule_unit_id` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_rule_unit_id`
--

INSERT INTO `isn_rule_unit_id` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Volt', NULL, NULL, 39, '2024-06-19 08:42:45', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_suppliers_list`
--

CREATE TABLE `isn_suppliers_list` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_suppliers_status`
--

CREATE TABLE `isn_suppliers_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_table`
--

CREATE TABLE `isn_table` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_table`
--

INSERT INTO `isn_table` (`id`, `name`, `description`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'users', 'company user', NULL, '2024-05-21 19:02:39', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_terms_list`
--

CREATE TABLE `isn_terms_list` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `isn_vacations`
--

CREATE TABLE `isn_vacations` (
  `Id` int(11) NOT NULL,
  `emp_id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `vacation_type_id` int(11) NOT NULL,
  `vacation_reason` text DEFAULT NULL,
  `approval_status` enum('Pending','Approved','Rejected','') DEFAULT 'Pending',
  `rejected_reason` text DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_vacations`
--

INSERT INTO `isn_vacations` (`Id`, `emp_id`, `start_date`, `end_date`, `vacation_type_id`, `vacation_reason`, `approval_status`, `rejected_reason`, `approved_by`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(3, 8, '2024-07-10', '2024-07-15', 2, 'I m tired', 'Approved', NULL, NULL, 39, '2024-06-15 17:57:09', '2024-06-15 18:03:44', 39, '2024-06-15 18:05:11', 39, '2024-06-15 18:05:38', 39, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_vacation_type`
--

CREATE TABLE `isn_vacation_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `isn_vacation_type`
--

INSERT INTO `isn_vacation_type` (`id`, `name`, `description`, `color`, `inserted_by`, `inserted_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `restored_at`, `restored_by`, `is_deleted`, `notes`) VALUES
(1, 'Sick Leave', 'Leave taken due to illness or medical reasons', NULL, 39, '2024-06-15 17:27:11', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 'Personal Leave', 'Leave taken for personal reasons or emergencies', NULL, 39, '2024-06-15 17:27:35', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 'Annual Leave', 'Paid leave for vacation or personal time off', NULL, 39, '2024-06-15 17:28:00', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `isn_work_type`
--

CREATE TABLE `isn_work_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inserted_by` int(11) DEFAULT NULL,
  `inserted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `restored_at` timestamp NULL DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `isn_accommodation_types`
--
ALTER TABLE `isn_accommodation_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_action`
--
ALTER TABLE `isn_action`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `isn_allowances`
--
ALTER TABLE `isn_allowances`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_approvals`
--
ALTER TABLE `isn_approvals`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `rtable` (`rtable`);

--
-- Indexes for table `isn_assessment_reading_type`
--
ALTER TABLE `isn_assessment_reading_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `asset_id` (`asset_id`),
  ADD KEY `unit_id` (`unit_id`);

--
-- Indexes for table `isn_assets`
--
ALTER TABLE `isn_assets`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `asset_status_id` (`asset_status_id`),
  ADD KEY `asset_type_id` (`asset_type_id`),
  ADD KEY `client_id` (`client_id`),
  ADD KEY `location_id` (`location_id`),
  ADD KEY `manufacturer_id` (`manufacturer_id`),
  ADD KEY `Model_id` (`Model_id`);

--
-- Indexes for table `isn_assets_model`
--
ALTER TABLE `isn_assets_model`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_assets_status`
--
ALTER TABLE `isn_assets_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_assets_type`
--
ALTER TABLE `isn_assets_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_attendance`
--
ALTER TABLE `isn_attendance`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `id` (`Id`),
  ADD KEY `Attendance_ibfk_1` (`emp_id`);

--
-- Indexes for table `isn_budget_status`
--
ALTER TABLE `isn_budget_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_budget_types`
--
ALTER TABLE `isn_budget_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_camps`
--
ALTER TABLE `isn_camps`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `camp_supervisor` (`camp_supervisor`);

--
-- Indexes for table `isn_category_list`
--
ALTER TABLE `isn_category_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_city`
--
ALTER TABLE `isn_city`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_clients`
--
ALTER TABLE `isn_clients`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `Client_Code` (`Client_Code`),
  ADD UNIQUE KEY `Email` (`Email`),
  ADD KEY `Client_Type_id` (`Client_Type_id`),
  ADD KEY `City_id` (`City_id`),
  ADD KEY `Client_Status_id` (`Client_Status_id`);

--
-- Indexes for table `isn_client_invoices_status`
--
ALTER TABLE `isn_client_invoices_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_client_status`
--
ALTER TABLE `isn_client_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_client_type`
--
ALTER TABLE `isn_client_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_contracts`
--
ALTER TABLE `isn_contracts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `client_id` (`client_id`),
  ADD KEY `contract_type_id` (`contract_type_id`);

--
-- Indexes for table `isn_contract_types`
--
ALTER TABLE `isn_contract_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_department`
--
ALTER TABLE `isn_department`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_departments_codes`
--
ALTER TABLE `isn_departments_codes`
  ADD PRIMARY KEY (`Id`),
  ADD UNIQUE KEY `code_number` (`code_number`);

--
-- Indexes for table `isn_doc_types`
--
ALTER TABLE `isn_doc_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_enquery_locations`
--
ALTER TABLE `isn_enquery_locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `isn_enquiry`
--
ALTER TABLE `isn_enquiry`
  ADD PRIMARY KEY (`id`),
  ADD KEY `priority_id` (`priority_id`),
  ADD KEY `status_id` (`status_id`),
  ADD KEY `reported_by` (`reported_by`),
  ADD KEY `isn_enquiry_ibfk_1` (`contract_id`),
  ADD KEY `client_id` (`client_id`);

--
-- Indexes for table `isn_enquiry_status`
--
ALTER TABLE `isn_enquiry_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_estimation_line_type`
--
ALTER TABLE `isn_estimation_line_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_estimation_line_unit`
--
ALTER TABLE `isn_estimation_line_unit`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_estimation_status`
--
ALTER TABLE `isn_estimation_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_estimation_type`
--
ALTER TABLE `isn_estimation_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_estimation_types`
--
ALTER TABLE `isn_estimation_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_exclusions_list`
--
ALTER TABLE `isn_exclusions_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_expenses_category`
--
ALTER TABLE `isn_expenses_category`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_files`
--
ALTER TABLE `isn_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `table_id` (`table_id`),
  ADD KEY `doc_type_id` (`doc_type_id`);

--
-- Indexes for table `isn_locations`
--
ALTER TABLE `isn_locations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `city_id` (`city_id`),
  ADD KEY `client_id` (`client_id`),
  ADD KEY `location_status_id` (`location_status_id`);

--
-- Indexes for table `isn_location_inventory_id`
--
ALTER TABLE `isn_location_inventory_id`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_location_status`
--
ALTER TABLE `isn_location_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_manufacturer`
--
ALTER TABLE `isn_manufacturer`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_payment_method`
--
ALTER TABLE `isn_payment_method`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_payment_term_list`
--
ALTER TABLE `isn_payment_term_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_permissions`
--
ALTER TABLE `isn_permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_id` (`role_id`),
  ADD KEY `table_id` (`table_id`);

--
-- Indexes for table `isn_permission_roles`
--
ALTER TABLE `isn_permission_roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `isn_positions`
--
ALTER TABLE `isn_positions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_priority_list`
--
ALTER TABLE `isn_priority_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_promotion`
--
ALTER TABLE `isn_promotion`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `emp_id` (`emp_id`);

--
-- Indexes for table `isn_roles`
--
ALTER TABLE `isn_roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `isn_rule_evaluation_id`
--
ALTER TABLE `isn_rule_evaluation_id`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_rule_unit_id`
--
ALTER TABLE `isn_rule_unit_id`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_suppliers_list`
--
ALTER TABLE `isn_suppliers_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_suppliers_status`
--
ALTER TABLE `isn_suppliers_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_table`
--
ALTER TABLE `isn_table`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_terms_list`
--
ALTER TABLE `isn_terms_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_vacations`
--
ALTER TABLE `isn_vacations`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `id` (`Id`),
  ADD KEY `approved_by` (`approved_by`),
  ADD KEY `vacation_type_id` (`vacation_type_id`),
  ADD KEY `Vacations_ibfk_1` (`emp_id`);

--
-- Indexes for table `isn_vacation_type`
--
ALTER TABLE `isn_vacation_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `isn_work_type`
--
ALTER TABLE `isn_work_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `isn_accommodation_types`
--
ALTER TABLE `isn_accommodation_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `isn_action`
--
ALTER TABLE `isn_action`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `isn_allowances`
--
ALTER TABLE `isn_allowances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `isn_approvals`
--
ALTER TABLE `isn_approvals`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_assessment_reading_type`
--
ALTER TABLE `isn_assessment_reading_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_assets`
--
ALTER TABLE `isn_assets`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_assets_model`
--
ALTER TABLE `isn_assets_model`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `isn_assets_status`
--
ALTER TABLE `isn_assets_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `isn_assets_type`
--
ALTER TABLE `isn_assets_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `isn_attendance`
--
ALTER TABLE `isn_attendance`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `isn_budget_status`
--
ALTER TABLE `isn_budget_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_budget_types`
--
ALTER TABLE `isn_budget_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_camps`
--
ALTER TABLE `isn_camps`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `isn_category_list`
--
ALTER TABLE `isn_category_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_city`
--
ALTER TABLE `isn_city`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `isn_clients`
--
ALTER TABLE `isn_clients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `isn_client_invoices_status`
--
ALTER TABLE `isn_client_invoices_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_client_status`
--
ALTER TABLE `isn_client_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `isn_client_type`
--
ALTER TABLE `isn_client_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_contracts`
--
ALTER TABLE `isn_contracts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `isn_contract_types`
--
ALTER TABLE `isn_contract_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `isn_department`
--
ALTER TABLE `isn_department`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `isn_departments_codes`
--
ALTER TABLE `isn_departments_codes`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `isn_doc_types`
--
ALTER TABLE `isn_doc_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `isn_enquery_locations`
--
ALTER TABLE `isn_enquery_locations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_enquiry`
--
ALTER TABLE `isn_enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_enquiry_status`
--
ALTER TABLE `isn_enquiry_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `isn_estimation_line_type`
--
ALTER TABLE `isn_estimation_line_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_estimation_line_unit`
--
ALTER TABLE `isn_estimation_line_unit`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_estimation_status`
--
ALTER TABLE `isn_estimation_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_estimation_type`
--
ALTER TABLE `isn_estimation_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_estimation_types`
--
ALTER TABLE `isn_estimation_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_exclusions_list`
--
ALTER TABLE `isn_exclusions_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_expenses_category`
--
ALTER TABLE `isn_expenses_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_files`
--
ALTER TABLE `isn_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `isn_locations`
--
ALTER TABLE `isn_locations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_location_inventory_id`
--
ALTER TABLE `isn_location_inventory_id`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_location_status`
--
ALTER TABLE `isn_location_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `isn_manufacturer`
--
ALTER TABLE `isn_manufacturer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `isn_payment_method`
--
ALTER TABLE `isn_payment_method`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_payment_term_list`
--
ALTER TABLE `isn_payment_term_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_permissions`
--
ALTER TABLE `isn_permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `isn_permission_roles`
--
ALTER TABLE `isn_permission_roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `isn_positions`
--
ALTER TABLE `isn_positions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `isn_priority_list`
--
ALTER TABLE `isn_priority_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `isn_promotion`
--
ALTER TABLE `isn_promotion`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_roles`
--
ALTER TABLE `isn_roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `isn_rule_evaluation_id`
--
ALTER TABLE `isn_rule_evaluation_id`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_rule_unit_id`
--
ALTER TABLE `isn_rule_unit_id`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_suppliers_list`
--
ALTER TABLE `isn_suppliers_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_suppliers_status`
--
ALTER TABLE `isn_suppliers_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_table`
--
ALTER TABLE `isn_table`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `isn_terms_list`
--
ALTER TABLE `isn_terms_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `isn_vacations`
--
ALTER TABLE `isn_vacations`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `isn_vacation_type`
--
ALTER TABLE `isn_vacation_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `isn_work_type`
--
ALTER TABLE `isn_work_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `isn_approvals`
--
ALTER TABLE `isn_approvals`
  ADD CONSTRAINT `isn_approvals_ibfk_1` FOREIGN KEY (`rtable`) REFERENCES `isn_table` (`id`);

--
-- Constraints for table `isn_assessment_reading_type`
--
ALTER TABLE `isn_assessment_reading_type`
  ADD CONSTRAINT `isn_assessment_reading_type_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `isn_assets` (`Id`),
  ADD CONSTRAINT `isn_assessment_reading_type_ibfk_2` FOREIGN KEY (`unit_id`) REFERENCES `isn_rule_unit_id` (`id`);

--
-- Constraints for table `isn_assets`
--
ALTER TABLE `isn_assets`
  ADD CONSTRAINT `isn_assets_ibfk_1` FOREIGN KEY (`asset_status_id`) REFERENCES `isn_assets_status` (`id`),
  ADD CONSTRAINT `isn_assets_ibfk_2` FOREIGN KEY (`asset_type_id`) REFERENCES `isn_assets_type` (`id`),
  ADD CONSTRAINT `isn_assets_ibfk_3` FOREIGN KEY (`client_id`) REFERENCES `isn_clients` (`id`),
  ADD CONSTRAINT `isn_assets_ibfk_4` FOREIGN KEY (`location_id`) REFERENCES `isn_locations` (`id`),
  ADD CONSTRAINT `isn_assets_ibfk_5` FOREIGN KEY (`manufacturer_id`) REFERENCES `isn_manufacturer` (`id`),
  ADD CONSTRAINT `isn_assets_ibfk_6` FOREIGN KEY (`Model_id`) REFERENCES `isn_assets_model` (`id`);

--
-- Constraints for table `isn_attendance`
--
ALTER TABLE `isn_attendance`
  ADD CONSTRAINT `Attendance_ibfk_1` FOREIGN KEY (`emp_id`) REFERENCES `isn_users` (`id`);

--
-- Constraints for table `isn_camps`
--
ALTER TABLE `isn_camps`
  ADD CONSTRAINT `isn_camps_ibfk_1` FOREIGN KEY (`camp_supervisor`) REFERENCES `isn_users` (`id`);

--
-- Constraints for table `isn_clients`
--
ALTER TABLE `isn_clients`
  ADD CONSTRAINT `isn_CLIENTS_ibfk_1` FOREIGN KEY (`Client_Type_id`) REFERENCES `isn_client_type` (`id`),
  ADD CONSTRAINT `isn_CLIENTS_ibfk_2` FOREIGN KEY (`City_id`) REFERENCES `isn_city` (`id`),
  ADD CONSTRAINT `isn_CLIENTS_ibfk_3` FOREIGN KEY (`Client_Status_id`) REFERENCES `isn_client_status` (`id`);

--
-- Constraints for table `isn_contracts`
--
ALTER TABLE `isn_contracts`
  ADD CONSTRAINT `isn_contracts_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `isn_clients` (`id`),
  ADD CONSTRAINT `isn_contracts_ibfk_2` FOREIGN KEY (`contract_type_id`) REFERENCES `isn_contract_types` (`id`);

--
-- Constraints for table `isn_enquiry`
--
ALTER TABLE `isn_enquiry`
  ADD CONSTRAINT `isn_enquiry_ibfk_1` FOREIGN KEY (`contract_id`) REFERENCES `isn_contracts` (`id`),
  ADD CONSTRAINT `isn_enquiry_ibfk_2` FOREIGN KEY (`priority_id`) REFERENCES `isn_priority_list` (`id`),
  ADD CONSTRAINT `isn_enquiry_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `isn_enquiry_status` (`id`),
  ADD CONSTRAINT `isn_enquiry_ibfk_4` FOREIGN KEY (`reported_by`) REFERENCES `isn_users` (`id`),
  ADD CONSTRAINT `isn_enquiry_ibfk_5` FOREIGN KEY (`client_id`) REFERENCES `isn_clients` (`id`);

--
-- Constraints for table `isn_files`
--
ALTER TABLE `isn_files`
  ADD CONSTRAINT `isn_files_ibfk_1` FOREIGN KEY (`doc_type_id`) REFERENCES `isn_doc_types` (`id`);

--
-- Constraints for table `isn_locations`
--
ALTER TABLE `isn_locations`
  ADD CONSTRAINT `isn_locations_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `isn_city` (`id`),
  ADD CONSTRAINT `isn_locations_ibfk_2` FOREIGN KEY (`client_id`) REFERENCES `isn_clients` (`id`),
  ADD CONSTRAINT `isn_locations_ibfk_3` FOREIGN KEY (`location_status_id`) REFERENCES `isn_location_status` (`id`);

--
-- Constraints for table `isn_permissions`
--
ALTER TABLE `isn_permissions`
  ADD CONSTRAINT `isn_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `isn_roles` (`id`),
  ADD CONSTRAINT `isn_permissions_ibfk_2` FOREIGN KEY (`table_id`) REFERENCES `isn_table` (`id`);

--
-- Constraints for table `isn_promotion`
--
ALTER TABLE `isn_promotion`
  ADD CONSTRAINT `isn_promotion_ibfk_1` FOREIGN KEY (`emp_id`) REFERENCES `isn_users` (`id`);

--
-- Constraints for table `isn_vacations`
--
ALTER TABLE `isn_vacations`
  ADD CONSTRAINT `Vacations_ibfk_1` FOREIGN KEY (`emp_id`) REFERENCES `isn_users` (`id`),
  ADD CONSTRAINT `isn_vacations_ibfk_2` FOREIGN KEY (`vacation_type_id`) REFERENCES `isn_vacation_type` (`id`);
COMMIT;

