--
-- Host: localhost    Database: infosanluis
-- ------------------------------------------------------


--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(191) DEFAULT NULL,
  `description` text NOT NULL,
  `subject_type` varchar(191) DEFAULT NULL,
  `event` varchar(191) DEFAULT NULL,
  `subject_id` bigint(20) unsigned DEFAULT NULL,
  `causer_type` varchar(191) DEFAULT NULL,
  `causer_id` bigint(20) unsigned DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`)),
  `batch_uuid` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject` (`subject_type`,`subject_id`),
  KEY `causer` (`causer_type`,`causer_id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_log`
--

INSERT INTO `activity_log` VALUES
(10,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-06 11:59:36','2025-02-06 11:59:36'),
(11,'Setting (Application)','Application updated','Modules\\Setting\\Entities\\Application','updated',1,'App\\Models\\User',1,'{\"attributes\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1723373981logo.png\",\"sidebar_logo\":\"application\\/1723374016sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1723374002sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1738822065login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-06T06:07:45.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1723374017footer_logo.png\",\"app_logo\":\"application\\/1723374017app_logo.png\",\"mobile_menu_image\":\"application\\/1723374002mobile_menu_image.png\",\"time_zone\":\"Africa\\/Abidjan\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1},\"old\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1723373981logo.png\",\"sidebar_logo\":\"application\\/1723374016sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1723374002sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1723374002login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2024-08-11T05:00:17.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1723374017footer_logo.png\",\"app_logo\":\"application\\/1723374017app_logo.png\",\"mobile_menu_image\":\"application\\/1723374002mobile_menu_image.png\",\"time_zone\":\"Africa\\/Abidjan\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1}}',NULL,'2025-02-06 12:07:45','2025-02-06 12:07:45'),
(12,'Setting (Application)','Application updated','Modules\\Setting\\Entities\\Application','updated',1,'App\\Models\\User',1,'{\"attributes\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1723373981logo.png\",\"sidebar_logo\":\"application\\/1723374016sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1723374002sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1738822099login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-06T06:08:19.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1723374017footer_logo.png\",\"app_logo\":\"application\\/1723374017app_logo.png\",\"mobile_menu_image\":\"application\\/1723374002mobile_menu_image.png\",\"time_zone\":\"Africa\\/Abidjan\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1},\"old\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1723373981logo.png\",\"sidebar_logo\":\"application\\/1723374016sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1723374002sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1738822065login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-06T06:07:45.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1723374017footer_logo.png\",\"app_logo\":\"application\\/1723374017app_logo.png\",\"mobile_menu_image\":\"application\\/1723374002mobile_menu_image.png\",\"time_zone\":\"Africa\\/Abidjan\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1}}',NULL,'2025-02-06 12:08:19','2025-02-06 12:08:19'),
(13,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-06 12:21:04','2025-02-06 12:21:04'),
(14,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-08 14:22:05','2025-02-08 14:22:05'),
(15,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-08 14:53:19','2025-02-08 14:53:19'),
(16,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-08 14:54:04','2025-02-08 14:54:04'),
(17,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-08 19:14:42','2025-02-08 19:14:42'),
(18,'User','created','App\\Models\\User','created',2,'App\\Models\\User',1,'[]',NULL,'2025-02-08 19:29:46','2025-02-08 19:29:46'),
(19,'Setting (Application)','Application updated','Modules\\Setting\\Entities\\Application','updated',1,'App\\Models\\User',1,'{\"attributes\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1723373981logo.png\",\"sidebar_logo\":\"application\\/1723374016sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1723374002sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1738822099login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T15:13:11.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1723374017footer_logo.png\",\"app_logo\":\"application\\/1723374017app_logo.png\",\"mobile_menu_image\":\"application\\/1723374002mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1},\"old\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1723373981logo.png\",\"sidebar_logo\":\"application\\/1723374016sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1723374002sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1738822099login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-06T06:08:19.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1723374017footer_logo.png\",\"app_logo\":\"application\\/1723374017app_logo.png\",\"mobile_menu_image\":\"application\\/1723374002mobile_menu_image.png\",\"time_zone\":\"Africa\\/Abidjan\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1}}',NULL,'2025-02-08 21:13:11','2025-02-08 21:13:11'),
(20,'Setting (Application)','Application updated','Modules\\Setting\\Entities\\Application','updated',1,'App\\Models\\User',1,'{\"attributes\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1739030072logo.png\",\"sidebar_logo\":\"application\\/1739030072sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1739030072sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1739030072login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T15:54:34.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1739030073footer_logo.png\",\"app_logo\":\"application\\/1739030073app_logo.png\",\"mobile_menu_image\":\"application\\/1739030074mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1},\"old\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1723373981logo.png\",\"sidebar_logo\":\"application\\/1723374016sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1723374002sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1738822099login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T15:13:11.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1723374017footer_logo.png\",\"app_logo\":\"application\\/1723374017app_logo.png\",\"mobile_menu_image\":\"application\\/1723374002mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1}}',NULL,'2025-02-08 21:54:34','2025-02-08 21:54:34'),
(21,'Setting (Application)','Application updated','Modules\\Setting\\Entities\\Application','updated',1,'App\\Models\\User',1,'{\"attributes\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"Infosanluis\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1739030072logo.png\",\"sidebar_logo\":\"application\\/1739030072sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1739030072sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1739030072login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T16:05:17.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1739030073footer_logo.png\",\"app_logo\":\"application\\/1739030073app_logo.png\",\"mobile_menu_image\":\"application\\/1739030074mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1},\"old\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"New365\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1739030072logo.png\",\"sidebar_logo\":\"application\\/1739030072sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1739030072sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1739030072login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T15:54:34.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1739030073footer_logo.png\",\"app_logo\":\"application\\/1739030073app_logo.png\",\"mobile_menu_image\":\"application\\/1739030074mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1}}',NULL,'2025-02-08 22:05:17','2025-02-08 22:05:17'),
(22,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-09 03:29:11','2025-02-09 03:29:11'),
(23,'Setting (Application)','Application updated','Modules\\Setting\\Entities\\Application','updated',1,'App\\Models\\User',1,'{\"attributes\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"Infosanluis\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":127,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1739030072logo.png\",\"sidebar_logo\":\"application\\/1739030072sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1739030072sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1739030072login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T22:33:25.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1739030073footer_logo.png\",\"app_logo\":\"application\\/1739030073app_logo.png\",\"mobile_menu_image\":\"application\\/1739030074mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1},\"old\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"Infosanluis\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1739030072logo.png\",\"sidebar_logo\":\"application\\/1739030072sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1739030072sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1739030072login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T16:05:17.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1739030073footer_logo.png\",\"app_logo\":\"application\\/1739030073app_logo.png\",\"mobile_menu_image\":\"application\\/1739030074mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1}}',NULL,'2025-02-09 04:33:25','2025-02-09 04:33:25'),
(24,'Setting (Application)','Application updated','Modules\\Setting\\Entities\\Application','updated',1,'App\\Models\\User',1,'{\"attributes\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"Infosanluis\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":0,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1739030072logo.png\",\"sidebar_logo\":\"application\\/1739030072sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1739030072sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1739030072login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T22:33:51.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1739030073footer_logo.png\",\"app_logo\":\"application\\/1739030073app_logo.png\",\"mobile_menu_image\":\"application\\/1739030074mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1},\"old\":{\"id\":1,\"language_id\":1,\"currency_id\":1,\"title\":\"Infosanluis\",\"phone\":\"880-258970255\",\"email\":\"info@bdtask.com\",\"website\":\"https:\\/\\/www.bdtask.com\",\"prefix\":\"BT\",\"address\":\"B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh\",\"tax_no\":\"43242424\",\"rtl_ltr\":1,\"negative_amount_symbol\":1,\"floating_number\":1,\"fixed_date\":127,\"footer_text\":\"BDTASK \\u00a9 2022. All Rights Reserved.\",\"logo\":\"application\\/1739030072logo.png\",\"sidebar_logo\":\"application\\/1739030072sidebar-logo.png\",\"favicon\":\"application\\/1723374002favicon.png\",\"sidebar_collapsed_logo\":\"application\\/1739030072sidebar-collapsed-logo.png\",\"login_image\":\"application\\/1739030072login-image.png\",\"created_at\":\"2022-10-12T10:46:42.000000Z\",\"updated_at\":\"2025-02-08T22:33:25.000000Z\",\"deleted_at\":null,\"state_income_tax\":5,\"soc_sec_npf_tax\":0,\"employer_contribution\":0,\"icf_amount\":0,\"footer_logo\":\"application\\/1739030073footer_logo.png\",\"app_logo\":\"application\\/1739030073app_logo.png\",\"mobile_menu_image\":\"application\\/1739030074mobile_menu_image.png\",\"time_zone\":\"America\\/Argentina\\/Buenos_Aires\",\"copy_right\":null,\"newstriker_status\":1,\"preloader_status\":1,\"speed_optimization\":1}}',NULL,'2025-02-09 04:33:51','2025-02-09 04:33:51'),
(25,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-09 14:34:13','2025-02-09 14:34:13'),
(26,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-10 08:51:09','2025-02-10 08:51:09'),
(27,'Login','Logged In',NULL,NULL,NULL,'App\\Models\\User',1,'[]',NULL,'2025-02-12 08:31:31','2025-02-12 08:31:31');

--
-- Table structure for table `ad_s`
--

CREATE TABLE `ad_s` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `page` int(11) NOT NULL,
  `ad_position` int(11) NOT NULL,
  `embed_code` text NOT NULL,
  `large_status` int(11) NOT NULL DEFAULT 1,
  `mobile_status` int(11) NOT NULL DEFAULT 1,
  `theme` varchar(100) NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ad_s`
--

INSERT INTO `ad_s` VALUES
(1,'abc626b0-a4a5-4679-8b8d-2aafae63be5d',1,11,'<script><script async src=\"https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-2922170655495017\" crossorigin=\"anonymous\"></script> <ins class=\"adsbygoogle\"   style=\"display:block\" data-ad-client=\"ca-pub-2922170655495017\" data-ad-slot=\"8352319773\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"></ins></script>',1,1,'Osru-Theme',1,1,'2025-02-09 03:47:45','2025-02-09 04:07:05','2025-02-09 04:07:05'),
(2,'4844a1bd-633e-495d-a62b-cee7d5c65665',1,11,'<a target=\"_blank\" href=\"http://toyota.com.ar\"><img width=\"100%\" src=\"http://143.198.224.178/admin/storage/ad_image/1739052361969.jpg\" alt=\"\"></a>',1,1,'Osru-Theme',1,NULL,'2025-02-09 04:06:01','2025-02-09 04:06:01',NULL),
(3,'00e65874-1838-4694-ba4a-7be928827ba6',1,12,'<a target=\"_blank\" href=\"http://dfwsef.com\"><img width=\"100%\" src=\"http://143.198.224.178/admin/storage/ad_image/1739053002214.jpg\" alt=\"\"></a>',1,1,'Osru-Theme',1,1,'2025-02-09 04:07:59','2025-02-09 04:16:42',NULL);

--
-- Table structure for table `app_settings`
--

CREATE TABLE `app_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `website_title` text DEFAULT NULL,
  `footer_text` text DEFAULT NULL,
  `copy_right` text DEFAULT NULL,
  `time_zone` varchar(200) DEFAULT NULL,
  `ltl_rtl` varchar(200) DEFAULT NULL,
  `logo` varchar(200) DEFAULT NULL,
  `footer_logo` varchar(200) DEFAULT NULL,
  `favicon` varchar(200) DEFAULT NULL,
  `app_logo` text DEFAULT NULL,
  `mobile_menu_image` varchar(200) DEFAULT NULL,
  `newstriker_status` tinyint(4) DEFAULT NULL,
  `share_status` tinyint(4) DEFAULT NULL,
  `preloader_status` tinyint(4) DEFAULT NULL,
  `speed_optimization` tinyint(4) DEFAULT NULL,
  `captcha` tinyint(4) DEFAULT NULL,
  `version` varchar(50) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_settings`
--

INSERT INTO `app_settings` VALUES
(1,'dfce03ab-ccc9-480d-977a-614e95f3b2ab','Infosanluis','BDTASK © 2022. All Rights Reserved.',NULL,'America/Argentina/Buenos_Aires','1','application/1739030072logo.png','application/1739030073footer_logo.png','application/1723374002favicon.png','application/1739030073app_logo.png','application/1739030074mobile_menu_image.png',1,NULL,1,1,NULL,NULL,2,1,'2024-07-27 23:33:02','2025-02-08 22:05:17',NULL);

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `language_id` int(11) DEFAULT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `website` varchar(191) DEFAULT NULL,
  `prefix` varchar(191) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `tax_no` varchar(191) DEFAULT NULL,
  `rtl_ltr` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1=LTR,2=RTL',
  `negative_amount_symbol` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1=-,2=()',
  `floating_number` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1 = 0, 2 = 0.0 ,3= 0.00, 4= 0.000 ',
  `fixed_date` tinyint(1) NOT NULL DEFAULT 0,
  `footer_text` varchar(191) NOT NULL,
  `logo` varchar(191) DEFAULT NULL,
  `sidebar_logo` varchar(191) DEFAULT NULL,
  `favicon` varchar(191) DEFAULT NULL,
  `sidebar_collapsed_logo` varchar(191) DEFAULT NULL,
  `login_image` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `state_income_tax` int(11) NOT NULL DEFAULT 5,
  `soc_sec_npf_tax` int(11) NOT NULL DEFAULT 0,
  `employer_contribution` int(11) NOT NULL DEFAULT 0 COMMENT 'Employer Contribution in Percent',
  `icf_amount` int(11) NOT NULL DEFAULT 0,
  `footer_logo` varchar(200) DEFAULT NULL,
  `app_logo` text DEFAULT NULL,
  `mobile_menu_image` varchar(200) DEFAULT NULL,
  `time_zone` varchar(200) DEFAULT NULL,
  `copy_right` text DEFAULT NULL,
  `newstriker_status` tinyint(4) DEFAULT NULL,
  `preloader_status` tinyint(4) DEFAULT NULL,
  `speed_optimization` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `applications`
--

INSERT INTO `applications` VALUES
(1,1,1,'Infosanluis','880-258970255','info@bdtask.com','https://www.bdtask.com','BT','B-25, Mannan Plaza, 4th Floor Khilkhet, Dhaka-1229, Bangladesh','43242424',1,1,1,0,'BDTASK © 2022. All Rights Reserved.','application/1739030072logo.png','application/1739030072sidebar-logo.png','application/1723374002favicon.png','application/1739030072sidebar-collapsed-logo.png','application/1739030072login-image.png','2022-10-12 16:46:42','2025-02-09 04:33:51',NULL,5,0,0,0,'application/1739030073footer_logo.png','application/1739030073app_logo.png','application/1739030074mobile_menu_image.png','America/Argentina/Buenos_Aires',NULL,1,1,1);

--
-- Table structure for table `breaking_news`
--

CREATE TABLE `breaking_news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `time_stamp` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `breaking_news`
--

INSERT INTO `breaking_news` VALUES
(1,'{\"news_title\":\"La Municipalidad de San Luis avanza con el arreglo de calles en el centro antes del inicio de las clases\",\"url\":\"http:\\/\\/infosanluis.com.ar\\/adminMobile\\/details\\/1\\/La-Municipalidad-de-San-Luis-avanza-con-el-arreglo-de-calles-en-el-centro-antes-del-inicio-de-las-clases\"}',1739021415,1,'2025-02-08 19:30:15','2025-02-08 19:30:15'),
(2,'{\"news_title\":\"La Municipalidad de San Luis avanza con el arreglo de calles en el centro antes del inicio de las clases\",\"url\":\"http:\\/\\/infosanluis.com.ar\\/adminSan-Luis\\/details\\/1\\/La-Municipalidad-de-San-Luis-avanza-con-el-arreglo-de-calles-en-el-centro-antes-del-inicio-de-las-clases\"}',1739030686,1,'2025-02-08 22:04:46','2025-02-08 22:04:46'),
(3,'{\"news_title\":\"La Municipalidad de San Luis avanza con el arreglo de calles en el centro antes del inicio de las clases\",\"url\":\"http:\\/\\/infosanluis.com.ar\\/adminSan-Luis\\/details\\/1\\/La-Municipalidad-de-San-Luis-avanza-con-el-arreglo-de-calles-en-el-centro-antes-del-inicio-de-las-clases\"}',1739030892,1,'2025-02-08 22:08:12','2025-02-08 22:08:12');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `category_id` int(11) NOT NULL,
  `category_name` text NOT NULL,
  `slug` text NOT NULL,
  `menu` int(11) NOT NULL DEFAULT 0,
  `position` int(11) NOT NULL DEFAULT 1,
  `parents_id` varchar(200) DEFAULT NULL,
  `category_imgae` text DEFAULT NULL,
  `img_status` tinyint(4) NOT NULL DEFAULT 0,
  `category_type` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES
(3,'7074bf24-c640-4162-b76c-20ee8aef04e2',3,'San Luis','San-Luis',0,1,NULL,'',0,1,'San Luis',1,1,'2025-02-08 21:59:52','2025-02-08 21:59:52',NULL),
(4,'44dd70c6-0b47-4cc2-bcf9-dc0a78794f80',4,'Villa Mercedes','Villa-Mercedes',0,1,NULL,'',0,1,'Villa Mercedes',1,1,'2025-02-08 22:00:17','2025-02-08 22:00:17',NULL),
(5,'f531696f-3979-4718-a23e-56c4c1a17bd3',5,'Merlo','Merlo',0,1,NULL,'',0,1,'Merlo',1,1,'2025-02-08 22:00:53','2025-02-08 22:00:53',NULL),
(6,'940fc93d-7e8b-4dbe-81d8-74effdc6ee58',6,'Interior','Interior',0,1,NULL,'',0,1,'Interior',1,1,'2025-02-08 22:01:09','2025-02-08 22:01:09',NULL);

--
-- Table structure for table `category_topics`
--

CREATE TABLE `category_topics` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `cat_slug` varchar(200) DEFAULT NULL,
  `topic` varchar(100) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_topics`
--


--
-- Table structure for table `comments_infos`
--

CREATE TABLE `comments_infos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `com_id` int(11) NOT NULL,
  `comments` text NOT NULL,
  `com_rating` int(11) DEFAULT NULL,
  `news_id` varchar(255) NOT NULL,
  `com_user_id` int(11) NOT NULL,
  `com_replay_id` int(11) NOT NULL,
  `com_date_time` varchar(50) NOT NULL,
  `com_type` int(11) DEFAULT NULL,
  `com_status` int(11) NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments_infos`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `country_name` varchar(191) NOT NULL,
  `country_code` varchar(191) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--


--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `title` varchar(191) NOT NULL,
  `symbol` char(191) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES
(1,14,'Taka','৳',1,'2024-06-26 10:49:45','2024-06-26 10:49:45');

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `department_name` varchar(100) NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` VALUES
(1,'Reporting',NULL,NULL,NULL,NULL,NULL),
(2,'Central',NULL,NULL,NULL,NULL,NULL),
(3,'Country',NULL,NULL,NULL,NULL,NULL),
(4,'Feature',NULL,NULL,NULL,NULL,NULL),
(5,'Game',NULL,NULL,NULL,NULL,NULL),
(6,'International',NULL,NULL,NULL,NULL,NULL),
(7,'Editorial and research',NULL,NULL,NULL,NULL,NULL),
(8,'Business Development and Marketing Department',NULL,NULL,NULL,NULL,NULL),
(9,'Web',NULL,NULL,NULL,NULL,NULL),
(10,'Social media',NULL,NULL,NULL,NULL,NULL),
(11,'Video section',NULL,NULL,NULL,NULL,NULL),
(12,'Administration Department',NULL,NULL,NULL,NULL,NULL),
(13,'Others',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `division_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `bn_name` varchar(255) NOT NULL,
  `lat` varchar(255) NOT NULL,
  `lon` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `districts_division_id_foreign` (`division_id`),
  CONSTRAINT `districts_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `districts`
--


--
-- Table structure for table `divisions`
--

CREATE TABLE `divisions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `bn_name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `divisions`
--


--
-- Table structure for table `doc_expired_settings`
--

CREATE TABLE `doc_expired_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `primary_expiration_alert` int(11) NOT NULL COMMENT 'Primary Expiration Alert in Days',
  `secondary_expiration_alert` int(11) NOT NULL COMMENT 'Secondary Expiration Alert in Days',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doc_expired_settings`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `home_page_positions`
--

CREATE TABLE `home_page_positions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(200) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `max_news` varchar(200) DEFAULT NULL,
  `category_id` bigint(20) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_page_positions`
--

INSERT INTO `home_page_positions` VALUES
(1,'San Luis','San-Luis',NULL,3,0,'2025-02-08 22:09:11','2025-02-08 22:09:11'),
(2,'Villa Mercedes','Villa-Mercedes',NULL,4,0,'2025-02-08 22:09:31','2025-02-08 22:09:31'),
(3,'Merlo','Merlo',NULL,5,0,'2025-02-08 22:09:39','2025-02-08 22:09:39'),
(4,'Interior','Interior',NULL,6,0,'2025-02-08 22:09:48','2025-02-08 22:09:48'),
(5,'San Luis','San-Luis',NULL,3,0,'2025-02-09 03:36:16','2025-02-09 03:36:16'),
(6,'San Luis','San-Luis',NULL,3,0,'2025-02-09 03:36:24','2025-02-09 03:36:24');

--
-- Table structure for table `lang`
--

CREATE TABLE `lang` (
  `id` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  `value` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `lang`
--

INSERT INTO `lang` VALUES
(1,'English','en'),
(2,'Afar','aa'),
(3,'Abkhazian','ab'),
(4,'Afrikaans','af'),
(5,'Amharic','am'),
(6,'Arabic','ar'),
(7,'Assamese','as'),
(8,'Aymara','ay'),
(9,'Azerbaijani','az'),
(10,'Bashkir','ba'),
(11,'Belarusian','be'),
(12,'Bulgarian','bg'),
(13,'Bihari','bh'),
(14,'Bislama','bi'),
(15,'Bengali/Bangla','bn'),
(16,'Tibetan','bo'),
(17,'Breton','br'),
(18,'Catalan','ca'),
(19,'Corsican','co'),
(20,'Czech','cs'),
(21,'Welsh','cy'),
(22,'Danish','da'),
(23,'German','de'),
(24,'Bhutani','dz'),
(25,'Greek','el'),
(26,'Esperanto','eo'),
(27,'Spanish','es'),
(28,'Estonian','et'),
(29,'Basque','eu'),
(30,'Persian','fa'),
(31,'Finnish','fi'),
(32,'Fiji','fj'),
(33,'Faeroese','fo'),
(34,'French','fr'),
(35,'Frisian','fy'),
(36,'Irish','ga'),
(37,'Scots/Gaelic','gd'),
(38,'Galician','gl'),
(39,'Guarani','gn'),
(40,'Gujarati','gu'),
(41,'Hausa','ha'),
(42,'Hindi','hi'),
(43,'Croatian','hr'),
(44,'Hungarian','hu'),
(45,'Armenian','hy'),
(46,'Interlingua','ia'),
(47,'Interlingue','ie'),
(48,'Inupiak','ik'),
(49,'Indonesian','in'),
(50,'Icelandic','is'),
(51,'Italian','it'),
(52,'Hebrew','iw'),
(53,'Japanese','ja'),
(54,'Yiddish','ji'),
(55,'Javanese','jw'),
(56,'Georgian','ka'),
(57,'Kazakh','kk'),
(58,'Greenlandic','kl'),
(59,'Cambodian','km'),
(60,'Kannada','kn'),
(61,'Korean','ko'),
(62,'Kashmiri','ks'),
(63,'Kurdish','ku'),
(64,'Kirghiz','ky'),
(65,'Latin','la'),
(66,'Lingala','ln'),
(67,'Laothian','lo'),
(68,'Lithuanian','lt'),
(69,'Latvian/Lettish','lv'),
(70,'Malagasy','mg'),
(71,'Maori','mi'),
(72,'Macedonian','mk'),
(73,'Malayalam','ml'),
(74,'Mongolian','mn'),
(75,'Moldavian','mo'),
(76,'Marathi','mr'),
(77,'Malay','ms'),
(78,'Maltese','mt'),
(79,'Burmese','my'),
(80,'Nauru','na'),
(81,'Nepali','ne'),
(82,'Dutch','nl'),
(83,'Norwegian','no'),
(84,'Occitan','oc'),
(85,'(Afan)/Oromoor/Oriya','om'),
(86,'Punjabi','pa'),
(87,'Polish','pl'),
(88,'Pashto/Pushto','ps'),
(89,'Portuguese','pt'),
(90,'Quechua','qu'),
(91,'Rhaeto-Romance','rm'),
(92,'Kirundi','rn'),
(93,'Romanian','ro'),
(94,'Russian','ru'),
(95,'Kinyarwanda','rw'),
(96,'Sanskrit','sa'),
(97,'Sindhi','sd'),
(98,'Sangro','sg'),
(99,'Serbo-Croatian','sh'),
(100,'Singhalese','si'),
(101,'Slovak','sk'),
(102,'Slovenian','sl'),
(103,'Samoan','sm'),
(104,'Shona','sn'),
(105,'Somali','so'),
(106,'Albanian','sq'),
(107,'Serbian','sr'),
(108,'Siswati','ss'),
(109,'Sesotho','st'),
(110,'Sundanese','su'),
(111,'Swedish','sv'),
(112,'Swahili','sw'),
(113,'Tamil','ta'),
(114,'Telugu','te'),
(115,'Tajik','tg'),
(116,'Thai','th'),
(117,'Tigrinya','ti'),
(118,'Turkmen','tk'),
(119,'Tagalog','tl'),
(120,'Setswana','tn'),
(121,'Tonga','to'),
(122,'Turkish','tr'),
(123,'Tsonga','ts'),
(124,'Tatar','tt'),
(125,'Twi','tw'),
(126,'Ukrainian','uk'),
(127,'Urdu','ur'),
(128,'Uzbek','uz'),
(129,'Vietnamese','vi'),
(130,'Volapuk','vo'),
(131,'Wolof','wo'),
(132,'Xhosa','xh'),
(133,'Yoruba','yo'),
(134,'Chinese','zh'),
(135,'Zulu','zu');

--
-- Table structure for table `langstrvals`
--

CREATE TABLE `langstrvals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `localize_id` bigint(20) unsigned NOT NULL,
  `langstring_id` bigint(20) unsigned NOT NULL,
  `value` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `langstrvals`
--


--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `langname` varchar(191) NOT NULL,
  `value` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES
(1,'English','en','2022-12-08 00:29:24','2022-12-08 00:29:24'),
(5,'Spanish','es','2025-02-09 04:35:10','2025-02-09 04:35:10');

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `level` text NOT NULL,
  `url` varchar(120) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `links`
--


--
-- Table structure for table `max_archive_settings`
--

CREATE TABLE `max_archive_settings` (
  `category_id` int(11) NOT NULL,
  `uuid` varchar(191) NOT NULL,
  `max_archive` int(11) NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `max_archive_settings`
--


--
-- Table structure for table `menu_contents`
--

CREATE TABLE `menu_contents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `content_type` text DEFAULT NULL,
  `content_id` bigint(20) DEFAULT NULL,
  `menu_position` int(11) DEFAULT NULL,
  `menu_level` varchar(255) DEFAULT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `menu_id` bigint(20) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_contents`
--

INSERT INTO `menu_contents` VALUES
(1,'categories',6,NULL,'Interior',NULL,'Interior',NULL,3,1,'2025-02-08 22:06:11','2025-02-08 22:06:11'),
(2,'categories',5,NULL,'Merlo',NULL,'Merlo',NULL,3,1,'2025-02-08 22:06:11','2025-02-08 22:06:11'),
(3,'categories',4,NULL,'Villa Mercedes',NULL,'Villa-Mercedes',NULL,3,1,'2025-02-08 22:06:11','2025-02-08 22:06:11'),
(4,'categories',3,NULL,'San Luis',NULL,'San-Luis',NULL,3,1,'2025-02-08 22:06:11','2025-02-08 22:06:11'),
(5,'categories',6,NULL,'Interior',NULL,'Interior',NULL,2,1,'2025-02-08 22:06:59','2025-02-08 22:06:59'),
(6,'categories',5,NULL,'Merlo',NULL,'Merlo',NULL,2,1,'2025-02-08 22:06:59','2025-02-08 22:06:59'),
(7,'categories',4,NULL,'Villa Mercedes',NULL,'Villa-Mercedes',NULL,2,1,'2025-02-08 22:06:59','2025-02-08 22:06:59'),
(8,'categories',3,NULL,'San Luis',NULL,'San-Luis',NULL,2,1,'2025-02-08 22:06:59','2025-02-08 22:06:59'),
(9,'categories',6,NULL,'Interior',NULL,'Interior',NULL,1,1,'2025-02-08 22:07:08','2025-02-08 22:07:08'),
(10,'categories',5,NULL,'Merlo',NULL,'Merlo',NULL,1,1,'2025-02-08 22:07:08','2025-02-08 22:07:08'),
(11,'categories',4,NULL,'Villa Mercedes',NULL,'Villa-Mercedes',NULL,1,1,'2025-02-08 22:07:08','2025-02-08 22:07:08'),
(12,'categories',3,NULL,'San Luis',NULL,'San-Luis',NULL,1,1,'2025-02-08 22:07:08','2025-02-08 22:07:08');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `style` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `mobile_status` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES
(1,'Main Menu',1,NULL,0,1,'2024-07-07 09:18:50','2025-02-08 22:06:46'),
(2,'Category',2,NULL,0,1,'2024-07-07 09:18:50','2025-02-08 22:06:44'),
(3,'Page',3,NULL,0,1,'2024-07-07 09:18:50','2025-02-08 22:06:31');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES
(1,'2014_10_12_100000_create_password_resets_table',1),
(2,'2019_08_19_000000_create_failed_jobs_table',1),
(3,'2019_12_14_000001_create_personal_access_tokens_table',1),
(4,'2022_04_06_050120_create_pictures_table',1),
(5,'2022_04_13_032828_create_applications_table',1),
(6,'2022_04_13_050141_create_currencies_table',1),
(7,'2022_04_18_075935_create_email_configs_table',1),
(8,'2022_08_06_043012_create_users_table',1),
(9,'2022_08_06_043013_create_user_types_table',1),
(10,'2022_08_06_054634_create_password_settings_table',1),
(11,'2022_08_08_034517_create_countries_table',1),
(12,'2022_10_10_100252_create_permission_tables',1),
(13,'2022_10_10_102515_create_per_menus_table',1),
(14,'2022_11_10_035218_create_notifications_table',1),
(15,'2022_12_07_071056_create_languages_table',1),
(16,'2022_12_07_094945_create_langstrings_table',1),
(17,'2022_12_07_095044_create_langstrvals_table',1),
(18,'2023_04_29_104322_create_zkts_table',1),
(19,'2023_05_07_094405_create_doc_expired_settings_table',1),
(20,'2023_07_23_103802_create_prefixes_table',1),
(21,'2023_08_13_104855_create_activity_log_table',1),
(22,'2023_08_13_104856_add_event_column_to_activity_log_table',1),
(23,'2023_08_13_104857_add_batch_uuid_column_to_activity_log_table',1),
(24,'2024_05_05_053538_update_applications_table',1),
(25,'2024_05_16_114541_create_appsettings_table',1),
(26,'2024_06_10_064636_create_categories_table',1),
(27,'2024_06_10_133007_create_category_topics_table',1),
(28,'2024_06_11_080405_create_settings_table',1),
(29,'2024_06_11_090858_create_advertisements_table',1),
(30,'2024_06_12_104021_create_reporters_table',1),
(31,'2024_06_13_065421_create_departments_table',1),
(32,'2024_06_26_103727_create_pages_table',2),
(40,'2024_07_02_133009_create_news_msts_table',3),
(41,'2024_07_02_134555_create_photo_libraries_table',3),
(43,'2024_07_02_174147_create_breaking_news_table',4),
(44,'2024_07_03_121210_create_news_positions_table',5),
(45,'2024_07_03_141901_create_post_seo_onpages_table',6),
(46,'2024_07_03_145656_create_post_tags_table',6),
(47,'2024_07_03_150558_create_schema_posts_table',7),
(48,'2024_07_04_053959_create_top_breakings_table',8),
(50,'2024_07_07_125014_create_menus_table',9),
(51,'2024_07_07_181536_create_menu_contents_table',10),
(52,'2024_07_07_185148_create_links_table',11),
(53,'2024_07_08_101512_create_max_archive_settings_table',12),
(54,'2024_07_08_101738_create_news_archives_table',12),
(55,'2024_07_09_121219_create_news_routings_table',12),
(56,'2024_07_10_153917_create_photo_posts_table',13),
(57,'2024_07_10_162533_create_photo_post_details_table',14),
(58,'2024_07_10_095451_add_logo_to_applications_table',15),
(60,'2024_07_13_084058_create_comments_infos_table',16),
(61,'2024_07_13_092407_create_subscriptions_table',16),
(62,'2024_07_13_161905_create_space_credentials_table',16),
(63,'2024_07_15_125006_add_disk_to_photo_libraries_table',17),
(64,'2024_07_25_123841_add_image_title_to_news_msts_table',18),
(65,'2024_07_25_135417_create_divisions_table',19),
(66,'2024_07_25_140746_create_districts_table',20),
(68,'2024_07_25_145009_create_upazilas_table',21),
(71,'2024_08_04_103232_create_home_page_positions_table',22);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES
(1,'App\\Models\\User',1),
(2,'App\\Models\\User',2);

--
-- Table structure for table `news_archives`
--

CREATE TABLE `news_archives` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `news_id` int(11) NOT NULL,
  `encode_title` varchar(200) NOT NULL,
  `seo_title` text DEFAULT NULL,
  `stitle` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `news` longtext NOT NULL,
  `image` varchar(250) DEFAULT NULL,
  `image_base_url` varchar(250) DEFAULT NULL,
  `videos` varchar(250) DEFAULT NULL,
  `podcust_id` int(11) DEFAULT NULL,
  `image_alt` varchar(200) DEFAULT NULL,
  `image_title` varchar(200) DEFAULT NULL,
  `reporter` varchar(56) DEFAULT NULL,
  `page` varchar(255) DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `ref_date` varchar(56) DEFAULT NULL,
  `post_by` varchar(56) DEFAULT NULL,
  `update_by` varchar(56) DEFAULT NULL,
  `time_stamp` int(11) DEFAULT NULL,
  `post_date` date DEFAULT NULL,
  `publish_date` date DEFAULT NULL,
  `last_update` datetime NOT NULL,
  `is_latest` int(11) DEFAULT NULL,
  `reader_hit` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_archives`
--


--
-- Table structure for table `news_msts`
--

CREATE TABLE `news_msts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `news_id` bigint(20) NOT NULL,
  `encode_title` varchar(200) NOT NULL,
  `seo_title` text DEFAULT NULL,
  `stitle` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `news` longtext NOT NULL,
  `image` varchar(250) DEFAULT NULL,
  `image_base_url` varchar(250) DEFAULT NULL,
  `videos` varchar(250) DEFAULT NULL,
  `podcust_id` bigint(20) DEFAULT NULL,
  `image_alt` varchar(250) DEFAULT NULL,
  `image_title` varchar(250) DEFAULT NULL,
  `reporter` varchar(250) DEFAULT NULL,
  `page` varchar(250) DEFAULT NULL,
  `reference` varchar(250) DEFAULT NULL,
  `ref_date` date DEFAULT NULL,
  `post_by` varchar(250) DEFAULT NULL,
  `reporter_id` bigint(20) DEFAULT NULL,
  `update_by` varchar(250) DEFAULT NULL,
  `time_stamp` int(11) DEFAULT NULL,
  `post_date` date DEFAULT NULL,
  `publish_date` date DEFAULT NULL,
  `last_update` datetime NOT NULL,
  `is_latest` bigint(20) DEFAULT NULL,
  `reader_hit` bigint(20) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_msts`
--

INSERT INTO `news_msts` VALUES
(3,'e67d7645-fdfc-4c3b-9f37-0c2817e64ce1',1,'La-Sole-paso-por-la-Fiesta-Nacional-del-Valle-del-Sol-y-hoy-llegan-Los-Caligaris',NULL,'La Sole paso por la Fiesta Nacional del Valle del Sol y hoy llegan Los Caligaris','La Sole paso por la Fiesta Nacional del Valle del Sol y hoy llegan Los Caligaris','<header>\r\n<p>Hizo vibrar al p&uacute;blico en una noche llena de emoci&oacute;n y folklore. Homenaje a Antonio Esteban Ag&uuml;ero en el 108&deg; aniversario de su natalicio. Alrededor de nueve mil personas asistieron el segundo d&iacute;a. Hoy act&uacute;a la banda cordobesa.</p>\r\n\r\n<p><img alt=\"Soledad fue la protagonista de la segunda noche. Foto prensa municipal\" decoding=\"async\" sizes=\"(max-width: 1920px) 930px, 100vw\" src=\"https://elchorrillero.com/nota/wp-content/uploads/2025/02/DESTACADA-SOLE-930x523.jpeg\" srcset=\"https://elchorrillero.com/nota/wp-content/uploads/2025/02/DESTACADA-SOLE-930x523.jpeg 930w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/DESTACADA-SOLE-810x456.jpeg 810w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/DESTACADA-SOLE-360x203.jpeg 360w\" /></p>\r\n\r\n<p>Soledad fue la protagonista de la segunda noche. Foto prensa municipal</p>\r\n</header>\r\n\r\n<p>Actualizada: 08/02/2025 12:40<br />\r\n<time datetime=\"2025-02-08T12:40:09+00:00\">s&aacute;bado, 8 febrero de 2025 &bull; 12:40</time></p>\r\n\r\n<p>En una noche estrellada, la 52&deg; Fiesta Nacional Valle del Sol celebr&oacute; su segunda jornada, con la presencia de destacadas autoridades provinciales y municipales, convocando un aproximado de nueve mil personas que se acercaron al Balneario Municipal para disfrutar de las propuestas art&iacute;sticas y gastron&oacute;micas de este emblem&aacute;tico festival.</p>\r\n\r\n<p>El evento conducido por las voces de Viviana Carranza y Juan Carlos Christiansen, comenz&oacute; con la apertura a cargo de Compa&ntilde;&iacute;a Flora, que present&oacute; la obra &quot;Hijos de la Tierra&quot;, donde la danza y la m&uacute;sica conectaron al p&uacute;blico con los ritmos esenciales del planeta: el calor del sol, la fertilidad de la tierra y la fluidez del agua.</p>\r\n\r\n<p>Luego, fue el turno de Nakasato, ganador del Pre Festival en la categor&iacute;a tema in&eacute;dito, quien sorprendi&oacute; con una obra innovadora que destac&oacute; su creatividad como autor.</p>\r\n\r\n<p><img alt=\"\" decoding=\"async\" sizes=\"(min-width: 600px) 600px, 100vw\" src=\"http://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-2-600x670.jpeg\" srcset=\"https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-2-600x670.jpeg 600w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-2-930x1039.jpeg 930w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-2-768x858.jpeg 768w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-2-360x402.jpeg 360w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-2-810x905.jpeg 810w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-2-1140x1273.jpeg 1140w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-2.jpeg 1146w\" /></p>\r\n\r\n<p id=\"caption-attachment-522209\">Soledad fue la protagonista de la segunda noche. Foto prensa municipal.</p>\r\n\r\n<p>El escenario tambi&eacute;n recibi&oacute; al Ballet Caminantes del Folklore, quienes obtuvieron una menci&oacute;n especial en el Pre Festival en el rubro danza grupal. Con pasi&oacute;n y entrega, este grupo de j&oacute;venes demuestra su amor por la danza y el folklore en cada presentaci&oacute;n.</p>\r\n\r\n<p>Por su parte, Naure D&uacute;o cautiv&oacute; al p&uacute;blico con su interpretaci&oacute;n de canciones del cancionero argentino, aportando una nueva esencia y revitalizando nuestras ra&iacute;ces musicales.</p>\r\n\r\n<p>En un momento de profunda emoci&oacute;n, se rindi&oacute; homenaje al gran poeta merlino Antonio Esteban Ag&uuml;ero en el 108&deg; aniversario de su natalicio. Nacido en iedra Blanca en 1917, su legado sigue vivo en cada rinc&oacute;n de Merlo y en el coraz&oacute;n de los puntanos. En su honor, el escenario mayor lleva su nombre, record&aacute;ndonos que su poes&iacute;a sigue latiendo en nuestra tierra.</p>\r\n\r\n<p>Carolina Centuri&oacute;n con su voz cautivante y su estilo aut&eacute;ntico, fusionando tradici&oacute;n y modernidad en un show vibrante hizo bailar al p&uacute;blico.</p>\r\n\r\n<p>Luego, el Ballet Grito de Mi Tierra present&oacute; &ldquo;Sencillito y de alpargatas&rdquo;, una puesta en escena emocionante que, a trav&eacute;s de la danza, rescat&oacute; las costumbres y tradiciones del folklore argentino, bas&aacute;ndose en la historia de &ldquo;Los Cumbranos&rdquo; y los relatos de puesteros de la Sierra de los Comechingones.</p>\r\n\r\n<p>Sonia Amaya, con 40 a&ntilde;os de trayectoria con un repertorio cargado de identidad y poes&iacute;a. Acompa&ntilde;ada por m&uacute;sicos y bailarines, ofreci&oacute; una presentaci&oacute;n llena de sentimiento y tradici&oacute;n.</p>\r\n\r\n<p>El D&uacute;o Orellana-Lucca lleg&oacute; al escenario con su inconfundible sonido santiague&ntilde;o, haciendo vibrar al p&uacute;blico al ritmo de chacareras y emoci&oacute;n. Con m&aacute;s de dos d&eacute;cadas de trayectoria, el d&uacute;o conquist&oacute; la noche con su m&uacute;sica y su energ&iacute;a arrolladora. Durante el show el Ministro de Turismo y Cultura De San Luis, Juan &Aacute;lvarez Pinto; Intendente Interino De La Villa De Merlo, Leonardo Rodriguez; el Secretario Hacienda, Dr. Bruno Mini; el Secretario De Gobierno Y Deportes; Francisco Sebast&iacute;an Oviedo y la Secretaria De Cultura Valentina Ortega les entregaron un certificado de reconocimiento y presentes por su aporte a la m&uacute;sica popular argentina.</p>\r\n\r\n<p>El Ballet Llastay, con m&aacute;s de 50 a&ntilde;os de trayectoria, present&oacute; su obra titulada &ldquo;Litoral&rdquo;, un homenaje a las tradiciones del noreste argentino. Dirigido por sus alumnos, el grupo llev&oacute; al escenario un cuadro folkl&oacute;rico con rasguido doble, chamarrita, ranchera y chamam&eacute;, como antesala de Soledad Pastorutti.</p>\r\n\r\n<p>El momento m&aacute;s esperado de la noche lleg&oacute; con la voz que renueva la tradici&oacute;n y es &iacute;cono del folklore argentino. Soledad Pastorutti, la santafesina que ha conquistado el pa&iacute;s, regres&oacute; a Merlo para brillar en el escenario mayor Antonio Esteban Ag&uuml;ero.</p>\r\n\r\n<p>Las luces se encendieron, los bailarines se prepararon y el p&uacute;blico se puso de pie para celebrar, u una vez m&aacute;s, la tradici&oacute;n que nos une como argentinos.</p>\r\n\r\n<p>Se hizo entrega de un certificado de reconocimiento y presentes a Soledad Pastorutti, por su a trayectoria y aporte a la cultura. Estuvieron el ministro de Turismo y Cultura, Juan &Aacute;lvarez Pinto; el intendente interino de la Villa de Merlo, Leonardo Rodr&iacute;guez; secretario de Gobierno y Deportes, Francisco Oviedo; y el productor general del evento, Gonzalo Mastronardi quienes acompa&ntilde;aron y celebraron el homenaje a esta figura fundamental del folklore argentino.</p>\r\n\r\n<p><img alt=\"\" decoding=\"async\" sizes=\"(min-width: 600px) 600px, 100vw\" src=\"http://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-1-600x400.jpeg\" srcset=\"https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-1-600x400.jpeg 600w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-1-930x621.jpeg 930w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-1-768x512.jpeg 768w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-1-625x417.jpeg 625w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-1-360x240.jpeg 360w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-1-810x541.jpeg 810w, https://elchorrillero.com/nota/wp-content/uploads/2025/02/WhatsApp-Image-2025-02-08-at-9.58.49-AM-1.jpeg 1040w\" /></p>\r\n\r\n<p id=\"caption-attachment-522210\">Soledad fue la protagonista de la segunda noche.</p>\r\n\r\n<p><strong>La grilla de hoy</strong></p>\r\n\r\n<p>&ndash; Apertura &ldquo;Hijos de la Tierra&rdquo; Compa&ntilde;&iacute;a Flora</p>\r\n\r\n<p>&ndash; Los Caligaris</p>\r\n\r\n<p>&ndash; Las Voces de Merlo</p>\r\n\r\n<p>&ndash; Daniel Gonzalez</p>\r\n\r\n<p>&ndash; El Ventarr&oacute;n Malambo</p>\r\n\r\n<p>&ndash; Alberto Altamirano</p>\r\n\r\n<p>&ndash; D&uacute;o Coplanacu</p>\r\n\r\n<p>&ndash; La Callejera</p>\r\n\r\n<p>&ndash; Astiyas del Mismo Palo</p>\r\n\r\n<p>&ndash; Ricardo Aguilera y Am&eacute;rico Moroso Orquesta</p>\r\n\r\n<p>&ndash; Estaci&oacute;n 67 (Ganadores Pre Festival: Canto Grupal)</p>\r\n\r\n<p>&ndash; Zaira Gallo y Ariel Hernandez D&uacute;o</p>\r\n\r\n<p>&ndash; Argentina es una Danza</p>\r\n\r\n<p>&ndash; Paisano Brand&aacute;n</p>','tArhs9X8UPxeffwVnFOQdICYVultKKipI9N2aolo.webp',NULL,NULL,NULL,'El intendente Hissa recorrió la obra de repavimentación en el centro de la ciudad. Foto: Municipalidad de San Luis.','El intendente Hissa recorrió la obra de repavimentación en el centro de la ciudad. Foto: Municipalidad de San Luis.',NULL,'San-Luis',NULL,'2025-02-09','1',1,NULL,1739050737,'2025-02-09','2025-02-08','2025-02-09 03:38:57',1,48,0,'2025-02-09 03:37:39','2025-02-09 03:38:57');

--
-- Table structure for table `news_positions`
--

CREATE TABLE `news_positions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `news_id` bigint(20) NOT NULL,
  `page` varchar(100) NOT NULL,
  `position` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_positions`
--

INSERT INTO `news_positions` VALUES
(9,1,'home',1,0,'2025-02-09 03:38:57','2025-02-09 03:38:57'),
(10,1,'San-Luis',1,1,'2025-02-09 03:38:57','2025-02-09 03:38:57');

--
-- Table structure for table `news_routings`
--

CREATE TABLE `news_routings` (
  `news_id` varchar(50) NOT NULL,
  `uuid` varchar(191) NOT NULL,
  `table_name` text DEFAULT NULL,
  `routing_id` varchar(50) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_routings`
--


--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `page_id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `page_slug` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `image_id` varchar(100) DEFAULT NULL,
  `galary_id` int(11) DEFAULT NULL,
  `video_url` varchar(100) DEFAULT NULL,
  `publishar_id` int(11) DEFAULT NULL,
  `seo_keyword` text DEFAULT NULL,
  `seo_description` text DEFAULT NULL,
  `publish_date` datetime DEFAULT NULL,
  `reader_view` int(11) DEFAULT NULL,
  `releted_id` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES
(1,'924b52d7-6411-46b7-860a-e4a9e822c012',1,'wefwefwefew',NULL,'<p>fwefewfwef</p>','',NULL,NULL,1,'','','2025-02-08 10:02:29',NULL,NULL,1,1,1,'2025-02-08 22:12:29','2025-02-09 04:32:51','2025-02-09 04:32:51');

--
-- Table structure for table `per_menus`
--

CREATE TABLE `per_menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `parentmenu_id` bigint(20) DEFAULT NULL,
  `lable` bigint(20) NOT NULL,
  `menu_name` varchar(191) NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `per_menus`
--


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

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `per_menu_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` VALUES
(1,'read_dashboard','web',1,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(2,'create_advertise','web',2,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(3,'read_advertise','web',2,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(4,'update_advertise','web',2,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(5,'delete_advertise','web',2,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(6,'create_update_advertise','web',3,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(7,'read_update_advertise','web',3,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(8,'update_update_advertise','web',3,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(9,'delete_update_advertise','web',3,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(10,'create_analytics','web',4,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(11,'read_analytics','web',4,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(12,'update_analytics','web',4,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(13,'delete_analytics','web',4,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(14,'create_live_now','web',5,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(15,'read_live_now','web',5,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(16,'update_live_now','web',5,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(17,'delete_live_now','web',5,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(18,'create_location_Based','web',6,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(19,'read_location_Based','web',6,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(20,'update_location_Based','web',6,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(21,'delete_location_Based','web',6,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(22,'create_news_based','web',7,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(23,'read_news_based','web',7,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(24,'update_news_based','web',7,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(25,'delete_news_based','web',7,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(26,'create_clear_analytics','web',8,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(27,'read_clear_analytics','web',8,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(28,'update_clear_analytics','web',8,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(29,'delete_clear_analytics','web',8,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(30,'create_archive_setting','web',9,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(31,'read_archive_setting','web',9,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(32,'update_archive_setting','web',9,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(33,'delete_archive_setting','web',9,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(34,'create_category','web',10,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(35,'read_category','web',10,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(36,'update_category','web',10,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(37,'delete_category','web',10,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(38,'create_comment','web',11,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(39,'read_comment','web',11,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(40,'update_comment','web',11,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(41,'delete_comment','web',11,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(42,'create_media_library','web',12,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(43,'read_media_library','web',12,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(44,'update_media_library','web',12,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(45,'delete_media_library','web',12,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(46,'create_photo_upload','web',13,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(47,'read_photo_upload','web',13,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(48,'update_photo_upload','web',13,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(49,'delete_photo_upload','web',13,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(50,'create_photo_list','web',14,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(51,'read_photo_list','web',14,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(52,'update_photo_list','web',14,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(53,'delete_photo_list','web',14,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(54,'create_menu_setup','web',15,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(55,'read_menu_setup','web',15,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(56,'update_menu_setup','web',15,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(57,'delete_menu_setup','web',15,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(58,'create_news','web',16,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(59,'read_news','web',16,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(60,'update_news','web',16,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(61,'delete_news','web',16,'2024-06-26 10:49:45','2024-06-26 10:49:45'),
(62,'create_post','web',17,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(63,'read_post','web',17,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(64,'update_post','web',17,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(65,'delete_post','web',17,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(66,'create_breaking_news','web',18,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(67,'read_breaking_news','web',18,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(68,'update_breaking_news','web',18,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(69,'delete_breaking_news','web',18,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(70,'create_positioning','web',19,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(71,'read_positioning','web',19,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(72,'update_positioning','web',19,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(73,'delete_positioning','web',19,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(74,'create_photo_post','web',20,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(75,'read_photo_post','web',20,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(76,'update_photo_post','web',20,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(77,'delete_photo_post','web',20,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(78,'create_page','web',21,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(79,'read_page','web',21,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(80,'update_page','web',21,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(81,'delete_page','web',21,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(82,'create_page_list','web',22,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(83,'read_page_list','web',22,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(84,'update_page_list','web',22,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(85,'delete_page_list','web',22,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(86,'create_reporter','web',23,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(87,'read_reporter','web',23,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(88,'update_reporter','web',23,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(89,'delete_reporter','web',23,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(90,'create_subscribers','web',24,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(91,'read_subscribers','web',24,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(92,'update_subscribers','web',24,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(93,'delete_subscribers','web',24,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(94,'create_last_20_access','web',25,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(95,'read_last_20_access','web',25,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(96,'update_last_20_access','web',25,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(97,'delete_last_20_access','web',25,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(98,'create_seo','web',26,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(99,'read_seo','web',26,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(100,'update_seo','web',26,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(101,'delete_seo','web',26,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(102,'create_meta_setting','web',27,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(103,'read_meta_setting','web',27,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(104,'update_meta_setting','web',27,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(105,'delete_meta_setting','web',27,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(106,'create_social_site','web',28,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(107,'read_social_site','web',28,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(108,'update_social_site','web',28,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(109,'delete_social_site','web',28,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(110,'create_social_link','web',29,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(111,'read_social_link','web',29,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(112,'update_social_link','web',29,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(113,'delete_social_link','web',29,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(114,'create_rss_sitemap_link','web',30,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(115,'read_rss_sitemap_link','web',30,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(116,'update_rss_sitemap_link','web',30,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(117,'delete_rss_sitemap_link','web',30,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(118,'create_setting','web',31,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(119,'read_setting','web',31,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(120,'update_setting','web',31,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(121,'delete_setting','web',31,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(122,'create_home_page','web',32,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(123,'read_home_page','web',32,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(124,'update_home_page','web',32,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(125,'delete_home_page','web',32,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(126,'create_contact_page_setup','web',33,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(127,'read_contact_page_setup','web',33,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(128,'update_contact_page_setup','web',33,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(129,'delete_contact_page_setup','web',33,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(130,'create_404_page_setting','web',34,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(131,'read_404_page_setting','web',34,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(132,'update_404_page_setting','web',34,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(133,'delete_404_page_setting','web',34,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(134,'create_color_setting','web',35,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(135,'read_color_setting','web',35,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(136,'update_color_setting','web',35,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(137,'delete_color_setting','web',35,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(138,'create_social_auth_setting','web',36,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(139,'read_social_auth_setting','web',36,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(140,'update_social_auth_setting','web',36,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(141,'delete_social_auth_setting','web',36,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(142,'create_cache_system','web',37,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(143,'read_cache_system','web',37,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(144,'update_cache_system','web',37,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(145,'delete_cache_system','web',37,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(146,'create_date_field_setup','web',38,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(147,'read_date_field_setup','web',38,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(148,'update_date_field_setup','web',38,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(149,'delete_date_field_setup','web',38,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(150,'create_panel_face','web',39,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(151,'read_panel_face','web',39,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(152,'update_panel_face','web',39,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(153,'delete_panel_face','web',39,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(154,'create_theme_setup','web',40,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(155,'read_theme_setup','web',40,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(156,'update_theme_setup','web',40,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(157,'delete_theme_setup','web',40,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(158,'create_software_setup','web',41,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(159,'read_software_setup','web',41,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(160,'update_software_setup','web',41,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(161,'delete_software_setup','web',41,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(162,'create_application','web',42,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(163,'read_application','web',42,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(164,'update_application','web',42,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(165,'delete_application','web',42,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(166,'create_apps_setting','web',43,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(167,'read_apps_setting','web',43,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(168,'update_apps_setting','web',43,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(169,'delete_apps_setting','web',43,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(170,'create_currency','web',44,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(171,'read_currency','web',44,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(172,'update_currency','web',44,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(173,'delete_currency','web',44,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(174,'create_mail_setup','web',45,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(175,'read_mail_setup','web',45,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(176,'update_mail_setup','web',45,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(177,'delete_mail_setup','web',45,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(178,'create_sms_setup','web',46,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(179,'read_sms_setup','web',46,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(180,'update_sms_setup','web',46,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(181,'delete_sms_setup','web',46,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(182,'create_password_setting','web',47,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(183,'read_password_setting','web',47,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(184,'update_password_setting','web',47,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(185,'delete_password_setting','web',47,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(186,'create_language','web',48,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(187,'read_language','web',48,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(188,'update_language','web',48,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(189,'delete_language','web',48,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(190,'create_add_language','web',49,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(191,'read_add_language','web',49,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(192,'update_add_language','web',49,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(193,'delete_add_language','web',49,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(194,'create_language_strings','web',50,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(195,'read_language_strings','web',50,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(196,'update_language_strings','web',50,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(197,'delete_language_strings','web',50,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(198,'create_user_management','web',51,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(199,'read_user_management','web',51,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(200,'update_user_management','web',51,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(201,'delete_user_management','web',51,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(202,'create_role_list','web',52,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(203,'read_role_list','web',52,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(204,'update_role_list','web',52,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(205,'delete_role_list','web',52,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(206,'create_user_list','web',53,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(207,'read_user_list','web',53,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(208,'update_user_list','web',53,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(209,'delete_user_list','web',53,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(210,'create_factory_reset','web',54,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(211,'read_factory_reset','web',54,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(212,'update_factory_reset','web',54,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(213,'delete_factory_reset','web',54,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(214,'create_backup_and_reset','web',55,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(215,'read_backup_and_reset','web',55,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(216,'update_backup_and_reset','web',55,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(217,'delete_backup_and_reset','web',55,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(218,'create_access_log','web',56,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(219,'read_access_log','web',56,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(220,'update_access_log','web',56,'2024-06-26 10:49:46','2024-06-26 10:49:46'),
(221,'delete_access_log','web',56,'2024-06-26 10:49:46','2024-06-26 10:49:46');

--
-- Table structure for table `photo_libraries`
--

CREATE TABLE `photo_libraries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `disk` varchar(199) DEFAULT NULL,
  `image_base_url` varchar(191) DEFAULT NULL,
  `actual_image_name` varchar(191) NOT NULL,
  `picture_name` varchar(191) DEFAULT NULL,
  `thumb_image` varchar(191) DEFAULT NULL,
  `large_image` varchar(191) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `category` bigint(20) DEFAULT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `time_stamp` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `photo_libraries`
--

INSERT INTO `photo_libraries` VALUES
(2,'47b733f1-0351-409e-9d99-e700f92fe202','local','http://infosanluis.com.ar/admin/storage/images/thumb/tArhs9X8UPxeffwVnFOQdICYVultKKipI9N2aolo.webp','tArhs9X8UPxeffwVnFOQdICYVultKKipI9N2aolo.webp','tArhs9X8UPxeffwVnFOQdICYVultKKipI9N2aolo.webp','images/thumb/tArhs9X8UPxeffwVnFOQdICYVultKKipI9N2aolo.webp','images/large/tArhs9X8UPxeffwVnFOQdICYVultKKipI9N2aolo.webp','El intendente Hissa recorrió la obra de repavimentación en el centro de la ciudad. Foto: Municipalidad de San Luis.',NULL,NULL,1739052207,1,'2025-02-08 22:03:27','2025-02-08 22:03:27'),
(3,'b412ef1b-ee9e-4d14-8f4b-c8040dc2f6df','local','http://143.198.224.178/admin/storage/images/thumb/VvcAHrB9McqFNjFNbFzk9feRM5gGnnMOyoChyI44.jpg','VvcAHrB9McqFNjFNbFzk9feRM5gGnnMOyoChyI44.jpg','VvcAHrB9McqFNjFNbFzk9feRM5gGnnMOyoChyI44.jpg','images/thumb/VvcAHrB9McqFNjFNbFzk9feRM5gGnnMOyoChyI44.jpg','images/large/VvcAHrB9McqFNjFNbFzk9feRM5gGnnMOyoChyI44.jpg',NULL,NULL,NULL,1739073788,1,'2025-02-09 04:03:08','2025-02-09 04:03:08');

--
-- Table structure for table `photo_post_details`
--

CREATE TABLE `photo_post_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image_base_url` varchar(255) DEFAULT NULL,
  `photo_reference` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `photo_post_details`
--


--
-- Table structure for table `photo_posts`
--

CREATE TABLE `photo_posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `stitle` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `reporter` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `post_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  `meta_keyword` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `photo_posts`
--


--
-- Table structure for table `pictures`
--

CREATE TABLE `pictures` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `imageable_type` varchar(191) NOT NULL,
  `imageable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `file_name` varchar(191) DEFAULT NULL,
  `mime_type` varchar(191) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `febicon` text DEFAULT NULL,
  `thumbnail` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=Inactive , 1=Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pictures_imageable_type_imageable_id_index` (`imageable_type`,`imageable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pictures`
--


--
-- Table structure for table `post_seo_onpages`
--

CREATE TABLE `post_seo_onpages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `news_id` bigint(20) NOT NULL,
  `meta_keyword` varchar(191) NOT NULL,
  `meta_description` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_seo_onpages`
--


--
-- Table structure for table `post_tags`
--

CREATE TABLE `post_tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `news_id` bigint(20) NOT NULL,
  `tag` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_tags`
--


--
-- Table structure for table `prefixes`
--

CREATE TABLE `prefixes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_requisition_no` varchar(191) DEFAULT NULL,
  `purchase_no` varchar(191) DEFAULT NULL,
  `purchase_received_no` varchar(191) DEFAULT NULL,
  `purchase_return_no` varchar(191) DEFAULT NULL,
  `sale_quotation_no` varchar(191) DEFAULT NULL,
  `sale_invoice_no` varchar(191) DEFAULT NULL,
  `sale_draft_no` varchar(191) DEFAULT NULL,
  `sale_return_no` varchar(191) DEFAULT NULL,
  `stock_adjustment_no` varchar(191) DEFAULT NULL,
  `wastage_no` varchar(191) DEFAULT NULL,
  `delivery_no` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `service_invoice_no` varchar(191) DEFAULT NULL,
  `transfer_no` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prefixes`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES
(1,1),
(2,1),
(3,1),
(4,1),
(5,1),
(6,1),
(7,1),
(8,1),
(9,1),
(10,1),
(11,1),
(12,1),
(13,1),
(14,1),
(15,1),
(16,1),
(17,1),
(18,1),
(19,1),
(20,1),
(21,1),
(22,1),
(23,1),
(24,1),
(25,1),
(26,1),
(27,1),
(28,1),
(29,1),
(30,1),
(31,1),
(32,1),
(33,1),
(34,1),
(35,1),
(36,1),
(37,1),
(38,1),
(39,1),
(40,1),
(41,1),
(42,1),
(43,1),
(44,1),
(45,1),
(46,1),
(47,1),
(48,1),
(49,1),
(50,1),
(51,1),
(52,1),
(53,1),
(54,1),
(55,1),
(56,1),
(57,1),
(58,1),
(59,1),
(60,1),
(61,1),
(62,1),
(63,1),
(64,1),
(65,1),
(66,1),
(67,1),
(68,1),
(69,1),
(70,1),
(71,1),
(72,1),
(73,1),
(74,1),
(75,1),
(76,1),
(77,1),
(78,1),
(79,1),
(80,1),
(81,1),
(82,1),
(83,1),
(84,1),
(85,1),
(86,1),
(87,1),
(88,1),
(89,1),
(90,1),
(91,1),
(92,1),
(93,1),
(94,1),
(95,1),
(96,1),
(97,1),
(98,1),
(99,1),
(100,1),
(101,1),
(102,1),
(103,1),
(104,1),
(105,1),
(106,1),
(107,1),
(108,1),
(109,1),
(110,1),
(111,1),
(112,1),
(113,1),
(114,1),
(115,1),
(116,1),
(117,1),
(118,1),
(119,1),
(120,1),
(121,1),
(122,1),
(123,1),
(124,1),
(125,1),
(126,1),
(127,1),
(128,1),
(129,1),
(130,1),
(131,1),
(132,1),
(133,1),
(134,1),
(135,1),
(136,1),
(137,1),
(138,1),
(139,1),
(140,1),
(141,1),
(142,1),
(143,1),
(144,1),
(145,1),
(146,1),
(147,1),
(148,1),
(149,1),
(150,1),
(151,1),
(152,1),
(153,1),
(154,1),
(155,1),
(156,1),
(157,1),
(158,1),
(159,1),
(160,1),
(161,1),
(162,1),
(163,1),
(164,1),
(165,1),
(166,1),
(167,1),
(168,1),
(169,1),
(170,1),
(171,1),
(172,1),
(173,1),
(174,1),
(175,1),
(176,1),
(177,1),
(178,1),
(179,1),
(180,1),
(181,1),
(182,1),
(183,1),
(184,1),
(185,1),
(186,1),
(187,1),
(188,1),
(189,1),
(190,1),
(191,1),
(192,1),
(193,1),
(194,1),
(195,1),
(196,1),
(197,1),
(198,1),
(199,1),
(200,1),
(201,1),
(202,1),
(203,1),
(204,1),
(205,1),
(206,1),
(207,1),
(208,1),
(209,1),
(210,1),
(211,1),
(212,1),
(213,1),
(214,1),
(215,1),
(216,1),
(217,1),
(218,1),
(219,1),
(220,1),
(221,1),
(1,2),
(58,2),
(59,2),
(60,2),
(61,2),
(62,2),
(63,2),
(64,2),
(65,2),
(66,2),
(67,2),
(68,2),
(69,2),
(70,2),
(71,2),
(72,2),
(73,2),
(74,2),
(75,2),
(76,2),
(77,2);

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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES
(1,'Super Admin','web','2024-06-26 10:49:45','2024-06-26 10:49:45'),
(2,'Reporter','web','2024-06-26 10:49:45','2024-06-26 10:49:45');

--
-- Table structure for table `schema_posts`
--

CREATE TABLE `schema_posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `news_id` bigint(20) DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `url` varchar(191) DEFAULT NULL,
  `headline` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image_url` varchar(191) DEFAULT NULL,
  `author_type` varchar(191) DEFAULT NULL,
  `author_name` varchar(191) DEFAULT NULL,
  `publisher` varchar(191) DEFAULT NULL,
  `publisher_logo` varchar(191) DEFAULT NULL,
  `publishdate` date DEFAULT NULL,
  `modifidate` date DEFAULT NULL,
  `active_status` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schema_posts`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL,
  `event` text NOT NULL,
  `details` longtext NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES
(1,'main_menu','{\"1\":{\"cat_name\":\"TECHNOLOGY\",\"slug\":\"Technology\",\"max_news\":null,\"category_id\":\"4\",\"status\":\"1\"},\"2\":{\"cat_name\":\"POLITICS\",\"slug\":\"Politics\",\"max_news\":null,\"category_id\":\"8\",\"status\":\"1\"},\"3\":{\"cat_name\":\"VIDEO\",\"slug\":\"Video\",\"max_news\":null,\"category_id\":\"7\",\"status\":\"1\"},\"4\":{\"cat_name\":\"TRAVEL\",\"slug\":\"Travel\",\"max_news\":null,\"category_id\":\"2\",\"status\":\"1\"},\"5\":{\"cat_name\":\"HEALTH\",\"slug\":\"Health\",\"max_news\":null,\"category_id\":\"14\",\"status\":\"1\"},\"6\":{\"cat_name\":\"LIFESTYLE\",\"slug\":\"Lifestyle\",\"max_news\":null,\"category_id\":\"5\",\"status\":\"1\"},\"7\":{\"cat_name\":\"TRAVEL\",\"slug\":\"Travel\",\"max_news\":null,\"category_id\":\"2\",\"status\":\"1\"},\"8\":{\"cat_name\":\"SPORTS\",\"slug\":\"Sports\",\"max_news\":null,\"category_id\":\"13\",\"status\":\"1\"},\"9\":{\"cat_name\":\"WORLD\",\"slug\":\"world\",\"max_news\":null,\"category_id\":\"10\",\"status\":\"1\"},\"10\":{\"cat_name\":\"POLITICS\",\"slug\":\"Politics\",\"max_news\":null,\"category_id\":\"8\",\"status\":\"0\"},\"11\":{\"cat_name\":\"EDITOR CHOICE\",\"slug\":\"Editor-Choice\",\"max_news\":null,\"category_id\":\"6\",\"status\":\"0\"},\"12\":{\"cat_name\":\"SCIENCE\",\"slug\":\"science\",\"max_news\":null,\"category_id\":\"11\",\"status\":\"0\"},\"14\":{\"cat_name\":\"BUSINESS\",\"slug\":\"Business\",\"max_news\":null,\"category_id\":\"12\",\"status\":\"0\"},\"15\":{\"cat_name\":\"FOOD\",\"slug\":\"Food\",\"max_news\":null,\"category_id\":\"3\",\"status\":\"0\"},\"13\":{\"cat_name\":\"POLITICS\",\"slug\":\"Politics\",\"max_news\":null,\"category_id\":\"8\",\"status\":\"0\"}}',NULL,NULL,NULL,NULL,NULL),
(3,'lang_settings','{\"latest_news\":\"LATEST NEWS\",\"most_read\":\"MOST POPULAR\",\"whole_country\":\"Whole Country\",\"headline\":\"Headline\",\"home\":\"HOME\",\"such_more_news\":\"Related News\",\"details\":\"Read More\"}',NULL,NULL,NULL,NULL,NULL),
(4,'home_page_cat_style','{\"1\":{\"cat_name\":\"Opinion\",\"slug\":\"opinion\",\"max_news\":null,\"category_id\":\"3\",\"status\":\"1\"}}',NULL,1,NULL,'2024-08-01 07:10:45',NULL),
(5,'meta','{\"title\":\"News365\",\"meta_tag\":\"news365\",\"meta_description\":\"news365\",\"google_analytics\":\"news365\",\"default_image\":\"uploads/images/2023-11-19/p.jpg\"}',NULL,NULL,NULL,NULL,NULL),
(6,'social_page','{\"fb\":\"https://www.facebook.com/envato/\",\"tw\":\"https://twitter.com/\",\"status\":\"1\",\"mobile_status\":null}',NULL,NULL,NULL,NULL,NULL),
(8,'user_analytics','{\"user_analytics\":\"inactive\"}',NULL,NULL,NULL,NULL,NULL),
(16,'default_theme','{\"default_theme\":\"Osru-Theme\"}',NULL,NULL,NULL,NULL,NULL),
(18,'prayer_time','{\"prayer_time\":\"\"}',NULL,NULL,NULL,NULL,NULL),
(111,'social_link','{\"fb\":\"https://www.facebook.com\",\"tw\":\"https://www.twitter.com\",\"linkd\":\"https://plus.google.com\",\"pin\":\"https://au.pinterest.com\",\"vimo\":\"https://vimeo.com\",\"youtube\":\"https://www.youtube.com\",\"flickr\":\"https://www.flickr.com\",\"vk\":\"https://www.vk.com\",\"whats_app\":\"https://www.whatsapp.com\",\"google\":null}',NULL,NULL,NULL,NULL,NULL),
(113,'contact_page_setup','{\"editor\":\"Contacto\",\"content\":\"To learn more about News365, Please feel free to contact with us\",\"address\":\"San Luis, Argentina\",\"phone\":null,\"phone_two\":null,\"email\":\"business@bdtask.com\",\"website\":\"www.infosanluis.com,ar\",\"latitude\":\"23.824411570033433\",\"longitude\":\"90.41929284887331\",\"map\":\"https:\\/\\/www.google.com\\/maps\\/embed?pb=!1m14!1m8!1m3!1d12275.142575508362!2d90.4103705716535!3d23.839154058973467!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3755b8a4136c4b61:0x19549f5462616f04!2sBdtask%20Limited!5e0!3m2!1sen!2sbd!4v1699174239627!5m2!1sen!2sbd\"}',NULL,1,NULL,'2025-02-09 04:14:50',NULL),
(114,'404_page_setup','{\"heading\":\"No Data Found\",\"details\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam et fermentum dui.\",\"img404\":\"uploads/images/4.jpg\"}',NULL,NULL,NULL,NULL,NULL),
(115,'others_settings','{\"reg_status\":1,\"reg_mail_status\":0,\"contact_status\":1,\"contact_mail_status\":1,\"comments_status\":1}',NULL,NULL,NULL,NULL,NULL),
(116,'dateconvert','{\"zero\":\"\\u0660\",\"one\":\"\\u0661\",\"two\":\"\\u0662\",\"three\":\"\\u0663\",\"four\":\"\\u0664\",\"five\":\"\\u0665\",\"six\":\"\\u0666\",\"seven\":\"\\u0667\",\"eight\":\"\\u0668\",\"nine\":\"\\u0669\"}',NULL,NULL,NULL,NULL,NULL),
(117,'panel_face','{\"fontone\":\"\",\"fonttwo\":\"\",\"color_code\":\"\",\"body_font_size\":\"14\",\"body_line_hight\":\"1.5\",\"content_text_color\":\"#aa0909\",\"logo_text_color\":\"#871717\",\"menubg_color\":\"#7f3434\",\"menu_hover_color\":\"#b41818\",\"menu_font_color\":\"#ffffff\",\"menu_font_size\":\"16\",\"active_menu_color\":\"#000000\",\"active_menu_bgcolor\":\"#7c0909\",\"active_status\":\"0\"}',NULL,NULL,NULL,NULL,NULL),
(118,'post_default_img','{\"img\":\"uploads/images/2021-02-20/d.jpg\"}',NULL,NULL,NULL,NULL,NULL),
(119,'apenai','{\"OPENAI_API_KEY\":\"sk-xxxxxx\",\"OPENAI_ORGANIZATION\":\"org-xxxxx\",\"OPENAI_MAX_NUMBER_OF_RESULT\":\"10\",\"OPENAI_MAX_TOKENS\":\"1000\",\"active_status\":\"1\"}',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `subs_id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `email` varchar(111) DEFAULT NULL,
  `phone` varchar(111) DEFAULT NULL,
  `category` text DEFAULT NULL,
  `frequency` int(11) DEFAULT NULL,
  `number_of_news` varchar(111) DEFAULT NULL,
  `subs_auth_code` int(11) NOT NULL,
  `payment_status` int(11) NOT NULL DEFAULT 1,
  `social_sheare` int(11) NOT NULL DEFAULT 1,
  `subscription_date` date NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `top_breakings`
--

CREATE TABLE `top_breakings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `category_slug` varchar(100) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `background_color` varchar(200) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `top_breakings`
--


--
-- Table structure for table `upazilas`
--

CREATE TABLE `upazilas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `district_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `bn_name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `upazilas_district_id_foreign` (`district_id`),
  CONSTRAINT `upazilas_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `upazilas`
--


--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `user_type_title` varchar(191) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_types`
--


--
-- Table structure for table `zkts`
--

CREATE TABLE `zkts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `device_id` varchar(191) NOT NULL,
  `ip_address` varchar(191) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zkts`
--



