DROP TABLE IF EXISTS `EmployeeInfo`;
CREATE TABLE `EmployeeInfo` (
id int(11) NOT NULL,
Code varchar(15) DEFAULT NULL,
Myouji varchar(15) DEFAULT NULL,
Namae varchar(15) DEFAULT NULL,
MyoujiF varchar(15) DEFAULT NULL,
NamaeF varchar(15) DEFAULT NULL,
Informal varchar(20) DEFAULT NULL,
BirthDay datetime DEFAULT NULL,
SEX int(11) DEFAULT NULL,
PostalCode varchar(10) DEFAULT NULL,
Address1 varchar(8) DEFAULT NULL,
Address2 varchar(50) DEFAULT NULL,
Address3 varchar(50) DEFAULT NULL,
TEL varchar(20) DEFAULT NULL,
Cellular varchar(20) DEFAULT NULL,
eMail1 varchar(50) DEFAULT NULL,
eMail2 varchar(50) DEFAULT NULL,
MemoData varchar(20) DEFAULT NULL,
Level int(11) DEFAULT NULL,
Executive int(11) DEFAULT NULL,
RegistDay datetime DEFAULT NULL,
RefixDay datetime DEFAULT NULL,
Status int(11) DEFAULT NULL,
Time1 datetime DEFAULT NULL,
Time2 datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `EmployeeInfo` ADD PRIMARY KEY (`id`);


INSERT INTO `EmployeeInfo` (`ID`,`Code`,`Myouji`,`Namae`,`MyoujiF`,`NamaeF`,`Informal`,`BirthDay`,`SEX`,`PostalCode`,`Address1`,`Address2`,`Address3`,`TEL`,`Cellular`,`eMail1`,`eMail2`,`MemoData`,`Level`,`Executive`,`RegistDay`,`RefixDay`,`Status`,`Time1`,`Time2`) VALUES 
(4,'50','','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2010-01-05 20:21:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(36,'34','徳泉','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-18 05:23:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(38,'37','柴田','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-27 13:55:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(39,'38','郷野','','','','','1900-01-01 10:00:00',1,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-27 13:56:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(40,'39','水谷','','','','','1900-01-01 10:00:00',1,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-27 13:57:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(42,'41','宮下','','','','','1900-01-01 10:00:00',1,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-27 13:59:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(43,'42','下苧坪','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-27 14:00:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(45,'44','二瀬','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-05-24 05:59:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(47,'46','神尾','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-09-10 10:05:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(48,'47','','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2010-01-05 20:21:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(49,'48','','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2010-01-05 20:21:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(50,'49','','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2010-01-05 20:21:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(51,'51','','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2010-06-04 08:06:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(52,'52','52','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(53,'53','53','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(54,'54','54','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(55,'55','55','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(56,'56','56','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(57,'57','57','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(58,'58','58','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(59,'59','59','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(60,'60','60','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(61,'61','61','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:09:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(62,'100','100','','','','','1900-01-01 09:00:00',0,'','','','','','','','','',0,0,'1900-01-01 09:00:00','2009-07-09 02:10:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(74,'32','松永','','','','','1900-01-01 10:00:00',1,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-18 05:22:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(91,'10','','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2022-01-23 04:29:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(94,'3','','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2020-08-16 22:38:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(95,'4','社員','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2019-11-14 14:12:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(104,'20','倉橋','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2022-02-02 21:38:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(110,'27','大山','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-03-03 07:00:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(112,'31','野村','','','','','1900-01-01 10:00:00',1,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-03-31 08:41:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(113,'36','西川','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-18 07:56:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(115,'22','東','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2021-10-14 21:10:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(116,'23','森','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-03-03 07:00:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(118,'25','東田','','','','','1900-01-01 10:00:00',1,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2022-01-15 19:22:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00'),
(120,'1','店長','','','','','1900-01-01 10:00:00',0,'0000000','','','','','','','','',0,0,'1900-01-01 09:00:00','2023-04-16 04:17:00',0,'1970-01-01 09:00:00','1970-01-01 09:00:00');