#
# TABLE STRUCTURE FOR: package_item
#

DROP TABLE IF EXISTS `package_item`;

CREATE TABLE `package_item` (
  `p_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(125) NOT NULL,
  `price` varchar(125) NOT NULL,
  `picture` text NOT NULL,
  `description` text NOT NULL,
  `category_id` int(11) NOT NULL,
  `date_created` int(11) NOT NULL,
  `date_update` int(11) NOT NULL,
  `public` int(11) NOT NULL,
  `is_active` int(11) NOT NULL,
  `create_by` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `package_mitra` int(11) NOT NULL,
  PRIMARY KEY (`p_item_id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (1, '20 Mbps', '225000', '', ' ', 1, 1734495397, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (2, '3 Mbps', '165000', '', ' ', 1, 1734495439, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (3, '5 Mbps', '185000', '', ' ', 1, 1734495448, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (4, '10 Mbps', '220000', '', ' ', 1, 1734495454, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (5, '1,5 Mbps', '110000', '', ' ', 1, 1737261615, 0, 0, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (6, '30 Mbps', '285000', '', ' ', 1, 1734495467, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (7, '40 Mbps', '335000', '', ' ', 1, 1734495472, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (8, '50 Mbps', '399000', '', ' ', 1, 1734495479, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (21, '20 Mbps ', '330000', '', ' ', 1, 1686200632, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (22, '1,5 Mbps Anten', '150000', '', ' ', 1, 1686196084, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (23, '2M Anten', '200000', '', ' ', 1, 1686196101, 0, 1, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (24, '3M anten', '200000', '', ' ', 1, 1686200583, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (25, '5 M anten', '225000', '', ' ', 1, 1686200487, 0, 1, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (26, '2 M anten', '150000', '', ' ', 1, 1734495485, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (27, '5 m anten', '300000', '', ' ', 1, 1686200516, 0, 1, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (28, '20 mbps anten', '350000', '', ' ', 1, 1686200525, 0, 1, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (29, '20 m ', '550000', '', ' ', 1, 1686200531, 0, 1, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (30, '1,5 m', '15000', '', ' ', 1, 1686200537, 0, 1, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (31, '1,5 m (wildan)', '165000', '', ' ', 1, 1686200473, 0, 1, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (32, '3 Mbps', '120000', '', ' ', 1, 1734595966, 0, 0, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (33, 'NEW 30 Mbps', '165000', '', ' ', 1, 1732505810, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (34, '3 Mbps Anten', '150000', '', ' ', 1, 1687578214, 0, 1, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (35, '3 Mbps', '990000', '', 'BALAI DESA', 1, 1691806281, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (36, 'NEW 50 Mbps', '205000', '', ' ', 1, 1732505966, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (37, 'NEW 15 Mbps', '125000', '', ' ', 1, 1734595754, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (38, 'NEW 100 Mbps', '250000', '', ' ', 1, 1732505988, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (40, 'NEW 150 Mbps', '385000', '', ' ', 1, 1732506018, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (41, '40 Mbps', '2460000', '', ' ', 1, 1734495509, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (42, '15 Mbps (Promo)', '115000', '', ' ', 1, 1734768352, 0, 0, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (43, 'NEW 20 Mbps', '135000', '', ' ', 1, 1734595942, 0, 0, 0, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (44, '20 Mbps promo', '135000', '', ' ', 1, 1735354058, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (45, 'ByteHome-Essential', '125000', '', ' ', 1, 1754813841, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (46, 'ByteHome-Signature', '165000', '', ' ', 1, 1754813656, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (47, '100 Mbps', '700000', '', ' PT MULIA 41', 1, 1757031107, 0, 1, 1, 0, 0, 0);
INSERT INTO `package_item` (`p_item_id`, `name`, `price`, `picture`, `description`, `category_id`, `date_created`, `date_update`, `public`, `is_active`, `create_by`, `role_id`, `package_mitra`) VALUES (49, 'Instalasi Internet', '100000', '', ' ', 1, 1767769263, 0, 1, 1, 5565, 0, 0);


