INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(126, '478996af-5edb-4611-bdad-8f2a1919c101', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'Riad khan,Developer,data:image/png;base64,[BLOB],0004,riadkhan2367@gmail.com,01628132705,000326,Riad \\nkhan\\n                ,2024-02-22T19:37,2024-02-23T19:37', '103.204.86.250', 19, '2024-02-21 19:37:50');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(127, 'bb67d443-d394-4d5a-9952-a9eefe34e453', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'Riad khan,Developer,data:image/png;base64,[BLOB],00023,riadkhan2367@gmail.com,01628132705,000236,Riad\nkhan\n\n                ,2024-02-22T19:39,2024-02-22T19:39', '103.204.86.250', 19, '2024-02-21 19:39:58');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(128, 'af785ce8-fb54-42f7-b246-5caf577b9166', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'Riad khan,Developer,data:image/png;base64,[BLOB],2365,riadkhan2367@gmail.com,01628132705,0123,Riad \\nkhan,2024-02-22T19:44,2024-02-22T19:44', '103.204.86.250', 19, '2024-02-21 19:44:39');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(129, '778409f3-773f-409d-9121-33ab7a6cbc62', 19, 'Pass create', 'create', 'name,designation,photo,id_no,email,phone,barcode,Terms & conditions,join,Expire', '', 'Riad khan,Developer,data:image/png;base64,[BLOB],2367,riadkhan2367@gmail.com,01628132705,1236,Riad <br>Khan<br>                ,2024-02-23T19:46,2024-02-22T19:46', '103.204.86.250', 19, '2024-02-21 19:46:57');
INSERT INTO `audit_log` (`id`, `uid`, `user`, `entity`, `event`, `field`, `old_value`, `new_value`, `ip_address`, `org_id`, `created_at`) VALUES
(130, 'bd621d07-1a8d-41a9-a644-ec220bca8673', 19, 'Prizol ID card Bulk job', 'create', '', '', '', '103.204.86.250', 19, '2024-02-28 17:47:03'),
(131, 'f9a6f515-b9c8-4cd6-8295-a660271ad1dd', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:21:38'),
(132, 'd1c6c3f8-39b0-45e1-bc21-a36a9d82f2bf', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:23:45'),
(133, '21c28103-4699-4019-a854-16477e981c63', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:24:21'),
(134, 'c63d70f0-1e73-4970-b047-a44a64a93dcc', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:24:48'),
(135, '8ad99754-3cd3-4081-8f2b-1ffbbb8a4745', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:25:44'),
(136, 'bf939804-d2c3-444b-8b82-dba632fcd719', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:26:30'),
(137, '9f1db70d-2a05-42d3-bacc-f3e2cd00267f', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:26:58'),
(138, '966e7820-f9a5-42a8-a05d-601127d119bb', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:28:08'),
(139, 'f22dc7d8-a67f-4081-abc9-a93e77e787f3', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:30:35'),
(140, '7c96d1c1-17c1-49e3-a9ce-19c8ae12b58e', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-03-05 16:58:18'),
(141, 'ed87e30d-1d7c-485e-9233-eb43a1a26ea7', 19, 'Pass create', 'create', 'Current amount,Name,Qr code,Programme Name,expiry_date,Loyality label', '', '1500,Riad Hossain Khan,01763662306,Valur - Felagakort,2024-03-05T20:59,Points', '103.204.86.250', 19, '2024-03-05 17:00:01'),
(142, '3514964c-4a1f-4f95-bd16-cbf893845b58', 19, 'Create template', 'create', '', '', '', '103.204.86.250', 19, '2024-04-05 14:36:20'),
(143, '0e1dd0e8-79d3-4739-8a4d-a0bd205b013c', 19, 'Pass create', 'create', 'current_price,card_holder_name,barcode_value,programme_name,programme_logo,hero_image,tel_number,link,lattitude,longitude,point_label,expiry_date', '', '6000,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-05T22:47', '103.204.86.250', 19, '2024-04-05 14:43:13'),
(144, '457381ba-0044-4a85-85f2-c7452fbc76e9', 19, 'Values updated for pass', 'update', 'current_price,card_holder_name,barcode_value,programme_name,programme_logo,hero_image,tel_number,link,lattitude,longitude,point_label,expiry_date', '12000,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-05T22:47', '12000,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-10T12:47', '103.204.86.250', 19, '2024-04-06 11:43:43'),
(145, '429bfc37-4384-4836-b4fd-6838cbafb648', 19, 'Values updated for pass', 'update', 'current_price,card_holder_name,barcode_value,programme_name,programme_logo,hero_image,tel_number,link,lattitude,longitude,point_label,expiry_date', '12000,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-10T12:47', '12000,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-10T12:47', '103.204.86.250', 19, '2024-04-06 11:43:53'),
(146, '58b8ae73-f9d0-4358-91d8-422ad8faeb11', 19, 'Values updated for pass', 'update', 'current_price,card_holder_name,barcode_value,programme_name,programme_logo,hero_image,tel_number,link,lattitude,longitude,point_label,expiry_date', '15100,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-10T12:47', '15100,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T16:05', '103.204.86.250', 19, '2024-04-06 16:04:12'),
(147, 'f57911a5-509c-43d4-8be1-43dc4525c05c', 19, 'Values updated for pass', 'update', 'current_price,card_holder_name,barcode_value,programme_name,programme_logo,hero_image,tel_number,link,lattitude,longitude,point_label,expiry_date', '15100,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T16:05', '15100,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T16:30', '103.204.86.250', 19, '2024-04-06 16:26:48'),
(148, 'e9658152-1a73-4c23-b7f4-7a97b14bb780', 19, 'Values updated for pass', 'update', 'current_price,card_holder_name,barcode_value,programme_name,programme_logo,hero_image,tel_number,link,lattitude,longitude,point_label,expiry_date', '15100,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T16:30', '15100,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T18:30', '103.204.86.250', 19, '2024-04-06 16:27:21'),
(149, '9863465c-5d25-4c23-9dbd-9acaaf605f53', 19, 'Values updated for pass', 'update', 'current_price,card_holder_name,barcode_value,programme_name,programme_logo,hero_image,tel_number,link,lattitude,longitude,point_label,expiry_date', '15400,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T18:30', '15400,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T16:51', '103.204.86.250', 19, '2024-04-06 16:45:25'),
(150, '8bdd17d7-bd75-428c-a7d4-c59b2f14d253', 19, 'Values updated for pass', 'update', 'current_price,card_holder_name,barcode_value,programme_name,programme_logo,hero_image,tel_number,link,lattitude,longitude,point_label,expiry_date', '16000,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T16:51', '16000,Riad khan,0000267,Orkusalan,https://veski.leikbreytir.is/assets/a7465d45283c88d6997cb8a7813418f47e4d80c6/logo.png,https://veski.leikbreytir.is/assets/2436f49c7e11dc9d074373497c2edcd0eb32abed/strip.png,01628132705,www.wooxperto.com,23.86620,90.39899,Balance,2024-04-06T16:48', '103.204.86.250', 19, '2024-04-06 16:47:00'),
(151, '8bbe1c13-367c-4dc8-88fd-138bc79bed73', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-04-18 16:42:50'),
(152, '57bfa57e-b292-4227-860a-3d54fc49bdb0', 19, 'Pass create', 'create', 'current_balance,card_holder_name,initial_balance,qr_code,PIN', '', '5600,Riad khan,6000,5600,5625', '103.204.87.5', 19, '2024-04-18 16:44:02'),
(153, '8a14a12f-60d4-4119-b8b8-0edb96d78803', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-04-18 16:46:45'),
(154, '620b6e1b-d16d-477c-b33e-5c46ae09faae', 19, 'Pass create', 'create', 'current_balance,card_holder_name,initial_balance,qr_code,PIN,tel,Link,lat,Long', '', '5600,asdas,5998,6000,5624,01628132705,www.wooxpertoo.com,5632699,72.35689', '103.204.87.5', 19, '2024-04-18 16:48:08'),
(155, 'efffe9bb-1f11-4962-a41c-370f6e1ff331', 19, 'Values updated for pass', 'update', 'current_balance,card_holder_name,initial_balance,qr_code,PIN,tel,Link,lat,Long', '5600,asdas,5998,6000,5624,01628132705,www.wooxpertoo.com,5632699,72.35689', '5600,asdas,5998,6000,5624,01628132705,www.wooxpertoo.com,69.568974,69.568975', '103.204.87.5', 19, '2024-04-18 19:31:30'),
(156, '0c899823-18e8-45a4-af68-c4713ed539ca', 19, 'Pass create', 'create', 'current_balance,card_holder_name,initial_balance,qr_code,PIN,tel,Link,lat,Long', '', '500,Sumon,500,500,5555,01737642007,asdasd,73.5645898,69.3564789', '103.204.87.5', 19, '2024-04-19 16:01:12'),
(157, '1ee9fd1c-915d-4507-9e1f-b9e936e3ef05', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-04-22 12:21:12'),
(158, '4d317611-9685-4609-920b-2eae630a193f', 19, 'update template', 'update', 'template_data', '', '', '103.204.87.5', 19, '2024-04-22 12:22:29'),
(159, 'd609c13b-a68b-46ce-9cba-0255173a32c7', 19, 'Pass create', 'create', 'asdasd', '', 'Riad khan', '103.204.87.5', 19, '2024-04-22 12:22:46'),
(160, '336872b9-af0a-4d9c-8c1b-c07fb833d64c', 19, 'Pass create', 'create', 'asdasd', '', 'wwoo', '103.204.87.5', 19, '2024-04-22 13:27:06'),
(161, '9203ff92-9329-4da3-9062-1c13289364a9', 19, 'Pass create', 'create', 'asdasd', '', 'yesss', '103.204.87.5', 19, '2024-04-22 13:27:58'),
(162, '32d6e294-d651-405d-924d-f9ac2445c7ea', 19, 'Pass create', 'create', 'asdasd', '', 'riadddd', '103.204.87.5', 19, '2024-04-22 13:37:19'),
(163, '60db537e-e580-4b3b-a0ad-229dbd3cde31', 19, 'Pass create', 'create', 'asdasd', '', 'sdfsdf', '103.204.87.5', 19, '2024-04-22 13:40:13'),
(164, 'd81d09a0-5150-4966-a1b4-5d02e2f93177', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-05-01 15:26:21'),
(165, '9ea66573-8703-4daf-84a5-31d89e554a02', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-05-01 15:48:46'),
(166, '6938fffc-7aae-4d6f-91c1-65f03ee97b72', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-05-01 15:55:49'),
(167, '2c60d25d-9526-4432-805f-33ea609ab4ba', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-05-01 16:50:28'),
(168, 'f299a10c-54ae-4887-9c89-7f948b5e599c', 19, 'Pass create', 'create', 'current_balance,card_holder,initial_balance,qr_code,expire_date,account_name,tel_module', '', '2500,Riad khan,3000,000325678,2024-05-10T16:51,Riad khan,01628132705', '103.204.87.5', 19, '2024-05-01 16:51:47'),
(169, '045a9e50-4b2e-415e-bddf-d4765cd0b03b', 19, 'Pass create', 'create', 'current_balance,card_holder,initial_balance,qr_code,expire_date,account_name,tel_module', '', '3200,Salman,3500,6598745689,2024-05-23T18:52,Salman,01953655424', '103.204.87.5', 19, '2024-05-01 18:52:48'),
(170, '184d7afa-6808-4804-9e65-fcbf6c020bae', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-05-03 20:20:01'),
(171, '75c9c5bc-a92f-4109-92d1-ec16cae48d5c', 19, 'Pass create', 'create', 'Name,expire_date,qr_code,package,telephone,link,lat,long,points_label,balance', '', 'Riad khan,2024-05-04T21:20,https://rsrewards.com.au/rs,Basic,01628132705,https://rsrewards.com.au/rs,93.256478,63.23568,Points,3000', '103.204.87.5', 19, '2024-05-03 20:21:12'),
(172, '409acfeb-afe6-4195-8c87-a8bc3167fa73', 19, 'Create template', 'create', '', '', '', '103.204.87.5', 19, '2024-05-06 15:12:15'),
(173, '4dfe31ed-376f-4902-b516-218efd27f35b', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'Basic,Mahadi Wiliam Fattah,2024-05-08T15:20,2659745689,01628130705,https://rsrewards.com.au/', '103.204.87.5', 19, '2024-05-06 15:21:20'),
(174, 'e76429ef-a8d0-422f-b79f-e009101c369d', 19, 'Values updated for pass', 'update', 'package,name,expiry_date,qr_code,telephone number,link', 'Basic,Mahadi Wiliam Fattah,2024-05-08T15:20,2659745689,01628130705,https://rsrewards.com.au/', 'Premium,Mahadi Wiliam Fattah,2024-05-08T15:20,2659745689,01628130705,https://rsrewards.com.au/', '103.204.87.5', 19, '2024-05-07 20:11:18'),
(175, '45fa129f-f0f3-48ed-9df6-ec2e5e90d298', 19, 'Values updated for pass', 'update', 'package,name,expiry_date,qr_code,telephone number,link', 'Premium,Mahadi Wiliam Fattah,2024-05-08T15:20,2659745689,01628130705,https://rsrewards.com.au/', 'Premium,Mahadi Wiliam Fattah,2024-05-08T15:20,2659745689,01628130705,https://rsrewards.com.au/', '103.204.87.5', 19, '2024-05-07 20:12:24'),
(176, 'f6360e7f-e62d-4c1f-adc1-0e7f94cb1bdb', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'Legendary,Sumon,2024-05-08T15:06,01628132705,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 15:05:16'),
(177, '2253c6c5-577a-45da-81db-93aeab121d34', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'basic,asdasd,2024-05-11T16:31,5654256,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 16:41:57'),
(178, '381f0a2a-8a89-478a-873c-a3f98645a462', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'basic,asdasd,2024-05-11T16:31,5654256,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 16:51:24'),
(179, 'f1584c25-7e8e-48ba-b98b-2bc21657acc5', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'Basic,Riad khan,2024-05-18T17:01,01628132705,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 17:01:58'),
(180, '740bfe9d-8c2b-439b-81f6-7cbb252a3d83', 19, 'Values updated for pass', 'update', 'package,name,expiry_date,qr_code,telephone number,link', 'Basic,Riad khan,2024-05-18T17:01,01628132705,01628132705,www.facebook.com', 'Basic,Riad khan,2024-05-18T17:01,01628132705,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 18:29:04'),
(181, '636c313b-7e78-4479-aff3-91b5d2c5dbd7', 19, 'Values updated for pass', 'update', 'package,name,expiry_date,qr_code,telephone number,link', 'Basic,Riad khan,2024-05-18T17:01,01628132705,01628132705,www.facebook.com', 'Basic,Riad khan,2024-05-18T17:01,01628132705,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 18:30:24'),
(182, '3b5e70cb-deed-4fd7-9fef-c18d0f2bfb9b', 19, 'Values updated for pass', 'update', 'package,name,expiry_date,qr_code,telephone number,link', 'Basic,Riad khan,2024-05-18T17:01,01628132705,01628132705,www.facebook.com', 'Basic,Riad khan,2024-05-18T17:01,01628132705,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 18:39:18'),
(183, 'f5bb9831-d583-4466-9803-dd569bd49847', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'Basic,Tanvir ,2024-05-09T19:41,01628132705,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 19:41:23'),
(184, '81554918-e2a2-46b5-8d58-9818e70288b6', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'Basic,asdasd,2024-05-09T19:49,56452365,56452365,56452365', '202.4.123.192', 19, '2024-05-08 19:49:31'),
(185, 'bbb7500d-b84d-44b2-b2e0-a31a58191614', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'Riad khan,Basic,2024-05-10T20:06,01628132705,01628132705,www.facebook.com', '202.4.123.192', 19, '2024-05-08 20:06:46'),
(186, 'fb3fa39d-b9c2-48e5-8ded-75b037e605ca', 19, 'Pass create', 'create', 'package,name,expiry_date,qr_code,telephone number,link', '', 'Basic,Tanvir md Al amin,2024-05-10T20:11,01953655424,01953655424,www.facebook.com', '202.4.123.192', 19, '2024-05-08 20:12:01'),
(187, '1956e3e3-6577-48be-a49b-3cda3bab5355', 19, 'Create template', 'create', '', '', '', '202.4.123.192', 19, '2024-05-09 18:30:30'),
(188, '2fa07b66-498e-4529-a29a-4d7034aeaeb1', 19, 'Create template', 'create', '', '', '', '202.4.123.192', 19, '2024-05-09 19:58:18'),
(189, 'f723d111-ea98-47b2-8b03-1840752d7dce', 19, 'Create template', 'create', '', '', '', '202.4.123.192', 19, '2024-05-10 19:33:12'),
(190, 'f9db6049-a07c-4c61-9513-ebc7205c3a3c', 19, 'update template', 'update', 'template_data', '', '', '202.4.123.192', 19, '2024-05-10 19:42:30');

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

--
-- Table structure for table `beacons`
--

CREATE TABLE `beacons` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `relevent_text` varchar(255) DEFAULT NULL,
  `major` varchar(255) DEFAULT NULL,
  `minor` varchar(255) DEFAULT NULL,
  `beacon_settings` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `beacons`
--

INSERT INTO `beacons` (`id`, `name`, `uid`, `relevent_text`, `major`, `minor`, `beacon_settings`) VALUES
(4, 'Beacon 1', 'asasd-asdac-asdwasd-334asd', 'relevent_text', 'major', 'minor', 4),
(5, 'Beacons', 'asasd-asdac-asdwasd-334asd', '', '0', '0', 5);

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

--
-- Table structure for table `beacon_settings`
--

CREATE TABLE `beacon_settings` (
  `id` bigint(20) NOT NULL,
  `is_active` tinyint(3) NOT NULL,
  `template_id` int(11) NOT NULL,
  `org_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `beacon_settings`
--

INSERT INTO `beacon_settings` (`id`, `is_active`, `template_id`, `org_id`) VALUES
(4, 1, 78, 19),
(5, 1, 126, 19);

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

--
-- Table structure for table `bulk_jobs`
--

CREATE TABLE `bulk_jobs` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `template_name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created_on` datetime NOT NULL,
  `org_id` bigint(20) NOT NULL,
  `created_by` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `bulk_jobs`
--

INSERT INTO `bulk_jobs` (`id`, `name`, `template_name`, `type`, `status`, `created_on`, `org_id`, `created_by`) VALUES
(3, 'Iesy', 'Isey ', 'create', 1, '2024-02-16 11:57:08', 19, 0),
(4, 'new job for isey', 'Isey ', 'create', 1, '2024-02-16 12:31:05', 19, 19),
(5, 'new job', 'Isey ', 'create', 1, '2024-02-16 01:14:52', 19, 19),
(6, 'ASASD', 'Isey ', 'create', 1, '2024-02-16 03:56:23', 19, 19),
(7, 'asd', 'Isey ', 'create', 1, '2024-02-16 04:59:11', 19, 19),
(8, 'asd', 'Isey ', 'create', 1, '2024-02-16 05:01:53', 19, 19),
(9, 'asd', 'Isey ', 'create', 1, '2024-02-16 05:08:08', 19, 19),
(10, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 06:49:20', 19, 19),
(11, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 06:59:19', 19, 19),
(12, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:04:49', 19, 19),
(13, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:06:37', 19, 19),
(14, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:06:57', 19, 19),
(15, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:07:30', 19, 19),
(16, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:07:55', 19, 19),
(17, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:08:13', 19, 19),
(18, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:09:08', 19, 19),
(19, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:11:25', 19, 19),
(20, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:13:50', 19, 19),
(21, 'update pass', 'Isey ', 'update existing', 1, '2024-02-16 07:17:22', 19, 19),
(22, 'update', 'Isey ', 'update existing', 1, '2024-02-16 07:27:17', 19, 19),
(23, 'update', 'Isey ', 'update existing', 1, '2024-02-16 07:27:43', 19, 19),
(24, 'update', 'Isey ', 'update existing', 1, '2024-02-16 07:31:12', 19, 19),
(25, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:39:37', 19, 19),
(26, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:41:20', 19, 19),
(27, '', 'Isey ', 'create', 1, '2024-02-16 07:46:25', 19, 19),
(28, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:49:11', 19, 19),
(29, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:49:46', 19, 19),
(30, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:51:57', 19, 19),
(31, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:52:41', 19, 19),
(32, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:53:54', 19, 19),
(33, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:56:16', 19, 19),
(34, 'test', 'Isey ', 'update existing', 1, '2024-02-16 07:57:00', 19, 19),
(35, 'demo', 'Isey ', 'update existing', 1, '2024-02-16 07:58:26', 19, 19),
(36, 'demo', 'Isey ', 'update existing', 1, '2024-02-16 07:59:44', 19, 19),
(37, 'isey update', 'Isey ', 'update existing', 1, '2024-02-20 11:14:06', 19, 19),
(38, 'isey update', 'Isey ', 'update existing', 1, '2024-02-20 11:15:13', 19, 19),
(39, 'update isey', 'Isey ', 'update existing', 1, '2024-02-20 11:17:39', 19, 19),
(40, 'asdasd', 'Isey ', 'update existing', 1, '2024-02-20 11:23:05', 19, 19),
(41, 'fsdfsdfsdf', 'Isey ', 'create', 1, '2024-02-20 11:24:18', 19, 19),
(42, 'Prizol ', 'Prizol ID card', 'create', 1, '2024-02-20 07:40:08', 19, 19),
(43, 'Prizoel Add', 'Prizol ID card', 'create', 1, '2024-02-20 07:43:40', 19, 19),
(44, 'create prizol id', 'Prizol ID card', 'create', 1, '2024-02-20 07:47:47', 19, 19),
(45, 'prizol id create', 'Prizol ID card', 'create', 1, '2024-02-20 07:48:44', 19, 19),
(46, 'prizol', 'Prizol ID card', 'create', 1, '2024-02-20 07:53:12', 19, 19),
(47, 'asdad', 'Prizol ID card', 'create', 1, '2024-02-20 07:54:44', 19, 19),
(48, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 07:55:19', 19, 19),
(49, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 07:57:44', 19, 19),
(50, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 07:57:56', 19, 19),
(51, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 07:58:14', 19, 19),
(52, 'asdasda', 'Prizol ID card', 'create', 1, '2024-02-20 07:59:25', 19, 19),
(53, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 07:59:53', 19, 19),
(54, 'dasd', 'Prizol ID card', 'create', 1, '2024-02-20 08:00:27', 19, 19),
(55, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 08:01:09', 19, 19),
(56, 'asdas', 'Prizol ID card', 'create', 1, '2024-02-20 08:01:55', 19, 19),
(57, 'aasd', 'Prizol ID card', 'create', 1, '2024-02-20 08:02:32', 19, 19),
(58, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 08:03:09', 19, 19),
(59, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 08:05:33', 19, 19),
(60, 'asdasd', 'Prizol ID card', 'create', 1, '2024-02-20 08:06:14', 19, 19),
(61, 'asasdf', 'Prizol ID card', 'create', 1, '2024-02-20 08:14:27', 19, 19),
(62, 'create', 'Prizol ID card', 'create', 1, '2024-02-21 12:22:47', 19, 19),
(63, 'Prizol ID', 'Prizol ID card', 'create', 1, '2024-02-21 01:16:59', 19, 19),
(64, 'id card', 'Prizol ID card', 'create', 1, '2024-02-28 05:47:03', 19, 19);

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

--
-- Table structure for table `certificates`
--

CREATE TABLE `certificates` (
  `id` bigint(20) NOT NULL,
  `certificate_name` varchar(100) NOT NULL,
  `file_path` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `certificates`
--

INSERT INTO `certificates` (`id`, `certificate_name`, `file_path`) VALUES
(4, 'pass.pass.aanbieding24.nl', '/files/certificatesFile/1713797427800_pass.cer');

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

--
-- Table structure for table `google_wallet_settings`
--

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

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

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` bigint(20) NOT NULL,
  `template_id` bigint(20) NOT NULL,
  `uid` varchar(200) NOT NULL,
  `location_settings` bigint(20) NOT NULL,
  `org_id` bigint(20) NOT NULL,
  `title` varchar(255) NOT NULL,
  `latitude` varchar(50) NOT NULL,
  `longitude` varchar(50) NOT NULL,
  `altitude` varchar(50) DEFAULT NULL,
  `relevent_text` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `template_id`, `uid`, `location_settings`, `org_id`, `title`, `latitude`, `longitude`, `altitude`, `relevent_text`) VALUES
(5, 126, '7ff733e9-2000-40fb-b383-fa434f73f7a6', 11, 19, 'Uttara, Dhaka, Bangladesh', '23.8758547', '90.3795438', '', ''),
(6, 127, 'a7de77cc-ab6b-4ded-a72b-4b5c4bf994bb', 12, 19, 'Australia Zoo, Steve Irwin Way, Beerwah QLD, Australia', '-26.8357181', '152.963113', '', '');

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

--
-- Table structure for table `location_settings`
--

CREATE TABLE `location_settings` (
  `id` bigint(20) NOT NULL,
  `template_id` bigint(20) NOT NULL,
  `org_id` int(11) NOT NULL,
  `is_active` tinyint(4) NOT NULL,
  `initial_message` text DEFAULT NULL,
  `notification_radius` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `location_settings`
--

INSERT INTO `location_settings` (`id`, `template_id`, `org_id`, `is_active`, `initial_message`, `notification_radius`) VALUES
(11, 126, 19, 1, '', 100),
(12, 127, 19, 1, '', 100);

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

--
-- Table structure for table `pass_summary_table`
--

CREATE TABLE `pass_summary_table` (
  `id` bigint(20) NOT NULL,
  `template_uid` varchar(255) NOT NULL,
  `template_name` varchar(255) NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` varchar(150) NOT NULL,
  `pass_data` longtext NOT NULL,
  `status` tinyint(4) NOT NULL,
  `org_id` bigint(20) NOT NULL,
  `pass_uid` varchar(255) NOT NULL,
  `expiry_status` tinyint(4) DEFAULT NULL,
  `recharge_status` tinyint(4) NOT NULL,
  `google_wallet_id` varchar(130) DEFAULT NULL,
  `apple_wallet_id` varchar(130) DEFAULT NULL,
  `google_wallet_type` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `pass_templates`
--

CREATE TABLE `pass_templates` (
  `id` int(11) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `template_data` longtext NOT NULL,
  `status` int(11) NOT NULL,
  `published_at` datetime DEFAULT NULL,
  `org_id` int(11) NOT NULL,
  `view_mode` tinyint(4) NOT NULL,
  `description` text NOT NULL,
  `pass_org_name` varchar(100) NOT NULL,
  `pass_limit` int(11) NOT NULL,
  `nfc` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `pass_unique_id`
--

CREATE TABLE `pass_unique_id` (
  `id` bigint(20) NOT NULL,
  `pass_template_id` char(36) DEFAULT NULL,
  `uid` bigint(20) NOT NULL,
  `pass_uid` char(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pass_unique_id`
--

INSERT INTO `pass_unique_id` (`id`, `pass_template_id`, `uid`, `pass_uid`) VALUES
(25, '1907d1e6-0a53-403b-897d-b62dc03138e7', 1693593343434, 'a6b0741a-00e1-422c-83a7-30d3aa80be70'),
(4, '5e8152be-4ea6-4dbb-8727-cdb5ec20156e', 1394712638477, ''),
(3, '5e8152be-4ea6-4dbb-8727-cdb5ec20156e', 9273783778095, ''),
(19, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 2484016779329, 'd33273da-7e10-42c3-aa58-51e550feafb1'),
(13, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 2535528469398, '72d098f8-c9b7-49a4-a720-79383e6af000'),
(20, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 2770064212167, '426614e6-9f2a-4edc-ab6a-45a2d39c0944'),
(8, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 2840666566827, '7d2b2a08-b45a-4f8a-98f0-dbac7239eb24'),
(10, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 3234737084465, 'fe52cf5a-8208-472c-ade5-d0404badd0a1'),
(23, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 4194937343890, 'b14b7438-2af2-4135-8883-13f39c9fe801'),
(9, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 4280992918909, 'd3547ee6-cd74-42ae-90c7-77c218bcae37'),
(17, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 4676924126853, 'b0e9a6bd-bfaa-4ca0-a7a7-444cf038cdad'),
(11, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 4859042565207, '112e5ea9-bdf7-4759-b076-2143b08fac4e'),
(21, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 5177017765284, 'c3878013-aa84-417c-b35d-a47435391f6e'),
(15, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 5360729209483, '44a8c7cd-382c-4f92-ad1d-5a90fa64bd54'),
(12, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 5982668587921, '518c0eb2-78a9-44de-9ec0-0d101edc38a2'),
(24, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 6467014482679, '351a81b2-f00c-45e9-97fa-de538a18c4f2'),
(18, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 6842901634837, '6c07b8b3-1ccb-4cf2-9c32-8466366b61f0'),
(14, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 7073027331450, 'ccb88343-b3d4-4119-8975-aea1f964f047'),
(16, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 7099480081442, '10cb3b1e-b6e5-44dd-abae-54ef95e59ef0'),
(22, 'ae0e7d9d-edbe-4a09-a2d2-4c8a96588f1c', 7874103713663, '083f31c3-b467-4221-a6ff-bedd1ed94fcc'),
(5, 'b1129541-7ee4-4ae0-a436-2e259f1ea427', 6078866165204, ''),
(6, 'b1129541-7ee4-4ae0-a436-2e259f1ea427', 8782788611746, ''),
(27, 'e146c454-695c-4115-b890-434fc2cf62e2', 3622509808859, 'd7dfb44f-1bc1-48b0-abe2-598dc520d10d'),
(28, 'e146c454-695c-4115-b890-434fc2cf62e2', 7652338303301, 'fb23d4c4-3fee-41ba-ae47-c63bf82b210f'),
(26, 'e146c454-695c-4115-b890-434fc2cf62e2', 9888499766484, 'b742359b-5c27-464f-839d-7f243e78ce17'),
(7, 'fa67a0c5-0012-4276-9edc-c0531c006fc0', 5324447445873, '4af46044-af90-491e-a4cd-80258675b216');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `role` varchar(10) NOT NULL,
  `status` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `role_id`, `role`, `status`) VALUES
(46, 23, '1.1', 'no'),
(47, 23, '1.2', 'no'),
(48, 23, '1.3', 'no'),
(49, 23, '1.4', 'no'),
(51, 25, '1.1', 'yes'),
(52, 25, '1.2', 'yes'),
(53, 25, '1.3', 'yes'),
(54, 25, '1.4', 'yes');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `role_name` varchar(150) NOT NULL,
  `org_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL COMMENT '1=active, 0=inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `role_name`, `org_id`, `status`) VALUES
(21, 'user', 7, 1),
(22, 'user', 7, 1),
(23, 'Moderator', 17, 1),
(24, 'user', 17, 1),
(25, 'Admin', 19, 1);

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

--
-- Table structure for table `transection_log`
--

CREATE TABLE `transection_log` (
  `id` bigint(20) NOT NULL,
  `note` varchar(255) DEFAULT NULL,
  `amount` float NOT NULL,
  `user` bigint(20) NOT NULL,
  `pass_id` text NOT NULL,
  `ip_address` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `org_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `transection_log`
--

INSERT INTO `transection_log` (`id`, `note`, `amount`, `user`, `pass_id`, `ip_address`, `created_at`, `org_id`) VALUES
(8, 'initial balance 2500', 2500, 19, '41935a58-59e0-4592-b37a-155c03bd769f', '103.204.86.250', '2024-02-14 12:27:53', 19),
(9, 'initial balance 1000', 1000, 19, '0ef59198-3ef5-4dc3-8ea3-eb9df5909efb', '103.204.86.250', '2024-02-14 12:28:36', 19),
(10, 'recharge', 100, 19, '0ef59198-3ef5-4dc3-8ea3-eb9df5909efb', '103.204.86.250', '2024-02-14 12:29:34', 19),
(11, '', 10, 19, '41935a58-59e0-4592-b37a-155c03bd769f', '103.204.86.250', '2024-02-14 13:42:29', 19),
(12, 'initial balance 1500', 1500, 19, '1c8b9e4b-eadd-480e-9f5b-27b31903123e', '103.204.86.250', '2024-03-05 17:00:01', 19),
(13, 'initial balance 6000', 6000, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-05 14:43:14', 19),
(14, '', 50, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-05 16:02:36', 19),
(15, '', 10, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-05 16:03:47', 19),
(16, '', 10, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 09:27:59', 19),
(17, '', 80, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 09:28:33', 19),
(18, 'topup', 150, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:01:37', 19),
(19, '', 200, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:07:07', 19),
(20, '', 50, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:23:40', 19),
(21, '', 50, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:26:45', 19),
(22, '', 100, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:34:24', 19),
(23, '', 100, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:35:05', 19),
(24, '', 5, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:36:57', 19),
(25, '', 50, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:39:59', 19),
(26, '', 3, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:49:44', 19),
(27, '', 2, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:50:35', 19),
(28, '', 40, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:50:48', 19),
(29, '', 100, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:53:33', 19),
(30, '', 500, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 10:53:49', 19),
(31, '', 200, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:09:52', 19),
(32, '', 20, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:12:58', 19),
(33, '', 2, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:14:56', 19),
(34, '', 3, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:15:21', 19),
(35, '', 5, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:15:51', 19),
(36, '', 5, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:16:54', 19),
(37, '', 65, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:18:52', 19),
(38, '', 200, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:19:18', 19),
(39, '', 2000, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:22:14', 19),
(40, '', 2000, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:28:57', 19),
(41, '', 3000, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 11:49:15', 19),
(42, '', 100, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 15:29:48', 19),
(43, '', 300, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 16:29:17', 19),
(44, '', 600, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 16:45:54', 19),
(45, '', 100, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 16:47:10', 19),
(46, '', 1000, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-06 16:52:05', 19),
(47, '', 50, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-07 12:02:02', 19),
(48, '', 100, 19, 'e79425ac-caa5-4793-9263-f3e1f59699b3', '103.204.86.250', '2024-04-07 12:13:34', 19),
(49, 'initial balance 2500', 2500, 19, '7d945213-3a65-491e-a788-2bd041e29c14', '103.204.87.5', '2024-05-01 16:51:48', 19),
(50, 'initial balance 3200', 3200, 19, '0a34aceb-9332-488b-93c6-d450f8bfbc42', '103.204.87.5', '2024-05-01 18:52:48', 19);

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

--
-- Table structure for table `wallet_pass`
--

CREATE TABLE `wallet_pass` (
  `id` int(11) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `template_id` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `org_id` int(11) NOT NULL,
  `date_time` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `expiry_status` tinyint(4) NOT NULL,
  `google_wallet_id` varchar(130) DEFAULT NULL,
  `apple_wallet_id` varchar(130) DEFAULT NULL,
  `google_wallet_type` varchar(50) DEFAULT NULL,
  `google_wallet_link` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `additional_fields`
--
ALTER TABLE `additional_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pass_id` (`pass_id`),
  ADD KEY `pass_id_2` (`pass_id`),
  ADD KEY `pass_id_3` (`pass_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `pass_unique_id`
--
ALTER TABLE `pass_unique_id`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pass_template_id` (`pass_template_id`,`uid`,`pass_uid`),
  ADD KEY `pass_template_id_2` (`pass_template_id`,`pass_uid`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `advance_settings`
--
ALTER TABLE `advance_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `apple_wallet_settings`
--
ALTER TABLE `apple_wallet_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `beacons`
--
ALTER TABLE `beacons`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `beacon_settings`
--
ALTER TABLE `beacon_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `bulk_jobs`
--
ALTER TABLE `bulk_jobs`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `certificates`
--
ALTER TABLE `certificates`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `google_wallet_settings`
--
ALTER TABLE `google_wallet_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `location_settings`
--
ALTER TABLE `location_settings`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `pass_summary_table`
--
ALTER TABLE `pass_summary_table`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=167;

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

--
-- AUTO_INCREMENT for table `pass_unique_id`
--
ALTER TABLE `pass_unique_id`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

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

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

--
-- AUTO_INCREMENT for table `transection_log`
--
ALTER TABLE `transection_log`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `wallet_pass`
--
ALTER TABLE `wallet_pass`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87980;
COMMIT;

