 /*!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) */;
+/*!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_STATUS` AS `MISSION_STATUS`,`t_member_deckport`.`MISSION_ID` AS `MISSION_ID`,`t_member_deckport`.`MISSION_COMPLETE_TIME` AS `MISSION_COMPLETE_TIME`,`t_member_deckport`.`MISSION_FLAG` AS `MISSION_FLAG`,`t_member_deckport`.`FLAGSHIP` AS `FLAGSHIP`,`t_member_deckport`.`SHIP` AS `SHIP`,`t_member_deckport`.`locked` AS `locked` 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` varchar(255) ,
 `FLAGSHIP` varchar(255) ,
 `SHIP` varchar(255) 
)*/;

/*Table structure for table `v_member_furniture` */

  `ID` tinyint(3) unsigned NOT NULL COMMENT '舰队ID',
  `NAME` varchar(255) NOT NULL COMMENT '舰队名',
  `NAME_ID` varchar(255) NOT NULL DEFAULT '',
  `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`),
  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` */
