create table test_demo
(
    id          bigint                       not null comment '主键'
        primary key,
    tenant_id   varchar(20) default '000000' null comment '租户编号',
    dept_id     bigint                       null comment '部门id',
    user_id     bigint                       null comment '用户id',
    order_num   int         default 0        null comment '排序号',
    test_key    varchar(255)                 null comment 'key键',
    value       varchar(255)                 null comment '值',
    version     int         default 0        null comment '版本',
    create_dept bigint                       null comment '创建部门',
    create_time datetime                     null comment '创建时间',
    create_by   bigint                       null comment '创建人',
    update_time datetime                     null comment '更新时间',
    update_by   bigint                       null comment '更新人',
    del_flag    int         default 0        null comment '删除标志'
)
    comment '测试单表';

INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (1, '000000', 102, 4, 1, '测试数据权限', '测试', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (2, '000000', 102, 3, 2, '子节点1', '111', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (3, '000000', 102, 3, 3, '子节点2', '222', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (4, '000000', 108, 4, 4, '测试数据', 'demo', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (5, '000000', 108, 3, 13, '子节点11', '1111', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (6, '000000', 108, 3, 12, '子节点22', '2222', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (7, '000000', 108, 3, 11, '子节点33', '3333', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (8, '000000', 108, 3, 10, '子节点44', '4444', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (9, '000000', 108, 3, 9, '子节点55', '5555', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (10, '000000', 108, 3, 8, '子节点66', '6666', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (11, '000000', 108, 3, 7, '子节点77', '7777', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (12, '000000', 108, 3, 6, '子节点88', '8888', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
INSERT INTO ruoyi.test_demo (id, tenant_id, dept_id, user_id, order_num, test_key, value, version, create_dept, create_time, create_by, update_time, update_by, del_flag) VALUES (13, '000000', 108, 3, 5, '子节点99', '9999', 0, 103, '2025-08-23 21:51:27', 1, null, null, 0);
