DROP TABLE IF EXISTS `ReserveInfo`; CREATE TABLE `ReserveInfo` ( id int(11) NOT NULL, Flag int(11) DEFAULT NULL, BusinessDay datetime DEFAULT NULL, ResDate datetime DEFAULT NULL, ResTime varchar(5) DEFAULT NULL, UseMinute int(11) DEFAULT NULL, UseNumber int(11) DEFAULT NULL, CustCode varchar(15) DEFAULT NULL, Name varchar(31) DEFAULT NULL, RoomID int(11) DEFAULT NULL, Advance int(11) DEFAULT NULL, MemoData varchar(30) DEFAULT NULL, EmployeeID int(11) DEFAULT NULL, TerminalID int(11) DEFAULT NULL, RefixDay datetime DEFAULT NULL,) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ALTER TABLE `ReserveInfo` ADD PRIMARY KEY (`id`);