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

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

--2024.4.18
insert into sys_dictionary values('CompanyType','企业类型',53,1);
INSERT into sys_dictionary_item (`DictionaryItemID`, `Code`, `DictionaryCode`, `Value`, `Name`, `OrderNo`, `RecordStatus`, `IsEditable`)
VALUES
(UUID(), '', 'CompanyType', 1, '国有企业', 1, 1, 0),
(UUID(), '', 'CompanyType', 2, '联营企业', 2, 1, 0),
(UUID(), '', 'CompanyType', 3, '有限责任公司', 3, 1, 0),
(UUID(), '', 'CompanyType', 4, '股份有限公司', 4, 1, 0),
(UUID(), '', 'CompanyType', 5, '私营企业', 5, 1, 0),
(UUID(), '', 'CompanyType', 6, '中外合资企业', 6, 1, 0),
(UUID(), '', 'CompanyType', 7, '外资企业', 7, 1, 0)