dotnetcore / dotnetcore/osharp

mysql 数据迁移 datetime(6) 出错

Open
#125 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
2.8k
Forks
763
PR merge metrics
No merged PRs in 30d

Description

执行 update -database 出错 :
Failed executing DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
```
CREATE TABLE `AuditOperation` (
`Id` char(36) NOT NULL,
`FunctionName` longtext NULL,
`UserId` longtext NULL,
`UserName` longtext NULL,
`NickName` longtext NULL,
`Ip` longtext NULL,
`OperationSystem` longtext NULL,
`Browser` longtext NULL,
`UserAgent` longtext NULL,
`ResultType` int NOT NULL,
`Message` longtext NULL,
`Elapsed` int NOT NULL,
`CreatedTime` datetime(6) NOT NULL,
CONSTRAINT `PK_AuditOperation` PRIMARY KEY (`Id`)
);
```

> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL,
CONSTRAINT `PK_AuditOperation` PRIMARY KEY (`Id`)
)' at line 14

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.