<commit_before>CREATE TABLE `io_threads` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` varchar(20) NOT NULL,
  `owner_id` int(5) NOT NULL,
  `instance` varchar(128) NOT NULL,
  `category` varchar(128) NOT NULL,
  `title` varchar(128) NOT NULL,
  `content` text NOT NULL,
  `likes` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

-- In case you are using an old blog table style
ALTER TABLE io_threads ADD instance varchar(128) NOT NULL;
ALTER TABLE io_threads ADD category varchar(128) NOT NULL;

CREATE TABLE `io_messages` (
  `msg_id` int(5) NOT NULL AUTO_INCREMENT,
  `date` varchar(20) NOT NULL,
  `parent_id` int(5) NOT NULL,
  `sender_id` int(5) NOT NULL,
  `device` varchar(25) NOT NULL,
  `link` varchar(50) NOT NULL,
  `body` text NOT NULL,
  `likes` int(11) NOT NULL,
  `reply` int(11) NOT NULL,
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

CREATE TABLE `io_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link` varchar(50) NOT NULL,
  `user_id` int(5) NOT NULL,
  `scope` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
<commit_msg>'upgrade'<commit_after>CREATE TABLE `io_threads` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` varchar(20) NOT NULL,
  `owner_id` int(5) NOT NULL,
  `instance` varchar(128) NOT NULL,
  `category` varchar(128) NOT NULL,
  `title` varchar(128) NOT NULL,
  `content` text NOT NULL,
  `likes` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

-- In case you are using an old blog table style
ALTER TABLE io_threads ADD instance varchar(128) DEFAULT 'default';
ALTER TABLE io_threads ADD category varchar(128) DEFAULT 'uncategorized';

CREATE TABLE `io_messages` (
  `msg_id` int(5) NOT NULL AUTO_INCREMENT,
  `date` varchar(20) NOT NULL,
  `parent_id` int(5) NOT NULL,
  `sender_id` int(5) NOT NULL,
  `device` varchar(25) NOT NULL,
  `link` varchar(50) NOT NULL,
  `body` text NOT NULL,
  `likes` int(11) NOT NULL,
  `reply` int(11) NOT NULL,
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

CREATE TABLE `io_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link` varchar(50) NOT NULL,
  `user_id` int(5) NOT NULL,
  `scope` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

{'fraction_non_alphanumeric': 0.12583333333333332, 'fraction_numerical': 0.04, 'mean_word_length': 4.899262899262899, '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': '1814265', 'n_tokens_mistral': 1007, 'n_tokens_neox': 918, 'n_words': 286}