<commit_before>SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `Halite`
--

use Halite;

--
-- Table structure for table `Game`
--

CREATE TABLE `Game` (
  `gameID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `replayName` varchar(64) NOT NULL,
  PRIMARY KEY (`gameID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Table structure for table `GameUser`
--

CREATE TABLE `GameUser` (
  `gameID` mediumint(8) unsigned NOT NULL,
  `userID` mediumint(8) unsigned NOT NULL,
  `rank` smallint(5) unsigned NOT NULL,
  `score` float unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `User`
--

CREATE TABLE `User` (
  `userID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(30) NOT NULL,
  `language` varchar(16) DEFAULT NULL,
  `status` smallint(5) unsigned NOT NULL,
  `mu` float unsigned NOT NULL,
  `sigma` float unsigned NOT NULL,
  PRIMARY KEY (`userID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Table structure for table `Worker`
--

CREATE TABLE `Worker` (
  `apiKey` smallint(5) unsigned NOT NULL,
  `ipAddress` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

<commit_msg>Add playerIndex to database<commit_after>SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `Halite`
--

use Halite;

--
-- Table structure for table `Game`
--

CREATE TABLE `Game` (
  `gameID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `replayName` varchar(64) NOT NULL,
  PRIMARY KEY (`gameID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Table structure for table `GameUser`
--

CREATE TABLE `GameUser` (
  `gameID` mediumint(8) unsigned NOT NULL,
  `userID` mediumint(8) unsigned NOT NULL,
  `rank` smallint(5) unsigned NOT NULL,
  `score` float unsigned NOT NULL,
  `playerIndex` smallint(5) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `User`
--

CREATE TABLE `User` (
  `userID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(30) NOT NULL,
  `language` varchar(16) DEFAULT NULL,
  `status` smallint(5) unsigned NOT NULL,
  `mu` float unsigned NOT NULL,
  `sigma` float unsigned NOT NULL,
  PRIMARY KEY (`userID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Table structure for table `Worker`
--

CREATE TABLE `Worker` (
  `apiKey` smallint(5) unsigned NOT NULL,
  `ipAddress` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

{'fraction_non_alphanumeric': 0.12303459119496855, 'fraction_numerical': 0.020047169811320754, 'mean_word_length': 4.3691983122362865, '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': '3274959', 'n_tokens_mistral': 947, 'n_tokens_neox': 902, 'n_words': 268}