CREATE TABLE `tblexpense_taxes` (
  `tenant_id` bigint(20) UNSIGNED NOT NULL DEFAULT 1,
  `id` bigint(20) UNSIGNED NOT NULL,
  `expense_id` bigint(20) UNSIGNED NOT NULL,
  `taxrate` decimal(15,2) NOT NULL,
  `taxname` varchar(100) NOT NULL,
  `amount` decimal(15,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `tblexpense_taxes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `expense_id` (`expense_id`);


ALTER TABLE `tblexpense_taxes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;