mekan2026 Turkey 1320 username,email,hashed passwords,IPs
by iaminthegameyo - Wednesday September 16, 2026 at 01:51 PM
#1
Quote:SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `accounts`
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `password` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `salt` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `serial` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `register_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `last_login` datetime DEFAULT NULL,
  `admin_level` tinyint(2) NOT NULL DEFAULT '0',
  `manager_level` tinyint(1) NOT NULL DEFAULT '0',
  `admin_reports` int(11) NOT NULL DEFAULT '0',
  `admin_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci,
  `max_characters` tinyint(3) NOT NULL DEFAULT '3',
  `admin_jailed` tinyint(1) NOT NULL DEFAULT '0',
  `admin_jail_time` int(11) NOT NULL DEFAULT '0',
  `admin_jail_by` text CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci,
  `admin_jail_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci,
  `donater` tinyint(1) NOT NULL DEFAULT '0',
  `youtuber` tinyint(1) NOT NULL DEFAULT '0',
  `rp_plus` tinyint(1) NOT NULL DEFAULT '0',
  `balance` int(11) NOT NULL DEFAULT '0',
  `promo_used` tinyint(1) NOT NULL DEFAULT '0',
  `total_hours_played` int(11) NOT NULL DEFAULT '0',
  `rp_confirm` tinyint(1) NOT NULL DEFAULT '0',
  `probation_status` tinyint(1) NOT NULL,
  `probation_end` int(11) NOT NULL,
  `probation_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `probation_admin` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1268 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci ROW_FORMAT=DYNAMIC;

Hidden Content
You must register or login to view this content.
Reply
#2
thank you :)
Reply
#3
nice stuff?
Reply
#4
thank you
Reply
#5
Thanks for share!
Reply
#6
thanks.
Reply
#7
nice man
Reply
#8
thanks for the drop man.
Reply
#9
(16-09-26, 01:51 PM)iaminthegameyo Wrote:
Quote:SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `accounts`
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `password` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `salt` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `serial` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci NOT NULL,
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `register_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `last_login` datetime DEFAULT NULL,
  `admin_level` tinyint(2) NOT NULL DEFAULT '0',
  `manager_level` tinyint(1) NOT NULL DEFAULT '0',
  `admin_reports` int(11) NOT NULL DEFAULT '0',
  `admin_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci,
  `max_characters` tinyint(3) NOT NULL DEFAULT '3',
  `admin_jailed` tinyint(1) NOT NULL DEFAULT '0',
  `admin_jail_time` int(11) NOT NULL DEFAULT '0',
  `admin_jail_by` text CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci,
  `admin_jail_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci,
  `donater` tinyint(1) NOT NULL DEFAULT '0',
  `youtuber` tinyint(1) NOT NULL DEFAULT '0',
  `rp_plus` tinyint(1) NOT NULL DEFAULT '0',
  `balance` int(11) NOT NULL DEFAULT '0',
  `promo_used` tinyint(1) NOT NULL DEFAULT '0',
  `total_hours_played` int(11) NOT NULL DEFAULT '0',
  `rp_confirm` tinyint(1) NOT NULL DEFAULT '0',
  `probation_status` tinyint(1) NOT NULL,
  `probation_end` int(11) NOT NULL,
  `probation_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `probation_admin` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1268 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci ROW_FORMAT=DYNAMIC;
Reply
#10
replying to show the link! much appreciated
Reply


Forum Jump:


 Users browsing this thread: 4 Guest(s)