<commit_before>/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50621
Source Host           : localhost:3306
Source Database       : wol

Target Server Type    : MYSQL
Target Server Version : 50621
File Encoding         : 65001

Date: 2014-12-28 21:42:18
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `wol_games`
-- ----------------------------
DROP TABLE IF EXISTS `wol_games`;
CREATE TABLE `wol_games` (
  `gid` int(11) NOT NULL AUTO_INCREMENT,
  `lid` int(11) NOT NULL,
  `mid` int(11) NOT NULL COMMENT 'Map Id',
  `wol_gid` int(11) NOT NULL COMMENT 'WOL (external) Game Id',
  `duration` int(11) NOT NULL,
  `afps` int(1) NOT NULL DEFAULT '60' COMMENT 'Average FPS',
  `crates` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Crates Flag',
  `oosy` int(1) NOT NULL DEFAULT '0' COMMENT 'Out of Sync Flag',
  `bases` int(1) NOT NULL DEFAULT '1' COMMENT 'Bases ON/OFF',
  `credits` int(11) NOT NULL DEFAULT '10000' COMMENT 'Starting Credits',
  `units` int(1) NOT NULL DEFAULT '1' COMMENT 'Starting Unit Count',
  `tech` int(1) NOT NULL DEFAULT '10' COMMENT 'Tech Level',
  `mtime` int(11) NOT NULL COMMENT 'Modified time',
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wol_games
-- ----------------------------

-- ----------------------------
-- Table structure for `wol_games_raw`
-- ----------------------------
DROP TABLE IF EXISTS `wol_games_raw`;
CREATE TABLE `wol_games_raw` (
  `hash` varchar(100) NOT NULL DEFAULT '' COMMENT 'sha1 hash of game packet',
  `packet` text NOT NULL COMMENT 'raw packet as recieved',
  `gid` int(11) DEFAULT NULL,
  `lid` int(11) NOT NULL,
  `ctime` int(200) NOT NULL COMMENT 'Time packet was created',
  PRIMARY KEY (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of wol_games_raw
-- ----------------------------

-- ----------------------------
-- Table structure for `wol_games_stats`
-- ----------------------------
DROP TABLE IF EXISTS `wol_games_stats`;
CREATE TABLE `wol_games_stats` (
  `gid` int(11) NOT NULL DEFAULT '0' COMMENT 'Game Id',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT 'Player Id',
  `cmp` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Result',
  `col` tinyint(11) NOT NULL DEFAULT '0' COMMENT 'Player color',
  `sid` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Player country',
  `pc` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Player points change',
  `cid` int(11) NOT NULL DEFAULT '0' COMMENT 'Clan Id',
  `hrv` int(11) NOT NULL DEFAULT '0' COMMENT 'Tiberium Harvested',
  `crd` int(11) NOT NULL DEFAULT '0' COMMENT 'Player credits',
  `inb` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Infantry Built',
  `unb` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Units Built',
  `plb` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Planes Built',
  `blb` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Buildings Built',
  `vsb` smallint(11) DEFAULT NULL COMMENT 'Vessles Built',
  `inl` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Infantry Left',
  `unl` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Units Left',
  `pll` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Planes Left',
  `bll` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Buildings Left',
  `vsl` smallint(11) DEFAULT NULL COMMENT 'Vessles Left',
  `ink` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Infantry Killed',
  `unk` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Units Killed',
  `plk` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Planes Killed',
  `blk` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Buildings Killed',
  `vsk` smallint(11) DEFAULT NULL COMMENT 'Vessles Killed',
  `blc` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Buildings Captured',
  `spc` smallint(11) DEFAULT NULL COMMENT '??',
  `ded` smallint(11) DEFAULT NULL COMMENT '??',
  `spa` smallint(11) DEFAULT NULL COMMENT '??',
  `rsg` smallint(11) DEFAULT NULL COMMENT '??',
  `aly` smallint(11) DEFAULT NULL COMMENT '??',
  `tid` smallint(11) DEFAULT NULL COMMENT '??',
  `ipa` int(11) NOT NULL DEFAULT '0' COMMENT 'Short IP Address',
  KEY `pid` (`pid`),
  KEY `cid` (`cid`),
  KEY `gid` (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wol_games_stats
-- ----------------------------
<commit_msg>adding missing lcn column and increasing ipa field<commit_after>/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50621
Source Host           : localhost:3306
Source Database       : wol

Target Server Type    : MYSQL
Target Server Version : 50621
File Encoding         : 65001

Date: 2014-12-28 23:38:31
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `wol_games`
-- ----------------------------
DROP TABLE IF EXISTS `wol_games`;
CREATE TABLE `wol_games` (
  `gid` int(11) NOT NULL AUTO_INCREMENT,
  `lid` int(11) NOT NULL,
  `mid` int(11) NOT NULL COMMENT 'Map Id',
  `wol_gid` int(11) NOT NULL COMMENT 'WOL (external) Game Id',
  `duration` int(11) NOT NULL,
  `afps` int(1) NOT NULL DEFAULT '60' COMMENT 'Average FPS',
  `crates` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Crates Flag',
  `oosy` int(1) NOT NULL DEFAULT '0' COMMENT 'Out of Sync Flag',
  `bases` int(1) NOT NULL DEFAULT '1' COMMENT 'Bases ON/OFF',
  `credits` int(11) NOT NULL DEFAULT '10000' COMMENT 'Starting Credits',
  `units` int(1) NOT NULL DEFAULT '1' COMMENT 'Starting Unit Count',
  `tech` int(1) NOT NULL DEFAULT '10' COMMENT 'Tech Level',
  `mtime` int(11) NOT NULL COMMENT 'Modified time',
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wol_games
-- ----------------------------

-- ----------------------------
-- Table structure for `wol_games_raw`
-- ----------------------------
DROP TABLE IF EXISTS `wol_games_raw`;
CREATE TABLE `wol_games_raw` (
  `hash` varchar(100) NOT NULL DEFAULT '' COMMENT 'sha1 hash of game packet',
  `packet` text NOT NULL COMMENT 'raw packet as recieved',
  `gid` int(11) DEFAULT NULL,
  `lid` int(11) NOT NULL,
  `ctime` int(200) NOT NULL COMMENT 'Time packet was created',
  PRIMARY KEY (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of wol_games_raw
-- ----------------------------

-- ----------------------------
-- Table structure for `wol_games_stats`
-- ----------------------------
DROP TABLE IF EXISTS `wol_games_stats`;
CREATE TABLE `wol_games_stats` (
  `gid` int(11) NOT NULL DEFAULT '0' COMMENT 'Game Id',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT 'Player Id',
  `cmp` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Result',
  `col` tinyint(11) NOT NULL DEFAULT '0' COMMENT 'Player color',
  `lcn` tinyint(11) DEFAULT NULL,
  `sid` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Player country',
  `pc` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Player points change',
  `cid` int(11) NOT NULL DEFAULT '0' COMMENT 'Clan Id',
  `hrv` int(11) NOT NULL DEFAULT '0' COMMENT 'Tiberium Harvested',
  `crd` int(11) NOT NULL DEFAULT '0' COMMENT 'Player credits',
  `inb` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Infantry Built',
  `unb` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Units Built',
  `plb` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Planes Built',
  `blb` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Buildings Built',
  `vsb` smallint(11) DEFAULT NULL COMMENT 'Vessles Built',
  `inl` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Infantry Left',
  `unl` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Units Left',
  `pll` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Planes Left',
  `bll` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Buildings Left',
  `vsl` smallint(11) DEFAULT NULL COMMENT 'Vessles Left',
  `ink` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Infantry Killed',
  `unk` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Units Killed',
  `plk` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Planes Killed',
  `blk` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Buildings Killed',
  `vsk` smallint(11) DEFAULT NULL COMMENT 'Vessles Killed',
  `blc` smallint(11) NOT NULL DEFAULT '0' COMMENT 'Buildings Captured',
  `spc` smallint(11) DEFAULT NULL COMMENT '??',
  `ded` smallint(11) DEFAULT NULL COMMENT '??',
  `spa` smallint(11) DEFAULT NULL COMMENT '??',
  `rsg` smallint(11) DEFAULT NULL COMMENT '??',
  `aly` smallint(11) DEFAULT NULL COMMENT '??',
  `tid` smallint(11) DEFAULT NULL COMMENT '??',
  `ipa` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Short IP Address',
  KEY `pid` (`pid`),
  KEY `cid` (`cid`),
  KEY `gid` (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wol_games_stats
-- ----------------------------

{'fraction_non_alphanumeric': 0.202334180725676, 'fraction_numerical': 0.03928819043217009, 'mean_word_length': 2.970183486238532, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4463781', 'n_tokens_mistral': 3138, 'n_tokens_neox': 2902, 'n_words': 1013}