[Sangokushi-svn] [SVN_Comitted] [458] #22695

OpenSangokushi commit ML sango****@lists*****
2010年 11月 6日 (土) 00:33:58 JST


Revision: 458
          http://sourceforge.jp/projects/sangokushi/svn/view?view=rev&revision=458
Author:   hryksbt
Date:     2010-11-06 00:33:58 +0900 (Sat, 06 Nov 2010)

Log Message:
-----------
#22695
DB手順修正しました。
テーブル作成と、データ投入は、本番様から抜いたdumpを使用します。

Ticket Links:
:-----------
    http://sourceforge.jp/projects/sangokushi/tracker/detail/22695

Modified Paths:
--------------
    trunk/Documents/DB作成手順.txt

Added Paths:
-----------
    trunk/Documents/dump.sql
    trunk/parameters/t_turnTimer.sql

Modified: trunk/Documents/DB作成手順.txt
===================================================================
--- trunk/Documents/DB作成手順.txt	2010-11-03 16:13:40 UTC (rev 457)
+++ trunk/Documents/DB作成手順.txt	2010-11-05 15:33:58 UTC (rev 458)
@@ -2,7 +2,7 @@
 
 	初期データベースを作成する手順です
 	サーバにMySQLがインストールされていることが前提になります。(初期設定済み)
-	基本的にはMySQLにログインしてSQLを実行するだけです。
+	基本的にはMySQLにログインしてSQLを実行し、dumpからリストアするだけです。
 	ファイルで実行でなくコピペで実行します。
 
 ■初期データベース作成
@@ -24,39 +24,7 @@
 
 ・データベースユーザ確認
 mysql> SHOW GRANTS FOR 'phpuser'@'localhost';
+mysql> quit
 
-
-・テーブル作成
-tableSQL.txtを開いて中のSQLをコピー → コンソールにペースト → 実行
-(改行コードも一緒にコピーすると勝手に実行されます。)
-
-
-mysql> use o_sangokushi
-mysql> show tables;
-
-テーブルができていることを確認します。
-
-
-■初期データ投入(データベース作成からつづき)
-
-それぞれのxxxxx.sqlを開いて中のSQLをコピー → コンソールにペースト → 実行
-t_AICharacter_data.sql
-t_defaultParam_data.sql
-t_map_data.sql
-t_room_data.sql
-t_login.sql
-
-必要であれば・・・
-
-t_battle_test.sql
-t_user_test.sql
-
-・件数確認します
-
-mysql> select * from t_xxxxxxx
-
-
-データが入っていれば終了です。
-
-
-
+・マスターデータ投入
+mysql -u root -pパスワード < dump.sql

