sqlsetup
# --------------------------------------------------------
#
# Table structure for table `MWGames`
#
CREATE TABLE `MWGames` (
`GameName` varchar(30) NOT NULL default '',
`GameData` varchar(200) NOT NULL default '',
PRIMARY KEY (`GameName`)
) TYPE=MyISAM COMMENT='Game Data for the MW games';
#
# Dumping data for table `MWGames`
#
INSERT INTO `MWGames` VALUES ('15: Practice', 'Game015x|43200|123789|drawt');
INSERT INTO `MWGames` VALUES ('16: Practice', 'Game016x|86400|123789|drawi');
INSERT INTO `MWGames` VALUES ('15: Risk', 'Game015|43200|813714|drawt');
INSERT INTO `MWGames` VALUES ('16: Classic', 'Game016|86400|172866|drawi');
# --------------------------------------------------------
#
# Table structure for table `MWMoves`
#
CREATE TABLE `MWMoves` (
`TeamName` varchar(20) NOT NULL default '',
`Game` varchar(30) NOT NULL default '',
`Password` tinyblob NOT NULL,
`MoveData` mediumblob NOT NULL,
`PlayerData` mediumblob NOT NULL,
PRIMARY KEY (`TeamName`)
) TYPE=MyISAM COMMENT='For MinuteWar Move Banker';
#
# Dumping data for table `MWMoves`
#
INSERT INTO `MWMoves` VALUES ('demo', '15: Practice', 0x64656d6f, 0xbb1da20a3618c47f15de48d966ff11a8b9aaaacb518f212ca64acae0b0db78b43a329f19b9cd4b8c3ccdc7a897e3b65104a0f9798246932615e9e6decb263d6aedfa5a368e7ed09429ae14966bfedf07bdc1128c04ce0d08e1abdad88641d5c54137d6b88b0ab7f635da40b9572a32d04881511e3215fb00cd42163316795368db1bceaa7bc37491aa9387b5f308d79215e508b0f6df091f89e5f1db24e7b0ab59702d33d79853a515e7e3c014b47672b9406ebd9ededb910c3d464e1b8d3d33d83bc025a5772152616f8c1a0baf445bd100075c47dfcfa5f189b3530d7e7064097025483ad06b267f8badd8a843894e86301a3bee305e4c0791ad62d1a385c14bc488a76c994a08b6382f, 0x6d6d70637c307c307c4e7c577c33377c3132327c6d6d7040636973636f2e636f6d0a);
INSERT INTO `MWMoves` VALUES ('demo16', '16: Practice', 0x64656d6f3136, '', '');