2019-07-13 13:57:56
CREATE TABLE  if not exists `bbs` (
      `id` varchar(50) NOT NULL,
      `initiator` varchar(50) DEFAULT NULL COMMENT '发起人',
      `reply` varchar(50) DEFAULT NULL COMMENT '回复人',
      `remote_application_id` varchar(50) DEFAULT NULL COMMENT '申请单id',
      `content` varchar(3000) DEFAULT NULL COMMENT '内容',
      `attachment` varchar(255) DEFAULT NULL COMMENT '附件',
      `createdAt` datetime DEFAULT NULL COMMENT '创建时间',
      PRIMARY KEY (`id`),
      KEY `bbs_initiator` (`initiator`),
      KEY `bbs_reply` (`reply`),
      KEY `bbs_applicaition` (`remote_application_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8执行成功;\r