github.com/angenalZZZ/gofunc@v0.0.0-20210507121333-48ff1be3917b/test/sql/logtest-mssql.sql (about)

     1  
     2  CREATE TABLE [logtest] (
     3  	[Id] bigint NOT NULL IDENTITY(1,1) PRIMARY KEY CLUSTERED,
     4  	[Code] varchar(50),
     5  	[Type] int,
     6  	[Message] varchar(4000) NOT NULL,
     7  	[Account] varchar(36),
     8  	[CreateTime] datetime NOT NULL,
     9  	[CreateUser] varchar(36)
    10  ) ON [PRIMARY];
    11  EXEC sp_addextendedproperty @name=N'MS_Description',@value=N'自增ID',@level0type=N'Schema',@level0name=N'dbo',@level1type=N'Table',@level1name=N'logtest',@level2type=N'Column',@level2name=N'Id';
    12  EXEC sp_addextendedproperty @name=N'MS_Description',@value=N'测试记录',@level0type=N'Schema',@level0name=N'dbo',@level1type=N'Table',@level1name=N'logtest';