CREATE TABLE `friend_tag_blocked` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  `item_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `friend_tag_blocked_user_id_index` (`user_id`),
  KEY `ix_friend_tag_blocked_user_morph` (`user_id`,`user_type`),
  KEY `friend_tag_blocked_owner_id_index` (`owner_id`),
  KEY `ix_friend_tag_blocked_owner_morph` (`owner_id`,`owner_type`),
  KEY `friend_tag_blocked_item_id_index` (`item_id`),
  KEY `ix_friend_tag_blocked_item_morph` (`item_id`,`item_type`),
  KEY `friend_tag_blocked_user_id_owner_id_index` (`user_id`,`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `friend_tag_friends` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) unsigned NOT NULL,
  `item_type` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `px` double(6,3) NOT NULL DEFAULT 0.000,
  `py` double(6,3) NOT NULL DEFAULT 0.000,
  `is_mention` tinyint(4) NOT NULL DEFAULT 0,
  `content` text DEFAULT NULL,
  `send_notification` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `friend_tag_friends_item_id_index` (`item_id`),
  KEY `ix_friend_tag_friends_item_morph` (`item_id`,`item_type`),
  KEY `friend_tag_friends_user_id_index` (`user_id`),
  KEY `ix_friend_tag_friends_user_morph` (`user_id`,`user_type`),
  KEY `friend_tag_friends_owner_id_index` (`owner_id`),
  KEY `ix_friend_tag_friends_owner_morph` (`owner_id`,`owner_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `friends` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `friends_user_id_index` (`user_id`),
  KEY `ix_friends_user_morph` (`user_id`,`user_type`),
  KEY `friends_owner_id_index` (`owner_id`),
  KEY `ix_friends_owner_morph` (`owner_id`,`owner_type`),
  KEY `friends_user_id_owner_id_index` (`user_id`,`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_activities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  `item_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_activities_user_id_index` (`user_id`),
  KEY `ix_group_activities_user_morph` (`user_id`,`user_type`),
  KEY `group_activities_item_id_index` (`item_id`),
  KEY `ix_group_activities_item_morph` (`item_id`,`item_type`),
  KEY `group_activities_group_id_index` (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `group_activities` VALUES
(1,3,1,'user',3,'group','2024-12-01 00:49:59','2024-12-01 00:49:59'),
(2,3,1,'user',1,'photo_album','2024-12-01 16:58:52','2024-12-01 16:58:52'),
(3,3,1,'user',3,'feed','2024-12-01 16:58:54','2024-12-01 16:58:54'),
(4,3,1,'user',1,'photo','2024-12-01 16:58:54','2024-12-01 16:58:54');
CREATE TABLE `group_announcement_hidden` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `announcement_id` bigint(20) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_announcement_hidden_user_id_announcement_id_unique` (`user_id`,`announcement_id`),
  KEY `group_announcement_hidden_user_id_index` (`user_id`),
  KEY `ix_group_announcement_hidden_user_morph` (`user_id`,`user_type`),
  KEY `group_announcement_hidden_group_id_index` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_announcements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  `item_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_announcements_user_id_index` (`user_id`),
  KEY `ix_group_announcements_user_morph` (`user_id`,`user_type`),
  KEY `group_announcements_item_id_index` (`item_id`),
  KEY `ix_group_announcements_item_morph` (`item_id`,`item_type`),
  KEY `group_announcements_group_id_index` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_answers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `value` mediumtext DEFAULT NULL,
  `request_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_answers_user_id_index` (`user_id`),
  KEY `ix_group_answers_user_morph` (`user_id`,`user_type`),
  KEY `group_answers_question_id_index` (`question_id`),
  KEY `group_answers_request_id_index` (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_blocks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_blocks_user_id_index` (`user_id`),
  KEY `ix_group_blocks_user_morph` (`user_id`,`user_type`),
  KEY `group_blocks_owner_id_index` (`owner_id`),
  KEY `ix_group_blocks_owner_morph` (`owner_id`,`owner_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `name_url` varchar(255) DEFAULT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `ordering` int(10) unsigned NOT NULL DEFAULT 0,
  `total_item` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `level` int(10) unsigned NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_categories_name_url_index` (`name_url`)
) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `group_categories` VALUES
(1,NULL,'group::phrase.category_entertainment',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(2,NULL,'group::phrase.category_brand_or_product',NULL,1,0,1,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(3,NULL,'group::phrase.category_local_business_or_place',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(4,NULL,'group::phrase.category_company_organization_or_institution',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(5,NULL,'group::phrase.category_artist_band_or_public_figure',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(6,NULL,'group::phrase.category_sports',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(7,NULL,'group::phrase.category_food',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(8,NULL,'group::phrase.category_travel',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(9,NULL,'group::phrase.category_photography',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(10,1,'group::phrase.category_album',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(11,1,'group::phrase.category_amateur_sports_team',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(12,1,'group::phrase.category_book',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(13,1,'group::phrase.category_book_store',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(14,1,'group::phrase.category_concert_tour',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(15,1,'group::phrase.category_concert_venue',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(16,1,'group::phrase.category_fictional_character',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(17,1,'group::phrase.category_library',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(18,1,'group::phrase.category_magazine',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(19,1,'group::phrase.category_movie',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(20,1,'group::phrase.category_movie_theater',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(21,1,'group::phrase.category_music_award',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(22,1,'group::phrase.category_music_chart',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(23,1,'group::phrase.category_music_video',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(24,1,'group::phrase.category_musical_instrument',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(25,1,'group::phrase.category_playlist',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(26,1,'group::phrase.category_professional_sports_team',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(27,1,'group::phrase.category_tadio_station',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(28,1,'group::phrase.category_record_label',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(29,1,'group::phrase.category_school_sports_team',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(30,1,'group::phrase.category_song',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(31,1,'group::phrase.category_sports_league',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(32,1,'group::phrase.category_sports_venue',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(33,1,'group::phrase.category_studio',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(34,1,'group::phrase.category_tv_channel',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(35,1,'group::phrase.category_tv_network',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(36,1,'group::phrase.category_tv_show',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(37,1,'group::phrase.category_tv_movie_award',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(38,2,'group::phrase.category_appliances',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(39,2,'group::phrase.category_baby_goods_kids_goods',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(40,2,'group::phrase.category_bags_luggage',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(41,2,'group::phrase.category_building_materials',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(42,2,'group::phrase.category_camera_photo',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(43,2,'group::phrase.category_cars',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(44,2,'group::phrase.category_clothing',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(45,2,'group::phrase.category_commercial_equipment',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(46,2,'group::phrase.category_computers',NULL,1,0,1,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(47,2,'group::phrase.category_drugs',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(48,2,'group::phrase.category_electronics',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(49,2,'group::phrase.category_food_beverages',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(50,2,'group::phrase.category_furniture',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(51,2,'group::phrase.category_games_toys',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(52,2,'group::phrase.category_health_beauty',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(53,2,'group::phrase.category_home_decor',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(54,2,'group::phrase.category_household_supplies',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(55,2,'group::phrase.category_jewelry_watches',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(56,2,'group::phrase.category_kitchen_cooking',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(57,2,'group::phrase.category_movies_music',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(58,2,'group::phrase.category_musical_instrument',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(59,2,'group::phrase.category_office_supplies',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(60,2,'group::phrase.category_outdoor_gear_sporting_goods',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(61,2,'group::phrase.category_patio_garden',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(62,2,'group::phrase.category_pet_supplies',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(63,2,'group::phrase.category_product_service',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(64,2,'group::phrase.category_software',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(65,2,'group::phrase.category_tools_equipment',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(66,2,'group::phrase.category_vitamins_supplements',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(67,2,'group::phrase.category_website',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(68,2,'group::phrase.category_wine_spirits',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(69,3,'group::phrase.category_airport',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(70,3,'group::phrase.category_arts_entertainment_nightlife',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(71,3,'group::phrase.category_attractions_things_to_do',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(72,3,'group::phrase.category_automotive',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(73,3,'group::phrase.category_bank_financial_services',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(74,3,'group::phrase.category_bar',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(75,3,'group::phrase.category_book_store',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(76,3,'group::phrase.category_business_services',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(77,3,'group::phrase.category_church_religious_organization',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(78,3,'group::phrase.category_club',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(79,3,'group::phrase.category_community_government',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(80,3,'group::phrase.category_concert_venue',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(81,3,'group::phrase.category_education',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(82,3,'group::phrase.category_event_planning_event_services',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(83,3,'group::phrase.category_food_grocery',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(84,3,'group::phrase.category_health_medical_pharmacy',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(85,3,'group::phrase.category_home_improvement',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(86,3,'group::phrase.category_hospital_clinic',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(87,3,'group::phrase.category_hotel',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(88,3,'group::phrase.category_landmark',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(89,3,'group::phrase.category_library',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(90,3,'group::phrase.category_local_business',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(91,3,'group::phrase.category_movie_theater',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(92,3,'group::phrase.category_museum_art_gallery',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(93,3,'group::phrase.category_pet_services',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(94,3,'group::phrase.category_professional_services',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(95,3,'group::phrase.category_public_places',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(96,3,'group::phrase.category_real_estate',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(97,3,'group::phrase.category_restaurant_cafe',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(98,3,'group::phrase.category_school',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(99,3,'group::phrase.category_shopping_retail',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(100,3,'group::phrase.category_spas_beauty_personal_care',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(101,3,'group::phrase.category_sports_venue',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(102,3,'group::phrase.category_sports_recreation_activities',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(103,3,'group::phrase.category_tours_sightseeing',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(104,3,'group::phrase.category_transit_stop',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(105,3,'group::phrase.category_transportation',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(106,3,'group::phrase.category_university',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(107,4,'group::phrase.category_aerospace_defense',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(108,4,'group::phrase.category_automobiles_and_parts',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(109,4,'group::phrase.category_bank_financial_institution',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(110,4,'group::phrase.category_biotechnology',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(111,4,'group::phrase.category_cause',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(112,4,'group::phrase.category_chemicals',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(113,4,'group::phrase.category_church_religious_organization',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(114,4,'group::phrase.category_community_organization',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(115,4,'group::phrase.category_company',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(116,4,'group::phrase.category_computers_technology',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(117,4,'group::phrase.category_consulting_business_services',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(118,4,'group::phrase.category_education',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(119,4,'group::phrase.category_energy_utility',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(120,4,'group::phrase.category_engineering_construction',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(121,4,'group::phrase.category_farming_agriculture',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(122,4,'group::phrase.category_food_beverages',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(123,4,'group::phrase.category_government_organization',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(124,4,'group::phrase.category_health_beauty',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(125,4,'group::phrase.category_health_medical_pharmaceuticals',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(126,4,'group::phrase.category_industrials',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(127,4,'group::phrase.category_insurance_company',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(128,4,'group::phrase.category_internet_software',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(129,4,'group::phrase.category_legal_law',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(130,4,'group::phrase.category_media_news_publishing',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(131,4,'group::phrase.category_mining_materials',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(132,4,'group::phrase.category_non_governmental_organization_ngo',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(133,4,'group::phrase.category_non_profit_organization',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(134,4,'group::phrase.category_organization',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(135,4,'group::phrase.category_political_organization',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(136,4,'group::phrase.category_political_party',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(137,4,'group::phrase.category_retail_and_consumer_merchandise',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(138,4,'group::phrase.category_school',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(139,4,'group::phrase.category_small_business',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(140,4,'group::phrase.category_telecommunication',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(141,4,'group::phrase.category_transport_freight',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(142,4,'group::phrase.category_travel_leisure',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(143,4,'group::phrase.category_university',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(144,5,'group::phrase.category_actor_director',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(145,5,'group::phrase.category_artist',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(146,5,'group::phrase.category_athlete',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(147,5,'group::phrase.category_author',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(148,5,'group::phrase.category_business_person',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(149,5,'group::phrase.category_chef',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(150,5,'group::phrase.category_coach',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(151,5,'group::phrase.category_comedian',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(152,5,'group::phrase.category_dancer',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(153,5,'group::phrase.category_doctor',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(154,5,'group::phrase.category_editor',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(155,5,'group::phrase.category_entertainer',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(156,5,'group::phrase.category_fictional_character',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(157,5,'group::phrase.category_government_official',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(158,5,'group::phrase.category_journalist',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(159,5,'group::phrase.category_lawyer',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(160,5,'group::phrase.category_monarch',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(161,5,'group::phrase.category_musician_band',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(162,5,'group::phrase.category_news_personality',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(163,5,'group::phrase.category_politician',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(164,5,'group::phrase.category_producer',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(165,5,'group::phrase.category_public_figure',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(166,5,'group::phrase.category_teacher',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL),
(167,5,'group::phrase.category_writer',NULL,1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',2,NULL);
CREATE TABLE `group_category_relations` (
  `parent_id` int(10) unsigned NOT NULL,
  `child_id` int(10) unsigned NOT NULL,
  `depth` int(10) unsigned NOT NULL,
  KEY `group_category_relations_parent_id_index` (`parent_id`),
  KEY `group_category_relations_child_id_index` (`child_id`),
  KEY `group_category_relations_depth_index` (`depth`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `group_category_relations` VALUES
(1,1,1),
(2,2,1),
(3,3,1),
(4,4,1),
(5,5,1),
(6,6,1),
(7,7,1),
(8,8,1),
(9,9,1),
(1,1,1),
(2,2,1),
(3,3,1),
(4,4,1),
(5,5,1),
(6,6,1),
(7,7,1),
(8,8,1),
(9,9,1),
(1,10,2),
(10,10,1),
(1,11,2),
(11,11,1),
(1,12,2),
(12,12,1),
(1,13,2),
(13,13,1),
(1,14,2),
(14,14,1),
(1,15,2),
(15,15,1),
(1,16,2),
(16,16,1),
(1,17,2),
(17,17,1),
(1,18,2),
(18,18,1),
(1,19,2),
(19,19,1),
(1,20,2),
(20,20,1),
(1,21,2),
(21,21,1),
(1,22,2),
(22,22,1),
(1,23,2),
(23,23,1),
(1,24,2),
(24,24,1),
(1,25,2),
(25,25,1),
(1,26,2),
(26,26,1),
(1,27,2),
(27,27,1),
(1,28,2),
(28,28,1),
(1,29,2),
(29,29,1),
(1,30,2),
(30,30,1),
(1,31,2),
(31,31,1),
(1,32,2),
(32,32,1),
(1,33,2),
(33,33,1),
(1,34,2),
(34,34,1),
(1,35,2),
(35,35,1),
(1,36,2),
(36,36,1),
(1,37,2),
(37,37,1),
(2,38,2),
(38,38,1),
(2,39,2),
(39,39,1),
(2,40,2),
(40,40,1),
(2,41,2),
(41,41,1),
(2,42,2),
(42,42,1),
(2,43,2),
(43,43,1),
(2,44,2),
(44,44,1),
(2,45,2),
(45,45,1),
(2,46,2),
(46,46,1),
(2,47,2),
(47,47,1),
(2,48,2),
(48,48,1),
(2,49,2),
(49,49,1),
(2,50,2),
(50,50,1),
(2,51,2),
(51,51,1),
(2,52,2),
(52,52,1),
(2,53,2),
(53,53,1),
(2,54,2),
(54,54,1),
(2,55,2),
(55,55,1),
(2,56,2),
(56,56,1),
(2,57,2),
(57,57,1),
(2,58,2),
(58,58,1),
(2,59,2),
(59,59,1),
(2,60,2),
(60,60,1),
(2,61,2),
(61,61,1),
(2,62,2),
(62,62,1),
(2,63,2),
(63,63,1),
(2,64,2),
(64,64,1),
(2,65,2),
(65,65,1),
(2,66,2),
(66,66,1),
(2,67,2),
(67,67,1),
(2,68,2),
(68,68,1),
(3,69,2),
(69,69,1),
(3,70,2),
(70,70,1),
(3,71,2),
(71,71,1),
(3,72,2),
(72,72,1),
(3,73,2),
(73,73,1),
(3,74,2),
(74,74,1),
(3,75,2),
(75,75,1),
(3,76,2),
(76,76,1),
(3,77,2),
(77,77,1),
(3,78,2),
(78,78,1),
(3,79,2),
(79,79,1),
(3,80,2),
(80,80,1),
(3,81,2),
(81,81,1),
(3,82,2),
(82,82,1),
(3,83,2),
(83,83,1),
(3,84,2),
(84,84,1),
(3,85,2),
(85,85,1),
(3,86,2),
(86,86,1),
(3,87,2),
(87,87,1),
(3,88,2),
(88,88,1),
(3,89,2),
(89,89,1),
(3,90,2),
(90,90,1),
(3,91,2),
(91,91,1),
(3,92,2),
(92,92,1),
(3,93,2),
(93,93,1),
(3,94,2),
(94,94,1),
(3,95,2),
(95,95,1),
(3,96,2),
(96,96,1),
(3,97,2),
(97,97,1),
(3,98,2),
(98,98,1),
(3,99,2),
(99,99,1),
(3,100,2),
(100,100,1),
(3,101,2),
(101,101,1),
(3,102,2),
(102,102,1),
(3,103,2),
(103,103,1),
(3,104,2),
(104,104,1),
(3,105,2),
(105,105,1),
(3,106,2),
(106,106,1),
(4,107,2),
(107,107,1),
(4,108,2),
(108,108,1),
(4,109,2),
(109,109,1),
(4,110,2),
(110,110,1),
(4,111,2),
(111,111,1),
(4,112,2),
(112,112,1),
(4,113,2),
(113,113,1),
(4,114,2),
(114,114,1),
(4,115,2),
(115,115,1),
(4,116,2),
(116,116,1),
(4,117,2),
(117,117,1),
(4,118,2),
(118,118,1),
(4,119,2),
(119,119,1),
(4,120,2),
(120,120,1),
(4,121,2),
(121,121,1),
(4,122,2),
(122,122,1),
(4,123,2),
(123,123,1),
(4,124,2),
(124,124,1),
(4,125,2),
(125,125,1),
(4,126,2),
(126,126,1),
(4,127,2),
(127,127,1),
(4,128,2),
(128,128,1),
(4,129,2),
(129,129,1),
(4,130,2),
(130,130,1),
(4,131,2),
(131,131,1),
(4,132,2),
(132,132,1),
(4,133,2),
(133,133,1),
(4,134,2),
(134,134,1),
(4,135,2),
(135,135,1),
(4,136,2),
(136,136,1),
(4,137,2),
(137,137,1),
(4,138,2),
(138,138,1),
(4,139,2),
(139,139,1),
(4,140,2),
(140,140,1),
(4,141,2),
(141,141,1),
(4,142,2),
(142,142,1),
(4,143,2),
(143,143,1),
(5,144,2),
(144,144,1),
(5,145,2),
(145,145,1),
(5,146,2),
(146,146,1),
(5,147,2),
(147,147,1),
(5,148,2),
(148,148,1),
(5,149,2),
(149,149,1),
(5,150,2),
(150,150,1),
(5,151,2),
(151,151,1),
(5,152,2),
(152,152,1),
(5,153,2),
(153,153,1),
(5,154,2),
(154,154,1),
(5,155,2),
(155,155,1),
(5,156,2),
(156,156,1),
(5,157,2),
(157,157,1),
(5,158,2),
(158,158,1),
(5,159,2),
(159,159,1),
(5,160,2),
(160,160,1),
(5,161,2),
(161,161,1),
(5,162,2),
(162,162,1),
(5,163,2),
(163,163,1),
(5,164,2),
(164,164,1),
(5,165,2),
(165,165,1),
(5,166,2),
(166,166,1),
(5,167,2),
(167,167,1);
CREATE TABLE `group_changed_privacy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `privacy` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `privacy_type` tinyint(4) NOT NULL DEFAULT 0,
  `privacy_item` tinyint(4) NOT NULL DEFAULT 0,
  `expired_at` timestamp NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_changed_privacy_user_id_index` (`user_id`),
  KEY `ix_group_changed_privacy_user_morph` (`user_id`,`user_type`),
  KEY `group_changed_privacy_group_id_index` (`group_id`),
  KEY `group_changed_privacy_privacy_index` (`privacy`),
  KEY `group_changed_privacy_privacy_type_index` (`privacy_type`),
  KEY `group_changed_privacy_privacy_item_index` (`privacy_item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_histories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`extra`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_histories_user_id_index` (`user_id`),
  KEY `ix_group_histories_user_morph` (`user_id`,`user_type`),
  KEY `group_histories_group_id_index` (`group_id`),
  KEY `group_histories_type_index` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_integrated_modules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `package_id` varchar(255) DEFAULT NULL,
  `name` varchar(200) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `ordering` int(10) unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `tab` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_integrated_modules_group_id_index` (`group_id`),
  KEY `group_integrated_modules_module_id_index` (`module_id`),
  KEY `group_integrated_modules_package_id_index` (`package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `group_integrated_modules` VALUES
(1,3,'activity','metafox/activity','home','group::phrase.discussions',1,1,'home'),
(2,3,'group','metafox/group','about','group::phrase.about',2,1,'about'),
(3,3,'user','metafox/user','member','user::phrase.members',4,1,'member'),
(4,3,'photo','metafox/photo','photo','photo::phrase.photos',5,1,'photo'),
(5,3,'video','metafox/video','video','video::phrase.videos',5,1,'video'),
(6,3,'poll','metafox/poll','poll','poll::phrase.polls',6,1,'poll'),
(7,3,'quiz','metafox/quiz','quiz','quiz::phrase.quizzes',7,1,'quiz'),
(8,3,'marketplace','metafox/marketplace','marketplace','marketplace::phrase.marketplace',8,1,'marketplace'),
(9,3,'livestreaming','metafox/livestreaming','live_video','livestreaming::phrase.live_videos',9,1,'live-video'),
(10,3,'event','metafox/event','event','event::phrase.events',10,1,'event'),
(11,3,'forum','metafox/forum','forum','forum::phrase.forums',13,1,'forum');
CREATE TABLE `group_invite_codes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_invite_codes_user_id_index` (`user_id`),
  KEY `ix_group_invite_codes_user_morph` (`user_id`,`user_type`),
  KEY `group_invite_codes_group_id_index` (`group_id`),
  KEY `group_invite_codes_code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_invites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `group_id` bigint(20) unsigned NOT NULL,
  `invite_type` varchar(255) NOT NULL DEFAULT 'invited_member',
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_invites_user_id_index` (`user_id`),
  KEY `ix_group_invites_user_morph` (`user_id`,`user_type`),
  KEY `group_invites_owner_id_index` (`owner_id`),
  KEY `ix_group_invites_owner_morph` (`owner_id`,`owner_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_members` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) unsigned NOT NULL,
  `member_type` int(10) unsigned NOT NULL DEFAULT 0,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_members_user_id_index` (`user_id`),
  KEY `ix_group_members_user_morph` (`user_id`,`user_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `group_members` VALUES
(1,3,1,1,'user','2024-12-01 00:49:59','2024-12-01 00:49:59');
CREATE TABLE `group_muted` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `expired_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_muted_user_id_index` (`user_id`),
  KEY `ix_group_muted_user_morph` (`user_id`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_network_streams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `network_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `group_network_streams_network_id_index` (`network_id`),
  KEY `group_network_streams_item_id_index` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_privacy_streams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `privacy_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `group_privacy_streams_privacy_id_index` (`privacy_id`),
  KEY `group_privacy_streams_item_id_index` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `group_privacy_streams` VALUES
(1,1,3);
CREATE TABLE `group_question_fields` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_questions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(255) DEFAULT NULL,
  `group_id` bigint(20) unsigned NOT NULL,
  `type_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `group_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `reviewer_id` bigint(20) unsigned DEFAULT NULL,
  `reviewer_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_requests_user_id_index` (`user_id`),
  KEY `ix_group_requests_user_morph` (`user_id`,`user_type`),
  KEY `group_requests_reviewer_id_index` (`reviewer_id`),
  KEY `ix_group_requests_reviewer_morph` (`reviewer_id`,`reviewer_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_rule_examples` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` mediumtext NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `ordering` smallint(5) unsigned NOT NULL DEFAULT 0,
  `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;

INSERT INTO `group_rule_examples` VALUES
(1,'group::phrase.rule_be_polite_label','group::phrase.rule_be_polite_desc',1,1,NULL,NULL),
(2,'group::phrase.rule_vulgar_language_label','group::phrase.rule_vulgar_language_desc',1,2,NULL,NULL),
(3,'group::phrase.rule_no_ad_spam_label','group::phrase.rule_no_ad_spam_desc',1,3,NULL,NULL);
CREATE TABLE `group_rules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` mediumtext DEFAULT NULL,
  `ordering` smallint(5) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_text` (
  `id` bigint(20) unsigned NOT NULL,
  `text` mediumtext NOT NULL,
  `text_parsed` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `group_text` VALUES
(3,'&lt;p class=\"editor-paragraph\" dir=\"ltr\"&gt;&lt;span style=\"white-space: pre-wrap;\"&gt;Cheap affordable Vps shared Dedicated Hosting&lt;/span&gt;&lt;/p&gt;','<p class=\"editor-paragraph\" dir=\"ltr\"><span style=\"white-space: pre-wrap;\">Cheap affordable Vps shared Dedicated Hosting</span></p>');
CREATE TABLE `groups` (
  `id` bigint(20) unsigned NOT NULL,
  `privacy` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `privacy_type` tinyint(4) NOT NULL DEFAULT 0,
  `privacy_item` tinyint(4) NOT NULL DEFAULT 0,
  `category_id` int(10) unsigned NOT NULL DEFAULT 0,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `profile_name` varchar(255) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `external_link` varchar(255) DEFAULT NULL,
  `landing_page` varchar(255) NOT NULL DEFAULT 'home',
  `pending_mode` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `is_approved` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `featured_at` timestamp NULL DEFAULT NULL,
  `is_sponsor` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `sponsor_in_feed` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `total_member` int(10) unsigned NOT NULL DEFAULT 0,
  `total_pending_post` int(10) unsigned NOT NULL DEFAULT 0,
  `avatar_id` bigint(20) unsigned DEFAULT NULL,
  `avatar_type` varchar(255) DEFAULT NULL,
  `avatar_file_id` bigint(20) unsigned DEFAULT NULL,
  `cover_id` bigint(20) unsigned DEFAULT NULL,
  `cover_type` varchar(255) DEFAULT NULL,
  `cover_file_id` bigint(20) unsigned DEFAULT NULL,
  `cover_photo_position` varchar(10) DEFAULT NULL,
  `location_latitude` decimal(30,8) DEFAULT NULL,
  `location_longitude` decimal(30,8) DEFAULT NULL,
  `location_name` varchar(255) DEFAULT NULL,
  `is_rule_confirmation` tinyint(1) NOT NULL DEFAULT 1,
  `is_answer_membership_question` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `total_invite` int(10) unsigned NOT NULL DEFAULT 0,
  `total_admin` int(10) unsigned NOT NULL DEFAULT 0,
  `total_pending_request` int(10) unsigned NOT NULL DEFAULT 0,
  `total_question` int(10) unsigned NOT NULL DEFAULT 0,
  `total_rule` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `groups_user_id_index` (`user_id`),
  KEY `ix_groups_user_morph` (`user_id`,`user_type`),
  KEY `groups_avatar_id_index` (`avatar_id`),
  KEY `groups_avatar_id_avatar_type_index` (`avatar_id`,`avatar_type`),
  KEY `groups_cover_id_index` (`cover_id`),
  KEY `groups_cover_id_cover_type_index` (`cover_id`,`cover_type`),
  KEY `groups_privacy_index` (`privacy`),
  KEY `groups_privacy_type_index` (`privacy_type`),
  KEY `groups_privacy_item_index` (`privacy_item`),
  KEY `groups_is_approved_index` (`is_approved`),
  KEY `groups_is_featured_index` (`is_featured`),
  KEY `groups_is_sponsor_index` (`is_sponsor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `groups` VALUES
(3,0,0,0,46,1,'user','Hosting92 Ltd',NULL,NULL,NULL,'home',0,1,1,'2024-12-01 16:58:54',0,0,1,0,NULL,NULL,NULL,1,'photo',666,'0.00%',NULL,NULL,NULL,0,0,'2024-12-01 00:49:59','2024-12-01 16:58:54',NULL,0,1,0,0,0);
CREATE TABLE `hashtag_tag_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) unsigned NOT NULL,
  `item_type` varchar(255) NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hashtag_tag_item_type` (`item_id`,`item_type`,`tag_id`),
  KEY `hashtag_tag_data_item_id_index` (`item_id`),
  KEY `ix_hashtag_tag_data_item_morph` (`item_id`,`item_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `hashtag_tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `text` varchar(255) NOT NULL,
  `tag_url` varchar(255) NOT NULL,
  `total_item` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `importer_bundle` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `source` varchar(16) NOT NULL,
  `resource` varchar(64) NOT NULL,
  `priority` int(10) unsigned NOT NULL DEFAULT 0,
  `filename` varchar(255) NOT NULL,
  `entry_index` int(10) unsigned NOT NULL DEFAULT 0,
  `total_entry` int(10) unsigned NOT NULL DEFAULT 0,
  `total_retry` int(10) unsigned NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `importer_bundle_filename_unique` (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `importer_entries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bundle_id` int(10) unsigned NOT NULL,
  `priority` int(10) unsigned NOT NULL,
  `resource_id` bigint(20) unsigned DEFAULT NULL,
  `resource_type` varchar(255) DEFAULT NULL,
  `source` varchar(16) NOT NULL,
  `ref_id` varchar(128) NOT NULL,
  `total_retry` int(10) unsigned NOT NULL DEFAULT 0,
  `filename` varchar(255) DEFAULT NULL,
  `entry_index` int(11) NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL DEFAULT 'pending' COMMENT 'pending, processing, failed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `importer_entries_ref_id_source_unique` (`ref_id`,`source`),
  KEY `importer_entries_resource_id_resource_type_index` (`resource_id`,`resource_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `importer_ids` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `resource` varchar(64) NOT NULL,
  `value` int(10) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `importer_ids_resource_unique` (`resource`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `importer_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `env` varchar(16) DEFAULT 'local',
  `level_name` varchar(255) NOT NULL,
  `level` smallint(5) unsigned NOT NULL,
  `message` mediumtext NOT NULL,
  `timestamp` datetime NOT NULL,
  `context` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`context`)),
  `extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`extra`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `invite_apt_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `address` varchar(255) NOT NULL,
  `action` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invite_apt_transactions_address_index` (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `invite_codes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `code` varchar(255) NOT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invite_codes_code_unique` (`code`),
  KEY `invite_codes_user_id_index` (`user_id`),
  KEY `ix_invite_codes_user_morph` (`user_id`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `invites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned DEFAULT NULL,
  `owner_type` varchar(255) DEFAULT NULL,
  `status_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `email` varchar(255) DEFAULT NULL,
  `phone_number` varchar(60) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `code` varchar(255) NOT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `invite_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invites_user_id_index` (`user_id`),
  KEY `ix_invites_user_morph` (`user_id`,`user_type`),
  KEY `invites_owner_id_index` (`owner_id`),
  KEY `ix_invites_owner_morph` (`owner_id`,`owner_type`),
  KEY `invites_code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `jobs` VALUES
(1,'default','{\"uuid\":\"679c34a5-697e-4252-892a-115c920e39f3\",\"displayName\":\"MetaFox\\\\Marketplace\\\\Jobs\\\\MigratePriceJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Marketplace\\\\Jobs\\\\MigratePriceJob\",\"command\":\"O:40:\\\"MetaFox\\\\Marketplace\\\\Jobs\\\\MigratePriceJob\\\":0:{}\"}}',0,NULL,1732975097,1732975097),
(2,'default','{\"uuid\":\"e50341b6-ab41-4fa3-bdd6-e64c81eca2ae\",\"displayName\":\"MetaFox\\\\Group\\\\Jobs\\\\MigrateTotalPendingRequestJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Group\\\\Jobs\\\\MigrateTotalPendingRequestJob\",\"command\":\"O:48:\\\"MetaFox\\\\Group\\\\Jobs\\\\MigrateTotalPendingRequestJob\\\":0:{}\"}}',0,NULL,1732975099,1732975099),
(3,'default','{\"uuid\":\"4af3a205-7a2e-4a21-8aba-3f2fc1f95428\",\"displayName\":\"MetaFox\\\\Photo\\\\Jobs\\\\MigrateApprovedPhotoGroupItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Photo\\\\Jobs\\\\MigrateApprovedPhotoGroupItemJob\",\"command\":\"O:51:\\\"MetaFox\\\\Photo\\\\Jobs\\\\MigrateApprovedPhotoGroupItemJob\\\":3:{s:7:\\\"\\u0000*\\u0000page\\\";i:1;s:8:\\\"\\u0000*\\u0000limit\\\";i:500;s:24:\\\"\\u0000*\\u0000refreshBeforeStarting\\\";b:0;}\"}}',0,NULL,1732975100,1732975100),
(4,'default','{\"uuid\":\"d4b5dafc-6679-45ed-b1d6-dd15415bccf4\",\"displayName\":\"MetaFox\\\\Photo\\\\Jobs\\\\UpdatePhotoStatisticJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Photo\\\\Jobs\\\\UpdatePhotoStatisticJob\",\"command\":\"O:42:\\\"MetaFox\\\\Photo\\\\Jobs\\\\UpdatePhotoStatisticJob\\\":0:{}\"}}',0,NULL,1732975100,1732975100),
(5,'default','{\"uuid\":\"3644bfbf-7899-4e7d-8b47-2bf68569c992\",\"displayName\":\"MetaFox\\\\Activity\\\\Jobs\\\\MigrateActivityHistoryHashTagJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Activity\\\\Jobs\\\\MigrateActivityHistoryHashTagJob\",\"command\":\"O:54:\\\"MetaFox\\\\Activity\\\\Jobs\\\\MigrateActivityHistoryHashTagJob\\\":0:{}\"}}',0,NULL,1732975100,1732975100),
(6,'default','{\"uuid\":\"9b564d80-ddf8-47f9-8b03-51555ac09521\",\"displayName\":\"MetaFox\\\\Photo\\\\Jobs\\\\MigrateApprovedPhotoAlbumItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Photo\\\\Jobs\\\\MigrateApprovedPhotoAlbumItemJob\",\"command\":\"O:51:\\\"MetaFox\\\\Photo\\\\Jobs\\\\MigrateApprovedPhotoAlbumItemJob\\\":3:{s:7:\\\"\\u0000*\\u0000page\\\";i:1;s:8:\\\"\\u0000*\\u0000limit\\\";i:500;s:24:\\\"\\u0000*\\u0000refreshBeforeStarting\\\";b:0;}\"}}',0,NULL,1732975100,1732975100),
(7,'default','{\"uuid\":\"5fcb1fda-26d2-4252-bc74-177794eedf43\",\"displayName\":\"MetaFox\\\\Group\\\\Jobs\\\\MigratePendingRequestJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Group\\\\Jobs\\\\MigratePendingRequestJob\",\"command\":\"O:43:\\\"MetaFox\\\\Group\\\\Jobs\\\\MigratePendingRequestJob\\\":0:{}\"}}',0,NULL,1732975100,1732975100),
(8,'default','{\"uuid\":\"d9b839f2-314a-4f5f-990c-fe1f618bf4f1\",\"displayName\":\"MetaFox\\\\User\\\\Jobs\\\\MigrateTotalFollowForUserJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\User\\\\Jobs\\\\MigrateTotalFollowForUserJob\",\"command\":\"O:46:\\\"MetaFox\\\\User\\\\Jobs\\\\MigrateTotalFollowForUserJob\\\":0:{}\"}}',0,NULL,1732975100,1732975100),
(9,'default','{\"uuid\":\"19898c25-0a22-461d-95b4-998edf24c24a\",\"displayName\":\"MetaFox\\\\Photo\\\\Jobs\\\\UpdatePhotoStatisticJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Photo\\\\Jobs\\\\UpdatePhotoStatisticJob\",\"command\":\"O:42:\\\"MetaFox\\\\Photo\\\\Jobs\\\\UpdatePhotoStatisticJob\\\":0:{}\"}}',0,NULL,1732975101,1732975101),
(10,'default','{\"uuid\":\"983488a5-73c3-4c60-8b7f-8df1bcd5354e\",\"displayName\":\"MetaFox\\\\Core\\\\Jobs\\\\UpdateAdminSearch\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Core\\\\Jobs\\\\UpdateAdminSearch\",\"command\":\"O:35:\\\"MetaFox\\\\Core\\\\Jobs\\\\UpdateAdminSearch\\\":1:{s:48:\\\"\\u0000MetaFox\\\\Core\\\\Jobs\\\\UpdateAdminSearch\\u0000packageName\\\";N;}\"}}',0,NULL,1732975157,1732975157),
(11,'default','{\"uuid\":\"3469827f-bcb3-45e4-a1e3-a753d36b2de0\",\"displayName\":\"MetaFox\\\\ChatPlus\\\\Jobs\\\\ProcessSyncUsers\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\ChatPlus\\\\Jobs\\\\ProcessSyncUsers\",\"command\":\"O:38:\\\"MetaFox\\\\ChatPlus\\\\Jobs\\\\ProcessSyncUsers\\\":2:{s:6:\\\"\\u0000*\\u0000min\\\";i:0;s:6:\\\"\\u0000*\\u0000max\\\";i:30;}\"}}',0,NULL,1732976219,1732976219),
(12,'default','{\"uuid\":\"0c6c9fe4-5eca-4141-a5f5-1cc9d9294779\",\"displayName\":\"MetaFox\\\\User\\\\Notifications\\\\WelcomeNewMember\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:24:\\\"MetaFox\\\\User\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:7:{i:0;s:7:\\\"profile\\\";i:1;s:19:\\\"profile.preferences\\\";i:2;s:5:\\\"owner\\\";i:3;s:13:\\\"activity_feed\\\";i:4;s:18:\\\"activity_feed.item\\\";i:5;s:4:\\\"user\\\";i:6;s:5:\\\"roles\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"MetaFox\\\\User\\\\Notifications\\\\WelcomeNewMember\\\":2:{s:8:\\\"\\u0000*\\u0000model\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:24:\\\"MetaFox\\\\User\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:7:{i:0;s:7:\\\"profile\\\";i:1;s:19:\\\"profile.preferences\\\";i:2;s:5:\\\"owner\\\";i:3;s:13:\\\"activity_feed\\\";i:4;s:18:\\\"activity_feed.item\\\";i:5;s:4:\\\"user\\\";i:6;s:5:\\\"roles\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"c20c4b44-be55-4b25-af60-4176fa44e03f\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"}}',0,NULL,1732976906,1732976906),
(13,'default','{\"uuid\":\"469b34d7-26e9-4c35-a9a5-cf863e70edb1\",\"displayName\":\"MetaFox\\\\Friend\\\\Notifications\\\\FriendRequested\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:24:\\\"MetaFox\\\\User\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:44:\\\"MetaFox\\\\Friend\\\\Notifications\\\\FriendRequested\\\":2:{s:8:\\\"\\u0000*\\u0000model\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:35:\\\"MetaFox\\\\Friend\\\\Models\\\\FriendRequest\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"0fd6fda1-38ab-4831-b595-aaed71ae367a\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"}}',0,NULL,1732991004,1732991004),
(14,'default','{\"uuid\":\"709835db-baf1-46a8-acab-57f0a3ce6567\",\"displayName\":\"MetaFox\\\\Event\\\\Jobs\\\\CleanUpCorruptedUserOwnerEventJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Event\\\\Jobs\\\\CleanUpCorruptedUserOwnerEventJob\",\"command\":\"O:52:\\\"MetaFox\\\\Event\\\\Jobs\\\\CleanUpCorruptedUserOwnerEventJob\\\":0:{}\"}}',0,NULL,1732991211,1732991211),
(15,'default','{\"uuid\":\"0f0621ef-1d4a-49c8-a3ce-3cf2e539cbe2\",\"displayName\":\"MetaFox\\\\Forum\\\\Jobs\\\\MigrateStatistic\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Forum\\\\Jobs\\\\MigrateStatistic\",\"command\":\"O:35:\\\"MetaFox\\\\Forum\\\\Jobs\\\\MigrateStatistic\\\":1:{s:49:\\\"\\u0000MetaFox\\\\Forum\\\\Jobs\\\\MigrateStatistic\\u0000migrateLevel\\\";b:0;}\"}}',0,NULL,1732991414,1732991414),
(16,'default','{\"uuid\":\"787e6667-7c5f-4040-aa7d-8de9fbdf4df6\",\"displayName\":\"MetaFox\\\\Forum\\\\Jobs\\\\MigrateStatistic\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Forum\\\\Jobs\\\\MigrateStatistic\",\"command\":\"O:35:\\\"MetaFox\\\\Forum\\\\Jobs\\\\MigrateStatistic\\\":1:{s:49:\\\"\\u0000MetaFox\\\\Forum\\\\Jobs\\\\MigrateStatistic\\u0000migrateLevel\\\";b:0;}\"}}',0,NULL,1732991414,1732991414),
(17,'default','{\"uuid\":\"518c6db5-fc2d-4557-9d2f-7715441d176b\",\"displayName\":\"MetaFox\\\\Forum\\\\Jobs\\\\MigratePostId\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Forum\\\\Jobs\\\\MigratePostId\",\"command\":\"O:32:\\\"MetaFox\\\\Forum\\\\Jobs\\\\MigratePostId\\\":0:{}\"}}',0,NULL,1732991414,1732991414),
(18,'default','{\"uuid\":\"1a7ce0a2-b407-43b8-9b27-bf2c7ac5083c\",\"displayName\":\"MetaFox\\\\Video\\\\Jobs\\\\UpdateVideoStatisticJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Video\\\\Jobs\\\\UpdateVideoStatisticJob\",\"command\":\"O:42:\\\"MetaFox\\\\Video\\\\Jobs\\\\UpdateVideoStatisticJob\\\":0:{}\"}}',0,NULL,1732991594,1732991594),
(19,'default','{\"uuid\":\"f02fa14e-c3e3-4ab8-aec8-e541438be3ff\",\"displayName\":\"MetaFox\\\\Video\\\\Jobs\\\\UpdatePhotoAlbumTotalItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Video\\\\Jobs\\\\UpdatePhotoAlbumTotalItemJob\",\"command\":\"O:47:\\\"MetaFox\\\\Video\\\\Jobs\\\\UpdatePhotoAlbumTotalItemJob\\\":0:{}\"}}',0,NULL,1732991594,1732991594),
(20,'default','{\"uuid\":\"24fbf006-6d53-4bc0-9f9d-4ccdc21b9d2c\",\"displayName\":\"MetaFox\\\\Video\\\\Jobs\\\\UpdateVideoStatisticJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Video\\\\Jobs\\\\UpdateVideoStatisticJob\",\"command\":\"O:42:\\\"MetaFox\\\\Video\\\\Jobs\\\\UpdateVideoStatisticJob\\\":0:{}\"}}',0,NULL,1732991594,1732991594),
(21,'default','{\"uuid\":\"c199f019-b74d-4bd7-8dac-848e07e18f45\",\"displayName\":\"MetaFox\\\\Video\\\\Jobs\\\\MigrateVideoTitle\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Video\\\\Jobs\\\\MigrateVideoTitle\",\"command\":\"O:36:\\\"MetaFox\\\\Video\\\\Jobs\\\\MigrateVideoTitle\\\":0:{}\"}}',0,NULL,1732991594,1732991594),
(22,'default','{\"uuid\":\"edab1dbc-89d2-4d67-a997-9c51b1f7aa07\",\"displayName\":\"MetaFox\\\\Page\\\\Jobs\\\\MigrateTotalFollowForPageJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Page\\\\Jobs\\\\MigrateTotalFollowForPageJob\",\"command\":\"O:46:\\\"MetaFox\\\\Page\\\\Jobs\\\\MigrateTotalFollowForPageJob\\\":0:{}\"}}',0,NULL,1732991614,1732991614),
(23,'default','{\"uuid\":\"b6199102-214f-463e-995f-44899ac3120f\",\"displayName\":\"MetaFox\\\\User\\\\Jobs\\\\MigrateTotalFollowForUserJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\User\\\\Jobs\\\\MigrateTotalFollowForUserJob\",\"command\":\"O:46:\\\"MetaFox\\\\User\\\\Jobs\\\\MigrateTotalFollowForUserJob\\\":0:{}\"}}',0,NULL,1732991614,1732991614),
(24,'default','{\"uuid\":\"b7125059-fb46-4abd-a390-7b197ccb78a9\",\"displayName\":\"MetaFox\\\\Announcement\\\\Jobs\\\\RecountTotalViewJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Announcement\\\\Jobs\\\\RecountTotalViewJob\",\"command\":\"O:45:\\\"MetaFox\\\\Announcement\\\\Jobs\\\\RecountTotalViewJob\\\":0:{}\"}}',0,NULL,1732991806,1732991806),
(25,'default','{\"uuid\":\"0260f612-bac7-4810-8681-d7b0a8be6532\",\"displayName\":\"MetaFox\\\\Comment\\\\Jobs\\\\MigrateCommentHistoryHashTagJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Comment\\\\Jobs\\\\MigrateCommentHistoryHashTagJob\",\"command\":\"O:52:\\\"MetaFox\\\\Comment\\\\Jobs\\\\MigrateCommentHistoryHashTagJob\\\":0:{}\"}}',0,NULL,1732992449,1732992449),
(26,'default','{\"uuid\":\"15be51b1-947d-4d45-b887-3207c2ed026c\",\"displayName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"command\":\"O:43:\\\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\\\":2:{s:9:\\\"\\u0000*\\u0000itemId\\\";i:18;s:11:\\\"\\u0000*\\u0000itemType\\\";s:19:\\\"core_privacy_member\\\";}\"}}',0,NULL,1732997598,1732997598),
(27,'default','{\"uuid\":\"5814ea4d-5be5-40a0-a772-9e4fa8abb6d6\",\"displayName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"command\":\"O:43:\\\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\\\":2:{s:9:\\\"\\u0000*\\u0000itemId\\\";i:19;s:11:\\\"\\u0000*\\u0000itemType\\\";s:19:\\\"core_privacy_member\\\";}\"}}',0,NULL,1732997598,1732997598),
(28,'default','{\"uuid\":\"f0ad8d38-0c42-4ee8-84de-ffd3f43a17c5\",\"displayName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"command\":\"O:43:\\\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\\\":2:{s:9:\\\"\\u0000*\\u0000itemId\\\";i:20;s:11:\\\"\\u0000*\\u0000itemType\\\";s:19:\\\"core_privacy_member\\\";}\"}}',0,NULL,1732997598,1732997598),
(29,'default','{\"uuid\":\"e5c646f0-30ae-4260-a6d1-51dde066f794\",\"displayName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"command\":\"O:43:\\\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\\\":2:{s:9:\\\"\\u0000*\\u0000itemId\\\";i:21;s:11:\\\"\\u0000*\\u0000itemType\\\";s:19:\\\"core_privacy_member\\\";}\"}}',0,NULL,1732997629,1732997629),
(30,'default','{\"uuid\":\"d4cb9bf6-745c-4061-8de0-353b6f77ec54\",\"displayName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"command\":\"O:43:\\\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\\\":2:{s:9:\\\"\\u0000*\\u0000itemId\\\";i:22;s:11:\\\"\\u0000*\\u0000itemType\\\";s:19:\\\"core_privacy_member\\\";}\"}}',0,NULL,1732997629,1732997629),
(31,'default','{\"uuid\":\"973dd4c9-210e-4df3-8d98-aed6333d2e27\",\"displayName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"command\":\"O:43:\\\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\\\":2:{s:9:\\\"\\u0000*\\u0000itemId\\\";i:23;s:11:\\\"\\u0000*\\u0000itemType\\\";s:19:\\\"core_privacy_member\\\";}\"}}',0,NULL,1732997629,1732997629),
(32,'default','{\"uuid\":\"5785abab-1b33-433b-8686-a8245c59f85f\",\"displayName\":\"MetaFox\\\\User\\\\Notifications\\\\DirectUpdatedPassword\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:24:\\\"MetaFox\\\\User\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:1:{i:0;s:5:\\\"roles\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:48:\\\"MetaFox\\\\User\\\\Notifications\\\\DirectUpdatedPassword\\\":2:{s:8:\\\"\\u0000*\\u0000model\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:24:\\\"MetaFox\\\\User\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:3:{i:0;s:7:\\\"profile\\\";i:1;s:19:\\\"profile.preferences\\\";i:2;s:13:\\\"activity_feed\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"a3ed10a7-bfa8-41ff-b4a5-da02ad22e0d1\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"}}',0,NULL,1732997629,1732997629),
(33,'default','{\"uuid\":\"c4a8d6d1-ebc1-44b5-b98c-35e34f95f31d\",\"displayName\":\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\",\"command\":\"O:44:\\\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\\\":1:{s:8:\\\"\\u0000*\\u0000model\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:26:\\\"MetaFox\\\\Event\\\\Models\\\\Event\\\";s:2:\\\"id\\\";i:4;s:9:\\\"relations\\\";a:5:{i:0;s:5:\\\"owner\\\";i:1;s:9:\\\"eventText\\\";i:2;s:13:\\\"activity_feed\\\";i:3;s:4:\\\"user\\\";i:4;s:10:\\\"user.roles\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}',0,NULL,1733018506,1733018506),
(34,'default','{\"uuid\":\"bb759ab0-8e5f-4531-b302-a59fb257d723\",\"displayName\":\"MetaFox\\\\Group\\\\Jobs\\\\SendFollowerNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Group\\\\Jobs\\\\SendFollowerNotification\",\"command\":\"O:43:\\\"MetaFox\\\\Group\\\\Jobs\\\\SendFollowerNotification\\\":2:{s:8:\\\"\\u0000*\\u0000model\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:26:\\\"MetaFox\\\\Photo\\\\Models\\\\Photo\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:5:{i:0;s:5:\\\"album\\\";i:1;s:5:\\\"group\\\";i:2;s:13:\\\"activity_feed\\\";i:3;s:4:\\\"user\\\";i:4;s:5:\\\"owner\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:11:\\\"\\u0000*\\u0000resource\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:26:\\\"MetaFox\\\\Group\\\\Models\\\\Group\\\";s:2:\\\"id\\\";i:3;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}',0,NULL,1733075934,1733075934),
(35,'default','{\"uuid\":\"4b37b277-4eb7-469c-92b2-22c23c63b9f0\",\"displayName\":\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\",\"command\":\"O:44:\\\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\\\":1:{s:8:\\\"\\u0000*\\u0000model\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:24:\\\"MetaFox\\\\Poll\\\\Models\\\\Poll\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:5:{i:0;s:5:\\\"owner\\\";i:1;s:8:\\\"pollText\\\";i:2;s:13:\\\"activity_feed\\\";i:3;s:4:\\\"user\\\";i:4;s:10:\\\"user.roles\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}',0,NULL,1733076763,1733076763),
(36,'default','{\"uuid\":\"39416a37-5372-4271-9a78-2fc91a7c20a8\",\"displayName\":\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\",\"command\":\"O:44:\\\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\\\":1:{s:8:\\\"\\u0000*\\u0000model\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:26:\\\"MetaFox\\\\Photo\\\\Models\\\\Photo\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:6:{i:0;s:5:\\\"album\\\";i:1;s:5:\\\"group\\\";i:2;s:13:\\\"activity_feed\\\";i:3;s:4:\\\"user\\\";i:4;s:10:\\\"user.roles\\\";i:5;s:10:\\\"userEntity\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}',0,NULL,1733077172,1733077172),
(37,'default','{\"uuid\":\"3f41c55d-3d1e-4918-b355-5144ce4e0821\",\"displayName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\",\"command\":\"O:43:\\\"MetaFox\\\\Comment\\\\Jobs\\\\DeleteCommentByItemJob\\\":2:{s:9:\\\"\\u0000*\\u0000itemId\\\";i:1;s:11:\\\"\\u0000*\\u0000itemType\\\";s:11:\\\"poll_result\\\";}\"}}',0,NULL,1733077194,1733077194),
(38,'default','{\"uuid\":\"bf9686c8-e09e-4cf8-8543-5c59bd0f7d80\",\"displayName\":\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\",\"command\":\"O:44:\\\"MetaFox\\\\Follow\\\\Jobs\\\\SendFollowerNotification\\\":1:{s:8:\\\"\\u0000*\\u0000model\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:26:\\\"MetaFox\\\\Photo\\\\Models\\\\Photo\\\";s:2:\\\"id\\\";i:3;s:9:\\\"relations\\\";a:6:{i:0;s:5:\\\"album\\\";i:1;s:5:\\\"group\\\";i:2;s:13:\\\"activity_feed\\\";i:3;s:4:\\\"user\\\";i:4;s:10:\\\"user.roles\\\";i:5;s:10:\\\"userEntity\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}',0,NULL,1733077317,1733077317),
(39,'default','{\"uuid\":\"c8ea8d60-047a-473c-802f-8dc5722051a2\",\"displayName\":\"MetaFox\\\\ChatPlus\\\\Jobs\\\\ProcessSyncUsers\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\ChatPlus\\\\Jobs\\\\ProcessSyncUsers\",\"command\":\"O:38:\\\"MetaFox\\\\ChatPlus\\\\Jobs\\\\ProcessSyncUsers\\\":2:{s:6:\\\"\\u0000*\\u0000min\\\";i:0;s:6:\\\"\\u0000*\\u0000max\\\";i:30;}\"}}',0,NULL,1733173603,1733173603),
(40,'default','{\"uuid\":\"c84f98f5-6f16-44c6-b0fb-53363fdc08ad\",\"displayName\":\"MetaFox\\\\Core\\\\Jobs\\\\UpdateAdminSearch\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"MetaFox\\\\Core\\\\Jobs\\\\UpdateAdminSearch\",\"command\":\"O:35:\\\"MetaFox\\\\Core\\\\Jobs\\\\UpdateAdminSearch\\\":1:{s:48:\\\"\\u0000MetaFox\\\\Core\\\\Jobs\\\\UpdateAdminSearch\\u0000packageName\\\";N;}\"}}',0,NULL,1735763268,1735763268);
CREATE TABLE `layout_revisions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `snippet_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `data` mediumtext 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;

CREATE TABLE `layout_snippets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `theme` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `variant` varchar(255) DEFAULT NULL,
  `snippet` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `data` mediumtext NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `revision_id` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `layout_themes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `theme_id` varchar(255) NOT NULL,
  `resolution` varchar(255) NOT NULL DEFAULT 'web',
  `title` varchar(255) NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `is_system` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `total_variant` int(10) unsigned NOT NULL DEFAULT 0,
  `thumb_url` varchar(255) DEFAULT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `package_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `layout_themes_theme_id_unique` (`theme_id`),
  KEY `layout_themes_module_id_index` (`module_id`),
  KEY `layout_themes_package_id_index` (`package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `layout_themes` VALUES
(1,'a0','web','Default',1,1,6,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL),
(2,'admincp','admin','AdminCP',1,1,1,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL);
CREATE TABLE `layout_variants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `theme_id` varchar(255) NOT NULL,
  `variant_id` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `is_system` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `thumb_url` varchar(255) DEFAULT NULL,
  `thumb_id` bigint(20) unsigned DEFAULT NULL,
  `dark_thumb_id` bigint(20) unsigned DEFAULT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `package_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `layout_variants_variant_id_unique` (`variant_id`),
  KEY `layout_variants_module_id_index` (`module_id`),
  KEY `layout_variants_package_id_index` (`package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `layout_variants` VALUES
(1,'a0','a0','Blue',1,1,NULL,NULL,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL),
(2,'a0','a1','Purple',1,1,NULL,NULL,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL),
(3,'a0','a2','Red',1,1,NULL,NULL,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL),
(4,'a0','a3','Green',1,1,NULL,NULL,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL),
(5,'a0','a4','Deep Blue',1,1,NULL,NULL,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL),
(6,'a0','a5','Deep Purple',1,1,NULL,NULL,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL),
(7,'admincp','admincp','AdminCP',1,1,NULL,NULL,NULL,NULL,'metafox/core','2024-11-30 12:58:29',NULL);
CREATE TABLE `like_aggregations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) unsigned NOT NULL,
  `item_type` varchar(255) NOT NULL,
  `reaction_id` int(10) unsigned NOT NULL DEFAULT 0,
  `total_reaction` int(10) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `like_aggregations_item_id_item_type_reaction_id_unique` (`item_id`,`item_type`,`reaction_id`),
  KEY `like_aggregations_item_id_index` (`item_id`),
  KEY `ix_like_aggregations_item_morph` (`item_id`,`item_type`),
  KEY `item_reaction_count` (`item_id`,`item_type`,`reaction_id`,`total_reaction`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `like_reactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `color` varchar(50) NOT NULL DEFAULT '#2681D5',
  `icon_file_id` bigint(20) unsigned DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `icon_path` varchar(255) DEFAULT NULL,
  `server_id` varchar(255) DEFAULT NULL,
  `ordering` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `icon_font` varchar(255) NOT NULL DEFAULT 'ico-thumbup-o',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `like_reactions` VALUES
(1,'like::phrase.like__u',1,1,'009fe2',533,'assets/images/images/like.png','assets/like/images/like.svg','asset',1,'2024-11-30 18:06:29','2024-11-30 18:06:34','ico-thumbup-o'),
(2,'like::phrase.love__u',1,0,'ff314c',534,'assets/images/images/love.png','assets/like/images/love.svg','asset',2,'2024-11-30 18:06:31','2024-11-30 18:06:34','ico-thumbup-o'),
(3,'like::phrase.haha__u',1,0,'ffc84d',532,'assets/images/images/haha.png','assets/like/images/haha.svg','asset',1,'2024-11-30 18:06:31','2024-11-30 18:06:34','ico-thumbup-o'),
(4,'like::phrase.wow__u',1,0,'ffc84d',536,'assets/images/images/wow.png','assets/like/images/wow.svg','asset',1,'2024-11-30 18:06:31','2024-11-30 18:06:35','ico-thumbup-o'),
(5,'like::phrase.sad__u',1,0,'ffc84d',535,'assets/images/images/sad.png','assets/like/images/sad.svg','asset',1,'2024-11-30 18:06:31','2024-11-30 18:06:34','ico-thumbup-o'),
(6,'like::phrase.angry__u',1,0,'e95921',531,'assets/images/images/angry.png','assets/like/images/angry.svg','asset',1,'2024-11-30 18:06:31','2024-11-30 18:06:34','ico-thumbup-o');
CREATE TABLE `likes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) unsigned NOT NULL,
  `item_type` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `reaction_id` int(10) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `likes_item_id_index` (`item_id`),
  KEY `ix_likes_item_morph` (`item_id`,`item_type`),
  KEY `likes_user_id_index` (`user_id`),
  KEY `ix_likes_user_morph` (`user_id`,`user_type`),
  KEY `likes_owner_id_index` (`owner_id`),
  KEY `ix_likes_owner_morph` (`owner_id`,`owner_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `livestreaming_live_videos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `stream_key` varchar(255) NOT NULL,
  `duration` decimal(14,2) DEFAULT NULL,
  `asset_id` varchar(255) DEFAULT NULL,
  `live_stream_id` varchar(255) DEFAULT NULL,
  `live_type` varchar(10) NOT NULL DEFAULT 'mobile',
  `is_streaming` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `is_landscape` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `module_id` varchar(255) DEFAULT NULL,
  `package_id` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `privacy` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `featured_at` timestamp NULL DEFAULT NULL,
  `is_sponsor` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `sponsor_in_feed` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `tags` mediumtext DEFAULT NULL,
  `total_comment` int(10) unsigned NOT NULL DEFAULT 0,
  `total_reply` int(10) unsigned NOT NULL DEFAULT 0,
  `total_like` int(10) unsigned NOT NULL DEFAULT 0,
  `total_share` int(10) unsigned NOT NULL DEFAULT 0,
  `total_view` int(10) unsigned NOT NULL DEFAULT 0,
  `total_attachment` int(10) unsigned NOT NULL DEFAULT 0,
  `image_file_id` bigint(20) unsigned DEFAULT NULL,
  `is_approved` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `location_latitude` decimal(30,8) DEFAULT NULL,
  `location_longitude` decimal(30,8) DEFAULT NULL,
  `location_name` varchar(255) DEFAULT NULL,
  `view_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `last_ping` varchar(255) DEFAULT NULL,
  `total_viewer` int(10) unsigned NOT NULL DEFAULT 0,
  `allow_feed` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `tagged_friends` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `total_pending_comment` int(10) unsigned NOT NULL DEFAULT 0,
  `total_pending_reply` int(10) unsigned NOT NULL DEFAULT 0,
  `total_tag_friend` int(10) unsigned NOT NULL DEFAULT 0,
  `to_story` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `livestreaming_live_videos_user_id_index` (`user_id`),
  KEY `ix_livestreaming_live_videos_user_morph` (`user_id`,`user_type`),
  KEY `livestreaming_live_videos_owner_id_index` (`owner_id`),
  KEY `ix_livestreaming_live_videos_owner_morph` (`owner_id`,`owner_type`),
  KEY `livestreaming_live_videos_module_id_index` (`module_id`),
  KEY `livestreaming_live_videos_package_id_index` (`package_id`),
  KEY `livestreaming_live_videos_privacy_index` (`privacy`),
  KEY `livestreaming_live_videos_is_featured_index` (`is_featured`),
  KEY `livestreaming_live_videos_is_sponsor_index` (`is_sponsor`),
  KEY `livestreaming_live_videos_is_approved_index` (`is_approved`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `livestreaming_network_streams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `network_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `livestreaming_network_streams_network_id_index` (`network_id`),
  KEY `livestreaming_network_streams_item_id_index` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `livestreaming_notification_setting` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `livestreaming_notification_setting_user_id_index` (`user_id`),
  KEY `ix_livestreaming_notification_setting_user_morph` (`user_id`,`user_type`),
  KEY `livestreaming_notification_setting_owner_id_index` (`owner_id`),
  KEY `ix_livestreaming_notification_setting_owner_morph` (`owner_id`,`owner_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `livestreaming_playback_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `live_id` bigint(20) unsigned NOT NULL,
  `playback_id` varchar(255) NOT NULL,
  `privacy` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `livestreaming_privacy_streams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `privacy_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `livestreaming_privacy_streams_privacy_id_index` (`privacy_id`),
  KEY `livestreaming_privacy_streams_item_id_index` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `livestreaming_service` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `driver` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `service_class` varchar(255) NOT NULL,
  `extra` text DEFAULT 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;

INSERT INTO `livestreaming_service` VALUES
(1,'mux','Mux',1,1,'MetaFox\\Mux\\Support\\Providers\\Mux','{\"url\":\"\\/admincp\\/mux\\/setting\\/livestreaming\"}',NULL,NULL);
CREATE TABLE `livestreaming_tag_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) unsigned NOT NULL,
  `tag_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `livestreaming_tag_data_item_id_tag_id_unique` (`item_id`,`tag_id`),
  KEY `livestreaming_tag_data_item_id_index` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `livestreaming_text` (
  `id` bigint(20) unsigned NOT NULL,
  `text` mediumtext NOT NULL,
  `text_parsed` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `livestreaming_user_stream_key` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `asset_id` varchar(255) DEFAULT NULL,
  `stream_key` varchar(255) NOT NULL,
  `live_stream_id` varchar(255) NOT NULL,
  `playback_ids` varchar(255) DEFAULT NULL,
  `is_streaming` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `connected_from` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `livestreaming_user_stream_key_user_id_index` (`user_id`),
  KEY `ix_livestreaming_user_stream_key_user_morph` (`user_id`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `log_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `env` varchar(16) DEFAULT 'local',
  `level_name` varchar(255) NOT NULL,
  `level` smallint(5) unsigned NOT NULL,
  `message` mediumtext NOT NULL,
  `timestamp` datetime NOT NULL,
  `context` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`context`)),
  `extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`extra`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `name_url` varchar(255) DEFAULT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `ordering` int(10) unsigned NOT NULL DEFAULT 0,
  `total_item` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `level` int(10) unsigned NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_categories_name_url_index` (`name_url`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `marketplace_categories` VALUES
(1,NULL,'marketplace::phrase.category_community','community',1,0,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(2,NULL,'marketplace::phrase.category_houses','houses',1,1,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(3,NULL,'marketplace::phrase.category_jobs','jobs',1,2,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(4,NULL,'marketplace::phrase.category_pets','pets',1,3,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(5,NULL,'marketplace::phrase.category_rentals','rentals',1,4,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(6,NULL,'marketplace::phrase.category_services','services',1,5,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(7,NULL,'marketplace::phrase.category_stuff','stuff',1,6,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(8,NULL,'marketplace::phrase.category_tickets','tickets',1,7,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL),
(9,NULL,'marketplace::phrase.category_vehicles','vehicles',1,8,0,'2024-11-30 12:58:30','2024-11-30 12:58:30',1,NULL);
CREATE TABLE `marketplace_category_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) unsigned NOT NULL,
  `category_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_category_data_item_id_index` (`item_id`),
  KEY `marketplace_category_data_category_id_index` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_category_relations` (
  `parent_id` int(10) unsigned NOT NULL,
  `child_id` int(10) unsigned NOT NULL,
  `depth` int(10) unsigned NOT NULL,
  KEY `marketplace_category_relations_parent_id_index` (`parent_id`),
  KEY `marketplace_category_relations_child_id_index` (`child_id`),
  KEY `marketplace_category_relations_depth_index` (`depth`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `marketplace_category_relations` VALUES
(1,1,1),
(2,2,1),
(3,3,1),
(4,4,1),
(5,5,1),
(6,6,1),
(7,7,1),
(8,8,1),
(9,9,1),
(1,1,1),
(2,2,1),
(3,3,1),
(4,4,1),
(5,5,1),
(6,6,1),
(7,7,1),
(8,8,1),
(9,9,1);
CREATE TABLE `marketplace_invites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `listing_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned DEFAULT NULL,
  `owner_type` varchar(255) DEFAULT NULL,
  `method_type` varchar(15) DEFAULT NULL,
  `method_value` varchar(255) DEFAULT NULL,
  `visited_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_invites_user_id_index` (`user_id`),
  KEY `ix_marketplace_invites_user_morph` (`user_id`,`user_type`),
  KEY `marketplace_invites_owner_id_index` (`owner_id`),
  KEY `ix_marketplace_invites_owner_morph` (`owner_id`,`owner_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_invoice_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `status` varchar(15) NOT NULL,
  `price` decimal(14,2) unsigned NOT NULL,
  `currency_id` char(3) NOT NULL,
  `transaction_id` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payment_gateway` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `marketplace_transaction_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `listing_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `price` decimal(14,2) NOT NULL DEFAULT 0.00,
  `currency_id` char(3) NOT NULL,
  `payment_gateway` int(10) unsigned NOT NULL DEFAULT 0,
  `status` varchar(15) NOT NULL,
  `paid_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_invoices_user_id_index` (`user_id`),
  KEY `ix_marketplace_invoices_user_morph` (`user_id`,`user_type`),
  KEY `marketplace_invoice_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_listing_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `listing_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `visited_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_listing_histories_user_id_index` (`user_id`),
  KEY `ix_marketplace_listing_histories_user_morph` (`user_id`,`user_type`),
  KEY `history_listing_id` (`listing_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_listing_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `listing_id` bigint(20) unsigned NOT NULL,
  `image_file_id` bigint(20) unsigned DEFAULT NULL,
  `ordering` int(10) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_listing_network_streams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `network_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_listing_network_streams_network_id_index` (`network_id`),
  KEY `marketplace_listing_network_streams_item_id_index` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_listing_prices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `listing_id` bigint(20) unsigned NOT NULL,
  `currency_id` char(3) NOT NULL,
  `price` decimal(14,2) unsigned NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`),
  UNIQUE KEY `listing_price` (`listing_id`,`currency_id`),
  KEY `listing_id` (`listing_id`),
  KEY `currency_id` (`currency_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_listing_privacy_streams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `privacy_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_listing_privacy_streams_privacy_id_index` (`privacy_id`),
  KEY `marketplace_listing_privacy_streams_item_id_index` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_listing_tag_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) unsigned NOT NULL,
  `tag_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `marketplace_listing_tag_data_item_id_tag_id_unique` (`item_id`,`tag_id`),
  KEY `marketplace_listing_tag_data_item_id_index` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_listing_text` (
  `id` bigint(20) unsigned NOT NULL,
  `text` mediumtext NOT NULL,
  `text_parsed` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `marketplace_listings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `privacy` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `owner_type` varchar(255) NOT NULL,
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `featured_at` timestamp NULL DEFAULT NULL,
  `is_sponsor` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `sponsor_in_feed` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `tags` mediumtext DEFAULT NULL,
  `total_comment` int(10) unsigned NOT NULL DEFAULT 0,
  `total_reply` int(10) unsigned NOT NULL DEFAULT 0,
  `total_like` int(10) unsigned NOT NULL DEFAULT 0,
  `total_share` int(10) unsigned NOT NULL DEFAULT 0,
  `total_view` int(10) unsigned NOT NULL DEFAULT 0,
  `total_attachment` int(10) unsigned NOT NULL DEFAULT 0,
  `allow_payment` tinyint(1) NOT NULL DEFAULT 0,
  `allow_point_payment` tinyint(1) NOT NULL DEFAULT 0,
  `auto_sold` tinyint(1) NOT NULL DEFAULT 0,
  `is_sold` tinyint(1) NOT NULL DEFAULT 0,
  `is_notified` tinyint(1) NOT NULL DEFAULT 0,
  `price` text NOT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `image_file_id` bigint(20) unsigned DEFAULT NULL,
  `location_latitude` decimal(30,8) DEFAULT NULL,
  `location_longitude` decimal(30,8) DEFAULT NULL,
  `location_name` varchar(255) DEFAULT NULL,
  `country_iso` varchar(2) DEFAULT NULL,
  `is_approved` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_expired_at` bigint(20) DEFAULT NULL,
  `notify_at` bigint(20) NOT NULL DEFAULT 0,
  `total_pending_comment` int(10) unsigned NOT NULL DEFAULT 0,
  `total_pending_reply` int(10) unsigned NOT NULL DEFAULT 0,
  `external_link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_listings_user_id_index` (`user_id`),
  KEY `ix_marketplace_listings_user_morph` (`user_id`,`user_type`),
  KEY `marketplace_listings_owner_id_index` (`owner_id`),
  KEY `ix_marketplace_listings_owner_morph` (`owner_id`,`owner_type`),
  KEY `marketplace_listings_privacy_index` (`privacy`),
  KEY `marketplace_listings_is_featured_index` (`is_featured`),
  KEY `marketplace_listings_is_sponsor_index` (`is_sponsor`),
  KEY `marketplace_listings_is_approved_index` (`is_approved`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `mfa_enforce_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `enforce_status` enum('success','blocked','cancelled','forced') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `due_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mfa_enforce_requests_user_id_index` (`user_id`),
  KEY `ix_mfa_enforce_requests_user_morph` (`user_id`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `mfa_services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `label` varchar(100) NOT NULL,
  `service_class` text NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `config` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mfa_services_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `mfa_services` VALUES
(1,'authenticator','Authenticator','MetaFox\\Mfa\\Support\\Services\\Authenticator',1,'{\"icon\":{\"web\":\"ico-key\",\"mobile\":\"key\"}}'),
(2,'email','Email Authentication','MetaFox\\Mfa\\Support\\Services\\Email',1,'{\"icon\":{\"web\":\"ico-envelope-o\",\"mobile\":\"envelope-o\"}}'),
(3,'sms','SMS Authentication','MetaFox\\Mfa\\Support\\Services\\Sms',1,'{\"icon\":{\"web\":\"ico-comment-square-o\",\"mobile\":\"comment-square-o\"}}');
CREATE TABLE `mfa_user_auth_tokens` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `value` varchar(128) NOT NULL,
  `is_authenticated` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `expired_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `resolution` varchar(255) NOT NULL DEFAULT 'web',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mfa_user_auth_tokens_value_unique` (`value`),
  KEY `mfa_user_auth_tokens_user_id_index` (`user_id`),
  KEY `ix_mfa_user_auth_tokens_user_morph` (`user_id`,`user_type`),
  KEY `mfa_user_auth_tokens_is_authenticated_index` (`is_authenticated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `mfa_user_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `service` varchar(50) NOT NULL,
  `value` text NOT NULL,
  `extra` text NOT NULL,
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `last_authenticated` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_user_service_unique` (`user_id`,`service`),
  KEY `mfa_user_services_user_id_index` (`user_id`),
  KEY `ix_mfa_user_services_user_morph` (`user_id`,`user_type`),
  KEY `mfa_user_services_service_index` (`service`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `mfa_user_verify_code` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `service` varchar(50) NOT NULL,
  `action` varchar(64) NOT NULL,
  `code` varchar(255) NOT NULL,
  `expired_at` timestamp NOT NULL,
  `authenticated_at` timestamp NULL DEFAULT NULL,
  `is_active` int(10) unsigned NOT NULL DEFAULT 1,
  `last_sent_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mfa_user_verify_code_user_id_index` (`user_id`),
  KEY `ix_mfa_user_verify_code_user_morph` (`user_id`,`user_type`),
  KEY `mfa_user_verify_code_service_index` (`service`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_resets_table',1),
(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),
(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),
(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),
(6,'2016_06_01_000004_create_oauth_clients_table',1),
(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),
(8,'2019_08_19_000000_create_failed_jobs_table',1),
(9,'2020_12_29_025357_create_packages_table',1),
(10,'2020_12_30_090th_migrate_packages_table',1),
(11,'2021_01_14_080233_create_user_profiles_table',1),
(12,'2021_01_15_074304_create_permission_tables',1),
(13,'2021_01_25_022433_create_phrases_table',1),
(14,'2021_02_03_072302_InitStickerTables',1),
(15,'2021_02_03_085750_InitGroupTables',1),
(16,'2021_02_03_091918_InitNotificationTables',1),
(17,'2021_02_03_095954_InitActivityPointTables',1),
(18,'2021_02_03_111111_PaymentTables',1),
(19,'2021_02_04_034533_CreateQuizTables',1),
(20,'2021_02_04_034552_CreateMarketplaceTables',1),
(21,'2021_02_04_041541_CreateHashtagTables',1),
(22,'2021_02_04_090th_migrate_activity_pins_table',1),
(23,'2021_02_04_105606_Activity',1),
(24,'2021_02_05_043515_Photo',1),
(25,'2021_02_05_084950_User',1),
(26,'2021_02_05_08th_migrate_user_verification_table',1),
(27,'2021_02_25_020811_InitFriendRequestTables',1),
(28,'2021_03_04_080th_migrate_site_settings_table',1),
(29,'2021_03_04_103325_Report',1),
(30,'2021_03_08_060th_migrate_sessions_table',1),
(31,'2021_03_10_073929_InitCoreTables',1),
(32,'2021_03_10_083929_core_rewrite_rules',1),
(33,'2021_03_10_083929_migrate_driver_table',1),
(34,'2021_04_30_020449_migrate_page_meta_table',1),
(35,'2021_07_14_081706_add_ldap_columns_to_users_table',1),
(36,'2021_07_21_051nd_migrate_storage_disks_table',1),
(37,'2021_07_21_051nd_migrate_storage_user_spaces_table',1),
(38,'2021_07_26_041326_create_test_items_table',1),
(39,'2021_09_21_040th_migrate_core_word_block_table',1),
(40,'2021_09_21_051nd_migrate_storage_assets_table',1),
(41,'2021_09_21_051nd_migrate_storage_files_table',1),
(42,'2021_09_24_182613_create_cache_table',1),
(43,'2021_09_27_020th_migrate_core_attachment_file_types_table',1),
(44,'2021_09_27_020th_migrate_core_attachments_table',1),
(45,'2021_12_10_044706_InitSearchTables',1),
(46,'2022_02_11_141217_InitChatPlusTables',1),
(47,'2022_06_03_060700_migrate_core_menus_table',1),
(48,'2022_06_03_061113_migrate_core_menu_items_table',1),
(49,'2022_06_03_061114_migrate_countries_table',1),
(50,'2022_06_13_090th_migrate_admin_search_table',1),
(51,'2022_06_15_080th_migrate_core_currencies_table',1),
(52,'2022_06_15_080th_migrate_core_languages_table',1),
(53,'2022_06_15_080th_migrate_core_timezones_table',1),
(54,'2022_06_30_080th_migrate_add_user_gender_table_table',1),
(55,'2022_07_03_150rd_migrate_payment_logs_table',1),
(56,'2022_07_03_150rd_migrate_payment_orders_table',1),
(57,'2022_07_03_150rd_migrate_payment_transactions_table',1),
(58,'2022_07_07_100756_StaticPageTables',1),
(59,'2022_07_27_050th_migrate_add_column_group_id_for_album_item_table',1),
(60,'2022_08_03_030811_migrate_friendTagBlocked_table',1),
(61,'2022_08_04_090th_migrate_support_photo_collection_statistic_table',1),
(62,'2022_08_05_020th_migrate_GroupCronTabChangePrivacy_table',1),
(63,'2022_08_08_040th_migrate_AddColumnIsApprove_table',1),
(64,'2022_08_18_100th_migrate_build_table',1),
(65,'2022_08_19_041941_create_jobs_table',1),
(66,'2022_08_19_070th_migrate_support_notifications_soft_delete_table',1),
(67,'2022_08_29_020th_migrate_add_parent_role_to_role_table_table',1),
(68,'2022_08_29_030th_migrate_GroupInviteCode_table',1),
(69,'2022_09_14_010th_migrate_activity_histories_table',1),
(70,'2022_09_25_060th_migrate_log_messages_table',1),
(71,'2022_10_06_080th_migrate_AddColumnIsFeatures_table',1),
(72,'2022_10_21_020st_migrate_update_extra_field_for_point_settings_table_table',1),
(73,'2022_10_26_030th_migrate_AddColumnICodeOnTableGroupInvites_table',1),
(74,'2022_10_31_030st_migrate_add_payment_gateway_filter_table',1),
(75,'2022_11_10_080th_migrate_snippet_table',1),
(76,'2022_11_15_102th_migrate_revisions_table',1),
(77,'2022_11_16_030th_migrate_add_core_admincp_accesses_table_table',1),
(78,'2022_11_16_080th_migrate_themes_table',1),
(79,'2022_11_16_080th_migrate_variants_table',1),
(80,'2022_11_20_030th_importer_bundle_table',1),
(81,'2022_11_20_030th_importer_ids_table',1),
(82,'2022_11_20_030th_importer_logs_table',1),
(83,'2022_11_20_030th_impoter_entries_table',1),
(84,'2022_11_20_030th_migrate_entries_table',1),
(85,'2022_11_30_080th_migrate_AddColumnLevelToGroupCategoryTable_table',1),
(86,'2022_11_30_080th_migrate_AddColumnLevelToMarketplaceCategoryTable_table',1),
(87,'2022_11_30_080th_migrate_AddColumnLevelToPhotoCategoryTable_table',1),
(88,'2022_12_06_090th_migrate_GroupAnnouncement_table',1),
(89,'2022_12_07_081th_migrate_menus_table',1),
(90,'2022_12_08_082th_migrate_menu_items_table',1),
(91,'2022_12_13_090th_migrate_add_device_table_table',1),
(92,'2022_12_14_040th_migrate_clean_up_old_data_table',1),
(93,'2022_12_14_100th_migrate_update_device_platform_version_column_type_table',1),
(94,'2022_12_15_090th_migrate_user_passwords_table',1),
(95,'2022_12_20_021th_migrate_user_custom_fields',1),
(96,'2022_12_20_030th_migrate_user_custom_options_table',1),
(97,'2022_12_20_110th_migrate_marketplace_invoice_transactions_table',1),
(98,'2022_12_21_031st_migrate_user_custom_value_table',1),
(99,'2022_12_21_080st_migrate_user_custom_profiles_table',1),
(100,'2022_12_21_080st_migrate_user_custom_structure_table',1),
(101,'2022_12_21_080st_migrate_user_profiles_table',1),
(102,'2022_12_22_070nd_migrate_payment_user_configurations_table',1),
(103,'2022_12_23_060rd_migrate_RemoveColumnIsMutedToTable_table',1),
(104,'2022_12_23_080rd_migrate_user_custom_section_table',1),
(105,'2022_12_25_080th_migrate_add_index_phrase_user_gender_table_table',1),
(106,'2022_12_26_020th_migrate_mfa_services_table',1),
(107,'2022_12_26_080th_migrate_AddTableNotificationModule_table',1),
(108,'2022_12_27_120th_migrate_support_user_soft_delete_table',1),
(109,'2022_12_27_130th_migrate_support_soft_delete_group_table',1),
(110,'2022_12_27_160th_migrate_mfa_user_services_table',1),
(111,'2022_12_28_090th_migrate_marketplace_invoice_transactions_table',1),
(112,'2022_12_29_030th_add_time_importer_bundle_table',1),
(113,'2022_12_30_020st_migrate_add_is_admincp_field_for_apt_transactions_table',1),
(114,'2022_12_30_030th_migrate_marketplace_listing_histories_table',1),
(115,'2023_01_03_030rd_migrate_marketplace_listings_table',1),
(116,'2023_01_05_070th_migrate_remove_global_search_hashtag_mobile_form_driver_table',1),
(117,'2023_01_06_050th_migrate_mfa_user_auth_tokens_table',1),
(118,'2023_01_11_080th_migrate_quiz_played_items_table',1),
(119,'2023_01_11_110th_migrate_contact_categories_table',1),
(120,'2023_01_16_090th_migrate_support_in_process_column_table',1),
(121,'2023_01_17_100th_migrate_auth_roles_table',1),
(122,'2023_01_19_040th_migrate_activity_subscriptions_table',1),
(123,'2023_01_30_040th_migrate_add_user_reset_password_token_table_table',1),
(124,'2023_01_30_070th_migrate_InitFollowTable_table',1),
(125,'2023_01_31_070st_migrate_AddAnswerTotalPlay_table',1),
(126,'2023_02_01_030st_migrate_DeletePollResultModuleId_table',1),
(127,'2023_02_16_040th_migrate_UserShortcutsData_table',1),
(128,'2023_02_17_040th_migrate_AddColumnRequestIdOnTabelAnswers_table',1),
(129,'2023_02_21_070st_migrate_support_report_item_aggregation_table',1),
(130,'2023_02_21_100st_migrate_languages_table',1),
(131,'2023_02_24_071th_migrate_phrases_table',1),
(132,'2023_02_28_070th_migrate_support_new_addresss_column_table',1),
(133,'2023_03_02_040nd_migrate_remove_duplicate_data_and_add_unique_index_table',1),
(134,'2023_03_03_043rd_migrate_meta_table',1),
(135,'2023_03_07_040st_migrate_DeleteNotificationTypeByName_table',1),
(136,'2023_03_07_060th_migrate_menu_items',1),
(137,'2023_03_08_020th_migrate_quiz_tag_data_table',1),
(138,'2023_03_08_090th_migrate_UpdatePaymentGatewayOfActivityPoint_table',1),
(139,'2023_03_15_110th_migrate_users_table',1),
(140,'2023_03_16_020th_migrate_AddColumnForUserRelation_table',1),
(141,'2023_03_16_090th_migrate_support_photo_hashtag_table_table',1),
(142,'2023_03_17_090th_migrate_UpdateTableUser_table',1),
(143,'2023_03_23_020rd_migrate_users_table',1),
(144,'2023_03_24_030th_migrate_update_notification_type_channel_type_id_column_type_table',1),
(145,'2023_03_27_070th_migrate_updateQuizItemActionMenu_table',1),
(146,'2023_03_29_030th_migrate_core_links_table',1),
(147,'2023_03_30_090th_migrate_add_ad_config_tables_table',1),
(148,'2023_04_07_020th_migrate_saved_item_menu_table',1),
(149,'2023_04_11_050th_migrate_core_menu_items_table',1),
(150,'2023_04_11_070th_migrate_delteMenuItemOnAdmin_table',1),
(151,'2023_04_12_040th_migrate_updateValueItemMenuForPage_table',1),
(152,'2023_04_14_020th_migrate_icon_transaction_table',1),
(153,'2023_04_17_050th_migrate_core_menu_items_table',1),
(154,'2023_04_17_090th_migrate_marketplace_listing_prices_table',1),
(155,'2023_04_17_100th_migrate_user_menus_on_profile_table',1),
(156,'2023_04_18_100th_update_menu_friend_list',1),
(157,'2023_04_18_300th_migrate_AddColumnNotifyAtTableMarketplace_table',1),
(158,'2023_04_19_100th_update_menu_user_shortcut',1),
(159,'2023_04_20_070th_migrate_notification_type_channels_table',1),
(160,'2023_04_20_080th_migrate_update-landing-menu-icon_table',1),
(161,'2023_04_20_080th_migrate_update-my-album-menu-icon_table',1),
(162,'2023_04_21_040th_migrate_updateValueItemMenuForPage_table',1),
(163,'2023_04_21_070st_migrate_add_phone_number_and_extra_column_to_user_delete_feedback_table',1),
(164,'2023_04_21_090st_migrate_update_remove_announcement_action_icon_table',1),
(165,'2023_04_24_080th_migrate_updateOrderingItemMenuForGroup_table',1),
(166,'2023_04_25_020th_migrate_core_links_table',1),
(167,'2023_04_25_021th_migrate_url_table',1),
(168,'2023_04_26_040th_migrate_group_integrated_module_table',1),
(169,'2023_04_29_100th_migrate_notification_settings_table',1),
(170,'2023_05_04_060th_migrate_InitInviteTable_table',1),
(171,'2023_05_05_070th_migrate_support_contact_category_soft_delete_table',1),
(172,'2023_05_05_070th_migrate_support_group_category_soft_delete_table',1),
(173,'2023_05_05_070th_migrate_support_marketplace_category_soft_delete_table',1),
(174,'2023_05_05_070th_migrate_support_photo_category_soft_delete_table',1),
(175,'2023_05_10_030th_migrate_update_quiz_home_menu_icon_table',1),
(176,'2023_05_10_050th_migrate_support_stat_content_group_column_table',1),
(177,'2023_05_10_070th_migrate_activity_feeds_table',1),
(178,'2023_05_10_100th_migrate_core_menu_items_table',1),
(179,'2023_05_12_070th_migrate_change_icon_follow_un_follow_menu_item_table',1),
(180,'2023_05_12_080th_migrate_removeFeedTypeGroupAndPage_table',1),
(181,'2023_05_12_080th_migrate_removeFeedTypePhoto_table',1),
(182,'2023_05_19_030th_migrate_update_quiz_pending_menu_icon_table',1),
(183,'2023_05_22_020nd_migrate_search_hashtag_statistics_table',1),
(184,'2023_05_23_201th_migrate_activeMenuOnGroupAndPage_table',1),
(185,'2023_05_24_060th_migrate_add_module_id_table',1),
(186,'2023_05_24_140th_migrate_updateProfileMenu_table',1),
(187,'2023_05_25_030th_migrate_updateLabelMenuItemtable',1),
(188,'2023_05_25_030th_migrate_update_photo_add_btn_on_owner_profile_table',1),
(189,'2023_05_26_080th_migrate_app_menus_table',1),
(190,'2023_05_26_200th_migrate_updateMenuItem_table',1),
(191,'2023_05_29_030th_migrate_updateLabelFooterMenu_table',1),
(192,'2023_05_29_060th_migrate_support_change_album_info_to_album_text_table',1),
(193,'2023_05_29_110th_migrate_auth_permissions_table',1),
(194,'2023_05_29_110th_migrate_move_report_menu_to_maintenance_parent_table',1),
(195,'2023_05_29_110th_migrate_remove_menu_item_from_setting_parent_table',1),
(196,'2023_05_29_110th_migrate_remove_menu_item_from_settings_parent_table',1),
(197,'2023_05_29_110th_migrate_remove_toggle_site_menu_from_settings_parent_table',1),
(198,'2023_05_30_080th_migrate_improve_payment_gateway_table',1),
(199,'2023_06_02_090nd_migrate_group_notifications_table',1),
(200,'2023_06_14_020th_migrate_notification_module_settings_table',1),
(201,'2023_06_14_080th_migrate_update_user_custom_options_column_label_table',1),
(202,'2023_06_20_070th_migrate_update-setting-resource-driver-name_table',1),
(203,'2023_06_21_090st_migrate_remove-unused-asset_table',1),
(204,'2023_06_22_040nd_migrate_update_unfollowing_themselves_table',1),
(205,'2023_06_23_090rd_migrate_update_mobile_menu_form_table',1),
(206,'2023_06_26_110th_migrate_hide_sponsor_permission_table',1),
(207,'2023_06_26_110th_migrate_remove_sponsor_permission_table',1),
(208,'2023_06_29_070th_migrate_update_invoice_sidebar_table',1),
(209,'2023_06_30_090th_migrate_force_replace_old_relationship_image_table',1),
(210,'2023_07_10_070th_migrate_add_column_invite_code_table',1),
(211,'2023_07_11_100th_update_menu_friend_list',1),
(212,'2023_07_12_065905_add_core_item_statistics_table',1),
(213,'2023_07_12_070th_migrate_sponsor_settings_table',1),
(214,'2023_07_12_090th_migrate_sponsor_settings_table',1),
(215,'2023_07_12_090th_migrate_update_label_menu_item_table',1),
(216,'2023_07_13_060th_migrate_sponsor_setting_table_table',1),
(217,'2023_07_18_060th_migrate_sponsor_settings_table',1),
(218,'2023_07_19_090th_migrate_remove_group_driver_table',1),
(219,'2023_07_26_040th_add_from_resource_column_activity_feeds_table',1),
(220,'2023_07_26_070th_migrate_emoney_tables_table',1),
(221,'2023_07_27_020th_migrate_payment_payee_columns_table',1),
(222,'2023_07_27_29th_remove_sticker_set_permission',1),
(223,'2023_07_28_030th_migrate_menu_admin_update_table',1),
(224,'2023_07_28_070th_remove_quiz_no_image_asset',1),
(225,'2023_08_02_070nd_migrate_remove_used_phrases_for_chatplus_table',1),
(226,'2023_08_02_30th_create_user_relation_histories_table',1),
(227,'2023_08_03_080rd_migrate_friend_tag_friend_send_notification_table',1),
(228,'2023_08_10_020th_migrate_total_friend_table',1),
(229,'2023_08_10_030th_migrate_update_icon_menu_all_friend_table',1),
(230,'2023_08_10_121th_migrate_total_mention_table',1),
(231,'2023_08_11_050th_migrate_mfa_user_verify_code_table',1),
(232,'2023_08_11_070th_migrate_total_tag_friends_table',1),
(233,'2023_08_13_400th_migrate_total_table',1),
(234,'2023_08_18_110th_migrate_link_table',1),
(235,'2023_08_18_110th_migrate_photo_group_table',1),
(236,'2023_08_18_110th_migrate_photo_table',1),
(237,'2023_08_18_120th_migrate_share_table',1),
(238,'2023_08_21_010st_migrate_listing_table',1),
(239,'2023_08_21_010st_migrate_quiz_table',1),
(240,'2023_08_21_060st_migrate_user_remove_payment_menu_table',1),
(241,'2023_08_21_090st_migrate_users_table',1),
(242,'2023_08_22_070nd_migrate_update_ordering_table',1),
(243,'2023_08_23_010rd_migrate_user_custom_value_data_table',1),
(244,'2023_08_23_020rd_migrate_remove_unused_phrases_table',1),
(245,'2023_08_23_030rd_migrate_remove_unused_phrases_table',1),
(246,'2023_08_23_080rd_migrate_chat_bot_table',1),
(247,'2023_08_24_050th_migrate_core_menu_items_table',1),
(248,'2023_08_29_070th_migrate_support_language_name_alias_table',1),
(249,'2023_08_30_060th_migrate_remove_cover_id_after_delete_photo_table',1),
(250,'2023_08_30_090th_migrate_remove_avart_cover_id_after_photo_deleted_table',1),
(251,'2023_08_31_020st_migrate_invite_apt_transaction_table',1),
(252,'2023_09_05_030th_migrate_update_accountMenu_table',1),
(253,'2023_09_05_070th_migrate_user_verify_table',1),
(254,'2023_09_07_020th_migrate_update_chat_bot_kb_table',1),
(255,'2023_09_07_060th_migrate_delete_menu_item_table',1),
(256,'2023_09_11_020th_migrate_update_report_photo_menu_ordering_table',1),
(257,'2023_09_18_030th_migrate_add_timestamp_group_rule_examples_table',1),
(258,'2023_09_18_100th_migrate_update_menu_item_for_user_table',1),
(259,'2023_09_19_030th_migrate_update_menu_item_for_review_post_table',1),
(260,'2023_09_19_080th_migrate_update_menu_item_for_group_table',1),
(261,'2023_09_24_090st_migrate_add_column_birthday_month_user_profile_table',1),
(262,'2023_09_28_080th_migrate_InitNewsLetterTables_table',1),
(263,'2023_09_29_030th_migrate_enforce_resource_unique_identifier_for_custom_field_and_section_table',1),
(264,'2023_10_02_030nd_migrate_remove-add-menu-item-button_table',1),
(265,'2023_10_04_050th_migrate_emoney_menu_items_table',1),
(266,'2023_10_04_090th_migrate_emoney_big_changes_table',1),
(267,'2023_10_06_050th_migrate_ewallet_remove_emoney_menu_table',1),
(268,'2023_10_09_090th_migrate_remove_smart_banner_phrase_and_setting',1),
(269,'2023_10_10_040th_migrate_apt_point_conversion_table',1),
(270,'2023_10_16_090th_migrate_GroupHistories_table',1),
(271,'2023_10_17_020th_migrate_migrate_total_share_table',1),
(272,'2023_10_19_070th_migrate_invite_codes_table',1),
(273,'2023_10_20_040th_migrate_ewallet_migration_old_data_table',1),
(274,'2023_10_20_100th_migrate_ewallet_withdraw_fee_table',1),
(275,'2023_10_24_090th_migrate_ewallet_migrate_old_mobile_menus_table',1),
(276,'2023_10_26_090th_migrate_ewallet_migrate_menu_label_table',1),
(277,'2023_10_27_040th_migrate_addColumnTableSticker_table',1),
(278,'2023_10_27_040th_migrate_upgrade_static_page_is_active_table',1),
(279,'2023_11_14_030th_migrate_remove_unused_phrase_table',1),
(280,'2023_11_15_100th_migrate_apt_point_transaction_reduce_points_type_table',1),
(281,'2023_11_16_090th_migrate_remove_deleted_user_result_in_quiz_detail',1),
(282,'2023_11_17_060th_migrate_addColumnTableNotification_table',1),
(283,'2023_11_22_050nd_migrate_CategoryRelation_table',1),
(284,'2023_11_23_090rd_migrate_CategoryRelation_table',1),
(285,'2023_11_24_080th_migrate_ListingCategoryRelation_table',1),
(286,'2023_11_24_080th_migrate_PhotoCategoryRelation_table',1),
(287,'2023_11_28_080th_migrate_removeSidebarSearchInGroupMenu_table',1),
(288,'2023_11_28_095954_InitActivityPointActionTypeTables',1),
(289,'2023_11_30_030th_migrate_feed_old_menus_table',1),
(290,'2023_12_01_030st_migrate_migrateSiteSettingsFromVideo_table',1),
(291,'2023_12_05_040th_migrate_createUserCustomFieldByRole_table',1),
(292,'2023_12_05_100th_migrate_add_new_table_user_preferences_table',1),
(293,'2023_12_08_030th_migrate_migrate_activity_point_statistics_table',1),
(294,'2023_12_11_030th_migrate_updateMenuHeaderItemAction_table',1),
(295,'2023_12_11_080th_migrate_migrate_permissions_for_custom_role_table',1),
(296,'2023_12_12_060th_migrate_updateNotification_table',1),
(297,'2023_12_13_020st_migrate_add_new_static_page_content_model_table',1),
(298,'2023_12_13_070th_migrate_updateProfileMenuItemActivity_table',1),
(299,'2023_12_13_070th_migrate_updateProfileMenuItemGroup_table',1),
(300,'2023_12_13_070th_migrate_updateProfileMenuItemPhoto_table',1),
(301,'2023_12_13_090th_migrate_updateProfileMenuItemUser_table',1),
(302,'2023_12_13_130th_migrate_support_soft_delete_newsletter_table',1),
(303,'2023_12_14_030st_migrate_migrating_old_static_page_text_to_new_content_table',1),
(304,'2023_12_14_050th_migrate_updateProfileMenuItemListing_table',1),
(305,'2023_12_14_050th_migrate_updateProfileMenuItemQuizz_table',1),
(306,'2023_12_19_020th_migrate_payment_gateway_id_columns_table',1),
(307,'2023_12_22_080nd_migrate_updateTotalPendingRequest_table',1),
(308,'2023_12_28_070th_migrate_activity_feeds_table',1),
(309,'2023_25_4_29th_remove_hashtag_permission',1),
(310,'2023_25_4_29th_remove_mfa_permission',1),
(311,'2023_25_4_29th_remove_report_permission',1),
(312,'2023_5_10_020st_migrate_add_item_id_item_type_field_for_apt_transactions_table',1),
(313,'2024_01_09_030th_migrate_addColumnTableStructure_table',1),
(314,'2024_01_10_060th_migrate_addColumnTableCustomField_table',1),
(315,'2024_01_11_070th_migrate_migrate_invite_code_table',1),
(316,'2024_01_24_090th_migrate_remove_avart_cover_id_after_photo_deleted_table',1),
(317,'2024_01_25_090th_migrate_migrate_photo_album_sponsor_table',1),
(318,'2024_01_26_080th_migrate_AddColumnTableDevice_table',1),
(319,'2024_01_31_100th_migrate_updateSystemCustomField_table',1),
(320,'2024_02_15_020th_migrate_removePermission_table',1),
(321,'2024_02_15_040th_migrate_removeReportPermission_table',1),
(322,'2024_02_19_130th_migrate_support_multi_filter_newsletter_table',1),
(323,'2024_02_23_020rd_migrate_support_original_value_for_phrases_table_table',1),
(324,'2024_03_01_090st_migrate_migrate_search_items_column_table',1),
(325,'2024_03_07_070th_migrate_migrate_new_friends_signup_setting_table',1),
(326,'2024_03_07_080th_migrate_activity_schedules_table',1),
(327,'2024_03_07_200th_migrate_addColumnTableOptions_table',1),
(328,'2024_03_12_200th_migrate_updateGroupManageMenuItem_table',1),
(329,'2024_03_19_030th_migrate_migrate_edit_type_table',1),
(330,'2024_03_21_080th_migrate_UpdateUserIdOfTimelineAlbum_table',1),
(331,'2024_03_28_080th_migrate_group_category_relations_table',1),
(332,'2024_03_28_080th_migrate_marketplace_category_relations_table',1),
(333,'2024_03_28_080th_migrate_photo_category_relations_table',1),
(334,'2024_03_28_090th_migrate_ewallet_stats_contents_table',1),
(335,'2024_03_29_080th_migrate_featured_table',1),
(336,'2024_04_03_030rd_migrate_migrate_approved_items_table',1),
(337,'2024_04_03_090rd_migrate_update_random_frequency_capping_table',1),
(338,'2024_04_03_100rd_migrate_updatePhotoStatistic_table',1),
(339,'2024_04_05_020th_migrate_RemoveMenuItemOnDataGrid_table',1),
(340,'2024_04_05_020th_migrate_removePlayplistType_table',1),
(341,'2024_04_05_080th_migrate_remove_deleted_point_statistics_table',1),
(342,'2024_04_08_070th_migrate_CustomFieldVisibleRoleData_table',1),
(343,'2024_04_08_090th_migrate_TranslationTables_table',1),
(344,'2024_04_15_100th_migrate_deleteMenuItemAddCategory_table',1),
(345,'2024_04_19_030th_migrate_deleteMenuItemGroup_table',1),
(346,'2024_04_23_020rd_migrate_update_integrated_menu_item_label_table',1),
(347,'2024_04_24_040th_migrate_change_report_label_table',1),
(348,'2024_05_06_100th_migrate_support_soft_delete_for_storage_files_table',1),
(349,'2024_05_07_020th_migrate_activity_schedule_time_column',1),
(350,'2024_05_14_020th_migrate_add_history_tag_data_table_table',1),
(351,'2024_05_14_050th_migrate_updateSettingMinimumWithdraw_table',1),
(352,'2024_05_14_070th_migrate_update_video_bridge_service',1),
(353,'2024_05_17_020th_migrate_is_free_featured_item_column_table',1),
(354,'2024_05_17_030th_migrate_remove_missing_phrase_menu_on_admin_top_table',1),
(355,'2024_05_21_080st_migrate_migrate_is_approved_album_item_table',1),
(356,'2024_06_04_030th_migrate_migrate_allow_configurable_table',1),
(357,'2024_06_04_030th_migrate_migrate_gateway_table',1),
(358,'2024_06_06_070th_migrate_addColumnIsSystemInTableSection_table',1),
(359,'2024_06_07_070th_migrate_remove_add_new_menu_activity_point_table',1),
(360,'2024_06_07_070th_migrate_remove_add_new_menu_attachment_table',1),
(361,'2024_06_07_070th_migrate_remove_add_new_menu_authorization_table',1),
(362,'2024_06_07_070th_migrate_remove_add_new_menu_featured_table',1),
(363,'2024_06_07_070th_migrate_remove_add_new_menu_group_table',1),
(364,'2024_06_07_070th_migrate_remove_add_new_menu_layout_table',1),
(365,'2024_06_07_070th_migrate_remove_add_new_menu_localize_table',1),
(366,'2024_06_07_070th_migrate_remove_add_new_menu_mobile_table',1),
(367,'2024_06_07_070th_migrate_remove_add_new_menu_newsletter_table',1),
(368,'2024_06_07_070th_migrate_remove_add_new_menu_report_table',1),
(369,'2024_06_07_070th_migrate_remove_add_new_menu_static_page_table',1),
(370,'2024_06_07_070th_migrate_remove_add_new_menu_sticker_table',1),
(371,'2024_06_07_070th_migrate_remove_add_new_menu_storage_table',1),
(372,'2024_06_07_070th_migrate_remove_add_new_menu_user_table',1),
(373,'2024_06_07_070th_migrate_remove_add_new_menu_word_table',1),
(374,'2024_06_10_040th_migrate_deletePendingRequest_table',1),
(375,'2024_06_12_090th_migrate_delete_notification_types_unusing_table',1),
(376,'2024_06_14_020th_migrate_add_search_name_to_users_table',1),
(377,'2024_06_17_070th_migrate_group_udpate_ordering_menu_setting_table',1),
(378,'2024_06_17_070th_migrate_update_missing_default_text_for_translatable_group_table',1),
(379,'2024_06_21_060st_migrate_change_more_menu_table',1),
(380,'2024_06_24_100th_migrate_update_value_setting_sort_default_table',1),
(381,'2024_06_26_020th_migrate_support_for_invite_only_mode_table',1),
(382,'2024_06_26_020th_migrate_update_section_id_for_field_seeder_table',1),
(383,'2024_06_28_070th_migrate_add_column_require_module_id_table_notification_type_table',1),
(384,'2024_07_01_070st_migrate_delete_notification_types_unusing_table',1),
(385,'2024_07_15_100th_migrate_update_video_settings_menu_table',1),
(386,'2024_07_26_040th_migrate_remove_unused_menu_items_table',1),
(387,'2024_07_29_29th_remove_link_permission',1),
(388,'2024_08_06_020th_migrate_addCollumnResolutionInTableMFAToken_table',1),
(389,'2024_08_06_090th_migrate_updateLenghtPhoneNumber_table',1),
(390,'2024_08_08_010th_migrate_addUserInactiveProcess_table',1),
(391,'2024_08_08_050th_migrate_mfa_enforce_requests',1),
(392,'2024_08_12_070rd_migrate_addTotalColumnUser_table',1),
(393,'2024_08_13_040th_migrate_add_stats_content_type_table_table',1),
(394,'2024_08_13_120th_migrate_support_text_newsletter_text_table',1),
(395,'2024_08_14_070th_migrate_group_activity_logs_table',1),
(396,'2024_08_21_030th_migrate_update_label_menu_privacy_mobile_table',1),
(397,'2024_08_23_070rd_migrate_update_mail_site_setting_config_table',1),
(398,'2024_08_26_090th_migrate_add_actor_type_column_table',1),
(399,'2024_08_27_070th_migrate_remove_menu_item_table',1),
(400,'2024_08_29_030th_migrate_remove_keyword_description_phrase_for_site_setting_table',1),
(401,'2024_08_30_020th_migrate_add_timestamps_in_options_table',1),
(402,'2024_08_30_040th_migrate_update_importer_entries_table',1),
(403,'2024_09_024_070th_migrate_add_column_report_table',1),
(404,'2024_09_04_070th_migrate_update_status_group_invites_has_duplicate_table',1),
(405,'2024_09_05_090th_migrate_update_photo_statistic_table',1),
(406,'2024_09_12_020th_migrate_add_external_link_column_for_listing_table',1),
(407,'2024_09_13_090th_migrate_addColumnTabToIntegrated_table',1),
(408,'2024_09_17_030th_migrate_add_canonical_url_seo_meta_table',1),
(409,'2024_09_20_020th_migrate_support_meta_no_index_table',1),
(410,'2024_10_18_020th_migrate_core_update_phrase_text_table',1),
(411,'2024_10_22_040th_migrate_update_name_states_table',1),
(412,'2024_27_3_29th_add_maximum_number_of_media_per_upload_for_supper_admin_permission',1),
(413,'2024_29_5_29th_remove_activity_permission',1),
(414,'2021_02_03_151921_CreateEventTable',2),
(415,'2022_05_25_171921_CreateHostInviteTable',2),
(416,'2022_11_01_090st_migrate_AddColumnExpiredAt_table',2),
(417,'2022_11_30_080th_migrate_AddColumnLevelToEventCategoryTable_table',2),
(418,'2022_12_27_130th_migrate_support_soft_delete_event_table',2),
(419,'2023_02_13_050th_migrate_UserMassEmailEvent_table',2),
(420,'2023_02_23_070rd_migrate_AddColumnExpiredAtToInviteHostsTable_table',2),
(421,'2023_03_10_070th_migrate_UpdateMenuItemOnEvent_table',2),
(422,'2023_03_17_030th_migrate_event_tag_data_table',2),
(423,'2023_04_12_020th_migrate_updateOderingItemMenuForEvent_table',2),
(424,'2023_04_27_030th_migrate_delete_all_events_do_not_have_owner_table',2),
(425,'2023_05_05_070th_migrate_support_event_category_soft_delete_table',2),
(426,'2023_07_10_070th_migrate_sponsor_settings_table',2),
(427,'2023_07_28_070th_remove_event_no_image_asset',2),
(428,'2023_08_11_080th_migrate_total_host_table',2),
(429,'2023_08_11_080th_migrate_total_table',2),
(430,'2023_10_17_090th_migrate_add_column_image_position_table',2),
(431,'2023_11_24_070th_migrate_CategoryRelation_table',2),
(432,'2023_12_14_050th_migrate_updateProfileMenuItemEvent_table',2),
(433,'2024_03_28_070th_migrate_event_category_relations_table',2),
(434,'2024_04_12_090th_migrate_addColumnLastMassInviteTableEvents_table',2),
(435,'2024_08_16_030th_migrate_updateMenuItemInterestedMenu_table',2),
(436,'2021_02_04_034515_CreatePollTables',3),
(437,'2023_05_22_040nd_migrate_poll_tag_data_table_table',3),
(438,'2023_07_06_040nd_add_pending_tagged_friends_poll_table',3),
(439,'2023_07_13_020th_migrate_delete_menu_item_table',3),
(440,'2023_07_28_070th_remove_poll_no_image_asset',3),
(441,'2023_08_29_010st_migrate_poll_table',3),
(442,'2023_10_16_030th_migrate_add_last_result_column',3),
(443,'2023_10_25_200th_migrate_change_type_column_table_poll_table',3),
(444,'2023_12_14_050th_migrate_updateProfileMenuItemPoll_table',3),
(445,'2022_03_11_064117_CreateForumTables',4),
(446,'2023_02_08_040th_migrate_forums_table',4),
(447,'2023_02_21_040st_migrate_forums_table',4),
(448,'2023_03_02_100nd_migrate_moderators_table',4),
(449,'2023_03_10_070th_migrate_forums_table',4),
(450,'2023_03_13_070th_migrate_UpdateMenuItemForumOnGroup_table',4),
(451,'2023_03_13_080th_migrate_forum_post_quotes_table',4),
(452,'2023_03_20_080th_migrate_forum_threads_table',4),
(453,'2023_04_14_030th_migrate_updateMenuItemDetailOfSaved_table',4),
(454,'2023_04_20_070th_migrate_DeleteMenuItem_table',4),
(455,'2023_05_25_040th_migrate_update_app_main_icon_table',4),
(456,'2023_07_12_030th_migrate_sponsor_settings_table',4),
(457,'2023_10_04_070th_migrate_remove_incorrect_forum_description_seeder_table',4),
(458,'2023_12_04_060th_migrate_create_new_thread_menu_table',4),
(459,'2023_12_11_040th_migrate_migrate_quote_forum_post_table',4),
(460,'2023_12_14_050th_migrate_updateProfileMenuItemForum_table',4),
(461,'2024_06_07_070th_migrate_remove_add_new_menu_forum_table',4),
(462,'2024_06_26_040th_migrate_migrate_forum_moderator_has_permission_table',4),
(463,'2021_02_03_095727_InitVideoTables',5),
(464,'2022_11_30_080th_migrate_AddColumnLevelToVideoCategoryTable_table',5),
(465,'2023_03_13_070th_migrate_support_thumbnail_url_column_table',5),
(466,'2023_04_14_032th_migrate_core_menu_items_table',5),
(467,'2023_05_05_070th_migrate_support_video_category_soft_delete_table',5),
(468,'2023_05_16_050th_update_add_video_menu_items_in_group',5),
(469,'2023_05_24_060th_migrate_update_header_menu_item_action_on_owner_table',5),
(470,'2023_06_12_040th_migrate_add_processing_video_data_column_table',5),
(471,'2023_06_26_010th_migrate_update_video_feed_composer_menu_table',5),
(472,'2023_06_26_050th_update_label_add_new_video_menu_items_in_group',5),
(473,'2023_07_14_090th_migrate_sponsor_settings_table',5),
(474,'2023_08_18_110th_migrate_video_table',5),
(475,'2023_11_24_080th_migrate_VideoCategoryRelation_table',5),
(476,'2023_12_01_080st_migrate_dropTableVideoServices_table',5),
(477,'2023_12_22_030nd_migrate_updateSettingVideoService_table',5),
(478,'2024_01_23_090rd_migrate_update_incorrect_video_of_page_status_table',5),
(479,'2024_03_28_080th_migrate_video_category_relations_table',5),
(480,'2024_04_03_100rd_migrate_updateVideoStatistic_table',5),
(481,'2024_04_05_030th_migrate_removeAdMobInDetailPage_table',5),
(482,'2024_05_09_070th_migrate_updatePhotoAlbumTotalItem_table',5),
(483,'2024_09_05_070th_migrate_update_video_statistic_table',5),
(484,'2024_10_08_080th_migrate_update_video_title_to_remove_untitle_video_table',5),
(485,'2022_06_30_030th_migrate_subscription_table',6),
(486,'2022_10_11_070th_migrate_fix_missing_image_file_id_field_table',6),
(487,'2023_04_06_020th_migrate_subscription_menu_table',6),
(488,'2023_04_20_080th_migrate_update-packages-menu-icon_table',6),
(489,'2023_05_08_030th_migrate_subscription_admincp_menus_table',6),
(490,'2023_05_24_080th_migrate_subscription_mobile_menu_table',6),
(491,'2023_05_25_060th_migrate_update-sidebar-menu-ordering-icon_table',6),
(492,'2023_25_4_29th_remove_subscription_permission',6),
(493,'2024_06_07_070th_migrate_remove_add_new_menu_subscription_table',6),
(494,'2024_08_28_070th_migrate_add_column_ordering_subscription_comparisons_table',6),
(495,'2021_02_03_100345_InitPageTables',6),
(496,'2022_11_30_080th_migrate_AddColumnLevelToPageCategoryTable_table',6),
(497,'2022_12_01_080st_migrate_AddColumnInviteTypeToPageInvite_table',6),
(498,'2022_12_27_130th_migrate_support_soft_delete_page_table',6),
(499,'2023_04_20_040th_migrate_migrate_update_page_sidebar_menu_items_table',6),
(500,'2023_05_05_070th_migrate_support_page_category_soft_delete_table',6),
(501,'2023_05_23_090rd_migrate_page_integrated_modules_table',6),
(502,'2023_05_26_100th_migrate_updateMenuItem_table',6),
(503,'2023_05_31_030st_migrate_updateOrderingMenuItem_table',6),
(504,'2023_06_02_100nd_migrate_page_notifications_table',6),
(505,'2023_06_08_090th_migrate_addColumnTabToIntegrated_table',6),
(506,'2023_07_14_060th_migrate_sponsor_settings_table',6),
(507,'2023_07_17_080th_migrate_update_value_menu_item_table',6),
(508,'2023_07_19_090th_migrate_remove_page_driver_table',6),
(509,'2023_08_01_070st_migrate_update_to_menu_item_table',6),
(510,'2023_08_13_100th_migrate_total_table',6),
(511,'2023_08_30_030th_migrate_clean_up_cover_avatar_id_table',6),
(512,'2023_10_12_070st_migrate_update_invite_friend_icon_menu_item_table',6),
(513,'2023_10_17_040th_migrate_PageHistories_table',6),
(514,'2023_11_24_030th_migrate_CategoryRelation_table',6),
(515,'2023_11_28_080th_migrate_removeSidebarSearchInPageMenu_table',6),
(516,'2023_12_13_070th_migrate_updateProfileMenuItemPage_table',6),
(517,'2024_03_28_080th_migrate_page_category_relations_table',6),
(518,'2024_04_04_040th_migrate_update_page_setting_menu_table',6),
(519,'2024_04_19_030th_migrate_deleteMenuItemPage_table',6),
(520,'2024_04_23_020rd_migrate_update_integrated_module_label_table',6),
(521,'2024_06_17_070th_migrate_page_update_ordering_menu_item_table',6),
(522,'2024_09_12_070rd_migrate_addTotalColumnPage_table',6),
(523,'2021_02_04_044706_CreateSavedTables',7),
(524,'2023_01_10_100th_migrate_saved_search_items_table',7),
(525,'2023_01_13_040th_migrate_saved_list_friend_table',7),
(526,'2023_02_03_030rd_migrate_AddCollectionPrivacy_table',7),
(527,'2023_02_24_090th_migrate_SavedListItemViews_table',7),
(528,'2023_03_22_090nd_migrate_UpdateMenuItem_table',7),
(529,'2023_03_24_090th_migrate_updateOderingItemMenu_table',7),
(530,'2023_04_05_020th_migrate_saved_list_friend_improve_table',7),
(531,'2023_04_18_100th_update_menu_saved_item',7),
(532,'2023_04_20_080th_migrate_update-saved-app-menu-icon_table',7),
(533,'2023_05_10_030th_migrate_update_saved_added_item_table',7),
(534,'2023_06_05_040th_migrate_update_saved_list_member_user_table',7),
(535,'2023_07_06_100th_update_menu_saved_item_collection',7),
(536,'2021_02_03_105548_CreateAnnouncementTables',8),
(537,'2022_09_05_080th_migrate_update_announcement_user_group_column',8),
(538,'2022_12_12_080th_migrate_update_announcement_total_column',8),
(539,'2023_05_22_060nd_migrate_CreateAnnouncementCloseTable_table',8),
(540,'2023_07_06_100th_migrate_support_announcement_style_name_label_table',8),
(541,'2023_07_06_100th_migrate_update_announcement_style_name_var',8),
(542,'2023_07_13_070th_migrate_announcements_table',8),
(543,'2023_10_31_020st_migrate_add_new_announcement_content_model_table',8),
(544,'2023_10_31_030st_migrate_migrating_old_text_to_new_content_table',8),
(545,'2024_05_22_090nd_migrate_addTableCountriesAndRenders_table',8),
(546,'2024_06_07_070th_migrate_remove_add_new_menu_announcement_table',8),
(547,'2023_02_14_030th_migrate_advertises_table',9),
(548,'2023_03_24_030th_migrate_advertise_invoices_table',9),
(549,'2023_05_05_100th_migrate_advertise_sponsors_table',9),
(550,'2023_06_28_030th_migrate_update_label_menu_item_table',9),
(551,'2023_07_26_040th_migrate_advertise_remove_deprecated_permissions_table',9),
(552,'2023_08_24_030th_migrate_update_label_menu_item_table',9),
(553,'2024_06_07_070th_migrate_remove_add_new_menu_advertise_table',9),
(554,'2021_02_03_065905_InitCommentTables',9),
(555,'2022_08_31_080st_migrate_AddColumnTaggedUserIds_table',9),
(556,'2022_09_12_010th_migrate_comment_histories_table',9),
(557,'2022_09_30_100th_migrate_UpdateFieldItemType_table',9),
(558,'2023_08_05_100th_migrate_add_is_edited_table',9),
(559,'2023_08_11_040th_migrate_total_table',9),
(560,'2023_08_28_070th_migrate__table',9),
(561,'2024_05_14_040th_migrate_add_comment_history_tag_data_table',9),
(562,'2023_02_06_100th_migrate_livestreaming_live_videos_table',10),
(563,'2023_04_20_080th_migrate_update-all-video-menu-icon_table',10),
(564,'2023_04_24_050th_migrate_update_action_menu_item_table',10),
(565,'2023_05_25_090th_migrate_migrate_update_live_video_duration_table',10),
(566,'2023_06_1_090th_migrate_migrate_update_live_video_table',10),
(567,'2023_06_30_090th_migrate_update_menu_item_live_video_table',10),
(568,'2023_07_05_020th_migrate_update_playback_data_table_table',10),
(569,'2023_07_14_090th_migrate_sponsor_settings_table_table',10),
(570,'2023_08_18_110th_migrate_live_video_table',10),
(571,'2023_08_30_060th_migrate_update_admod_path_table',10),
(572,'2023_09_11_050th_migrate_update_admob_livestream_detail_table',10),
(573,'2023_11_29_100th_migrate_update_live_video_integrate_table',10),
(574,'2021_02_03_073927_migrate_likes_table',11),
(575,'2021_09_21_050st_migrate_like_reactions_table',11),
(576,'2022_09_21_050st_migrate_like_aggregations_table',11),
(577,'2022_09_21_051st_migrate_reaction_increament_table',11),
(578,'2024_03_11_070th_migrate_updateIsDefaultReaction_table',11),
(579,'2024_03_15_090th_migrate_addColumnIconFontTableReaction_table',11),
(580,'2023_07_19_060th_migrate_payment_processor_table',12),
(581,'2023_09_28_010th_migrate_CreateStoryTable_table',12),
(582,'2023_11_14_030th_migrate_update_accountMenu_table',12),
(583,'2023_12_05_030th_migrate_update_story_table_table',12),
(584,'2023_12_12_070th_migrate_updateLabelMenuItem_table',12),
(585,'2023_12_27_080th_migrate_addColumnTableStories_table',12),
(586,'2023_12_29_030th_migrate_addColumnDestinationTableStories_table',12),
(587,'2024_03_19_090th_migrate_deleteMenuItem_table',12),
(588,'2024_08_12_090th_migrate_updateLabelMenuItem_table',12),
(589,'2024_08_13_010th_migrate_story_mute_table',12),
(590,'2024_08_27_070th_migrate_update_ordering_menu_item_table',13),
(591,'2024_11_06_080th_migrate_show_map_on_feed_table',13),
(592,'2024_11_12_070th_migrate_page_activity_logs_table',13),
(593,'2024_11_15_090th_migrate_add_index_and_unique_for_user_ban_rules_table',13),
(594,'2024_11_19_020th_migrate_support_meta_structed_schema_table',13),
(595,'2024_11_29_020th_migrate_core_update_menu_name_table',13),
(596,'2024_12_10_090th_migrate_addColumnReviewerToRequest_table',13),
(597,'2024_12_19_070th_migrate_updateNotification_table',13);
CREATE TABLE `newsletter_country_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `newsletter_id` bigint(20) unsigned NOT NULL,
  `country_iso` char(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `newsletter_country_data_newsletter_id_index` (`newsletter_id`),
  KEY `newsletter_country_data_country_iso_index` (`country_iso`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `newsletter_gender_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `newsletter_id` bigint(20) unsigned NOT NULL,
  `gender_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `newsletter_gender_data_newsletter_id_index` (`newsletter_id`),
  KEY `newsletter_gender_data_gender_id_index` (`gender_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `newsletter_role_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `newsletter_id` bigint(20) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `newsletter_role_data_newsletter_id_index` (`newsletter_id`),
  KEY `newsletter_role_data_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `newsletter_text` (
  `id` bigint(20) unsigned NOT NULL,
  `text_html` mediumtext DEFAULT NULL,
  `text` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `newsletters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `age_from` int(11) DEFAULT NULL,
  `age_to` int(11) DEFAULT NULL,
  `round` int(11) NOT NULL DEFAULT 5,
  `status` int(11) NOT NULL DEFAULT 0,
  `archive` tinyint(4) NOT NULL DEFAULT 0,
  `override_privacy` tinyint(4) NOT NULL DEFAULT 0,
  `total_sent` int(11) NOT NULL DEFAULT 0,
  `total_users` int(11) NOT NULL DEFAULT 0,
  `last_sent_id` bigint(20) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `channels` varchar(255) NOT NULL DEFAULT '{"mail":1}',
  PRIMARY KEY (`id`),
  KEY `newsletters_user_id_index` (`user_id`),
  KEY `ix_newsletters_user_morph` (`user_id`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `notification_channels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `is_system` int(10) unsigned NOT NULL DEFAULT 0,
  `is_active` int(10) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notification_channels_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `notification_channels` VALUES
(1,'database','In-App',1,1),
(2,'mail','Email',1,1),
(3,'sms','SMS',1,1),
(4,'webpush','WebPush',1,1),
(5,'mobilepush','MobilePush',1,1);
CREATE TABLE `notification_module_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `user_value` mediumtext DEFAULT NULL,
  `module_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `notification_module_settings_user_id_index` (`user_id`),
  KEY `ix_notification_module_settings_user_morph` (`user_id`,`user_type`),
  KEY `notification_module_settings_module_id_index` (`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `notification_modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `module_id` varchar(500) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `is_active` int(10) unsigned NOT NULL DEFAULT 1,
  `channel` varchar(255) NOT NULL DEFAULT 'database',
  `ordering` int(10) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_modules_module_id_index` (`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `notification_modules` VALUES
(1,'follow','follow::phrase.follow_notification_type',1,'database',1,'2024-11-30 12:58:53','2024-11-30 12:58:53'),
(2,'follow','follow::phrase.follow_notification_type',1,'mail',1,'2024-11-30 12:58:53','2024-11-30 12:58:53'),
(3,'follow','follow::phrase.follow_notification_type',1,'mobilepush',1,'2024-11-30 12:58:53','2024-11-30 12:58:53'),
(4,'follow','follow::phrase.follow_notification_type',1,'webpush',1,'2024-11-30 12:58:53','2024-11-30 12:58:53'),
(5,'user','user::phrase.user_notification_type',1,'mail',1,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(6,'user','user::phrase.user_notification_type',1,'database',1,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(7,'user','user::phrase.user_notification_type',1,'mobilepush',1,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(8,'user','user::phrase.user_notification_type',1,'webpush',1,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(9,'mfa','mfa::phrase.mfa_notification_type',1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(10,'mfa','mfa::phrase.mfa_notification_type',1,'sms',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(11,'ewallet','ewallet::phrase.ewallet_notification_type',1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(12,'ewallet','ewallet::phrase.ewallet_notification_type',1,'database',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(13,'ewallet','ewallet::phrase.ewallet_notification_type',1,'mobilepush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(14,'ewallet','ewallet::phrase.ewallet_notification_type',1,'webpush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(15,'featured','featured::phrase.featured_notification_type',1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(16,'featured','featured::phrase.featured_notification_type',1,'database',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(17,'featured','featured::phrase.featured_notification_type',1,'mobilepush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(18,'featured','featured::phrase.featured_notification_type',1,'webpush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(19,'friend','friend::phrase.friend_notification_type',1,'database',1,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(20,'friend','friend::phrase.friend_notification_type',1,'mail',1,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(21,'friend','friend::phrase.friend_notification_type',1,'mobilepush',1,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(22,'friend','friend::phrase.friend_notification_type',1,'webpush',1,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(23,'photo','photo::phrase.photo_notification_type',1,'database',1,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(24,'photo','photo::phrase.photo_notification_type',1,'mail',1,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(25,'photo','photo::phrase.photo_notification_type',1,'mobilepush',1,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(26,'photo','photo::phrase.photo_notification_type',1,'webpush',1,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(27,'report','report::phrase.report_notification_type',1,'mail',1,'2024-11-30 12:58:59','2024-11-30 12:58:59'),
(28,'activitypoint','activitypoint::phrase.activitypoint_notification_type',1,'database',1,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(29,'activitypoint','activitypoint::phrase.activitypoint_notification_type',1,'mail',1,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(30,'activitypoint','activitypoint::phrase.activitypoint_notification_type',1,'mobilepush',1,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(31,'activitypoint','activitypoint::phrase.activitypoint_notification_type',1,'webpush',1,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(32,'activity','activity::phrase.activity_notification_type',1,'database',1,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(33,'activity','activity::phrase.activity_notification_type',1,'mail',1,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(34,'activity','activity::phrase.activity_notification_type',1,'mobilepush',1,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(35,'activity','activity::phrase.activity_notification_type',1,'webpush',1,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(36,'group','group::phrase.group_notification_type',1,'database',1,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(37,'group','group::phrase.group_notification_type',1,'mail',1,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(38,'group','group::phrase.group_notification_type',1,'mobilepush',1,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(39,'group','group::phrase.group_notification_type',1,'webpush',1,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(40,'marketplace','marketplace::phrase.marketplace_notification_type',1,'database',1,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(41,'marketplace','marketplace::phrase.marketplace_notification_type',1,'mail',1,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(42,'marketplace','marketplace::phrase.marketplace_notification_type',1,'mobilepush',1,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(43,'marketplace','marketplace::phrase.marketplace_notification_type',1,'webpush',1,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(44,'newsletter','newsletter::phrase.newsletter_notification_type',1,'mail',1,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(45,'quiz','quiz::phrase.quiz_notification_type',1,'mail',1,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(46,'quiz','quiz::phrase.quiz_notification_type',1,'database',1,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(47,'quiz','quiz::phrase.quiz_notification_type',1,'mobilepush',1,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(48,'quiz','quiz::phrase.quiz_notification_type',1,'webpush',1,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(49,'event','event::phrase.event_notification_type',1,'database',1,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(50,'event','event::phrase.event_notification_type',1,'mail',1,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(51,'event','event::phrase.event_notification_type',1,'mobilepush',1,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(52,'event','event::phrase.event_notification_type',1,'webpush',1,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(53,'poll','poll::phrase.poll_notification_type',1,'mail',1,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(54,'poll','poll::phrase.poll_notification_type',1,'database',1,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(55,'poll','poll::phrase.poll_notification_type',1,'mobilepush',1,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(56,'poll','poll::phrase.poll_notification_type',1,'webpush',1,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(57,'forum','forum::phrase.forum_notification_type',1,'database',1,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(58,'forum','forum::phrase.forum_notification_type',1,'mail',1,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(59,'forum','forum::phrase.forum_notification_type',1,'mobilepush',1,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(60,'forum','forum::phrase.forum_notification_type',1,'webpush',1,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(61,'video','video::phrase.video_notification_type',1,'database',1,'2024-11-30 17:33:28','2024-11-30 17:33:28'),
(62,'video','video::phrase.video_notification_type',1,'mail',1,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(63,'video','video::phrase.video_notification_type',1,'mobilepush',1,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(64,'video','video::phrase.video_notification_type',1,'webpush',1,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(65,'subscription','subscription::phrase.subscription_notification_type',1,'database',1,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(66,'subscription','subscription::phrase.subscription_notification_type',1,'mail',1,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(67,'subscription','subscription::phrase.subscription_notification_type',1,'mobilepush',1,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(68,'subscription','subscription::phrase.subscription_notification_type',1,'webpush',1,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(69,'page','page::phrase.page_notification_type',1,'database',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(70,'page','page::phrase.page_notification_type',1,'mail',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(71,'page','page::phrase.page_notification_type',1,'mobilepush',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(72,'page','page::phrase.page_notification_type',1,'webpush',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(73,'saved','saved::phrase.saved_notification_type',1,'database',1,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(74,'saved','saved::phrase.saved_notification_type',1,'mail',1,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(75,'saved','saved::phrase.saved_notification_type',1,'mobilepush',1,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(76,'saved','saved::phrase.saved_notification_type',1,'webpush',1,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(77,'advertise','advertise::phrase.advertise_notification_type',1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(78,'advertise','advertise::phrase.advertise_notification_type',1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(79,'advertise','advertise::phrase.advertise_notification_type',1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(80,'advertise','advertise::phrase.advertise_notification_type',1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(81,'comment','comment::phrase.comment_notification_type',1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(82,'comment','comment::phrase.comment_notification_type',1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(83,'comment','comment::phrase.comment_notification_type',1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(84,'comment','comment::phrase.comment_notification_type',1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(85,'livestreaming','livestreaming::phrase.livestreaming_notification_type',1,'database',1,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(86,'livestreaming','livestreaming::phrase.livestreaming_notification_type',1,'mail',1,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(87,'livestreaming','livestreaming::phrase.livestreaming_notification_type',1,'mobilepush',1,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(88,'livestreaming','livestreaming::phrase.livestreaming_notification_type',1,'webpush',1,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(89,'like','like::phrase.like_notification_type',1,'database',1,'2024-11-30 18:06:47','2024-11-30 18:06:47'),
(90,'like','like::phrase.like_notification_type',1,'mail',1,'2024-11-30 18:06:47','2024-11-30 18:06:47'),
(91,'like','like::phrase.like_notification_type',1,'mobilepush',1,'2024-11-30 18:06:47','2024-11-30 18:06:47'),
(92,'like','like::phrase.like_notification_type',1,'webpush',1,'2024-11-30 18:06:47','2024-11-30 18:06:47'),
(93,'story','story::phrase.story_notification_type',1,'mail',1,'2025-01-01 19:27:11','2025-01-01 19:27:11'),
(94,'story','story::phrase.story_notification_type',1,'database',1,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(95,'story','story::phrase.story_notification_type',1,'mobilepush',1,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(96,'story','story::phrase.story_notification_type',1,'webpush',1,'2025-01-01 19:27:12','2025-01-01 19:27:12');
CREATE TABLE `notification_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `type_id` int(10) unsigned NOT NULL,
  `channel` varchar(255) NOT NULL DEFAULT 'database',
  `user_value` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_settings_user_id_index` (`user_id`),
  KEY `ix_notification_settings_user_morph` (`user_id`,`user_type`),
  KEY `notification_settings_channel_index` (`channel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `notification_tokens` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `environment` varchar(255) NOT NULL DEFAULT 'production',
  `platform` varchar(100) NOT NULL DEFAULT 'ios',
  `token_source` varchar(100) NOT NULL DEFAULT 'firebase',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `notification_tokens_user_id_index` (`user_id`),
  KEY `ix_notification_tokens_user_morph` (`user_id`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `notification_type_channels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type_id` bigint(20) unsigned NOT NULL,
  `is_active` int(10) unsigned NOT NULL DEFAULT 1,
  `channel` varchar(255) NOT NULL DEFAULT 'database',
  `ordering` int(10) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notification_type_channels_type_id_channel_unique` (`type_id`,`channel`),
  KEY `notification_type_channels_type_id_index` (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=452 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `notification_type_channels` VALUES
(1,1,1,'database',8,'2024-11-30 12:58:53','2024-11-30 12:58:53'),
(2,1,1,'mail',8,'2024-11-30 12:58:53','2024-11-30 12:58:53'),
(3,1,1,'mobilepush',8,'2024-11-30 12:58:53','2024-11-30 12:58:53'),
(4,1,1,'webpush',8,'2024-11-30 12:58:53','2024-11-30 12:58:53'),
(5,2,1,'mail',20,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(6,3,1,'mail',21,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(7,4,1,'database',22,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(8,4,1,'mail',22,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(9,4,1,'mobilepush',22,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(10,4,1,'webpush',22,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(11,5,1,'database',23,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(12,5,1,'mail',23,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(13,5,1,'mobilepush',23,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(14,5,1,'webpush',23,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(15,6,1,'mail',24,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(16,7,1,'mail',26,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(17,8,1,'mail',27,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(18,9,1,'database',28,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(19,9,1,'mail',28,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(20,9,1,'mobilepush',28,'2024-11-30 12:58:54','2024-11-30 12:58:54'),
(21,9,1,'webpush',28,'2024-11-30 12:58:55','2024-11-30 12:58:55'),
(22,10,1,'mail',28,'2024-11-30 12:58:55','2024-11-30 12:58:55'),
(23,11,1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(24,11,1,'sms',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(25,12,1,'mail',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(26,12,1,'database',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(27,12,1,'mobilepush',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(28,12,1,'webpush',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(29,13,1,'mail',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(30,13,1,'database',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(31,13,1,'mobilepush',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(32,13,1,'webpush',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(33,14,1,'mail',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(34,14,1,'database',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(35,14,1,'mobilepush',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(36,14,1,'webpush',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(37,15,1,'mail',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(38,15,1,'database',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(39,15,1,'mobilepush',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(40,15,1,'webpush',10,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(41,16,1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(42,16,1,'database',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(43,16,1,'mobilepush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(44,16,1,'webpush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(45,17,1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(46,17,1,'database',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(47,17,1,'mobilepush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(48,17,1,'webpush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(49,18,1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(50,18,1,'database',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(51,18,1,'mobilepush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(52,18,1,'webpush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(53,19,1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(54,19,1,'database',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(55,19,1,'mobilepush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(56,19,1,'webpush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(57,20,1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(58,20,1,'database',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(59,20,1,'mobilepush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(60,20,1,'webpush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(61,21,1,'mail',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(62,21,1,'database',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(63,21,1,'mobilepush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(64,21,1,'webpush',1,'2024-11-30 12:58:56','2024-11-30 12:58:56'),
(65,22,1,'database',10,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(66,22,1,'mail',10,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(67,22,1,'mobilepush',10,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(68,22,1,'webpush',10,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(69,23,1,'mail',11,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(70,24,1,'database',12,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(71,24,1,'mail',12,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(72,24,1,'mobilepush',12,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(73,24,1,'webpush',12,'2024-11-30 12:58:57','2024-11-30 12:58:57'),
(74,25,1,'database',1,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(75,25,1,'mail',1,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(76,25,1,'mobilepush',1,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(77,25,1,'webpush',1,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(78,26,1,'mail',18,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(79,26,1,'database',18,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(80,26,1,'mobilepush',18,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(81,26,1,'webpush',18,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(82,27,1,'mail',18,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(83,27,1,'database',18,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(84,27,1,'mobilepush',18,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(85,27,1,'webpush',18,'2024-11-30 12:58:58','2024-11-30 12:58:58'),
(86,28,1,'mail',20,'2024-11-30 12:58:59','2024-11-30 12:58:59'),
(87,29,1,'database',1,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(88,29,1,'mail',1,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(89,29,1,'mobilepush',1,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(90,29,1,'webpush',1,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(91,30,1,'database',2,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(92,30,1,'mail',2,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(93,30,1,'mobilepush',2,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(94,30,1,'webpush',2,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(95,31,1,'database',3,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(96,31,1,'mail',3,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(97,31,1,'mobilepush',3,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(98,31,1,'webpush',3,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(99,32,1,'database',4,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(100,32,1,'mail',4,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(101,32,1,'mobilepush',4,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(102,32,1,'webpush',4,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(103,33,1,'mail',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(104,33,1,'database',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(105,33,1,'mobilepush',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(106,33,1,'webpush',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(107,34,1,'mail',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(108,34,1,'database',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(109,34,1,'mobilepush',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(110,34,1,'webpush',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(111,35,1,'mail',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(112,35,1,'database',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(113,35,1,'mobilepush',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(114,35,1,'webpush',10,'2024-11-30 12:59:02','2024-11-30 12:59:02'),
(115,36,1,'database',2,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(116,36,1,'mail',2,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(117,36,1,'mobilepush',2,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(118,36,1,'webpush',2,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(119,37,1,'database',2,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(120,37,1,'mail',2,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(121,37,1,'mobilepush',2,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(122,37,1,'webpush',2,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(123,38,1,'database',3,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(124,38,1,'mail',3,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(125,38,1,'mobilepush',3,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(126,38,1,'webpush',3,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(127,39,1,'database',7,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(128,39,1,'mail',7,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(129,39,1,'mobilepush',7,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(130,39,1,'webpush',7,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(131,40,1,'database',8,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(132,40,1,'mail',8,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(133,40,1,'mobilepush',8,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(134,40,1,'webpush',8,'2024-11-30 12:59:03','2024-11-30 12:59:03'),
(135,41,1,'database',1,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(136,41,1,'mail',1,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(137,41,1,'mobilepush',1,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(138,41,1,'webpush',1,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(139,42,1,'database',2,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(140,42,1,'mail',2,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(141,42,1,'mobilepush',2,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(142,42,1,'webpush',2,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(143,43,1,'database',3,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(144,43,1,'mail',3,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(145,43,1,'mobilepush',3,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(146,43,1,'webpush',3,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(147,44,1,'database',4,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(148,44,1,'mail',4,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(149,44,1,'mobilepush',4,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(150,44,1,'webpush',4,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(151,45,1,'database',5,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(152,45,1,'mail',5,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(153,45,1,'mobilepush',5,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(154,45,1,'webpush',5,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(155,46,1,'database',6,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(156,46,1,'mail',6,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(157,46,1,'mobilepush',6,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(158,46,1,'webpush',6,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(159,47,1,'database',7,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(160,47,1,'mail',7,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(161,47,1,'mobilepush',7,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(162,47,1,'webpush',7,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(163,48,1,'database',8,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(164,48,1,'mail',8,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(165,48,1,'mobilepush',8,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(166,48,1,'webpush',8,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(167,49,1,'mail',18,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(168,49,1,'database',18,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(169,49,1,'mobilepush',18,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(170,49,1,'webpush',18,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(171,50,1,'mail',19,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(172,50,1,'database',19,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(173,50,1,'mobilepush',19,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(174,50,1,'webpush',19,'2024-11-30 12:59:06','2024-11-30 12:59:06'),
(175,51,1,'database',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(176,51,1,'mail',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(177,51,1,'mobilepush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(178,51,1,'webpush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(179,52,1,'database',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(180,52,1,'mail',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(181,52,1,'mobilepush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(182,52,1,'webpush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(183,53,1,'database',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(184,53,1,'mail',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(185,53,1,'mobilepush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(186,53,1,'webpush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(187,54,1,'database',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(188,54,1,'mail',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(189,54,1,'mobilepush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(190,54,1,'webpush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(191,55,1,'database',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(192,55,1,'mail',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(193,55,1,'mobilepush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(194,55,1,'webpush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(195,56,1,'mail',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(196,57,1,'database',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(197,57,1,'mail',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(198,57,1,'mobilepush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(199,57,1,'webpush',14,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(200,58,1,'mail',1,'2024-11-30 12:59:07','2024-11-30 12:59:07'),
(201,59,1,'mail',19,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(202,59,1,'database',19,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(203,59,1,'mobilepush',19,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(204,59,1,'webpush',19,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(205,60,1,'mail',20,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(206,60,1,'database',20,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(207,60,1,'mobilepush',20,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(208,60,1,'webpush',20,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(209,61,1,'mail',21,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(210,61,1,'database',21,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(211,61,1,'mobilepush',21,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(212,61,1,'webpush',21,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(213,62,1,'mail',21,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(214,62,1,'database',21,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(215,62,1,'mobilepush',21,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(216,62,1,'webpush',21,'2024-11-30 12:59:08','2024-11-30 12:59:08'),
(217,63,1,'database',13,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(218,63,1,'mail',13,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(219,63,1,'mobilepush',13,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(220,63,1,'webpush',13,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(221,64,1,'database',14,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(222,64,1,'mail',14,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(223,64,1,'mobilepush',14,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(224,64,1,'webpush',14,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(225,65,1,'database',15,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(226,65,1,'mail',15,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(227,65,1,'mobilepush',15,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(228,65,1,'webpush',15,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(229,66,1,'database',16,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(230,66,1,'mail',16,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(231,66,1,'mobilepush',16,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(232,66,1,'webpush',16,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(233,67,1,'mail',19,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(234,67,1,'database',19,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(235,67,1,'mobilepush',19,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(236,67,1,'webpush',19,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(237,68,1,'mail',20,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(238,68,1,'database',20,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(239,68,1,'mobilepush',20,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(240,68,1,'webpush',20,'2024-11-30 17:26:55','2024-11-30 17:26:55'),
(241,69,1,'mail',17,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(242,69,1,'database',17,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(243,69,1,'mobilepush',17,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(244,69,1,'webpush',17,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(245,70,1,'mail',18,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(246,70,1,'database',18,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(247,70,1,'mobilepush',18,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(248,70,1,'webpush',18,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(249,71,1,'mail',18,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(250,71,1,'database',18,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(251,71,1,'mobilepush',18,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(252,71,1,'webpush',18,'2024-11-30 17:29:17','2024-11-30 17:29:17'),
(253,72,1,'database',1,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(254,72,1,'mail',1,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(255,72,1,'mobilepush',1,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(256,72,1,'webpush',1,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(257,73,1,'database',2,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(258,73,1,'mail',2,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(259,73,1,'mobilepush',2,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(260,73,1,'webpush',2,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(261,74,1,'database',3,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(262,74,1,'mail',3,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(263,74,1,'mobilepush',3,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(264,74,1,'webpush',3,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(265,75,1,'database',4,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(266,75,1,'mail',4,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(267,75,1,'mobilepush',4,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(268,75,1,'webpush',4,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(269,76,1,'database',5,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(270,76,1,'mail',5,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(271,76,1,'mobilepush',5,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(272,76,1,'webpush',5,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(273,77,1,'database',6,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(274,77,1,'mail',6,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(275,77,1,'mobilepush',6,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(276,77,1,'webpush',6,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(277,78,1,'database',7,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(278,78,1,'mail',7,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(279,78,1,'mobilepush',7,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(280,78,1,'webpush',7,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(281,79,1,'database',8,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(282,79,1,'mail',8,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(283,79,1,'mobilepush',8,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(284,79,1,'webpush',8,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(285,80,1,'database',9,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(286,80,1,'mail',9,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(287,80,1,'mobilepush',9,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(288,80,1,'webpush',9,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(289,81,1,'mail',20,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(290,81,1,'database',20,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(291,81,1,'mobilepush',20,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(292,81,1,'webpush',20,'2024-11-30 17:30:19','2024-11-30 17:30:19'),
(293,82,1,'database',1,'2024-11-30 17:33:28','2024-11-30 17:33:28'),
(294,82,1,'mail',1,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(295,82,1,'mobilepush',1,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(296,82,1,'webpush',1,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(297,83,1,'database',3,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(298,83,1,'mail',3,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(299,83,1,'mobilepush',3,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(300,83,1,'webpush',3,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(301,84,1,'mail',2,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(302,84,1,'database',2,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(303,84,1,'mobilepush',2,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(304,84,1,'webpush',2,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(305,85,1,'mail',2,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(306,85,1,'database',2,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(307,85,1,'mobilepush',2,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(308,85,1,'webpush',2,'2024-11-30 17:33:29','2024-11-30 17:33:29'),
(309,86,1,'database',1,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(310,86,1,'mail',1,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(311,86,1,'mobilepush',1,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(312,86,1,'webpush',1,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(313,87,1,'database',2,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(314,87,1,'mail',2,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(315,87,1,'mobilepush',2,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(316,87,1,'webpush',2,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(317,88,1,'database',3,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(318,88,1,'mail',3,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(319,88,1,'mobilepush',3,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(320,88,1,'webpush',3,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(321,89,1,'database',4,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(322,89,1,'mail',4,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(323,89,1,'mobilepush',4,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(324,89,1,'webpush',4,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(325,90,1,'database',5,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(326,90,1,'mail',5,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(327,90,1,'mobilepush',5,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(328,90,1,'webpush',5,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(329,91,1,'database',6,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(330,91,1,'mail',6,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(331,91,1,'mobilepush',6,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(332,91,1,'webpush',6,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(333,92,1,'database',7,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(334,92,1,'mail',7,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(335,92,1,'mobilepush',7,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(336,92,1,'webpush',7,'2024-11-30 17:33:44','2024-11-30 17:33:44'),
(337,93,1,'database',15,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(338,93,1,'mail',15,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(339,93,1,'mobilepush',15,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(340,93,1,'webpush',15,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(341,94,1,'database',16,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(342,94,1,'mail',16,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(343,94,1,'webpush',16,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(344,95,1,'database',17,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(345,95,1,'mail',17,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(346,95,1,'mobilepush',17,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(347,95,1,'webpush',17,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(348,96,1,'mail',18,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(349,96,1,'database',18,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(350,96,1,'mobilepush',18,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(351,96,1,'webpush',18,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(352,97,1,'mail',19,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(353,97,1,'database',19,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(354,97,1,'mobilepush',19,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(355,97,1,'webpush',19,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(356,98,1,'mail',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(357,98,1,'database',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(358,98,1,'mobilepush',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(359,98,1,'webpush',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(360,99,1,'mail',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(361,99,1,'database',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(362,99,1,'mobilepush',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(363,99,1,'webpush',1,'2024-11-30 17:33:47','2024-11-30 17:33:47'),
(364,100,1,'database',19,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(365,100,1,'mail',19,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(366,100,1,'mobilepush',19,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(367,100,1,'webpush',19,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(368,101,1,'database',20,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(369,101,1,'mail',20,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(370,101,1,'mobilepush',20,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(371,101,1,'webpush',20,'2024-11-30 17:35:50','2024-11-30 17:35:50'),
(372,102,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(373,102,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(374,102,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(375,102,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(376,103,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(377,103,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(378,103,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(379,103,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(380,104,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(381,104,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(382,104,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(383,104,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(384,105,1,'database',3,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(385,106,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(386,106,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(387,105,1,'mail',3,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(388,106,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(389,105,1,'mobilepush',3,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(390,106,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(391,105,1,'webpush',3,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(392,107,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(393,107,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(394,107,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(395,107,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(396,108,1,'mail',4,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(397,108,1,'database',4,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(398,109,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(399,108,1,'mobilepush',4,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(400,109,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(401,108,1,'webpush',4,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(402,109,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(403,109,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(404,110,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(405,110,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(406,110,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(407,110,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(408,111,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(409,111,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(410,111,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(411,111,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(412,112,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(413,112,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(414,112,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(415,112,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(416,113,1,'mail',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(417,113,1,'database',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(418,113,1,'mobilepush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(419,113,1,'webpush',1,'2024-11-30 17:47:41','2024-11-30 17:47:41'),
(420,114,1,'database',1,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(421,114,1,'mail',1,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(422,114,1,'mobilepush',1,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(423,114,1,'webpush',1,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(424,115,1,'mail',2,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(425,115,1,'database',2,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(426,115,1,'mobilepush',2,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(427,115,1,'webpush',2,'2024-11-30 17:47:45','2024-11-30 17:47:45'),
(428,116,1,'database',14,'2024-11-30 18:06:47','2024-11-30 18:06:47'),
(429,116,1,'mail',14,'2024-11-30 18:06:47','2024-11-30 18:06:47'),
(430,116,1,'mobilepush',14,'2024-11-30 18:06:47','2024-11-30 18:06:47'),
(431,116,1,'webpush',14,'2024-11-30 18:06:47','2024-11-30 18:06:47'),
(432,117,1,'mail',21,'2025-01-01 19:26:03','2025-01-01 19:26:03'),
(433,117,1,'database',21,'2025-01-01 19:26:03','2025-01-01 19:26:03'),
(434,117,1,'mobilepush',21,'2025-01-01 19:26:03','2025-01-01 19:26:03'),
(435,117,1,'webpush',21,'2025-01-01 19:26:03','2025-01-01 19:26:03'),
(436,118,1,'mail',17,'2025-01-01 19:27:11','2025-01-01 19:27:11'),
(437,118,1,'database',17,'2025-01-01 19:27:11','2025-01-01 19:27:11'),
(438,118,1,'mobilepush',17,'2025-01-01 19:27:11','2025-01-01 19:27:11'),
(439,118,1,'webpush',17,'2025-01-01 19:27:11','2025-01-01 19:27:11'),
(440,119,1,'mail',18,'2025-01-01 19:27:11','2025-01-01 19:27:11'),
(441,119,1,'database',18,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(442,119,1,'mobilepush',18,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(443,119,1,'webpush',18,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(444,120,1,'database',19,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(445,120,1,'mail',19,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(446,120,1,'mobilepush',19,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(447,120,1,'webpush',19,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(448,121,1,'database',19,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(449,121,1,'mail',19,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(450,121,1,'mobilepush',19,'2025-01-01 19:27:12','2025-01-01 19:27:12'),
(451,121,1,'webpush',19,'2025-01-01 19:27:12','2025-01-01 19:27:12');
CREATE TABLE `notification_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `handler` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `module_id` varchar(255) DEFAULT NULL,
  `package_id` varchar(255) DEFAULT NULL,
  `require_module_id` varchar(255) DEFAULT NULL,
  `channels` varchar(255) NOT NULL DEFAULT '[database]',
  `can_edit` int(10) unsigned NOT NULL DEFAULT 1,
  `is_request` int(10) unsigned NOT NULL DEFAULT 0,
  `is_active` int(10) unsigned NOT NULL DEFAULT 1,
  `is_system` int(10) unsigned NOT NULL DEFAULT 1,
  `ordering` int(10) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notification_types_type_unique` (`type`),
  KEY `notification_types_module_id_index` (`module_id`),
  KEY `notification_types_package_id_index` (`package_id`),
  KEY `notification_types_require_module_id_index` (`require_module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `notification_types` VALUES
(1,'post_link_follower_notification','MetaFox\\Core\\Notifications\\NewPostLinkToFollowerNotification','core::phrase.post_link_follower_notification_type','core',NULL,'follow','[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,8),
(2,'request_reset_password_token','MetaFox\\User\\Notifications\\ResetPasswordTokenNotification','user::phrase.new_password_requested_notification_type','user',NULL,NULL,'[\"mail\"]',0,0,1,1,20),
(3,'new_password_updated','MetaFox\\User\\Notifications\\DirectUpdatedPassword','user::phrase.new_password_updated_notification_type','user',NULL,NULL,'[\"mail\"]',0,0,1,1,21),
(4,'new_post_timeline','MetaFox\\User\\Notifications\\NewPostTimeline','user::phrase.new_post_timeline_notification_type','user',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,22),
(5,'profile_updated_by_admin','MetaFox\\User\\Notifications\\ProfileUpdatedByAdmin','user::phrase.profile_updated_by_admin_notification_type','user',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,23),
(6,'user_approve_notification','MetaFox\\User\\Notifications\\UserApproveNotification','user::phrase.user_approved_notification_type','user',NULL,NULL,'[\"mail\"]',0,0,1,1,24),
(7,'user_welcome','MetaFox\\User\\Notifications\\WelcomeNewMember','user::phrase.user_welcome_notification_type','user',NULL,NULL,'[\"mail\"]',0,0,1,1,26),
(8,'process_mailing_inactive_user','MetaFox\\User\\Notifications\\ProcessMailingInactiveUser','user::phrase.process_mailing_notification_type','user',NULL,NULL,'[\"mail\"]',0,0,1,1,27),
(9,'user_relation_with_user','MetaFox\\User\\Notifications\\UserRelationWithUserNotification','user::phrase.user_relation_with_user_notification_type','user',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,28),
(10,'user_pending_approval_notification','MetaFox\\User\\Notifications\\UserPendingApprovalNotification','user::mail.user_pending_approval_notification_type','user',NULL,NULL,'[\"mail\"]',0,0,1,1,28),
(11,'brute_force_notification','MetaFox\\Mfa\\Notifications\\BruteForceMfaNotification','mfa::phrase.mfa_failure_notification','mfa',NULL,NULL,'[\"mail\",\"sms\"]',0,0,1,1,1),
(12,'ewallet_approved_transaction_notification','MetaFox\\EMoney\\Notifications\\ApprovedTransactionNotification','ewallet::phrase.approved_balance_transaction_type','ewallet',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,10),
(13,'ewallet_pending_withdraw_request','MetaFox\\EMoney\\Notifications\\PendingWithdrawRequestNotification','ewallet::phrase.approve_the_withdrawal_request_notification','ewallet',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,10),
(14,'ewallet_denied_withdraw_request','MetaFox\\EMoney\\Notifications\\DeniedWithdrawRequestNotification','ewallet::phrase.denied_withdrawal_request_notification','ewallet',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,10),
(15,'ewallet_success_payment_withdraw_request','MetaFox\\EMoney\\Notifications\\SuccessPaymentRequestNotification','ewallet::phrase.withdrawal_request_success_payment_notification','ewallet',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,10),
(16,'featured_cancelled_item_for_deleted_content','MetaFox\\Featured\\Notifications\\CancelledFeaturedItemForDeletedContentNotification','featured::phrase.cancelled_featured_item_for_deleted_content_notification','featured',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(17,'featured_cancelled_item','MetaFox\\Featured\\Notifications\\CancelledFeaturedItemNotification','featured::phrase.cancelled_featured_item_notification','featured',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(18,'featured_cancelled_invoice','MetaFox\\Featured\\Notifications\\CancelledInvoiceNotification','featured::phrase.cancelled_invoice_notification','featured',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(19,'featured_ended_item','MetaFox\\Featured\\Notifications\\EndedFeaturedItemNotification','featured::phrase.ended_featured_item_notification','featured',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(20,'featured_marked_invoice_as_paid','MetaFox\\Featured\\Notifications\\MarkedInvoiceAsPaidNotification','featured::phrase.marked_invoice_as_paid_notification','featured',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(21,'featured_payment_success','MetaFox\\Featured\\Notifications\\SuccessPaymentNotification','featured::phrase.success_payment_notification','featured',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(22,'friend_accepted','MetaFox\\Friend\\Notifications\\FriendAccepted','friend::phrase.friend_accept_notification_type','friend',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,10),
(23,'friend_requested','MetaFox\\Friend\\Notifications\\FriendRequested','friend::phrase.friend_request_notification_type','friend',NULL,NULL,'[\"mail\"]',1,1,1,1,11),
(24,'friend_tag','MetaFox\\Friend\\Notifications\\FriendTag','friend::phrase.friend_tag_notification_type','friend',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,12),
(25,'done_processing_group_items','MetaFox\\Photo\\Notifications\\DoneProcessingGroupItemsNotification','photo::phrase.done_processing_group_items','photo',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(26,'photo_approve_notification','MetaFox\\Photo\\Notifications\\PhotoApproveNotification','photo::phrase.photo_approve_notification_type','photo',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,18),
(27,'photo_follower_notification','MetaFox\\Photo\\Notifications\\NewPhotoToFollowerNotification','photo::phrase.photo_follower_notification_type','photo',NULL,'follow','[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,18),
(28,'processed_report_item','MetaFox\\Report\\Notifications\\ProcessedReportItemNotification','report::phrase.processed_report_item_notification_type','report',NULL,NULL,'[\"mail\"]',1,0,1,1,20),
(29,'purchase_package_success','MetaFox\\ActivityPoint\\Notifications\\PurchasePackageSuccessNotification','activitypoint::phrase.purchase_package_success','activitypoint',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(30,'purchase_package_fail','MetaFox\\ActivityPoint\\Notifications\\PurchasePackageFailedNotification','activitypoint::phrase.purchase_package_fail_notification','activitypoint',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(31,'received_gifted_points','MetaFox\\ActivityPoint\\Notifications\\ReceivedGiftedPointsNotification','activitypoint::phrase.received_gifted_points','activitypoint',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,3),
(32,'adjust_points','MetaFox\\ActivityPoint\\Notifications\\AdjustPointsNotification','activitypoint::phrase.adjust_points','activitypoint',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,4),
(33,'activitypoint_pending_conversion_request_notification','MetaFox\\ActivityPoint\\Notifications\\PendingConversionRequestNotification','activitypoint::phrase.pending_conversion_request_notification','activitypoint',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,10),
(34,'activitypoint_denied_conversion_request_notification','MetaFox\\ActivityPoint\\Notifications\\DeniedConversionRequestNotification','activitypoint::phrase.denied_conversion_request_notification','activitypoint',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,10),
(35,'activitypoint_approved_conversion_request_notification','MetaFox\\ActivityPoint\\Notifications\\ApprovedConversionRequestNotification','activitypoint::phrase.approved_conversion_request_notification','activitypoint',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,10),
(36,'activity_feed_pending','MetaFox\\Activity\\Notifications\\PendingFeedNotification','activity::phrase.activity_feed_pending_notification_type','activity',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(37,'activity_feed_approved','MetaFox\\Activity\\Notifications\\ApproveFeedNotification','activity::phrase.activity_feed_approved_notification_type','activity',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(38,'activity_share_notification','MetaFox\\Activity\\Notifications\\ShareFeedNotification','activity::phrase.activity_share_notification_type','activity',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,3),
(39,'share_follower_notification','MetaFox\\Activity\\Notifications\\NewShareToFollowerNotification','activity::phrase.share_follower_notification_type','activity',NULL,'follow','[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,7),
(40,'post_follower_notification','MetaFox\\Activity\\Notifications\\NewPostToFollowerNotification','activity::phrase.post_follower_notification_type','activity',NULL,'follow','[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,8),
(41,'group_invite','MetaFox\\Group\\Notifications\\GroupInvite','group::phrase.group_invite_notification_type','group',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(42,'group_pending_request','MetaFox\\Group\\Notifications\\PendingRequestNotification','group::phrase.group_pending_request_notification_type','group',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(43,'add_group_moderator','MetaFox\\Group\\Notifications\\AddGroupModerator','group::phrase.group_add_moderator_notification_type','group',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,3),
(44,'add_group_admin','MetaFox\\Group\\Notifications\\AddGroupAdmin','group::phrase.group_add_admin_notification_type','group',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,4),
(45,'accept_request_member','MetaFox\\Group\\Notifications\\AcceptRequestNotification','group::phrase.group_accept_request_member_notification_type','group',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,5),
(46,'pending_privacy','MetaFox\\Group\\Notifications\\PendingPrivacyNotification','group::phrase.pending_privacy_group_notification_type','group',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,6),
(47,'success_change_privacy','MetaFox\\Group\\Notifications\\SuccessPrivacyNotification','group::phrase.success_privacy_group_notification_type','group',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,7),
(48,'approved_new_post','MetaFox\\Group\\Notifications\\ApproveNewPostNotification','group::phrase.approved_new_post_in_group_notification','group',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,8),
(49,'group_approve_notification','MetaFox\\Group\\Notifications\\GroupApproveNotification','group::phrase.approved_group_notification','group',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,18),
(50,'group_update_info','MetaFox\\Group\\Notifications\\UpdateInformationNotification','group::phrase.update_info_group_notification_type','group',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,19),
(51,'payment_pending_notification','MetaFox\\Marketplace\\Notifications\\PaymentPendingNotification','marketplace::phrase.payment_pending_notification','marketplace',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,14),
(52,'payment_success_notification','MetaFox\\Marketplace\\Notifications\\PaymentSuccessNotification','marketplace::phrase.payment_success_notification','marketplace',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,14),
(53,'owner_payment_success_notification','MetaFox\\Marketplace\\Notifications\\OwnerPaymentSuccessNotification','marketplace::phrase.owner_payment_success_notification','marketplace',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,14),
(54,'invite_notification','MetaFox\\Marketplace\\Notifications\\InviteNotification','marketplace::phrase.invite_notification','marketplace',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,14),
(55,'listing_approved_notification','MetaFox\\Marketplace\\Notifications\\ListingApprovedNotification','marketplace::phrase.listing_approved_notification','marketplace',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,14),
(56,'listing_expired_notification','MetaFox\\Marketplace\\Notifications\\ExpiredNotification','marketplace::phrase.listing_expired_notification','marketplace',NULL,NULL,'[\"mail\"]',1,0,1,1,14),
(57,'listing_follower_notification','MetaFox\\Marketplace\\Notifications\\NewListingToFollowerNotification','marketplace::phrase.listing_follower_notification_type','marketplace',NULL,'follow','[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,14),
(58,'newsletter_notification','MetaFox\\Newsletter\\Notifications\\NewsletterNotification','newsletter::phrase.process_newsletter_notification_type','newsletter',NULL,NULL,'[\"mail\"]',1,0,1,1,1),
(59,'quiz_approve_notification','MetaFox\\Quiz\\Notifications\\QuizApproveNotifications','quiz::phrase.quiz_approve_notification_type','quiz',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,19),
(60,'quiz_result_submitted_notification','MetaFox\\Quiz\\Notifications\\SubmitResultNotifications','quiz::phrase.quiz_result_submitted_notification_type','quiz',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,20),
(61,'quiz_resubmit_notification','MetaFox\\Quiz\\Notifications\\QuizResubmitNotifications','quiz::phrase.quiz_resubmit_notification_type','quiz',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,21),
(62,'quiz_follower_notification','MetaFox\\Quiz\\Notifications\\NewQuizToFollowerNotification','quiz::phrase.quiz_follower_notification_type','quiz',NULL,'follow','[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,21),
(63,'event_invite','MetaFox\\Event\\Notifications\\Invite','event::phrase.event_invite_notification_type','event',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,13),
(64,'event_host_invite','MetaFox\\Event\\Notifications\\HostInvite','event::phrase.event_host_invite_notification_type','event',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,14),
(65,'new_event_discussion','MetaFox\\Event\\Notifications\\NewEventDiscussion','event::phrase.new_discussion_event_notification_type','event',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,15),
(66,'event_member','MetaFox\\Event\\Notifications\\EventRsvpNotification','event::phrase.event_rsvp_notification_type','event',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,16),
(67,'event_approve_notification','MetaFox\\Event\\Notifications\\EventApproveNotifications','event::phrase.event_approved_notification','event',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,19),
(68,'event_follower_notification','MetaFox\\Event\\Notifications\\NewEventToFollowerNotification','event::phrase.event_follower_notification_type','event',NULL,'follow','[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,20),
(69,'poll_notification','MetaFox\\Poll\\Notifications\\PollResultNotification','poll::phrase.poll_result_notification_type','poll',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,17),
(70,'poll_approve_notification','MetaFox\\Poll\\Notifications\\PollApproveNotification','poll::phrase.poll_approve_notification_type','poll',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,18),
(71,'poll_follower_notification','MetaFox\\Poll\\Notifications\\NewPollToFollowerNotification','poll::phrase.poll_follower_notification_type','poll',NULL,'follow','[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,18),
(72,'approved_post','MetaFox\\Forum\\Notifications\\ApprovedPost','forum::phrase.post_successfully_approved','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(73,'approved_thread','MetaFox\\Forum\\Notifications\\ApprovedThread','forum::phrase.thread_successfully_approved','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(74,'copy_thread','MetaFox\\Forum\\Notifications\\CopyThread','forum::phrase.thread_successfully_copied','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,3),
(75,'subscribed_thread','MetaFox\\Forum\\Notifications\\SubscribedThread','forum::phrase.subscribed_thread_notification','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,4),
(76,'admin_update_thread','MetaFox\\Forum\\Notifications\\AdminUpdateThread','forum::phrase.update_thread_notification','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,5),
(77,'create_post','MetaFox\\Forum\\Notifications\\CreatePost','forum::phrase.create_post_notification','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,6),
(78,'merge_thread','MetaFox\\Forum\\Notifications\\MergeThread','forum::phrase.merge_thread_notification','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,7),
(79,'display_wiki','MetaFox\\Forum\\Notifications\\DisplayWiki','forum::phrase.display_wiki_notification','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,8),
(80,'add_moderator','MetaFox\\Forum\\Notifications\\AddModerator','forum::phrase.add_moderator_notification','forum',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,9),
(81,'forum_thread_follower_notification','MetaFox\\Forum\\Notifications\\NewThreadToFollowerNotification','forum::phrase.forum_thread_follower_notification_type','forum',NULL,'follow','[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,20),
(82,'video_done_processing','MetaFox\\Video\\Notifications\\VideoDoneProcessingNotification','video::phrase.video_done_processing_type','video',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(83,'video_processed_failed','MetaFox\\Video\\Notifications\\VideoProcessedFailedNotification','video::phrase.video_processed_failed_type','video',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,3),
(84,'video_approve_notification','MetaFox\\Video\\Notifications\\VideoApproveNotification','video::phrase.video_approved_notification','video',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(85,'video_follower_notification','MetaFox\\Video\\Notifications\\NewVideoToFollowerNotification','video::phrase.video_follower_notification_type','video',NULL,'follow','[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(86,'subscription_completed_transaction','MetaFox\\Subscription\\Notifications\\CompletedTransaction','subscription::phrase.invoice_transaction','subscription',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(87,'subscription_manual_cancellation','MetaFox\\Subscription\\Notifications\\ManualSubscriptionCancellation','subscription::phrase.subscription_manual_cancellation','subscription',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(88,'subscription_system_cancellation','MetaFox\\Subscription\\Notifications\\SystemSubscriptionCancellation','subscription::phrase.subscription_system_cancellation','subscription',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,3),
(89,'subscription_pending_transaction','MetaFox\\Subscription\\Notifications\\PendingTransaction','subscription::phrase.pending_transaction','subscription',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,4),
(90,'subscription_expired_transaction','MetaFox\\Subscription\\Notifications\\ExpiredTransaction','subscription::phrase.expired_transaction','subscription',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,5),
(91,'subscription_expired_notify','MetaFox\\Subscription\\Notifications\\ExpiredNotify','subscription::phrase.expired_notification','subscription',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,6),
(92,'subscription_delete_package','MetaFox\\Subscription\\Notifications\\DeletePackage','subscription::phrase.delete_package','subscription',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,7),
(93,'page_invite','MetaFox\\Page\\Notifications\\PageInvite','page::phrase.page_invite_notification_type','page',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,15),
(94,'claim_page','MetaFox\\Page\\Notifications\\ClaimNotification','page::phrase.claim_page_notification_type','page',NULL,NULL,'[\"database\",\"mail\",\"webpush\"]',0,0,1,1,16),
(95,'like_page','MetaFox\\Page\\Notifications\\LikePageNotification','page::phrase.like_page_notification_type','page',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',0,0,1,1,17),
(96,'page_approve_notification','MetaFox\\Page\\Notifications\\PageApproveNotification','page::phrase.approve_page_notification_type','page',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,18),
(97,'approve_claim_page','MetaFox\\Page\\Notifications\\ApproveRequestClaimNotification','page::phrase.approve_claim_page_notification_type','page',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,19),
(98,'page_new_post','MetaFox\\Page\\Notifications\\ApproveNewPostNotification','page::phrase.page_new_post_notification_type','page',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(99,'page_update_info','MetaFox\\Page\\Notifications\\UpdateInformationNotification','page::phrase.update_info_page_notification_type','page',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(100,'saved_notification','','saved::phrase.saved_notification_type','saved',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,19),
(101,'saved_add_friend_to_list','MetaFox\\Saved\\Notifications\\AddFriendToListNotification','saved::phrase.saved_add_friend_to_list_notification_type','saved',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,20),
(102,'advertise_approved_notification','MetaFox\\Advertise\\Notifications\\AdvertiseApprovedNotification','advertise::phrase.approve_ad_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(103,'advertise_sponsor_approved_notification','MetaFox\\Advertise\\Notifications\\SponsorApprovedNotification','advertise::phrase.approve_sponsor_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(104,'advertise_denied_notification','MetaFox\\Advertise\\Notifications\\AdvertiseDeniedNotification','advertise::phrase.deny_ad_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(105,'new_comment','MetaFox\\Comment\\Notifications\\CommentNotification','comment::phrase.new_comment_notification_type','comment',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,3),
(106,'advertise_sponsor_denied_notification','MetaFox\\Advertise\\Notifications\\SponsorDeniedNotification','advertise::phrase.deny_sponsor_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(107,'advertise_sponsor_pending_notification','MetaFox\\Advertise\\Notifications\\PendingSponsorNotification','advertise::phrase.pending_sponsor_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(108,'comment_approve_notification','MetaFox\\Comment\\Notifications\\CommentApproveNotification','comment::phrase.comment_approved_notification_type','comment',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,4),
(109,'advertise_pending_notification','MetaFox\\Advertise\\Notifications\\PendingAdvertiseNotification','advertise::phrase.pending_advertise_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(110,'advertise_mark_as_paid_notification','MetaFox\\Advertise\\Notifications\\MarkAsPaidNotification','advertise::phrase.mark_ad_as_paid_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(111,'advertise_payment_success_ad_notification','MetaFox\\Advertise\\Notifications\\AdminPaymentSuccessNotification','advertise::phrase.pay_ad_successfully_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(112,'advertise_mark_sponsor_as_paid_notification','MetaFox\\Advertise\\Notifications\\MarkSponsorAsPaidNotification','advertise::phrase.mark_sponsor_as_paid_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(113,'advertise_payment_success_owner_notification','MetaFox\\Advertise\\Notifications\\OwnerPaymentSuccessNotification','advertise::phrase.owner_payment_success_notification','advertise',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(114,'start_livestream','MetaFox\\LiveStreaming\\Notifications\\StartLiveStreamNotification','livestreaming::phrase.friend_creates_a_new_live_video','livestreaming',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,1),
(115,'livestreaming_approve_notification','MetaFox\\LiveStreaming\\Notifications\\LiveVideoApproveNotification','livestreaming::phrase.livestreaming_approve_notification','livestreaming',NULL,NULL,'[\"mail\",\"database\",\"mobilepush\",\"webpush\"]',1,0,1,1,2),
(116,'like_notification','MetaFox\\Like\\Notifications\\LikeNotification','like::phrase.like_notification_type','like',NULL,NULL,'[\"database\",\"mail\",\"mobilepush\",\"webpush\"]',1,0,1,1,14),
(117,'joined_member_event_delete','MetaFox\\Event\\Notifications\\JoinedMemberEventDeletedNotification','event::phrase.event_delete_notification_type','event',NULL,NULL,'[database]',1,0,1,1,21),
(118,'story_reaction','MetaFox\\Story\\Notifications\\StoryReactionNotification','story::phrase.story_reaction_notification_type','like',NULL,NULL,'[database]',1,0,1,1,17),
(119,'suggest_create_story','MetaFox\\Story\\Notifications\\RenewStoryNotification','story::phrase.suggest_create_story_notification_type','story',NULL,NULL,'[database]',1,0,1,1,18),
(120,'story_video_done_processing','MetaFox\\Story\\Notifications\\StoryDoneProcessingNotification','story::phrase.story_video_done_processing_type','story',NULL,NULL,'[database]',1,0,1,1,19),
(121,'story_follower_notification','MetaFox\\Story\\Notifications\\NewStoryToFollowerNotification','story::phrase.story_follower_notification_type','story',NULL,'follow','[database]',1,0,1,1,19);
CREATE TABLE `notification_webpush_subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subscribable_id` bigint(20) unsigned NOT NULL,
  `subscribable_type` varchar(255) NOT NULL,
  `endpoint` varchar(500) NOT NULL,
  `public_key` varchar(255) DEFAULT NULL,
  `auth_token` varchar(255) DEFAULT NULL,
  `content_encoding` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notification_webpush_subscriptions_endpoint_unique` (`endpoint`),
  KEY `notification_webpush_subscriptions_subscribable_id_index` (`subscribable_id`),
  KEY `notification_webpush_subscriptions_user` (`subscribable_id`,`subscribable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  `data_item_id` bigint(20) unsigned DEFAULT NULL,
  `data_item_type` varchar(255) DEFAULT NULL,
  `item_type` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `data` mediumtext DEFAULT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `notified_at` timestamp NULL DEFAULT NULL,
  `is_request` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_id_index` (`notifiable_id`),
  KEY `ix_notifications_notifiable_morph` (`notifiable_id`,`notifiable_type`),
  KEY `notifications_item_id_index` (`item_id`),
  KEY `ix_notifications_item_morph` (`item_id`,`item_type`),
  KEY `notifications_user_id_index` (`user_id`),
  KEY `ix_notifications_user_morph` (`user_id`,`user_type`),
  KEY `notifications_data_item_id_index` (`data_item_id`),
  KEY `notifications_data_item_type_index` (`data_item_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `oauth_access_tokens` VALUES
('0d7cffacfe1d6f778b221ea27ca31fc695057a3c35dee271959b950f1ec0495594094284072f84e6',1,2,NULL,'[\"*\"]',0,'2024-12-03 20:29:47','2024-12-03 20:29:47','2024-12-18 21:29:47'),
('1813ff857378a8e9df0f5566f0515d27662865a4c5069ba6545dd35ecc517f61d2801c38e66a0f1e',1,2,NULL,'[\"*\"]',0,'2024-12-03 15:34:32','2024-12-03 15:34:32','2024-12-18 16:34:32'),
('18509ba8c81f26eb53526be4410e3a6553bde172540aff952ca680fdb95826c39df7c1a484fcdf0a',1,2,NULL,'[\"*\"]',0,'2024-12-05 21:16:56','2024-12-05 21:16:56','2024-12-20 22:16:56'),
('1d128f1298c717761a173c973a5ee3fa04590ab9a6fecf79c10688231f0ecda44271cf2118d3a252',1,2,NULL,'[\"*\"]',0,'2024-12-28 06:58:04','2024-12-28 06:58:04','2025-01-12 07:58:04'),
('1ff025a50de0e2161c1a3cb435d7ca525eee7a8ebbb9f7a206d17b5d0eae248cf9120c8ae5996e8c',1,2,NULL,'[\"*\"]',0,'2024-12-06 05:00:47','2024-12-06 05:00:47','2024-12-21 06:00:47'),
('22ca42fc7c633da2bb6431454bec9efed5714cbb4e1f65d8c71b7294d99f0e1b289314cc43d59a08',1,2,NULL,'[\"*\"]',1,'2024-11-30 13:29:43','2024-11-30 19:13:52','2024-12-15 14:29:43'),
('2897f3b50064db4f95fd1cf295f8420569801bc29834ca2945e74db8a8f44ac89be6e3c916482bbd',1,2,NULL,'[\"*\"]',1,'2024-12-01 15:54:54','2024-12-01 15:57:33','2024-12-16 16:54:54'),
('2f4962f559c92b678c0c4adb243d442483efd84db26498026f1c3f57b153f7f4bca3d406000561e5',1,2,NULL,'[\"*\"]',1,'2024-11-30 17:00:40','2024-11-30 19:13:52','2024-12-15 18:00:40'),
('325ae38d995de8b75b8e2a6ffd2e07bd4aefb3882d619bac90cc8e387f37437af3f70712d168e34b',1,2,NULL,'[\"*\"]',1,'2024-12-01 15:53:23','2024-12-01 15:54:24','2024-12-16 16:53:23'),
('39ddab5242d65fd761e1018586734cb4552887cd13f2e1b81d4f9b5938281c04f5b5ec6ba93b646f',2,2,NULL,'[\"*\"]',1,'2024-11-30 13:28:37','2024-11-30 17:00:28','2024-12-15 14:28:37'),
('42a4fe07ee8424d90451154cac5d6783d5929167ccd146bd0c9d3411d93741d80ca749026286dcd9',1,2,NULL,'[\"*\"]',0,'2024-12-04 14:55:42','2024-12-04 14:55:42','2024-12-19 15:55:42'),
('4a7c47ec9f142228aa9fcf06690c94c22fd8be4ca27fb83e812155bf30ce9ef2e68dcaebe1823b7f',1,2,NULL,'[\"*\"]',1,'2024-11-30 16:54:43','2024-11-30 17:02:45','2024-12-15 17:54:43'),
('515aea0d1cd55027889e893bb6d3b0e9c10a31c91c16de8f4293fc34d2274775a6cf501f0b9427a0',1,2,NULL,'[\"*\"]',1,'2024-11-30 18:14:45','2024-11-30 19:14:37','2024-12-15 19:14:45'),
('559da2dd2cc89d4d2dbe76916736910579834c97e5dce02d77242a55178bcceaae478fcf05d235bf',1,2,NULL,'[\"*\"]',0,'2024-12-02 17:20:47','2024-12-02 17:20:47','2024-12-17 18:20:47'),
('5d144f6668ba304d2717c00b9b0988363bd07cda334f3fe9856105b81b4bac3d72f06ba7fb872a80',1,2,NULL,'[\"*\"]',0,'2024-12-01 10:02:43','2024-12-01 10:02:43','2024-12-16 11:02:43'),
('5dd62ccfeae30829e6c809d0dbeb1645288904a6ab5d5f17cd4467d007c1e4290b39bb87869a68c2',1,2,NULL,'[\"*\"]',1,'2024-11-30 13:13:58','2024-11-30 19:13:52','2024-12-15 14:13:58'),
('617c2a2a72e9e9d082e07feac080d4b399e61a3dc76ef57c028fae99b81305977a05b2b9df6913bc',1,2,NULL,'[\"*\"]',0,'2024-12-02 09:15:13','2024-12-02 09:15:13','2024-12-17 10:15:13'),
('622e11550a32f90e2ce168ead38dd699c85049c86cdc42bdd9818e8d62113337d6e950cc25eb3f37',1,2,NULL,'[\"*\"]',0,'2024-12-01 00:48:31','2024-12-01 00:48:31','2024-12-16 01:48:31'),
('7062fb8ed5fb4b2e98cd891a1ec7a59e6cf934d175ba6381131fe2178b41c63ac2381d3ad5e5d3ee',1,2,NULL,'[\"*\"]',0,'2025-01-01 18:58:26','2025-01-01 18:58:26','2025-01-16 19:58:26'),
('7d1c3acd7d725e645b1201d6c8c648d0d75a03e42be006ca176bdf0bbb30f0e6e8eaa2f35cb12030',1,2,NULL,'[\"*\"]',0,'2024-12-01 18:30:17','2024-12-01 18:30:17','2024-12-16 19:30:17'),
('865048f228b5dea12e0de5887c9c31f1ed5f12f72ec85cb950a1b2cb741e5bb30bc9d549443acebf',1,2,NULL,'[\"*\"]',1,'2024-12-01 10:17:38','2024-12-01 15:53:03','2024-12-16 11:17:38'),
('871bd5033b358e411863ff48dae081d45bae7ff146da8dc56a8947f51807815d511357993675ef4e',1,2,NULL,'[\"*\"]',0,'2024-12-01 10:11:36','2024-12-01 10:11:36','2024-12-16 11:11:36'),
('9b736de55ad444ef34793c8293a7fe9382f11f45c8ae5a51653166b1eaec0cc5d9887d2158d8cc54',1,2,NULL,'[\"*\"]',1,'2024-11-30 18:13:12','2024-11-30 19:13:52','2024-12-15 19:13:12'),
('9d5018f202fb5a7d0fb2faa8301933b7ab1846a28702cd331c866f6b045088c0b2b2b4ecd611226f',1,2,NULL,'[\"*\"]',0,'2024-12-23 18:10:43','2024-12-23 18:10:43','2025-01-07 19:10:43'),
('9f5ea11c842663ff8e9b1246dc4a8d71c70b3f1950893407383e2c8cf7d89a169dabdb1fb31280a8',1,2,NULL,'[\"*\"]',0,'2024-12-02 16:04:41','2024-12-02 16:04:41','2024-12-17 17:04:41'),
('a425eacf419c34a10b3622c2227f426ffc069a635fdd7f2405a8b64ca62b75ec24879e1b31743f5d',1,2,NULL,'[\"*\"]',0,'2024-12-01 16:58:12','2024-12-01 16:58:12','2024-12-16 17:58:12'),
('abae948aa1c93d620e32e6fed26324e0ba81c0ec805c941d349fea2413b2fa401363fb6656e07cbf',1,2,NULL,'[\"*\"]',1,'2024-12-02 20:13:17','2024-12-02 20:20:41','2024-12-17 21:13:17'),
('b18807e560e8563dc489764b90660daa36c40c62489330af4dd5d764db508598fb1fe0f50ac8ecc5',1,2,NULL,'[\"*\"]',0,'2024-12-01 15:59:22','2024-12-01 15:59:22','2024-12-16 16:59:22'),
('b4f8b7573b1d41d02eaf31da41c04e1f700e0b411bc68cfa11ed463fe7f04d471b1737cef10363c3',1,2,NULL,'[\"*\"]',0,'2024-12-02 11:11:40','2024-12-02 11:11:40','2024-12-17 12:11:40'),
('c57bfacce07e30fc6a71e5bad0d80abb426bc92555781a2d3e554b84813d3346c994b764238eb875',1,2,NULL,'[\"*\"]',0,'2024-12-02 17:16:56','2024-12-02 17:16:56','2024-12-17 18:16:56'),
('c80a072c332b167808c30fa0656eb283d5b4307cf5d366966d0e021314acedbe9b06297f98d8057c',1,2,NULL,'[\"*\"]',0,'2024-12-01 00:30:15','2024-12-01 00:30:15','2024-12-16 01:30:15'),
('cc77f1db3b36797435f96e59dadda450bd07032fed6c33d9c519bd566fcde4e2a034496af545aa00',1,2,NULL,'[\"*\"]',0,'2024-12-09 16:06:18','2024-12-09 16:06:18','2024-12-24 17:06:18'),
('d81f85280025fb959d607a0e67be9dcb52600071183e1b265463edcf16a0a960f456a5a93180ccca',2,2,NULL,'[\"*\"]',0,'2024-11-30 17:03:21','2024-11-30 17:03:21','2024-12-15 18:03:21'),
('d91af4284524acf42ec669feb6aa78a45fd5b0fffda92c41cd9a33aa753fe696478e8d7b39318b43',1,2,NULL,'[\"*\"]',0,'2024-12-01 15:40:30','2024-12-01 15:40:30','2024-12-16 16:40:30'),
('e614473639866cb6542ee5f3294491701ecf056995e46a7077d296c12a948f40d714dab4e2bdd6bd',1,2,NULL,'[\"*\"]',0,'2024-12-09 12:24:04','2024-12-09 12:24:04','2024-12-24 13:24:04'),
('efb767b360372b198e6576f798cfbbecbf81c03ac9764a9c4f7430d0a978d5d8cb54fed6a481c764',1,2,NULL,'[\"*\"]',0,'2024-12-12 16:06:26','2024-12-12 16:06:26','2024-12-27 17:06:26'),
('f8ef8e2ee986bf6dc8a4c9b3ca5aaf1547a9cced6412ec8b40b8e179ed1ff7f64ac08c838a28a51e',1,2,NULL,'[\"*\"]',0,'2024-12-09 12:24:41','2024-12-09 12:24:41','2024-12-24 13:24:41');
