create table sys_post
(
    post_id       bigint                       not null comment '岗位ID'
        primary key,
    tenant_id     varchar(20) default '000000' null comment '租户编号',
    dept_id       bigint                       not null comment '部门id',
    post_code     varchar(64)                  not null comment '岗位编码',
    post_category varchar(100)                 null comment '岗位类别编码',
    post_name     varchar(50)                  not null comment '岗位名称',
    post_sort     int                          not null comment '显示顺序',
    status        char                         not null comment '状态（0正常 1停用）',
    create_dept   bigint                       null comment '创建部门',
    create_by     bigint                       null comment '创建者',
    create_time   datetime                     null comment '创建时间',
    update_by     bigint                       null comment '更新者',
    update_time   datetime                     null comment '更新时间',
    remark        varchar(500)                 null comment '备注'
)
    comment '岗位信息表';

INSERT INTO ruoyi.sys_post (post_id, tenant_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1, '000000', 103, 'ceo', null, '董事长', 1, '0', 103, 1, '2025-08-23 21:51:22', null, null, '');
INSERT INTO ruoyi.sys_post (post_id, tenant_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (2, '000000', 100, 'se', null, '项目经理', 2, '0', 103, 1, '2025-08-23 21:51:22', null, null, '');
INSERT INTO ruoyi.sys_post (post_id, tenant_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (3, '000000', 100, 'hr', null, '人力资源', 3, '0', 103, 1, '2025-08-23 21:51:22', null, null, '');
INSERT INTO ruoyi.sys_post (post_id, tenant_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (4, '000000', 100, 'user', null, '普通员工', 4, '0', 103, 1, '2025-08-23 21:51:22', null, null, '');
