<commit_before>CREATE TABLE `tblActivation` (
  `entryId` bigint(20) unsigned NOT NULL auto_increment,
  `userId` bigint(20) unsigned NOT NULL,
  `type` tinyint(1) unsigned NOT NULL default '0',
  `rnd` bigint(20) unsigned NOT NULL default '0',
  `answer` varchar(10) default NULL,
  `timeCreated` datetime default NULL,
  PRIMARY KEY  (`entryId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tblBlogs` (
  `blogId` int(10) unsigned NOT NULL auto_increment,
  `userId` int(10) unsigned NOT NULL default '0',
  `blogTitle` varchar(200) default NULL,
  `blogBody` text,
  `timeCreated` datetime default NULL,
  `timeUpdated` datetime default NULL,
  `categoryId` bigint(20) unsigned NOT NULL default '0',
  `deletedBy` int(10) unsigned NOT NULL default '0',
  `timeDeleted` datetime default NULL,
  `rating` tinyint(3) unsigned NOT NULL default '0',
  `ratingCnt` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`blogId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tblCategories` (
  `categoryId` bigint(20) unsigned NOT NULL auto_increment,
  `categoryName` varchar(200) default NULL,
  `categoryType` tinyint(3) unsigned NOT NULL default '0',
  `timeCreated` datetime default NULL,
  `creatorId` int(10) unsigned NOT NULL default '0',
  `categoryPermissions` tinyint(3) unsigned NOT NULL default '0',
  `ownerId` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`categoryId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tblChecksums` (
  `entryId` bigint(20) unsigned NOT NULL auto_increment,
  `fileId` int(11) unsigned default NULL,
  `sha1` varchar(40) default NULL,
  `md5` varchar(32) default NULL,
  `timeCreated` datetime default NULL,
  `timeExec` float default NULL,
  PRIMARY KEY  (`entryId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tblComments` (
  `commentId` bigint(20) unsigned NOT NULL auto_increment,
  `commentType` tinyint(3) unsigned NOT NULL default '0',
  `commentText` text,
  `commentPrivate` tinyint(4) NOT NULL default '0',
  `timeCreated` datetime default NULL,
  `timeDeleted` datetime default NULL,
  `deletedBy` smallint(5) unsigned NOT NULL default '0',
  `ownerId` bigint(20) unsigned NOT NULL default '0',<commit_msg>added tblBlocks renamed tblCategories.categoryPermissions to tblCategories.permissions<commit_after>CREATE TABLE `tblActivation` (
  `entryId` bigint(20) unsigned NOT NULL auto_increment,
  `userId` bigint(20) unsigned NOT NULL,
  `type` tinyint(1) unsigned NOT NULL default '0',
  `rnd` bigint(20) unsigned NOT NULL default '0',
  `answer` varchar(10) default NULL,
  `timeCreated` datetime default NULL,
  PRIMARY KEY  (`entryId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tblBlocks` (
  `ruleId` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(3) unsigned NOT NULL,
  `rule` text character set utf8,
  `timeCreated` datetime default NULL,
  `createdBy` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ruleId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `tblBlogs` (
  `blogId` int(10) unsigned NOT NULL auto_increment,
  `userId` int(10) unsigned NOT NULL default '0',
  `blogTitle` varchar(200) default NULL,
  `blogBody` text,
  `timeCreated` datetime default NULL,
  `timeUpdated` datetime default NULL,
  `categoryId` bigint(20) unsigned NOT NULL default '0',
  `deletedBy` int(10) unsigned NOT NULL default '0',
  `timeDeleted` datetime default NULL,
  `rating` tinyint(3) unsigned NOT NULL default '0',
  `ratingCnt` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`blogId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tblCategories` (
  `categoryId` bigint(20) unsigned NOT NULL auto_increment,
  `categoryName` varchar(200) default NULL,
  `categoryType` tinyint(3) unsigned NOT NULL default '0',
  `timeCreated` datetime default NULL,
  `creatorId` int(10) unsigned NOT NULL default '0',
  `permissions` tinyint(3) unsigned NOT NULL default '0',
  `ownerId` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`categoryId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tblChecksums` (
  `entryId` bigint(20) unsigned NOT NULL auto_increment,
  `fileId` int(11) unsigned default NULL,
  `sha1` varchar(40) default NULL,
  `md5` varchar(32) default NULL,
  `timeCreated` datetime default NULL,
  `timeExec` float default NULL,
  PRIMARY KEY  (`entryId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tblComments` (
  `commentId` bigint(20) unsigned NOT NULL auto_increment,
  `commentType` tinyint(3) unsigned NOT NULL default '0',
  `commentText` text,
  `commentPrivate` tinyint(4) NOT NULL default '0',
  `timeCreated` datetime default NULL,
  `timeDeleted` datetime default NULL,
  `deletedBy` smallint(5) unsigned NOT NULL default '0',
  `ownerId` bigint(20) unsigned NOT NULL default '0',
{'fraction_non_alphanumeric': 0.1112043642467478, 'fraction_numerical': 0.030843474611833822, 'mean_word_length': 5.485714285714286, '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': '2318888', 'n_tokens_mistral': 1631, 'n_tokens_neox': 1543, 'n_words': 524}