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

--
-- Table structure for table `business_searches`
--

CREATE TABLE `business_searches` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bussiness_name` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `category` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `sub_category` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tags` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `listing_description` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `website` varchar(44) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `address` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `state` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `city` varchar(33) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `sub_area` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pin_code` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `geo_location` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `contact_number` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `landline_no` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `whatsapp_number` varchar(13) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `working_days` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '[]',
  `timing_from` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `timing_till` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `add_faq` varchar(111) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `twitter` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `facebook` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `linkedIn` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `Youtube` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `Instagram` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `logo` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '[]'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `business_searches`
--

INSERT INTO `business_searches` (`id`, `deleted_at`, `created_at`, `updated_at`, `bussiness_name`, `category`, `sub_category`, `tags`, `listing_description`, `website`, `address`, `state`, `city`, `sub_area`, `pin_code`, `geo_location`, `contact_number`, `landline_no`, `whatsapp_number`, `working_days`, `timing_from`, `timing_till`, `add_faq`, `twitter`, `facebook`, `linkedIn`, `Youtube`, `Instagram`, `logo`) VALUES
(1, NULL, NULL, NULL, 'IT Office In Amritsar', '1', '6001', 'newspaper,agency', 'Newspaper In Amritsar', 'www.davinternationalschool.edu', 'near canal road', '6', '594', 'demo Address', '143002', '', '9988661129', '0183123456', '9988661129', 'Monday,Tuesday,Wednesday,Thursday,Friday,Satuarday', '10:00', '19:00', 'jjkxjlxx', '', '', '', '', '', '[\"984\"]'),
(2, NULL, NULL, NULL, 'IT Office In Amritsar', '1', '6001', 'ads,advertising', 'ckcmlsc;lsk;\'xlsxc', 'www.davinternationalschool.edu', 'near canal road', '6', '594', 'demo Address', '143002', '', '9988661129', '0183123456', '9988661129', 'Tuesday,Wednesday,Thursday', '10:22', '19:26', 'jjkxjlxx', '', '', '', '', '', '[\"985\"]'),
(3, NULL, NULL, NULL, 'Green Cafe', '20', '6258', 'Restaurent,food,Chinese', 'Chinese Restaurant In Amritsar', 'www.davinternationalschool.edu', 'near canal road', '6', '594', 'Chandigarh', '143002', '', '9876543210', '0183123456', '9876543211', 'Monday,Tuesday,Wednesday,Thursday,Friday,Satuarday', '10:25', '22:00', 'jjkxjlxx', '', '', '', '', '', '[\"986\"]'),
(4, NULL, NULL, NULL, 'Shubh Food Corner', '20', '6262', 'Dhaba,Vegetarian,food', 'Only Veg Food Avilable', 'www.shubfood.com', 'near canal road', '6', '594', 'demo Address', '143002', '', '9876543210', '01835555555', '9876543212', 'Monday,Tuesday,Wednesday,Thursday,Friday,Satuarday', '09:00', '22:30', 'No FAQ', '', '', '', '', '', '[\"987\"]'),
(5, NULL, NULL, NULL, '3 dec business', '9', '6108', 'books', 'books', 'books.com', 'no', '5', '449', 'ok', '423567', '', '8483838423', '8373890982', '8372839282', 'Monday', '22:21', '17:27', 'no', '', '', '', '', '', '[\"994\"]');
