/* 执行脚本前,请先选择数据库,脚本会先删除表,然后再创建表,请谨慎执行!!! */; /* use [YiShaAdmin] */ IF OBJECT_ID('[dbo].[SysArea]', 'U') IS NOT NULL DROP TABLE [dbo].[SysArea]; CREATE TABLE [dbo].[SysArea]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [AreaCode] [varchar](6) NOT NULL, [ParentAreaCode] [varchar](6) NOT NULL, [AreaName] [nvarchar](50) NOT NULL, [ZipCode] [varchar](50) NOT NULL, [AreaLevel] [int] NOT NULL, CONSTRAINT [PK_SysArea] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'Id' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记(0正常 1删除)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'BaseIsDelete' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'BaseCreateTime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'BaseModifyTime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'BaseCreatorId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'BaseModifierId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据版本(每次更新+1)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'BaseVersion' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地区编码', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'AreaCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父地区编码', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'ParentAreaCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地区名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'AreaName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮政编码', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'ZipCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地区层级(1省份 2城市 3区县)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysArea', @level2type=N'COLUMN',@level2name=N'AreaLevel' IF OBJECT_ID('[dbo].[SysAutoJob]', 'U') IS NOT NULL DROP TABLE [dbo].SysAutoJob; CREATE TABLE [dbo].[SysAutoJob]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [JobGroupName] [nvarchar](50) NOT NULL, [JobName] [nvarchar](50) NOT NULL, [JobStatus] [int] NOT NULL, [CronExpression] [varchar](50) NOT NULL, [StartTime] [datetime] NOT NULL, [EndTime] [datetime] NOT NULL, [NextStartTime] [datetime] NOT NULL, [Remark] [nvarchar](500) NOT NULL, CONSTRAINT [PK_SysAutoJob] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务组名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJob', @level2type=N'COLUMN',@level2name=N'JobGroupName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJob', @level2type=N'COLUMN',@level2name=N'JobName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务状态(0禁用 1启用)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJob', @level2type=N'COLUMN',@level2name=N'JobStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'cron表达式', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJob', @level2type=N'COLUMN',@level2name=N'CronExpression' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运行开始时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJob', @level2type=N'COLUMN',@level2name=N'StartTime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运行结束时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJob', @level2type=N'COLUMN',@level2name=N'EndTime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下次执行时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJob', @level2type=N'COLUMN',@level2name=N'NextStartTime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJob', @level2type=N'COLUMN',@level2name=N'Remark' IF OBJECT_ID('[dbo].[SysAutoJobLog]', 'U') IS NOT NULL DROP TABLE [dbo].[SysAutoJobLog]; CREATE TABLE [dbo].[SysAutoJobLog]( [Id] [bigint] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [JobGroupName] [nvarchar](50) NOT NULL, [JobName] [nvarchar](50) NOT NULL, [LogStatus] [int] NOT NULL, [Remark] [nvarchar](500) NOT NULL, CONSTRAINT [PK_SysAutoJobLog] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务组名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJobLog', @level2type=N'COLUMN',@level2name=N'JobGroupName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJobLog', @level2type=N'COLUMN',@level2name=N'JobName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'执行状态(0失败 1成功)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJobLog', @level2type=N'COLUMN',@level2name=N'LogStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysAutoJobLog', @level2type=N'COLUMN',@level2name=N'Remark' IF OBJECT_ID('[dbo].[SysDataDict]', 'U') IS NOT NULL DROP TABLE [dbo].[SysDataDict]; CREATE TABLE [dbo].[SysDataDict]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [DictType] [varchar](50) NOT NULL, [DictSort] [int] NOT NULL, [Remark] [nvarchar](50) NOT NULL, CONSTRAINT [PK_SysDataDict] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典类型', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDict', @level2type=N'COLUMN',@level2name=N'DictType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典排序', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDict', @level2type=N'COLUMN',@level2name=N'DictSort' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDict', @level2type=N'COLUMN',@level2name=N'Remark' IF OBJECT_ID('[dbo].[SysDataDictDetail]', 'U') IS NOT NULL DROP TABLE [dbo].[SysDataDictDetail]; CREATE TABLE [dbo].[SysDataDictDetail]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [DictType] [varchar](50) NOT NULL, [DictSort] [int] NOT NULL, [DictKey] [int] NOT NULL, [DictValue] [varchar](50) NOT NULL, [ListClass] [varchar](50) NOT NULL, [DictStatus] [int] NOT NULL, [IsDefault] [int] NOT NULL, [Remark] [nvarchar](50) NOT NULL, CONSTRAINT [PK_SysDataDictDetail] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典类型(外键)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDictDetail', @level2type=N'COLUMN',@level2name=N'DictType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典排序', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDictDetail', @level2type=N'COLUMN',@level2name=N'DictSort' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典键(一般从1开始)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDictDetail', @level2type=N'COLUMN',@level2name=N'DictKey' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典值', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDictDetail', @level2type=N'COLUMN',@level2name=N'DictValue' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示样式(default primary success info warning danger)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDictDetail', @level2type=N'COLUMN',@level2name=N'ListClass' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典状态(0禁用 1启用)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDictDetail', @level2type=N'COLUMN',@level2name=N'DictStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'默认选中(0不是 1是)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDictDetail', @level2type=N'COLUMN',@level2name=N'IsDefault' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDataDictDetail', @level2type=N'COLUMN',@level2name=N'Remark' IF OBJECT_ID('[dbo].[SysDepartment]', 'U') IS NOT NULL DROP TABLE [dbo].[SysDepartment]; CREATE TABLE [dbo].[SysDepartment]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [ParentId] [bigint] NOT NULL, [DepartmentName] [nvarchar](50) NOT NULL, [Telephone] [varchar](50) NOT NULL, [Fax] [varchar](50) NOT NULL, [Email] [varchar](50) NOT NULL, [PrincipalId] [bigint] NOT NULL, [DepartmentSort] [int] NOT NULL, [Remark] [nvarchar](500) NOT NULL, CONSTRAINT [PK_SysDepartment] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父部门Id(0表示是根部门)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDepartment', @level2type=N'COLUMN',@level2name=N'ParentId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDepartment', @level2type=N'COLUMN',@level2name=N'DepartmentName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门电话', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDepartment', @level2type=N'COLUMN',@level2name=N'Telephone' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门传真', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDepartment', @level2type=N'COLUMN',@level2name=N'Fax' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门Email', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDepartment', @level2type=N'COLUMN',@level2name=N'Email' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门负责人Id', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDepartment', @level2type=N'COLUMN',@level2name=N'PrincipalId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门排序', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDepartment', @level2type=N'COLUMN',@level2name=N'DepartmentSort' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysDepartment', @level2type=N'COLUMN',@level2name=N'Remark' IF OBJECT_ID('[dbo].[SysLogApi]', 'U') IS NOT NULL DROP TABLE [dbo].[SysLogApi]; CREATE TABLE [dbo].[SysLogApi]( [Id] [bigint] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [LogStatus] [int] NOT NULL, [Remark] [nvarchar](50) NOT NULL, [ExecuteUrl] [varchar](100) NOT NULL, [ExecuteParam] [nvarchar](4000) NOT NULL, [ExecuteResult] [nvarchar](4000) NOT NULL, [ExecuteTime] [int] NOT NULL, CONSTRAINT [PK_SysLogApi] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'执行状态(0失败 1成功)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogApi', @level2type=N'COLUMN',@level2name=N'LogStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogApi', @level2type=N'COLUMN',@level2name=N'Remark' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接口地址', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogApi', @level2type=N'COLUMN',@level2name=N'ExecuteUrl' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求参数', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogApi', @level2type=N'COLUMN',@level2name=N'ExecuteParam' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求结果', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogApi', @level2type=N'COLUMN',@level2name=N'ExecuteResult' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'执行时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogApi', @level2type=N'COLUMN',@level2name=N'ExecuteTime' IF OBJECT_ID('[dbo].[SysLogLogin]', 'U') IS NOT NULL DROP TABLE [dbo].[SysLogLogin]; CREATE TABLE [dbo].[SysLogLogin]( [Id] [bigint] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [LogStatus] [int] NOT NULL, [IpAddress] [varchar](20) NOT NULL, [IpLocation] [nvarchar](50) NOT NULL, [Browser] [nvarchar](50) NOT NULL, [OS] [nvarchar](50) NOT NULL, [Remark] [nvarchar](50) NOT NULL, [ExtraRemark] [nvarchar](500) NOT NULL, CONSTRAINT [PK_SysLogLogin] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'执行状态(0失败 1成功)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogLogin', @level2type=N'COLUMN',@level2name=N'LogStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ip地址', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogLogin', @level2type=N'COLUMN',@level2name=N'IpAddress' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ip位置', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogLogin', @level2type=N'COLUMN',@level2name=N'IpLocation' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'浏览器', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogLogin', @level2type=N'COLUMN',@level2name=N'Browser' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作系统', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogLogin', @level2type=N'COLUMN',@level2name=N'OS' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogLogin', @level2type=N'COLUMN',@level2name=N'Remark' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'额外备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogLogin', @level2type=N'COLUMN',@level2name=N'ExtraRemark' IF OBJECT_ID('[dbo].[SysLogOperate]', 'U') IS NOT NULL DROP TABLE [dbo].[SysLogOperate]; CREATE TABLE [dbo].[SysLogOperate]( [Id] [bigint] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [LogStatus] [int] NOT NULL, [IpAddress] [varchar](20) NOT NULL, [IpLocation] [nvarchar](50) NOT NULL, [Remark] [nvarchar](50) NOT NULL, [LogType] [varchar](50) NOT NULL, [BusinessType] [varchar](50) NOT NULL, [ExecuteUrl] [nvarchar](100) NOT NULL, [ExecuteParam] [nvarchar](4000) NOT NULL, [ExecuteResult] [nvarchar](4000) NOT NULL, [ExecuteTime] [int] NOT NULL, CONSTRAINT [PK_SysLogOperate] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'执行状态(0失败 1成功)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'LogStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ip地址', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'IpAddress' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ip位置', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'IpLocation' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'Remark' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志类型(暂未用到)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'LogType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务类型(暂未用到)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'BusinessType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'页面地址', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'ExecuteUrl' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求参数', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'ExecuteParam' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求结果', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'ExecuteResult' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'执行时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysLogOperate', @level2type=N'COLUMN',@level2name=N'ExecuteTime' IF OBJECT_ID('[dbo].[SysMenu]', 'U') IS NOT NULL DROP TABLE [dbo].[SysMenu]; CREATE TABLE [dbo].[SysMenu]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [ParentId] [bigint] NOT NULL, [MenuName] [nvarchar](50) NOT NULL, [MenuIcon] [varchar](50) NOT NULL, [MenuUrl] [varchar](100) NOT NULL, [MenuTarget] [varchar](50) NOT NULL, [MenuSort] [int] NOT NULL, [MenuType] [int] NOT NULL, [MenuStatus] [int] NOT NULL, [Authorize] [varchar](50) NOT NULL, [Remark] [nvarchar](50) NOT NULL, CONSTRAINT [PK_SysMenu] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父菜单Id(0表示是根菜单)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'ParentId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'MenuName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单图标', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'MenuIcon' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单Url', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'MenuUrl' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接打开方式', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'MenuTarget' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单排序', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'MenuSort' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单类型(1目录 2页面 3按钮)',@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'MenuType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单状态(0禁用 1启用)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'MenuStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单权限标识', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'Authorize' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenu', @level2type=N'COLUMN',@level2name=N'Remark' IF OBJECT_ID('[dbo].[SysMenuAuthorize]', 'U') IS NOT NULL DROP TABLE [dbo].[SysMenuAuthorize]; CREATE TABLE [dbo].[SysMenuAuthorize]( [Id] [bigint] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [MenuId] [bigint] NOT NULL, [AuthorizeId] [bigint] NOT NULL, [AuthorizeType] [int] NOT NULL, CONSTRAINT [PK_SysMenuAuthorize] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单Id', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenuAuthorize', @level2type=N'COLUMN',@level2name=N'MenuId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'授权Id(角色Id或者用户Id)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenuAuthorize', @level2type=N'COLUMN',@level2name=N'AuthorizeId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'授权类型(1角色 2用户)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysMenuAuthorize', @level2type=N'COLUMN',@level2name=N'AuthorizeType' IF OBJECT_ID('[dbo].[SysNews]', 'U') IS NOT NULL DROP TABLE [dbo].[SysNews]; CREATE TABLE [dbo].[SysNews]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [NewsTitle] [nvarchar](300) NOT NULL, [NewsContent] [ntext] NOT NULL, [NewsTag] [nvarchar](200) NOT NULL, [ThumbImage] [varchar](200) NOT NULL, [NewsAuthor] [nvarchar](50) NOT NULL, [NewsSort] [int] NOT NULL, [NewsDate] [datetime] NOT NULL, [NewsType] [int] NOT NULL, [ViewTimes] [int] NOT NULL, [ProvinceId] [bigint] NOT NULL, [CityId] [bigint] NOT NULL, [CountyId] [bigint] NOT NULL, CONSTRAINT [PK_SysNews] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新闻标题', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'NewsTitle' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新闻内容', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'NewsContent' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新闻标签', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'NewsTag' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省份Id', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'ProvinceId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'城市Id', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'CityId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区县Id', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'CountyId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缩略图', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'ThumbImage' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新闻排序', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'NewsSort' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布者', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'NewsAuthor' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'NewsDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新闻类型(1产品案例 2行业新闻)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'NewsType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'查看次数', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysNews', @level2type=N'COLUMN',@level2name=N'ViewTimes' IF OBJECT_ID('[dbo].[SysPosition]', 'U') IS NOT NULL DROP TABLE [dbo].[SysPosition]; CREATE TABLE [dbo].[SysPosition]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [PositionName] [nvarchar](50) NOT NULL, [PositionSort] [int] NOT NULL, [PositionStatus] [int] NOT NULL, [Remark] [nvarchar](50) NOT NULL, CONSTRAINT [PK_SysPosition] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysPosition', @level2type=N'COLUMN',@level2name=N'PositionName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位排序', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysPosition', @level2type=N'COLUMN',@level2name=N'PositionSort' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位状态(0禁用 1启用)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysPosition', @level2type=N'COLUMN',@level2name=N'PositionStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysPosition', @level2type=N'COLUMN',@level2name=N'Remark' IF OBJECT_ID('[dbo].[SysRole]', 'U') IS NOT NULL DROP TABLE [dbo].[SysRole]; CREATE TABLE [dbo].[SysRole]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [RoleName] [nvarchar](50) NOT NULL, [RoleSort] [int] NOT NULL, [RoleStatus] [int] NOT NULL, [Remark] [nvarchar](50) NOT NULL, CONSTRAINT [PK_SysRole] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色名称', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysRole', @level2type=N'COLUMN',@level2name=N'RoleName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色排序', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysRole', @level2type=N'COLUMN',@level2name=N'RoleSort' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色状态(0禁用 1启用)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysRole', @level2type=N'COLUMN',@level2name=N'RoleStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysRole', @level2type=N'COLUMN',@level2name=N'Remark' IF OBJECT_ID('[dbo].[SysUser]', 'U') IS NOT NULL DROP TABLE [dbo].[SysUser]; CREATE TABLE [dbo].[SysUser]( [Id] [bigint] NOT NULL, [BaseIsDelete] [int] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseModifyTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [BaseModifierId] [bigint] NOT NULL, [BaseVersion] [int] NOT NULL, [UserName] [nvarchar](20) NOT NULL, [Password] [varchar](32) NOT NULL, [Salt] [varchar](5) NOT NULL, [RealName] [nvarchar](20) NOT NULL, [DepartmentId] [bigint] NOT NULL, [Gender] [int] NOT NULL, [Birthday] [varchar](10) NOT NULL, [Portrait] [varchar](200) NOT NULL, [Email] [varchar](50) NOT NULL, [Mobile] [varchar](11) NOT NULL, [QQ] [varchar](20) NOT NULL, [WeChat] [varchar](20) NOT NULL, [LoginCount] [int] NOT NULL, [UserStatus] [int] NOT NULL, [IsSystem] [int] NOT NULL, [IsOnline] [int] NOT NULL, [FirstVisit] [datetime] NOT NULL, [PreviousVisit] [datetime] NOT NULL, [LastVisit] [datetime] NOT NULL, [Remark] [nvarchar](200) NOT NULL, [WebToken] [varchar](32) NOT NULL, [ApiToken] [varchar](32) NOT NULL, CONSTRAINT [PK_SysUser] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'UserName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'Password' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码盐值', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'Salt' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'RealName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属部门Id', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'DepartmentId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别(0未知 1男 2女)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'Gender' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'Birthday' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'Portrait' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Email', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'Email' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'Mobile' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'QQ', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'QQ' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'WeChat' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录次数', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'LoginCount' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户状态(0禁用 1启用)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'UserStatus' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统用户(0不是 1是[系统用户拥有所有的权限])', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'IsSystem' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'在线(0不是 1是)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'IsOnline' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'首次登录时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'FirstVisit' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上一次登录时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'PreviousVisit' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后一次登录时间', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'LastVisit' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'Remark' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'后台Token', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'WebToken' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ApiToken', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUser', @level2type=N'COLUMN',@level2name=N'ApiToken' IF OBJECT_ID('[dbo].[SysUserBelong]', 'U') IS NOT NULL DROP TABLE [dbo].[SysUserBelong]; CREATE TABLE [dbo].[SysUserBelong]( [Id] [bigint] NOT NULL, [BaseCreateTime] [datetime] NOT NULL, [BaseCreatorId] [bigint] NOT NULL, [UserId] [bigint] NOT NULL, [BelongId] [bigint] NOT NULL, [BelongType] [int] NOT NULL, CONSTRAINT [PK_SysUserBelong] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户Id', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserBelong', @level2type=N'COLUMN',@level2name=N'UserId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位Id或者角色Id', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserBelong', @level2type=N'COLUMN',@level2name=N'BelongId' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属类型(1职位 2角色)', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserBelong', @level2type=N'COLUMN',@level2name=N'BelongType'