<commit_before>/*
Navicat MySQL Data Transfer

Source Server         : my local mysql connection
Source Server Version : 50173
Source Host           : localhost:3306
Source Database       : netscout_db

Target Server Type    : MYSQL
Target Server Version : 50173
File Encoding         : 65001

Date: 2015-02-10 16:42:50
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `customers`
-- ----------------------------
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` longtext,
  `f_name` longtext,
  `l_name` longtext,
  `password` longtext,
  `full_key` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of customers
-- ----------------------------
INSERT INTO `customers` VALUES ('5', 'Test', 'Vasia', 'Pupkin', '$1$WT4.nR2.$CHdd7aZsUz/.QA9TQYSfK.', '4321-4321-4321');
INSERT INTO `customers` VALUES ('6', 'vasia', 'Dima ', 'Hitrov', '$1$Cq2.ja5.$unlIAvy34YnBnXjymTBqe1', '4444-4444-4444');

-- ----------------------------
-- Table structure for `labels`
-- ----------------------------
DROP TABLE IF EXISTS `labels`;
CREATE TABLE `labels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of labels
-- ----------------------------
INSERT INTO `labels` VALUES ('1', 'login');
INSERT INTO `labels` VALUES ('2', 'password');<commit_msg>new db dump<commit_after>/*
Navicat MySQL Data Transfer

Source Server         : my local mysql connection
Source Server Version : 50173
Source Host           : localhost:3306
Source Database       : netscout_db

Target Server Type    : MYSQL
Target Server Version : 50173
File Encoding         : 65001

Date: 2015-02-10 19:03:07
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `customers`
-- ----------------------------
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` longtext,
  `f_name` longtext,
  `l_name` longtext,
  `password` longtext,
  `full_key` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of customers
-- ----------------------------
INSERT INTO `customers` VALUES ('5', 'Test', 'Vasia', 'Pupkin', '$1$WT4.nR2.$CHdd7aZsUz/.QA9TQYSfK.', '4321-4321-4321');
INSERT INTO `customers` VALUES ('6', 'vasia', 'Dima ', 'Hitrov', '$1$Cq2.ja5.$unlIAvy34YnBnXjymTBqe1', '4444-4444-4444');

-- ----------------------------
-- Table structure for `datacentres`
-- ----------------------------
DROP TABLE IF EXISTS `datacentres`;
CREATE TABLE `datacentres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datacenter_name` varchar(30) DEFAULT NULL,
  `ip_address` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of datacentres
-- ----------------------------
INSERT INTO `datacentres` VALUES ('1', null, '192.168.127.12');
INSERT INTO `datacentres` VALUES ('2', 'DC', '12333333');
INSERT INTO `datacentres` VALUES ('3', 'rtrtrtr', '343434');
INSERT INTO `datacentres` VALUES ('4', 'dc1', '213.23.23.34');

-- ----------------------------
-- Table structure for `dc_user`
-- ----------------------------
DROP TABLE IF EXISTS `dc_user`;
CREATE TABLE `dc_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dc_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dc_user
-- ----------------------------
INSERT INTO `dc_user` VALUES ('1', '4', '5');

-- ----------------------------
-- Table structure for `labels`
-- ----------------------------
DROP TABLE IF EXISTS `labels`;
CREATE TABLE `labels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of labels
-- ----------------------------
INSERT INTO `labels` VALUES ('1', 'login');
INSERT INTO `labels` VALUES ('2', 'password');
{'fraction_non_alphanumeric': 0.2837996708205972, 'fraction_numerical': 0.05172819186456619, 'mean_word_length': 2.0560344827586206, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 2, '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': '7295653', 'n_tokens_mistral': 1540, 'n_tokens_neox': 1371, 'n_words': 376}