
CREATE TABLE `active_modules` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `client_id` int DEFAULT NULL,
  `module_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `admin_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `has_landing_page` int DEFAULT NULL,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `styles` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `admin_settings` VALUES (1,1,10,'nature.jpeg','Saif','2022-10-03 17:11:47','2022-10-03 18:08:23'),(2,2,10,'nature.jpeg','Kawkab','2022-10-03 17:13:15','2022-10-03 17:16:57'),(3,3,10,'nature_001.png','Galib','2022-10-03 17:16:09','2022-10-03 18:09:09'),(5,7,10,'nature.jpeg','SaifOrg','2022-10-27 11:35:56','2022-10-27 11:36:40');
CREATE TABLE `cities` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `countries` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `d_c_allow_surveys` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `is_allow` tinyint NOT NULL DEFAULT '0',
  `d_c_survey_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `country` int NOT NULL DEFAULT '1',
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `d_c_allow_surveys` VALUES (1,1,'1',2,1,'en',NULL,'2022-10-03 18:06:40','2022-10-03 18:07:45'),(2,1,'2',3,1,'en',NULL,'2022-10-03 18:08:47','2022-10-03 18:08:47'),(3,0,'3',2,1,'en',NULL,'2022-10-21 15:22:58','2022-10-21 15:22:58');
CREATE TABLE `d_c_feedbacks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `rating` int NOT NULL DEFAULT '0',
  `feedback` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `d_c_feedbacks` VALUES (1,2,0,NULL,NULL,'2022-10-03 17:13:15','2022-10-03 17:13:15'),(2,3,0,NULL,NULL,'2022-10-03 17:16:09','2022-10-03 17:16:09');
CREATE TABLE `d_c_hack_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `d_c_hack_users` VALUES (1,1,NULL,NULL,'2022-10-03 17:11:47','2022-10-03 17:11:47'),(2,2,0,NULL,'2022-10-03 17:13:15','2022-10-03 17:13:15'),(3,3,0,NULL,'2022-10-03 17:16:09','2022-10-03 17:16:09');
CREATE TABLE `d_c_income_levels` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `income` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `d_c_pending_surveys` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `country` int DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `mongo_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mongo_answer_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_pending` tinyint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `d_c_pending_surveys` VALUES (1,2,NULL,'en','633ac264505a337158086c12',NULL,0,NULL,'2022-10-03 18:07:16','2022-10-03 18:07:16'),(2,3,NULL,'en','633ac264505a337158086c12',NULL,0,NULL,'2022-10-03 18:08:47','2022-10-03 18:08:47');
CREATE TABLE `d_c_point_redeems` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `points` int DEFAULT NULL,
  `type` tinyint NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `d_c_point_redeems` VALUES (1,1,NULL,0,0,NULL,'2022-10-03 17:11:47','2022-10-03 17:11:47'),(2,2,NULL,0,0,NULL,'2022-10-03 17:13:15','2022-10-03 17:13:15'),(3,3,NULL,0,0,NULL,'2022-10-03 17:16:09','2022-10-03 17:16:09');
CREATE TABLE `d_c_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `role` tinyint NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '0',
  `language` tinyint NOT NULL DEFAULT '1',
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `d_c_settings` VALUES (1,1,0,0,1,NULL,'2022-10-03 17:11:47','2022-10-03 17:11:47'),(2,2,0,0,1,NULL,'2022-10-03 17:13:15','2022-10-03 17:13:15'),(3,3,0,0,1,NULL,'2022-10-03 17:16:09','2022-10-03 17:16:09');
CREATE TABLE `d_c_surveys` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `country` int NOT NULL DEFAULT '1',
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` int NOT NULL DEFAULT '0',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `istemplate` tinyint NOT NULL DEFAULT '0',
  `isprivate` tinyint NOT NULL DEFAULT '0',
  `istemporary` tinyint NOT NULL DEFAULT '0',
  `points` int NOT NULL DEFAULT '0',
  `mongo_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `d_c_surveys` VALUES (1,2,1,'en','What are some of the Dark Truths about the Liberal Mind?',3,'2022-10-03','2022-10-10',2,0,0,0,20,'633ac264505a337158086c12',NULL,'2022-10-03 18:06:40','2022-10-03 18:07:45'),(2,3,1,'en','What are some of the Dark Truths about the Liberal Mind?',3,'2022-10-03','2022-10-10',2,0,0,0,20,'633ac264505a337158086c12',NULL,'2022-10-03 18:08:47','2022-10-03 18:08:47'),(3,2,1,'en','What are some of the Dark Truths about the Atheist Mind?',3,'2022-10-21','2022-10-28',3,1,1,1,20,NULL,NULL,'2022-10-21 15:22:58','2022-10-21 15:22:58');
