ALTER TABLE `tbl_products_stock_adjustments` ADD `adjusted_by` INT NOT NULL AFTER `id`;
INSERT INTO `tbl_permissions` (`perm_id`, `sidebar_group`, `perm_group`, `perm_name`, `created_by`, `created_on`, `updated_by`, `updated_on`) VALUES ('8', 'accounts', 'store inventory', 'adjust stock', '1', '2023-10-21 04:55:20', '1', '2019-01-21 00:00:00');

ALTER TABLE `tbl_pos_bill_items` CHANGE `quantity` `quantity` FLOAT NOT NULL;
ALTER TABLE `tbl_pos_billing` CHANGE `cash_amount` `cash_amount` FLOAT NOT NULL;


CREATE TABLE `tbl_purchases_invoices` (
  `id` int(11) NOT NULL,
  `purchase_id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `file_type` int(11) NOT NULL COMMENT '0-image,1-doc',
  `status` int(11) NOT NULL COMMENT '1-active,2-inactive'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tbl_purchases_invoices` ADD PRIMARY KEY (`id`), ADD KEY `purchase_id` (`purchase_id`);
ALTER TABLE `tbl_purchases_invoices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
