 /*
-SQLyog Ultimate v11.42 (64 bit)
-MySQL - 5.6.21 : Database - kancolle
+SQLyog Ultimate v11.4 (64 bit)
+MySQL - 5.6.24 : Database - kancolle
 *********************************************************************
 */
 

/*Data for the table `t_bgm` */

insert  into `t_bgm`(`ID`,`NAME`) values (101,'母港'),(105,'秋の鎮守府'),(106,'武蔵の帰投'),(107,'冬の抜錨'),(108,'迎春の鎮守府'),(109,'第五戦隊の出撃'),(110,'節分の鎮守府'),(111,'艦娘のお菓子作り'),(112,'桃の節句と艦娘'),(205,'秋月の空'),(206,'明石の工廠'),(207,'冬の抜錨'),(208,'海上護衛戦'),(209,'索敵機、発艦始め！'),(210,'連合艦隊の出撃'),(211,'冬の艦隊'),(212,'迎春の鎮守府'),(213,'士魂の護り'),(214,'特型駆逐艦'),(215,'艦娘のお菓子作り'),(216,'桃の節句と艦娘'),(217,'武蔵の帰投');

/*Table structure for table `t_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` */
