<commit_before>CREATE TABLE `mobilewebosp`.`Buildings1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `hours` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `wifi` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `subtype` varchar(45) DEFAULT NULL,
  `campus` varchar(45) DEFAULT NULL,
  `latitude` varchar(45) DEFAULT NULL,
  `longitude` varchar(45) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `physical_address` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

CREATE TABLE `mobilewebosp`.`Pageviews_by_Device1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `count` int(11) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `day` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

CREATE TABLE `mobilewebosp`.`Pageviews_by_Section1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `count` int(11) DEFAULT NULL,
  `section` varchar(255) DEFAULT NULL,
  `day` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
<commit_msg>adding a UID field to the maps table so the parent-child relationship works properly<commit_after>CREATE TABLE `mobilewebosp`.`Buildings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `hours` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `wifi` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `subtype` varchar(45) DEFAULT NULL,
  `campus` varchar(45) DEFAULT NULL,
  `latitude` varchar(45) DEFAULT NULL,
  `longitude` varchar(45) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `physical_address` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

CREATE TABLE `mobilewebosp`.`Pageviews_by_Device` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `count` int(11) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `day` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

CREATE TABLE `mobilewebosp`.`Pageviews_by_Section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `count` int(11) DEFAULT NULL,
  `section` varchar(255) DEFAULT NULL,
  `day` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

{'fraction_non_alphanumeric': 0.12607674236491778, 'fraction_numerical': 0.04894283476898982, 'mean_word_length': 5.636363636363637, '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': '4173712', 'n_tokens_mistral': 1037, 'n_tokens_neox': 909, 'n_words': 259}