DROP TABLE IF EXISTS `RoomInfo3`; CREATE TABLE `RoomInfo3` ( RoomID int(11) NOT NULL, Yorei int(11) DEFAULT NULL, AlmTime1 int(11) DEFAULT NULL, AlmTime2 int(11) DEFAULT NULL, Info1 varchar(30) DEFAULT NULL, Info2 varchar(30) DEFAULT NULL, Data1 int(11) DEFAULT NULL, Data2 int(11) DEFAULT NULL, Data3 int(11) DEFAULT NULL, Data4 int(11) DEFAULT NULL, Data5 int(11) DEFAULT NULL, Memo3 varchar(30) DEFAULT NULL,) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO `RoomInfo3` (`RoomID`,`Yorei`,`AlmTime1`,`AlmTime2`,`Info1`,`Info2`,`Data1`,`Data2`,`Data3`,`Data4`,`Data5`,`Memo3`) VALUES (1,1,0,0,'','',0,0,0,0,0,''), (2,1,0,0,'','',0,0,0,0,0,''), (3,1,0,0,'','',0,0,0,0,0,''), (4,1,0,0,'','',0,0,0,0,0,''), (5,1,0,0,'','',0,0,0,0,0,''), (6,1,0,0,'','',0,0,0,0,0,''), (7,1,0,0,'','',0,0,0,0,0,''), (8,1,0,0,'','',0,0,0,0,0,''), (9,1,0,0,'','',0,0,0,0,0,''), (10,1,0,0,'','',0,0,0,0,0,''), (11,1,0,0,'','',0,0,0,0,0,''), (12,1,0,0,'','',0,0,0,0,0,''), (13,1,0,0,'','',0,0,0,0,0,''), (14,1,0,0,'','',0,0,0,0,0,''), (15,1,0,0,'','',0,0,0,0,0,''), (16,1,0,0,'','',0,0,0,0,0,''), (17,1,0,0,'','',0,0,0,0,0,''), (18,1,0,0,'','',0,0,0,0,0,''), (19,1,0,0,'','',0,0,0,0,0,''), (20,1,0,0,'','',0,0,0,0,0,'');