Added: trunk/Documents/dump.sql
===================================================================
--- trunk/Documents/dump.sql	                        (rev 0)
+++ trunk/Documents/dump.sql	2010-11-05 15:33:58 UTC (rev 458)
@@ -0,0 +1,358 @@
+-- MySQL dump 10.13  Distrib 5.1.44, for unknown-linux-gnu (x86_64)
+--
+-- Host: localhost    Database: o_sangokushi
+-- ------------------------------------------------------
+-- Server version	5.1.44-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 `t_AICharacter`
+--
+
+DROP TABLE IF EXISTS `t_AICharacter`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_AICharacter` (
+  `charID` smallint(5) unsigned NOT NULL,
+  `charName` varchar(40) DEFAULT NULL,
+  `charType` varchar(1) DEFAULT NULL,
+  `countryID` smallint(5) unsigned DEFAULT NULL,
+  `paramID` smallint(5) unsigned DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`charID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_AICharacter`
+--
+
+LOCK TABLES `t_AICharacter` WRITE;
+/*!40000 ALTER TABLE `t_AICharacter` DISABLE KEYS */;
+INSERT INTO `t_AICharacter` VALUES (1,'曹操','s',1,101,'2010-05-12 20:29:06'),(2,'曹丕','b',1,102,'2010-05-12 20:29:06'),(3,'郭嘉','b',1,103,'2010-05-12 20:29:06'),(4,'荀彧','b',1,104,'2010-05-12 20:29:06'),(5,'荀攸','b',1,105,'2010-05-12 20:29:06'),(6,'程昱','b',1,106,'2010-05-12 20:29:06'),(7,'賈詡','b',1,107,'2010-05-12 20:29:06'),(8,'司馬懿','b',1,108,'2010-05-12 20:29:06'),(9,'徐庶','b',1,109,'2010-05-12 20:29:06'),(10,'許楮','b',1,110,'2010-05-12 20:29:06'),(11,'夏侯惇','b',1,111,'2010-05-12 20:29:06'),(12,'夏侯淵','b',1,112,'2010-05-12 20:29:06'),(13,'曹仁','b',1,113,'2010-05-12 20:29:06'),(14,'曹洪','b',1,114,'2010-05-12 20:29:06'),(15,'楽進','b',1,115,'2010-05-12 20:29:06'),(16,'李典','b',1,116,'2010-05-12 20:29:06'),(17,'張遼','b',1,117,'2010-05-12 20:29:06'),(18,'徐晃','b',1,118,'2010-05-12 20:29:06'),(19,'張郃','b',1,119,'2010-05-12 20:29:06'),(20,'于禁','b',1,120,'2010-05-12 20:29:06'),(21,'龐徳','b',1,121,'2010-05-12
  20:29:06'),(22,'劉備','s',3,122,'2010-05-12 20:29:06'),(23,'諸葛亮','b',3,123,'2010-05-12 20:29:06'),(24,'龐統','b',3,124,'2010-05-12 20:29:06'),(25,'法正','b',3,125,'2010-05-12 20:29:06'),(26,'馬良','b',3,126,'2010-05-12 20:29:06'),(27,'関羽','b',3,127,'2010-05-12 20:29:06'),(28,'張飛','b',3,128,'2010-05-12 20:29:06'),(29,'馬超','b',3,129,'2010-05-12 20:29:06'),(30,'黄忠','b',3,130,'2010-05-12 20:29:06'),(31,'趙雲','b',3,131,'2010-05-12 20:29:06'),(32,'魏延','b',3,132,'2010-05-12 20:29:06'),(33,'馬岱','b',3,133,'2010-05-12 20:29:07'),(34,'姜維','b',3,134,'2010-05-12 20:29:07'),(35,'関平','b',3,135,'2010-05-12 20:29:07'),(36,'孟達','b',3,136,'2010-05-12 20:29:07'),(37,'劉封','b',3,137,'2010-05-12 20:29:07'),(38,'廖化 ','b',3,138,'2010-05-12 20:29:07'),(39,'周倉','b',3,139,'2010-05-12 20:29:07'),(40,'厳顔','b',3,140,'2010-05-12 20:29:07'),(41,'麋芳','b',3,141,'2010-05-12 20:29:07'),(42,'李厳','b',3,142,'2010-05-12 20:29:07'),(43,'å­
 «æ¨©','s',2,143,'2010-05-12 20:29:07'),(44,'孫尚香','b',2,144,'2010-05-12 20:29:07'),(45,'周喩','b',2,145,'2010-05-12 20:29:07'),(46,'陸遜','b',2,146,'2010-05-12 20:29:07'),(47,'å‘‚è’™','b',2,147,'2010-05-12 20:29:07'),(48,'魯粛','b',2,148,'2010-05-12 20:29:07'),(49,'虞翻','b',2,149,'2010-05-12 20:29:07'),(50,'程普','b',2,150,'2010-05-12 20:29:07'),(51,'太史慈','b',2,151,'2010-05-12 20:29:07'),(52,'甘寧','b',2,152,'2010-05-12 20:29:07'),(53,'黄蓋','b',2,153,'2010-05-12 20:29:07'),(54,'韓当','b',2,154,'2010-05-12 20:29:07'),(55,'周泰','b',2,155,'2010-05-12 20:29:07'),(56,'蒋欽','b',2,156,'2010-05-12 20:29:07'),(57,'凌操','b',2,157,'2010-05-12 20:29:07'),(58,'凌統','b',2,158,'2010-05-12 20:29:07'),(59,'朱治','b',2,159,'2010-05-12 20:29:07'),(60,'徐盛','b',2,160,'2010-05-12 20:29:07'),(61,'陳武','b',2,161,'2010-05-12 20:29:07'),(62,'董襲','b',2,162,'2010-05-12 20:29:07'),(63,'朱然','b',2,163,'2010-05-12 20:29:07');
+/*!40000 ALTER TABLE `t_AICharacter` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_battle`
+--
+
+DROP TABLE IF EXISTS `t_battle`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_battle` (
+  `battleID` int(8) unsigned NOT NULL,
+  `roomID` smallint(5) unsigned DEFAULT NULL,
+  `userID` varchar(10) DEFAULT NULL,
+  `userName` varchar(40) DEFAULT NULL,
+  `countryID` smallint(5) unsigned NOT NULL,
+  `charKbn` varchar(1) DEFAULT NULL,
+  `mapChipNo` smallint(5) unsigned DEFAULT NULL,
+  `power` smallint(5) unsigned DEFAULT NULL,
+  `mobility` smallint(5) unsigned DEFAULT NULL,
+  `exclusionKbn` tinyint(4) DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`battleID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_battle`
+--
+
+LOCK TABLES `t_battle` WRITE;
+/*!40000 ALTER TABLE `t_battle` DISABLE KEYS */;
+INSERT INTO `t_battle` VALUES (945153,3,'10','許楮',1,'s',86,900,500,0,'2010-10-08 04:31:01'),(7501122,2,'19','張郃',1,'b',2610,800,700,0,'2010-11-03 15:00:02'),(10608984,5,'43','孫権',2,'s',182,700,700,0,'2010-10-12 02:37:01'),(13222551,1,'7','賈詡',1,'b',2700,100,300,0,'2010-10-26 06:59:01'),(14637581,1,'15','楽進',1,'s',2700,700,600,0,'2010-10-26 06:59:01'),(15575980,1,'20','于禁',1,'b',0,700,700,0,'2010-10-26 06:59:01'),(19692992,2,'37','劉封',3,'b',136,600,500,0,'2010-11-03 15:00:02'),(39307961,3,'59','朱治',2,'b',2516,700,600,0,'2010-10-08 04:31:01'),(41467218,3,'7','賈詡',1,'b',185,100,300,0,'2010-10-08 04:31:01'),(42378115,4,'59','朱治',2,'b',2564,700,600,0,'2010-10-12 02:40:02'),(43230937,3,'51','太史慈',2,'b',2518,900,600,0,'2010-10-08 04:31:01'),(44916361,4,'49','虞翻',2,'s',2561,200,300,0,'2010-10-12 02:40:02'),(46146849,5,'62','董襲',2,'b',46,600,500,0,'2010-10-12 02:37:01'),(49580858,2,'21','龐徳',1,'s',2565,900,900,0,'2010-11-03 15
 :00:02'),(56601943,2,'33','馬岱',3,'b',222,800,900,0,'2010-11-03 15:00:02'),(62013701,4,'53','黄蓋',2,'b',2652,600,600,0,'2010-10-12 02:40:02'),(72906091,5,'53','黄蓋',2,'b',2658,600,600,0,'2010-10-12 02:37:01'),(73978570,3,'62','董襲',2,'s',2608,600,500,0,'2010-10-08 04:31:01'),(75526361,1,'61','陳武',2,'b',139,600,600,0,'2010-10-26 06:59:01'),(76119411,4,'32','魏延',3,'b',50,800,500,0,'2010-10-12 02:40:02'),(76975254,5,'29','馬超',3,'b',2564,1000,900,0,'2010-10-12 02:37:01'),(80799074,1,'50','程普',2,'b',47,700,500,0,'2010-10-26 06:59:01'),(81219871,2,'41','麋芳',3,'s',2477,500,600,0,'2010-11-03 15:00:02'),(85238533,4,'40','厳顔',3,'b',182,600,500,0,'2010-10-12 02:40:02'),(89918517,5,'31','趙雲',3,'s',2565,900,800,0,'2010-10-12 02:37:01'),(90374217,2,'5','荀攸',1,'b',2561,100,300,0,'2010-11-03 15:00:02'),(92561503,5,'36','孟達',3,'b',2518,600,600,0,'2010-10-12 02:37:01'),(93312956,3,'18','徐晃',1,'b',135,800,600,0,'2010-10-08 04:31:01'),(9344364
 3,1,'43','孫権',2,'s',2477,700,700,0,'2010-10-26 06:59:01'),(99724597,4,'22','劉備',3,'s',95,600,900,0,'2010-10-12 02:40:02');
+/*!40000 ALTER TABLE `t_battle` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_battleTemp`
+--
+
+DROP TABLE IF EXISTS `t_battleTemp`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_battleTemp` (
+  `userID` varchar(10) NOT NULL,
+  `roomID` smallint(5) unsigned DEFAULT NULL,
+  `moveMapChipNo` smallint(5) unsigned DEFAULT NULL,
+  `power` smallint(5) unsigned DEFAULT NULL,
+  PRIMARY KEY (`userID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_battleTemp`
+--
+
+LOCK TABLES `t_battleTemp` WRITE;
+/*!40000 ALTER TABLE `t_battleTemp` DISABLE KEYS */;
+/*!40000 ALTER TABLE `t_battleTemp` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_country`
+--
+
+DROP TABLE IF EXISTS `t_country`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_country` (
+  `countryID` smallint(6) NOT NULL DEFAULT '0',
+  `countryName` varchar(40) DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`countryID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_country`
+--
+
+LOCK TABLES `t_country` WRITE;
+/*!40000 ALTER TABLE `t_country` DISABLE KEYS */;
+INSERT INTO `t_country` VALUES (1,'魏','2010-04-20 01:42:09'),(2,'呉','2010-04-20 01:42:09'),(3,'蜀','2010-04-20 01:42:09');
+/*!40000 ALTER TABLE `t_country` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_defaultParam`
+--
+
+DROP TABLE IF EXISTS `t_defaultParam`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_defaultParam` (
+  `paramID` smallint(5) unsigned NOT NULL,
+  `paramType` tinyint(3) unsigned DEFAULT NULL,
+  `paramName` varchar(40) DEFAULT NULL,
+  `power` smallint(5) unsigned DEFAULT NULL,
+  `mobility` smallint(5) unsigned DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`paramID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_defaultParam`
+--
+
+LOCK TABLES `t_defaultParam` WRITE;
+/*!40000 ALTER TABLE `t_defaultParam` DISABLE KEYS */;
+INSERT INTO `t_defaultParam` VALUES (101,0,'AI武将用',800,700,'2010-05-02 01:59:48'),(102,0,'AI武将用',700,600,'2010-05-02 01:59:48'),(103,0,'AI武将用',100,300,'2010-05-02 01:59:48'),(104,0,'AI武将用',100,300,'2010-05-02 01:59:48'),(105,0,'AI武将用',100,300,'2010-05-02 01:59:48'),(106,0,'AI武将用',100,300,'2010-05-02 01:59:48'),(107,0,'AI武将用',100,300,'2010-05-02 01:59:48'),(108,0,'AI武将用',300,800,'2010-05-02 01:59:48'),(109,0,'AI武将用',200,300,'2010-05-02 01:59:48'),(110,0,'AI武将用',900,500,'2010-05-02 01:59:48'),(111,0,'AI武将用',800,700,'2010-05-02 01:59:48'),(112,0,'AI武将用',800,1000,'2010-05-02 01:59:48'),(113,0,'AI武将用',700,800,'2010-05-02 01:59:48'),(114,0,'AI武将用',600,500,'2010-05-02 01:59:48'),(115,0,'AI武将用',700,600,'2010-05-02 01:59:48'),(116,0,'AI武将用',700,600,'2010-05-02 01:59:48'),(117,0,'AI武将用',800,700,'2010-05-02 01:59:48'),(118,0,'AI武将用',800,600,'2010-05-02 01:59:48'),(119,0,'AI武将
 用',800,700,'2010-05-02 01:59:48'),(120,0,'AI武将用',700,700,'2010-05-02 01:59:48'),(121,0,'AI武将用',900,900,'2010-05-02 01:59:48'),(122,0,'AI武将用',600,900,'2010-05-02 01:59:48'),(123,0,'AI武将用',300,300,'2010-05-02 01:59:48'),(124,0,'AI武将用',300,300,'2010-05-02 01:59:48'),(125,0,'AI武将用',100,300,'2010-05-02 01:59:48'),(126,0,'AI武将用',100,300,'2010-05-02 01:59:48'),(127,0,'AI武将用',900,1000,'2010-05-02 01:59:48'),(128,0,'AI武将用',1000,400,'2010-05-02 01:59:48'),(129,0,'AI武将用',1000,900,'2010-05-02 01:59:48'),(130,0,'AI武将用',900,600,'2010-05-02 01:59:48'),(131,0,'AI武将用',900,800,'2010-05-02 01:59:48'),(132,0,'AI武将用',800,500,'2010-05-02 01:59:48'),(133,0,'AI武将用',800,900,'2010-05-02 01:59:48'),(134,0,'AI武将用',800,900,'2010-05-02 01:59:48'),(135,0,'AI武将用',700,500,'2010-05-02 01:59:48'),(136,0,'AI武将用',600,600,'2010-05-02 01:59:48'),(137,0,'AI武将用',600,500,'2010-05-02 01:59:48'),(138,0,'AIæ­¦å
 °†ç”¨',600,700,'2010-05-02 01:59:48'),(139,0,'AI武将用',700,800,'2010-05-02 01:59:48'),(140,0,'AI武将用',600,500,'2010-05-02 01:59:48'),(141,0,'AI武将用',500,600,'2010-05-02 01:59:48'),(142,0,'AI武将用',800,700,'2010-05-02 01:59:48'),(143,0,'AI武将用',700,700,'2010-05-02 01:59:48'),(144,0,'AI武将用',500,800,'2010-05-02 01:59:48'),(145,0,'AI武将用',600,700,'2010-05-02 01:59:48'),(146,0,'AI武将用',300,600,'2010-05-02 01:59:48'),(147,0,'AI武将用',800,600,'2010-05-02 01:59:48'),(148,0,'AI武将用',200,700,'2010-05-02 01:59:48'),(149,0,'AI武将用',200,300,'2010-05-02 01:59:48'),(150,0,'AI武将用',700,500,'2010-05-02 01:59:48'),(151,0,'AI武将用',900,600,'2010-05-02 01:59:48'),(152,0,'AI武将用',900,700,'2010-05-02 01:59:48'),(153,0,'AI武将用',600,600,'2010-05-02 01:59:48'),(154,0,'AI武将用',800,600,'2010-05-02 01:59:48'),(155,0,'AI武将用',800,600,'2010-05-02 01:59:48'),(156,0,'AI武将用',700,600,'2010-05-02 01:59:48'),(157,0,'AIæ­¦å°
 †ç”¨',700,700,'2010-05-02 01:59:48'),(158,0,'AI武将用',700,700,'2010-05-02 01:59:48'),(159,0,'AI武将用',700,600,'2010-05-02 01:59:48'),(160,0,'AI武将用',700,600,'2010-05-02 01:59:48'),(161,0,'AI武将用',600,600,'2010-05-02 01:59:48'),(162,0,'AI武将用',600,500,'2010-05-02 01:59:48'),(163,0,'AI武将用',600,600,'2010-05-02 01:59:48'),(164,1,'ユーザデフォルト',80,70,'2010-05-02 01:59:48');
+/*!40000 ALTER TABLE `t_defaultParam` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_login`
+--
+
+DROP TABLE IF EXISTS `t_login`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_login` (
+  `userID` varchar(10) NOT NULL,
+  `sessionID` varchar(40) NOT NULL,
+  `lastLoginDate` datetime DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`userID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_login`
+--
+
+LOCK TABLES `t_login` WRITE;
+/*!40000 ALTER TABLE `t_login` DISABLE KEYS */;
+INSERT INTO `t_login` VALUES ('0af5f8de42','4df09d417bde93d97216e94bdf9cb961','2010-05-05 20:51:25','2010-05-05 20:51:25'),('37ac5d6b0d','bed77a77b83fb7cf3c75e0f5c4e4f52e','2010-05-05 20:45:12','2010-05-05 20:45:12'),('3aef5d0e7e','1b7c583445661e50b86d3452f394fd12','2010-05-05 20:57:42','2010-05-05 20:57:42'),('3f84dc5de6','9b3b74f5415e669695c6cca1c36b30a2','2010-05-05 22:06:57','2010-05-05 22:06:57'),('928b4b3e82','18fec080f8af2018daab74bd5f04e845','2010-05-05 20:43:34','2010-05-05 20:43:34'),('948c0971bf','6f0000180568405017dea2b3608cd718','2010-05-05 20:45:54','2010-05-05 20:45:54'),('9e057cf47e','626f9f6ea21a2302b59922eaaf0cec24','2010-05-05 20:55:03','2010-05-05 20:55:03'),('b266f8f283','b959fa2fafeff4848052093679a8c5ae','2010-05-05 21:34:25','2010-05-05 21:34:25'),('U0143b5eaa','8cd8e9807805a77f6ff9619d6af38d3a','2010-05-12 01:39:10','2010-05-12 01:39:10'),('U02536abdc','b656eeae8055953eed8da583ec20af87','2010-05-12 03:38:06','2010-05-12 03:38:06'),('U0260be6f9','c580e
 a56f6aec5a88bd019deb1adc4b1','2010-06-22 01:37:22','2010-06-22 01:37:22'),('U02de1eda6','1d18cb5c6d9ece5bbcdc06d00b2ace62','2010-06-02 23:19:23','2010-06-02 23:19:23'),('U035514ce8','c7e5cbb32d79f059ff6fa173c79090eb','2010-05-08 19:40:02','2010-05-08 19:40:02'),('U0510488ed','dc5a04f9945f57aae193bfa638475ba8','2010-05-10 18:55:45','2010-05-10 18:55:45'),('U07d2e9cd2','e33c41cbc1e7476a1293c55bd687d7ff','2010-09-22 23:35:50','2010-09-22 23:35:50'),('U07fb00210','423a2cdbe6466cb7448ebc6461ec8ae5','2010-05-12 09:05:22','2010-05-12 09:05:22'),('U0b8206c6e','f1a8cea60f199c37e05d4c4077549332','2010-10-05 23:54:58','2010-10-05 23:54:58'),('U0db742293','263c82492cd04b56bd7b18d581773f97','2010-05-10 09:54:44','2010-05-10 09:54:44'),('U0ffa91522','b2c1d6f284e1ea2b0d76690d9e3b19d7','2010-09-10 23:57:16','2010-09-10 23:57:16'),('U102a015a9','eb82472533b5a08226ca8da428bea5cc','2010-06-24 23:41:27','2010-06-24 23:41:27'),('U10728c8da','795e5b147bbed2fa567f87c530be9f52','2010-10-01 21:37:42
 ','2010-10-01 21:37:42'),('U108c2da78','7dd55fd1a5f60548dfc58f2330a51d6f','2010-06-22 01:48:04','2010-06-22 01:48:04'),('U12d7cb916','db20d55236a46e2cd738fd5b823d77f9','2010-09-22 23:34:35','2010-09-22 23:34:35'),('U137417190','14451d859b2bfa9279555d4477b640cd','2010-10-01 01:55:32','2010-10-01 01:55:32'),('U1927eccd1','3fd0d6cdadb77abe5b749d6de4d6bcd9','2010-05-10 22:34:38','2010-05-10 22:34:38'),('U23ce4fe74','ca27fc1e98441caf86e895cec63cf9ff','2010-07-01 23:43:59','2010-07-01 23:43:59'),('U265f6d781','142d8acf19047a457d214f367de580ff','2010-05-13 23:19:02','2010-05-13 23:19:02'),('U2a666421e','6784946c1ff755d9358d08a74402bc26','2010-10-08 12:41:40','2010-10-08 12:41:40'),('U2b0f32a9d','361e6dd49e8a83aa81a1816ed0ce28e8','2010-05-08 19:35:24','2010-05-08 19:35:24'),('U2d6e34d0c','d0c4fa18f8e4981c38da01773a951820','2010-09-22 23:34:50','2010-09-22 23:34:50'),('U308f7a20e','98d9673d8924649bcce57f8ec8e768ce','2010-05-08 19:30:40','2010-05-08 19:30:40'),('U31519e2a3','42727c569
 96760bee7738dbfd410926c','2010-05-25 22:51:19','2010-05-25 22:51:19'),('U3274f4fc3','8b16b9b0a926fc1807fd7561d5ab3252','2010-07-01 23:12:32','2010-07-01 23:12:32'),('U32e997c8e','95f3d585837f3edd3a4402f9a3aa9a20','2010-05-22 23:54:04','2010-05-22 23:54:04'),('U3745c6424','67d5333c413deeb7a01d0937777b0b3b','2010-05-12 03:01:22','2010-05-12 03:01:22'),('U385674d53','454f2c0dadcc1890d8077be580c2845b','2010-08-04 01:01:40','2010-08-04 01:01:40'),('U391f182a6','425b90fb65ee8f33e8992671dfedc9ef','2010-10-05 23:46:09','2010-10-05 23:46:09'),('U39865d82b','adde2ee9b8396a5d8d6cc1f094943d4a','2010-09-18 14:16:34','2010-09-18 14:16:34'),('U3cdc73c40','23597d67d4c48742cd7954030cea3014','2010-08-23 03:24:50','2010-08-23 03:24:50'),('U3cff1c5c0','d3d0cfbc2e6adbd23f3fbb5dcafbf606','2010-10-01 02:42:46','2010-10-01 02:42:46'),('U3db03759c','78994c482aeae767d66b2c3898e6d9a7','2010-05-09 20:35:16','2010-05-09 20:35:16'),('U3e87d7517','71fcb4997e71ef648e7debd4bd65cd47','2010-10-05 23:54:18','2
 010-10-05 23:54:18'),('U43e29b1fc','305385bb43845d5e0cc4fde940e1ca9c','2010-09-20 11:46:54','2010-09-20 11:46:54'),('U444cd49d8','cc6fb959f1b5018aeefb7ebbb9984630','2010-05-12 07:21:47','2010-05-12 07:21:47'),('U45715a0de','60e34be2a35cd2a0f2e597b5163f728a','2010-10-01 02:02:22','2010-10-01 02:02:22'),('U45dbe6341','03702562dd62682a3a3d6a2de2506bd6','2010-05-09 17:54:17','2010-05-09 17:54:17'),('U463715273','04ab8e3c0671aa2c9b29e055bab8da39','2010-05-08 19:35:05','2010-05-08 19:35:05'),('U47c48c4bd','e4061c4fc9e4a07f3567b04c66d69eef','2010-05-09 19:59:07','2010-05-09 19:59:07'),('U48234910c','30c0a392d6ce2db03711ac3f86b046ee','2010-05-12 01:55:54','2010-05-12 01:55:54'),('U497afc648','ae75a2513d99acf88e40bab2642454c6','2010-05-08 19:30:18','2010-05-08 19:30:18'),('U4ab09c426','8dbe9db9085425803993bc211a48edaf','2010-10-01 21:37:29','2010-10-01 21:37:29'),('U4cdd94df9','9cbeeb470575330159dcef0c32e95e63','2010-10-03 01:05:42','2010-10-03 01:05:42'),('U4f9ae98af','c90f1e4bdcdc5
 af17efd862168fd9521','2010-10-12 13:08:14','2010-10-12 13:08:14'),('U530a26801','4004fd4abc55b225e57741989b392ed0','2010-07-24 13:10:02','2010-07-24 13:10:02'),('U539963c3e','61ab0778e67580810a1faffacb04281a','2010-05-31 00:27:50','2010-05-31 00:27:50'),('U53d045021','06b6ab20db3ad7acf25e300db39b85d3','2010-06-09 23:12:26','2010-06-09 23:12:26'),('U56bb40fc6','ab5a8ac96e06c9b964efb89cb7b25522','2010-06-23 00:33:47','2010-06-23 00:33:47'),('U5a3c17694','376e3d1ea4f2a40c969cd5136e0b6709','2010-05-26 00:12:20','2010-05-26 00:12:20'),('U5cacd0959','1fcdc1558fba9e522f976fc839704da8','2010-10-11 17:46:01','2010-10-11 17:46:01'),('U5ccbbe61d','b16b0474f425d48cb4284e31c3ad6fd2','2010-10-23 21:13:48','2010-10-23 21:13:48'),('U5fcd4871c','4af1a85c656553f82432dd216d9a4b11','2010-06-24 21:20:11','2010-06-24 21:20:11'),('U618fde241','b9ca041a908ec9ea99edadcb9204ef3a','2010-05-08 19:36:03','2010-05-08 19:36:03'),('U62906be75','45fbdb4f3d8eac6c7449330832d9bb5f','2010-10-05 08:01:25','2010-
 10-05 08:01:25'),('U636fca053','888cc6a6ba69b2ee44dcc2cd94fc06d8','2010-05-12 01:52:15','2010-05-12 01:52:15'),('U658793ef1','327f26ce49af6d5e341b8e822bb5ef81','2010-05-13 00:40:05','2010-05-13 00:40:05'),('U680fc5e0f','fa563b032856099d1c6f103333cfd72c','2010-05-08 19:37:01','2010-05-08 19:37:01'),('U6ca50b927','aa5096b6ea0b2bd1aab3d4798c44c4fe','2010-05-09 19:51:22','2010-05-09 19:51:22'),('U6cc9d3661','83955a3317e6a8a72165d0726889804b','2010-10-06 23:27:39','2010-10-06 23:27:39'),('U6cf3b4be9','edd3d2d9acbfe47188edb60f65268b8c','2010-05-12 00:30:26','2010-05-12 00:30:26'),('U6d321c457','852adbedaf473fa7b6f01965f0fe10ba','2010-09-18 14:03:04','2010-09-18 14:03:04'),('U6d8f5355d','d5812fd57c2cd7856d3bccd06ec2b6ba','2010-05-12 10:44:28','2010-05-12 10:44:28'),('U6f046622b','831a003706153d9a54301344ef3f78c4','2010-07-24 23:22:10','2010-07-24 23:22:10'),('U6f187eaa2','87b76df19533c0f4f977f33533658850','2010-09-12 01:01:36','2010-09-12 01:01:36'),('U6f2044637','bd8630e2d5542926e
 c4b785519ab2224','2010-05-12 08:56:35','2010-05-12 08:56:35'),('U702c142e7','50e607d307ec30d6b6e3047a05c3936a','2010-05-09 20:29:52','2010-05-09 20:29:52'),('U707fad461','7829f1c55f1c1653666a07b00f89d93e','2010-05-12 01:48:12','2010-05-12 01:48:12'),('U71d945382','e24c5c5919ba85e83554336563c70f0d','2010-05-10 22:13:05','2010-05-10 22:13:05'),('U7236438f9','a83a311070a58065a801f117b1747c76','2010-10-01 21:37:22','2010-10-01 21:37:22'),('U760295e46','4a21365f57f682b2d0021764ac951243','2010-05-13 01:19:25','2010-05-13 01:19:25'),('U77d5aef64','ede20c87369e2a08f7c8bc745cf9f1f4','2010-05-12 02:23:44','2010-05-12 02:23:44'),('U7ae8dfb79','79bb636f81b07b3b262639672a212a05','2010-05-12 01:14:42','2010-05-12 01:14:42'),('U7b87ae651','bab613a8c97c921e72e85f94e1dd3e36','2010-10-07 23:40:59','2010-10-07 23:40:59'),('U7d608dcd4','81b985ac254ceecdaaac1ff4f5e04a53','2010-05-10 10:07:50','2010-05-10 10:07:50'),('U7ee62fc81','f4f08b4c12cbc197dcd00062950d63f4','2010-05-12 02:26:20','2010-05-1
 2 02:26:20'),('U80a762653','7c1a4b82cdd62504f672fd1e084d21da','2010-10-05 23:51:49','2010-10-05 23:51:49'),('U82c0d8bb1','c6072d7f2ea788ccd381458f990a537f','2010-09-23 15:54:19','2010-09-23 15:54:19'),('U82df0fc43','9f1701acadcecf47458f8ec59e5b4ccf','2010-05-13 21:58:22','2010-05-13 21:58:22'),('U832ad15df','f0a338292ca6191d7f1bf77c4dc0ed0b','2010-09-28 05:02:12','2010-09-28 05:02:12'),('U835961fff','1ada0f5e37784dd9e55fbfbc49e088c2','2010-05-09 20:18:06','2010-05-09 20:18:06'),('U83ab85c1b','44883dc3ff76a5f4661ba14127c7e94d','2010-05-08 19:57:33','2010-05-08 19:57:33'),('U855e8f47f','cc911ac2a2bc60e9cf3d7244019cbb37','2010-05-20 23:12:50','2010-05-20 23:12:50'),('U86299a24d','b1801a7075791eda4292a3caa74d8197','2010-09-22 23:33:24','2010-09-22 23:33:24'),('U8a85cbf01','e4d9e03c34c4f076c4cad3815fb3aceb','2010-10-21 06:53:02','2010-10-21 06:53:02'),('U8a8ab895d','bb477fd6d669c2e463739cc01d4baa0a','2010-05-12 02:32:43','2010-05-12 02:32:43'),('U8d59d045c','1a52be5734ca2c765af54
 280e3cb6ad4','2010-10-01 01:53:50','2010-10-01 01:53:50'),('U8db42a714','aafffc7acd732b98608bf4d6525b6616','2010-05-08 19:30:45','2010-05-08 19:30:45'),('U909311f65','3155bb3bd8002319536d47c7e4221d08','2010-11-03 10:39:08','2010-11-03 10:39:08'),('U91357ac04','6f446a24ee2a68caf59e8fae4bfd7f26','2010-10-02 13:56:19','2010-10-02 13:56:19'),('U92dd41180','4483f035e129f27363547ed8ee006b26','2010-07-24 22:46:39','2010-07-24 22:46:39'),('U93328fdc4','63c15d1d5bf03a1348962f495e447743','2010-05-09 17:42:31','2010-05-09 17:42:31'),('U94998bf97','16b7f832a5ad8ec372998529542f9027','2010-09-20 18:53:34','2010-09-20 18:53:34'),('U9b306706c','b3e99360995cc9faad0eef2effd56008','2010-06-05 11:22:06','2010-06-05 11:22:06'),('U9b7b4d7ad','9834b8c4e051f05b9725a3f705ea3f82','2010-05-12 04:02:13','2010-05-12 04:02:13'),('U9b96081c1','43559ca0f91eb325442b2155999a0730','2010-07-31 22:42:05','2010-07-31 22:42:05'),('U9be5c652d','6c433d91adca094de3138cbab1ebae35','2010-05-08 17:04:05','2010-05-08 17
 :04:05'),('U9c5119c02','b3059eeeaf1f9ed1a2b4ca3a7c82300c','2010-10-01 02:01:27','2010-10-01 02:01:27'),('U9d2026cfe','dd77f01570c1f3bc79cbd07f988e9d4b','2010-07-02 02:32:18','2010-07-02 02:32:18'),('Ua0fe52ce6','7e0246a25b0ed9d83d027d28f135f885','2010-05-12 01:41:46','2010-05-12 01:41:46'),('Ua17b802ea','0f70239d98944807ec20182fdf8d4904','2010-10-11 22:15:23','2010-10-11 22:15:23'),('Ua2d33ecf7','775d7ddaefe5c2cbfe52865af1a0e653','2010-05-10 09:53:39','2010-05-10 09:53:39'),('Ua663f0756','c693fb841b2fb89c110cadd5984e20b9','2010-05-12 06:47:25','2010-05-12 06:47:25'),('Uab8e34897','6452eb6d063e278c272e39b4428eb8b6','2010-05-10 21:37:38','2010-05-10 21:37:38'),('Uac487712c','4655bc00488eef5d32f8149b682f9328','2010-09-21 17:20:44','2010-09-21 17:20:44'),('Uaef8d99b1','23fc9a6707161ef690aeed7fe784762b','2010-08-14 15:21:10','2010-08-14 15:21:10'),('Ub0c4cfd3c','31db526f5ed70d7a50cce2b8de2e7536','2010-06-02 17:46:22','2010-06-02 17:46:22'),('Ub4199fa12','c1fcb0f02ffcb1606ec9f3944
 4eb237f','2010-10-08 12:41:08','2010-10-08 12:41:08'),('Ub5752cc53','86bb47453a2d0ca9821d8e26d39f1884','2010-05-13 05:37:12','2010-05-13 05:37:12'),('Ub5c58b6be','5b5779bd40ccd83a3434b1236be2d479','2010-06-26 04:26:21','2010-06-26 04:26:21'),('Ub9a310e2a','aa28e556819c9cb91aaa8044fc7f7b06','2010-10-01 01:56:26','2010-10-01 01:56:26'),('Ubadbf7558','9df9ed41e8a68c2ea37a4ebd7b6eea4c','2010-05-12 02:23:29','2010-05-12 02:23:29'),('Ubb447ca40','279ab97b2fb42dc3c745ce46a7d30077','2010-09-18 14:03:59','2010-09-18 14:03:59'),('Ubbd31de5c','a59c3d04856c9df138c06d2c05490ca3','2010-05-08 19:43:48','2010-05-08 19:43:48'),('Uc12d9b351','bc8827efa951e067fbaa680e528c3a6d','2010-07-02 01:50:35','2010-07-02 01:50:35'),('Uc18025643','60bf8ca957363b7fcbd14a206e9ccfe8','2010-05-09 17:46:34','2010-05-09 17:46:34'),('Uc50e52674','82032eab1a5301a57a0790dca7c828c5','2010-05-08 19:37:15','2010-05-08 19:37:15'),('Uca72602cb','4115c2bc2c6f066fee510635cdd75cfb','2010-09-18 17:31:53','2010-09-18 17:31:
 53'),('Uccccbde0a','2ec50514ff2296520761e3e68e9fd81f','2010-09-21 17:37:30','2010-09-21 17:37:30'),('Ucd924588a','180dfffc61d5bd1da891b9ae66f64244','2010-05-31 08:20:44','2010-05-31 08:20:44'),('Ucfae42d5b','41e8038aed347868d8cf273aba7ac4ef','2010-07-11 16:16:24','2010-07-11 16:16:24'),('Ud026db27d','c3732ee4a0cb883ab258268e081d9719','2010-06-02 07:30:04','2010-06-02 07:30:04'),('Ud32632b05','c1d1bb47081284cb55f94f30da0cfde8','2010-07-01 23:07:20','2010-07-01 23:07:20'),('Ud474bcd73','0fdcfbd07a893ffec59ff2c2790b7a7f','2010-05-10 06:37:02','2010-05-10 06:37:02'),('Ud686002bf','c9d2c5861bb324a8a25854971bc0ee15','2010-09-18 14:13:48','2010-09-18 14:13:48'),('Ud7ad8712e','c35615e736a54f3fb268ab740e880bd7','2010-07-03 01:00:41','2010-07-03 01:00:41'),('Ud80eac800','fa98ae8bdbb3670d27d9420567701ca1','2010-07-01 23:06:44','2010-07-01 23:06:44'),('Ude5101aea','5fe646e7054d3c0629f1cc9e9274e556','2010-05-12 03:06:45','2010-05-12 03:06:45'),('Udf0c7365d','eb2a37a4adf42c68a301473d1241b
 12e','2010-10-01 21:37:57','2010-10-01 21:37:57'),('Ue0c7bba79','224b41bf03a468685538283684e627b3','2010-09-22 23:33:50','2010-09-22 23:33:50'),('Ue30d2e3da','880d2947aa1a2e7a263ab5d99751e81f','2010-05-13 20:18:16','2010-05-13 20:18:16'),('Ue46a98fbb','18488da5ab1c69aa577dade5fe94a6a6','2010-05-10 09:58:29','2010-05-10 09:58:29'),('Ue728341a1','989d496f775de9153d7fe2d06c18be50','2010-10-23 21:13:33','2010-10-23 21:13:33'),('Ue73ed1c70','f7a7aace601d2a5fa7ab3013363b0dac','2010-05-13 00:38:16','2010-05-13 00:38:16'),('Ue8a15b047','a56e3bdef2fed0b6cb56058df836a259','2010-05-09 20:05:05','2010-05-09 20:05:05'),('Uea36db2f7','2c2a795a15be6f90264f9e2443824106','2010-10-12 13:08:33','2010-10-12 13:08:33'),('Ued7c6b37f','76f92b02f70a6ac0b948571dcd57383c','2010-05-08 20:34:06','2010-05-08 20:34:06'),('Uee2327278','cac7b4be6bcc815aa3bb4ad2d275a3cc','2010-05-10 23:08:25','2010-05-10 23:08:25'),('Uef2ec541a','20232508e7f5b037e55029c2565d3fef','2010-06-02 00:10:38','2010-06-02 00:10:38')
 ,('Uf09cf742a','80fa5e93c69ca442f3f5190214f585b4','2010-10-11 22:16:04','2010-10-11 22:16:04'),('Uf1cee9840','eea802699a5a81cd537c6898282f3753','2010-05-12 02:18:12','2010-05-12 02:18:12'),('Uf23e58a24','94a10d050fa0e4737aff9a60ca0f87c0','2010-05-12 01:45:05','2010-05-12 01:45:05'),('Uf4b0e06e2','c2fe0f859a44c834485aca7bbe616b8d','2010-07-24 13:09:39','2010-07-24 13:09:39'),('Uf4d1187c6','41489cf0d193754c17260c9956263998','2010-05-12 02:11:29','2010-05-12 02:11:29'),('Uf7b146095','e5e5890ff911b5fe06df12b74deae3bf','2010-05-12 06:35:59','2010-05-12 06:35:59'),('Uf85c12875','888e76c7dc45e49803e1ac2bf96ef5c9','2010-09-14 12:48:52','2010-09-14 12:48:52'),('Uf97f64209','4975c817f291dd11beba47b5a5a9405a','2010-09-18 14:00:41','2010-09-18 14:00:41'),('Ufbc370dc6','cdd1878b0dc17d62158debc2878df005','2010-05-20 23:07:50','2010-05-20 23:07:50'),('Ufc48316c6','736a0ef470d530819aac1bbafad6fefc','2010-10-08 13:44:13','2010-10-08 13:44:13'),('Ufcde30624','ef10d4e00ccb368f4de15fbe82a531e7'
 ,'2010-06-29 22:42:12','2010-06-29 22:42:12'),('Ufd75e5be5','9c44b8073419bdef8332bc3e5f042667','2010-10-07 12:54:37','2010-10-07 12:54:37');
+/*!40000 ALTER TABLE `t_login` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_map`
+--
+
+DROP TABLE IF EXISTS `t_map`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_map` (
+  `mapID` smallint(5) unsigned NOT NULL,
+  `mapName` varchar(40) DEFAULT NULL,
+  `mapExplanation` varchar(100) DEFAULT NULL,
+  `mapComponent` varchar(1000) DEFAULT NULL,
+  `lastUpdateDate` varchar(45) DEFAULT NULL,
+  PRIMARY KEY (`mapID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_map`
+--
+
+LOCK TABLES `t_map` WRITE;
+/*!40000 ALTER TABLE `t_map` DISABLE KEYS */;
+INSERT INTO `t_map` VALUES (1,'夷陵戦','','1111111111111111111111111111111111114441111111111111161111111111111111111111111111111111111111114441111111111111166111111111111111111111111111111111111111114441111111111111111111111111111111111111111111111111111111114441111111111111111111111111111111111111111111111111111111114441111111111111111111111111111111111111111111111111111111114441111111111111111111111111111111111111111111111111111111114441111111111111111111111111111111111111111111111111111111144411111111111111111111111111111111111111111111111111111111144411111111111111111111111111111111111111111411111111111111144411111111111111111111111111111111111111114411111111111111144411111111111111111111111111111111111111114111111111111111144411111111111111111111111111111111111111144111111111111111144411111111111111111111111111111111111111144111111111111111444111111111111111111111111111111111111111144111111111111111444111111111111111111111111111111111111111141111111111111111444111111
 111111111111111111111111111111111441111111111111114441111','2010-05-02 02:01:38'),(2,'合肥戦','','333333666333333333338883333333338333333333332333333333333333333333666333333333333388833333338333333333332333333333333333333333366333333333333333888333338333333333332333333333333333333333366333333333333333338883338333333333322333333333333333333333333333333333333333333388838333333333322333333333333333333333333333333333333333333333888333333333322333333333333333633333333333333333333333333333338833333333322333333333333333633333333333333333333333333333333833333333322333333333333333333333322233333333322233333333333833333333322333333333333333333333222222333333222233333333333833333333322333333333333333333333322222333333222333333333333833333333222333333333333388333333333323333373333333333333333833333333222333333888888883333333333333333333333333333333333833333332888888888833333333333333333333333333333333333333333833333338823333333333333333333333333333333333333333333333333833333888223333
 3333333333333332222333333333333333333333333338333338322333333333333333333332223333333333333333333333333338888888','2010-05-02 02:01:38'),(3,'陽平関戦','','11111111331111111111111111111111111111111111111111111113311111111111311111111111111111111111111111111111111111111111311111111111311111111111111111111111111111111111111111111111331111111113311111111111111111111111111111111111111111111111133111111113111111111111111111111111111111111111111111111111113111111113111111111111111111111111111111111111111111111111113311111113111111111111111111111111111111111111111111111111111311111113111111111111111111111111111111111111111111111111111311111111111111111111111111111111111111111111111311111111111311111111111111111111131111111111111111111111111311111111111311111111111111111111131111111111111111111111113311111111111311111111111111111111131111111111111111111111113111111111111311111111111111111111331111111111111111111111113222222222222311111111111111111111311111111111111111122222233222
 22222222231111111111111111111131112222211111111222222233222222222222231111111222222222111132222222222221122222222332222222222222231111112222222222255232222222222222222222','2010-05-02 02:01:38');
+/*!40000 ALTER TABLE `t_map` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_room`
+--
+
+DROP TABLE IF EXISTS `t_room`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_room` (
+  `roomID` smallint(5) unsigned NOT NULL,
+  `roomName` varchar(40) DEFAULT NULL,
+  `roomStatus` tinyint(3) unsigned DEFAULT NULL,
+  `offenseCountry` smallint(5) unsigned DEFAULT NULL,
+  `defenseCountry` smallint(5) unsigned DEFAULT NULL,
+  `mapID` smallint(5) unsigned DEFAULT NULL,
+  `maxTurnCount` smallint(5) unsigned DEFAULT NULL,
+  `turnCount` smallint(5) unsigned DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`roomID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_room`
+--
+
+LOCK TABLES `t_room` WRITE;
+/*!40000 ALTER TABLE `t_room` DISABLE KEYS */;
+INSERT INTO `t_room` VALUES (1,'夷陵',2,1,2,1,60,0,'2010-10-26 06:59:01'),(2,'夷陵',2,1,3,1,60,0,'2010-11-03 15:00:01'),(3,'合肥',2,2,1,2,60,0,'2010-10-08 04:31:01'),(4,'合肥',2,2,3,2,60,0,'2010-10-12 02:40:02'),(5,'陽平関',2,3,2,3,60,0,'2010-10-12 02:37:01');
+/*!40000 ALTER TABLE `t_room` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_turnTimer`
+--
+
+DROP TABLE IF EXISTS `t_turnTimer`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_turnTimer` (
+  `roomID` smallint(5) unsigned DEFAULT NULL,
+  `receiptTime` datetime DEFAULT NULL,
+  `turnInterval` int(11) DEFAULT NULL,
+  `gameInterval` int(11) DEFAULT NULL,
+  `timerStatus` smallint(5) unsigned DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_turnTimer`
+--
+
+LOCK TABLES `t_turnTimer` WRITE;
+/*!40000 ALTER TABLE `t_turnTimer` DISABLE KEYS */;
+INSERT INTO `t_turnTimer` VALUES (1,'2010-10-26 06:59:01',180,300,0),(2,'2010-11-03 15:00:02',180,300,0),(3,'2010-10-08 04:31:01',180,300,0),(4,'2010-10-12 02:40:02',180,300,0),(5,'2010-10-12 02:37:01',180,300,0);
+/*!40000 ALTER TABLE `t_turnTimer` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_user`
+--
+
+DROP TABLE IF EXISTS `t_user`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_user` (
+  `userID` varchar(10) NOT NULL,
+  `twitterID` varchar(40) DEFAULT NULL,
+  `userName` varchar(40) DEFAULT NULL,
+  `twitterToken` varchar(40) DEFAULT NULL,
+  `country` smallint(5) unsigned DEFAULT NULL,
+  `paramID` smallint(5) unsigned DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`userID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_user`
+--
+
+LOCK TABLES `t_user` WRITE;
+/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
+INSERT INTO `t_user` VALUES ('0af5f8de42',NULL,'',NULL,NULL,NULL,'2010-05-05 20:51:25'),('37ac5d6b0d',NULL,'abcdefg',NULL,NULL,NULL,'2010-05-05 20:45:12'),('3aef5d0e7e',NULL,'あいうえお',NULL,NULL,NULL,'2010-05-05 20:57:42'),('3f84dc5de6',NULL,'zxxxx',NULL,NULL,NULL,'2010-05-05 22:06:57'),('41967a8ac5',NULL,'d',NULL,NULL,NULL,'2010-05-02 22:09:44'),('4a02f8fff3',NULL,'e',NULL,NULL,NULL,'2010-05-02 22:23:36'),('83bfee2209',NULL,'',NULL,NULL,NULL,'2010-05-02 22:24:06'),('928b4b3e82',NULL,'',NULL,NULL,NULL,'2010-05-05 20:43:34'),('948c0971bf',NULL,'\\\'',NULL,NULL,NULL,'2010-05-05 20:45:54'),('9e057cf47e',NULL,'',NULL,NULL,NULL,'2010-05-05 20:55:03'),('b266f8f283',NULL,'ccccccc',NULL,NULL,NULL,'2010-05-05 21:20:23'),('da73eceb9d',NULL,'b',NULL,NULL,NULL,'2010-05-02 21:52:15'),('dd215e93af',NULL,'a',NULL,NULL,NULL,'2010-05-02 22:44:59'),('e20ceab73e',NULL,'c',NULL,NULL,NULL,'2010-05-02 21:54:45'),('U0143b5eaa',NULL,'Uee2327278',NULL,1,164,'2010-05-12 01:39:10'),('U02536abdc
 ',NULL,'ak3_test3',NULL,2,164,'2010-05-12 03:38:05'),('U0260be6f9',NULL,'tttttt',NULL,1,164,'2010-06-22 01:37:18'),('U02de1eda6',NULL,'うほほのほ',NULL,2,164,'2010-06-02 23:19:17'),('U035514ce8',NULL,'000009',NULL,1,164,'2010-05-08 19:40:02'),('U0510488ed',NULL,'test007',NULL,3,164,'2010-05-10 09:24:40'),('U07d2e9cd2',NULL,'凛',NULL,2,164,'2010-09-22 23:35:22'),('U07fb00210',NULL,'ist 101',NULL,3,164,'2010-05-12 09:05:15'),('U0b8206c6e',NULL,'hononohoh',NULL,2,164,'2010-10-05 23:54:55'),('U0db742293',NULL,'test009',NULL,1,164,'2010-05-10 09:54:44'),('U0ffa91522',NULL,'shinrai',NULL,3,164,'2010-09-10 23:57:11'),('U102a015a9',NULL,'Demo player 2',NULL,3,164,'2010-06-24 23:41:24'),('U10728c8da',NULL,'ak_12345678',NULL,1,164,'2010-10-01 21:37:40'),('U108c2da78',NULL,'AA',NULL,2,164,'2010-06-22 01:48:01'),('U12d7cb916',NULL,'咲',NULL,3,164,'2010-09-22 23:34:35'),('U137417190',NULL,'rossi_',NULL,2,164,'2010-10-01 01:55:28'),('U1927eccd1',NULL,'test',NULL,2,164,'2010-05-10 2
 2:34:27'),('U23ce4fe74',NULL,'rossi3',NULL,2,164,'2010-07-01 23:43:57'),('U265f6d781',NULL,'ma_6',NULL,3,164,'2010-05-13 23:19:00'),('U28cfcc1b9',NULL,'てんき',NULL,1,164,'2010-05-11 23:07:14'),('U2a666421e',NULL,'タカ',NULL,3,164,'2010-10-08 12:41:35'),('U2b0f32a9d',NULL,'000005',NULL,2,164,'2010-05-08 19:35:24'),('U2d6e34d0c',NULL,'ぬぅ',NULL,2,164,'2010-09-22 23:34:50'),('U308f7a20e',NULL,'000002',NULL,3,164,'2010-05-08 19:30:40'),('U31519e2a3',NULL,'ひろゆ',NULL,1,164,'2010-05-25 22:51:11'),('U3274f4fc3',NULL,'rossi2',NULL,2,164,'2010-07-01 23:12:25'),('U32e997c8e',NULL,'ma_11',NULL,1,164,'2010-05-22 23:54:02'),('U3745c6424',NULL,'ak3_test',NULL,1,164,'2010-05-12 03:01:22'),('U385674d53',NULL,'IS01',NULL,2,164,'2010-08-04 01:01:40'),('U391f182a6',NULL,'narunaru235',NULL,1,164,'2010-10-05 23:46:02'),('U39865d82b',NULL,'りゅう',NULL,1,164,'2010-09-18 14:16:28'),('U39f2b20aa',NULL,'aaa',NULL,3,164,'2010-05-11 01:32:30'),('U3cdc73c40',NULL,'ak-test',NULL,3,164,'
 2010-08-23 03:24:48'),('U3cff1c5c0',NULL,'narunaru512234',NULL,3,164,'2010-10-01 02:42:41'),('U3db03759c',NULL,'test005',NULL,2,164,'2010-05-09 20:35:16'),('U3e87d7517',NULL,'teltelte122',NULL,3,164,'2010-10-05 23:54:14'),('U43e29b1fc',NULL,'hikki',NULL,2,164,'2010-09-20 11:46:53'),('U444cd49d8',NULL,'ma_1',NULL,1,164,'2010-05-12 07:21:41'),('U45715a0de',NULL,'narunaru51223!',NULL,2,164,'2010-10-01 02:02:22'),('U45dbe6341',NULL,'xxx0003',NULL,1,164,'2010-05-09 17:49:48'),('U463715273',NULL,'000004',NULL,1,164,'2010-05-08 19:35:05'),('U47c48c4bd',NULL,'test002',NULL,1,164,'2010-05-09 19:59:07'),('U497afc648',NULL,'000001',NULL,1,164,'2010-05-08 19:30:18'),('U4ab09c426',NULL,'ak_12345',NULL,3,164,'2010-10-01 21:37:29'),('U4cdd94df9',NULL,'茶図',NULL,2,164,'2010-10-03 01:05:30'),('U4f9ae98af',NULL,'うぬり',NULL,2,164,'2010-10-12 13:08:14'),('U530a26801',NULL,'yyy',NULL,3,164,'2010-07-24 13:09:59'),('U539963c3e',NULL,'moo_twit',NULL,3,164,'2010-05-31 00:27:50'),('U53d045021
 ',NULL,'tenki',NULL,3,164,'2010-06-09 23:12:05'),('U56bb40fc6',NULL,'nnn',NULL,3,164,'2010-06-23 00:33:45'),('U5a3c17694',NULL,'ゆきひろろろ',NULL,2,164,'2010-05-26 00:12:13'),('U5cacd0959',NULL,'たなか',NULL,2,164,'2010-10-11 17:45:54'),('U5ccbbe61d',NULL,'あか',NULL,1,164,'2010-10-23 21:13:42'),('U5fcd4871c',NULL,'Demo player',NULL,1,164,'2010-06-24 21:20:07'),('U618fde241',NULL,'000006',NULL,3,164,'2010-05-08 19:36:03'),('U62906be75',NULL,'toyo',NULL,1,164,'2010-10-05 08:00:40'),('U658793ef1',NULL,'ma_3',NULL,2,164,'2010-05-13 00:40:03'),('U680fc5e0f',NULL,'000007',NULL,2,164,'2010-05-08 19:37:01'),('U6ca50b927',NULL,'test001',NULL,3,164,'2010-05-09 19:51:22'),('U6cc9d3661',NULL,'testooooooo',NULL,3,164,'2010-10-06 23:27:36'),('U6cf3b4be9',NULL,'aaaa',NULL,2,164,'2010-05-12 00:30:26'),('U6d321c457',NULL,'よりと',NULL,1,164,'2010-09-18 14:02:41'),('U6d8f5355d',NULL,'ak3_test1',NULL,1,164,'2010-05-12 10:44:26'),('U6f046622b',NULL,'裕之でーす',NULL,3,164,'
 2010-07-24 23:22:02'),('U6f187eaa2',NULL,'テスト',NULL,1,164,'2010-09-12 01:01:31'),('U6f2044637',NULL,'ist_001',NULL,3,164,'2010-05-12 08:56:24'),('U702c142e7',NULL,'test004',NULL,1,164,'2010-05-09 20:29:51'),('U707fad461',NULL,'test013',NULL,3,164,'2010-05-12 01:48:12'),('U71d945382',NULL,'たっき',NULL,3,164,'2010-05-10 22:12:50'),('U7236438f9',NULL,'ak_1234567890',NULL,3,164,'2010-10-01 21:37:12'),('U760295e46',NULL,'ma_5',NULL,1,164,'2010-05-13 01:19:23'),('U7ae8dfb79',NULL,'qqq',NULL,2,164,'2010-05-12 01:14:42'),('U7b87ae651',NULL,'momomoo',NULL,3,164,'2010-10-07 23:40:55'),('U7bd5r6a2d',NULL,'taka8',NULL,1,164,'2010-05-09 15:08:09'),('U7d608dcd4',NULL,'test011',NULL,2,164,'2010-05-10 10:07:50'),('U7ebaf5c0b',NULL,'aaat',NULL,2,164,'2010-05-11 01:32:48'),('U80a762653',NULL,'narunaru2345',NULL,3,164,'2010-10-05 23:51:46'),('U82c0d8bb1',NULL,'regoris ',NULL,3,164,'2010-09-23 15:54:13'),('U82df0fc43',NULL,'あかさたな',NULL,1,164,'2010-05-13 21:58:10'),('U832ad15
 df',NULL,'ぐんぐん',NULL,2,164,'2010-09-28 05:02:00'),('U835961fff',NULL,'test003',NULL,2,164,'2010-05-09 20:18:06'),('U83ab85c1b',NULL,'000012',NULL,3,164,'2010-05-08 19:57:33'),('U855e8f47f',NULL,'shige',NULL,3,164,'2010-05-20 23:12:49'),('U86299a24d',NULL,'策',NULL,1,164,'2010-09-22 23:33:20'),('U8a85cbf01',NULL,'TK',NULL,1,164,'2010-10-21 06:53:02'),('U8d59d045c',NULL,'narunaru23',NULL,2,164,'2010-10-01 01:53:50'),('U8db42a714',NULL,'000003',NULL,1,164,'2010-05-08 19:30:45'),('U909311f65',NULL,'WA',NULL,3,164,'2010-11-03 10:39:02'),('U91357ac04',NULL,'たなはまやら',NULL,3,164,'2010-10-02 13:56:16'),('U92dd41180',NULL,'nihongoutenai',NULL,2,164,'2010-07-24 22:46:36'),('U93328fdc4',NULL,'xxx0001',NULL,2,164,'2010-05-09 17:42:31'),('U94998bf97',NULL,'はろきち',NULL,3,164,'2010-09-20 18:52:05'),('U9b306706c',NULL,'hohoho',NULL,1,164,'2010-06-05 11:22:03'),('U9b7b4d7ad',NULL,' ak3_tests',NULL,2,164,'2010-05-12 04:02:11'),('U9b96081c1',NULL,'もも',NULL,1,164,'
 2010-07-31 22:42:01'),('U9be5c652d',NULL,'aaaaaaaaaa',NULL,NULL,1,'2010-05-08 17:04:05'),('U9c5119c02',NULL,'あかさたなはまやらわ',NULL,3,164,'2010-10-01 02:01:25'),('U9d2026cfe',NULL,'Anknown',NULL,1,164,'2010-07-02 02:31:12'),('Ua0fe52ce6',NULL,'Ue',NULL,2,164,'2010-05-12 01:41:46'),('Ua17b802ea',NULL,'アボカド',NULL,2,164,'2010-10-11 22:15:23'),('Ua2d33ecf7',NULL,'test008',NULL,3,164,'2010-05-10 09:53:39'),('Ua663f0756',NULL,'裕之',NULL,1,164,'2010-05-12 06:47:25'),('Uab8e34897',NULL,'non',NULL,3,164,'2010-05-10 21:37:32'),('Uac487712c',NULL,'tyamaz ',NULL,1,164,'2010-09-21 17:20:44'),('Uaef8d99b1',NULL,'おおららら',NULL,1,164,'2010-08-14 15:21:08'),('Ub0c4cfd3c',NULL,'ペア\n',NULL,3,164,'2010-06-02 17:46:18'),('Ub4199fa12',NULL,'Taka',NULL,2,164,'2010-10-08 12:41:08'),('Ub5752cc53',NULL,'test_102',NULL,3,164,'2010-05-13 05:37:09'),('Ub5c58b6be',NULL,'taro',NULL,2,164,'2010-06-26 04:26:04'),('Ub9a310e2a',NULL,'narunaru51223',NULL,1,164,'2010-10-01 0
 1:55:57'),('Ubadbf7558',NULL,'Uee23454323',NULL,2,164,'2010-05-12 02:23:29'),('Ubb447ca40',NULL,'oritoy',NULL,3,164,'2010-09-18 14:03:40'),('Ubbd31de5c',NULL,'000011',NULL,3,164,'2010-05-08 19:43:48'),('Uc12d9b351',NULL,'testes',NULL,3,164,'2010-07-02 01:49:32'),('Uc18025643',NULL,'xxx0002',NULL,1,164,'2010-05-09 17:46:34'),('Uc50e52674',NULL,'000008',NULL,3,164,'2010-05-08 19:37:15'),('Uca72602cb',NULL,'政志っす',NULL,2,164,'2010-09-18 17:31:53'),('Uccccbde0a',NULL,'かんすけ',NULL,1,164,'2010-09-21 17:37:30'),('Ucd924588a',NULL,'okotaneko',NULL,3,164,'2010-05-31 08:20:44'),('Ucfae42d5b',NULL,'へろゆき',NULL,1,164,'2010-07-11 16:16:19'),('Ud026db27d',NULL,'futatan ',NULL,1,164,'2010-06-02 07:29:59'),('Ud32632b05',NULL,'rossijp',NULL,1,164,'2010-07-01 23:07:15'),('Ud474bcd73',NULL,'test006',NULL,1,164,'2010-05-10 06:37:02'),('Ud686002bf',NULL,'白起',NULL,3,164,'2010-09-18 14:10:11'),('Ud7ad8712e',NULL,'ankown1',NULL,1,164,'2010-07-03 01:00:39'),('Ud80eac800',NUL
 L,'rossi',NULL,3,164,'2010-07-01 23:06:44'),('Ude5101aea',NULL,'ak3_test2',NULL,1,164,'2010-05-12 03:06:19'),('Udf0c7365d',NULL,'ak_123',NULL,2,164,'2010-10-01 21:37:56'),('Ue0c7bba79',NULL,'佐久',NULL,1,164,'2010-09-22 23:33:50'),('Ue30d2e3da',NULL,'ひろゆき',NULL,3,164,'2010-05-13 20:18:12'),('Ue46a98fbb',NULL,'test010',NULL,1,164,'2010-05-10 09:58:29'),('Ue728341a1',NULL,'あ',NULL,2,164,'2010-10-23 21:13:33'),('Ue73ed1c70',NULL,'ma_2',NULL,2,164,'2010-05-13 00:38:14'),('Ue8a15b047',NULL,'xxx0004',NULL,3,164,'2010-05-09 20:03:15'),('Uea36db2f7',NULL,'うぬり\n',NULL,3,164,'2010-10-12 13:08:19'),('Ued7c6b37f',NULL,'000010',NULL,2,164,'2010-05-08 19:40:28'),('Uee2327278',NULL,'akifumi3_test',NULL,3,164,'2010-05-10 23:08:17'),('Uef2ec541a',NULL,'ひるゆき',NULL,3,164,'2010-06-02 00:10:32'),('Uf09cf742a',NULL,'アボカド\n',NULL,3,164,'2010-10-11 22:15:07'),('Uf1cee9840',NULL,'123345678900',NULL,1,164,'2010-05-12 02:18:12'),('Uf23e58a24',NULL,'ttttt',NULL,2,164,'
 2010-05-12 01:45:05'),('Uf4b0e06e2',NULL,'uuii\n',NULL,3,164,'2010-07-24 13:09:39'),('Uf7b146095',NULL,'hiroyuki',NULL,2,164,'2010-05-12 06:35:59'),('Uf85c12875',NULL,'moon',NULL,2,164,'2010-09-14 12:48:34'),('Uf97f64209',NULL,'ktsugita',NULL,3,164,'2010-09-18 14:00:17'),('Ufbc370dc6',NULL,'shige0501',NULL,3,164,'2010-05-20 23:07:50'),('Ufbcf6bfcc',NULL,'test 012',NULL,1,164,'2010-05-11 01:40:54'),('Ufc48316c6',NULL,'hoge',NULL,2,164,'2010-10-08 13:44:06'),('Ufcde30624',NULL,'ankown',NULL,1,164,'2010-06-29 22:27:30'),('Ufd75e5be5',NULL,'よーこ。',NULL,2,164,'2010-10-07 12:54:14');
+/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_userAction`
+--
+
+DROP TABLE IF EXISTS `t_userAction`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_userAction` (
+  `userID` varchar(10) NOT NULL,
+  `roomID` smallint(5) unsigned DEFAULT NULL,
+  `moveMapChipNo` smallint(5) unsigned DEFAULT NULL,
+  `battleCommandID` smallint(5) unsigned DEFAULT NULL,
+  `battleMapChipNo` smallint(5) unsigned DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`userID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_userAction`
+--
+
+LOCK TABLES `t_userAction` WRITE;
+/*!40000 ALTER TABLE `t_userAction` DISABLE KEYS */;
+/*!40000 ALTER TABLE `t_userAction` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `t_userStatus`
+--
+
+DROP TABLE IF EXISTS `t_userStatus`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_userStatus` (
+  `userID` varchar(10) NOT NULL,
+  `win` int(10) unsigned DEFAULT NULL,
+  `lost` int(10) unsigned DEFAULT NULL,
+  `lastUpdateDate` datetime DEFAULT NULL,
+  PRIMARY KEY (`userID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `t_userStatus`
+--
+
+LOCK TABLES `t_userStatus` WRITE;
+/*!40000 ALTER TABLE `t_userStatus` DISABLE KEYS */;
+INSERT INTO `t_userStatus` VALUES ('U0260be6f9',0,0,'2010-06-22 01:37:19'),('U02de1eda6',0,0,'2010-06-02 23:19:17'),('U07d2e9cd2',0,0,'2010-09-22 23:35:22'),('U0b8206c6e',0,0,'2010-10-05 23:54:55'),('U0ffa91522',0,0,'2010-09-10 23:57:11'),('U102a015a9',0,0,'2010-06-24 23:41:24'),('U10728c8da',0,0,'2010-10-01 21:37:40'),('U108c2da78',0,0,'2010-06-22 01:48:01'),('U12d7cb916',0,0,'2010-09-22 23:34:35'),('U137417190',0,0,'2010-10-01 01:55:28'),('U23ce4fe74',0,0,'2010-07-01 23:43:57'),('U2a666421e',0,0,'2010-10-08 12:41:35'),('U2d6e34d0c',0,0,'2010-09-22 23:34:50'),('U31519e2a3',0,0,'2010-05-25 22:51:11'),('U3274f4fc3',0,0,'2010-07-01 23:12:25'),('U32e997c8e',0,0,'2010-05-22 23:54:02'),('U385674d53',0,0,'2010-08-04 01:01:40'),('U391f182a6',0,0,'2010-10-05 23:46:02'),('U39865d82b',0,0,'2010-09-18 14:16:28'),('U3cdc73c40',0,0,'2010-08-23 03:24:48'),('U3cff1c5c0',0,0,'2010-10-01 02:42:41'),('U3e87d7517',0,0,'2010-10-05 23:54:14'),('U43e29b1fc',0,0,'2010-09-20 11:46:54'),('U45715a0de
 ',0,0,'2010-10-01 02:02:22'),('U4ab09c426',0,0,'2010-10-01 21:37:29'),('U4cdd94df9',0,0,'2010-10-03 01:05:30'),('U4f9ae98af',0,0,'2010-10-12 13:08:14'),('U530a26801',0,0,'2010-07-24 13:09:59'),('U539963c3e',0,0,'2010-05-31 00:27:50'),('U53d045021',0,0,'2010-06-09 23:12:05'),('U56bb40fc6',0,0,'2010-06-23 00:33:45'),('U5a3c17694',0,0,'2010-05-26 00:12:13'),('U5cacd0959',0,0,'2010-10-11 17:45:54'),('U5ccbbe61d',0,0,'2010-10-23 21:13:42'),('U5fcd4871c',0,0,'2010-06-24 21:20:07'),('U62906be75',0,0,'2010-10-05 08:00:40'),('U6cc9d3661',0,0,'2010-10-06 23:27:36'),('U6d321c457',0,0,'2010-09-18 14:02:41'),('U6f046622b',0,0,'2010-07-24 23:22:03'),('U6f187eaa2',0,0,'2010-09-12 01:01:31'),('U7236438f9',0,0,'2010-10-01 21:37:12'),('U7b87ae651',0,0,'2010-10-07 23:40:55'),('U80a762653',0,0,'2010-10-05 23:51:46'),('U82c0d8bb1',0,0,'2010-09-23 15:54:13'),('U832ad15df',0,0,'2010-09-28 05:02:00'),('U855e8f47f',0,0,'2010-05-20 23:12:49'),('U86299a24d',0,0,'2010-09-22 23:33:20'),('U8a85cbf01',0,0
 ,'2010-10-21 06:53:02'),('U8d59d045c',0,0,'2010-10-01 01:53:50'),('U909311f65',0,0,'2010-11-03 10:39:02'),('U91357ac04',0,0,'2010-10-02 13:56:16'),('U92dd41180',0,0,'2010-07-24 22:46:36'),('U94998bf97',0,0,'2010-09-20 18:52:05'),('U9b306706c',0,0,'2010-06-05 11:22:03'),('U9b96081c1',0,0,'2010-07-31 22:42:01'),('U9c5119c02',0,0,'2010-10-01 02:01:25'),('U9d2026cfe',0,0,'2010-07-02 02:31:12'),('Ua17b802ea',0,0,'2010-10-11 22:15:23'),('Uac487712c',0,0,'2010-09-21 17:20:44'),('Uaef8d99b1',0,0,'2010-08-14 15:21:08'),('Ub0c4cfd3c',0,0,'2010-06-02 17:46:18'),('Ub4199fa12',0,0,'2010-10-08 12:41:08'),('Ub5c58b6be',0,0,'2010-06-26 04:26:04'),('Ub9a310e2a',0,0,'2010-10-01 01:55:57'),('Ubb447ca40',0,0,'2010-09-18 14:03:40'),('Uc12d9b351',0,0,'2010-07-02 01:49:32'),('Uca72602cb',0,0,'2010-09-18 17:31:53'),('Uccccbde0a',0,0,'2010-09-21 17:37:30'),('Ucd924588a',0,0,'2010-05-31 08:20:44'),('Ucfae42d5b',0,0,'2010-07-11 16:16:19'),('Ud026db27d',0,0,'2010-06-02 07:29:59'),('Ud32632b05',0,0,'201
 0-07-01 23:07:15'),('Ud686002bf',0,0,'2010-09-18 14:10:11'),('Ud7ad8712e',0,0,'2010-07-03 01:00:39'),('Ud80eac800',0,0,'2010-07-01 23:06:44'),('Udf0c7365d',0,0,'2010-10-01 21:37:56'),('Ue0c7bba79',0,0,'2010-09-22 23:33:50'),('Ue728341a1',0,0,'2010-10-23 21:13:33'),('Uea36db2f7',0,0,'2010-10-12 13:08:19'),('Uef2ec541a',0,0,'2010-06-02 00:10:32'),('Uf09cf742a',0,0,'2010-10-11 22:15:07'),('Uf4b0e06e2',0,0,'2010-07-24 13:09:39'),('Uf85c12875',0,0,'2010-09-14 12:48:35'),('Uf97f64209',0,0,'2010-09-18 14:00:17'),('Ufbc370dc6',0,0,'2010-05-20 23:07:50'),('Ufc48316c6',0,0,'2010-10-08 13:44:06'),('Ufcde30624',0,0,'2010-06-29 22:27:30'),('Ufd75e5be5',0,0,'2010-10-07 12:54:14');
+/*!40000 ALTER TABLE `t_userStatus` 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 2010-11-06  0:02:41

Added: trunk/parameters/t_turnTimer.sql
===================================================================
--- trunk/parameters/t_turnTimer.sql	                        (rev 0)
+++ trunk/parameters/t_turnTimer.sql	2010-11-05 15:33:58 UTC (rev 458)
@@ -0,0 +1,5 @@
+insert into t_turnTimer values (1,now(),180,300,0);
+insert into t_turnTimer values (2,now(),180,300,0);
+insert into t_turnTimer values (3,now(),180,300,0);
+insert into t_turnTimer values (4,now(),180,300,0);
+insert into t_turnTimer values (5,now(),180,300,0);




Sangokushi-svn メーリングリストの案内