<commit_before>CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
  `revision` int(4) NOT NULL DEFAULT '1',
  `browserscopeID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `info` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `setup` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `teardown` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `initHTML` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `visible` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `authorEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `authorURL` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -- `hits` bigint(20) NOT NULL, TODO default value
  `published` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `browserscopeID` (`browserscopeID`),
  KEY `slugRev` (`slug`,`revision`),
  KEY `updated` (`updated`),
  KEY `author` (`author`),
  KEY `visible` (`visible`)<commit_msg>add default for page hits<commit_after>CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(55) COLLATE utf8_unicode_ci NOT NULL,
  `revision` int(4) NOT NULL DEFAULT 1,
  `browserscopeID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `info` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `setup` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `teardown` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `initHTML` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `visible` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `authorEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `authorURL` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hits` bigint(20) NOT NULL DEFAULT 0,
  `published` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `browserscopeID` (`browserscopeID`),
  KEY `slugRev` (`slug`,`revision`),
  KEY `updated` (`updated`),
  KEY `author` (`author`),
  KEY `visible` (`visible`)
{'fraction_non_alphanumeric': 0.10955302366345311, 'fraction_numerical': 0.030236634531113058, 'mean_word_length': 5.774480712166172, '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': '6407651', 'n_tokens_mistral': 894, 'n_tokens_neox': 823, 'n_words': 244}