-- ----------------------------
-- Table structure for SysApiAuthorize
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysApiAuthorize]') AND type IN ('U'))
	DROP TABLE [dbo].[SysApiAuthorize]
GO

CREATE TABLE [dbo].[SysApiAuthorize] (
  [Id] bigint  NOT NULL,
  [Url] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Authorize] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysApiAuthorize] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'请求接口',
'SCHEMA', N'dbo',
'TABLE', N'SysApiAuthorize',
'COLUMN', N'Url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单权限标识',
'SCHEMA', N'dbo',
'TABLE', N'SysApiAuthorize',
'COLUMN', N'Authorize'
GO

EXEC sp_addextendedproperty
'MS_Description', N'接口权限',
'SCHEMA', N'dbo',
'TABLE', N'SysApiAuthorize'
GO


-- ----------------------------
-- Records of SysApiAuthorize
-- ----------------------------
INSERT INTO [dbo].[SysApiAuthorize] ([Id], [Url], [Authorize]) VALUES (N'46049625945280512', N'/SystemManage/LogApi/GetPageListJson', N'system:logapi:search')
GO


-- ----------------------------
-- Table structure for SysCodeTemplet
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysCodeTemplet]') AND type IN ('U'))
	DROP TABLE [dbo].[SysCodeTemplet]
GO

CREATE TABLE [dbo].[SysCodeTemplet] (
  [Id] bigint  NOT NULL,
  [Code] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [Remark] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Flag] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Type] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysCodeTemplet] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'代码',
'SCHEMA', N'dbo',
'TABLE', N'SysCodeTemplet',
'COLUMN', N'Code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysCodeTemplet',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标识',
'SCHEMA', N'dbo',
'TABLE', N'SysCodeTemplet',
'COLUMN', N'Flag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'代码类型（cs java html 等）',
'SCHEMA', N'dbo',
'TABLE', N'SysCodeTemplet',
'COLUMN', N'Type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'代码生成模板',
'SCHEMA', N'dbo',
'TABLE', N'SysCodeTemplet'
GO


-- ----------------------------
-- Records of SysCodeTemplet
-- ----------------------------
INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368218067537920', N'using Furion.DatabaseAccessor;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using {项目名称}.Util.Helper;

namespace {项目名称}.Entity
{
{描述}
    [Table("{表名称}")]
    public partial class {类名} : IEntity<MasterDbContextLocator>
    {
{字段}
    }
}', N'实体类', N'Entity', N'csharp')
GO

INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368219082559488', N'using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using {项目名称}.Util.Helper;
using Newtonsoft.Json;

namespace {项目名称}.Model.Param.{命名空间}
{
{描述}
    public class {类名}
    {
{字段}
    }
}', N'查询类', N'ListParam', N'csharp')
GO

INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368219468435456', N'using Furion.DatabaseAccessor;
using Furion.DependencyInjection;
using Furion.LinqBuilder;
using Furion.Utilities;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.EntityFrameworkCore;
using EFCore.BulkExtensions;
using {项目名称}.Entity;
using {项目名称}.IService.{命名空间};
using {项目名称}.Model.Param.{命名空间};
using {项目名称}.Util;
using {项目名称}.Util.Helper;
using {项目名称}.Util.Model;

namespace {项目名称}.Service.{命名空间}
{
{描述}
    public class {类名} : I{类名}, ITransient
    {
        private readonly IRepository<{实体类名}> _{驼峰实体类名}DB;

        public {类名}(IRepository<{实体类名}> {驼峰实体类名}DB)
        {
            _{驼峰实体类名}DB = {驼峰实体类名}DB;
        }

        #region 获取数据

        /// <summary>
        /// 带条件查询所有
        /// </summary>
        public async Task<List<{实体类名}>> GetList({查询类名} param)
        {
            IQueryable<{实体类名}> query =  ListFilter(param);
            var data = await query.ToListAsync();
            return data;
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        public async Task<List<{实体类名}>> GetPageList({查询类名} param, Pagination pagination)
        {
            IQueryable<{实体类名}> query =  ListFilter(param);
            var data = await query.OrderByDescending(a => a.Id).ToPagedListAsync(pagination.PageIndex, pagination.PageSize);

            // 分页参数赋值
            pagination.TotalCount = data.TotalCount;
            return data.Items.ToList();
        }

        /// <summary>
        /// 根据ID获取对象
        /// </summary>
        public async Task<{实体类名}> GetEntity(long id)
        {
            var list = await _{驼峰实体类名}DB.AsAsyncEnumerable(p => p.Id == id);
            return list.FirstOrDefault();
        }

        public async Task<int> GetMaxSort()
        {
            object result = await "SELECT MAX(positionSort) FROM {实体类名}".SqlNonQueryAsync();
            int sort = result.ParseToInt();
            sort++;
            return sort;
        }

        /// <summary>
        /// 查询多个ID主键数据
        /// </summary>
        public async Task<List<{实体类名}>> GetListByIds(string ids)
        {
            if (ids.IsNullOrEmpty())
                throw new Exception("参数不合法！");

            var idArr = TextHelper.SplitToArray<long>(ids, '','').ToList();
            var data = await _{驼峰实体类名}DB.AsAsyncEnumerable(a => idArr.Contains(a.Id.GetValueOrDefault()));

            return data;
        }

        #endregion

        #region 提交数据

        public async Task SaveForm({实体类名} entity)
        {
            if (entity.Id.IsNullOrZero())
            {
                // 默认赋值
                entity.Id = IdGeneratorHelper.Instance.GetId();
                await _{驼峰实体类名}DB.InsertNowAsync(entity);
            }
            else
            {
                await _{驼峰实体类名}DB.UpdateNowAsync(entity, true);
            }
        }

        public async Task DeleteForm(string ids)
        {
            if(string.IsNullOrWhiteSpace(ids))
                throw new Exception("参数不合法！");

            var _ids = ids.Split(",");
            await _{驼峰实体类名}DB.Where(a => _ids.Contains(a.Id.ToString())).BatchDeleteAsync();
        }

        #endregion

        #region 私有方法
        private IQueryable<{实体类名}> ListFilter({查询类名} param)
        {
            IQueryable<{实体类名}> query = _{驼峰实体类名}DB.AsQueryable();
            if (param != null)
            {
{查询条件}
            }
            return query;
        }

        #endregion
    }
}', N'数据服务类', N'Service', N'csharp')
GO

INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368219850117120', N'using Furion.DependencyInjection;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using {项目名称}.Entity;
using {项目名称}.IBusiness.{命名空间};
using {项目名称}.IService.{命名空间};
using {项目名称}.Model.Param.{命名空间};
using {项目名称}.Util;
using {项目名称}.Util.Model;

namespace {项目名称}.Business.{命名空间}
{
{描述}
    public class {类名}: I{类名}, ITransient
    {
        private I{数据服务类名} _{驼峰数据服务类名};
        
        public {类名}(I{数据服务类名} {驼峰数据服务类名})
        {
            _{驼峰数据服务类名} = {驼峰数据服务类名};
        }

        #region 获取数据

        public async Task<TData<List<{实体类名}>>> GetList({查询类名} param)
        {
            TData<List<{实体类名}>> obj = new TData<List<{实体类名}>>();
            obj.Data = await _{驼峰数据服务类名}.GetList(param);
            obj.Tag = 1;
            return obj;
        }

        public async Task<TData<List<{实体类名}>>> GetPageList({查询类名} param, Pagination pagination)
        {
            TData<List<{实体类名}>> obj = new TData<List<{实体类名}>>();
            obj.Data = await _{驼峰数据服务类名}.GetPageList(param, pagination);
            obj.Total = pagination.TotalCount;
            obj.Tag = 1;
            return obj;
        }

        public async Task<TData<{实体类名}>> GetEntity(long id)
        {
            TData<{实体类名}> obj = new TData<{实体类名}>();
            obj.Data = await _{驼峰数据服务类名}.GetEntity(id);
            obj.Tag = 1;
            return obj;
        }

        #endregion

        #region 提交数据

        public async Task<TData<string>> SaveForm({实体类名} entity)
        {
            TData<string> obj = new TData<string>();
            await _{驼峰数据服务类名}.SaveForm(entity);
            obj.Data = entity.Id.ParseToString();
            obj.Tag = 1;
            return obj;
        }

        public async Task<TData> DeleteForm(string ids)
        {
            TData obj = new TData();
            await _{驼峰数据服务类名}.DeleteForm(ids);
            obj.Tag = 1;
            return obj;
        }

        #endregion
    }
}', N'业务类', N'BLL', N'csharp')
GO

INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368220223410176', N'using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using {项目名称}.Entity;
using {项目名称}.Model.Param.{命名空间};
using {项目名称}.Util;
using {项目名称}.Util.Model;

namespace {项目名称}.IService.{命名空间}
{
{描述}
    public interface I{类名}
    {
        #region 获取数据

        Task<List<{实体类名}>> GetList({查询类名} param);

        Task<List<{实体类名}>> GetPageList({查询类名} param, Pagination pagination);

        Task<{实体类名}> GetEntity(long id);

        #endregion

        #region 提交数据

        Task SaveForm({实体类名} entity);

        Task DeleteForm(string ids);

        #endregion

        #region 私有方法

