EmploymentSite/doc/待更新脚本

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

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