-- MySQL dump 10.9
--
-- Host: localhost    Database: karljay_betaDB
-- ------------------------------------------------------
-- Server version	4.1.22-standard

/*!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 */;
/*!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 `webchess_messages`
--

DROP TABLE IF EXISTS `webchess_messages`;
CREATE TABLE `webchess_messages` (
  `msgID` int(11) NOT NULL auto_increment,
  `gameID` smallint(6) NOT NULL default '0',
  `msgType` enum('undo','draw','under Review') default NULL,
  `msgStatus` enum('request','approved','denied') NOT NULL default 'request',
  `destination` enum('black','white') NOT NULL default 'black',
  PRIMARY KEY  (`msgID`)
) ENGINE=MyISAM AUTO_INCREMENT=1387 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `webchess_messages`
--

LOCK TABLES `webchess_messages` WRITE;
/*!40000 ALTER TABLE `webchess_messages` DISABLE KEYS */;
INSERT INTO `webchess_messages` VALUES (143,278,'undo','denied','white'),(158,288,'draw','denied','black'),(185,325,'undo','denied','white'),(205,254,'draw','approved','black'),(220,312,'undo','denied','black'),(247,430,'undo','approved','white'),(249,173,'draw','request','white'),(250,377,'draw','approved','black'),(251,395,'draw','denied','black'),(266,469,'draw','approved','black'),(269,494,'undo','request','black'),(291,511,'draw','approved','white'),(298,198,'draw','denied','white'),(299,198,'undo','approved','white'),(305,552,'draw','approved','white'),(313,571,'draw','approved','white'),(352,696,'draw','approved','black'),(362,731,'draw','approved','white'),(373,693,'draw','request','white'),(387,763,'draw','request','white'),(398,720,'draw','approved','white'),(399,767,'undo','denied','black'),(417,804,'draw','request','white'),(446,861,'draw','approved','black'),(447,684,'draw','approved','black'),(448,850,'undo','request','black'),(467,1027,'draw','approved','white'),(469,1020,'draw','approved','white'),(472,733,'draw','request','white'),(498,963,'draw','approved','white'),(551,1376,'draw','approved','black'),(571,1299,'draw','approved','black'),(577,1475,'draw','approved','white'),(590,1397,'undo','approved','black'),(604,1451,'','','white'),(609,1609,'draw','approved','black'),(610,1609,'draw','approved','black'),(626,1740,'','','white'),(633,1482,'undo','request','white'),(637,1623,'draw','approved','white'),(639,1823,'draw','approved','black'),(640,1379,'draw','approved','white'),(644,1568,'draw','approved','black'),(660,1889,'undo','request','white'),(661,1889,'draw','approved','black'),(662,1889,'draw','approved','black'),(663,1918,'draw','approved','white'),(665,1993,'draw','request','white'),(679,1962,'draw','approved','white'),(680,1508,'draw','approved','white'),(683,1883,'draw','approved','white'),(685,1845,'draw','approved','black'),(694,1954,'draw','approved','white'),(696,2045,'draw','approved','white'),(699,1723,'draw','approved','white'),(704,1715,'draw','approved','white'),(706,2034,'draw','approved','white'),(753,2117,'draw','approved','black'),(755,2064,'draw','approved','black'),(757,1804,'draw','approved','white'),(761,2089,'undo','request','black'),(762,1291,'draw','approved','white'),(769,2088,'draw','approved','black'),(776,2132,'draw','approved','black'),(778,2126,'draw','approved','white'),(815,2295,'draw','approved','white'),(816,2295,'draw','approved','white'),(823,2096,'draw','approved','white'),(826,2243,'draw','approved','black'),(829,2179,'draw','approved','white'),(833,2280,'draw','approved','white'),(842,2408,'draw','approved','white'),(843,2349,'draw','approved','black'),(844,2288,'draw','approved','black'),(846,2163,'draw','approved','black'),(850,2203,'draw','approved','white'),(854,2468,'undo','denied','black'),(859,2323,'draw','approved','white'),(860,2323,'draw','approved','white'),(865,2430,'draw','approved','black'),(871,2570,'draw','approved','black'),(873,1952,'draw','approved','white'),(882,2414,'draw','approved','white'),(883,2439,'draw','approved','black'),(884,2416,'draw','approved','black'),(895,2473,'draw','approved','black'),(900,2679,'draw','approved','black'),(916,2630,'draw','approved','white'),(925,2265,'draw','approved','black'),(927,2265,'draw','approved','black'),(932,2601,'draw','approved','white'),(936,2691,'draw','approved','black'),(937,2691,'draw','approved','black'),(938,2565,'draw','approved','black'),(940,2644,'draw','approved','black'),(942,2496,'draw','approved','black'),(943,2643,'draw','approved','white'),(945,2634,'draw','approved','white'),(949,2264,'draw','request','white'),(950,2264,'draw','request','white'),(951,2735,'draw','approved','black'),(952,2860,'undo','request','white'),(956,2656,'undo','approved','black'),(960,2754,'draw','approved','black'),(961,2854,'draw','approved','white'),(969,2910,'draw','approved','white'),(971,2357,'draw','approved','black'),(973,2396,'draw','approved','white'),(975,2249,'undo','request','black'),(977,2604,'draw','approved','black'),(980,2987,'draw','approved','black'),(981,2703,'draw','approved','black'),(982,2949,'draw','approved','black'),(983,2919,'draw','approved','black'),(984,2919,'draw','approved','black'),(985,2919,'draw','approved','black'),(988,2936,'draw','approved','white'),(993,2749,'draw','approved','white'),(994,2901,'draw','approved','white'),(1002,2900,'draw','approved','black'),(1003,3101,'draw','approved','white'),(1007,3061,'draw','approved','white'),(1008,2672,'draw','approved','white'),(1010,2996,'draw','approved','white'),(1012,2873,'draw','approved','white'),(1028,3094,'under Review','request','black'),(1031,2870,'draw','approved','white'),(1032,2998,'draw','request','black'),(1033,3002,'undo','request','black'),(1041,2920,'draw','approved','black'),(1045,2541,'draw','approved','white'),(1054,3163,'draw','approved','black'),(1059,3150,'draw','approved','white'),(1060,2937,'draw','approved','white'),(1061,3305,'undo','denied','black'),(1063,3260,'draw','approved','white'),(1070,3251,'draw','approved','black'),(1071,2828,'draw','approved','white'),(1072,3175,'draw','approved','white'),(1073,3257,'draw','approved','white'),(1077,3255,'draw','approved','white'),(1078,3129,'draw','approved','white'),(1080,3312,'draw','approved','white'),(1082,3310,'draw','approved','white'),(1087,3437,'draw','approved','white'),(1096,3502,'draw','approved','black'),(1106,3558,'draw','approved','black'),(1107,3572,'draw','approved','black'),(1111,3568,'draw','approved','black'),(1112,3685,'draw','approved','white'),(1113,3588,'draw','approved','white'),(1114,3598,'draw','approved','white'),(1115,3658,'draw','approved','black'),(1118,3712,'draw','approved','black'),(1119,3670,'draw','approved','black'),(1124,3672,'draw','approved','black'),(1125,3672,'draw','approved','black'),(1130,3739,'draw','approved','black'),(1131,3415,'draw','approved','white'),(1132,3749,'draw','approved','black'),(1134,3855,'draw','approved','black'),(1140,3875,'draw','approved','black'),(1146,3740,'draw','approved','black'),(1152,3837,'draw','denied','white'),(1158,3788,'draw','approved','white'),(1159,3687,'draw','approved','black'),(1160,4026,'draw','approved','black'),(1171,3997,'draw','approved','white'),(1172,3997,'draw','approved','white'),(1174,4053,'draw','approved','white'),(1175,3870,'draw','approved','black'),(1180,3579,'draw','approved','black'),(1186,3551,'draw','approved','black'),(1189,3878,'draw','approved','black'),(1190,3812,'draw','approved','white'),(1191,3881,'draw','approved','white'),(1195,3852,'draw','approved','white'),(1197,4208,'draw','approved','black'),(1198,4223,'draw','approved','black'),(1201,4235,'draw','approved','black'),(1202,3778,'draw','approved','white'),(1203,3854,'draw','approved','black'),(1205,3889,'draw','approved','white'),(1216,4198,'draw','approved','white'),(1222,4326,'draw','approved','black'),(1223,4326,'draw','approved','black'),(1224,4255,'draw','approved','white'),(1225,4361,'draw','approved','white'),(1231,4191,'draw','approved','white'),(1233,4252,'draw','approved','white'),(1236,4341,'draw','approved','black'),(1237,4376,'draw','approved','black'),(1240,4275,'draw','approved','white'),(1242,4374,'draw','approved','white'),(1244,4357,'draw','approved','black'),(1247,3887,'draw','approved','white'),(1250,4185,'draw','approved','black'),(1263,4267,'draw','approved','black'),(1265,4209,'draw','approved','black'),(1266,4268,'draw','approved','black'),(1272,4286,'draw','approved','black'),(1273,4285,'draw','approved','black'),(1274,4339,'draw','approved','black'),(1278,4288,'draw','approved','white'),(1279,4197,'draw','approved','white'),(1280,4242,'draw','approved','white'),(1281,4407,'draw','approved','white'),(1299,4292,'draw','approved','white'),(1304,4397,'draw','approved','white'),(1308,4358,'draw','approved','white'),(1309,4358,'draw','approved','white'),(1310,4512,'draw','approved','white'),(1311,4512,'draw','approved','white'),(1317,4344,'draw','approved','black'),(1318,4344,'draw','approved','black'),(1333,4526,'draw','approved','black'),(1335,4554,'draw','approved','white'),(1339,4466,'draw','approved','white'),(1341,4562,'draw','approved','black'),(1349,4542,'draw','approved','white'),(1351,4621,'draw','approved','white'),(1352,4664,'draw','approved','white'),(1357,4695,'draw','approved','white'),(1361,4706,'draw','approved','black'),(1362,4607,'draw','approved','black'),(1373,4599,'draw','approved','white'),(1377,4652,'draw','approved','white'),(1379,4609,'draw','request','black'),(1381,4722,'draw','request','black');
/*!40000 ALTER TABLE `webchess_messages` ENABLE KEYS */;
UNLOCK TABLES;

/*!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 */;