        #endregion
    }
}', N'数据服务接口', N'IService', N'csharp')
GO

INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368220596703232', N'using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using {项目名称}.Entity;
using {项目名称}.Model.Param.{命名空间};
using {项目名称}.Util.Model;

namespace {项目名称}.IBusiness.{命名空间}
{
    public interface I{类名}
    {
        #region 获取数据

        Task<TData<List<{实体类名}>>> GetList({查询类名} param);

        Task<TData<List<{实体类名}>>> GetPageList({查询类名} param, Pagination pagination);

        Task<TData<{实体类名}>> GetEntity(long id);

        #endregion

        #region 提交数据

        Task<TData<string>> SaveForm({实体类名} entity);

        Task<TData> DeleteForm(string ids);

        #endregion
    }
}', N'业务接口', N'IBLL', N'csharp')
GO

INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368220965801984', N'using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using {项目名称}.Entity;
using {项目名称}.IBusiness.{命名空间};
using {项目名称}.Model.Param.{命名空间};
using {项目名称}.Util.Model;
using {项目名称}.WebApi.Areas;

namespace {项目名称}.WebApi.Areas.{命名空间}
{
{描述}
    [Route("{命名空间}/[controller]")]
    public class {类名} : BaseController
    {
        private readonly I{业务类名} _{驼峰业务类名};

        public {类名}(I{业务类名} {驼峰业务类名})
        {
            _{驼峰业务类名} = {驼峰业务类名};
        }

        #region 获取数据

        /// <summary>
        /// 条件查询
        /// </summary>
        [HttpGet]
        public async Task<TData<List<{实体类名}>>> GetListJson([FromQuery] {查询类名} param)
        {
            TData<List<{实体类名}>> obj = await _{驼峰业务类名}.GetList(param);
            return obj;
        }

        /// <summary>
        /// 条件查询-分页
        /// </summary>
        [HttpGet]
        public async Task<TData<List<{实体类名}>>> GetPageListJson([FromQuery] {查询类名} param, [FromQuery] Pagination pagination)
        {
            TData<List<{实体类名}>> obj = await _{驼峰业务类名}.GetPageList(param, pagination);
            return obj;
        }

        /// <summary>
        /// 根据ID查询
        /// </summary>
        [HttpGet]
        public async Task<TData<{实体类名}>> GetFormJson([FromQuery] long id)
        {
            TData<{实体类名}> obj = await _{驼峰业务类名}.GetEntity(id);
            return obj;
        }

        #endregion

        #region 提交数据

        /// <summary>
        /// 新增/修改 数据
        /// </summary>
        [HttpPost]
        public async Task<TData<string>> SaveFormJson([FromForm] {实体类名} entity)
        {
            TData<string> obj = await _{驼峰业务类名}.SaveForm(entity);
            return obj;
        }

        /// <summary>
        /// 删除数据
        /// </summary>
        [HttpPost]
        public async Task<TData> DeleteFormJson([FromForm] string ids)
        {
            TData obj = await _{驼峰业务类名}.DeleteForm(ids);
            return obj;
        }

        #endregion
    }
}', N'控制器', N'Controller', N'csharp')
GO

INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368221347483648', N'<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="/assets/libs/layui/css/layui.css" />
    <link rel="stylesheet" href="/assets/module/admin.css">
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
    <style>
        {启用搜索}
    </style>
</head>
<body>
    <!-- 主体部分 -->
    <div class="layui-fluid">
        <div class="layui-card">
            <div class="layui-card-body">
                <!-- 表格工具栏 -->
                <form class="layui-form toolbar searchbar">
                    <div class="layui-form-item">

{查询条件}

                        <div class="layui-inline">
                            &emsp;
                            <button class="layui-btn icon-btn" lay-filter="TbSearch" lay-submit>
                                <i class="layui-icon">&#xe615;</i>搜索
                            </button>
                        </div>
                    </div>
                </form>
                <!-- 数据表格 -->
                <table id="gridTable" lay-filter="gridTable"></table>
            </div>
        </div>
    </div>

    <!-- 表格操作列 -->
    <script type="text/html" id="toolbar">
        {新增按钮}
        {修改按钮}
        {删除按钮}
    </script>

    <!-- js部分 -->
    <script src="/assets/libs/jquery/jquery-3.2.1.min.js"></script>
    <script src="/assets/libs/layui/layui.js"></script>
    <script src="/assets/js/utils.js"></script>
    <script src="/assets/js/main.js"></script>
    <script>

        // 全局变量
        var table;

