<commit_before>-- MySQL Script generated by MySQL Workbench
-- 01/19/16 14:00:02
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema game
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema game
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `game` DEFAULT CHARACTER SET utf8 ;
USE `game` ;

-- -----------------------------------------------------
-- Table `game`.`weapons`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `game`.`weapons` (
  `weapon_id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `damage_minimal` INT NOT NULL,
  `damage_maximal` INT NOT NULL,
  `str_b` INT NULL,
  `agi_b` INT NULL,
  `int_b` INT NULL,
  PRIMARY KEY (`weapon_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `game`.`armor_types`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `game`.`armor_types` (
  `armor_type_id` INT NOT NULL,
  `armor_type_name` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`armor_type_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `game`.`armor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `game`.`armor` (
  `armor_id` INT NOT NULL AUTO_INCREMENT,
  `armor_type` INT NULL,
  `name` VARCHAR(45) NULL,
  `str_b` INT NULL,
  `int_b` INT NULL,
  `agi_b` INT NULL,
  `armor_amount` INT NULL,
  PRIMARY KEY (`armor_id`),
  INDEX `armor_idx` (`armor_type` ASC),
  CONSTRAINT `armor`
    FOREIGN KEY (`armor_type`)
    REFERENCES `game`.`armor_types` (`armor_type_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

<commit_msg>init sql update ( pure sql need to be converted to H2 sql)<commit_after>-- MySQL Script generated by MySQL Workbench
-- 01/19/16 17:38:37
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema game
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema game
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `game` DEFAULT CHARACTER SET utf8 ;
USE `game` ;

-- -----------------------------------------------------
-- Table `game`.`weapon_types`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `game`.`weapon_types` (
  `weapon_type_id` INT NOT NULL AUTO_INCREMENT,
  `weapon_type_name` VARCHAR(45) NULL,
  PRIMARY KEY (`weapon_type_id`));


-- -----------------------------------------------------
-- Table `game`.`weapon`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `game`.`weapon` (
  `weapon_id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `damage_minimal` INT NOT NULL,
  `damage_maximal` INT NOT NULL,
  `str_b` INT NULL,
  `agi_b` INT NULL,
  `int_b` INT NULL,
  `weapon_type` INT NULL,
  `weaponcol` VARCHAR(45) NULL,
  PRIMARY KEY (`weapon_id`),
  INDEX `weapontypedict_idx` (`weapon_type` ASC),
  CONSTRAINT `weapontypedict`
  FOREIGN KEY (`weapon_type`)
  REFERENCES `game`.`weapon_types` (`weapon_type_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);


-- -----------------------------------------------------
-- Table `game`.`armor_types`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `game`.`armor_types` (
  `armor_type_id` INT NOT NULL,
  `armor_type_name` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`armor_type_id`));


-- -----------------------------------------------------
-- Table `game`.`armor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `game`.`armor` (
  `armor_id` INT NOT NULL AUTO_INCREMENT,
  `armor_type` INT NULL,
  `name` VARCHAR(45) NULL,
  `str_b` INT NULL,
  `int_b` INT NULL,
  `agi_b` INT NULL,
  `armor_amount` INT NULL,
  PRIMARY KEY (`armor_id`),
  INDEX `armor_idx` (`armor_type` ASC),
  CONSTRAINT `armor`
  FOREIGN KEY (`armor_type`)
  REFERENCES `game`.`armor_types` (`armor_type_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);


{'fraction_non_alphanumeric': 0.3486646884272997, 'fraction_numerical': 0.010809665112335736, 'mean_word_length': 1.5101063829787233, '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': '2747225', 'n_tokens_mistral': 1537, 'n_tokens_neox': 1426, 'n_words': 368}