<commit_before>-- Adminer 4.2.5 MySQL dump

CREATE TABLE `privileges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `privileges` (`id`, `name`) VALUES
(NULL, 'default');

CREATE TABLE `resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `resources` (`id`, `name`) VALUES
(NULL, 'Web:Web'),
(NULL, 'Web:Login'),
(NULL, 'Admin:Admin');

CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `parent` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `roles` (`id`, `name`, `parent`) VALUES
(NULL, 'guest',  0),
(NULL, 'member', 1),
(NULL, 'admin',  1);

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` int(11) NOT NULL,
  `resource` int(11) NOT NULL,
  `privilege` int(11) NOT NULL,
  `allowed` enum('no','yes') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  KEY `resource` (`resource`),
  KEY `role` (`role`),
  KEY `privilege` (`privilege`),
  CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`resource`) REFERENCES `resources` (`id`),
  CONSTRAINT `permissions_ibfk_2` FOREIGN KEY (`role`) REFERENCES `roles` (`id`),
  CONSTRAINT `permissions_ibfk_3` FOREIGN KEY (`privilege`) REFERENCES `privileges` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `permissions` (`id`, `role`, `resource`, `privilege`, `allowed`) VALUES
(NULL, 1, 1, 1, 'yes'),
(NULL, 1, 2, 1, 'yes');

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `realname` varchar(60) NOT NULL,
  `email` varchar(60) NOT NULL,
  `password` char(60) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `users` (`id`, `realname`, `email`, `password`) VALUES
(NULL, 'Root', '<EMAIL>', <PASSWORD>');

CREATE TABLE `access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `role` (`role`),
  CONSTRAINT `access_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`id`),
  CONSTRAINT `access_ibfk_2` FOREIGN KEY (`role`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `access` (`id`, `role`, `user`) VALUES
(NULL, 2, 1);

-- 2017-05-23 05:29:29
<commit_msg>fix typo<commit_after>-- Adminer 4.2.5 MySQL dump

CREATE TABLE `privileges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `privileges` (`id`, `name`) VALUES
(NULL, 'default');

CREATE TABLE `resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `resources` (`id`, `name`) VALUES
(NULL, 'Web:Web'),
(NULL, 'Web:Login'),
(NULL, 'Admin:Admin');

CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `parent` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `roles` (`id`, `name`, `parent`) VALUES
(NULL, 'guest',  0),
(NULL, 'member', 1),
(NULL, 'admin',  2);

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` int(11) NOT NULL,
  `resource` int(11) NOT NULL,
  `privilege` int(11) NOT NULL,
  `allowed` enum('no','yes') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  KEY `resource` (`resource`),
  KEY `role` (`role`),
  KEY `privilege` (`privilege`),
  CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`resource`) REFERENCES `resources` (`id`),
  CONSTRAINT `permissions_ibfk_2` FOREIGN KEY (`role`) REFERENCES `roles` (`id`),
  CONSTRAINT `permissions_ibfk_3` FOREIGN KEY (`privilege`) REFERENCES `privileges` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `permissions` (`id`, `role`, `resource`, `privilege`, `allowed`) VALUES
(NULL, 1, 1, 1, 'yes'),
(NULL, 1, 2, 1, 'yes');

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `realname` varchar(60) NOT NULL,
  `email` varchar(60) NOT NULL,
  `password` char(60) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `users` (`id`, `realname`, `email`, `password`) VALUES
(NULL, 'Root', '<EMAIL>', <PASSWORD>');

CREATE TABLE `access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `role` (`role`),
  CONSTRAINT `access_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`id`),
  CONSTRAINT `access_ibfk_2` FOREIGN KEY (`role`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `access` (`id`, `role`, `user`) VALUES
(NULL, 2, 1);

-- 2017-05-23 05:29:29

{'fraction_non_alphanumeric': 0.18598112070696926, 'fraction_numerical': 0.03012653143201446, 'mean_word_length': 5.1940298507462686, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, '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': '4448309', 'n_tokens_mistral': 2185, 'n_tokens_neox': 1968, 'n_words': 579}