        layui.use([''layer'', ''form'', ''table'', ''util'', ''admin'', ''setter''], function () {
            var $ = layui.jquery;
            var layer = layui.layer;
            var form = layui.form;
            table = layui.table;
            var util = layui.util;
            var admin = layui.admin;
            var setter = layui.setter;

            // 表格初始化
            layuiTableSet(table, setter);

            /* 渲染表格 */
            var insTb = table.render({
                elem: ''#gridTable'',
                url: setter.baseServer() + ''/{命名空间}/{类名前缀}/GetPageListJson'',
                page: true,
                toolbar: "#toolbar",
                cols: [[
                    { type: ''checkbox'' },
                    { type: ''numbers'' },
{表格列}
                ]]
            });

            /* 表格搜索 */
            form.on(''submit(TbSearch)'', function (data) {
                insTb.reload({ where: data.field, page: { curr: 1 } });
                return false;
            });

            /* 表格头工具栏点击事件 */
            table.on(''toolbar(gridTable)'', function (obj) {
                if (obj.event === ''add'') { // 添加
                    showEditModel();
                } else if (obj.event === ''edit'') { // 修改
                    var checkRows = table.checkStatus(''gridTable'');
                    if (checkRows.data.length === 0 || checkRows.data.length > 1) {
                        layer.msg(''请选择且只选择一条数据'', { icon: 2 });
                        return;
                    }
                    showEditModel(checkRows.data[0]);
                } else if (obj.event === ''del'') { // 删除
                    var checkRows = table.checkStatus(''gridTable'');
                    if (checkRows.data.length === 0) {
                        layer.msg(''请选择要删除的数据'', { icon: 2 });
                        return;
                    }
                    var ids = checkRows.data.map(function (d) {
                        return d.Id;
                    });
                    doDel({ ids: ids });
                }
            });

            /* 显示表单弹窗 */
            function showEditModel(mData) {
                var id = 0;
                if (mData != undefined && mData != null) { id = mData.Id; }
                admin.open({
                    type: 2,
                    area: [''768px'', ''600px''],
                    title: (mData ? ''修改'' : ''添加''),
                    content: ''{驼峰类名前缀}Form.html?id='' + id,
                });
            }

            /* 删除 */
            function doDel(obj) {
                layer.confirm(''确定要删除选中数据吗？'', {
                    skin: ''layui-layer-admin'',
                    shade: .1
                }, function (i) {
                    layer.close(i);
                    var loadIndex = layer.load(2);
                    admin.req(''/{命名空间}/{类名前缀}/DeleteFormJson'', {
                        ids: obj.ids ? obj.ids.join('','') : ''''
                    }, function (res) {
                        layer.close(loadIndex);
                        if (1 === res.Tag) {
                            layer.msg("操作成功", { icon: 1 });
                            insTb.reload({ page: { curr: 1 } });
                        } else {
                            layer.msg(res.Message, { icon: 2 });
                        }
                    }, ''post'');
                });
            }

        });
    </script>
</body>
</html>', N'列表页面', N'Index', N'html')
GO

INSERT INTO [dbo].[SysCodeTemplet] ([Id], [Code], [Remark], [Flag], [Type]) VALUES (N'45368221750136832', N'<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="/assets/libs/layui/css/layui.css" />
    <link rel="stylesheet" href="/assets/module/admin.css?v=318">
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
    <style>
        .form-div {
            padding: 20px;
            background-color: white;
            margin: 15px;
        }
    </style>
</head>
<body>
    <div class="layui-row form-div">
        <form id="dataform" lay-filter="dataform" class="layui-form model-form">

{表单控件}
          
            <div class="layui-form-item text-right">
                <button class="layui-btn" lay-filter="formSubmit" lay-submit>保存</button>
                <button class="layui-btn layui-btn-primary" type="button" id="btn-cancel">取消</button>
            </div>
        </form>
    </div>

    <!-- 初始加载动画 -->
    <div class="page-loading">
        <div class="signal-loader">
            <span></span><span></span><span></span><span></span>
        </div>
    </div>

    <!-- js部分 -->
    <script src="/assets/libs/jquery/jquery-3.2.1.min.js"></script>
    <script src="/assets/libs/layui/layui.js"></script>
    <script src="/assets/js/utils.js"></script>
    <script src="/assets/js/main.js"></script>
    <script type="text/javascript">
        var id = getRequestData("id");

        layui.use([''layer'', ''form'', ''admin'', ''laydate'', ''formX''], function () {
            var layer = layui.layer;
            var form = layui.form;
            var admin = layui.admin;
            var formX = layui.formX;
            var laydate = layui.laydate;

            /* // 时间弹窗模板
            laydate.render({
                elem: ''#StartTime''
                , type: ''datetime''
                , trigger: ''click''
            });
            */

            // 初始化
            if (id > 0) {
                admin.req(''/{命名空间}/{类名前缀}/GetFormJson'', { id: id }, function (res) {
                    admin.removeLoading();
                    if (res.Tag == 1) {
                        form.val(''dataform'', res.Data);
                    }
                }, ''get'');
            } else {
                admin.removeLoading();
            }

            // 表单提交
            form.on(''submit(formSubmit)'', function (data) {
                data.field.Id = id;
                admin.showLoading(''body'', 3, ''.8'');

                admin.req(''/{命名空间}/{类名前缀}/SaveFormJson'', data.field, function (res) {
                    admin.removeLoading(''body'', true, true);
                    if (res.Tag == 1) {
                        parent.layer.msg(''操作成功'', { icon: 1, time: 1500 });
                        parent.table.reload(''gridTable'');
                        parent.layer.close(parent.layer.getFrameIndex(window.name));
                    }
                    else {
                        layer.msg(res.Message, { icon: 2 });
                    }
                }, ''post'');

                return false;
            });

            // 关闭当前页面
            $("#btn-cancel").click(function () {
                var index = parent.layer.getFrameIndex(window.name); 
                parent.layer.close(index); 
            });
        });
    </script>
</body>
</html>', N'表单页面', N'Form', N'html')
GO


-- ----------------------------
-- Table structure for SysDataDict
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysDataDict]') AND type IN ('U'))
	DROP TABLE [dbo].[SysDataDict]
GO

CREATE TABLE [dbo].[SysDataDict] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NULL,
  [CreatorId] bigint  NULL,
  [DictType] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DictSort] int  NULL,
  [Remark] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysDataDict] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典类型',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDict',
'COLUMN', N'DictType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典排序',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDict',
'COLUMN', N'DictSort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDict',
'COLUMN', N'Remark'
GO


-- ----------------------------
-- Records of SysDataDict
-- ----------------------------
INSERT INTO [dbo].[SysDataDict] ([Id], [CreateTime], [CreatorId], [DictType], [DictSort], [Remark]) VALUES (N'16508640061124399', N'2019-01-05 07:15:41.000', N'0', N'NewsType', N'1', N'新闻类别')
GO


-- ----------------------------
-- Table structure for SysDataDictDetail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysDataDictDetail]') AND type IN ('U'))
	DROP TABLE [dbo].[SysDataDictDetail]
GO

CREATE TABLE [dbo].[SysDataDictDetail] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NULL,
  [DictType] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DictSort] int  NULL,
  [DictKey] int  NULL,
  [DictValue] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [ListClass] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DictStatus] int  NULL,
  [IsDefault] int  NULL,
  [Remark] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysDataDictDetail] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典类型(外键)',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDictDetail',
'COLUMN', N'DictType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典排序',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDictDetail',
'COLUMN', N'DictSort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典键(一般从1开始)',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDictDetail',
'COLUMN', N'DictKey'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典值',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDictDetail',
'COLUMN', N'DictValue'
GO

EXEC sp_addextendedproperty
'MS_Description', N'显示样式(default primary success info warning danger)',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDictDetail',
'COLUMN', N'ListClass'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典状态(0禁用 1启用)',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDictDetail',
'COLUMN', N'DictStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'默认选中(0不是 1是)',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDictDetail',
'COLUMN', N'IsDefault'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysDataDictDetail',
'COLUMN', N'Remark'
GO


-- ----------------------------
-- Records of SysDataDictDetail
-- ----------------------------
INSERT INTO [dbo].[SysDataDictDetail] ([Id], [CreateTime], [DictType], [DictSort], [DictKey], [DictValue], [ListClass], [DictStatus], [IsDefault], [Remark]) VALUES (N'16508640061124400', N'2019-01-05 07:16:12.000', N'NewsType', N'1', N'1', N'产品案例', N'primary', N'1', N'1', N'')
GO

INSERT INTO [dbo].[SysDataDictDetail] ([Id], [CreateTime], [DictType], [DictSort], [DictKey], [DictValue], [ListClass], [DictStatus], [IsDefault], [Remark]) VALUES (N'16508640061124401', N'2019-01-05 07:16:25.000', N'NewsType', N'2', N'2', N'行业新闻', N'warning', N'1', N'0', N'')
GO


-- ----------------------------
-- Table structure for SysDepartment
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysDepartment]') AND type IN ('U'))
	DROP TABLE [dbo].[SysDepartment]
GO

CREATE TABLE [dbo].[SysDepartment] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatorId] bigint  NOT NULL,
  [ParentId] bigint  NULL,
  [DepartmentName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Telephone] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Fax] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Email] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [PrincipalId] bigint  NULL,
  [DepartmentSort] int  NULL,
  [Remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [Enable] bit DEFAULT ((1)) NULL,
  [PrincipalPhone] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DepartmentCode] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysDepartment] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'父部门Id(0表示是根部门)',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'ParentId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门名称',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'DepartmentName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门电话',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'Telephone'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门传真',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'Fax'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门Email',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'Email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门负责人Id',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'PrincipalId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门排序',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'DepartmentSort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否启用',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'Enable'
GO

EXEC sp_addextendedproperty
'MS_Description', N'负责人电话',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'PrincipalPhone'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门编号',
'SCHEMA', N'dbo',
'TABLE', N'SysDepartment',
'COLUMN', N'DepartmentCode'
GO


-- ----------------------------
-- Records of SysDepartment
-- ----------------------------
INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124402', N'2018-10-10 01:00:00.000', N'0', NULL, N'主公司', N'0551-6666666', N'0551-8888888', NULL, NULL, N'1', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124403', N'2018-10-10 01:00:00.000', N'0', N'16508640061124402', N'一号子公司', N'111', N'11', N'11', N'16508640061130151', N'1', N'', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124404', N'2018-10-10 01:00:00.000', N'0', N'16508640061124402', N'二号子公司', N'1', N'', N'', N'16505640061130150', N'1', N'', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124405', N'2018-10-10 01:00:00.000', N'0', N'16508640061124403', N'研发部', N'3', N'', N'', N'16508640061130153', N'1', N'专注前端与后端结合的开发模式', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124406', N'2018-10-10 01:00:00.000', N'0', N'16508640061124403', N'测试部', N'1', N'', N'', N'0', N'3', N'', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124407', N'2018-10-10 01:00:00.000', N'0', N'16508640061124403', N'前端设计部', N'1', N'', N'', N'16508640061130150', N'2', N'', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124408', N'2018-12-22 18:36:58.000', N'0', N'16508640061124403', N'财务部', N'0551-87654321', N'0551-12345678', N'wangxue@yishasoft.com', N'0', N'15', N'2', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124409', N'2018-12-22 18:47:42.000', N'0', N'16508640061124403', N'市场部', N'', N'', N'', N'0', N'7', N'', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysDepartment] ([Id], [CreateTime], [CreatorId], [ParentId], [DepartmentName], [Telephone], [Fax], [Email], [PrincipalId], [DepartmentSort], [Remark], [Enable], [PrincipalPhone], [DepartmentCode]) VALUES (N'16508640061124410', N'2018-12-22 18:48:02.000', N'0', N'16508640061124403', N'行政部', N'', N'', N'', N'0', N'10', N'', N'1', N'', N'')
GO


-- ----------------------------
-- Table structure for SysLogApi
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysLogApi]') AND type IN ('U'))
	DROP TABLE [dbo].[SysLogApi]
GO

CREATE TABLE [dbo].[SysLogApi] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NULL,
  [CreatorId] bigint  NULL,
  [LogStatus] int  NULL,
  [Remark] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [ExecuteUrl] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [ExecuteParam] nvarchar(4000) COLLATE Chinese_PRC_CI_AS  NULL,
  [ExecuteResult] nvarchar(4000) COLLATE Chinese_PRC_CI_AS  NULL,
  [ExecuteTime] int  NULL,
  [IpAddress] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysLogApi] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行状态(0失败 1成功)',
'SCHEMA', N'dbo',
'TABLE', N'SysLogApi',
'COLUMN', N'LogStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysLogApi',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'接口地址',
'SCHEMA', N'dbo',
'TABLE', N'SysLogApi',
'COLUMN', N'ExecuteUrl'
GO

EXEC sp_addextendedproperty
'MS_Description', N'请求参数',
'SCHEMA', N'dbo',
'TABLE', N'SysLogApi',
'COLUMN', N'ExecuteParam'
GO

EXEC sp_addextendedproperty
'MS_Description', N'请求结果',
'SCHEMA', N'dbo',
'TABLE', N'SysLogApi',
'COLUMN', N'ExecuteResult'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行时间',
'SCHEMA', N'dbo',
'TABLE', N'SysLogApi',
'COLUMN', N'ExecuteTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'IP地址',
'SCHEMA', N'dbo',
'TABLE', N'SysLogApi',
'COLUMN', N'IpAddress'
GO


-- ----------------------------
-- Records of SysLogApi
-- ----------------------------

-- ----------------------------
-- Table structure for SysLogLogin
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysLogLogin]') AND type IN ('U'))
	DROP TABLE [dbo].[SysLogLogin]
GO

CREATE TABLE [dbo].[SysLogLogin] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatorId] bigint  NULL,
  [LogStatus] int  NOT NULL,
  [IpAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [IpLocation] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Browser] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [OS] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Remark] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [ExtraRemark] nvarchar(500) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysLogLogin] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行状态(0失败 1成功)',
'SCHEMA', N'dbo',
'TABLE', N'SysLogLogin',
'COLUMN', N'LogStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'ip地址',
'SCHEMA', N'dbo',
'TABLE', N'SysLogLogin',
'COLUMN', N'IpAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'ip位置',
'SCHEMA', N'dbo',
'TABLE', N'SysLogLogin',
'COLUMN', N'IpLocation'
GO

EXEC sp_addextendedproperty
'MS_Description', N'浏览器',
'SCHEMA', N'dbo',
'TABLE', N'SysLogLogin',
'COLUMN', N'Browser'
GO

EXEC sp_addextendedproperty
'MS_Description', N'操作系统',
'SCHEMA', N'dbo',
'TABLE', N'SysLogLogin',
'COLUMN', N'OS'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysLogLogin',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'额外备注',
'SCHEMA', N'dbo',
'TABLE', N'SysLogLogin',
'COLUMN', N'ExtraRemark'
GO


-- ----------------------------
-- Records of SysLogLogin
-- ----------------------------

-- ----------------------------
-- Table structure for SysMenu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysMenu]') AND type IN ('U'))
	DROP TABLE [dbo].[SysMenu]
GO

CREATE TABLE [dbo].[SysMenu] (
  [Id] bigint  NOT NULL,
  [ParentId] bigint  NULL,
  [MenuName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [MenuIcon] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [MenuUrl] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [MenuTarget] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [MenuSort] int  NULL,
  [MenuType] int  NULL,
  [MenuStatus] int  NULL,
  [Authorize] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Remark] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysMenu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'父菜单Id(0表示是根菜单)',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'ParentId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单名称',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'MenuName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单图标',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'MenuIcon'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单Url',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'MenuUrl'
GO

EXEC sp_addextendedproperty
'MS_Description', N'链接打开方式',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'MenuTarget'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单排序',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'MenuSort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单类型(1目录 2页面 3按钮)',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'MenuType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单状态(0禁用 1启用)',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'MenuStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单权限标识',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'Authorize'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysMenu',
'COLUMN', N'Remark'
GO


-- ----------------------------
-- Records of SysMenu
-- ----------------------------
INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130069', N'0', N'单位组织', N'layui-icon layui-icon-user', N'', N'', N'1', N'1', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130070', N'0', N'系统管理', N'layui-icon layui-icon-set', N'', N'', N'2', N'1', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130071', N'0', N'系统工具', N'layui-icon layui-icon-util', N'', N'', N'3', N'1', N'1', N'', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130072', N'16508640061130069', N'员工管理', NULL, N'#/organization/user/userIndex', N'', N'1', N'2', N'1', N'organization:user:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130073', N'16508640061130069', N'部门管理', N'', N'#/organization/department/departmentIndex', N'', N'2', N'2', N'1', N'organization:department:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130074', N'16508640061130070', N'系统角色', N'layui-icon ', N'#/system/role/roleIndex', N'', N'1', N'2', N'1', N'system:role:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130075', N'16508640061130070', N'系统菜单', N'layui-icon ', N'#/system/menu/menuIndex', N'', N'2', N'2', N'1', N'system:menu:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130076', N'16508640061130070', N'系统日志', N'layui-icon layui-icon-align-left', NULL, N'', N'10', N'1', N'1', NULL, N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130077', N'16508640061130070', N'通用字典', NULL, N'#/system/datadict/datadictIndex', N'', N'5', N'2', N'1', N'system:datadict:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130078', N'16508640061130070', N'行政区划', NULL, N'#/system/area/areaIndex', N'', N'7', N'2', N'1', N'system:area:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130079', N'16508640061130070', N'数据表管理', NULL, N'#/system/database/databaseIndex', N'', N'14', N'2', N'1', N'system:datatable:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130080', N'16508640061130071', N'代码生成', N'', N'#/tool/codeGenerator/codeGeneratorIndex', N'', N'1', N'2', N'1', N'tool:codegenerator:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130082', N'16508640061130076', N'登录日志', NULL, N'#/system/logLogin/logLoginIndex', N'', N'1', N'2', N'1', N'system:loglogin:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130083', N'16508640061130069', N'职位管理', N'', N'#/organization/position/positionIndex', N'', N'3', N'2', N'1', N'organization:position:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130084', N'16508640061130072', N'员工查询', N'', N'', N'', N'1', N'3', N'1', N'organization:user:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130085', N'16508640061130072', N'员工新增', N'', N'', N'', N'2', N'3', N'1', N'organization:user:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130086', N'16508640061130072', N'员工修改', N'', N'', N'', N'3', N'3', N'1', N'organization:user:edit', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130087', N'16508640061130072', N'员工删除', N'', N'', N'', N'4', N'3', N'1', N'organization:user:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130088', N'16508640061130072', N'员工导出', N'', N'', N'', N'5', N'3', N'1', N'organization:user:export', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130089', N'16508640061130072', N'重置密码', N'', N'', N'', N'6', N'3', N'1', N'system:user:resetpassword', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130090', N'16508640061130073', N'部门查询', N'', N'', N'', N'1', N'3', N'1', N'organization:department:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130091', N'16508640061130073', N'部门新增', N'', N'', N'', N'2', N'3', N'1', N'organization:department:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130092', N'16508640061130073', N'部门修改', N'', N'', N'', N'3', N'3', N'1', N'organization:department:edit', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130093', N'16508640061130073', N'部门删除', N'', N'', N'', N'4', N'3', N'1', N'organization:department:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130094', N'16508640061130083', N'职位查询', N'', N'', N'', N'1', N'3', N'1', N'organization:position:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130095', N'16508640061130083', N'职位新增', N'', N'', N'', N'2', N'3', N'1', N'organization:position:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130096', N'16508640061130083', N'职位修改', N'', N'', N'', N'3', N'3', N'1', N'organization:position:edit', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130097', N'16508640061130083', N'职位删除', N'', N'', N'', N'4', N'3', N'1', N'organization:position:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130098', N'16508640061130074', N'角色查询', N'', N'', N'', N'1', N'3', N'1', N'system:role:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130099', N'16508640061130074', N'角色新增', N'', N'', N'', N'2', N'3', N'1', N'system:role:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130100', N'16508640061130074', N'角色修改', N'', N'', N'', N'3', N'3', N'1', N'system:role:edit', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130101', N'16508640061130074', N'角色删除', N'', N'', N'', N'4', N'3', N'1', N'system:role:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130102', N'16508640061130075', N'菜单查询', N'', N'', N'', N'1', N'3', N'1', N'system:menu:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130103', N'16508640061130075', N'菜单新增', N'', N'', N'', N'2', N'3', N'1', N'system:menu:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130104', N'16508640061130075', N'菜单修改', N'', N'', N'', N'3', N'3', N'1', N'system:menu:edit', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130105', N'16508640061130075', N'菜单删除', N'', N'', N'', N'4', N'3', N'1', N'system:menu:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130106', N'16508640061130077', N'字典查询', N'', N'', N'', N'1', N'3', N'1', N'system:datadict:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130107', N'16508640061130077', N'字典新增', N'', N'', N'', N'2', N'3', N'1', N'system:datadict:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130108', N'16508640061130077', N'字典修改', N'', N'', N'', N'3', N'3', N'1', N'system:datadict:edit', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130109', N'16508640061130077', N'字典删除', N'', N'', N'', N'4', N'3', N'1', N'system:datadict:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130110', N'16508640061130078', N'地区查询', N'', N'', N'', N'1', N'3', N'1', N'system:area:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130111', N'16508640061130078', N'地区新增', N'', N'', N'', N'2', N'3', N'1', N'system:area:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130112', N'16508640061130078', N'地区修改', N'', N'', N'', N'3', N'3', N'1', N'system:area:edit', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130113', N'16508640061130078', N'地区删除', N'', N'', N'', N'4', N'3', N'1', N'system:area:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130114', N'16508640061130082', N'登录日志查询', N'', N'', N'', N'1', N'3', N'1', N'system:loglogin:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130115', N'16508640061130082', N'登录日志删除', N'', N'', N'', N'2', N'3', N'1', N'system:loglogin:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130118', N'16508640061130079', N'数据表查询', N'', N'', N'', N'1', N'3', N'1', N'system:datatable:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130119', N'16508640061130080', N'代码生成新增', N'', N'', N'', N'2', N'3', N'1', N'tool:codegenerator:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130120', N'16508640061130080', N'代码生成查询', N'', N'', N'', N'1', N'3', N'1', N'tool:codegenerator:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130121', N'16508640061130071', N'服务器信息', NULL, N'#/tool/server/serverIndex', N'', N'15', N'2', N'1', N'tool:server:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130122', N'16508640061130070', N'定时任务', NULL, N'#/system/autoJob/autoJobIndex', N'', N'12', N'2', N'1', N'system:autojob:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130123', N'16508640061130122', N'定时任务查询', N'', N'', N'', N'1', N'3', N'1', N'system:autojob:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130124', N'16508640061130122', N'定时任务新增', N'', N'', N'', N'2', N'3', N'1', N'system:autojob:add', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130125', N'16508640061130122', N'定时任务修改', N'', N'', N'', N'3', N'3', N'1', N'system:autojob:edit', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130126', N'16508640061130122', N'定时任务删除', N'', N'', N'', N'4', N'3', N'1', N'system:autojob:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130127', N'16508640061130122', N'定时任务暂停', N'', N'', N'', N'5', N'3', N'1', N'system:autojob:pause', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130128', N'16508640061130122', N'定时任务日志查看', N'', N'', N'', N'6', N'3', N'1', N'system:autojob:logview', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130134', N'16508640061130070', N'系统api', N'layui-icon ', N'#/api', N'', N'13', N'2', N'1', N'system:api:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130135', N'16508640061130076', N'Api日志', NULL, N'#/system/logApi/logApiIndex', N'', N'3', N'2', N'1', N'system:logapi:view', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130136', N'16508640061130135', N'Api日志查询', N'', N'', N'', N'1', N'3', N'1', N'system:logapi:search', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'16508640061130137', N'16508640061130135', N'Api日志删除', N'', N'', N'', N'2', N'3', N'1', N'system:logapi:delete', N'')
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'260867164880244736', N'16508640061130070', N'缓存管理', NULL, N'#/system/cache/cacheIndex', NULL, N'14', N'1', N'1', NULL, NULL)
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'261771075572994048', N'16508640061130070', N'MQTT主题订阅', NULL, N'#/system/mqttTheme/mqttThemeIndex', NULL, N'16', N'2', N'1', N'system:mqtttheme:view', NULL)
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'261771076357328896', N'261771075572994048', N'MQTT主题订阅搜索', NULL, NULL, NULL, N'17', N'3', N'1', N'system:mqtttheme:search', NULL)
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'261771077133275136', N'261771075572994048', N'MQTT主题订阅新增', NULL, NULL, NULL, N'18', N'3', N'1', N'system:mqtttheme:add', NULL)
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'261771077850501120', N'261771075572994048', N'MQTT主题订阅修改', NULL, NULL, NULL, N'19', N'3', N'1', N'system:mqtttheme:edit', NULL)
GO

INSERT INTO [dbo].[SysMenu] ([Id], [ParentId], [MenuName], [MenuIcon], [MenuUrl], [MenuTarget], [MenuSort], [MenuType], [MenuStatus], [Authorize], [Remark]) VALUES (N'261771078534172672', N'261771075572994048', N'MQTT主题订阅删除', NULL, NULL, NULL, N'20', N'3', N'1', N'system:mqtttheme:delete', NULL)
GO


-- ----------------------------
-- Table structure for SysMenuAuthorize
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysMenuAuthorize]') AND type IN ('U'))
	DROP TABLE [dbo].[SysMenuAuthorize]
GO

CREATE TABLE [dbo].[SysMenuAuthorize] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatorId] bigint  NOT NULL,
  [MenuId] bigint  NOT NULL,
  [AuthorizeId] bigint  NOT NULL,
  [AuthorizeType] int  NOT NULL
)
GO

ALTER TABLE [dbo].[SysMenuAuthorize] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单Id',
'SCHEMA', N'dbo',
'TABLE', N'SysMenuAuthorize',
'COLUMN', N'MenuId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'授权Id(角色Id或者用户Id)',
'SCHEMA', N'dbo',
'TABLE', N'SysMenuAuthorize',
'COLUMN', N'AuthorizeId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'授权类型(1角色 2用户)',
'SCHEMA', N'dbo',
'TABLE', N'SysMenuAuthorize',
'COLUMN', N'AuthorizeType'
GO


-- ----------------------------
-- Records of SysMenuAuthorize
-- ----------------------------
INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081509060382720', N'2020-12-06 11:51:27.913', N'16508640061130151', N'16508640061130069', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081509404315648', N'2020-12-06 11:51:27.997', N'16508640061130151', N'16508640061130072', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081509710499840', N'2020-12-06 11:51:28.067', N'16508640061130151', N'16508640061130084', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081510016684032', N'2020-12-06 11:51:28.140', N'16508640061130151', N'16508640061130085', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081510314479616', N'2020-12-06 11:51:28.213', N'16508640061130151', N'16508640061130086', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081510620663808', N'2020-12-06 11:51:28.287', N'16508640061130151', N'16508640061130087', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081510918459392', N'2020-12-06 11:51:28.357', N'16508640061130151', N'16508640061130088', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081511224643584', N'2020-12-06 11:51:28.430', N'16508640061130151', N'16508640061130089', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081511535022080', N'2020-12-06 11:51:28.503', N'16508640061130151', N'16508640061130073', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081511837011968', N'2020-12-06 11:51:28.577', N'16508640061130151', N'16508640061130090', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081512143196160', N'2020-12-06 11:51:28.647', N'16508640061130151', N'16508640061130091', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081512453574656', N'2020-12-06 11:51:28.723', N'16508640061130151', N'16508640061130092', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081512755564544', N'2020-12-06 11:51:28.793', N'16508640061130151', N'16508640061130093', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081513057554432', N'2020-12-06 11:51:28.867', N'16508640061130151', N'16508640061130083', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081513359544320', N'2020-12-06 11:51:28.940', N'16508640061130151', N'16508640061130094', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081513665728512', N'2020-12-06 11:51:29.013', N'16508640061130151', N'16508640061130095', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081513967718400', N'2020-12-06 11:51:29.083', N'16508640061130151', N'16508640061130096', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46081514273902592', N'2020-12-06 11:51:29.157', N'16508640061130151', N'16508640061130097', N'253512862180315136', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123151389757440', N'2020-12-06 14:36:56.220', N'16508640061130151', N'16508640061130069', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123151687553024', N'2020-12-06 14:36:56.290', N'16508640061130151', N'16508640061130072', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123151972765696', N'2020-12-06 14:36:56.357', N'16508640061130151', N'16508640061130084', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123152245395456', N'2020-12-06 14:36:56.423', N'16508640061130151', N'16508640061130085', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123152513830912', N'2020-12-06 14:36:56.487', N'16508640061130151', N'16508640061130086', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123152786460672', N'2020-12-06 14:36:56.553', N'16508640061130151', N'16508640061130070', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123153059090432', N'2020-12-06 14:36:56.617', N'16508640061130151', N'16508640061130076', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123153327525888', N'2020-12-06 14:36:56.680', N'16508640061130151', N'16508640061130135', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123153591767040', N'2020-12-06 14:36:56.743', N'16508640061130151', N'16508640061130136', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'46123153868591104', N'2020-12-06 14:36:56.810', N'16508640061130151', N'16508640061130137', N'16508640061130147', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241783234560', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130069', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241787428864', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130072', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241791623168', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130084', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241800011776', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130085', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241804206080', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130086', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241808400384', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130087', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241812594688', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130088', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241820983296', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130089', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241825177600', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130073', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241829371904', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130090', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241837760512', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130091', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241841954816', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130092', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241850343424', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130093', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241854537728', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130083', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241862926336', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130094', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241871314944', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130095', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241875509248', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130096', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241883897856', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130097', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241892286464', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130129', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241900675072', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130130', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241909063680', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130131', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241913257984', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130132', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'103195241921646592', N'2019-03-01 06:54:31.000', N'16508640061130151', N'16508640061130133', N'103195209390624768', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092413965762560', N'2020-11-26 15:25:15.140', N'0', N'16508640061130069', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092414716542976', N'2020-11-26 15:25:15.320', N'0', N'16508640061130072', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092414955618304', N'2020-11-26 15:25:15.377', N'0', N'16508640061130084', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092415169527808', N'2020-11-26 15:25:15.427', N'0', N'16508640061130085', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092415383437312', N'2020-11-26 15:25:15.480', N'0', N'16508640061130086', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092415593152512', N'2020-11-26 15:25:15.530', N'0', N'16508640061130087', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092415798673408', N'2020-11-26 15:25:15.577', N'0', N'16508640061130088', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092416008388608', N'2020-11-26 15:25:15.627', N'0', N'16508640061130089', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092416222298112', N'2020-11-26 15:25:15.680', N'0', N'16508640061130073', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092416427819008', N'2020-11-26 15:25:15.727', N'0', N'16508640061130090', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092416629145600', N'2020-11-26 15:25:15.777', N'0', N'16508640061130091', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092416834666496', N'2020-11-26 15:25:15.823', N'0', N'16508640061130092', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092417044381696', N'2020-11-26 15:25:15.873', N'0', N'16508640061130093', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092417249902592', N'2020-11-26 15:25:15.923', N'0', N'16508640061130083', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092417455423488', N'2020-11-26 15:25:15.973', N'0', N'16508640061130094', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092417669332992', N'2020-11-26 15:25:16.023', N'0', N'16508640061130095', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092417874853888', N'2020-11-26 15:25:16.073', N'0', N'16508640061130096', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092418088763392', N'2020-11-26 15:25:16.123', N'0', N'16508640061130097', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092418294284288', N'2020-11-26 15:25:16.173', N'0', N'16508640061130070', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092418503999488', N'2020-11-26 15:25:16.223', N'0', N'16508640061130074', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092418722103296', N'2020-11-26 15:25:16.273', N'0', N'16508640061130098', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092418927624192', N'2020-11-26 15:25:16.323', N'0', N'16508640061130099', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092419133145088', N'2020-11-26 15:25:16.373', N'0', N'16508640061130100', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092419351248896', N'2020-11-26 15:25:16.423', N'0', N'16508640061130101', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092419569352704', N'2020-11-26 15:25:16.477', N'0', N'16508640061130075', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092419783262208', N'2020-11-26 15:25:16.527', N'0', N'16508640061130102', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092419992977408', N'2020-11-26 15:25:16.577', N'0', N'16508640061130103', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092420219469824', N'2020-11-26 15:25:16.630', N'0', N'16508640061130104', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092420500488192', N'2020-11-26 15:25:16.700', N'0', N'16508640061130105', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092420714397696', N'2020-11-26 15:25:16.750', N'0', N'16508640061130076', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092420919918592', N'2020-11-26 15:25:16.800', N'0', N'16508640061130082', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092421125439488', N'2020-11-26 15:25:16.847', N'0', N'16508640061130114', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092421326766080', N'2020-11-26 15:25:16.897', N'0', N'16508640061130115', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092421528092672', N'2020-11-26 15:25:16.943', N'0', N'16508640061130135', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092421729419264', N'2020-11-26 15:25:16.990', N'0', N'16508640061130136', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092421939134464', N'2020-11-26 15:25:17.040', N'0', N'16508640061130137', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092422144655360', N'2020-11-26 15:25:17.090', N'0', N'16508640061130077', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092422350176256', N'2020-11-26 15:25:17.140', N'0', N'16508640061130106', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092422551502848', N'2020-11-26 15:25:17.187', N'0', N'16508640061130107', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092422761218048', N'2020-11-26 15:25:17.237', N'0', N'16508640061130108', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092422962544640', N'2020-11-26 15:25:17.287', N'0', N'16508640061130109', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092423163871232', N'2020-11-26 15:25:17.333', N'0', N'16508640061130078', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092423365197824', N'2020-11-26 15:25:17.380', N'0', N'16508640061130110', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092423566524416', N'2020-11-26 15:25:17.430', N'0', N'16508640061130111', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092423772045312', N'2020-11-26 15:25:17.480', N'0', N'16508640061130112', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092423977566208', N'2020-11-26 15:25:17.527', N'0', N'16508640061130113', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092424183087104', N'2020-11-26 15:25:17.577', N'0', N'16508640061130079', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092424388608000', N'2020-11-26 15:25:17.627', N'0', N'16508640061130118', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092424606711808', N'2020-11-26 15:25:17.677', N'0', N'16508640061130122', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092424829009920', N'2020-11-26 15:25:17.730', N'0', N'16508640061130123', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092425038725120', N'2020-11-26 15:25:17.780', N'0', N'16508640061130124', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092425252634624', N'2020-11-26 15:25:17.830', N'0', N'16508640061130125', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092425458155520', N'2020-11-26 15:25:17.880', N'0', N'16508640061130126', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092425655287808', N'2020-11-26 15:25:17.927', N'0', N'16508640061130127', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092425860808704', N'2020-11-26 15:25:17.977', N'0', N'16508640061130128', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092426062135296', N'2020-11-26 15:25:18.023', N'0', N'16508640061130134', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092426276044800', N'2020-11-26 15:25:18.077', N'0', N'16508640061130071', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092426485760000', N'2020-11-26 15:25:18.127', N'0', N'16508640061130080', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092426695475200', N'2020-11-26 15:25:18.177', N'0', N'16508640061130119', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092426900996096', N'2020-11-26 15:25:18.223', N'0', N'16508640061130120', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092427106516992', N'2020-11-26 15:25:18.273', N'0', N'16508640061130121', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092427307843584', N'2020-11-26 15:25:18.320', N'0', N'16508640061131999', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092427513364480', N'2020-11-26 15:25:18.370', N'0', N'16508640061132000', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'252092427727273984', N'2020-11-26 15:25:18.420', N'0', N'16508640061132001', N'16508640061130146', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'258565056382373888', N'2020-12-14 12:05:13.347', N'16508640061130151', N'16508640061130069', N'258201886530736128', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'258565056466259968', N'2020-12-14 12:05:13.370', N'16508640061130151', N'16508640061130072', N'258201886530736128', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'258565056483037184', N'2020-12-14 12:05:13.373', N'16508640061130151', N'16508640061130087', N'258201886530736128', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'258565056491425792', N'2020-12-14 12:05:13.377', N'16508640061130151', N'16508640061130088', N'258201886530736128', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765877219328', N'2020-12-20 19:27:48.960', N'16508640061130151', N'16508640061130070', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765893996544', N'2020-12-20 19:27:48.963', N'16508640061130151', N'16508640061130076', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765906579456', N'2020-12-20 19:27:48.967', N'16508640061130151', N'16508640061130082', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765919162368', N'2020-12-20 19:27:48.967', N'16508640061130151', N'16508640061130114', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765935939584', N'2020-12-20 19:27:48.973', N'16508640061130151', N'16508640061130115', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765948522496', N'2020-12-20 19:27:48.977', N'16508640061130151', N'16508640061130135', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765965299712', N'2020-12-20 19:27:48.980', N'16508640061130151', N'16508640061130136', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765977882624', N'2020-12-20 19:27:48.983', N'16508640061130151', N'16508640061130137', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850765990465536', N'2020-12-20 19:27:48.987', N'16508640061130151', N'16508640061130077', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850766007242752', N'2020-12-20 19:27:48.990', N'16508640061130151', N'16508640061130106', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850766019825664', N'2020-12-20 19:27:48.993', N'16508640061130151', N'16508640061130107', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850766036602880', N'2020-12-20 19:27:48.997', N'16508640061130151', N'16508640061130108', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850766053380096', N'2020-12-20 19:27:49.000', N'16508640061130151', N'16508640061130109', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850766065963008', N'2020-12-20 19:27:49.003', N'16508640061130151', N'16508640061130071', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850766078545920', N'2020-12-20 19:27:49.007', N'16508640061130151', N'16508640061130080', N'258606017569361920', N'1')
GO

INSERT INTO [dbo].[SysMenuAuthorize] ([Id], [CreateTime], [CreatorId], [MenuId], [AuthorizeId], [AuthorizeType]) VALUES (N'260850766107906048', N'2020-12-20 19:27:49.013', N'16508640061130151', N'16508640061130120', N'258606017569361920', N'1')
GO


-- ----------------------------
-- Table structure for SysMqttMsg
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysMqttMsg]') AND type IN ('U'))
	DROP TABLE [dbo].[SysMqttMsg]
GO

CREATE TABLE [dbo].[SysMqttMsg] (
  [Id] bigint  NOT NULL,
  [ThemeName] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Msg] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [Time] datetime  NULL
)
GO

ALTER TABLE [dbo].[SysMqttMsg] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'MQTT订阅消息',
'SCHEMA', N'dbo',
'TABLE', N'SysMqttMsg'
GO


-- ----------------------------
-- Records of SysMqttMsg
-- ----------------------------

-- ----------------------------
-- Table structure for SysMqttTheme
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysMqttTheme]') AND type IN ('U'))
	DROP TABLE [dbo].[SysMqttTheme]
GO

CREATE TABLE [dbo].[SysMqttTheme] (
  [Id] bigint  NOT NULL,
  [ThemeName] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IsSubscribe] bit  NULL
)
GO

ALTER TABLE [dbo].[SysMqttTheme] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'订阅主题名称',
'SCHEMA', N'dbo',
'TABLE', N'SysMqttTheme',
'COLUMN', N'ThemeName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否订阅',
'SCHEMA', N'dbo',
'TABLE', N'SysMqttTheme',
'COLUMN', N'IsSubscribe'
GO

EXEC sp_addextendedproperty
'MS_Description', N'MQTT订阅主题',
'SCHEMA', N'dbo',
'TABLE', N'SysMqttTheme'
GO


-- ----------------------------
-- Records of SysMqttTheme
-- ----------------------------
INSERT INTO [dbo].[SysMqttTheme] ([Id], [ThemeName], [IsSubscribe]) VALUES (N'261778569259126784', N'AA', N'1')
GO

INSERT INTO [dbo].[SysMqttTheme] ([Id], [ThemeName], [IsSubscribe]) VALUES (N'264362008562896896', N'b', N'1')
GO


-- ----------------------------
-- Table structure for SysNews
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysNews]') AND type IN ('U'))
	DROP TABLE [dbo].[SysNews]
GO

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) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [NewsContent] ntext COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [NewsTag] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ThumbImage] varchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [NewsAuthor] nvarchar(50) COLLATE Chinese_PRC_CI_AS  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
)
GO

ALTER TABLE [dbo].[SysNews] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'新闻标题',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'NewsTitle'
GO

EXEC sp_addextendedproperty
'MS_Description', N'新闻内容',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'NewsContent'
GO

EXEC sp_addextendedproperty
'MS_Description', N'新闻标签',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'NewsTag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'缩略图',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'ThumbImage'
GO

EXEC sp_addextendedproperty
'MS_Description', N'发布者',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'NewsAuthor'
GO

EXEC sp_addextendedproperty
'MS_Description', N'新闻排序',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'NewsSort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'发布时间',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'NewsDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'新闻类型(1产品案例 2行业新闻)',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'NewsType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'查看次数',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'ViewTimes'
GO

EXEC sp_addextendedproperty
'MS_Description', N'省份Id',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'ProvinceId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'城市Id',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'CityId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'区县Id',
'SCHEMA', N'dbo',
'TABLE', N'SysNews',
'COLUMN', N'CountyId'
GO


-- ----------------------------
-- Records of SysNews
-- ----------------------------
INSERT INTO [dbo].[SysNews] ([Id], [BaseIsDelete], [BaseCreateTime], [BaseModifyTime], [BaseCreatorId], [BaseModifierId], [BaseVersion], [NewsTitle], [NewsContent], [NewsTag], [ThumbImage], [NewsAuthor], [NewsSort], [NewsDate], [NewsType], [ViewTimes], [ProvinceId], [CityId], [CountyId]) VALUES (N'34571912667467776', N'0', N'2019-04-06 09:36:26.000', N'2019-10-10 12:22:22.000', N'16508640061130151', N'16508640061130151', N'0', N'UHC健康会', N'<p>UHC 健康会，您的健康管家，为您的健康保驾护航。</p><p>
        <img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/8722abb613cd46b4af5b4ded7ddf5fad.jpg" data-filename="/" style="width: 550px;">
    </p><p>
        <img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/1ffc4edd922e4cb195744c13f9eec636.jpg" data-filename="/" style="width: 550px;">
    </p><p>
        <img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/e0728828482542f099ab79ba7d3ef701.jpg" data-filename="/" style="width: 550px;">

    </p><p>
        <img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/57b1153fbf514d9384ba9837a46737cf.jpg" data-filename="/" style="width: 550px;">
        <br>
    </p>
    <p>小程序码</p><p>
        <img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/46ece527595a408e9e62b2334374b560.jpg" data-filename="/" style="width: 430px;">
        <br>
    </p><p><br></p>', N'微信小程序，健康会', N'https://www.yishasoft.com/api/Resource/News/2019/07/31/eee642de4d3443779c0670e0da8eeed7.png', N'管理员', N'1', N'2019-04-06 09:29:00.000', N'1', N'138', N'0', N'0', N'0')
GO

INSERT INTO [dbo].[SysNews] ([Id], [BaseIsDelete], [BaseCreateTime], [BaseModifyTime], [BaseCreatorId], [BaseModifierId], [BaseVersion], [NewsTitle], [NewsContent], [NewsTag], [ThumbImage], [NewsAuthor], [NewsSort], [NewsDate], [NewsType], [ViewTimes], [ProvinceId], [CityId], [CountyId]) VALUES (N'76797547762421760', N'0', N'2019-07-31 22:06:02.000', N'2019-10-12 17:29:52.000', N'16508640061130151', N'16508640061130151', N'0', N'58名师', N'<p>汇聚同城的各科教师，找老师，就上58名师！</p><p><img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/b0316da26b5546d1bf07fcd05e8889e0.png" data-filename="/" style="width: 270px;"></p><p><br></p><p><img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/ad812ef0248a4fcb94edfa69d1ee5a66.png" data-filename="/" style="width: 269px;"></p><p><img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/b2921e1e08e04b0d92b29485356eacb1.png" data-filename="/" style="width: 273px;"></p><p><img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/a1ee188e3d3b462c8f401a9205ddd10e.png" data-filename="/" style="width: 274px;"></p><p>小程序码</p><p><img src="https://www.yishasoft.com/api/Resource/News/2019/07/31/1c30e2bb681448bab52e566993b82472.jpg" data-filename="/" style="width: 430px;"><br></p><p><br></p>', N'微信小程序，找老师', N'https://www.yishasoft.com/api/Resource/News/2019/07/31/a627c3eed0ca428391fa62a841652ea4.png', N'管理员', N'2', N'2019-07-31 21:44:00.000', N'1', N'35', N'340000', N'340100', N'340172')
GO


-- ----------------------------
-- Table structure for SysPosition
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysPosition]') AND type IN ('U'))
	DROP TABLE [dbo].[SysPosition]
GO

CREATE TABLE [dbo].[SysPosition] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatorId] bigint  NOT NULL,
  [PositionName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [PositionSort] int  NOT NULL,
  [Remark] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysPosition] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'职位名称',
'SCHEMA', N'dbo',
'TABLE', N'SysPosition',
'COLUMN', N'PositionName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'职位排序',
'SCHEMA', N'dbo',
'TABLE', N'SysPosition',
'COLUMN', N'PositionSort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysPosition',
'COLUMN', N'Remark'
GO


-- ----------------------------
-- Records of SysPosition
-- ----------------------------
INSERT INTO [dbo].[SysPosition] ([Id], [CreateTime], [CreatorId], [PositionName], [PositionSort], [Remark]) VALUES (N'16508640061130139', N'2018-12-06 09:43:34.000', N'0', N'董事长', N'1', N'CEO')
GO

INSERT INTO [dbo].[SysPosition] ([Id], [CreateTime], [CreatorId], [PositionName], [PositionSort], [Remark]) VALUES (N'16508640061130140', N'2018-12-06 09:47:46.000', N'0', N'总经理', N'2', N'')
GO

INSERT INTO [dbo].[SysPosition] ([Id], [CreateTime], [CreatorId], [PositionName], [PositionSort], [Remark]) VALUES (N'16508640061130141', N'2018-12-06 09:47:56.000', N'0', N'项目经理', N'3', N'')
GO

INSERT INTO [dbo].[SysPosition] ([Id], [CreateTime], [CreatorId], [PositionName], [PositionSort], [Remark]) VALUES (N'16508640061130142', N'2018-12-06 09:48:10.000', N'0', N'测试经理', N'4', N'111')
GO

INSERT INTO [dbo].[SysPosition] ([Id], [CreateTime], [CreatorId], [PositionName], [PositionSort], [Remark]) VALUES (N'16508640061130143', N'2018-12-06 09:48:18.000', N'0', N'程序员', N'5', N'')
GO

INSERT INTO [dbo].[SysPosition] ([Id], [CreateTime], [CreatorId], [PositionName], [PositionSort], [Remark]) VALUES (N'16508640061130144', N'2018-12-22 11:41:39.000', N'0', N'前端', N'6', N'')
GO

INSERT INTO [dbo].[SysPosition] ([Id], [CreateTime], [CreatorId], [PositionName], [PositionSort], [Remark]) VALUES (N'16508640061130145', N'2018-12-22 18:44:32.000', N'0', N'财务专员', N'7', NULL)
GO


-- ----------------------------
-- Table structure for SysRole
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysRole]') AND type IN ('U'))
	DROP TABLE [dbo].[SysRole]
GO

CREATE TABLE [dbo].[SysRole] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatorId] bigint  NOT NULL,
  [RoleName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [RoleSort] int  NOT NULL,
  [RoleStatus] int  NOT NULL,
  [Remark] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysRole] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'SysRole',
'COLUMN', N'RoleName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色排序',
'SCHEMA', N'dbo',
'TABLE', N'SysRole',
'COLUMN', N'RoleSort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色状态(0禁用 1启用)',
'SCHEMA', N'dbo',
'TABLE', N'SysRole',
'COLUMN', N'RoleStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysRole',
'COLUMN', N'Remark'
GO


-- ----------------------------
-- Records of SysRole
-- ----------------------------
INSERT INTO [dbo].[SysRole] ([Id], [CreateTime], [CreatorId], [RoleName], [RoleSort], [RoleStatus], [Remark]) VALUES (N'258606017569361920', N'2020-12-14 14:47:59.257', N'16508640061130151', N'管理', N'1', N'1', NULL)
GO


-- ----------------------------
-- Table structure for SysUser
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysUser]') AND type IN ('U'))
	DROP TABLE [dbo].[SysUser]
GO

CREATE TABLE [dbo].[SysUser] (
  [Id] bigint  NOT NULL,
  [IsDelete] int  NOT NULL,
  [CreateTime] datetime  NULL,
  [CreatorId] bigint  NOT NULL,
  [UserName] nvarchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Password] varchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Salt] varchar(5) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [RealName] nvarchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DepartmentId] bigint  NOT NULL,
  [Gender] int  NOT NULL,
  [Birthday] varchar(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Portrait] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [Email] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Mobile] varchar(11) COLLATE Chinese_PRC_CI_AS  NULL,
  [QQ] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [WeChat] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [LoginCount] int  NULL,
  [UserStatus] int  NOT NULL,
  [IsSystem] int  NULL,
  [IsOnline] int  NULL,
  [FirstVisit] datetime  NULL,
  [PreviousVisit] datetime  NULL,
  [LastVisit] datetime  NULL,
  [Remark] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [Picture] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [ApiToken] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[SysUser] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'UserName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码盐值',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Salt'
GO

EXEC sp_addextendedproperty
'MS_Description', N'姓名',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'RealName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'所属部门Id',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'DepartmentId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'性别(0未知 1男 2女)',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Gender'
GO

EXEC sp_addextendedproperty
'MS_Description', N'出生日期',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Birthday'
GO

EXEC sp_addextendedproperty
'MS_Description', N'头像',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Portrait'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Email',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'手机',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Mobile'
GO

EXEC sp_addextendedproperty
'MS_Description', N'QQ',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'QQ'
GO

EXEC sp_addextendedproperty
'MS_Description', N'微信',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'WeChat'
GO

EXEC sp_addextendedproperty
'MS_Description', N'登录次数',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'LoginCount'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户状态(0禁用 1启用)',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'UserStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统用户(0/null不是 1是[系统用户拥有所有的权限])',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'IsSystem'
GO

EXEC sp_addextendedproperty
'MS_Description', N'在线(0不是 1是)',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'IsOnline'
GO

EXEC sp_addextendedproperty
'MS_Description', N'首次登录时间',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'FirstVisit'
GO

EXEC sp_addextendedproperty
'MS_Description', N'上一次登录时间',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'PreviousVisit'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后一次登录时间',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'LastVisit'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'相片',
'SCHEMA', N'dbo',
'TABLE', N'SysUser',
'COLUMN', N'Picture'
GO


-- ----------------------------
-- Records of SysUser
-- ----------------------------
INSERT INTO [dbo].[SysUser] ([Id], [IsDelete], [CreateTime], [CreatorId], [UserName], [Password], [Salt], [RealName], [DepartmentId], [Gender], [Birthday], [Portrait], [Email], [Mobile], [QQ], [WeChat], [LoginCount], [UserStatus], [IsSystem], [IsOnline], [FirstVisit], [PreviousVisit], [LastVisit], [Remark], [Picture], [ApiToken]) VALUES (N'16508640061130149', N'0', N'2018-12-12 06:59:29.000', N'0', N'zhangsan', N'3', N'', N'张三', N'253473405880242176', N'1', N'2020-11-04', N'', N'222', N'18712345678', N'', N'', N'0', N'1', N'0', N'0', N'1970-01-01 00:00:00.000', N'1970-01-01 00:00:00.000', N'1970-01-01 00:00:00.000', N'', NULL, NULL)
GO

INSERT INTO [dbo].[SysUser] ([Id], [IsDelete], [CreateTime], [CreatorId], [UserName], [Password], [Salt], [RealName], [DepartmentId], [Gender], [Birthday], [Portrait], [Email], [Mobile], [QQ], [WeChat], [LoginCount], [UserStatus], [IsSystem], [IsOnline], [FirstVisit], [PreviousVisit], [LastVisit], [Remark], [Picture], [ApiToken]) VALUES (N'16508640061130150', N'0', N'2018-12-12 11:20:47.000', N'0', N'wangxue', N'518cd8c7e019f06ad7bf68f7532a5a73', N'8941', N'王雪', N'16508640061124408', N'0', N'1993-10-06', N'', N'', N'15612345678', N'', N'', N'1', N'1', N'0', N'1', N'2019-09-21 10:48:03.000', N'2019-09-21 10:48:03.000', N'2019-09-21 10:48:03.000', N'', NULL, NULL)
GO

INSERT INTO [dbo].[SysUser] ([Id], [IsDelete], [CreateTime], [CreatorId], [UserName], [Password], [Salt], [RealName], [DepartmentId], [Gender], [Birthday], [Portrait], [Email], [Mobile], [QQ], [WeChat], [LoginCount], [UserStatus], [IsSystem], [IsOnline], [FirstVisit], [PreviousVisit], [LastVisit], [Remark], [Picture], [ApiToken]) VALUES (N'16508640061130151', N'0', N'2018-12-12 15:42:59.000', N'0', N'admin', N'b4e24a62fb8b61b0af033b0a30b20df1', N'98648', N'管理员', N'16508640061124402', N'0', N'2019-01-01', N'', N'admin@163.com', N'15766666666', N'810938177', N's810938177', N'1004', N'1', N'1', N'1', N'2018-12-12 16:00:10.000', N'2021-02-05 10:58:03.760', N'2021-02-05 10:58:03.760', N'', NULL, N'd406549e4af64bfaab54a4987b511b9b')
GO


-- ----------------------------
-- Table structure for SysUserBelong
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SysUserBelong]') AND type IN ('U'))
	DROP TABLE [dbo].[SysUserBelong]
GO

CREATE TABLE [dbo].[SysUserBelong] (
  [Id] bigint  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatorId] bigint  NOT NULL,
  [UserId] bigint  NOT NULL,
  [BelongId] bigint  NOT NULL,
  [BelongType] int  NOT NULL
)
GO

ALTER TABLE [dbo].[SysUserBelong] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户Id',
'SCHEMA', N'dbo',
'TABLE', N'SysUserBelong',
'COLUMN', N'UserId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'职位Id或者角色Id',
'SCHEMA', N'dbo',
'TABLE', N'SysUserBelong',
'COLUMN', N'BelongId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'所属类型(1职位 2角色)',
'SCHEMA', N'dbo',
'TABLE', N'SysUserBelong',
'COLUMN', N'BelongType'
GO


-- ----------------------------
-- Records of SysUserBelong
-- ----------------------------
INSERT INTO [dbo].[SysUserBelong] ([Id], [CreateTime], [CreatorId], [UserId], [BelongId], [BelongType]) VALUES (N'259363197956395008', N'2020-12-16 16:56:45.127', N'16508640061130151', N'259345304376053760', N'258606017569361920', N'2')
GO

INSERT INTO [dbo].[SysUserBelong] ([Id], [CreateTime], [CreatorId], [UserId], [BelongId], [BelongType]) VALUES (N'259363198329688064', N'2020-12-16 16:56:45.217', N'16508640061130151', N'259345304376053760', N'16508640061130140', N'1')
GO

INSERT INTO [dbo].[SysUserBelong] ([Id], [CreateTime], [CreatorId], [UserId], [BelongId], [BelongType]) VALUES (N'259363198677815296', N'2020-12-16 16:56:45.300', N'16508640061130151', N'259345304376053760', N'16508640061130141', N'1')
GO

INSERT INTO [dbo].[SysUserBelong] ([Id], [CreateTime], [CreatorId], [UserId], [BelongId], [BelongType]) VALUES (N'259426846125330432', N'2020-12-16 21:09:40.037', N'16508640061130151', N'16508640061130151', N'258606017569361920', N'2')
GO

INSERT INTO [dbo].[SysUserBelong] ([Id], [CreateTime], [CreatorId], [UserId], [BelongId], [BelongType]) VALUES (N'259426846565732352', N'2020-12-16 21:09:40.140', N'16508640061130151', N'16508640061130151', N'16508640061130140', N'1')
GO

INSERT INTO [dbo].[SysUserBelong] ([Id], [CreateTime], [CreatorId], [UserId], [BelongId], [BelongType]) VALUES (N'259432564475826176', N'2020-12-16 21:32:23.397', N'16508640061130151', N'16508640061130152', N'258606017569361920', N'2')
GO

INSERT INTO [dbo].[SysUserBelong] ([Id], [CreateTime], [CreatorId], [UserId], [BelongId], [BelongType]) VALUES (N'259432564895256576', N'2020-12-16 21:32:23.497', N'16508640061130151', N'16508640061130152', N'16508640061130141', N'1')
GO

INSERT INTO [dbo].[SysUserBelong] ([Id], [CreateTime], [CreatorId], [UserId], [BelongId], [BelongType]) VALUES (N'259432565268549632', N'2020-12-16 21:32:23.587', N'16508640061130151', N'16508640061130152', N'16508640061130140', N'1')
GO


-- ----------------------------
-- Primary Key structure for table SysApiAuthorize
-- ----------------------------
ALTER TABLE [dbo].[SysApiAuthorize] ADD CONSTRAINT [PK__SysApiAu__3214EC07F7C5DE0B] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysCodeTemplet
-- ----------------------------
ALTER TABLE [dbo].[SysCodeTemplet] ADD CONSTRAINT [PK__SysCodeT__3214EC07E6AD90F3] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysDataDict
-- ----------------------------
ALTER TABLE [dbo].[SysDataDict] ADD CONSTRAINT [PK_SysDataDict] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysDataDictDetail
-- ----------------------------
ALTER TABLE [dbo].[SysDataDictDetail] ADD CONSTRAINT [PK_SysDataDictDetail] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysDepartment
-- ----------------------------
ALTER TABLE [dbo].[SysDepartment] ADD CONSTRAINT [PK_SysDepartment] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysLogApi
-- ----------------------------
ALTER TABLE [dbo].[SysLogApi] ADD CONSTRAINT [PK_SysLogApi] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysLogLogin
-- ----------------------------
ALTER TABLE [dbo].[SysLogLogin] ADD CONSTRAINT [PK_SysLogLogin] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysMenu
-- ----------------------------
ALTER TABLE [dbo].[SysMenu] ADD CONSTRAINT [PK_SysMenu] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysMenuAuthorize
-- ----------------------------
ALTER TABLE [dbo].[SysMenuAuthorize] ADD CONSTRAINT [PK_SysMenuAuthorize] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysMqttMsg
-- ----------------------------
ALTER TABLE [dbo].[SysMqttMsg] ADD CONSTRAINT [PK__SysMqttM__3214EC071BD5A793] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysMqttTheme
-- ----------------------------
ALTER TABLE [dbo].[SysMqttTheme] ADD CONSTRAINT [PK__SysMqtt__3214EC0761696934] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysNews
-- ----------------------------
ALTER TABLE [dbo].[SysNews] ADD CONSTRAINT [PK_SysNews] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysPosition
-- ----------------------------
ALTER TABLE [dbo].[SysPosition] ADD CONSTRAINT [PK_SysPosition] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysRole
-- ----------------------------
ALTER TABLE [dbo].[SysRole] ADD CONSTRAINT [PK_SysRole] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysUser
-- ----------------------------
ALTER TABLE [dbo].[SysUser] ADD CONSTRAINT [PK_SysUser] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table SysUserBelong
-- ----------------------------
ALTER TABLE [dbo].[SysUserBelong] ADD CONSTRAINT [PK_SysUserBelong] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO