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
insert sys_dictionary values('NationType','民族',89,1);
insert sys_dictionary_item values(UUID(),'','NationType',1,'汉族',1,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',2,'蒙古族',2,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',3,'回族',3,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',4,'藏族',4,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',5,'维吾尔族',5,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',6,'苗族',6,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',7,'彝族',7,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',8,'壮族',8,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',9,'布依族',9,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',10,'朝鲜族',10,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',11,'满族',11,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',12,'侗族',12,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',13,'瑶族',13,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',14,'白族',14,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',15,'土家族',15,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',16,'哈尼族',16,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',17,'哈萨克族',17,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',18,'傣族',18,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',19,'黎族',19,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',20,'傈傈族',20,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',21,'佤族',21,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',22,'畲族',22,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',23,'高山族',23,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',24,'拉祜族',24,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',25,'水族',25,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',26,'东乡族',26,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',27,'纳西族',27,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',28,'景颇族',28,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',29,'柯尔克族',29,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',30,'土族',30,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',31,'达斡尔族',31,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',32,'仫佬族',32,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',33,'羌族',33,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',34,'布朗族',34,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',35,'撒拉族',35,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',36,'毛难族',36,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',37,'仡佬族',37,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',38,'锡伯族',38,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',39,'阿昌族',39,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',40,'普米族',40,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',41,'塔吉克族',41,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',42,'怒族',42,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',43,'乌孜别克',43,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',44,'俄罗斯族',44,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',45,'鄂温克族',45,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',46,'崩龙族',46,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',47,'保安族',47,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',48,'裕固族',48,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',49,'京族',49,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',50,'塔塔尔族',50,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',51,'独龙族',51,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',52,'鄂伦春族',52,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',53,'赫哲族',53,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',54,'门巴族',54,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',55,'珞巴族',55,1,1);
insert sys_dictionary_item values(UUID(),'','NationType',56,'基诺族',56,1,1);