EmploymentSite/doc/待更新脚本

--2024-02-22
ALTER TABLE pc_post RENAME COLUMN trailtime TO trailMonths

--2024-04-10
alter table pc_company add column Longitude varchar(50)
alter table pc_company add column Latitude varchar(50)

--2024-04-12
--一级职业数据插入
insert pc_profession values(UUID(),'','销售/客服',1,1);
insert pc_profession values(UUID(),'','互联网技术',2,1);
insert pc_profession values(UUID(),'','人事/行政',3,1);
insert pc_profession values(UUID(),'','财务/税务/法务',4,1);
insert pc_profession values(UUID(),'','运营',5,1);
insert pc_profession values(UUID(),'','市场/公关',6,1);
insert pc_profession values(UUID(),'','设计',7,1);
insert pc_profession values(UUID(),'','产品',8,1);
insert pc_profession values(UUID(),'','生产制造',9,1);
insert pc_profession values(UUID(),'','通信/电子',10,1);
insert pc_profession values(UUID(),'','建筑/房地产',11,1);
insert pc_profession values(UUID(),'','医药/医疗',12,1);
insert pc_profession values(UUID(),'','生活服务/零售',13,1);
insert pc_profession values(UUID(),'','物流/供应链',14,1);
insert pc_profession values(UUID(),'','采购/贸易',15,1);
insert pc_profession values(UUID(),'','金融',16,1);
insert pc_profession values(UUID(),'','汽车',17,1);
insert pc_profession values(UUID(),'','科研/教育/培训',18,1);
insert pc_profession values(UUID(),'','餐饮',19,1);
insert pc_profession values(UUID(),'','能源/环保/化工',20,1);
insert pc_profession values(UUID(),'','文化/传媒',21,1);
insert pc_profession values(UUID(),'','高级管理',22,1);
insert pc_profession values(UUID(),'','咨询/法律/翻译',23,1);
insert pc_profession values(UUID(),'','酒店/旅游',24,1);
insert pc_profession values(UUID(),'','政府机构/农业',25,1);

-- 2024.4.16
delete from sys_dictionary_item where DictionaryCode='DataRange';

INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable) VALUES ('f06c44b6-a77a-11ed-a6c5-7085c2a9999e', '', 'DataRange', 0, '全部', 0, 1, 0);
INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable) VALUES ('f06cf371-a77a-11ed-a6c5-7085c2a9999e', '', 'DataRange', 1, '市', 10, 1, 0);
INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable) VALUES ('f06cf371-a77a-11ed-a6c5-7185c2a9999e', '', 'DataRange', 2, '区', 20, 1, 0);
INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable) VALUES ('f06cf371-a77a-11ed-a6c5-7285c2a9999e', '', 'DataRange', 3, '机构', 30, 1, 0);
INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable) VALUES ('f06cf371-a77a-11ed-a6c5-7385c2a9999e', '', 'DataRange', 4, '驿站', 40, 1, 0);
INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable) VALUES ('f06cf371-a77a-11ed-a6c5-7485c2a9999e', '', 'DataRange', 5, '企业', 50, 1, 0);
INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable) VALUES ('f06cf371-a77a-11ed-a6c5-7585c3a9999e', '', 'DataRange', 6, '本人', 60, 1, 0);

-- 2024.4.17
alter table pc_site_user add UserNo varchar(50) comment '工号';
alter table pc_site_user add IDCard varchar(100) comment '身份证号';