```[sql]
/*
Navicat MySQL Data Transfer
Source Server : 基金数据包年
Source Server Version : 50648
Source Host : 139.196.50.92:3306
Source Database : fund
Target Server Type : MYSQL
Target Server Version : 50648
File Encoding : 65001
Date: 2020-07-20 11:26:04
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fund_notice
-- ----------------------------
DROP TABLE IF EXISTS `fund_notice`;
CREATE TABLE `fund_notice` (
`fundCode` char(8) DEFAULT NULL COMMENT '基金编号',
`title` varchar(1024) NOT NULL COMMENT '标题',
`content` mediumtext COMMENT '内容',
`publish_time` datetime DEFAULT NULL COMMENT '发布时间',
KEY `fundCode` (`fundCode`) USING BTREE,
KEY `date` (`publish_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='基金公告';
```
