-- Create syntax for 'notes'

CREATE TABLE `notes` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `note` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `note_author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `note_created_at` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`pk`)
) ENGINE=InnoDB AUTO_INCREMENT=690861 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
