zerd_pg.sql

create table address
(
    id          SERIAL PRIMARY KEY,
    name        varchar(30)  not null,
    mobile      varchar(20)  not null,
    province    varchar(20)  null,
    city        varchar(20)  null,
    country     varchar(20)  null,
    detail      varchar(100) null,
    user_id     integer          not null,
    create_time integer          null,
    update_time integer          null,
    delete_time integer          null,
    constraint user_id
        unique (user_id)
);

INSERT INTO address (id, name, mobile, province, city, country, detail, user_id, create_time, update_time, delete_time) VALUES (1, '巴拿巴', '13799999999', '浙江', '杭州', '滨江', '塞浦路斯9栋7单元101室', 1, null, null, null);
INSERT INTO address (id, name, mobile, province, city, country, detail, user_id, create_time, update_time, delete_time) VALUES (2, '扫罗', '13788888888', '浙江', '杭州', '萧山', '大马士革7栋1单元701室', 3, null, null, null);
create table auth
(
    id       SERIAL PRIMARY KEY,
    group_id integer     not null,
    name     varchar(60) null,
    module   varchar(50) null
);

INSERT INTO auth (id, group_id, name, module) VALUES (1, 1, '查询用户列表', '用户');
INSERT INTO auth (id, group_id, name, module) VALUES (2, 1, '更改用户密码', '用户');
INSERT INTO auth (id, group_id, name, module) VALUES (3, 1, '新增类别', '类别');
create table banner
(
    id          SERIAL PRIMARY KEY,
    name        varchar(50)  null,
    description varchar(255) null,
    create_time integer          null,
    update_time integer          null,
    delete_time integer          null
);

INSERT INTO banner (id, name, description, create_time, update_time, delete_time) VALUES (1, '首页置顶', '首页轮播图', 1528938338, null, null);
create table category
(
    id           SERIAL PRIMARY KEY,
    name         varchar(50)  not null,
    topic_img_id integer          null,
    description  varchar(100) null,
    create_time  integer          null,
    update_time  integer          null,
    delete_time  integer          null
);

INSERT INTO category (id, name, topic_img_id, description, create_time, update_time, delete_time) VALUES (2, '果味', 6, null, null, null, null);
INSERT INTO category (id, name, topic_img_id, description, create_time, update_time, delete_time) VALUES (3, '蔬菜', 5, null, null, null, null);
INSERT INTO category (id, name, topic_img_id, description, create_time, update_time, delete_time) VALUES (4, '炒货', 7, null, null, null, null);
INSERT INTO category (id, name, topic_img_id, description, create_time, update_time, delete_time) VALUES (5, '点心', 4, null, null, null, null);
INSERT INTO category (id, name, topic_img_id, description, create_time, update_time, delete_time) VALUES (6, '粗茶', 8, null, null, null, null);
INSERT INTO category (id, name, topic_img_id, description, create_time, update_time, delete_time) VALUES (7, '淡饭', 9, null, null, null, null);
create table config
(
    id     SERIAL PRIMARY KEY,
    name   varchar(64) null,
    "key"  varchar(64) null,
    value  varchar(64) null,
    type   boolean  null,
    remark text        null
);

INSERT INTO config (id, name, "key", value, type, remark) VALUES (1, '用户管理-账号初始密码', 'sys.user.init_password', '123456', true, '用户初始化密码: 123456');
INSERT INTO config (id, name, "key", value, type, remark) VALUES (2, '页面框架-布局主题', 'sys.layout.theme', 'vertical', true, '左右布局default，上下布局vertical，T型布局t-type');
INSERT INTO config (id, name, "key", value, type, remark) VALUES (3, '分页查询-默认页', 'sys.paginator.page', '1', true, '默认查询第1页');
INSERT INTO config (id, name, "key", value, type, remark) VALUES (4, '分页查询-默认数量', 'sys.paginator.size', '10', true, '默认每页10条数据');
create table dict
(
    id         SERIAL PRIMARY KEY,
    "order"    integer         not null,
    label      varchar(64) null,
    value      varchar(64) null,
    type       varchar(64) null,
    css_class  varchar(64) null,
    list_class varchar(64) null,
    is_default boolean  null,
    status     boolean  null,
    remark     text        null
);

INSERT INTO dict (id, "order", label, value, type, css_class, list_class, is_default, status, remark) VALUES (1, 1, '男', '0', 'sys_user_sex', null, null, true, true, '性别: 男');
INSERT INTO dict (id, "order", label, value, type, css_class, list_class, is_default, status, remark) VALUES (2, 2, '女', '1', 'sys_user_sex', null, null, false, true, '性别: 女');
INSERT INTO dict (id, "order", label, value, type, css_class, list_class, is_default, status, remark) VALUES (4, 1, '显示', '0', 'sys_show_hide', null, 'primary', true, true, '显示菜单');
INSERT INTO dict (id, "order", label, value, type, css_class, list_class, is_default, status, remark) VALUES (5, 2, '隐藏', '1', 'sys_show_hide', null, 'danger', false, true, '隐藏菜单');
create table dict_type
(
    id     SERIAL PRIMARY KEY,
    name   varchar(64) null,
    type   varchar(64) null,
    status boolean  null,
    remark text        null
);

