#
# TABLE STRUCTURE FOR: help
#

DROP TABLE IF EXISTS `help`;

CREATE TABLE `help` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no_ticket` varchar(50) NOT NULL,
  `help_type` int(11) NOT NULL,
  `help_solution` int(11) NOT NULL,
  `no_services` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `date_created` int(11) NOT NULL,
  `status` varchar(50) NOT NULL,
  `teknisi` int(11) NOT NULL,
  `picture` text NOT NULL,
  `create_by` int(11) NOT NULL,
  `action` int(11) NOT NULL,
  `estimation` int(11) NOT NULL,
  `ticket_password` text NOT NULL,
  `date_help` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `help` (`id`, `no_ticket`, `help_type`, `help_solution`, `no_services`, `description`, `date_created`, `status`, `teknisi`, `picture`, `create_by`, `action`, `estimation`, `ticket_password`, `date_help`) VALUES (1, '240404001', 1, 1, '240317090955', 'internet sering kali ngelag gatau apa penyebabnya kadang di buat youtube ngelag nya minta ampun min udah seminggu ini ngelag nya parah', 1712216971, 'pending', 0, '', 1959, 0, 0, '', '2024-04-04');
INSERT INTO `help` (`id`, `no_ticket`, `help_type`, `help_solution`, `no_services`, `description`, `date_created`, `status`, `teknisi`, `picture`, `create_by`, `action`, `estimation`, `ticket_password`, `date_help`) VALUES (2, '240701001', 1, 2, '240131105525', '', 1719836571, 'pending', 0, '', 1773, 0, 0, '', '2024-07-01');
INSERT INTO `help` (`id`, `no_ticket`, `help_type`, `help_solution`, `no_services`, `description`, `date_created`, `status`, `teknisi`, `picture`, `create_by`, `action`, `estimation`, `ticket_password`, `date_help`) VALUES (3, '250609001', 1, 1, '250221170412', '', 1749438033, 'pending', 0, '', 2970, 0, 0, '', '2025-06-09');
INSERT INTO `help` (`id`, `no_ticket`, `help_type`, `help_solution`, `no_services`, `description`, `date_created`, `status`, `teknisi`, `picture`, `create_by`, `action`, `estimation`, `ticket_password`, `date_help`) VALUES (4, '260104001', 1, 2, '240919092312', '', 1767509732, 'pending', 0, '', 0, 0, 0, '', '2026-01-04');