#
# TABLE STRUCTURE FOR: package_category
#

DROP TABLE IF EXISTS `package_category`;

CREATE TABLE `package_category` (
  `p_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(125) NOT NULL,
  `description` text NOT NULL,
  `date_created` int(11) NOT NULL,
  `date_updated` int(11) NOT NULL,
  `create_by` int(11) NOT NULL,
  PRIMARY KEY (`p_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `package_category` (`p_category_id`, `name`, `description`, `date_created`, `date_updated`, `create_by`) VALUES (1, 'Internet Broadband', '  ', 1607703893, 1661497993, 0);
INSERT INTO `package_category` (`p_category_id`, `name`, `description`, `date_created`, `date_updated`, `create_by`) VALUES (2, 'Internet Dedicated', ' ', 1661497935, 0, 0);