INSERT INTO dict_type (id, name, type, status, remark) VALUES (1, '用户性别', 'sys_user_sex', true, '用户性别列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (2, '菜单状态', 'sys_show_hide', true, '菜单状态列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (3, '系统开关', 'sys_normal_disable', true, '系统开关列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (4, '任务状态', 'sys_job_status', true, '任务状态列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (5, '任务分组', 'sys_job_group', true, '任务分组列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (6, '系统是否', 'sys_yes_no', true, '系统是否列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (7, '通知类型', 'sys_notice_type', true, '通知类型列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (8, '通知状态', 'sys_notice_status', true, '通知状态列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (9, '操作类型', 'sys_oper_type', true, '操作类型列表');
INSERT INTO dict_type (id, name, type, status, remark) VALUES (10, '系统状态', 'sys_common_status', true, '登录状态列表');
create table file
(
    create_time integer          null,
    update_time integer          null,
    delete_time integer          null,
    id          SERIAL PRIMARY KEY,
    parent_id   integer          null,
    uuid_name   varchar(100) null,
    name        varchar(100) not null,
    path        varchar(500) null,
    extension   varchar(50)  null,
    "from"      smallint     null,
    size        integer          null,
    md5         varchar(40)  null
);

INSERT INTO file (create_time, update_time, delete_time, id, parent_id, uuid_name, name, path, extension, "from", size, md5) VALUES (1589786103, 1590398617, null, 1, 0, null, '321', null, null, 1, null, null);
INSERT INTO file (create_time, update_time, delete_time, id, parent_id, uuid_name, name, path, extension, "from", size, md5) VALUES (1589786103, null, null, 2, 0, null, '图片文件', null, null, 1, null, null);
INSERT INTO file (create_time, update_time, delete_time, id, parent_id, uuid_name, name, path, extension, "from", size, md5) VALUES (1589786103, 1590386642, null, 3, 0, null, 'pdf文件', null, null, 1, null, null);
INSERT INTO file (create_time, update_time, delete_time, id, parent_id, uuid_name, name, path, extension, "from", size, md5) VALUES (1589786103, null, null, 5, 2, 'aebdff3a-7bb5-11ea-8007-acbc32924b6f.png', 'virtualmachine2.png', '2020/04/11/aebdff3a-7bb5-11ea-8007-acbc32924b6f.png', 'png', 1, null, null);
INSERT INTO file (create_time, update_time, delete_time, id, parent_id, uuid_name, name, path, extension, "from", size, md5) VALUES (1590112814, null, null, 8, 1, 'f992de74-9bcf-11ea-97a6-acbc32924b6fpng', 'logo-01.png', '2020/05/22/f992de74-9bcf-11ea-97a6-acbc32924b6fpng', 'png', 1, 39272, '61b2160c5fc09e373a25ca5fa9e95e38');
INSERT INTO file (create_time, update_time, delete_time, id, parent_id, uuid_name, name, path, extension, "from", size, md5) VALUES (1590398385, 1590398395, null, 13, 0, null, '新建文件夹12', null, null, 1, null, null);
INSERT INTO file (create_time, update_time, delete_time, id, parent_id, uuid_name, name, path, extension, "from", size, md5) VALUES (1590459173, null, null, 15, 1, null, '新建文件夹', null, null, 1, null, null);
INSERT INTO file (create_time, update_time, delete_time, id, parent_id, uuid_name, name, path, extension, "from", size, md5) VALUES (1593586591, null, null, 16, 68, 'fe7d066e-bb67-11ea-86bf-acbc32924b6f.png', '我的.png', '2020/07/01/fe7d066e-bb67-11ea-86bf-acbc32924b6f.png', '.png', 1, 805, 'e8e3153cb3f57175a434ef50bc8b541f');
create table "group"
(
    id   SERIAL PRIMARY KEY,
    name varchar(60)  null,
    info varchar(255) null
);

INSERT INTO "group" (id, name, info) VALUES (1, '系统管理员', '行使超级管理员的相同权限，但不能新增同级的系统管理员');
INSERT INTO "group" (id, name, info) VALUES (2, '运维管理员', '管理商品上架、下架');
INSERT INTO "group" (id, name, info) VALUES (3, '物流管理员', '负责订单的发货情况');
INSERT INTO "group" (id, name, info) VALUES (4, '活动策划员', '策划线上营销活动');
INSERT INTO "group" (id, name, info) VALUES (6, '测试1', '测试分组');
create table image
(
    id          SERIAL PRIMARY KEY,
    url         varchar(255)      not null,
    "from"      smallint default 1 not null,
    create_time integer               null,
    update_time integer               null,
    delete_time integer               null
);

INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (1, '/banner-1a.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (2, '/banner-2a.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (3, '/banner-3a.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (4, '/category-cake.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (5, '/category-vg.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (6, '/category-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (7, '/category-fry-a.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (8, '/category-tea.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (9, '/category-rice.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (10, '/product-dryfruit@1.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (13, '/product-vg@1.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (14, '/product-rice@6.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (16, '/1@theme.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (17, '/2@theme.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (18, '/3@theme.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (19, '/detail-1@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (20, '/detail-2@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (21, '/detail-3@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (22, '/detail-4@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (23, '/detail-5@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (24, '/detail-6@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (25, '/detail-7@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (26, '/detail-8@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (27, '/detail-9@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (28, '/detail-11@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (29, '/detail-10@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (31, '/product-rice@1.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (32, '/product-tea@1.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (33, '/product-dryfruit@2.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (36, '/product-dryfruit@3.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (37, '/product-dryfruit@4.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (38, '/product-dryfruit@5.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (39, '/product-dryfruit-a@6.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (40, '/product-dryfruit@7.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (41, '/product-rice@2.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (42, '/product-rice@3.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (43, '/product-rice@4.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (44, '/product-fry@1.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (45, '/product-fry@2.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (46, '/product-fry@3.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (47, '/product-tea@2.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (48, '/product-tea@3.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (49, '/1@theme-head.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (50, '/2@theme-head.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (51, '/3@theme-head.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (52, '/product-cake@1.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (53, '/product-cake@2.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (54, '/product-cake-a@3.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (55, '/product-cake-a@4.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (56, '/product-dryfruit@8.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (57, '/product-fry@4.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (58, '/product-fry@5.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (59, '/product-rice@5.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (60, '/product-rice@7.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (62, '/detail-12@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (63, '/detail-13@1-dryfruit.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (65, '/banner-4a.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (66, '/product-vg@4.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (67, '/product-vg@5.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (68, '/product-vg@2.png', 1, null, null, null);
INSERT INTO image (id, url, "from", create_time, update_time, delete_time) VALUES (69, '/product-vg@3.png', 1, null, null, null);
create table login_log
(
    id          SERIAL PRIMARY KEY,
    user_id     integer          not null,
    user_name   varchar(50)  null,
    ip_addr     varchar(50)  null,
    location    varchar(255) null,
    browser     varchar(50)  null,
    os          varchar(50)  null,
    message     varchar(255) null,
    status      boolean   null,
    create_time integer          null
);

INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (1, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '', true, 1592230004);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (2, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '', true, 1592230619);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (3, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '', true, 1592231445);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (4, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '', true, 1592231613);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (5, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '', true, 1592231618);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (6, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '', true, 1592231620);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (7, 3, 'Allen7D', '192.168.10.80', '内网IP', 'chrome', 'macos', '', true, 1592272492);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (8, 3, 'Allen7D', '192.168.10.80', '内网IP', 'chrome', 'macos', '', true, 1592273245);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (9, 3, 'Allen7D', '192.168.10.80', '内网IP', 'chrome', 'macos', '', true, 1592273358);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (10, 3, 'Allen7D', '192.168.10.74', '内网IP', 'chrome', 'windows', '', true, 1592273401);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (11, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '', true, 1592273564);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (12, 3, 'Allen7D', '192.168.10.74', '内网IP', 'chrome', 'windows', '', true, 1592273605);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (13, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592275354);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (14, 3, 'Allen7D', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592275592);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (15, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592289190);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (16, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592289200);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (17, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592289426);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (18, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592289589);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (19, 3, 'Allen7D', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592290309);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (20, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592290367);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (21, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592295023);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (22, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592295098);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (23, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592295258);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (24, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592377702);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (25, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592408328);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (26, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592442372);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (27, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592446398);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (28, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592446400);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (29, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592446564);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (30, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592446685);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (31, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592446914);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (32, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592446959);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (33, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592447150);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (34, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592447266);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (35, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592447270);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (36, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592447591);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (37, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592448529);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (38, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592449339);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (39, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592449490);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (40, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592456918);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (41, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457110);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (42, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457314);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (43, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457433);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (44, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457470);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (45, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457498);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (46, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457505);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (47, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457530);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (48, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457539);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (49, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457548);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (50, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457585);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (51, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457651);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (52, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592457654);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (53, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592458175);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (54, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592458198);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (55, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592458237);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (56, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592458350);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (57, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592458352);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (58, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592458355);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (59, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592458453);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (60, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592459710);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (61, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592461445);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (62, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592461726);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (63, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592461733);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (64, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592462383);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (65, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592462391);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (66, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592465345);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (67, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592465509);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (68, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592466956);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (69, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592467189);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (70, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592467488);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (71, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592467543);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (72, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592469118);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (73, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592472363);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (74, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592472461);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (75, 1, 'Boss', '192.168.10.55', '内网IP', 'chrome', 'windows', '登录成功', true, 1592472581);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (76, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592492589);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (77, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592492594);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (78, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592496350);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (79, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592496354);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (80, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592496358);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (81, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592496362);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (82, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592496831);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (83, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592496834);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (84, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592496854);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (85, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592497135);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (86, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592497147);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (87, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592497199);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (88, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592497648);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (89, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592498901);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (90, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592499975);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (91, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592500128);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (92, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592502048);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (93, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592502103);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (94, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592502201);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (95, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592502638);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (96, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592504253);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (97, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592504305);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (98, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592504311);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (99, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592504324);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (100, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592504853);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (101, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592506638);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (102, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592506731);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (103, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592507621);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (104, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592507656);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (105, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592534517);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (106, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592534517);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (107, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592534571);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (108, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592534653);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (109, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592534669);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (110, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592534741);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (111, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592534763);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (112, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592534958);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (113, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592534972);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (114, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535508);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (115, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535712);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (116, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535724);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (117, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535760);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (118, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535823);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (119, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535827);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (120, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535830);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (121, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535937);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (122, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592535973);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (123, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536026);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (124, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536096);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (125, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536109);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (126, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536194);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (127, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536252);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (128, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536302);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (129, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536335);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (130, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536365);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (131, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536406);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (132, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536443);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (133, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536469);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (134, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536531);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (135, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536554);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (136, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536564);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (137, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536573);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (138, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536627);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (139, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536640);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (140, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536647);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (141, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536660);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (142, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536714);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (143, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592536975);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (144, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592537111);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (145, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592537165);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (146, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538017);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (147, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538180);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (148, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538224);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (149, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538227);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (150, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538274);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (151, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538303);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (152, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538454);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (153, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538696);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (154, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538749);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (155, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538765);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (156, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538771);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (157, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538792);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (158, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592538941);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (159, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592539285);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (160, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592539290);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (161, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592539303);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (162, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592638346);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (163, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592638394);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (164, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592638833);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (165, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592639533);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (166, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592639563);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (167, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592639714);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (168, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592639767);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (169, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592639816);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (170, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592640059);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (171, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592640075);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (172, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592640202);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (173, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592640223);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (174, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592640226);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (175, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592640338);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (176, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592640409);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (177, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592642892);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (178, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592643016);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (179, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592643020);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (180, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592643709);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (181, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592643724);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (182, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592643726);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (183, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592643778);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (184, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592648526);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (185, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592649278);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (186, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592657035);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (187, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592657049);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (188, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592657243);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (189, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592657262);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (190, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592657387);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (191, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592657573);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (192, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592657680);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (193, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592658688);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (194, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592658693);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (195, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592658790);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (196, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592658794);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (197, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592658840);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (198, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592659377);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (199, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592660103);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (200, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592660125);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (201, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592660271);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (202, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592661054);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (203, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592661061);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (204, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592661066);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (205, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592661072);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (206, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592661424);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (207, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592662688);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (208, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592719174);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (209, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592719245);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (210, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592720730);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (211, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592722942);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (212, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592879225);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (213, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592879233);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (214, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1592880253);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (215, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592892400);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (216, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592892423);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (217, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592892462);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (218, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592892611);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (219, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592892854);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (220, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1592893955);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (221, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1592960984);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (222, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593307243);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (223, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593308587);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (224, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593308609);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (225, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593308626);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (226, 3, 'Allen7D', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593308632);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (227, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593310266);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (228, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593310298);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (229, 1, 'Boss', '192.168.10.59', '内网IP', 'chrome', 'windows', '登录成功', true, 1593400460);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (230, 1, 'Boss', '192.168.10.59', '内网IP', 'chrome', 'windows', '登录成功', true, 1593401089);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (231, 1, 'Boss', '192.168.10.59', '内网IP', 'chrome', 'windows', '登录成功', true, 1593409253);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (232, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593415871);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (233, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593415949);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (234, 1, 'Boss', '192.168.10.80', '内网IP', 'chrome', 'macos', '登录成功', true, 1593420031);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (235, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'android', '登录成功', true, 1593420227);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (236, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593420708);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (237, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593483841);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (238, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593487473);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (239, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593487529);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (240, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593494870);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (241, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593503116);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (242, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593503137);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (243, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593503839);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (244, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593568245);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (245, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593570738);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (246, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593581966);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (247, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593581973);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (248, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593583769);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (249, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593655035);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (250, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1593655039);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (251, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1593661429);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (252, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1604545322);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (253, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1604546073);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (254, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1604546081);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (255, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1604546086);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (256, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1604546092);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (257, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1604546164);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (258, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1604546318);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (259, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1604546328);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (260, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604557523);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (261, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604561437);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (262, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604561627);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (263, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604561656);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (264, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604561727);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (265, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604561777);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (266, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604561831);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (267, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604561833);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (268, 1, 'Boss', '192.168.10.74', '内网IP', 'chrome', 'windows', '登录成功', true, 1604562130);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (269, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1606149299);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (270, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1606208378);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (271, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1607739198);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (272, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1607742388);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (273, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1611561798);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (274, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1619591451);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (275, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1628605334);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (276, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1658119664);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (277, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1658119665);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (278, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1658119666);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (279, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1658119667);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (280, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1658119772);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (281, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1658119781);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (282, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1746901491);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (283, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1746901499);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (284, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1746901654);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (285, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1746901977);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (286, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1746902047);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (287, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1746902052);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (288, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1746902116);
INSERT INTO login_log (id, user_id, user_name, ip_addr, location, browser, os, message, status, create_time) VALUES (289, 1, 'Boss', '127.0.0.1', '内网IP', 'chrome', 'macos', '登录成功', true, 1746902198);
create table notice
(
    create_time integer         null,
    update_time integer         null,
    delete_time integer         null,
    id          SERIAL PRIMARY KEY,
    type        smallint    null,
    title       varchar(64) null,
    content     text        null,
    status      boolean  null,
    remark      text        null,
    create_by   varchar(32) null,
    update_by   varchar(32) null
);

INSERT INTO notice (create_time, update_time, delete_time, id, type, title, content, status, remark, create_by, update_by) VALUES (null, 1593311079, null, 1, 2, '温馨提醒：2020-07-01 MiniShop新版本发布啦', '<p>新版本内容</p>', false, '', '管理员', 'Boss');
INSERT INTO notice (create_time, update_time, delete_time, id, type, title, content, status, remark, create_by, update_by) VALUES (null, 1593311075, null, 2, 1, '维护通知：2020-07-01 MiniShop系统凌晨0:00维护', '<p>维护内容</p>', false, '', '管理员', 'Boss');
INSERT INTO notice (create_time, update_time, delete_time, id, type, title, content, status, remark, create_by, update_by) VALUES (1593309584, 1593310141, 1593310141, 3, 1, '测试', '<p>111</p>', true, '', 'Boss', '');
INSERT INTO notice (create_time, update_time, delete_time, id, type, title, content, status, remark, create_by, update_by) VALUES (1593311196, 1593311241, 1593311241, 4, 2, '测试1', '<p>测试1111</p>', true, '', 'Boss', 'Boss');
INSERT INTO notice (create_time, update_time, delete_time, id, type, title, content, status, remark, create_by, update_by) VALUES (1593316414, 1593316428, 1593316428, 5, 1, '测试', '<p>111</p>', true, '', 'Boss', '');
create table oper_log
(
    id             SERIAL PRIMARY KEY,
    module         varchar(20)  null,
    message        varchar(450) null,
    user_id        integer          not null,
    user_name      varchar(50)  null,
    path           varchar(50)  null,
    request_method varchar(20)  null,
    request_param  json         null,
    endpoint       varchar(100) null,
    type           smallint     null,
    auth           varchar(100) null,
    status_code    integer          null,
    create_time    integer          null
);

INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (1, null, '更新用户分组', 1, 'Boss', '/cms/user/1/group', 'PUT', null, null, 2, '更新用户分组', 201, 1592278649);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (2, null, '更新用户分组', 1, 'Boss', '/cms/user/1/group', 'PUT', null, null, 2, '更新用户分组', 201, 1592288761);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (3, null, '更改用户密码', 1, 'Boss', '/cms/user/1/password', 'PUT', null, null, 2, '更改用户密码', 201, 1592288770);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (4, null, '更新用户分组', 1, 'Boss', '/cms/user/4/group', 'PUT', null, null, 2, '更新用户分组', 201, 1592879250);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (5, '用户管理', '更新用户分组', 1, 'Boss', '/cms/user/4/group', 'PUT', null, null, 2, '更新用户分组', 201, 1592880267);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (6, '用户管理', '更新用户分组', 1, 'Boss', '/cms/user/1/group', 'PUT', null, null, 2, '更新用户分组', 201, 1592894747);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (7, '用户管理', '更新用户分组', 1, 'Boss', '/cms/user/1/group', 'PUT', null, 'cms.user+update_user', 2, '更新用户分组', 201, 1592895003);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (8, '用户管理', '更新用户分组', 1, 'Boss', '/cms/user/1/group', 'PUT', null, 'cms.user+update_user', 2, '更新用户分组', 201, 1592898895);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (9, '用户管理', '更新用户分组', 1, 'Boss', '/cms/user/1/group', 'PUT', null, 'cms.user+update_user', 2, '更新用户分组', 201, 1592899462);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (10, '用户管理', '更新用户分组', 1, 'Boss', '/cms/user/1/group', 'PUT', '{"body": {"group_id": 1}, "path": {"uid": 1}, "query": {}}', 'cms.user+update_user', 2, '更新用户分组', 201, 1592901433);
INSERT INTO oper_log (id, module, message, user_id, user_name, path, request_method, request_param, endpoint, type, auth, status_code, create_time) VALUES (11, '用户管理', '更新用户分组', 1, 'Boss', '/cms/user/1/group', 'PUT', '{"body": {"group_id": 1}, "path": {"uid": 1}, "query": {}}', 'cms.user+update_user', 2, '更新用户分组', 201, 1592901757);
create table "order"
(
    id           SERIAL PRIMARY KEY,
    order_no     varchar(20)       not null,
    user_id      integer               not null,
    order_status smallint default 1 not null,
    snap_img     varchar(255)      null,
    snap_name    varchar(80)       null,
    snap_items   text              null,
    snap_address varchar(500)      null,
    total_count  integer     default 0 not null,
    total_price  decimal(6, 2)     not null,
    prepay_id    varchar(100)      null,
    create_time  integer               null,
    update_time  integer               null,
    delete_time  integer               null,
    constraint order_no
        unique (order_no)
);

create index order_user_id
    on "order" (user_id);

INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (1, 'B0X435186095427189', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 2, "has_stock": true, "count": 10, "name": "梨花带雨 3个", "total_price": 0.1}]', '{"city": "杭州市", "country": "人才科技园 S1-1101", "detail": "", "id": 2, "mobile": "13788889999", "name": "董小小", "province": "浙江省", "user_id": 2}', 20, 0.20, null, 1588130000, 1628692672, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (2, 'B0X439892335427188', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 2, "has_stock": true, "count": 10, "name": "梨花带雨 3个", "total_price": 0.1}]', '{"city": "杭州市", "country": "人才科技园 S1-1101", "detail": "", "id": 2, "mobile": "13788889999", "name": "董小小", "province": "浙江省", "user_id": 2}', 20, 0.20, null, 1588131000, 1628692680, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (18, 'B0X433513735427169', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 2, "has_stock": true, "count": 10, "name": "梨花带雨 3个", "total_price": 0.1}]', '{"city": "杭州市", "country": "人才科技园 S1-1101", "detail": "", "id": 2, "mobile": "13788889999", "name": "董小小", "province": "浙江省", "user_id": 2}', 20, 0.20, null, 1588132000, 1628692687, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (19, 'B0X431906695427191', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 2, "has_stock": true, "count": 10, "name": "梨花带雨 3个", "total_price": 0.1}]', '{"city": "杭州市", "country": "人才科技园 S1-1101", "detail": "", "id": 2, "mobile": "13788889999", "name": "董小小", "province": "浙江省", "user_id": 2}', 20, 0.20, null, 1588133000, 1628692695, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (22, 'B0X436611625427134', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 2, "has_stock": true, "count": 10, "name": "梨花带雨 3个", "total_price": 0.1}]', '{"city": "杭州市", "country": "人才科技园 S1-1101", "detail": "", "id": 2, "mobile": "13788889999", "name": "董小小", "province": "浙江省", "user_id": 2}', 20, 0.20, null, 1588134000, 1628692704, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (23, 'B0X434107455427153', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 2, "has_stock": true, "count": 10, "name": "梨花带雨 3个", "total_price": 0.1}]', '{"city": "杭州市", "country": "人才科技园 S1-1101", "detail": "", "id": 2, "mobile": "13788889999", "name": "董小小", "province": "浙江省", "user_id": 2}', 20, 0.20, null, 1588135000, 1628692711, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (24, 'B0X436584155427116', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 2, "has_stock": true, "count": 10, "name": "梨花带雨 3个", "total_price": 0.1}]', '{"city": "杭州市", "country": "人才科技园 S1-1101", "detail": "", "id": 2, "mobile": "13788889999", "name": "董小小", "province": "浙江省", "user_id": 2}', 20, 0.20, null, 1588136000, 1628692732, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (25, 'B0XB42397767285726', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 2, "has_stock": true, "count": 10, "name": "梨花带雨 3个", "total_price": 0.1}]', '{"city": "杭州市", "country": "中国", "detail": "人才科技园 S1-1101", "mobile": 13788889999, "name": "段兵兵", "province": "浙江省"}', 20, 0.20, null, 1588137000, 1628692744, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (26, 'B0XB43649737285735', 1, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤 等', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}, {"id": 11, "has_stock": true, "count": 10, "name": "贵妃笑 100克", "total_price": 0.1}]', '{"city": "杭州市", "country": "中国", "detail": "人才科技园 S1-1101", "mobile": 13788889999, "name": "段兵兵", "province": "浙江省"}', 20, 0.20, null, 1588138000, 1628692723, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (27, 'B0XB40017347285790', 1, 1, '0.0.0.0:8010/static/images/product-rice@1.png', '素米 327克 等', '[{"id": 3, "has_stock": true, "count": 10, "name": "素米 327克", "total_price": 0.1}, {"id": 4, "has_stock": true, "count": 10, "name": "红袖枸杞 6克*3袋", "total_price": 0.1}]', '{"city": "杭州市", "country": "中国", "detail": "人才科技园 S1-1101", "mobile": 13788889999, "name": "段兵兵", "province": "浙江省"}', 20, 0.20, null, 1588138500, 1628692664, null);
INSERT INTO "order" (id, order_no, user_id, order_status, snap_img, snap_name, snap_items, snap_address, total_count, total_price, prepay_id, create_time, update_time, delete_time) VALUES (28, 'C0X4262413568787205', 3, 1, '0.0.0.0:8010/static/images/product-vg@1.png', '芹菜 半斤', '[{"id": 1, "has_stock": true, "count": 10, "name": "芹菜 半斤", "total_price": 0.1}]', '{"city": "杭州", "country": "萧山", "detail": "欢天喜地2栋2单元666室", "mobile": 13799999999, "name": "苏小小", "province": "浙江"}', 10, 0.10, null, 1588139000, 1628692649, null);
create table order_product
(
    order_id    integer not null,
    product_id  integer not null,
    count       integer not null,
    create_time integer null,
    update_time integer null,
    delete_time integer null,
    primary key (product_id, order_id)
);

INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (1, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (2, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (18, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (19, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (22, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (23, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (24, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (25, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (26, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (28, 1, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (1, 2, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (2, 2, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (18, 2, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (19, 2, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (22, 2, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (23, 2, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (24, 2, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (25, 2, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (27, 3, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (27, 4, 10, null, null, null);
INSERT INTO order_product (order_id, product_id, count, create_time, update_time, delete_time) VALUES (26, 11, 10, null, null, null);
create table product
(
    id           SERIAL PRIMARY KEY,
    name         varchar(80)       not null,
    price        decimal(6, 2)     not null,
    stock        integer     default 0 not null,
    category_id  integer               null,
    main_img_url varchar(255)      null,
    "from"       smallint default 1 not null,
    summary      varchar(50)       null,
    img_id       integer               null,
    create_time  integer               null,
    update_time  integer               null,
    delete_time  integer               null
);

INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (1, '芹菜 半斤', 0.01, 998, 3, '/product-vg@1.png', 1, null, 13, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (2, '梨花带雨 3个', 0.01, 984, 2, '/product-dryfruit@1.png', 1, null, 10, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (3, '素米 327克', 0.01, 996, 7, '/product-rice@1.png', 1, null, 31, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (4, '红袖枸杞 6克*3袋', 0.01, 998, 6, '/product-tea@1.png', 1, null, 32, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (5, '春生龙眼 500克', 0.01, 995, 2, '/product-dryfruit@2.png', 1, null, 33, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (6, '小红的猪耳朵 120克', 0.01, 997, 5, '/product-cake@2.png', 1, null, 53, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (7, '泥蒿 半斤', 0.01, 998, 3, '/product-vg@2.png', 1, null, 68, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (8, '夏日芒果 3个', 0.01, 995, 2, '/product-dryfruit@3.png', 1, null, 36, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (9, '冬木红枣 500克', 0.01, 996, 2, '/product-dryfruit@4.png', 1, null, 37, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (10, '万紫千凤梨 300克', 0.01, 996, 2, '/product-dryfruit@5.png', 1, null, 38, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (11, '贵妃笑 100克', 0.01, 994, 2, '/product-dryfruit-a@6.png', 1, null, 39, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (12, '珍奇异果 3个', 0.01, 999, 2, '/product-dryfruit@7.png', 1, null, 40, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (13, '绿豆 125克', 0.01, 999, 7, '/product-rice@2.png', 1, null, 41, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (14, '芝麻 50克', 0.01, 999, 7, '/product-rice@3.png', 1, null, 42, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (15, '猴头菇 370克', 0.01, 999, 7, '/product-rice@4.png', 1, null, 43, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (16, '西红柿 1斤', 0.01, 999, 3, '/product-vg@3.png', 1, null, 69, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (17, '油炸花生 300克', 0.01, 999, 4, '/product-fry@1.png', 1, null, 44, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (18, '春泥西瓜子 128克', 0.01, 997, 4, '/product-fry@2.png', 1, null, 45, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (19, '碧水葵花籽 128克', 0.01, 999, 4, '/product-fry@3.png', 1, null, 46, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (20, '碧螺春 12克*3袋', 0.01, 999, 6, '/product-tea@2.png', 1, null, 47, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (21, '西湖龙井 8克*3袋', 0.01, 998, 6, '/product-tea@3.png', 1, null, 48, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (22, '梅兰清花糕 1个', 0.01, 997, 5, '/product-cake-a@3.png', 1, null, 54, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (23, '清凉薄荷糕 1个', 0.01, 998, 5, '/product-cake-a@4.png', 1, null, 55, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (25, '小明的妙脆角 120克', 0.01, 999, 5, '/product-cake@1.png', 1, null, 52, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (26, '红衣青瓜 混搭160克', 0.01, 999, 2, '/product-dryfruit@8.png', 1, null, 56, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (27, '锈色瓜子 100克', 0.01, 998, 4, '/product-fry@4.png', 1, null, 57, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (28, '春泥花生 200克', 0.01, 999, 4, '/product-fry@5.png', 1, null, 58, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (29, '冰心鸡蛋 2个', 0.01, 999, 7, '/product-rice@5.png', 1, null, 59, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (30, '八宝莲子 200克', 0.01, 999, 7, '/product-rice@6.png', 1, null, 14, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (31, '深涧木耳 78克', 0.01, 999, 7, '/product-rice@7.png', 1, null, 60, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (32, '土豆 半斤', 0.01, 999, 3, '/product-vg@4.png', 1, null, 66, null, null, null);
INSERT INTO product (id, name, price, stock, category_id, main_img_url, "from", summary, img_id, create_time, update_time, delete_time) VALUES (33, '青椒 半斤', 0.01, 999, 3, '/product-vg@5.png', 1, null, 67, null, null, null);
create table product_image
(
    img_id      integer           not null,
    "order"     integer default 0 not null,
    product_id  integer           not null,
    create_time integer           null,
    update_time integer           null,
    delete_time integer           null,
    primary key (img_id, "order")
);

INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (19, 1, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (20, 2, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (21, 3, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (22, 4, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (23, 5, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (24, 6, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (25, 7, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (26, 8, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (27, 9, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (28, 11, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (29, 10, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (62, 12, 11, null, null, null);
INSERT INTO product_image (img_id, "order", product_id, create_time, update_time, delete_time) VALUES (63, 13, 11, null, null, null);
create table product_property
(
    id          SERIAL PRIMARY KEY,
    name        varchar(30) default '' null,
    detail      varchar(255)           not null,
    product_id  integer                    not null,
    create_time integer                    null,
    update_time integer                    null,
    delete_time integer                    null
);

INSERT INTO product_property (id, name, detail, product_id, create_time, update_time, delete_time) VALUES (1, '品名', '杨梅', 11, null, null, null);
INSERT INTO product_property (id, name, detail, product_id, create_time, update_time, delete_time) VALUES (2, '口味', '青梅味 雪梨味 黄桃味 菠萝味', 11, null, null, null);
INSERT INTO product_property (id, name, detail, product_id, create_time, update_time, delete_time) VALUES (3, '产地', '火星', 11, null, null, null);
INSERT INTO product_property (id, name, detail, product_id, create_time, update_time, delete_time) VALUES (4, '保质期', '180天', 11, null, null, null);
INSERT INTO product_property (id, name, detail, product_id, create_time, update_time, delete_time) VALUES (5, '品名', '梨子', 2, null, null, null);
INSERT INTO product_property (id, name, detail, product_id, create_time, update_time, delete_time) VALUES (6, '产地', '金星', 2, null, null, null);
INSERT INTO product_property (id, name, detail, product_id, create_time, update_time, delete_time) VALUES (7, '净含量', '100g', 2, null, null, null);
INSERT INTO product_property (id, name, detail, product_id, create_time, update_time, delete_time) VALUES (8, '保质期', '10天', 2, null, null, null);
create table route
(
    id        integer
        primary key,
    parent_id integer          not null,
    title     varchar(20)  not null,
    name      varchar(20)  null,
    icon      varchar(100) null,
    path      varchar(100) not null,
    component varchar(100) null,
    hidden    boolean   not null,
    "order"   integer          null,
    constraint name
        unique (name)
);

INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (1, 0, '首页', 'Main', 'fa fa-th-large', '/main', null, false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (3, 1, '主页面', 'Home', 'fa fa-align-justify', '/home', 'home/index', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (4, 1, '规范指南', 'Guide', 'fa fa-align-justify', '/guide', 'guide/index', false, 1);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (5, 0, '关于', 'About', 'fa fa-info', '/about', null, false, 1);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (6, 5, '关于', 'AboutIndex', 'fa fa-align-justify', '/about/index', 'about/index', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (7, 0, '系统管理', 'Admin', 'fa fa-cog', '/admin', null, false, 4);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (8, 7, '用户管理', 'AdminUser', 'fa fa-align-justify', '/admin/user', 'admin/user/index', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (9, 7, '权限管理', 'AdminApi', 'fa fa-align-justify', '/admin/auth', 'admin/auth/index', false, 1);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (10, 7, '菜单管理', 'AdminMenu', 'fa fa-align-justify', '/admin/menu', 'admin/menu/index', false, 2);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (11, 0, '文件管理', 'File', 'fa fa-folder-o', '/file', null, false, 7);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (12, 11, '文件管理', 'FileIndex', 'fa fa-align-justify', '/file/index', 'file/index', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (13, 0, '系统工具', 'Tool', 'fa fa-wrench', '/tool', null, false, 5);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (14, 16, 'Json格式化', 'JsonView', 'fa fa-edit', '/component/json-view', 'components/json-view', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (15, 13, '表单构建', 'FormBuilder', 'fa fa-list-ul', '/tool/build', 'tools/build/index', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (16, 0, '组件管理', 'ComponentLib', 'fa fa-cogs', '/component', '', false, 6);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (17, 13, '错误码', 'ErrorCode', 'fa fa-file-word-o', '/tool/error-code', 'tools/error-code/index', false, 1);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (18, 13, '接口文档', 'Swagger', 'fa fa-book', '/tool/swagger', 'tools/swagger/index', false, 2);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (19, 0, '文章管理', 'Article', 'fa fa-file-text-o', '/article', null, false, 8);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (20, 19, '新增文章', 'ArticleAdd', 'fa fa-align-justify', '/article/add', 'article/add', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (21, 19, '文章列表', 'ArticleList', 'fa fa-align-justify', '/article/list', 'article/index', false, 1);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (22, 19, '编辑文章', 'ArticleEdit', 'fa fa-align-justify', '/article/edit/:id', 'article/edit', true, 2);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (23, 7, '字典管理', 'AdminDict', 'fa fa-align-justify', '/admin/dict', 'admin/dict/index', false, 3);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (24, 7, '字典数据', 'AdminDictData', 'fa fa-align-justify', '/admin/dict/data/:id', 'admin/dict/dict-data', true, 4);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (25, 7, '日志管理', 'AdminLog', 'fa fa-pencil-square-o', '/admin/log', null, false, 7);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (26, 25, '登录日志', 'LoginLog', 'fa fa-sign-in', '/admin/log/login-log', 'admin/log/login-log', false, 1);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (27, 25, '操作日志', 'OperLog', 'fa fa-keyboard-o', '/admin/log/oper-log', 'admin/log/oper-log', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (28, 7, '通知管理', 'Notice', 'fa fa-align-justify', '/admin/notice', 'admin/notice/index', false, 6);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (29, 16, '富文本', 'Tinymce', 'fa fa-edit', '/component/tinymce', 'components/tinymce/index', false, 1);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (30, 7, '参数管理', 'AdminConfig', 'fa fa-list-ol', '/admin/config', 'admin/config/index', false, 5);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (31, 0, '类别管理', 'Category', 'fa fa-table', '/category', '', false, 3);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (32, 31, '类别列表', 'CategoryIndex', 'fa fa-align-justify', '/category/index', 'category/index', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (33, 0, 'Banner管理', 'Banner', 'fa fa-ellipsis-h', '/banner', null, false, 2);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (34, 33, 'Banner列表', 'BannerIndex', 'fa fa-ellipsis-h', '/banner/index', 'banner/index', false, 0);
INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (36, 16, 'Ueditor', 'Ueditor', 'fa fa-edit', '/component/Ueditor', 'components/ueditor/index', false, 0);
create table theme
(
    id           SERIAL PRIMARY KEY,
    name         varchar(50)  not null,
    description  varchar(255) null,
    topic_img_id integer          not null,
    head_img_id  integer          not null,
    create_time  integer          null,
    update_time  integer          null,
    delete_time  integer          null
);

INSERT INTO theme (id, name, description, topic_img_id, head_img_id, create_time, update_time, delete_time) VALUES (1, '专题栏位一', '美味水果世界', 16, 49, null, null, null);
INSERT INTO theme (id, name, description, topic_img_id, head_img_id, create_time, update_time, delete_time) VALUES (2, '专题栏位二', '新品推荐', 17, 50, null, null, null);
INSERT INTO theme (id, name, description, topic_img_id, head_img_id, create_time, update_time, delete_time) VALUES (3, '专题栏位三', '做个干物女', 18, 51, null, null, null);
create table theme_product
(
    theme_id    integer not null,
    product_id  integer not null,
    create_time integer null,
    update_time integer null,
    delete_time integer null,
    primary key (theme_id, product_id)
);

INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (1, 2, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (1, 5, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (1, 8, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (1, 10, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (1, 12, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (2, 1, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (2, 2, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (2, 3, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (2, 5, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (2, 6, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (2, 16, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (2, 33, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (3, 15, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (3, 18, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (3, 19, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (3, 27, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (3, 30, null, null, null);
INSERT INTO theme_product (theme_id, product_id, create_time, update_time, delete_time) VALUES (3, 31, null, null, null);
create table third_app
(
    id                SERIAL PRIMARY KEY,
    app_id            varchar(64)  not null,
    app_secret        varchar(64)  not null,
    app_description   varchar(100) null,
    scope             varchar(20)  not null,
    scope_description varchar(100) null,
    create_time       integer          null,
    update_time       integer          null,
    delete_time       integer          null
);

INSERT INTO third_app (id, app_id, app_secret, app_description, scope, scope_description, create_time, update_time, delete_time) VALUES (1, 'starcraft', '777*777', 'CMS', '32', 'Super', null, null, null);
create table "user"
(
    id          SERIAL PRIMARY KEY,
    nickname    varchar(50)  null,
    auth        smallint     null,
    group_id    integer          null,
    avatar      varchar(255) null,
    extend      varchar(255) null,
    create_time integer          null,
    update_time integer          null,
    delete_time integer          null
);

INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (1, 'Boss', 2, 1, 'http://abc/xzy.jpg', null, 1588138125, 1592674088, null);
INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (2, '小叶', 1, 1, null, null, null, 1592674088, null);
INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (3, '小董', 1, 1, null, null, 1587102577, 1592674088, null);
INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (4, 'Allen7D', 1, 1, null, null, null, 1592879250, null);
INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (24, 'Allen9D', 1, 2, null, null, null, null, null);
INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (25, 'Allen8D', 1, 2, null, null, null, null, null);
INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (27, '笑呵呵', 1, 3, null, null, 1587024920, 1587029097, null);
INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (30, '宋仁投', 1, 6, null, null, 1587043791, 1588686249, null);
INSERT INTO "user" (id, nickname, auth, group_id, avatar, extend, create_time, update_time, delete_time) VALUES (31, 'Allen1D', 1, 6, null, null, 1588134674, 1588686249, null);

create table banner_item
(
    id          SERIAL PRIMARY KEY,
    banner_id   integer          null,
    img_id      integer          null,
    key_word    varchar(100) null,
    type        smallint     null,
    create_time integer          null,
    update_time integer          null,
    delete_time integer          null,
    constraint banner_item_ibfk_1
        foreign key (banner_id) references banner (id),
    constraint banner_item_ibfk_2
        foreign key (img_id) references image (id)
);

create index banner_id
    on banner_item (banner_id);

create index img_id
    on banner_item (img_id);

INSERT INTO banner_item (id, banner_id, img_id, key_word, type, create_time, update_time, delete_time) VALUES (1, 1, 65, '6', 1, 1528938338, null, null);
INSERT INTO banner_item (id, banner_id, img_id, key_word, type, create_time, update_time, delete_time) VALUES (2, 1, 2, '25', 1, 1528938338, null, null);
INSERT INTO banner_item (id, banner_id, img_id, key_word, type, create_time, update_time, delete_time) VALUES (3, 1, 3, '11', 1, 1528938338, null, null);
INSERT INTO banner_item (id, banner_id, img_id, key_word, type, create_time, update_time, delete_time) VALUES (4, 1, 1, '10', 1, 1528938338, null, null);
create table element
(
    id SERIAL PRIMARY KEY,
    name     varchar(50) null,
    sign     varchar(50) null,
    route_id integer         not null,
    constraint element_ibfk_1
        foreign key (route_id) references route (id)
);

create index element_route_id
    on element (route_id);


create table menu
(
    group_id integer not null,
    route_id integer not null,
    primary key (group_id, route_id),
    constraint menu_ibfk_1
        foreign key (group_id) references "group" (id),
    constraint menu_ibfk_2
        foreign key (route_id) references route (id)
);

create index menu_route_id
    on menu (route_id);

INSERT INTO route (id, parent_id, title, name, icon, path, component, hidden, "order") VALUES (0, 0, '根目录', 'Root', null, '/', null, false, 0);

INSERT INTO menu (group_id, route_id) VALUES (1, 0);
INSERT INTO menu (group_id, route_id) VALUES (1, 1);
INSERT INTO menu (group_id, route_id) VALUES (1, 3);
INSERT INTO menu (group_id, route_id) VALUES (1, 4);
INSERT INTO menu (group_id, route_id) VALUES (1, 5);
INSERT INTO menu (group_id, route_id) VALUES (1, 6);
INSERT INTO menu (group_id, route_id) VALUES (1, 7);
INSERT INTO menu (group_id, route_id) VALUES (1, 8);
INSERT INTO menu (group_id, route_id) VALUES (1, 9);
INSERT INTO menu (group_id, route_id) VALUES (1, 10);
INSERT INTO menu (group_id, route_id) VALUES (1, 11);
INSERT INTO menu (group_id, route_id) VALUES (1, 12);
create table article
(
    id          SERIAL PRIMARY KEY,
    author_id   integer          not null,
    type        smallint     null,
    title       varchar(255) null,
    summary     text         null,
    content     text         null,
    theme       smallint     null,
    img         varchar(255) null,
    views       integer          null,
    create_time integer          null,
    update_time integer          null,
    delete_time integer          null,
    constraint article_ibfk_1
        foreign key (author_id) references "user" (id)
);

create index author_id
    on article (author_id);

INSERT INTO article (id, author_id, type, title, summary, content, theme, img, views, create_time, update_time, delete_time) VALUES (1, 1, 1, '***', '***', '***', null, null, 8, 1590480321, 1592639188, 1592639188);
INSERT INTO article (id, author_id, type, title, summary, content, theme, img, views, create_time, update_time, delete_time) VALUES (2, 1, 1, '工控安全大数据存储平台', 'AiLPHA大数据智能安全平台能够提供基于大数据技术的多源...', 'AiLPHA大数据智能安全平台能够提供基于大数据技术的多源异构数据收集服务能力，依托于分布式复杂事件处理引擎进行安全建模分析与运营框架编排，实现安全事件攻击溯源与威胁回放并剔除误报，提升安全运维效率。', null, null, 10, 1590483315, 1593587208, null);
INSERT INTO article (id, author_id, type, title, summary, content, theme, img, views, create_time, update_time, delete_time) VALUES (3, 1, 1, '大数据智能安全解决方案', null, '依托大数据态势感知与智能防控国家地方联合工程研究中心，开展网络安 全、大数据与人工智能的交叉领域的前沿研究与落地。', null, null, 1, 1590483277, 1590483323, null);
INSERT INTO article (id, author_id, type, title, summary, content, theme, img, views, create_time, update_time, delete_time) VALUES (4, 1, 1, '工控安全大数据存储平台研发', 'AiLPHA大数据智能安全平台能够提供基于大数据技术的多源异构数据收集服务能力，依托于分布式复杂事件处理引擎进行安全建模...', 'AiLPHA大数据智能安全平台能够提供基于大数据技术的多源异构数据收集服务能力，依托于分布式复杂事件处理引擎进行安全建模分析与运营框架编排，实现安全事件攻击溯源与威胁回放并剔除误报，提升安全运维效率。', null, null, 4, 1590483439, 1592645411, null);
INSERT INTO article (id, author_id, type, title, summary, content, theme, img, views, create_time, update_time, delete_time) VALUES (5, 1, 1, '工控+AI平台', '大数据智能安全解决方案', '<h2>大数据智能安全解决方案</h2>
<p>AiLPHA大数据智能安全平台能够提供基于大数据技术的多源异构数据收集服务能力，依托于分布式复杂事件处理引擎进行安全建模分析与运营框架编排，实现安全事件攻击溯源与威胁回放并剔除误报，提升安全运维效率。</p>
<h3>核心功能 FEATURES</h3>
<p><img src="https://www.dbappsecurity.com.cn/uploadfile/2019/06/05/20190605173643gwLZk0.jpg" width="741" height="347" /></p>
<h3>平台优势 ADVANTAGE</h3>
<h4>占据行业制高点</h4>
<p>应用于国家部委、大型央企、省级公安、电信运营商、金融等众多客户(已 服务100+客户)，提供全面智能安全解决方案。</p>
<h4>智能分析引擎</h4>
<p>推出大数据智能复杂安全事件关联分析系统，支持智能安全建模和自动化编 排。从而实现精准告警、未知及高级威胁的检测以及追踪溯源。</p>
<h4>国家地方联合工程研究中心</h4>
<p>依托大数据态势感知与智能防控国家地方联合工程研究中心，开展网络安 全、大数据与人工智能的交叉领域的前沿研究与落地。</p>
<h4>市场份额排名第一</h4>
<p>&ldquo;凭借在网络安全大数据与人工智能等前沿技术领域的产品化转速度，日志审计 产品市场份额排名第一&rdquo; &mdash;&mdash;引自赛迪顾问研究报告</p>
<h4>开放兼容 灵活部署</h4>
<p>致力于为全面大、中、小型政企客户提供基于大数据分析的智能安全解决方案。</p>
<h4>重大活动安保应用实战</h4>
<p>为2016中国杭州G20峰会;连续五届世界互联网大会;2017金砖峰会; 2018青岛上合峰会、上海进博会等提供重要安保技术支撑。</p>
<p>。</p>', null, null, 13, 1590484135, 1592449857, null);
create table identity
(
    id          SERIAL PRIMARY KEY,
    user_id     integer          not null,
    type        integer          not null,
    identifier  varchar(100) null,
    credential  varchar(255) null,
    verified    smallint     null,
    create_time integer          null,
    update_time integer          null,
    delete_time integer          null,
    constraint identifier
        unique (identifier),
    constraint identity_ibfk_1
        foreign key (user_id) references "user" (id)
);

create index identity_user_id
    on identity (user_id);

INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (1, 3, 101, '666@qq.com', 'pbkdf2:sha256:150000$Oh2TxEHw$e497614a0209566491df406275aca2a15ea45c42c4c5132526c323bbfd530fab', 1, 1586767003, 1587019825, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (2, 3, 200, 'oYf_s0OnCim9Cx7tCV-AHs_rDWXs', null, 1, 1586767003, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (3, 1, 101, '999@qq.com', 'pbkdf2:sha256:150000$0YA1wZOx$028783c07999fd6ed8050c2f831857ac602218bcbc2399072f7f50064a30109e', 1, 1586767003, 1592288770, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (4, 3, 100, 'Allen7D', 'pbkdf2:sha256:150000$dlyAHfD8$691ba12bf1e0183f90f70c489ebb89a93040dbc90a733363871453919e476f6d', 1, 1586767003, 1587019825, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (5, 3, 102, '13758787058', 'pbkdf2:sha256:150000$SQwNb0bE$24f9d9ee1372bdf298f7fe70d41f4fb848991049491cd82aff2e9dd7cecba5da', 1, 1586767003, 1587102577, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (7, 2, 101, '777@qq.com', 'pbkdf2:sha256:50000$YrYmLzfp$981a20fc95c1dfc423866be176c0a66b728a95f9c285d6b731af05349112d2f9', 1, 1586767003, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (8, 27, 100, 'Allen2D', 'pbkdf2:sha256:150000$MVGqTbkT$e48eebef1b43782f262c72b9043b706ff27580619e45dae15437c7f9a51cf280', 0, 1587024948, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (9, 27, 102, '13755555555', 'pbkdf2:sha256:150000$sZdQl4R0$fe697627c25a0407b438a304268ff9a681876772482edfdfb3258a863c4b1151', 0, 1587024948, 1587029097, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (10, 27, 101, '555@qq.com', 'pbkdf2:sha256:150000$Jojx9DNW$1307d58aabc221e8a0d098e48877eb00256ff07dbeec439ce38d30b47d82e6cc', 0, 1587024956, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (14, 30, 100, 'Allen3D', 'pbkdf2:sha256:150000$vHwJolCh$a77780e06b034058a5b0ac2263dd965b9539916464e80ad747bd51a3c5465c73', 1, 1587043791, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (15, 30, 102, '13758787053', 'pbkdf2:sha256:150000$fJpShyPb$e2fe9caae9780a81bc351cc4d289c6be9a2be4b6176dc7ad012b58867580da1a', 0, 1587043792, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (18, 1, 102, '13758787011', 'pbkdf2:sha256:150000$RtZqKtDN$fd2cb930047b2e934a1c65198ab213f79d3fef99f5670e9344e133eee7956e69', 0, 1588134197, 1592288770, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (19, 31, 100, 'Allen1D', 'pbkdf2:sha256:150000$vV7OHnCT$dbb29421d70d1d831c1bd12106ce95c026c143772b45a598f4f0ecc732070c69', 1, 1588134674, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (20, 31, 102, '13758787111', 'pbkdf2:sha256:150000$MIOWaCVV$3ac3e942c60dfa1ecf10bc5b102c396edadf79900b54b457e71709e50147ff33', 0, 1588134675, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (21, 31, 101, '111@qq.com', 'pbkdf2:sha256:150000$9AM9MtIo$487496f19fefe828b62e5297f42165637334e14fade766a36cf95e19cd13f3d8', 0, 1588134675, null, null);
INSERT INTO identity (id, user_id, type, identifier, credential, verified, create_time, update_time, delete_time) VALUES (24, 1, 100, 'Boss', 'pbkdf2:sha256:150000$pFccHtr1$3d6a5dd99315504c63033347c476ff67d0905b8cc77591616ea75ae89099b366', 0, 1588140875, 1592288770, null);
create table group_element
(
    group_id   integer not null,
    element_id integer not null,
    primary key (group_id, element_id),
    constraint group_element_ibfk_1
        foreign key (group_id) references "group" (id),
    constraint group_element_ibfk_2
        foreign key (element_id) references element (id)
);

create index group_element_element_id
    on group_element (element_id);

-- Reset sequences after explicit ID inserts
SELECT setval(pg_get_serial_sequence('address', 'id'), 2);
SELECT setval(pg_get_serial_sequence('article', 'id'), 5);
SELECT setval(pg_get_serial_sequence('auth', 'id'), 3);
SELECT setval(pg_get_serial_sequence('banner', 'id'), 1);
SELECT setval(pg_get_serial_sequence('banner_item', 'id'), 4);
SELECT setval(pg_get_serial_sequence('category', 'id'), 7);
SELECT setval(pg_get_serial_sequence('config', 'id'), 4);
SELECT setval(pg_get_serial_sequence('dict', 'id'), 5);
SELECT setval(pg_get_serial_sequence('dict_type', 'id'), 16);
SELECT setval(pg_get_serial_sequence('identity', 'id'), 24);
SELECT setval(pg_get_serial_sequence('image', 'id'), 69);
SELECT setval(pg_get_serial_sequence('login_log', 'id'), 289);
SELECT setval(pg_get_serial_sequence('oper_log', 'id'), 11);
SELECT setval(pg_get_serial_sequence('product', 'id'), 33);
SELECT setval(pg_get_serial_sequence('product_property', 'id'), 8);
SELECT setval(pg_get_serial_sequence('theme', 'id'), 3);
SELECT setval(pg_get_serial_sequence('third_app', 'id'), 1);
SELECT setval(pg_get_serial_sequence('user', 'id'), 31);
SELECT setval(pg_get_serial_sequence('group', 'id'), 6);
SELECT setval(pg_get_serial_sequence('order', 'id'), 28);
SELECT setval(pg_get_serial_sequence('file', 'id'), 16);
SELECT setval(pg_get_serial_sequence('notice', 'id'), 5);

-- Table and column comments
COMMENT ON COLUMN "address"."name" IS '收获人姓名';
COMMENT ON COLUMN "address"."mobile" IS '手机号';
COMMENT ON COLUMN "address"."province" IS '省';
COMMENT ON COLUMN "address"."city" IS '市';
COMMENT ON COLUMN "address"."country" IS '区';
COMMENT ON COLUMN "address"."detail" IS '详细地址';
COMMENT ON COLUMN "address"."user_id" IS '外键';
COMMENT ON COLUMN "address"."create_time" IS '创建时间';
COMMENT ON COLUMN "address"."update_time" IS '更新时间';
COMMENT ON COLUMN "address"."delete_time" IS '删除时间';
COMMENT ON COLUMN "article"."author_id" IS '外键，用户id';
COMMENT ON COLUMN "article"."type" IS '文章类型';
COMMENT ON COLUMN "article"."title" IS '文章标题';
COMMENT ON COLUMN "article"."summary" IS '文章摘要';
COMMENT ON COLUMN "article"."content" IS '文章内容';
COMMENT ON COLUMN "article"."theme" IS '文章主题';
COMMENT ON COLUMN "article"."img" IS '主图路径';
COMMENT ON COLUMN "article"."views" IS '浏览量';
COMMENT ON COLUMN "article"."create_time" IS '创建时间';
COMMENT ON COLUMN "article"."update_time" IS '更新时间';
COMMENT ON COLUMN "article"."delete_time" IS '删除时间';
COMMENT ON TABLE "auth" IS '权限';
COMMENT ON COLUMN "auth"."group_id" IS '所属权限组id';
COMMENT ON COLUMN "auth"."name" IS '权限字段';
COMMENT ON COLUMN "auth"."module" IS '权限的模块';
COMMENT ON TABLE "banner" IS 'banner管理';
COMMENT ON COLUMN "banner"."name" IS 'Banner名称，通常作为标识';
COMMENT ON COLUMN "banner"."description" IS 'Banner描述';
COMMENT ON COLUMN "banner_item"."banner_id" IS '外键，所属Banner组id';
COMMENT ON COLUMN "banner_item"."img_id" IS '外键，关联image表';
COMMENT ON COLUMN "banner_item"."key_word" IS '执行关键字，根据不同的type含义不同';
COMMENT ON COLUMN "banner_item"."type" IS '跳转类型，可能导向商品，可能导向专题，可能导向其他。0，无导向；1：导向商品;2:导向专题';
COMMENT ON COLUMN "banner_item"."create_time" IS '创建时间';
COMMENT ON COLUMN "banner_item"."update_time" IS '更新时间';
COMMENT ON COLUMN "banner_item"."delete_time" IS '删除时间';
COMMENT ON TABLE "category" IS '商品类目';
COMMENT ON COLUMN "category"."name" IS '分类名称';
COMMENT ON COLUMN "category"."topic_img_id" IS '外键，关联image表';
COMMENT ON COLUMN "category"."description" IS '描述';
COMMENT ON COLUMN "category"."create_time" IS '创建时间';
COMMENT ON COLUMN "category"."update_time" IS '更新时间';
COMMENT ON COLUMN "category"."delete_time" IS '删除时间';
COMMENT ON COLUMN "config"."name" IS '名称';
COMMENT ON COLUMN "config"."key" IS '键名';
COMMENT ON COLUMN "config"."value" IS '键值';
COMMENT ON COLUMN "config"."type" IS '是否系统内置(True是, False否)';
COMMENT ON COLUMN "config"."remark" IS '备注';
COMMENT ON COLUMN "dict"."order" IS '字典排序';
COMMENT ON COLUMN "dict"."label" IS '字典标签';
COMMENT ON COLUMN "dict"."value" IS '字典键值';
COMMENT ON COLUMN "dict"."type" IS '字典类型';
COMMENT ON COLUMN "dict"."css_class" IS '样式属性（其他样式扩展）';
COMMENT ON COLUMN "dict"."list_class" IS '表格回显样式';
COMMENT ON COLUMN "dict"."is_default" IS '是否默认(True是, False否)';
COMMENT ON COLUMN "dict"."status" IS '状态(True正常, False停用)';
COMMENT ON COLUMN "dict"."remark" IS '备注';
COMMENT ON COLUMN "dict_type"."name" IS '字典名称';
COMMENT ON COLUMN "dict_type"."type" IS '字典类型';
COMMENT ON COLUMN "dict_type"."status" IS '状态(True正常, False停用)';
COMMENT ON COLUMN "dict_type"."remark" IS '备注';
COMMENT ON COLUMN "element"."name" IS '名称';
COMMENT ON COLUMN "element"."sign" IS '元素标识';
COMMENT ON COLUMN "file"."create_time" IS '创建时间';
COMMENT ON COLUMN "file"."update_time" IS '更新时间';
COMMENT ON COLUMN "file"."delete_time" IS '删除时间';
COMMENT ON COLUMN "file"."parent_id" IS '父级目录id';
COMMENT ON COLUMN "file"."uuid_name" IS '唯一名称';
COMMENT ON COLUMN "file"."name" IS '原始名称';
COMMENT ON COLUMN "file"."path" IS '路径';
COMMENT ON COLUMN "file"."extension" IS '后缀';
COMMENT ON COLUMN "file"."from" IS '来源: 1 本地，2 公网';
COMMENT ON COLUMN "file"."size" IS '大小';
COMMENT ON COLUMN "file"."md5" IS '文件md5值，防止上传重复文件';
COMMENT ON COLUMN "group"."name" IS '权限组名称';
COMMENT ON COLUMN "group"."info" IS '权限组描述';
COMMENT ON COLUMN "identity"."user_id" IS '外键，用户id';
COMMENT ON COLUMN "identity"."type" IS '登录类型';
COMMENT ON COLUMN "identity"."identifier" IS '标识(手机号、邮箱、用户名或第三方应用的唯一标识)';
COMMENT ON COLUMN "identity"."credential" IS '密码凭证(站内的保存密码，站外的不保存或保存token)';
COMMENT ON COLUMN "identity"."verified" IS '是否已经验证';
COMMENT ON COLUMN "identity"."create_time" IS '创建时间';
COMMENT ON COLUMN "identity"."update_time" IS '更新时间';
COMMENT ON COLUMN "identity"."delete_time" IS '删除时间';
COMMENT ON TABLE "image" IS '图片总表';
COMMENT ON COLUMN "image"."url" IS '图片路径';
COMMENT ON COLUMN "image"."from" IS '1 来自本地，2 来自公网';
COMMENT ON COLUMN "image"."create_time" IS '创建时间';
COMMENT ON COLUMN "image"."update_time" IS '更新时间';
COMMENT ON COLUMN "image"."delete_time" IS '删除时间';
COMMENT ON COLUMN "login_log"."user_id" IS '用户id';
COMMENT ON COLUMN "login_log"."user_name" IS '用户当时的昵称';
COMMENT ON COLUMN "login_log"."ip_addr" IS '登录IP地址';
COMMENT ON COLUMN "login_log"."location" IS '登录地点';
COMMENT ON COLUMN "login_log"."browser" IS '浏览器类型';
COMMENT ON COLUMN "login_log"."os" IS '操作系统';
COMMENT ON COLUMN "login_log"."message" IS '提示消息';
COMMENT ON COLUMN "login_log"."status" IS '登录状态(True成功, False失败)';
COMMENT ON COLUMN "login_log"."create_time" IS '访问时间';
COMMENT ON COLUMN "menu"."group_id" IS '外键 权限组ID';
COMMENT ON COLUMN "menu"."route_id" IS '外键 路由节点ID';
COMMENT ON COLUMN "notice"."create_time" IS '创建时间';
COMMENT ON COLUMN "notice"."update_time" IS '更新时间';
COMMENT ON COLUMN "notice"."delete_time" IS '删除时间';
COMMENT ON COLUMN "notice"."type" IS '类型(1通知, 2公告)';
COMMENT ON COLUMN "notice"."title" IS '标题';
COMMENT ON COLUMN "notice"."content" IS '内容';
COMMENT ON COLUMN "notice"."status" IS '状态(0正常 1关闭)';
COMMENT ON COLUMN "notice"."remark" IS '备注';
COMMENT ON COLUMN "notice"."create_by" IS '创建者';
COMMENT ON COLUMN "notice"."update_by" IS '更新者';
COMMENT ON COLUMN "oper_log"."module" IS '系统模块';
COMMENT ON COLUMN "oper_log"."message" IS '日志信息';
COMMENT ON COLUMN "oper_log"."user_id" IS '用户id';
COMMENT ON COLUMN "oper_log"."user_name" IS '用户当时的昵称';
COMMENT ON COLUMN "oper_log"."path" IS '请求路径';
COMMENT ON COLUMN "oper_log"."request_method" IS '请求方法';
COMMENT ON COLUMN "oper_log"."request_param" IS '请求参数';
COMMENT ON COLUMN "oper_log"."endpoint" IS '端点';
COMMENT ON COLUMN "oper_log"."type" IS '业务类型';
COMMENT ON COLUMN "oper_log"."auth" IS '访问哪个权限';
COMMENT ON COLUMN "oper_log"."status_code" IS '请求的http返回码';
COMMENT ON COLUMN "oper_log"."create_time" IS '创建时间';
COMMENT ON COLUMN "order"."order_no" IS '订单号';
COMMENT ON COLUMN "order"."user_id" IS '外键，用户id，注意并不是openid';
COMMENT ON COLUMN "order"."order_status" IS '1:未支付 2:已支付 3:已发货 4:已支付，但库存不足 ';
COMMENT ON COLUMN "order"."snap_img" IS '订单快照·封面';
COMMENT ON COLUMN "order"."snap_name" IS '订单快照·别名';
COMMENT ON COLUMN "order"."snap_items" IS '订单快照·详情';
COMMENT ON COLUMN "order"."snap_address" IS '订单快照·地址信息';
COMMENT ON COLUMN "order"."total_count" IS '订单总量';
COMMENT ON COLUMN "order"."total_price" IS '订单总价';
COMMENT ON COLUMN "order"."prepay_id" IS '预支付ID';
COMMENT ON COLUMN "order"."create_time" IS '创建时间';
COMMENT ON COLUMN "order"."update_time" IS '更新时间';
COMMENT ON COLUMN "order"."delete_time" IS '删除时间';
COMMENT ON COLUMN "order_product"."order_id" IS '联合主键，订单id';
COMMENT ON COLUMN "order_product"."product_id" IS '联合主键，商品id';
COMMENT ON COLUMN "order_product"."count" IS '商品数量';
COMMENT ON COLUMN "order_product"."create_time" IS '创建时间';
COMMENT ON COLUMN "order_product"."update_time" IS '更新时间';
COMMENT ON COLUMN "order_product"."delete_time" IS '删除时间';
COMMENT ON COLUMN "product"."name" IS '商品名称';
COMMENT ON COLUMN "product"."price" IS '价格,单位：分';
COMMENT ON COLUMN "product"."stock" IS '库存量';
COMMENT ON COLUMN "product"."main_img_url" IS '主图ID号，这是一个反范式设计，有一定的冗余';
COMMENT ON COLUMN "product"."from" IS '图片来自 1 本地 ，2公网';
COMMENT ON COLUMN "product"."summary" IS '摘要';
COMMENT ON COLUMN "product"."img_id" IS '图片外键';
COMMENT ON COLUMN "product"."create_time" IS '创建时间';
COMMENT ON COLUMN "product"."update_time" IS '更新时间';
COMMENT ON COLUMN "product"."delete_time" IS '删除时间';
COMMENT ON COLUMN "product_image"."img_id" IS '外键，关联图片表';
COMMENT ON COLUMN "product_image"."order" IS '图片排序序号';
COMMENT ON COLUMN "product_image"."product_id" IS '商品id，外键';
COMMENT ON COLUMN "product_image"."create_time" IS '创建时间';
COMMENT ON COLUMN "product_image"."update_time" IS '更新时间';
COMMENT ON COLUMN "product_image"."delete_time" IS '删除时间';
COMMENT ON COLUMN "product_property"."name" IS '详情属性名称';
COMMENT ON COLUMN "product_property"."detail" IS '详情属性';
COMMENT ON COLUMN "product_property"."product_id" IS '商品id，外键';
COMMENT ON COLUMN "product_property"."create_time" IS '创建时间';
COMMENT ON COLUMN "product_property"."update_time" IS '更新时间';
COMMENT ON COLUMN "product_property"."delete_time" IS '删除时间';
COMMENT ON COLUMN "route"."id" IS '路由节点ID';
COMMENT ON COLUMN "route"."parent_id" IS '路由节点父级ID';
COMMENT ON COLUMN "route"."title" IS '路由节点标签';
COMMENT ON COLUMN "route"."name" IS '路由节点名';
COMMENT ON COLUMN "route"."icon" IS '图标';
COMMENT ON COLUMN "route"."path" IS '路由节点相对路径';
COMMENT ON COLUMN "route"."component" IS '组件路径';
COMMENT ON COLUMN "route"."hidden" IS '路由节点是否隐藏';
COMMENT ON COLUMN "route"."order" IS '路由顺序';
COMMENT ON TABLE "theme" IS '主题信息表';
COMMENT ON COLUMN "theme"."name" IS '专题名称';
COMMENT ON COLUMN "theme"."description" IS '专题描述';
COMMENT ON COLUMN "theme"."topic_img_id" IS '主题图，外键';
COMMENT ON COLUMN "theme"."head_img_id" IS '专题列表页，头图';
COMMENT ON COLUMN "theme"."create_time" IS '创建时间';
COMMENT ON COLUMN "theme"."update_time" IS '更新时间';
COMMENT ON COLUMN "theme"."delete_time" IS '删除时间';
COMMENT ON TABLE "theme_product" IS '主题所包含的商品';
COMMENT ON COLUMN "theme_product"."theme_id" IS '主题外键';
COMMENT ON COLUMN "theme_product"."product_id" IS '商品外键';
COMMENT ON COLUMN "theme_product"."create_time" IS '创建时间';
COMMENT ON COLUMN "theme_product"."update_time" IS '更新时间';
COMMENT ON COLUMN "theme_product"."delete_time" IS '删除时间';
COMMENT ON TABLE "third_app" IS '访问API的各应用账号密码表';
COMMENT ON COLUMN "third_app"."app_id" IS '应用app_id';
COMMENT ON COLUMN "third_app"."app_secret" IS '应用secret';
COMMENT ON COLUMN "third_app"."app_description" IS '应用程序描述';
COMMENT ON COLUMN "third_app"."scope" IS '应用权限';
COMMENT ON COLUMN "third_app"."scope_description" IS '权限描述';
COMMENT ON COLUMN "third_app"."create_time" IS '创建时间';
COMMENT ON COLUMN "third_app"."update_time" IS '更新时间';
COMMENT ON COLUMN "third_app"."delete_time" IS '删除时间';
COMMENT ON COLUMN "user"."nickname" IS '昵称';
COMMENT ON COLUMN "user"."auth" IS '权限';
COMMENT ON COLUMN "user"."group_id" IS '用户所属的权限组id';
COMMENT ON COLUMN "user"."avatar" IS '头像URL';
COMMENT ON COLUMN "user"."extend" IS '额外备注';
COMMENT ON COLUMN "user"."create_time" IS '创建时间';
COMMENT ON COLUMN "user"."update_time" IS '更新时间';
COMMENT ON COLUMN "user"."delete_time" IS '删除时间';