EmploymentSite/doc/待更新脚本.txt

-- 2024-7-16 企业信用记录表
CREATE TABLE `pc_credit_record`  (
  `CreditRecordID` varchar(50) NOT NULL,
  `CompanyID` varchar(50) NULL COMMENT '企业ID',
  `CreditRecordContent` text NULL COMMENT '信用记录内容',
  `EnterTime` datetime NULL COMMENT '录入时间',
  `DocumentNumber` varchar(50) NULL COMMENT '决定文书号',
  `IncludeTime` datetime NULL COMMENT '列入时间',
  `ExpirationTime` datetime NULL COMMENT '到期时间',
  `DecidingDepartment` varchar(100) NULL COMMENT '作出列入决定部门',
  `Source` varchar(100) NULL COMMENT '来源',
  `IsEffective` int NULL COMMENT '是否有效：0是1否',
  `DepartmentTypeID` int NULL COMMENT '部门类别',
  `CreateUserID` varchar(50) NULL,
  `CreateTime` datetime NULL,
  `ModifyUserID` varchar(50) NULL,
  `ModifyTime` datetime NULL,
  PRIMARY KEY (`CreditRecordID`)
);

-- 2024-7-16 企业信用记录来源部门字典
INSERT INTO `sys_dictionary` VALUES ('CreditRecordDepartment', '企业信用记录来源部门类型', 109, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78001', '', 'CreditRecordDepartment', 1, '人社', 1, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78002', '', 'CreditRecordDepartment', 2, '环保', 2, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78003', '', 'CreditRecordDepartment', 3, '工商', 3, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78004', '', 'CreditRecordDepartment', 4, '安全', 4, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78005', '', 'CreditRecordDepartment', 5, '其他', 5, 1, 1);

-- 2024-7-24 数据大屏路由与权限
INSERT INTO sys_function_code VALUES ('T011004', '数据大屏', 'T0110', 4);
INSERT INTO `sys_menu` VALUES ('T011004', 4, '数据大屏', NULL, 'views/dataMap/dataScreenIndex', '/dataScreenIndex', 'T0110', NULL, 0, 1, 1, 'T011004', 1, NULL, 1);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011004');