talent_map/server/database/202310271307.sql

CREATE TABLE `dd_survey_new` (
                                 `id` int(11) NOT NULL AUTO_INCREMENT,
                                 `use_layout` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0:不使用1:使用',
                                 `content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '内容',
                                 `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '标题',
                                 `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
                                 `filter` text COLLATE utf8_unicode_ci NOT NULL,
                                 `markdown` smallint(6) DEFAULT '0' COMMENT '是否markdown格式',
                                 `created_at` int(11) DEFAULT NULL,
                                 `updated_at` int(11) DEFAULT NULL,
                                 `cengci` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '人才层次',
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT

ALTER TABLE `dd_policy` ADD `summary` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '简介' AFTER `updated_at`;
ALTER TABLE `dd_policy` ADD `type` TINYINT(2) NOT NULL DEFAULT 'survey,search' COMMENT '类型：0 匹配，1 查询' AFTER `summary`;