cif/sql/20260119_qa.sql

CREATE TABLE `c_qa`
(
	`id` bigint NOT NULL AUTO_INCREMENT,
	`bn_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '孟加拉标题',
	`en_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '英文标题',
	`bn_content` longtext COLLATE utf8mb4_unicode_ci COMMENT '孟加拉内容',
	`en_content` longtext COLLATE utf8mb4_unicode_ci COMMENT '英文内容',
	`create_user` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
	`update_user` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
	`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
	`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	`del_flag` bit(1) NOT NULL DEFAULT b'0' COMMENT '删除标识',
	`group_id` bigint NOT NULL COMMENT '分类id',
	`sort` int DEFAULT '0' COMMENT '排序',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='qa问答';

CREATE TABLE `c_qa_group`
(
	`id` bigint NOT NULL AUTO_INCREMENT,
	`create_user` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
	`update_user` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
	`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
	`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	`del_flag` bit(1) NOT NULL DEFAULT b'0' COMMENT '删除标识',
	`bn_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '孟加拉分类名称',
	`en_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '英文分类名称',
	`sort` int DEFAULT '0' COMMENT '排序',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='qa分类';