<commit_before>CREATE DATABASE `lseed` ;

CREATE USER 'lseed'@'localhost' IDENTIFIED BY 'GCp:rtAaN8nwTFMP';

REVOKE ALL PRIVILEGES ON * . * FROM 'lseed'@'localhost';
REVOKE GRANT OPTION ON * . * FROM 'lseed'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE ON * . *
TO 'lseed'@'localhost'
WITH MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0

CREATE TABLE `User` (
	`ID` INT( 255 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`Name` VARCHAR( 255 ) NOT NULL ,
	`Password` VARCHAR( 255 ) NOT NULL ,
	`IsAdmin` BOOL NOT NULL ,
	INDEX ( `Name` )
) ENGINE = MYISAM ;

CREATE TABLE `plant` (
	`ID` INT( 255 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`UserID` INT( 255 ) NOT NULL ,
	`Name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
	`Code` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
	INDEX ( `UserID` )
) ENGINE = MYISAM ;

<commit_msg>Update DB-Specification (season, seasonscore)<commit_after>CREATE DATABASE `lseed` ;

CREATE USER 'lseed'@'localhost' IDENTIFIED BY 'GCp:rtAaN8nwTFMP';

REVOKE ALL PRIVILEGES ON * . * FROM 'lseed'@'localhost';
REVOKE GRANT OPTION ON * . * FROM 'lseed'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE ON * . *
TO 'lseed'@'localhost'
WITH MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0

CREATE TABLE `user` (
	`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`Name` VARCHAR( 255 ) NOT NULL ,
	`Password` VARCHAR( 255 ) NOT NULL ,
	`IsAdmin` BOOL NOT NULL ,
	`NextSeed` Int NULL,
	INDEX ( `Name` )
) ENGINE = MYISAM ;

CREATE TABLE `plant` (
	`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`UserID` INT NOT NULL ,
	`Name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
	`Code` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
	INDEX ( `UserID` )
) ENGINE = MYISAM ;

CREATE TABLE `season` (
	`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`IsRunning` BOOL NOT NULL
) ENGINE = MYISAM ;

CREATE TABLE `seasonscore` (
	`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`UserID` INT NOT NULL ,
	`SeasonID` INT NOT NULL ,
	`Score` DOUBLE NOT NULL, 
	UNIQUE INDEX ( `UserID`, `SeasonID` )
) ENGINE = MYISAM ;
{'fraction_non_alphanumeric': 0.10987482614742698, 'fraction_numerical': 0.019935095039406582, 'mean_word_length': 4.605194805194805, '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': '775497', 'n_tokens_mistral': 920, 'n_tokens_neox': 834, 'n_words': 255}