<commit_before>-- This is a partical database structure dump used by SteamDB
-- This structure is not final and can change at any time

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `Apps` (
  `AppID` int(7) NOT NULL,
  `AppType` smallint(2) NOT NULL DEFAULT '0',
  `Name` varchar(150) CHARACTER SET utf8 NOT NULL DEFAULT 'SteamDB Unknown App',
  `StoreName` varchar(150) CHARACTER SET utf8 NOT NULL,
  `LastKnownName` varchar(150) CHARACTER SET utf8 NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `LastDepotUpdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  UNIQUE KEY `AppID` (`AppID`),
  KEY `LastUpdated` (`LastUpdated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `AppsHistory` (
  `ID` int(9) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(9) NOT NULL,
  `AppID` int(7) NOT NULL,
  `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Action` enum('created_app','deleted_app','created_key','removed_key','modified_key','created_info','modified_info','removed_info','modified_price','added_to_sub','removed_from_sub') COLLATE utf8_bin NOT NULL,
  `Key` smallint(4) NOT NULL DEFAULT '0',
  `OldValue` mediumtext COLLATE utf8_bin NOT NULL,
  `NewValue` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `AppID` (`AppID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `AppsInfo` (
  `AppID` int(7) NOT NULL,
  `Key` smallint(4) NOT NULL,
  `Value` mediumtext COLLATE utf8_bin NOT NULL,
  UNIQUE KEY `AppID` (`AppID`,`Key`),
  KEY `Key` (`Key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `AppsTypes` (
  `AppType` smallint(2) NOT NULL AUTO_INCREMENT,
  `Name` varbinary(15) NOT NULL,
  `DisplayName` varchar(30) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`AppType`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=16 ;

INSERT INTO `AppsTypes` (`AppType`, `Name`, `DisplayName`) VALUES
(0, 'unknown', 'Unknown'),
(1, 'game', 'Game'),
(2, 'application', 'Application'),
(3, 'demo', 'Demo'),
(4, 'dlc', 'DLC'),
(5, 'tool', 'Tool'),
(6, 'depotonly', 'Depot'),
(7, 'guide', 'Guide'),
(8, 'media', 'Media'),
(9, 'config', 'Config'),
(10, 'driver', 'Driver'),
(11, 'film', 'Film'),
(12, 'tvseries', 'TV Series'),
(13, 'video', 'Video'),
(14, 'plugin', 'Plugin'),
(15, 'music', 'Music');

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `Changelists` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(11) NOT NULL,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `id` (`ChangeID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ChangelistsApps` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(11) NOT NULL,
  `AppID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ChangeID` (`ChangeID`,`AppID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ChangelistsSubs` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(11) NOT NULL,
  `SubID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ChangeID` (`ChangeID`,`SubID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `Depots` (
  `DepotID` int(7) NOT NULL,
  `Name` varchar(150) CHARACTER SET utf8 NOT NULL DEFAULT 'SteamDB Unknown Depot',
  `BuildID` int(7) NOT NULL DEFAULT '0',
  `ManifestID` bigint(20) NOT NULL,
  `Files` mediumtext COLLATE utf8_bin NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `DepotID` (`DepotID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `DepotsHistory` (
  `ID` int(9) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(9) NOT NULL,
  `DepotID` int(7) NOT NULL,
  `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Action` enum('added','removed','modified','manifest_change') COLLATE utf8_bin NOT NULL,
  `File` varchar(300) COLLATE utf8_bin NOT NULL,
  `OldValue` bigint(20) NOT NULL,
  `NewValue` bigint(20) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `DepotID` (`DepotID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `GC` (
  `AppID` int(7) NOT NULL,
  `Status` varchar(80) COLLATE utf8_bin NOT NULL,
  UNIQUE KEY `AppID` (`AppID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ImportantApps` (
  `AppID` int(7) NOT NULL,
  `Announce` tinyint(1) NOT NULL DEFAULT '0',
  `CurrentPlayers` int(7) NOT NULL DEFAULT '0',
  `MaxPlayers` int(7) NOT NULL DEFAULT '0',
  `MaxPlayersDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  UNIQUE KEY `AppID` (`AppID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ImportantSubs` (
  `SubID` int(7) NOT NULL,
  UNIQUE KEY `AppID` (`SubID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `KeyNames` (<commit_msg>Update schema<commit_after>-- This is a partical database structure dump used by SteamDB
-- This structure is not final and can change at any time

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `Apps` (
  `AppID` int(7) NOT NULL,
  `AppType` smallint(2) NOT NULL DEFAULT '0',
  `Name` varchar(150) CHARACTER SET utf8 NOT NULL DEFAULT 'SteamDB Unknown App',
  `StoreName` varchar(150) CHARACTER SET utf8 NOT NULL,
  `LastKnownName` varchar(150) CHARACTER SET utf8 NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `LastDepotUpdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  UNIQUE KEY `AppID` (`AppID`),
  KEY `LastUpdated` (`LastUpdated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `AppsHistory` (
  `ID` int(9) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(9) NOT NULL,
  `AppID` int(7) NOT NULL,
  `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Action` enum('created_app','deleted_app','created_key','removed_key','modified_key','created_info','modified_info','removed_info','modified_price','added_to_sub','removed_from_sub') COLLATE utf8_bin NOT NULL,
  `Key` smallint(4) NOT NULL DEFAULT '0',
  `OldValue` mediumtext COLLATE utf8_bin NOT NULL,
  `NewValue` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `AppID` (`AppID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `AppsInfo` (
  `AppID` int(7) NOT NULL,
  `Key` smallint(4) NOT NULL,
  `Value` mediumtext COLLATE utf8_bin NOT NULL,
  UNIQUE KEY `AppID` (`AppID`,`Key`),
  KEY `Key` (`Key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `AppsTypes` (
  `AppType` smallint(2) NOT NULL AUTO_INCREMENT,
  `Name` varbinary(15) NOT NULL,
  `DisplayName` varchar(30) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`AppType`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=16 ;

INSERT INTO `AppsTypes` (`AppType`, `Name`, `DisplayName`) VALUES
(0, 'unknown', 'Unknown'),
(1, 'game', 'Game'),
(2, 'application', 'Application'),
(3, 'demo', 'Demo'),
(4, 'dlc', 'DLC'),
(5, 'tool', 'Tool'),
(6, 'depotonly', 'Depot'),
(7, 'guide', 'Guide'),
(8, 'media', 'Media'),
(9, 'config', 'Config'),
(10, 'driver', 'Driver'),
(11, 'film', 'Film'),
(12, 'tvseries', 'TV Series'),
(13, 'video', 'Video'),
(14, 'plugin', 'Plugin'),
(15, 'music', 'Music');

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `Changelists` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(11) NOT NULL,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `id` (`ChangeID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ChangelistsApps` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(11) NOT NULL,
  `AppID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ChangeID` (`ChangeID`,`AppID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ChangelistsSubs` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(11) NOT NULL,
  `SubID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ChangeID` (`ChangeID`,`SubID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `Depots` (
  `DepotID` int(7) NOT NULL,
  `Name` varchar(150) CHARACTER SET utf8 NOT NULL DEFAULT 'SteamDB Unknown Depot',
  `BuildID` int(7) NOT NULL DEFAULT '0',
  `ManifestID` bigint(20) NOT NULL,
  `Files` mediumtext COLLATE utf8_bin NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `DepotID` (`DepotID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `DepotsHistory` (
  `ID` int(9) NOT NULL AUTO_INCREMENT,
  `ChangeID` int(9) NOT NULL,
  `DepotID` int(7) NOT NULL,
  `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Action` enum('added','removed','modified','manifest_change') COLLATE utf8_bin NOT NULL,
  `File` varchar(300) COLLATE utf8_bin NOT NULL,
  `OldValue` bigint(20) NOT NULL,
  `NewValue` bigint(20) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `DepotID` (`DepotID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `GC` (
  `AppID` int(7) NOT NULL,
  `Status` varchar(80) COLLATE utf8_bin NOT NULL,
  UNIQUE KEY `AppID` (`AppID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ImportantApps` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `AppID` int(7) NOT NULL,
  `Channel` varchar(50) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `AppID` (`AppID`,`Channel`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ImportantSubs` (
  `SubID` int(7) NOT NULL,
  UNIQUE KEY `AppID` (`SubID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `KeyNames` (
{'fraction_non_alphanumeric': 0.2505602482330633, 'fraction_numerical': 0.027495259438027927, 'mean_word_length': 2.7380798969072164, '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': '7265561', 'n_tokens_mistral': 4198, 'n_tokens_neox': 3925, 'n_words': 1113}