<commit_before>CREATE TABLE IF NOT EXISTS `cars` (
  `CA_id` int(11) NOT NULL AUTO_INCREMENT,
  `CA_name` varchar(255) NOT NULL,
  `CA_value` int(11) NOT NULL,
  `CA_theftChance` int(11) NOT NULL,
  PRIMARY KEY (`CA_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `crimes` (
  `C_id` int(11) NOT NULL AUTO_INCREMENT,
  `C_name` varchar(120) NOT NULL,
  `C_cooldown` int(11) NOT NULL,
  `C_money` int(11) NOT NULL,
  `C_maxMoney` int(11) NOT NULL,
  `C_bullets` int(11) NOT NULL DEFAULT 0,
  `C_maxBullets` int(11) NOT NULL DEFAULT 0,
  `C_exp` int(11) NOT NULL DEFAULT 1,
  `C_level` int(11) NOT NULL,
  PRIMARY KEY (`C_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gameNews` (
  `GN_id` int(11) NOT NULL AUTO_INCREMENT,
  `GN_author` int(11) NOT NULL,
  `GN_title` varchar(120) NOT NULL,
  `GN_text` text NOT NULL,
  `GN_date` int(11) NOT NULL,
  PRIMARY KEY (`GN_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gangs` (
  `G_id` int(11) NOT NULL AUTO_INCREMENT,
  `G_name` varchar(120) NOT NULL,
  `G_bank` int(11) NOT NULL DEFAULT 0,
  `G_info` text NOT NULL DEFAULT '',
  `G_desc` text NOT NULL DEFAULT '',
  `G_location` int(11) NOT NULL DEFAULT 0,
  `G_boss` int(11) NOT NULL DEFAULT 0,
  `G_underboss` int(11) NOT NULL DEFAULT 0,
  `G_level` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`G_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `garage` (
  `GA_id` int(11) NOT NULL AUTO_INCREMENT,
  `GA_uid` int(11) NOT NULL,
  `GA_car` int(11) NOT NULL,
  `GA_damage` int(11) NOT NULL,
  `GA_location` int(11) NOT NULL,
  PRIMARY KEY (`GA_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `locations` (
  `L_id` int(11) NOT NULL AUTO_INCREMENT,
  `L_name` varchar(120) NOT NULL,
  `L_cost` int(11) NOT NULL,
  `L_bullets` int(11) NOT NULL,
  `L_bulletCost` int(11) NOT NULL DEFAULT '100',
  `L_cooldown` int(11) NOT NULL,
  PRIMARY KEY (`L_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `mail` (
  `M_id` int(11) NOT NULL AUTO_INCREMENT,
  `M_time` int(11) NOT NULL,
  `M_uid` int(11) NOT NULL,
  `M_sid` int(11) NOT NULL,
  `M_subject` varchar(120) NOT NULL,
  `M_parent` int(11) NOT NULL,
  `M_text` text NOT NULL,
  `M_type` int(11) NOT NULL,
  `M_read` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`M_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `notifications` (
  `N_id` int(11) NOT NULL AUTO_INCREMENT,
  `N_uid` int(11) NOT NULL,
  `N_time` int(11) NOT NULL,
  `N_text` text NOT NULL,
  `N_read` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`N_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ranks` (
  `R_id` int(11) NOT NULL AUTO_INCREMENT,
  `R_name` varchar(100) NOT NULL,
  `R_exp` int(11) NOT NULL,
  `R_limit` int(11) NOT NULL,
  `R_cashReward` int(11) NOT NULL,
  `R_health` int(11) NOT NULL,
  `R_bulletReward` int(11) NOT NULL,
  PRIMARY KEY (`R_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `settings` (
  `S_id` int(11) NOT NULL AUTO_INCREMENT,
  `S_desc` varchar(255) NOT NULL,
  `S_value` text NOT NULL,
  PRIMARY KEY (`S_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `theft` (
  `T_id` int(11) NOT NULL AUTO_INCREMENT,
  `T_name` varchar(255) NOT NULL,
  `T_chance` int(11) NOT NULL,
  `T_maxDamage` int(11) NOT NULL,
  `T_worstCar` int(11) NOT NULL,
  `T_bestCar` int(11) NOT NULL,
  PRIMARY KEY (`T_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `users` (
  `U_id` int(11) NOT NULL AUTO_INCREMENT,
  `U_name` varchar(30) NOT NULL,
  `U_email` varchar(100) NOT NULL,
  `U_password` varchar(255) NOT NULL,
  `U_userLevel` int(1) NOT NULL,
  `U_status` int(1) NOT NULL,<commit_msg>Update schema.sql<commit_after>CREATE TABLE IF NOT EXISTS `cars` (
  `CA_id` int(11) NOT NULL AUTO_INCREMENT,
  `CA_name` varchar(255) NOT NULL,
  `CA_value` int(11) NOT NULL,
  `CA_theftChance` int(11) NOT NULL,
  PRIMARY KEY (`CA_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `crimes` (
  `C_id` int(11) NOT NULL AUTO_INCREMENT,
  `C_name` varchar(120) NOT NULL,
  `C_cooldown` int(11) NOT NULL,
  `C_money` int(11) NOT NULL,
  `C_maxMoney` int(11) NOT NULL,
  `C_bullets` int(11) NOT NULL DEFAULT 0,
  `C_maxBullets` int(11) NOT NULL DEFAULT 0,
  `C_exp` int(11) NOT NULL DEFAULT 1,
  `C_level` int(11) NOT NULL,
  PRIMARY KEY (`C_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gameNews` (
  `GN_id` int(11) NOT NULL AUTO_INCREMENT,
  `GN_author` int(11) NOT NULL,
  `GN_title` varchar(120) NOT NULL,
  `GN_text` text NOT NULL,
  `GN_date` int(11) NOT NULL,
  PRIMARY KEY (`GN_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gangs` (
  `G_id` int(11) NOT NULL AUTO_INCREMENT,
  `G_name` varchar(120) NOT NULL,
  `G_bank` int(11) NOT NULL DEFAULT 0,
  `G_info` text NOT NULL DEFAULT '',
  `G_desc` text NOT NULL DEFAULT '',
  `G_location` int(11) NOT NULL DEFAULT 0,
  `G_boss` int(11) NOT NULL DEFAULT 0,
  `G_underboss` int(11) NOT NULL DEFAULT 0,
  `G_level` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`G_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `garage` (
  `GA_id` int(11) NOT NULL AUTO_INCREMENT,
  `GA_uid` int(11) NOT NULL,
  `GA_car` int(11) NOT NULL,
  `GA_damage` int(11) NOT NULL,
  `GA_location` int(11) NOT NULL,
  PRIMARY KEY (`GA_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `locations` (
  `L_id` int(11) NOT NULL AUTO_INCREMENT,
  `L_name` varchar(120) NOT NULL,
  `L_cost` int(11) NOT NULL,
  `L_bullets` int(11) NOT NULL,
  `L_bulletCost` int(11) NOT NULL DEFAULT '100',
  `L_cooldown` int(11) NOT NULL,
  PRIMARY KEY (`L_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `mail` (
  `M_id` int(11) NOT NULL AUTO_INCREMENT,
  `M_time` int(11) NOT NULL,
  `M_uid` int(11) NOT NULL,
  `M_sid` int(11) NOT NULL,
  `M_subject` varchar(120) NOT NULL,
  `M_parent` int(11) NOT NULL,
  `M_text` text NOT NULL,
  `M_type` int(11) NOT NULL,
  `M_read` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`M_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `notifications` (
  `N_id` int(11) NOT NULL AUTO_INCREMENT,
  `N_uid` int(11) NOT NULL,
  `N_time` int(11) NOT NULL,
  `N_text` text NOT NULL,
  `N_read` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`N_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ranks` (
  `R_id` int(11) NOT NULL AUTO_INCREMENT,
  `R_name` varchar(100) NOT NULL,
  `R_exp` int(11) NOT NULL,
  `R_limit` int(11) NOT NULL,
  `R_cashReward` int(11) NOT NULL,
  `R_health` int(11) NOT NULL,
  `R_bulletReward` int(11) NOT NULL,
  PRIMARY KEY (`R_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `settings` (
  `S_id` int(11) NOT NULL AUTO_INCREMENT,
  `S_desc` varchar(255) NOT NULL,
  `S_value` text NOT NULL,
  PRIMARY KEY (`S_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `theft` (
  `T_id` int(11) NOT NULL AUTO_INCREMENT,
  `T_name` varchar(255) NOT NULL,
  `T_chance` int(11) NOT NULL,
  `T_maxDamage` int(11) NOT NULL,
  `T_worstCar` int(11) NOT NULL,
  `T_bestCar` int(11) NOT NULL,
  PRIMARY KEY (`T_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `users` (
  `U_id` int(11) NOT NULL AUTO_INCREMENT,
  `U_name` varchar(30) NOT NULL,
  `U_email` varchar(100) NOT NULL,
  `U_password` varchar(255) NOT NULL DEFAULT '',
  `U_userLevel` int(1) NOT NULL,
  `U_status` int(1) NOT NULL,
{'fraction_non_alphanumeric': 0.13402346445824706, 'fraction_numerical': 0.04665286404416839, 'mean_word_length': 4.435858964741185, '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': '1156715', 'n_tokens_mistral': 3325, 'n_tokens_neox': 3026, 'n_words': 919}