   `ID` tinyint(3) unsigned NOT NULL COMMENT '舰队ID',
   `NAME` varchar(255) NOT NULL COMMENT '舰队名',
   `NAME_ID` varchar(255) NOT NULL DEFAULT '',
-  `MISSION` varchar(255) NOT NULL DEFAULT '[0,0,0,0]' COMMENT '远征信息',
+  `MISSION_STATUS` tinyint(4) unsigned NOT NULL DEFAULT '0',
+  `MISSION_ID` int(11) unsigned NOT NULL DEFAULT '0',
+  `MISSION_COMPLETE_TIME` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `MISSION_FLAG` tinyint(4) unsigned NOT NULL DEFAULT '0',
   `FLAGSHIP` varchar(255) NOT NULL DEFAULT '0',
   `SHIP` varchar(255) NOT NULL DEFAULT '[-1,-1,-1,-1,-1,-1]' COMMENT '舰队信息',
   `locked` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否可用',
   PRIMARY KEY (`index`),
   UNIQUE KEY `member_id` (`member_id`,`ID`),
-  CONSTRAINT `t_member_deckport_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `t_member` (`member_id`) ON DELETE CASCADE ON UPDATE CASCADE
+  KEY `MISSION_ID` (`MISSION_ID`),
+  CONSTRAINT `t_member_deckport_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `t_member` (`member_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `t_member_deckport_ibfk_2` FOREIGN KEY (`MISSION_ID`) REFERENCES `t_mission` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 /*Data for the table `t_member_deckport` */

/*!50001 DROP TABLE IF EXISTS `v_member_deckport` */;
/*!50001 DROP VIEW IF EXISTS `v_member_deckport` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_member_deckport` AS select `t_member_deckport`.`member_id` AS `member_id`,`t_member_deckport`.`ID` AS `ID`,`t_member_deckport`.`NAME` AS `NAME`,`t_member_deckport`.`NAME_ID` AS `NAME_ID`,`t_member_deckport`.`MISSION` AS `MISSION`,`t_member_deckport`.`FLAGSHIP` AS `FLAGSHIP`,`t_member_deckport`.`SHIP` AS `SHIP` from `t_member_deckport` where (`t_member_deckport`.`locked` = 0) */;

/*View structure for view v_member_furniture */


 `ID` tinyint(3) unsigned ,
 `NAME` varchar(255) ,
 `NAME_ID` varchar(255) ,
 `MISSION_STATUS` tinyint(4) unsigned ,
 `MISSION_ID` int(11) unsigned ,
 `MISSION_COMPLETE_TIME` bigint(20) unsigned ,
 `MISSION_FLAG` tinyint(4) unsigned ,
 `FLAGSHIP` varchar(255) ,
 `SHIP` varchar(255) ,
 `locked` tinyint(3) unsigned 
)*/;

/*Table structure for table `v_member_furniture` */
