<commit_before>-- create database
CREATE DATABASE IF NOT EXISTS `rss2slack` CHARACTER SET utf8;
USE `rss2slack`;

-- create tables
CREATE TABLE IF NOT EXISTS `FEED`(
  `FEED_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'FEED_ID',
  `FEED_NAME` VARCHAR(255) NOT NULL UNIQUE COMMENT 'FEED_NAME',
  `URL` VARCHAR(255) NOT NULL UNIQUE COMMENT 'URL',
  `CREATED_AT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'CREATED_AT',
  `UPDATED_AT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'UPDATED_AT',
  PRIMARY KEY (`FEED_ID`)
) COMMENT = 'フィード';

CREATE TABLE IF NOT EXISTS `ARTICLE`(
  `ARTICLE_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ARTICLE_ID',
  `TITLE` VARCHAR(255) NULL COMMENT 'TITLE',
  `DESCRIPTION` VARCHAR(255) NULL COMMENT 'DESCRIPTION',
  `BODY` VARCHAR(3072) NULL COMMENT 'BODY',
  `URL` VARCHAR(255) NULL COMMENT 'URL',
  `CREATED_AT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'CREATED_AT',
  `UPDATED_AT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'UPDATED_AT',
  PRIMARY KEY (`ARTICLE_ID`)
) COMMENT = '記事';

<commit_msg>fix create table sql<commit_after>-- create database
CREATE DATABASE IF NOT EXISTS `rss2slack` CHARACTER SET utf8;
USE `rss2slack`;

-- create tables
CREATE TABLE IF NOT EXISTS `FEED`(
  `FEED_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'FEED_ID',
  `FEED_NAME` VARCHAR(255) NOT NULL COMMENT 'FEED_NAME',
  `URL` VARCHAR(255) NOT NULL UNIQUE COMMENT 'URL',
  `CREATED_AT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'CREATED_AT',
  `UPDATED_AT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'UPDATED_AT',
  PRIMARY KEY (`FEED_ID`)
) COMMENT = 'フィード';

CREATE TABLE IF NOT EXISTS `ARTICLE`(
  `ARTICLE_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ARTICLE_ID',
  `TITLE` VARCHAR(255) NULL COMMENT 'TITLE',
  `DESCRIPTION` VARCHAR(255) NULL COMMENT 'DESCRIPTION',
  `BODY` VARCHAR(3072) NULL COMMENT 'BODY',
  `URL` VARCHAR(255) NULL COMMENT 'URL',
  `CREATED_AT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'CREATED_AT',
  `UPDATED_AT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'UPDATED_AT',
  PRIMARY KEY (`ARTICLE_ID`)
) COMMENT = '記事';


{'fraction_non_alphanumeric': 0.0956140350877193, 'fraction_numerical': 0.01929824561403509, 'mean_word_length': 5.808955223880597, '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': '1732354', 'n_tokens_mistral': 925, 'n_tokens_neox': 835, 'n_words': 254}