对应的是:
create table `zt_project` (
`id` int ,
`isCat` varchar (3),
`catID` int ,
`type` varchar (60),
`parent` int ,
`name` varchar (270),
`code` varchar (135),
`begin` date ,
`end` date ,
`days` int ,
`status` varchar (30),
`statge` varchar (3),
`pri` varchar (3),
`desc` blob ,
`openedBy` varchar (90),
`openedDate` datetime ,
`openedVersion` varchar (60),
`closedBy` varchar (90),
`closedDate` datetime ,
`canceledBy` varchar (90),
`canceledDate` datetime ,
`PO` varchar (90),
`PM` varchar (90),
`QD` varchar (90),
`RD` varchar (90),
`team` varchar (270),
`acl` varchar (21),
`whitelist` blob ,
`order` int ,
`deleted` varchar (3),
`ptype` double
);
insert into `zt_project` (`id`, `isCat`, `catID`, `type`, `parent`, `name`, `code`, `begin`, `end`, `days`, `status`, `statge`, `pri`, `desc`, `openedBy`, `openedDate`, `openedVersion`, `closedBy`, `closedDate`, `canceledBy`, `canceledDate`, `PO`, `PM`, `QD`, `RD`, `team`, `acl`, `whitelist`, `order`, `deleted`, `ptype`) values('12','0','0','sprint','0','汇创达聚明2厂MES系统2024运维','HCD_JM2','2022-06-07','2023-06-06','261','wait','1','1','','syant','2022-06-07 15:07:54','11.4.1','','0000-00-00 00:00:00','','0000-00-00 00:00:00','','','','','汇创达聚明2厂MES运维','open','','60','0','0');
|