| 123456789101112131415161718192021222324252627282930313233 |
- 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);
|
