master

分支 (1)

管理

管理

master

ChineseChess
/
ChineseChess20161206.sql

-- MySQL dump 10.13  Distrib 5.7.9, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: chinesechess
-- ------------------------------------------------------
-- Server version	5.7.11-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `chessman`
--

DROP TABLE IF EXISTS `chessman`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chessman` (
  `chessId` int(11) NOT NULL,
  `score` int(11) NOT NULL,
  `type` varchar(5) NOT NULL,
  `isRed` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`chessId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chessman`
--

LOCK TABLES `chessman` WRITE;
/*!40000 ALTER TABLE `chessman` DISABLE KEYS */;
INSERT INTO `chessman` VALUES (1,10000,'将',1),(2,2,'士',1),(3,2,'士',1),(4,2,'相',1),(5,2,'相',1),(6,4,'马',1),(7,4,'马',1),(8,9,'车',1),(9,9,'车',1),(10,4,'炮',1),(11,4,'炮',1),(12,1,'兵',1),(13,1,'兵',1),(14,1,'兵',1),(15,1,'兵',1),(16,1,'兵',1),(21,10000,'将',0),(22,2,'士',0),(23,2,'士',0),(24,2,'相',0),(25,2,'相',0),(26,4,'马',0),(27,4,'马',0),(28,9,'车',0),(29,9,'车',0),(30,4,'炮',0),(31,4,'炮',0),(32,1,'兵',0),(33,1,'兵',0),(34,1,'兵',0),(35,1,'兵',0),(36,1,'兵',0);
/*!40000 ALTER TABLE `chessman` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `brule`
--

DROP TABLE IF EXISTS `brule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brule` (
  `id` int(11) NOT NULL,
  `chessId` int(11) NOT NULL,
  `inBlack_X` int(11) DEFAULT NULL,
  `inBlack_Y` int(11) DEFAULT NULL,
  `inRed_X` int(11) DEFAULT NULL,
  `inRed_Y` int(11) DEFAULT NULL,
  `existBlack_X` int(11) DEFAULT NULL,
  `existBlack_Y` int(11) DEFAULT NULL,
  `existRed_X` int(11) DEFAULT NULL,
  `existRed_Y` int(11) DEFAULT NULL,
  `notExistRed_X` int(11) DEFAULT NULL,
  `notExistRed_Y` int(11) DEFAULT NULL,
  `notExistBlack_X` int(11) DEFAULT NULL,
  `notExistBlack_Y` int(11) DEFAULT NULL,
  `moveTo_X` int(11) DEFAULT NULL,
  `moveTo_Y` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Reference_7` (`chessId`),
  CONSTRAINT `FK_Reference_7` FOREIGN KEY (`chessId`) REFERENCES `chessman` (`chessId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `brule`
--

LOCK TABLES `brule` WRITE;
/*!40000 ALTER TABLE `brule` DISABLE KEYS */;
INSERT INTO `brule` VALUES (1201,12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,0,1),(1202,12,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,1,0),(1203,12,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,NULL,NULL,-1,0),(1301,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,0,1),(1302,13,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,1,0),(1303,13,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,NULL,NULL,-1,0),(1401,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,0,1),(1402,14,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,1,0),(1403,14,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,NULL,NULL,-1,0),(1501,15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,0,1),(1502,15,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,1,0),(1503,15,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,NULL,NULL,-1,0),(1601,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,0,1),(1602,16,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,1,0),(1603,16,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,NULL,NULL,-1,0),(3201,32,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1,0,-1),(3202,32,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0),(3203,32,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,-1,0),(3301,33,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1,0,-1),(3302,33,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0),(3303,33,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,-1,0),(3401,34,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1,0,-1),(3402,34,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0),(3403,34,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,-1,0),(3501,35,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1,0,-1),(3502,35,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0),(3503,35,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,-1,0),(3601,36,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1,0,-1),(3602,36,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0),(3603,36,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0,-1,0);
/*!40000 ALTER TABLE `brule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `crule`
--

DROP TABLE IF EXISTS `crule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crule` (
  `id` int(11) NOT NULL,
  `chessId` int(11) NOT NULL,
  `notExistRed_X` int(11) DEFAULT NULL,
  `notExistRed_Y` int(11) DEFAULT NULL,
  `notExistBlack_X` int(11) DEFAULT NULL,
  `notExistBlack_Y` int(11) DEFAULT NULL,
  `notExistInX_X1` int(11) DEFAULT NULL,
  `notExistInX_X2` int(11) DEFAULT NULL,
  `notExistInY_Y1` int(11) DEFAULT NULL,
  `notExistInY_Y2` int(11) DEFAULT NULL,
  `moveTo_X` int(11) DEFAULT NULL,
  `moveTo_Y` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Reference_2` (`chessId`),
  CONSTRAINT `FK_Reference_2` FOREIGN KEY (`chessId`) REFERENCES `chessman` (`chessId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crule`
--

LOCK TABLES `crule` WRITE;
/*!40000 ALTER TABLE `crule` DISABLE KEYS */;
INSERT INTO `crule` VALUES (817,8,1,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(818,8,2,0,NULL,NULL,1,1,NULL,NULL,2,0),(819,8,3,0,NULL,NULL,1,2,NULL,NULL,3,0),(820,8,4,0,NULL,NULL,1,3,NULL,NULL,4,0),(821,8,5,0,NULL,NULL,1,4,NULL,NULL,5,0),(822,8,6,0,NULL,NULL,1,5,NULL,NULL,6,0),(823,8,7,0,NULL,NULL,1,6,NULL,NULL,7,0),(824,8,8,0,NULL,NULL,1,7,NULL,NULL,8,0),(825,8,-1,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0),(826,8,-2,0,NULL,NULL,-1,-1,NULL,NULL,-2,0),(827,8,-3,0,NULL,NULL,-2,-1,NULL,NULL,-3,0),(828,8,-4,0,NULL,NULL,-3,-1,NULL,NULL,-4,0),(829,8,-5,0,NULL,NULL,-4,-1,NULL,NULL,-5,0),(830,8,-6,0,NULL,NULL,-5,-1,NULL,NULL,-6,0),(831,8,-7,0,NULL,NULL,-6,-1,NULL,NULL,-7,0),(832,8,-8,0,NULL,NULL,-7,-1,NULL,NULL,-8,0),(851,8,0,1,NULL,NULL,NULL,NULL,NULL,NULL,0,1),(852,8,0,2,NULL,NULL,NULL,NULL,1,1,0,2),(853,8,0,3,NULL,NULL,NULL,NULL,1,2,0,3),(854,8,0,4,NULL,NULL,NULL,NULL,1,3,0,4),(855,8,0,5,NULL,NULL,NULL,NULL,1,4,0,5),(856,8,0,6,NULL,NULL,NULL,NULL,1,5,0,6),(857,8,0,7,NULL,NULL,NULL,NULL,1,6,0,7),(858,8,0,8,NULL,NULL,NULL,NULL,1,7,0,8),(859,8,0,9,NULL,NULL,NULL,NULL,1,8,0,9),(860,8,0,-1,NULL,NULL,NULL,NULL,NULL,NULL,0,-1),(861,8,0,-2,NULL,NULL,NULL,NULL,-1,-1,0,-2),(862,8,0,-3,NULL,NULL,NULL,NULL,-2,-1,0,-3),(863,8,0,-4,NULL,NULL,NULL,NULL,-3,-1,0,-4),(864,8,0,-5,NULL,NULL,NULL,NULL,-4,-1,0,-5),(865,8,0,-6,NULL,NULL,NULL,NULL,-5,-1,0,-6),(866,8,0,-7,NULL,NULL,NULL,NULL,-6,-1,0,-7),(867,8,0,-8,NULL,NULL,NULL,NULL,-7,-1,0,-8),(868,8,0,-9,NULL,NULL,NULL,NULL,-8,-1,0,-9),(917,9,1,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(918,9,2,0,NULL,NULL,1,1,NULL,NULL,2,0),(919,9,3,0,NULL,NULL,1,2,NULL,NULL,3,0),(920,9,4,0,NULL,NULL,1,3,NULL,NULL,4,0),(921,9,5,0,NULL,NULL,1,4,NULL,NULL,5,0),(922,9,6,0,NULL,NULL,1,5,NULL,NULL,6,0),(923,9,7,0,NULL,NULL,1,6,NULL,NULL,7,0),(924,9,8,0,NULL,NULL,1,7,NULL,NULL,8,0),(925,9,-1,0,NULL,NULL,NULL,NULL,NULL,NULL,-1,0),(926,9,-2,0,NULL,NULL,-1,-1,NULL,NULL,-2,0),(927,9,-3,0,NULL,NULL,-2,-1,NULL,NULL,-3,0),(928,9,-4,0,NULL,NULL,-3,-1,NULL,NULL,-4,0),(929,9,-5,0,NULL,NULL,-4,-1,NULL,NULL,-5,0),(930,9,-6,0,NULL,NULL,-5,-1,NULL,NULL,-6,0),(931,9,-7,0,NULL,NULL,-6,-1,NULL,NULL,-7,0),(932,9,-8,0,NULL,NULL,-7,-1,NULL,NULL,-8,0),(951,9,0,1,NULL,NULL,NULL,NULL,NULL,NULL,0,1),(952,9,0,2,NULL,NULL,NULL,NULL,1,1,0,2),(953,9,0,3,NULL,NULL,NULL,NULL,1,2,0,3),(954,9,0,4,NULL,NULL,NULL,NULL,1,3,0,4),(955,9,0,5,NULL,NULL,NULL,NULL,1,4,0,5),(956,9,0,6,NULL,NULL,NULL,NULL,1,5,0,6),(957,9,0,7,NULL,NULL,NULL,NULL,1,6,0,7),(958,9,0,8,NULL,NULL,NULL,NULL,1,7,0,8),(959,9,0,9,NULL,NULL,NULL,NULL,1,8,0,9),(960,9,0,-1,NULL,NULL,NULL,NULL,NULL,NULL,0,-1),(961,9,0,-2,NULL,NULL,NULL,NULL,-1,-1,0,-2),(962,9,0,-3,NULL,NULL,NULL,NULL,-2,-1,0,-3),(963,9,0,-4,NULL,NULL,NULL,NULL,-3,-1,0,-4),(964,9,0,-5,NULL,NULL,NULL,NULL,-4,-1,0,-5),(965,9,0,-6,NULL,NULL,NULL,NULL,-5,-1,0,-6),(966,9,0,-7,NULL,NULL,NULL,NULL,-6,-1,0,-7),(967,9,0,-8,NULL,NULL,NULL,NULL,-7,-1,0,-8),(968,9,0,-9,NULL,NULL,NULL,NULL,-8,-1,0,-9),(2817,28,NULL,NULL,1,0,NULL,NULL,NULL,NULL,1,0),(2818,28,NULL,NULL,2,0,1,1,NULL,NULL,2,0),(2819,28,NULL,NULL,3,0,1,2,NULL,NULL,3,0),(2820,28,NULL,NULL,4,0,1,3,NULL,NULL,4,0),(2821,28,NULL,NULL,5,0,1,4,NULL,NULL,5,0),(2822,28,NULL,NULL,6,0,1,5,NULL,NULL,6,0),(2823,28,NULL,NULL,7,0,1,6,NULL,NULL,7,0),(2824,28,NULL,NULL,8,0,1,7,NULL,NULL,8,0),(2825,28,NULL,NULL,-1,0,NULL,NULL,NULL,NULL,-1,0),(2826,28,NULL,NULL,-2,0,-1,-1,NULL,NULL,-2,0),(2827,28,NULL,NULL,-3,0,-2,-1,NULL,NULL,-3,0),(2828,28,NULL,NULL,-4,0,-3,-1,NULL,NULL,-4,0),(2829,28,NULL,NULL,-5,0,-4,-1,NULL,NULL,-5,0),(2830,28,NULL,NULL,-6,0,-5,-1,NULL,NULL,-6,0),(2831,28,NULL,NULL,-7,0,-6,-1,NULL,NULL,-7,0),(2832,28,NULL,NULL,-8,0,-7,-1,NULL,NULL,-8,0),(2851,28,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,1),(2852,28,NULL,NULL,0,2,NULL,NULL,1,1,0,2),(2853,28,NULL,NULL,0,3,NULL,NULL,1,2,0,3),(2854,28,NULL,NULL,0,4,NULL,NULL,1,3,0,4),(2855,28,NULL,NULL,0,5,NULL,NULL,1,4,0,5),(2856,28,NULL,NULL,0,6,NULL,NULL,1,5,0,6),(2857,28,NULL,NULL,0,7,NULL,NULL,1,6,0,7),(2858,28,NULL,NULL,0,8,NULL,NULL,1,7,0,8),(2859,28,NULL,NULL,0,9,NULL,NULL,1,8,0,9),(2860,28,NULL,NULL,0,-1,NULL,NULL,NULL,NULL,0,-1),(2861,28,NULL,NULL,0,-2,NULL,NULL,-1,-1,0,-2),(2862,28,NULL,NULL,0,-3,NULL,NULL,-2,-1,0,-3),(2863,28,NULL,NULL,0,-4,NULL,NULL,-3,-1,0,-4),(2864,28,NULL,NULL,0,-5,NULL,NULL,-4,-1,0,-5),(2865,28,NULL,NULL,0,-6,NULL,NULL,-5,-1,0,-6),(2866,28,NULL,NULL,0,-7,NULL,NULL,-6,-1,0,-7),(2867,28,NULL,NULL,0,-8,NULL,NULL,-7,-1,0,-8),(2868,28,NULL,NULL,0,-9,NULL,NULL,-8,-1,0,-9),(2917,29,NULL,NULL,1,0,NULL,NULL,NULL,NULL,1,0),(2918,29,NULL,NULL,2,0,1,1,NULL,NULL,2,0),(2919,29,NULL,NULL,3,0,1,2,NULL,NULL,3,0),(2920,29,NULL,NULL,4,0,1,3,NULL,NULL,4,0),(2921,29,NULL,NULL,5,0,1,4,NULL,NULL,5,0),(2922,29,NULL,NULL,6,0,1,5,NULL,NULL,6,0),(2923,29,NULL,NULL,7,0,1,6,NULL,NULL,7,0),(2924,29,NULL,NULL,8,0,1,7,NULL,NULL,8,0),(2925,29,NULL,NULL,-1,0,NULL,NULL,NULL,NULL,-1,0),(2926,29,NULL,NULL,-2,0,-1,-1,NULL,NULL,-2,0),(2927,29,NULL,NULL,-3,0,-2,-1,NULL,NULL,-3,0),(2928,29,NULL,NULL,-4,0,-3,-1,NULL,NULL,-4,0),(2929,29,NULL,NULL,-5,0,-4,-1,NULL,NULL,-5,0),(2930,29,NULL,NULL,-6,0,-5,-1,NULL,NULL,-6,0),(2931,29,NULL,NULL,-7,0,-6,-1,NULL,NULL,-7,0),(2932,29,NULL,NULL,-8,0,-7,-1,NULL,NULL,-8,0),(2951,29,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,1),(2952,29,NULL,NULL,0,2,NULL,NULL,1,1,0,2),(2953,29,NULL,NULL,0,3,NULL,NULL,1,2,0,3),(2954,29,NULL,NULL,0,4,NULL,NULL,1,3,0,4),(2955,29,NULL,NULL,0,5,NULL,NULL,1,4,0,5),(2956,29,NULL,NULL,0,6,NULL,NULL,1,5,0,6),(2957,29,NULL,NULL,0,7,NULL,NULL,1,6,0,7),(2958,29,NULL,NULL,0,8,NULL,NULL,1,7,0,8),(2959,29,NULL,NULL,0,9,NULL,NULL,1,8,0,9),(2960,29,NULL,NULL,0,-1,NULL,NULL,NULL,NULL,0,-1),(2961,29,NULL,NULL,0,-2,NULL,NULL,-1,-1,0,-2),(2962,29,NULL,NULL,0,-3,NULL,NULL,-2,-1,0,-3),(2963,29,NULL,NULL,0,-4,NULL,NULL,-3,-1,0,-4),(2964,29,NULL,NULL,0,-5,NULL,NULL,-4,-1,0,-5),(2965,29,NULL,NULL,0,-6,NULL,NULL,-5,-1,0,-6),(2966,29,NULL,NULL,0,-7,NULL,NULL,-6,-1,0,-7),(2967,29,NULL,NULL,0,-8,NULL,NULL,-7,-1,0,-8),(2968,29,NULL,NULL,0,-9,NULL,NULL,-8,-1,0,-9);
/*!40000 ALTER TABLE `crule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jrule`
--

DROP TABLE IF EXISTS `jrule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jrule` (
  `id` int(11) NOT NULL,
  `chessId` int(11) DEFAULT NULL,
  `inBlackHome_X` int(11) DEFAULT NULL,
  `inBlackHome_Y` int(11) DEFAULT NULL,
  `inRedHome_X` int(11) DEFAULT NULL,
  `inRedHome_Y` int(11) DEFAULT NULL,
  `moveTo_X` int(11) DEFAULT NULL,
  `moveTo_Y` int(11) DEFAULT NULL,
  `notExistBlack_X` int(11) DEFAULT NULL,
  `notExistBlack_Y` int(11) DEFAULT NULL,
  `notExistRed_X` int(11) DEFAULT NULL,
  `notExistRed_Y` int(11) DEFAULT NULL,
  `notFaceToFace_X` int(11) DEFAULT NULL,
  `notFaceToFace_Y` int(11) DEFAULT NULL,
  `faceToFace` tinyint(1) DEFAULT NULL,
  `eatAnother` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Reference_4` (`chessId`),
  CONSTRAINT `FK_Reference_4` FOREIGN KEY (`chessId`) REFERENCES `chessman` (`chessId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jrule`
--

LOCK TABLES `jrule` WRITE;
/*!40000 ALTER TABLE `jrule` DISABLE KEYS */;
INSERT INTO `jrule` VALUES (101,1,NULL,NULL,1,0,1,0,NULL,NULL,1,0,1,0,NULL,NULL),(102,1,NULL,NULL,-1,0,-1,0,NULL,NULL,-1,0,-1,0,NULL,NULL),(103,1,NULL,NULL,0,1,0,1,NULL,NULL,0,1,0,1,NULL,NULL),(104,1,NULL,NULL,0,-1,0,-1,NULL,NULL,0,-1,0,-1,NULL,NULL),(105,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1),(2101,21,1,0,NULL,NULL,1,0,1,0,NULL,NULL,1,0,NULL,NULL),(2102,21,-1,0,NULL,NULL,-1,0,-1,0,NULL,NULL,-1,0,NULL,NULL),(2103,21,0,1,NULL,NULL,0,1,0,1,NULL,NULL,0,1,NULL,NULL),(2104,21,0,-1,NULL,NULL,0,-1,0,-1,NULL,NULL,0,-1,NULL,NULL),(2105,21,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1);
/*!40000 ALTER TABLE `jrule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mrule`
--

DROP TABLE IF EXISTS `mrule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mrule` (
  `id` int(11) NOT NULL,
  `chessId` int(11) NOT NULL,
  `notExistBlack_X` int(11) DEFAULT NULL,
  `notExistBlack_Y` int(11) DEFAULT NULL,
  `notExistRed_X` int(11) DEFAULT NULL,
  `notExistRed_Y` int(11) DEFAULT NULL,
  `notExist_X` int(11) DEFAULT NULL,
  `notExist_Y` int(11) DEFAULT NULL,
  `moveTo_X` int(11) DEFAULT NULL,
  `moveTo_Y` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Reference_6` (`chessId`),
  CONSTRAINT `FK_Reference_6` FOREIGN KEY (`chessId`) REFERENCES `chessman` (`chessId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mrule`
--

LOCK TABLES `mrule` WRITE;
/*!40000 ALTER TABLE `mrule` DISABLE KEYS */;
INSERT INTO `mrule` VALUES (601,6,NULL,NULL,-1,2,0,1,-1,2),(602,6,NULL,NULL,1,2,0,1,1,2),(603,6,NULL,NULL,2,1,1,0,2,1),(604,6,NULL,NULL,2,-1,1,0,2,-1),(605,6,NULL,NULL,1,-2,0,-1,1,-2),(606,6,NULL,NULL,-1,-2,0,-1,-1,-2),(607,6,NULL,NULL,-2,-1,-1,0,-2,-1),(608,6,NULL,NULL,-2,1,-1,0,-2,1),(701,7,NULL,NULL,-1,2,0,1,-1,2),(702,7,NULL,NULL,1,2,0,1,1,2),(703,7,NULL,NULL,2,1,1,0,2,1),(704,7,NULL,NULL,2,-1,1,0,2,-1),(705,7,NULL,NULL,1,-2,0,-1,1,-2),(706,7,NULL,NULL,-1,-2,0,-1,-1,-2),(707,7,NULL,NULL,-2,1,-1,0,-2,1),(708,7,NULL,NULL,-2,-1,-1,0,-2,-1),(2601,26,-1,2,NULL,NULL,0,1,-1,2),(2602,26,1,2,NULL,NULL,0,1,1,2),(2603,26,2,1,NULL,NULL,1,0,2,1),(2604,26,2,-1,NULL,NULL,1,0,2,-1),(2605,26,1,-2,NULL,NULL,0,1,1,-2),(2606,26,-1,-2,NULL,NULL,0,1,-1,-2),(2607,26,-2,-1,NULL,NULL,-1,0,-2,-1),(2608,26,-2,1,NULL,NULL,-1,0,-2,1),(2701,27,-1,2,NULL,NULL,0,1,-1,2),(2702,27,1,2,NULL,NULL,0,1,1,2),(2703,27,2,1,NULL,NULL,1,0,2,1),(2704,27,2,-1,NULL,NULL,1,0,2,-1),(2705,27,1,-2,NULL,NULL,0,1,1,-2),(2706,27,-1,-2,NULL,NULL,0,1,-1,-2),(2707,27,-2,-1,NULL,NULL,-1,0,-2,-1),(2708,27,-2,1,NULL,NULL,-1,0,-2,1);
/*!40000 ALTER TABLE `mrule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `prule`
--

DROP TABLE IF EXISTS `prule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prule` (
  `id` int(11) NOT NULL,
  `chessId` int(11) NOT NULL,
  `notExistInX_X1` int(11) DEFAULT NULL,
  `notExistInX_X2` int(11) DEFAULT NULL,
  `notExistInY_Y1` int(11) DEFAULT NULL,
  `notExistInY_Y2` int(11) DEFAULT NULL,
  `existBlack_X` int(11) DEFAULT NULL,
  `existBlack_Y` int(11) DEFAULT NULL,
  `existRed_X` int(11) DEFAULT NULL,
  `existRed_Y` int(11) DEFAULT NULL,
  `existOneInY_Y1` int(11) DEFAULT NULL,
  `existOneInY_Y2` int(11) DEFAULT NULL,
  `existOneInX_X1` int(11) DEFAULT NULL,
  `existOneInX_X2` int(11) DEFAULT NULL,
  `moveTo_X` int(11) DEFAULT NULL,
  `moveTo_Y` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Reference_1` (`chessId`),
  CONSTRAINT `FK_Reference_1` FOREIGN KEY (`chessId`) REFERENCES `chessman` (`chessId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `prule`
--

LOCK TABLES `prule` WRITE;
/*!40000 ALTER TABLE `prule` DISABLE KEYS */;
INSERT INTO `prule` VALUES (1001,10,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(1002,10,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0),(1003,10,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,0),(1004,10,1,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,0),(1005,10,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,0),(1006,10,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,0),(1007,10,1,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0),(1008,10,1,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,0),(1009,10,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-1,0),(1010,10,-2,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-2,0),(1011,10,-3,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-3,0),(1012,10,-4,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-4,0),(1013,10,-5,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-5,0),(1014,10,-6,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-6,0),(1015,10,-7,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-7,0),(1016,10,-8,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-8,0),(1017,10,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1),(1018,10,NULL,NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2),(1019,10,NULL,NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3),(1020,10,NULL,NULL,1,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4),(1021,10,NULL,NULL,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,5),(1022,10,NULL,NULL,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6),(1023,10,NULL,NULL,1,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7),(1024,10,NULL,NULL,1,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,8),(1025,10,NULL,NULL,1,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,9),(1026,10,NULL,NULL,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1),(1027,10,NULL,NULL,-2,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-2),(1028,10,NULL,NULL,-3,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-3),(1029,10,NULL,NULL,-4,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-4),(1030,10,NULL,NULL,-5,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-5),(1031,10,NULL,NULL,-6,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-6),(1032,10,NULL,NULL,-7,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-7),(1033,10,NULL,NULL,-8,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-8),(1034,10,NULL,NULL,-9,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-9),(1035,10,NULL,NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,1,1,2,0),(1036,10,NULL,NULL,NULL,NULL,3,0,NULL,NULL,NULL,NULL,1,2,3,0),(1037,10,NULL,NULL,NULL,NULL,4,0,NULL,NULL,NULL,NULL,1,3,4,0),(1038,10,NULL,NULL,NULL,NULL,5,0,NULL,NULL,NULL,NULL,1,4,5,0),(1039,10,NULL,NULL,NULL,NULL,6,0,NULL,NULL,NULL,NULL,1,5,6,0),(1040,10,NULL,NULL,NULL,NULL,7,0,NULL,NULL,NULL,NULL,1,6,7,0),(1041,10,NULL,NULL,NULL,NULL,8,0,NULL,NULL,NULL,NULL,1,7,8,0),(1042,10,NULL,NULL,NULL,NULL,-2,0,NULL,NULL,NULL,NULL,-1,-1,-2,0),(1043,10,NULL,NULL,NULL,NULL,-3,0,NULL,NULL,NULL,NULL,-2,-1,-3,0),(1044,10,NULL,NULL,NULL,NULL,-4,0,NULL,NULL,NULL,NULL,-3,-1,-4,0),(1045,10,NULL,NULL,NULL,NULL,-5,0,NULL,NULL,NULL,NULL,-4,-1,-5,0),(1046,10,NULL,NULL,NULL,NULL,-6,0,NULL,NULL,NULL,NULL,-5,-1,-6,0),(1047,10,NULL,NULL,NULL,NULL,-7,0,NULL,NULL,NULL,NULL,-6,-1,-7,0),(1048,10,NULL,NULL,NULL,NULL,-8,0,NULL,NULL,NULL,NULL,-7,-1,-8,0),(1049,10,NULL,NULL,NULL,NULL,0,2,NULL,NULL,1,1,NULL,NULL,0,2),(1050,10,NULL,NULL,NULL,NULL,0,3,NULL,NULL,1,2,NULL,NULL,0,3),(1051,10,NULL,NULL,NULL,NULL,0,4,NULL,NULL,1,3,NULL,NULL,0,4),(1052,10,NULL,NULL,NULL,NULL,0,5,NULL,NULL,1,4,NULL,NULL,0,5),(1053,10,NULL,NULL,NULL,NULL,0,6,NULL,NULL,1,5,NULL,NULL,0,6),(1054,10,NULL,NULL,NULL,NULL,0,7,NULL,NULL,1,6,NULL,NULL,0,7),(1055,10,NULL,NULL,NULL,NULL,0,8,NULL,NULL,1,7,NULL,NULL,0,8),(1056,10,NULL,NULL,NULL,NULL,0,9,NULL,NULL,1,8,NULL,NULL,0,9),(1057,10,NULL,NULL,NULL,NULL,0,-2,NULL,NULL,-1,-1,NULL,NULL,0,-2),(1058,10,NULL,NULL,NULL,NULL,0,-3,NULL,NULL,-2,-1,NULL,NULL,0,-3),(1059,10,NULL,NULL,NULL,NULL,0,-4,NULL,NULL,-3,-1,NULL,NULL,0,-4),(1060,10,NULL,NULL,NULL,NULL,0,-5,NULL,NULL,-4,-1,NULL,NULL,0,-5),(1061,10,NULL,NULL,NULL,NULL,0,-6,NULL,NULL,-5,-1,NULL,NULL,0,-6),(1062,10,NULL,NULL,NULL,NULL,0,-7,NULL,NULL,-6,-1,NULL,NULL,0,-7),(1063,10,NULL,NULL,NULL,NULL,0,-8,NULL,NULL,-7,-1,NULL,NULL,0,-8),(1064,10,NULL,NULL,NULL,NULL,0,-9,NULL,NULL,-8,-1,NULL,NULL,0,-9),(1101,11,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(1102,11,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0),(1103,11,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,0),(1104,11,1,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,0),(1105,11,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,0),(1106,11,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,0),(1107,11,1,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0),(1108,11,1,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,0),(1109,11,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-1,0),(1110,11,-2,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-2,0),(1111,11,-3,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-3,0),(1112,11,-4,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-4,0),(1113,11,-5,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-5,0),(1114,11,-6,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-6,0),(1115,11,-7,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-7,0),(1116,11,-8,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-8,0),(1117,11,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1),(1118,11,NULL,NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2),(1119,11,NULL,NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3),(1120,11,NULL,NULL,1,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4),(1121,11,NULL,NULL,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,5),(1122,11,NULL,NULL,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6),(1123,11,NULL,NULL,1,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7),(1124,11,NULL,NULL,1,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,8),(1125,11,NULL,NULL,1,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,9),(1126,11,NULL,NULL,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1),(1127,11,NULL,NULL,-2,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-2),(1128,11,NULL,NULL,-3,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-3),(1129,11,NULL,NULL,-4,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-4),(1130,11,NULL,NULL,-5,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-5),(1131,11,NULL,NULL,-6,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-6),(1132,11,NULL,NULL,-7,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-7),(1133,11,NULL,NULL,-8,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-8),(1134,11,NULL,NULL,-9,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-9),(1135,11,NULL,NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,1,1,2,0),(1136,11,NULL,NULL,NULL,NULL,3,0,NULL,NULL,NULL,NULL,1,2,3,0),(1137,11,NULL,NULL,NULL,NULL,4,0,NULL,NULL,NULL,NULL,1,3,4,0),(1138,11,NULL,NULL,NULL,NULL,5,0,NULL,NULL,NULL,NULL,1,4,5,0),(1139,11,NULL,NULL,NULL,NULL,6,0,NULL,NULL,NULL,NULL,1,5,6,0),(1140,11,NULL,NULL,NULL,NULL,7,0,NULL,NULL,NULL,NULL,1,6,7,0),(1141,11,NULL,NULL,NULL,NULL,8,0,NULL,NULL,NULL,NULL,1,7,8,0),(1142,11,NULL,NULL,NULL,NULL,-2,0,NULL,NULL,NULL,NULL,-1,-1,-2,0),(1143,11,NULL,NULL,NULL,NULL,-3,0,NULL,NULL,NULL,NULL,-2,-1,-3,0),(1144,11,NULL,NULL,NULL,NULL,-4,0,NULL,NULL,NULL,NULL,-3,-1,-4,0),(1145,11,NULL,NULL,NULL,NULL,-5,0,NULL,NULL,NULL,NULL,-4,-1,-5,0),(1146,11,NULL,NULL,NULL,NULL,-6,0,NULL,NULL,NULL,NULL,-5,-1,-6,0),(1147,11,NULL,NULL,NULL,NULL,-7,0,NULL,NULL,NULL,NULL,-6,-1,-7,0),(1148,11,NULL,NULL,NULL,NULL,-8,0,NULL,NULL,NULL,NULL,-7,-1,-8,0),(1149,11,NULL,NULL,NULL,NULL,0,2,NULL,NULL,1,1,NULL,NULL,0,2),(1150,11,NULL,NULL,NULL,NULL,0,3,NULL,NULL,1,2,NULL,NULL,0,3),(1151,11,NULL,NULL,NULL,NULL,0,4,NULL,NULL,1,3,NULL,NULL,0,4),(1152,11,NULL,NULL,NULL,NULL,0,5,NULL,NULL,1,4,NULL,NULL,0,5),(1153,11,NULL,NULL,NULL,NULL,0,6,NULL,NULL,1,5,NULL,NULL,0,6),(1154,11,NULL,NULL,NULL,NULL,0,7,NULL,NULL,1,6,NULL,NULL,0,7),(1155,11,NULL,NULL,NULL,NULL,0,8,NULL,NULL,1,7,NULL,NULL,0,8),(1156,11,NULL,NULL,NULL,NULL,0,9,NULL,NULL,1,8,NULL,NULL,0,9),(1157,11,NULL,NULL,NULL,NULL,0,-2,NULL,NULL,-1,-1,NULL,NULL,0,-2),(1158,11,NULL,NULL,NULL,NULL,0,-3,NULL,NULL,-2,-1,NULL,NULL,0,-3),(1159,11,NULL,NULL,NULL,NULL,0,-4,NULL,NULL,-3,-1,NULL,NULL,0,-4),(1160,11,NULL,NULL,NULL,NULL,0,-5,NULL,NULL,-4,-1,NULL,NULL,0,-5),(1161,11,NULL,NULL,NULL,NULL,0,-6,NULL,NULL,-5,-1,NULL,NULL,0,-6),(1162,11,NULL,NULL,NULL,NULL,0,-7,NULL,NULL,-6,-1,NULL,NULL,0,-7),(1163,11,NULL,NULL,NULL,NULL,0,-8,NULL,NULL,-7,-1,NULL,NULL,0,-8),(1164,11,NULL,NULL,NULL,NULL,0,-9,NULL,NULL,-8,-1,NULL,NULL,0,-9),(3001,30,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(3002,30,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0),(3003,30,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,0),(3004,30,1,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,0),(3005,30,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,0),(3006,30,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,0),(3007,30,1,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0),(3008,30,1,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,0),(3009,30,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-1,0),(3010,30,-2,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-2,0),(3011,30,-3,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-3,0),(3012,30,-4,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-4,0),(3013,30,-5,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-5,0),(3014,30,-6,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-6,0),(3015,30,-7,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-7,0),(3016,30,-8,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-8,0),(3017,30,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1),(3018,30,NULL,NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2),(3019,30,NULL,NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3),(3020,30,NULL,NULL,1,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4),(3021,30,NULL,NULL,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,5),(3022,30,NULL,NULL,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6),(3023,30,NULL,NULL,1,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7),(3024,30,NULL,NULL,1,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,8),(3025,30,NULL,NULL,1,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,9),(3026,30,NULL,NULL,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1),(3027,30,NULL,NULL,-2,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-2),(3028,30,NULL,NULL,-3,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-3),(3029,30,NULL,NULL,-4,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-4),(3030,30,NULL,NULL,-5,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-5),(3031,30,NULL,NULL,-6,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-6),(3032,30,NULL,NULL,-7,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-7),(3033,30,NULL,NULL,-8,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-8),(3034,30,NULL,NULL,-9,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-9),(3035,30,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,NULL,1,1,2,0),(3036,30,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,NULL,1,2,3,0),(3037,30,NULL,NULL,NULL,NULL,NULL,NULL,4,0,NULL,NULL,1,3,4,0),(3038,30,NULL,NULL,NULL,NULL,NULL,NULL,5,0,NULL,NULL,1,4,5,0),(3039,30,NULL,NULL,NULL,NULL,NULL,NULL,6,0,NULL,NULL,1,5,6,0),(3040,30,NULL,NULL,NULL,NULL,NULL,NULL,7,0,NULL,NULL,1,6,7,0),(3041,30,NULL,NULL,NULL,NULL,NULL,NULL,8,0,NULL,NULL,1,7,8,0),(3042,30,NULL,NULL,NULL,NULL,NULL,NULL,-2,0,NULL,NULL,-1,-1,-2,0),(3043,30,NULL,NULL,NULL,NULL,NULL,NULL,-3,0,NULL,NULL,-2,-1,-3,0),(3044,30,NULL,NULL,NULL,NULL,NULL,NULL,-4,0,NULL,NULL,-3,-1,-4,0),(3045,30,NULL,NULL,NULL,NULL,NULL,NULL,-5,0,NULL,NULL,-4,-1,-5,0),(3046,30,NULL,NULL,NULL,NULL,NULL,NULL,-6,0,NULL,NULL,-5,-1,-6,0),(3047,30,NULL,NULL,NULL,NULL,NULL,NULL,-7,0,NULL,NULL,-6,-1,-7,0),(3048,30,NULL,NULL,NULL,NULL,NULL,NULL,-8,0,NULL,NULL,-7,-1,-8,0),(3049,30,NULL,NULL,NULL,NULL,NULL,NULL,0,2,1,1,NULL,NULL,0,2),(3050,30,NULL,NULL,NULL,NULL,NULL,NULL,0,3,1,2,NULL,NULL,0,3),(3051,30,NULL,NULL,NULL,NULL,NULL,NULL,0,4,1,3,NULL,NULL,0,4),(3052,30,NULL,NULL,NULL,NULL,NULL,NULL,0,5,1,4,NULL,NULL,0,5),(3053,30,NULL,NULL,NULL,NULL,NULL,NULL,0,6,1,5,NULL,NULL,0,6),(3054,30,NULL,NULL,NULL,NULL,NULL,NULL,0,7,1,6,NULL,NULL,0,7),(3055,30,NULL,NULL,NULL,NULL,NULL,NULL,0,8,1,7,NULL,NULL,0,8),(3056,30,NULL,NULL,NULL,NULL,NULL,NULL,0,9,1,8,NULL,NULL,0,9),(3057,30,NULL,NULL,NULL,NULL,NULL,NULL,0,-2,-1,-1,NULL,NULL,0,-2),(3058,30,NULL,NULL,NULL,NULL,NULL,NULL,0,-3,-2,-1,NULL,NULL,0,-3),(3059,30,NULL,NULL,NULL,NULL,NULL,NULL,0,-4,-3,-1,NULL,NULL,0,-4),(3060,30,NULL,NULL,NULL,NULL,NULL,NULL,0,-5,-4,-1,NULL,NULL,0,-5),(3061,30,NULL,NULL,NULL,NULL,NULL,NULL,0,-6,-5,-1,NULL,NULL,0,-6),(3062,30,NULL,NULL,NULL,NULL,NULL,NULL,0,-7,-6,-1,NULL,NULL,0,-7),(3063,30,NULL,NULL,NULL,NULL,NULL,NULL,0,-8,-7,-1,NULL,NULL,0,-8),(3064,30,NULL,NULL,NULL,NULL,NULL,NULL,0,-9,-8,-1,NULL,NULL,0,-9),(3101,31,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(3102,31,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0),(3103,31,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,0),(3104,31,1,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,0),(3105,31,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,0),(3106,31,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,0),(3107,31,1,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0),(3108,31,1,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,0),(3109,31,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-1,0),(3110,31,-2,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-2,0),(3111,31,-3,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-3,0),(3112,31,-4,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-4,0),(3113,31,-5,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-5,0),(3114,31,-6,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-6,0),(3115,31,-7,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-7,0),(3116,31,-8,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-8,0),(3117,31,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1),(3118,31,NULL,NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2),(3119,31,NULL,NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3),(3120,31,NULL,NULL,1,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4),(3121,31,NULL,NULL,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,5),(3122,31,NULL,NULL,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6),(3123,31,NULL,NULL,1,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7),(3124,31,NULL,NULL,1,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,8),(3125,31,NULL,NULL,1,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,9),(3126,31,NULL,NULL,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-1),(3127,31,NULL,NULL,-2,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-2),(3128,31,NULL,NULL,-3,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-3),(3129,31,NULL,NULL,-4,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-4),(3130,31,NULL,NULL,-5,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-5),(3131,31,NULL,NULL,-6,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-6),(3132,31,NULL,NULL,-7,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-7),(3133,31,NULL,NULL,-8,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-8),(3134,31,NULL,NULL,-9,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,-9),(3135,31,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,NULL,1,1,2,0),(3136,31,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,NULL,1,2,3,0),(3137,31,NULL,NULL,NULL,NULL,NULL,NULL,4,0,NULL,NULL,1,3,4,0),(3138,31,NULL,NULL,NULL,NULL,NULL,NULL,5,0,NULL,NULL,1,4,5,0),(3139,31,NULL,NULL,NULL,NULL,NULL,NULL,6,0,NULL,NULL,1,5,6,0),(3140,31,NULL,NULL,NULL,NULL,NULL,NULL,7,0,NULL,NULL,1,6,7,0),(3141,31,NULL,NULL,NULL,NULL,NULL,NULL,8,0,NULL,NULL,1,7,8,0),(3142,31,NULL,NULL,NULL,NULL,NULL,NULL,-2,0,NULL,NULL,-1,-1,-2,0),(3143,31,NULL,NULL,NULL,NULL,NULL,NULL,-3,0,NULL,NULL,-2,-1,-3,0),(3144,31,NULL,NULL,NULL,NULL,NULL,NULL,-4,0,NULL,NULL,-3,-1,-4,0),(3145,31,NULL,NULL,NULL,NULL,NULL,NULL,-5,0,NULL,NULL,-4,-1,-5,0),(3146,31,NULL,NULL,NULL,NULL,NULL,NULL,-6,0,NULL,NULL,-5,-1,-6,0),(3147,31,NULL,NULL,NULL,NULL,NULL,NULL,-7,0,NULL,NULL,-6,-1,-7,0),(3148,31,NULL,NULL,NULL,NULL,NULL,NULL,-8,0,NULL,NULL,-7,-1,-8,0),(3149,31,NULL,NULL,NULL,NULL,NULL,NULL,0,2,1,1,NULL,NULL,0,2),(3150,31,NULL,NULL,NULL,NULL,NULL,NULL,0,3,1,2,NULL,NULL,0,3),(3151,31,NULL,NULL,NULL,NULL,NULL,NULL,0,4,1,3,NULL,NULL,0,4),(3152,31,NULL,NULL,NULL,NULL,NULL,NULL,0,5,1,4,NULL,NULL,0,5),(3153,31,NULL,NULL,NULL,NULL,NULL,NULL,0,6,1,5,NULL,NULL,0,6),(3154,31,NULL,NULL,NULL,NULL,NULL,NULL,0,7,1,6,NULL,NULL,0,7),(3155,31,NULL,NULL,NULL,NULL,NULL,NULL,0,8,1,7,NULL,NULL,0,8),(3156,31,NULL,NULL,NULL,NULL,NULL,NULL,0,9,1,8,NULL,NULL,0,9),(3157,31,NULL,NULL,NULL,NULL,NULL,NULL,0,-2,-1,-1,NULL,NULL,0,-2),(3158,31,NULL,NULL,NULL,NULL,NULL,NULL,0,-3,-2,-1,NULL,NULL,0,-3),(3159,31,NULL,NULL,NULL,NULL,NULL,NULL,0,-4,-3,-1,NULL,NULL,0,-4),(3160,31,NULL,NULL,NULL,NULL,NULL,NULL,0,-5,-4,-1,NULL,NULL,0,-5),(3161,31,NULL,NULL,NULL,NULL,NULL,NULL,0,-6,-5,-1,NULL,NULL,0,-6),(3162,31,NULL,NULL,NULL,NULL,NULL,NULL,0,-7,-6,-1,NULL,NULL,0,-7),(3163,31,NULL,NULL,NULL,NULL,NULL,NULL,0,-8,-7,-1,NULL,NULL,0,-8),(3164,31,NULL,NULL,NULL,NULL,NULL,NULL,0,-9,-8,-1,NULL,NULL,0,-9);
/*!40000 ALTER TABLE `prule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `srule`
--

DROP TABLE IF EXISTS `srule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `srule` (
  `id` int(11) NOT NULL,
  `chessId` int(11) NOT NULL,
  `inRedHome_X` int(11) DEFAULT NULL,
  `inRedHome_Y` int(11) DEFAULT NULL,
  `inBlackHome_X` int(11) DEFAULT NULL,
  `inBlackHome_Y` int(11) DEFAULT NULL,
  `notExistBlack_X` int(11) DEFAULT NULL,
  `notExistBlack_Y` int(11) DEFAULT NULL,
  `notExistRed_X` int(11) DEFAULT NULL,
  `notExistRed_Y` int(11) DEFAULT NULL,
  `moveTo_X` int(11) DEFAULT NULL,
  `moveTo_Y` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Reference_5` (`chessId`),
  CONSTRAINT `FK_Reference_5` FOREIGN KEY (`chessId`) REFERENCES `chessman` (`chessId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `srule`
--

LOCK TABLES `srule` WRITE;
/*!40000 ALTER TABLE `srule` DISABLE KEYS */;
INSERT INTO `srule` VALUES (201,2,-1,1,NULL,NULL,NULL,NULL,-1,1,-1,1),(202,2,1,1,NULL,NULL,NULL,NULL,1,1,1,1),(203,2,1,-1,NULL,NULL,NULL,NULL,1,-1,1,-1),(204,2,-1,-1,NULL,NULL,NULL,NULL,-1,-1,-1,-1),(301,3,-1,1,NULL,NULL,NULL,NULL,-1,1,-1,1),(302,3,1,1,NULL,NULL,NULL,NULL,1,1,1,1),(303,3,1,-1,NULL,NULL,NULL,NULL,1,-1,1,-1),(304,3,-1,-1,NULL,NULL,NULL,NULL,-1,-1,-1,-1),(2201,22,NULL,NULL,-1,1,-1,1,NULL,NULL,-1,1),(2202,22,NULL,NULL,1,1,1,1,NULL,NULL,1,1),(2203,22,NULL,NULL,1,-1,1,-1,NULL,NULL,1,-1),(2204,22,NULL,NULL,-1,-1,-1,-1,NULL,NULL,-1,-1),(2301,23,NULL,NULL,-1,1,-1,1,NULL,NULL,-1,1),(2302,23,NULL,NULL,1,1,1,1,NULL,NULL,1,1),(2303,23,NULL,NULL,1,-1,1,-1,NULL,NULL,1,-1),(2304,23,NULL,NULL,-1,-1,-1,-1,NULL,NULL,-1,-1);
/*!40000 ALTER TABLE `srule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xrule`
--

DROP TABLE IF EXISTS `xrule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xrule` (
  `id` int(11) NOT NULL,
  `chessId` int(11) NOT NULL,
  `notExist_X` int(11) DEFAULT NULL,
  `notExist_Y` int(11) DEFAULT NULL,
  `notExistBlack_X` int(11) DEFAULT NULL,
  `notExistBlack_Y` int(11) DEFAULT NULL,
  `notExistRed_X` int(11) DEFAULT NULL,
  `notExistRed_Y` int(11) DEFAULT NULL,
  `inRed_X` int(11) DEFAULT NULL,
  `inRed_Y` int(11) DEFAULT NULL,
  `inBlack_X` int(11) DEFAULT NULL,
  `inBlack_Y` int(11) DEFAULT NULL,
  `moveTo_X` int(11) DEFAULT NULL,
  `moveTo_Y` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Reference_3` (`chessId`),
  CONSTRAINT `FK_Reference_3` FOREIGN KEY (`chessId`) REFERENCES `chessman` (`chessId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xrule`
--

LOCK TABLES `xrule` WRITE;
/*!40000 ALTER TABLE `xrule` DISABLE KEYS */;
INSERT INTO `xrule` VALUES (401,4,-1,1,NULL,NULL,-2,2,-2,2,NULL,NULL,-2,2),(402,4,1,1,NULL,NULL,2,2,2,2,NULL,NULL,2,2),(403,4,1,-1,NULL,NULL,2,-2,2,-2,NULL,NULL,2,-2),(404,4,-1,-1,NULL,NULL,-2,-2,-2,-2,NULL,NULL,-2,-2),(501,5,-1,1,NULL,NULL,-2,2,-2,2,NULL,NULL,-2,2),(502,5,1,1,NULL,NULL,2,2,2,2,NULL,NULL,2,2),(503,5,1,-1,NULL,NULL,2,-2,2,-2,NULL,NULL,2,-2),(504,5,-1,-1,NULL,NULL,-2,-2,-2,-2,NULL,NULL,-2,-2),(2401,24,-1,1,-2,2,NULL,NULL,NULL,NULL,-2,2,-2,2),(2402,24,1,1,2,2,NULL,NULL,NULL,NULL,2,2,2,2),(2403,24,1,-1,2,-2,NULL,NULL,NULL,NULL,2,-2,2,-2),(2404,24,-1,-1,-2,-2,NULL,NULL,NULL,NULL,-2,-2,-2,-2),(2501,25,-1,1,-2,2,NULL,NULL,NULL,NULL,-2,2,-2,2),(2502,25,1,1,2,2,NULL,NULL,NULL,NULL,2,2,2,2),(2503,25,1,-1,2,-2,NULL,NULL,NULL,NULL,2,-2,2,-2),(2504,25,-1,-1,-2,-2,NULL,NULL,NULL,NULL,-2,-2,-2,-2);
/*!40000 ALTER TABLE `xrule` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-12-06 23:18:53