drop table if exists job_category;
create table job_category (
id int NOT NULL AUTO_INCREMENT COMMENT ‘ID’,
category_name varchar(80) NOT NULL COMMENT ‘分类名称’,
category_desc varchar(200) DEFAULT NULL COMMENT ‘分类描述’,
primary key (id) USING BTREE,
unique key category_name_unique (category_name)
) engine=innodb default charset=utf8mb4 comment=‘岗位分类表’ ROW_FORMAT = Dynamic;

insert into job_category (id, category_name, category_desc) values (1, ‘java’, ‘Java开发’);
insert into job_category (id, category_name, category_desc) values (2, ‘web’, ‘前端开发’);
insert into job_category (id, category_name, category_desc) values (3, ‘softwaretest’, ‘软件测试’);
insert into job_category (id, category_name, category_desc) values (4, ‘python’, ‘Python开发’);
insert into job_category (id, category_name, category_desc) values (5, ‘cplusplus’, ‘C++工程师’);
insert into job_category (id, category_name, category_desc) values (6, ‘embedded’, ‘嵌入式工程师’);
insert into job_category (id, category_name, category_desc) values (7, ‘cloudcomputing’, ‘云计算工程师’);
insert into job_category (id, category_name, category_desc) values (8, ‘ai’, ‘人工智能’);
insert into job_category (id, category_name, category_desc) values (9, ‘operation’, ‘运维工程师’);
insert into job_category (id, category_name, category_desc) values (10, ‘other’, ‘其他’);