DROP TABLE IF EXISTS `BusinessTicket`; CREATE TABLE `BusinessTicket` ( id int(11) NOT NULL, BusinessID int(11) DEFAULT NULL, DataID int(11) DEFAULT NULL, Name varchar(30) DEFAULT NULL, Flag int(11) DEFAULT NULL, TypeFlag int(11) DEFAULT NULL, Kind int(11) DEFAULT NULL, Val int(11) DEFAULT NULL, Kubun int(11) DEFAULT NULL, GroupCode int(11) DEFAULT NULL, Data int(11) DEFAULT NULL, AccData int(11) DEFAULT NULL, Count int(11) DEFAULT NULL, SubID int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ALTER TABLE `BusinessTicket` ADD PRIMARY KEY (`id`);