#
# TABLE STRUCTURE FOR: whatsapp
#

DROP TABLE IF EXISTS `whatsapp`;

CREATE TABLE `whatsapp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_active` int(11) NOT NULL,
  `api_key` text NOT NULL,
  `token` text NOT NULL,
  `domain_api` text NOT NULL,
  `username` varchar(50) NOT NULL,
  `vendor` varchar(128) NOT NULL,
  `createinvoice` int(11) NOT NULL,
  `paymentinvoice` int(11) NOT NULL,
  `duedateinvoice` int(11) NOT NULL,
  `interval_message` int(11) NOT NULL,
  `sender` varchar(128) NOT NULL,
  `reminderinvoice` int(11) NOT NULL,
  `version` int(11) NOT NULL,
  `period` int(11) NOT NULL,
  `create_help` text NOT NULL,
  `update_help` text NOT NULL,
  `get_help` text NOT NULL,
  `create_help_customer` int(11) NOT NULL,
  `create_help_admin` int(11) NOT NULL,
  `text_help_customer` int(11) NOT NULL,
  `send_help_customer` int(11) NOT NULL,
  `id_devices` int(11) NOT NULL,
  `official` int(11) NOT NULL,
  `count_blast` int(11) NOT NULL,
  `last_excute` text NOT NULL,
  `time_start` text NOT NULL,
  `time_end` text NOT NULL,
  `send_isolir` int(11) NOT NULL,
  `send_ticket_done` int(11) NOT NULL,
  `template` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `whatsapp` (`id`, `is_active`, `api_key`, `token`, `domain_api`, `username`, `vendor`, `createinvoice`, `paymentinvoice`, `duedateinvoice`, `interval_message`, `sender`, `reminderinvoice`, `version`, `period`, `create_help`, `update_help`, `get_help`, `create_help_customer`, `create_help_admin`, `text_help_customer`, `send_help_customer`, `id_devices`, `official`, `count_blast`, `last_excute`, `time_start`, `time_end`, `send_isolir`, `send_ticket_done`, `template`) VALUES (1, 1, '064b668a-3590-4844-8048-e82e54c737e9', 'danilbukankudanil', 'https://wa.danialrusdy.com', '6281222200030', 'Other', 1, 1, 1, 5, 'SyPrRCuU', 0, 3, 1, '0', '', '', 0, 0, 0, 0, 0, 0, 5, '2025-11-18 19:21:02', '05:00', '23:59', 0, 0, '');


