-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `indiasuperkart`
--

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `parent` int(11) NOT NULL DEFAULT 0,
  `level` tinyint(3) DEFAULT 1,
  `category_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_alt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) DEFAULT 1 COMMENT '1=ACTIVE,0=INACTIVE',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `icon_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `parent`, `level`, `category_name`, `image`, `image_alt`, `image_title`, `description`, `slug`, `status`, `created_at`, `updated_at`, `icon_image`) VALUES
(1, 0, 1, 'Agriculture', 'CJln7NOs.jpg', 'Agriculture', 'Agriculture', '<p>Agriculture</p>\r\n', 'agriculture', 1, '2022-06-17 01:43:24', '2022-06-28 02:05:34', 'rpx2gl-4.png'),
(2, 1, 2, 'Fresh Flowers and Plants', NULL, '', '', '<p>Fresh Flowers and Plants</p>\r\n', 'fresh-flowers-and-plants', 1, '2022-06-17 02:10:34', '2022-06-17 02:10:34', NULL),
(3, 1, 2, 'Irrigation Equipment & Systems', NULL, 'Irrigation Equipment & Systems', 'Irrigation Equipment & Systems', '<p>Irrigation Equipment &amp; Systems</p>\r\n', 'irrigation-equipment-systems', 1, '2022-06-17 02:17:34', '2022-06-17 02:17:34', NULL),
(4, 1, 2, 'Pet and Farming Animals', NULL, 'Pet and Farming Animals', 'Pet and Farming Animals', '<p>Pet and Farming Animals</p>\r\n', 'pet-and-farming-animals', 1, '2022-06-17 02:18:33', '2022-06-17 02:18:33', NULL),
(5, 1, 2, 'Tractor & Tractor Parts', NULL, 'Tractor & Tractor Parts', 'Tractor & Tractor Parts', '<p>Tractor &amp; Tractor Parts</p>\r\n', 'tractor-tractor-parts', 1, '2022-06-17 02:20:39', '2022-06-17 02:20:39', NULL),
(6, 2, 3, 'Rose', NULL, 'Rose', 'Rose', '<p>Rose</p>\r\n', 'rose', 1, '2022-06-17 02:21:52', '2022-06-17 02:21:52', NULL),
(7, 2, 3, 'Jasmine Flowers', NULL, 'Jasmine Flowers', 'Jasmine Flowers', '<p>Jasmine Flowers</p>\r\n', 'jasmine-flowers', 1, '2022-06-17 02:23:04', '2022-06-17 02:23:04', NULL),
(8, 2, 3, 'Marigold Flowers', NULL, 'Marigold Flowers', 'Marigold Flowers', '<p>Marigold Flowers</p>\r\n', 'marigold-flowers', 1, '2022-06-18 11:24:15', '2022-06-18 11:24:15', NULL),
(9, 0, 1, 'Apparel & Fashion', '', '', '', '<p>Apparle &amp; Fashion Accesseries</p>\r\n', 'apparel-fashion', 1, '2022-06-21 23:27:03', '2022-06-29 22:57:54', 'jmTlh2qv.png'),
(10, 9, 2, 'Men, Women & Kids Footwear', NULL, '', '', '<p>Men, Women &amp; Kids Footwear</p>\r\n', 'men-women-kids-footwear', 1, '2022-06-21 23:31:20', '2022-06-21 23:31:20', NULL),
(11, 9, 2, 'Kids Dressing & Clothing', NULL, '', '', '<p>Kids Dressing &amp; Clothing</p>\r\n', 'kids-dressing-clothing', 1, '2022-06-21 23:32:36', '2022-06-21 23:32:36', NULL),
(12, 9, 2, 'Mens Clothing', NULL, '', '', '<p>Mens Clothing</p>\r\n', 'mens-clothing', 1, '2022-06-21 23:33:11', '2022-06-21 23:33:11', NULL),
(13, 9, 2, 'Leather Clothing', NULL, 'Leather Clothing', 'Leather Clothing', '<p>Leather Clothing</p>\r\n', 'leather-clothing', 1, '2022-06-21 23:33:38', '2022-06-21 23:33:38', NULL),
(14, 0, 1, 'Chemicals', NULL, 'Chemicals', 'Chemicals', '<p>Chemicals</p>\r\n', 'chemicals', 1, '2022-06-21 23:35:48', '2022-06-29 22:58:33', 'R5BXzS1G.png'),
(15, 14, 2, 'Textile Chemicals', NULL, 'Textile Chemicals', 'Textile Chemicals', '<p>Textile Chemicals</p>\r\n', 'textile-chemicals', 1, '2022-06-21 23:36:21', '2022-06-21 23:36:21', NULL),
(16, 14, 2, 'Medical and Industrial Gases', NULL, 'Medical and Industrial Gases', 'Medical and Industrial Gases', '<p>Medical and Industrial Gases</p>\r\n', 'medical-and-industrial-gases', 1, '2022-06-21 23:36:52', '2022-06-21 23:36:52', NULL),
(17, 0, 1, 'Construction & Real Estate', 'DDB2O91a.jpg', 'Construction & Real Estate', 'Construction & Real Estate', '<p>Construction &amp; Real Estate</p>\r\n', 'construction-real-estate', 1, '2022-06-28 02:13:02', '2022-06-28 02:13:02', 'svTmc9U6.png'),
(18, 17, 2, 'Construction Machinery & Equipment', 'adVSv9X5.jpg', 'Crushing Machines', 'Crushing Machines', '<p>Crushing Machines</p>\r\n', 'construction-machinery-equipment', 1, '2022-06-28 02:14:20', '2022-06-28 02:17:16', NULL),
(19, 17, 2, 'Industrial Pipe & Tube Fittings', '-odTIAXe.jpg', 'Industrial Pipe & Tube Fittings', 'Industrial Pipe & Tube Fittings', '<p>Industrial Pipe &amp; Tube Fittings</p>\r\n', 'industrial-pipe-tube-fittings', 1, '2022-06-28 02:18:23', '2022-06-28 02:18:23', NULL);

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

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country_code` char(5) COLLATE utf8_unicode_ci NOT NULL,
  `iso_code` char(10) COLLATE utf8_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1 COMMENT '1=ACTIVE, 0=INACTIVE',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `apply_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migration`
--

INSERT INTO `migration` (`version`, `apply_time`) VALUES
('m000000_000000_base', 1645608509),
('m130524_201442_init', 1645608513),
('m190124_110200_add_verification_token_column_to_user_table', 1645608513),
('m210607_134105_add_indexes_to_user_table', 1645608513),
('m210608_050842_users_seeder', 1645608514),
('m220223_100050_create_country_table', 1645610980),
('m220616_172137_create_category_table', 1655410353),
('m220621_171115_create_top_category_table', 1655831657),
('m220627_193050_add_icon_image_col_category_table', 1656358322),
('m220627_204932_create_sliders_table', 1656363208);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int(11) NOT NULL,
  `heading` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_alt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1 COMMENT '1=ACTIVE,0=INACTIVE',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `heading`, `link`, `image`, `image_alt`, `image_title`, `status`, `created_at`, `updated_at`) VALUES
(1, '40% Discount', 'http://localhost/indiasuperkart/admin/sliders/create', 'toV0eeFj.jpg', '40% Discount', '40% Discount', 1, '2022-06-29 21:41:37', '2022-06-29 21:52:03'),
(2, '50 % discount', 'http://localhost/indiasuperkart/', 'at8EuYdO.jpg', '', '', 1, '2022-06-29 22:39:43', '2022-06-29 22:39:43'),
(3, '30% Discount', 'http://localhost/indiasuperkart/', 'ETMgAr7Q.jpg', '', '', 1, '2022-06-29 22:40:13', '2022-06-29 22:40:13');

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

--
-- Table structure for table `top_category`
--

CREATE TABLE `top_category` (
  `id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `order_no` int(11) DEFAULT 1,
  `status` tinyint(1) DEFAULT 1 COMMENT '1=ACTIVE,0=INACTIVE',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `top_category`
