CREATE TABLE IF NOT EXISTS `Sys_Log${date:format=yyyyMM}`(
`id` bigint NOT NULL AUTO_INCREMENT,
`createtime` datetime NOT NULL,
`appname` varchar(50) NOT NULL,
`modulename` varchar(50) NULL,
`level` varchar(50) NOT NULL,
`logger` varchar(1024) NULL DEFAULT NULL,
`msg` text NULL,
`userid` varchar(50) NULL DEFAULT NULL,
`url` varchar(1024) NULL DEFAULT NULL,
`ip` varchar(255) NULL DEFAULT NULL,
`tenantId` varchar(50) NULL,
PRIMARY KEY (`id`) USING BTREE
);
INSERT INTO `Sys_Log${date:format=yyyyMM}`(`createtime`, `appname`, `modulename`, `level`, `logger`, `msg`,`userid`, `url`, `ip`,`tenantId`) VALUES (@CreateTime, @AppName,@ModuleName, @Level, @Logger, @Msg, @UserId, @Url, @IP,@TenantId);