E-commerce Categories List

CREATE TABLE `tbl_ecom_category` (
  `cat_id` int(11) UNSIGNED NOT NULL,
  `cat_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cat_parent` int(11) NOT NULL DEFAULT 0,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `tbl_ecom_category` (`cat_id`, `cat_name`,`cat_parent`) VALUES
(1, 'Electronics', 0),
(2, 'Books', 0),
(3, 'Cameras', 1),
(4, 'Televisions',1),
(5, 'Fiction Books',2),
(6, 'Exam Books',2);

ALTER TABLE `tbl_ecom_category`
  ADD PRIMARY KEY (`cat_id`);

ALTER TABLE `tbl_ecom_category`
  MODIFY `cat_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=257;
COMMIT;