
  CREATE TABLE `inv_product_stock_check` (
    `ipsm_id` int(11) NOT NULL,
    `ipsm_date` date DEFAULT NULL,
    `ipsm_batch` int(11) NOT NULL,
    `ipsm_quantity` decimal(11,2) NOT NULL,
    `deleted` tinyint(4) NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  ALTER TABLE `inv_product_stock_check`
    ADD PRIMARY KEY (`ipsm_id`);
    ALTER TABLE `inv_product_stock_check`
    MODIFY `ipsm_id` int(11) NOT NULL AUTO_INCREMENT;