-- Create syntax for 'items'

CREATE TABLE `items` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `serial_number` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `item_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `description` varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sale_sequence` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `delivered` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `delivered_quantity` int(11) DEFAULT NULL,
  `item_notes` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `notes` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `warehouse_notes` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `amount` decimal(6,2) DEFAULT NULL,
  `checked_quantity` int(11) DEFAULT NULL,
  `location` int(11) DEFAULT NULL,
  `return_code` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`pk`)
) ENGINE=InnoDB AUTO_INCREMENT=2360187 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