CREATE TABLE `d_c_track_surveys` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `country` int NOT NULL DEFAULT '1',
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `d_c_survey_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mongo_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mongo_answer_id` varchar(6000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `achieve_point` int NOT NULL DEFAULT '0',
  `csv_report` tinyint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `d_c_track_surveys` VALUES (1,2,1,'en','1','633ac264505a337158086c12',NULL,0,0,NULL,'2022-10-03 18:06:40','2022-10-03 18:07:16'),(2,3,1,'en','2','633ac264505a337158086c12','[\"633d808eb78a5bb272017d92\",\"633d808eb78a5bb272017d92\",\"633e502bb0fc3cae6a05d392\"]',3,0,NULL,'2022-10-03 18:08:47','2022-10-06 10:48:59'),(3,2,1,'en','3',NULL,NULL,0,0,NULL,'2022-10-21 15:22:58','2022-10-21 15:22:58');
CREATE TABLE `districts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `division_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `divisions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `geo_locations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `d_c_survey_id` int DEFAULT NULL,
  `mongo_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `lat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `long` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `country` int NOT NULL DEFAULT '0',
  `city` int NOT NULL DEFAULT '0',
  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `platform` tinyint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `geo_locations` VALUES (1,1,'633ac264505a337158086c12',2,'0','0',0,0,NULL,NULL,0,NULL,'2022-10-03 18:06:40','2022-10-03 18:07:16'),(2,2,'633ac264505a337158086c12',3,'0','0',0,0,NULL,NULL,0,NULL,'2022-10-03 18:08:47','2022-10-03 18:08:47'),(3,3,NULL,2,'0','0',0,0,NULL,NULL,0,NULL,'2022-10-21 15:22:58','2022-10-21 15:22:58');
CREATE TABLE `global_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `client_id` int DEFAULT NULL,
  `client_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `languages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `mail_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `mail_settings` VALUES (1,1,NULL,NULL,'Created by User as an authenticated Admin','For Sending Notification to an Admin When Created',1,'2022-10-03 17:11:47','2022-10-03 17:11:47',NULL),(2,2,NULL,NULL,'Created by User as an authenticated Organisation','For Sending Notification to an Organisation When Created',1,'2022-10-03 17:13:15','2022-10-03 17:13:15',NULL),(3,3,NULL,NULL,'Created by User as an authenticated User','For Sending Notification to an User When Created',1,'2022-10-03 17:16:09','2022-10-03 17:16:09',NULL);
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1239 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` VALUES (1211,'2014_10_12_000000_create_users_table',1),(1212,'2014_10_12_100000_create_password_resets_table',1),(1213,'2018_10_09_175319_create_d_c_surveys_table',1),(1214,'2018_10_09_181120_create_d_c_track_surveys_table',1),(1215,'2018_10_09_183233_create_d_c_allow_surveys_table',1),(1216,'2018_10_09_184126_create_d_c_pending_surveys_table',1),(1217,'2018_10_10_030011_create_active_modules_table',1),(1218,'2018_10_10_030424_create_d_c_settings_table',1),(1219,'2018_10_10_031120_create_geo_locations_table',1),(1220,'2018_10_10_031924_create_mail_settings_table',1),(1221,'2018_10_10_032531_create_modules_table',1),(1222,'2018_10_10_033049_create_notification_email_settings_table',1),(1223,'2018_10_10_033227_create_notification_s_m_s_settings_table',1),(1224,'2018_10_10_033937_create_notification_settings_table',1),(1225,'2018_10_10_034252_create_districts_table',1),(1226,'2018_10_10_034725_create_divisions_table',1),(1227,'2018_10_10_035141_create_admin_settings_table',1),(1228,'2018_10_10_041006_create_cities_table',1),(1229,'2018_10_10_041318_create_countries_table',1),(1230,'2018_10_10_041803_create_d_c_hack_users_table',1),(1231,'2018_10_10_042144_create_global_settings_table',1),(1232,'2018_10_11_032137_create_d_c_feedbacks_table',1),(1233,'2018_10_11_032738_create_d_c_income_levels_table',1),(1234,'2018_10_11_033100_create_d_c_point_redeems_table',1),(1235,'2018_10_11_033526_create_languages_table',1),(1236,'2018_10_11_033923_create_occupations_table',1),(1237,'2018_10_11_034224_create_profiles_table',1),(1238,'2021_06_07_133341_create_jobs_table',1);
CREATE TABLE `modules` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prefix` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `version` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_published` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `notification_email_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `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 `notification_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `module_id` int DEFAULT NULL,
  `active_sub_modules` text COLLATE utf8mb4_unicode_ci,
  `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 `occupations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `occupation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `profiles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `iscompleted` tinyint NOT NULL DEFAULT '0',
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `handset` tinyint NOT NULL DEFAULT '0',
  `operator` tinyint NOT NULL DEFAULT '0',
  `firstname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` tinyint NOT NULL DEFAULT '1',
  `marital_status` tinyint NOT NULL DEFAULT '0',
  `birth_date` date DEFAULT NULL,
  `education_level` tinyint NOT NULL DEFAULT '0',
  `occupation` tinyint NOT NULL DEFAULT '0',
  `country` int NOT NULL DEFAULT '1',
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `income_level` int DEFAULT NULL,
  `profile_photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qr_file_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime 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 `profiles` VALUES (1,NULL,0,'+8801718432571',0,0,'Saif','Kamal',1,0,'2022-10-10',0,2,1,NULL,NULL,'House -132, Road # 3, Block-A, Niketan, Dhaka',NULL,'beautiful-bg-custom.jpg','nature.jpeg',NULL,'2022-10-11 11:09:44','2022-10-11 11:09:44');


