EmploymentSite/doc/待更新脚本

-- 2024-4-28
ALTER TABLE pc_company CHANGE ProfessionID IndustryID VARCHAR(50);


--2024.4.30 选择标签
create table pc_label(
LabelID varchar(50) primary key not null COMMENT '标签id',
LabelName varchar(50) COMMENT '标签名',
LabelType int COMMENT '标签类型 1-基础标签 2-自定义标签',
BigType int COMMENT '大类型 1-企业 2-人员',
SortNo int COMMENT '排序号',
CreateUserID varchar(50) COMMENT '创建人',
CreateTime datetime COMMENT '创建时间',
ModifyUserID varchar(50) COMMENT '修改人',
ModifyTime datetime COMMENT '修改时间'
) COMMENT '企业、人员标签表';


create table pc_label_jobuser(
LabelID varchar(50) not null COMMENT '标签id',
JobuserID varchar(50) not null COMMENT '人员id'
) COMMENT '人员标签表';
alter table pc_label_jobuser add index pc_label_jobuser_LabelID(LabelID);
alter table pc_label_jobuser add index pc_label_jobuser_JobuserID(JobuserID);

create table pc_label_company(
LabelID varchar(50) not null COMMENT '标签id',
CompanyID varchar(50) not null COMMENT '企业id'
) COMMENT '企业标签表';
alter table pc_label_company add index pc_label_company_LabelID(LabelID);
alter table pc_label_company add index pc_label_company_CompanyID(CompanyID);


 INSERT INTO `sys_dictionary` (`DictionaryCode`, `Name`, `OrderNo`, `RecordStatus`) VALUES
 ('LabelType', '标签类型', 100, 1),
 ('BigType', '企业人员类型', 101, 1);
 INSERT INTO `sys_dictionary_item` (`DictionaryItemID`, `Code`, `DictionaryCode`, `Value`, `Name`, `OrderNo`, `RecordStatus`, `IsEditable`) VALUES
 ('f06c44b6-a77a-11ed-a6c5-7085c2a00000', '', 'LabelType', 1, '基础标签', 0, 1, 0),
 ('f06c44b6-a77a-11ed-a6c5-7085c2a00001', '', 'LabelType', 2, '自定义标签', 1, 1, 0),
 ('f06c44b6-a77a-11ed-a6c5-7085c2a00002', '', 'BigType', 1, '企业', 0, 1, 0),
 ('f06c44b6-a77a-11ed-a6c5-7085c2a00003', '', 'BigType', 2, '人员', 1, 1, 0);

-- 2024-4-30
ALTER TABLE pc_company MODIFY RegisteredCapital DECIMAL(10, 2);


-- 2024.5.6
alter table pc_dotask add taskLevel int comment '任务级别';

alter table pc_dotask_user add completeDesc text comment '完成情况描述';

insert into sys_dictionary
values ('TaskLevel','任务级别','10','1');

INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable)
VALUES ('0ca43465-0b4b-11ef-ad8e-7085c2a9999e', '', 'TaskLevel', 1, '特别重要任务', 10, 1, 0),
       ('1507732b-0b4b-11ef-ad8e-7085c2a9999e', '', 'TaskLevel', 2, '重要任务', 20, 1, 0),
       ('196e4f6d-0b4b-11ef-ad8e-7085c2a9999e', '', 'TaskLevel', 3, '一般任务', 30, 1, 0);

-- 2024-5-6
ALTER TABLE `employmentsitedb`.`pc_jobuser`
ADD COLUMN `Longitude` varchar(50) NULL COMMENT '经度' AFTER `OccupationalLevel`,
ADD COLUMN `Latitude` varchar(50) NULL COMMENT '纬度' AFTER `Longitude`;

-- 2024.5.6
create table pc_label_post(
LabelID varchar(50) not null COMMENT '标签id',
PostID varchar(50) not null COMMENT '岗位id'
) COMMENT '岗位标签表';
alter table pc_label_post add index pc_label_post_LabelID(LabelID);
alter table pc_label_post add index pc_label_post_PostID(PostID);

INSERT INTO `sys_dictionary_item` (`DictionaryItemID`, `Code`, `DictionaryCode`, `Value`, `Name`, `OrderNo`, `RecordStatus`, `IsEditable`) VALUES
 ('f06c44b6-a77a-11ed-a6c5-7085c2a00004', '', 'BigType', 3, '岗位', 1, 1, 0);


 -- 2024.5.7
 alter table pc_jobhunt modify workYear decimal(18,2)