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

START TRANSACTION;



--
-- Database: `prizeol_pass_creator`
--

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

--
-- Table structure for table `additional_fields`
--

CREATE TABLE `additional_fields` (
  `id` int(11) NOT NULL,
  `pass_id` int(11) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `field_name` varchar(255) NOT NULL,
  `field_type` varchar(100) NOT NULL,
  `required` tinyint(1) NOT NULL,
  `org_id` int(11) NOT NULL,
  `is_protected` tinyint(2) DEFAULT NULL,
  `protected_by` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `additional_field_values`
--

CREATE TABLE `additional_field_values` (
  `id` int(11) NOT NULL,
  `template_uid` varchar(255) NOT NULL,
  `field_uid` varchar(255) NOT NULL,
  `field_value` longtext NOT NULL,
  `pass_id` int(11) NOT NULL,
  `org_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `advance_settings`
--

CREATE TABLE `advance_settings` (
  `id` bigint(20) NOT NULL,
  `template_id` bigint(20) NOT NULL,
  `expire_type` varchar(100) DEFAULT NULL,
  `expire_data_type` varchar(255) NOT NULL,
  `expire_value` varchar(255) NOT NULL,
  `audit_log` varchar(5) NOT NULL,
  `rechargeable` varchar(5) NOT NULL,
  `transaction_log` varchar(5) NOT NULL,
  `redeemable` varchar(5) NOT NULL,
  `reedem_field` varchar(255) NOT NULL,
  `org_id` bigint(20) NOT NULL,
  `expire_settings` varchar(5) NOT NULL,
  `recharge_field` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `apple_wallet_settings`
--

CREATE TABLE `apple_wallet_settings` (
  `id` bigint(20) NOT NULL,
  `template_id` bigint(20) NOT NULL,
  `wallet_obj` longtext NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `apple_wallet_settings`
--

INSERT INTO `apple_wallet_settings` (`id`, `template_id`, `wallet_obj`, `created_at`, `updated_at`) VALUES
(4, 133, '{\"primarySettings\":{\"cardType\":\"StoreCard\",\"organizationName\":\"template_name\",\"description\":\"description\",\"forgroundColor\":\"rgb(0,0,0)\",\"backgroundColor\":\"rgb(255,255,255)\",\"labelColor\":\"rgb(0,0,0)\",\"stripColor\":\"rgb(0,0,0)\",\"expireType\":\"dynamic\",\"expireValue\":\"{expire}\"},\"headerFields\":[{\"label\":\"Membership\",\"value\":\"Basic\",\"valueType\":\"fixed\",\"changeMsg\":\"value changed %@\",\"staticValueType\":\"text\"}],\"backFields\":[{\"label\":\"Back Fields\",\"value\":\"Back value\",\"valueType\":\"fixed\",\"changeMsg\":\"value changed %@\",\"staticValueType\":\"text\"}],\"images\":{\"background\":\"\",\"logo\":\"images/image_1715263098602_917.png\",\"icon\":\"images/image_1715263098603_669.png\",\"thumbnail\":\"\",\"strip\":\"images/image_1715263098603_900.png\",\"footer\":\"\"},\"primaryFields\":[{\"label\":\"Name\",\"value\":\"{name}\",\"valueType\":\"dynamic\"},{\"label\":\"Expire Date\",\"value\":\"{expire}\",\"valueType\":\"dynamic\"}],\"barcode\":{\"format\":\"PKBarcodeFormatCode128\",\"barcodeValueType\":\"dynamic\",\"value\":\"{bar_code}\"},\"secondaryFields\":[{\"label\":\"Secondary Field\",\"value\":\"Secondary Field Value\",\"valueType\":\"fixed\"}]}', '2024-05-09 07:58:18', NULL),
(5, 134, '{\"primarySettings\":{\"cardType\":\"StoreCard\",\"organizationName\":\"organization_name\",\"description\":\"description\",\"forgroundColor\":\"rgb(0,0,0)\",\"backgroundColor\":\"rgb(255,255,255)\",\"labelColor\":\"rgb(0,0,0)\",\"stripColor\":\"rgb(0,0,0)\",\"expireType\":\"dynamic\",\"expireValue\":\"{expire_date}\"},\"headerFields\":[{\"label\":\"Membership\",\"value\":\"{package}\",\"valueType\":\"dynamic\",\"changeMsg\":\"package changed %@\",\"staticValueType\":\"\"}],\"backFields\":[{\"label\":\"My Account\",\"value\":\"{website_url}\",\"valueType\":\"dynamic\",\"changeMsg\":\"website url changed %@\",\"staticValueType\":\"\"}],\"images\":{\"background\":\"\",\"logo\":\"images/image_1715347992017_412.png\",\"icon\":\"images/image_1715347992018_590.png\",\"thumbnail\":\"\",\"strip\":\"images/image_1715347992019_415.png\",\"footer\":\"\"},\"primaryFields\":[{\"label\":\"Primary\",\"value\":\"asdasdasd\",\"valueType\":\"fixed\"}],\"barcode\":{\"format\":\"PKBarcodeFormatCode128\",\"barcodeValueType\":\"dynamic\",\"value\":\"{bar_code}\"},\"secondaryFields\":[{\"label\":\"Name\",\"value\":\"{name}\",\"valueType\":\"dynamic\"},{\"label\":\"Expire Date\",\"value\":\"{expire_date}\",\"valueType\":\"dynamic\"}]}', '2024-05-10 07:33:11', NULL);

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

--
-- Table structure for table `audit_log`
--

CREATE TABLE `audit_log` (
  `id` int(11) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `user` bigint(20) NOT NULL,
  `entity` varchar(255) DEFAULT NULL,
  `event` varchar(20) DEFAULT NULL,
  `field` varchar(255) NOT NULL,
  `old_value` longtext DEFAULT NULL,
  `new_value` longtext DEFAULT NULL,
  `ip_address` varchar(60) NOT NULL,
  `org_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `audit_log`
--

INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(19, 'c4ccf79d-b58b-48fb-95f6-be774454349f', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-02-12 18:29:25'),
(20, '72c32b77-8388-4b3a-be6e-04fbaf3556ff', 19, 'update template', 'update', '', '', '', '103.204.86.250', 19, '2024-02-12 18:32:17'),
(21, '2451bacd-b236-439d-b211-d2467eb1e4de', 19, 'update template', 'update', 'template_data', '', '', '103.204.86.250', 19, '2024-02-12 19:42:53'),
(22, '58bd2e31-5b63-491e-83b8-99d9c8975f85', 19, 'Pass created', 'create', 'expiry_time', '', '', '103.204.86.250', 19, '2024-02-12 19:50:07'),
(23, '26604f1e-876c-4423-9adc-cbe5a452ed73', 19, 'Pass created', 'create', 'মালিকের নাম,ফোন নম্বর,ওয়ার্ড,বাসা নং,Latitude,Longitude', '', '', '103.204.86.250', 19, '2024-02-12 19:50:57'),
(24, '7312d952-7fd0-4dbe-83c9-b6c1987a27ea', 19, 'Pass created', 'create', 'মালিকের নাম,ফোন নম্বর,ওয়ার্ড,বাসা নং,Latitude,Longitude', '', 'asdas,asdasd,asdasd,asdas,asdasd,asdasda', '103.204.86.250', 19, '2024-02-12 20:04:57'),
(25, '9a880223-65f3-491c-a857-d163762ca0f3', 19, 'update template', 'update', 'template_data', '', '', '103.204.86.250', 19, '2024-02-12 20:13:33'),
(26, '1d38f077-e351-4968-b4bc-4f2334f64681', 19, 'update template', 'update', 'template_data', '', '', '103.204.86.250', 19, '2024-02-12 20:14:07'),
(27, 'cd398dc5-5e42-4604-ba14-132e8a71f573', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-02-13 11:03:21'),
(28, '15697653-663b-4c86-ac36-0e603406eb82', 19, 'Pass create', 'create', 'Balance', '', '1500', '103.204.86.250', 19, '2024-02-13 11:04:39'),
(29, 'a23fc3c2-8031-40c9-8517-c823bcf6b7b2', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-02-13 11:08:20'),
(30, '0479e01d-7e56-4e93-b95c-2142d44ab8db', 19, 'Pass create', 'create', 'Balance', '', '1500', '103.204.86.250', 19, '2024-02-13 11:08:35'),
(31, '3c28e301-9d24-48ac-9b9a-c3ccd5b99c09', 19, 'Pass create', 'create', 'Balance', '', '3500', '103.204.86.250', 19, '2024-02-13 11:24:31'),
(32, 'd187150a-67b2-4cf4-abe4-f9936d913479', 19, 'Pass create', 'create', 'Balance', '', '4500', '103.204.86.250', 19, '2024-02-13 11:25:19'),
(33, 'f7d7b6bb-05e0-45f4-9897-e2d98f47171a', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-02-13 11:48:38'),
(34, 'febaed3e-d35a-4172-acc2-483fa4d3b59f', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '2000,Riad khan,9564265789,2024-02-13T13:25', '103.204.86.250', 19, '2024-02-13 12:24:56'),
(35, '6bd8899b-0aee-4c2a-8988-c7a6bcd687dd', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '1500,Riad khan,94562145,2024-02-13T13:30', '103.204.86.250', 19, '2024-02-13 12:26:22'),
(36, '57d78fba-8a6d-4bbd-a4bd-4e810c672742', 19, 'update template', 'update', 'template_data', '', '', '103.204.86.250', 19, '2024-02-13 14:07:10'),
(37, '43777e17-5432-45bd-881c-d9a3ccbec721', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '3600,Razi bhai,9456789,2024-02-13T14:50', '103.204.86.250', 19, '2024-02-13 14:40:19'),
(38, '81af48c1-a0d9-41fb-8c39-ad3e7749fefe', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '20,asdas,6535987456,2024-02-13T19:21', '103.204.86.250', 19, '2024-02-13 19:19:46'),
(39, '1ae6bda1-9e49-4e91-99b2-67a84dc00bd0', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '20,asdas,6535987456,2024-02-13T19:21', '103.204.86.250', 19, '2024-02-13 19:20:01'),
(40, 'a465505f-2a29-477f-9833-f9ecf9d1bdd3', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '150,Riad khan,236,2024-02-13T19:25', '103.204.86.250', 19, '2024-02-13 19:22:28'),
(41, 'fd5b277b-082a-4d4e-b6ad-41590f517e9d', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '200,Riad khan,236,2024-02-13T21:27', '103.204.86.250', 19, '2024-02-13 19:25:38'),
(42, 'e7e6e20f-f7f0-4c5d-8e91-b59db190656d', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '2500,Riad khan,456,2024-02-15T12:27', '103.204.86.250', 19, '2024-02-14 12:27:53'),
(43, '2bc5a32c-ecb4-49d2-b76a-98a854c33e70', 19, 'Pass create', 'create', 'current_balance,Name,barcode,expiry_date', '', '1000,Arafat,457,2024-02-15T12:28', '103.204.86.250', 19, '2024-02-14 12:28:35'),
(44, '2122ff73-df5f-435c-971f-49eac1244b51', 19, 'Values updated for pass', 'update', 'current_balance,Name,barcode,expiry_date', '2500,Riad hossain khan,45678,2024-02-16T12:27', '3000,Riad hossain khan,45678,2024-02-16T12:27', '103.204.86.250', 19, '2024-02-14 18:48:37'),
(45, '6d09ba34-7e3d-4ce3-9438-19154d26f33c', 19, 'Values updated for pass', 'update', 'current_balance,Name,barcode,expiry_date', '3000,Riad hossain khan,45678,2024-02-16T12:27', '3000,Riad hossain khan,45678,2024-02-16T12:27', '103.204.86.250', 19, '2024-02-14 18:49:06'),
(46, 'c7744585-5bed-4aa2-b204-c1f9d9a5a9bb', 19, 'Values updated for pass', 'update', 'current_balance,Name,barcode,expiry_date', '1100,Arafat,457,2024-02-15T12:28', '2000,Arafat rahman,457,2024-02-15T12:28', '103.204.86.250', 19, '2024-02-14 18:50:31'),
(47, 'c293d0d0-0f5a-4f65-ad7d-33869f6c2a76', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-15 19:21:28'),
(48, '9bf56fa1-d92a-4e6b-b764-6a97172f2dd8', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-15 19:21:28'),
(49, '247391bc-695b-4d4f-8da8-08a644f14465', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-15 19:22:30'),
(50, 'be8c8658-19a4-49c4-84c5-96aa72330ca0', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-15 19:41:31'),
(51, 'cfde1881-177e-4bc1-b14b-92bbc9d89600', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-15 19:42:35'),
(52, 'dd86c75c-7877-46c0-a26e-6140a6ff2fd7', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-15 20:02:14'),
(53, '7a489816-8d1f-4c13-9c48-a04ec0b9f94e', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 11:57:08'),
(54, '1ad426fd-6ba5-4dc0-8025-3cd88615577a', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 12:29:01'),
(55, '803282ab-e577-4811-b0ac-00450e8a5d71', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 12:31:05'),
(56, 'd656c8f8-ff8b-4b15-abbf-4651f30f896c', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 13:14:52'),
(57, 'ebbc5b0e-8cf7-4aee-9e45-5e44a6f1bdd2', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 16:59:11'),
(58, '21b0d5d5-7a0c-4768-851f-155c045f5223', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 17:01:53'),
(59, 'f2b198cf-b6f3-46e0-a72b-728461853faa', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 17:08:08'),
(60, '1a44f204-6bd0-4d7e-bf28-12001b31d872', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 18:49:20'),
(61, '9dc92adc-8a11-41b3-934e-9518e5340488', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 18:59:19'),
(62, '8f25d5a4-9a15-4684-bde9-36ecbd8798ba', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:06:57'),
(63, '9a49920b-2514-4cad-9abf-1d2dca4b9b2e', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:08:13'),
(64, 'f445e930-94b2-4221-8cf7-2dcb2da425ea', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:09:08'),
(65, 'b25f5ae3-5b9b-43e6-89ac-99a28133375a', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:11:26'),
(66, '7a93d7b8-2e5f-4d18-b0cf-58ccddc5d594', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:13:50'),
(67, '9bb06e47-d832-413f-a208-03d74012da1d', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:17:22'),
(68, 'ffa71108-69dd-467b-8d9d-5742c19d5476', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:27:43'),
(69, 'f04d1247-2e7c-4044-8b0c-3702e41bc2ed', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:31:12'),
(70, '89c121ad-e99f-425d-9026-ca57e1ebb31b', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:39:37'),
(71, '6dcd2e0f-20a0-4b15-94de-0eb1449a41da', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:41:20'),
(72, '98949e12-4b9b-49e4-b1ac-3ae2fc513d41', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:46:25'),
(73, '075cadb1-fbb6-49b6-abc2-910be4290c72', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:49:11'),
(74, 'fc3cb920-43ba-49ad-a5f6-f6bfc3e3b83f', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:49:46'),
(75, 'e4eb8dc0-b5ec-48ca-a1ce-6319055e54c4', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:52:41'),
(76, '6a06db3a-2b75-496c-9d43-f5a3947ac095', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:53:54'),
(77, '718f1441-9ee3-464b-a99b-e0dbe6e786b5', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:56:16'),
(78, 'e81ad224-04f8-4848-aef0-dd32c5aef0ee', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:58:26'),
(79, '07bde51a-a366-4899-b4b9-18bb52411eba', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-16 19:59:44'),
(80, 'febb62a1-ee02-4c69-9110-84eccb1c9d6b', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 11:15:13'),
(81, '4e9183d2-662b-411e-a153-c479c7c8f3ff', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 11:17:39'),
(82, 'c0cd2c39-17fd-420c-8a02-fa761208533b', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 11:23:05'),
(83, '81bf1fe4-d845-4851-b378-570befc8dd5a', 19, 'Isey  Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 11:24:18'),
(84, 'db692329-4807-4dad-8efb-38e903d06cb9', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 17:20:56');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(85, 'bab79126-e33c-460e-a77e-ce61afaa1374', 19, 'Pass create', 'create', 'name,designation,photo,id_no,E-mail,phone,barcode,Terms & conditions,join,Expire', '', 'Riad khan,Developer,data:image/png;base64,[BLOB],0000003,riadhossain2367@gmail.com,01628132705,0000003,Identification: Carry the ID card at all times during working hours for identification purposes.\nAuthorized Use: The ID card is strictly for official use and should not be shared or used for unauthorized purposes.,2024-02-05T17:39,2024-02-21T17:39', '103.204.86.250', 19, '2024-02-20 17:39:34');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(86, '269af58b-dacf-4ea7-a657-7bde5cdd6518', 19, 'Values updated for pass', 'update', 'name,designation,photo,id_no,E-mail,phone,barcode,Terms & conditions,join,Expire', 'Riad khan,Developer,images/image_1708429174090_650.png,0000003,riadhossain2367@gmail.com,01628132705,0000003,Identification: Carry the ID card at all times during working hours for identification purposes.\nAuthorized Use: The ID card is strictly for official use and should not be shared or used for unauthorized purposes.,2024-02-05T17:39,2024-02-21T17:39', 'Riad khan,Backend Developer,images/image_1708429174090_650.png,0000003,riadhossain2367@gmail.com,01628132705,0000003,Identification: Carry the ID card at all times during working hours for identification purposes.\nAuthorized Use: The ID card is strictly for official use and should not be shared or used for unauthorized purposes.,2024-02-05T17:39,2024-02-21T17:39', '103.204.86.250', 19, '2024-02-20 17:52:00'),
(87, 'ac31a98a-e38b-4c5d-8247-c4ba046ef88f', 19, 'Values updated for pass', 'update', 'name,designation,photo,id_no,E-mail,phone,barcode,Terms & conditions,join,Expire', 'Riad khan,Backend Developer,images/image_1708429174090_650.png,0000003,riadhossain2367@gmail.com,01628132705,0000003,Identification: Carry the ID card at all times during working hours for identification purposes.\nAuthorized Use: The ID card is strictly for official use and should not be shared or used for unauthorized purposes.,2024-02-05T17:39,2024-02-21T17:39', 'Riad khan,Backend Developer,images/image_1708429174090_650.png,0000003,riadhossain2367@gmail.com,01628132705,0000003,Identification: Carry the ID card at all times during working hours for identification purposes.\nAuthorized Use: The ID card is strictly for official use and should not be shared or used for unauthorized purposes.,2024-02-05T17:39,2024-02-21T17:39', '103.204.86.250', 19, '2024-02-20 17:52:17'),
(88, 'e270e975-fa2e-45aa-8866-0833712ccc44', 19, 'Values updated for pass', 'update', 'name,designation,photo,id_no,E-mail,phone,barcode,Terms & conditions,join,Expire', 'Riad khan,Backend Developer,images/image_1708429174090_650.png,0000003,riadhossain2367@gmail.com,01628132705,0000003,Identification: Carry the ID card at all times during working hours for identification purposes.\nAuthorized Use: The ID card is strictly for official use and should not be shared or used for unauthorized purposes.,2024-02-05T17:39,2024-02-21T17:39', 'Riad khan,Backend Developer,images/image_1708429174090_650.png,0000003,riadhossain2367@gmail.com,01628132705,0000003,zzszxczxczxczx,2024-02-05T17:39,2024-02-21T17:39', '103.204.86.250', 19, '2024-02-20 17:52:23'),
(89, '11491018-5f85-48ff-aa5b-15f76f764910', 19, 'Values updated for pass', 'update', 'name,designation,photo,id_no,E-mail,phone,barcode,Terms & conditions,join,Expire', 'Riad khan,Backend Developer,images/image_1708429174090_650.png,0000003,riadhossain2367@gmail.com,01628132705,0000003,zzszxczxczxczx,2024-02-05T17:39,2024-02-21T17:39', 'Riad khan,Developer,images/image_1708429174090_650.png,0000003,riadhossain2367@gmail.com,01628132705,0000003,zzszxczxczxczx,2024-02-05T17:39,2024-02-21T17:39', '103.204.86.250', 19, '2024-02-20 17:52:43'),
(90, '9788dcf3-fb85-4fd6-8b0d-bd80741c9b6f', 19, 'update template', 'update', 'template_data', '', '', '103.204.86.250', 19, '2024-02-20 18:43:18'),
(91, '358e1697-3f88-4eb0-9bef-110be5a2e933', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:43:40'),
(92, 'aef2ee83-329c-4630-b935-e3a30c76b1d3', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:47:47'),
(93, '0fb51d29-1f61-4855-a87a-a3f3c9e66252', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:48:44'),
(94, '202e7dce-fb13-4fcc-8984-6dd958d47edb', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:53:12'),
(95, '96ce7e49-0cd2-444a-b8b2-140ec9fba9ce', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:54:44'),
(96, '882e717d-f3d1-4a74-bbeb-87cfadbf4790', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:55:19'),
(97, '432ee629-a494-47ce-8e3d-c9762a92e569', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:57:44'),
(98, '5a1e4480-5e1a-4e08-bebf-62ef5414686f', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:57:56'),
(99, '74804958-54ac-45cd-bcc2-548a8eeea8dc', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:58:14'),
(100, '73007feb-4f64-4e34-8c46-557f6037427b', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:59:25'),
(101, 'b9ad0e89-aa1f-4327-8e13-be4373f327f6', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 19:59:53'),
(102, '9237a756-c467-49ff-af08-561d1ddc11ee', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 20:00:27'),
(103, '70ef89f1-5a58-4592-a1e4-68e2128927e4', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 20:01:09'),
(104, 'fbdee57c-a622-4e7d-b39e-86177cb6f88a', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 20:01:55'),
(105, '2df22958-5592-46b2-8482-9c3525a5cb76', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 20:02:32'),
(106, '8acf7d9e-987d-4589-828b-41039e930c3d', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 20:03:09'),
(107, '71c9a743-b3f2-4a41-b1a6-896d7a3e99f9', 19, 'update template', 'update', 'template_data', '', '', '103.204.86.250', 19, '2024-02-20 20:04:14'),
(108, '96871a62-64ed-42b3-947c-85fe0653d068', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 20:05:33'),
(109, 'add8ea33-76d8-4ee2-979d-307d43899a37', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 20:06:14'),
(110, 'f5be19d9-284f-41d1-95e2-70b7ee250f3d', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-20 20:14:27');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(111, '5ef4b10c-ab4a-483b-9ed4-6664b6feecb9', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'Riad hossain khan,Developer,data:image/png;base64,[BLOB],00003,riadhossain2367@gmail.com,01628132705,00003,Please use this card on office premises,2024-02-02T10:49,2024-02-21T01:49', '103.204.86.250', 19, '2024-02-21 10:49:50');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(112, '99e1ef8b-f205-455f-a6f3-8a78af6410e8', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-21 12:22:47'),
(113, 'c4743baa-4b47-4f69-9f32-369d134beb58', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-21 13:16:59');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(114, '2725ef49-db36-45ea-8837-c2d31871cbac', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'Riad Hossain Khan,Developer,data:image/png;base64,[BLOB],3,riadhossain2367@gmail.com,01628132705,01628132705,Please \nuse this in office premises.,2024-02-21T12:22,2024-02-21T14:22', '103.204.86.250', 19, '2024-02-21 13:22:35');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(115, 'f8001b50-04f2-488a-8f7e-717237f9d4ba', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'asda,sdasdasd,data:image/png;base64,[BLOB],6,riadkhan2367@gmail.com,01628132705,asdasd,adasda\nasdasd,2024-02-22T17:20,2024-02-15T17:20', '103.204.86.250', 19, '2024-02-21 17:20:19');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(116, 'dd5257b4-3aac-4fc7-9f79-d9566255960e', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'adasd,asdasd,data:image/png;base64,[BLOB],7,riad@gmail.com,54689756421,12,2024-02-22T17:47,2024-02-21T17:51', '103.204.86.250', 19, '2024-02-21 17:47:58');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(117, 'ad86a958-479c-48c6-a01a-6ceaaa1bb948', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'ddfasds,asdasd,data:image/png;base64,[BLOB],8,asdasd,asdasd,56,2024-02-20T17:55,2024-02-20T17:55', '103.204.86.250', 19, '2024-02-21 17:56:24');
