CREATE TABLE `sales_items` (
  `item_id` int(11) NOT NULL,
  `product` varchar(255) NOT NULL,
  `unit_price` decimal(19,2) NOT NULL,
  `qty` int(11) NOT NULL,
  `date_of_sale` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;