<commit_before>﻿-- Скрипт сгенерирован Devart dbForge Studio for MySQL, Версия 3.60.351.1
-- Дата: 01.11.2011 9:54:41
-- Версия сервера: 5.1.42-community
-- Версия клиента: 4.1

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */;

SET NAMES 'utf8';
--
-- Описание для базы данных cubique_test
--
CREATE DATABASE cubique_test
CHARACTER SET utf8
COLLATE utf8_general_ci;

USE cubique_test;

--
-- Описание для таблицы country
--
CREATE TABLE country(
  id BIGINT (20) UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR (80) DEFAULT NULL,
  alpha_1 CHAR (2) DEFAULT NULL,
  alpha_2 CHAR (3) DEFAULT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 4
AVG_ROW_LENGTH = 5461
CHARACTER SET utf8
COLLATE utf8_general_ci;

--
-- Описание для таблицы province
--
CREATE TABLE province(
  id BIGINT (20) UNSIGNED NOT NULL AUTO_INCREMENT,
  country_id BIGINT (20) UNSIGNED NOT NULL,
  name VARCHAR (80) DEFAULT NULL,
  code CHAR (3) DEFAULT NULL,
  PRIMARY KEY (id),
  INDEX province_i1 USING BTREE (country_id),
  CONSTRAINT province_fk1 FOREIGN KEY (country_id)
  REFERENCES country (id) ON DELETE CASCADE ON UPDATE CASCADE
)
ENGINE = INNODB
AUTO_INCREMENT = 4378
AVG_ROW_LENGTH = 210
CHARACTER SET utf8
COLLATE utf8_general_ci;

-- 
-- Вывод данных для таблицы country
-- 
/*!40000 ALTER TABLE country DISABLE KEYS */;

  INSERT INTO country VALUES (1, 'Australia', 'AU', 'AUS'),
  (2, 'Canada', 'CA', 'CAN'),
  (3, 'United States of America', 'US', 'USA');
/*!40000 ALTER TABLE country ENABLE KEYS */;

-- 
-- Вывод данных для таблицы province
-- 
/*!40000 ALTER TABLE province DISABLE KEYS */;

  INSERT INTO province VALUES (1, 1, 'Australian Capital Territory', 'ACT'),
  (2, 1, 'New South Wales', 'NSW'),
  (3, 1, 'Northern Territory', 'NT'),
  (4, 1, 'Queensland', 'QLD'),
  (5, 1, 'South Australia', 'SA'),<commit_msg>New test DB version<commit_after>﻿/*!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */;

SET NAMES 'utf8';

CREATE DATABASE cubique_test
CHARACTER SET utf8
COLLATE utf8_general_ci;

USE cubique_test;

CREATE TABLE country(
  id BIGINT (20) UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR (80) DEFAULT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 4
AVG_ROW_LENGTH = 5461
CHARACTER SET utf8
COLLATE utf8_general_ci;

CREATE TABLE province(
  id BIGINT (20) UNSIGNED NOT NULL AUTO_INCREMENT,
  country_id BIGINT (20) UNSIGNED NOT NULL,
  name VARCHAR (80) DEFAULT NULL,
  code CHAR (3) DEFAULT NULL,
  PRIMARY KEY (id),
  INDEX province_i1 USING BTREE (country_id),
  CONSTRAINT province_fk1 FOREIGN KEY (country_id)
  REFERENCES country (id) ON DELETE CASCADE ON UPDATE CASCADE
)
ENGINE = INNODB
AUTO_INCREMENT = 4378
AVG_ROW_LENGTH = 210
CHARACTER SET utf8
COLLATE utf8_general_ci;

/*!40000 ALTER TABLE country DISABLE KEYS */;

  INSERT INTO country VALUES (1, 'Australia'),
  (2, 'Canada'),
  (3, 'United States of America');
/*!40000 ALTER TABLE country ENABLE KEYS */;

/*!40000 ALTER TABLE province DISABLE KEYS */;

  INSERT INTO province VALUES (1, 1, 'Australian Capital Territory', 'ACT'),
  (2, 1, 'New South Wales', 'NSW'),
  (3, 1, 'Northern Territory', 'NT'),
  (4, 1, 'Queensland', 'QLD'),
  (5, 1, 'South Australia', 'SA'),
{'fraction_non_alphanumeric': 0.11542012927054478, 'fraction_numerical': 0.04986149584487535, 'mean_word_length': 4.354200988467875, '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': '4083903', 'n_tokens_mistral': 1376, 'n_tokens_neox': 1246, 'n_words': 396}