sales_helper.update.20240707.sql 1.2 KB

12345678910111213141516171819
  1. ALTER TABLE space_parameter ADD name varchar(100) DEFAULT NULL NULL;
  2. ALTER TABLE helper_talk_detail ADD reference_content_id VARCHAR(100) DEFAULT NULL NULL;
  3. -- 20240716
  4. ALTER TABLE `sys_user` CHANGE `rank` rank_ varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '职级';
  5. ALTER TABLE `enterprise_info` ADD `session_num` int(11) DEFAULT NULL COMMENT '同时登录用户数';
  6. ALTER TABLE `enterprise_info` ADD `max_token` int(11) DEFAULT NULL COMMENT '企业最大token数';
  7. ALTER TABLE `enterprise_info` ADD `max_space` int(11) DEFAULT NULL COMMENT '企业最大空间(单位M)';
  8. ALTER TABLE `enterprise_info` ADD `api_key` varchar(256) DEFAULT NULL COMMENT 'AI API KEY';
  9. ALTER TABLE `knowledge_base` ADD `sort_code` varchar(12) DEFAULT NULL COMMENT '排序码';
  10. DROP TABLE IF EXISTS `knowledge_permission`;
  11. CREATE TABLE `knowledge_permission` (
  12. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  13. `knowledge_id` int(11) NOT NULL COMMENT '知识库ID',
  14. `grant_to_type` int(11) NOT NULL COMMENT '授权类型(1:部门,2:个人)',
  15. `grant_to_id` int(11) NOT NULL COMMENT '部门或用户id',
  16. PRIMARY KEY (`id`)
  17. ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COMMENT='知识库授权';