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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `top_banner` int NOT NULL,
  `right_banner` int NOT NULL,
  `left_banner` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `bottom_banner` int NOT NULL,
  `top_banner_url` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `left_banner_url` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `right_banner_url` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `bottom_url_banner` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `web_page` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `ad_for` 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 `ads`
--

INSERT INTO `ads` (`id`, `deleted_at`, `created_at`, `updated_at`, `name`, `top_banner`, `right_banner`, `left_banner`, `bottom_banner`, `top_banner_url`, `left_banner_url`, `right_banner_url`, `bottom_url_banner`, `status`, `web_page`, `ad_for`) VALUES
(3, NULL, '2021-03-27 06:23:39', '2021-03-27 06:23:39', 'test', 272, 273, '273', 272, 'http://passproviders.com/', 'http://passproviders.com/', 'http://passproviders.com/', 'http://passproviders.com/', 'active', 'Passive', '[]'),
(4, NULL, '2024-02-19 09:23:04', '2024-02-19 12:24:18', 'KARAN SAHOTA', 0, 5892, '0', 0, 'https://passproviders.com/User_dashboard_one_dynamic/1?gradebasedmarket=USA%20High%20GCV%20Coal%20Grade-A%20(6800%20-%207100%20NAR%20)&pid=1&portid=2', '', 'https://passproviders.com/User_dashboard_one_dynamic/1?gradebasedmarket=USA%20High%20GCV%20Coal%20Grade-A%20(6800%20-%207100%20NAR%20)&pid=1&portid=2', '', 'inactive', 'Home Page', '[]');
