ght_namsor_s

CREATE TABLE `ght_namsor_s` (
  `id` int(11) NOT NULL DEFAULT '0',
  `login` varchar(255) CHARACTER SET utf8 NOT NULL,
  `name` text,
  `firstName` text,
  `lastName` text,
  `email` text,
  `company` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'USR',
  `fake` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `location` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `nameParseScore` float DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `countryAlt` varchar(255) DEFAULT NULL,
  `countryScore` float DEFAULT NULL,
  `script` varchar(255) DEFAULT NULL,
  `countryFirstName` text,
  `countryLastName` text,
  `countryScoreFirstName` float DEFAULT NULL,
  `countryScoreLastName` float DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `countryGender` varchar(255) DEFAULT NULL,
  `countryGenderAlt` varchar(255) DEFAULT NULL,
  `genderScale` float DEFAULT NULL,
  `gplus_gender` float DEFAULT NULL,
  `gplus_reliability` float DEFAULT NULL,
  `genderComputer` float DEFAULT NULL,
  `do_not_contact` tinyint(1) DEFAULT '0',
  `friendly` tinyint(1) DEFAULT '0',
  `first_commit` datetime DEFAULT NULL,
  KEY `index1` (`id`),
  KEY `index2` (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;