CREATE TABLE IF NOT EXISTS `trailbalance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(50) DEFAULT NULL,
  `total_deduction` varchar(50) DEFAULT NULL,
  `approval_status` varchar(50) DEFAULT '1',
  `created_by` varchar(50) DEFAULT NULL,
  `department_id` tinyint(4) DEFAULT NULL,
  `total_earning` varchar(50) DEFAULT NULL,
  `approval_date` timestamp NULL DEFAULT NULL,
  `approver_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4;


CREATE TABLE IF NOT EXISTS `trailbalancecomments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `trail_balance_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `comment` text,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;