--

INSERT INTO `top_category` (`id`, `title`, `url`, `order_no`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Surgical Flower', 'http://localhost/indiasuperkart/', 1, 1, '2022-06-21 23:02:18', '2022-06-22 14:36:16'),
(2, 'T Shirt', 'http://localhost/indiasuperkart/', 2, 1, '2022-06-21 23:04:13', '2022-06-21 23:04:13'),
(3, 'Gloves', 'http://localhost/indiasuperkart/', 3, 1, '2022-06-21 23:07:22', '2022-06-21 23:16:56'),
(4, 'Dental Implants', 'http://localhost/indiasuperkart/', 4, 1, '2022-06-21 23:19:33', '2022-06-21 23:19:43'),
(5, 'Furniture', 'http://localhost/indiasuperkart/', 5, 1, '2022-06-21 23:20:05', '2022-06-21 23:20:05'),
(6, 'Filling Machinery', 'http://localhost/indiasuperkart/', 6, 1, '2022-06-21 23:20:27', '2022-06-21 23:20:27'),
(7, 'Silica Sand', 'http://localhost/indiasuperkart/', 7, 1, '2022-06-21 23:20:44', '2022-06-21 23:20:44');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx-category-status` (`status`),
  ADD KEY `idx-category-slug` (`slug`),
  ADD KEY `idx-category-parent` (`parent`);

--
-- Indexes for table `country`
--
ALTER TABLE `country`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx-country-status` (`status`);

--
-- Indexes for table `migration`
--
ALTER TABLE `migration`
  ADD PRIMARY KEY (`version`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `top_category`
--
ALTER TABLE `top_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx-top_category-status` (`status`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `top_category`
--
ALTER TABLE `top_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

