· 9 years ago · Oct 14, 2016, 09:20 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.14
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Oct 14, 2016 at 03:05 PM
7-- Server version: 5.6.33
8-- PHP Version: 5.6.20
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `vilehcfc_xenforo`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `xf_user`
27--
28
29CREATE TABLE IF NOT EXISTS `xf_user` (
30 `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
31 `username` varchar(50) NOT NULL,
32 `email` varchar(120) NOT NULL,
33 `gender` enum('','male','female') NOT NULL DEFAULT '' COMMENT 'Leave empty for ''unspecified''',
34 `custom_title` varchar(50) NOT NULL DEFAULT '',
35 `language_id` int(10) unsigned NOT NULL,
36 `style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
37 `timezone` varchar(50) NOT NULL COMMENT 'Example: ''Europe/London''',
38 `visible` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Show browsing activity to others',
39 `activity_visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
40 `user_group_id` int(10) unsigned NOT NULL,
41 `secondary_group_ids` varbinary(255) NOT NULL,
42 `display_style_group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User group ID that provides user styling',
43 `permission_combination_id` int(10) unsigned NOT NULL,
44 `message_count` int(10) unsigned NOT NULL DEFAULT '0',
45 `conversations_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
46 `register_date` int(10) unsigned NOT NULL DEFAULT '0',
47 `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
48 `trophy_points` int(10) unsigned NOT NULL DEFAULT '0',
49 `alerts_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
50 `avatar_date` int(10) unsigned NOT NULL DEFAULT '0',
51 `avatar_width` smallint(5) unsigned NOT NULL DEFAULT '0',
52 `avatar_height` smallint(5) unsigned NOT NULL DEFAULT '0',
53 `gravatar` varchar(120) NOT NULL DEFAULT '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
54 `user_state` enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') NOT NULL DEFAULT 'valid',
55 `is_moderator` tinyint(3) unsigned NOT NULL DEFAULT '0',
56 `is_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
57 `is_banned` tinyint(3) unsigned NOT NULL DEFAULT '0',
58 `like_count` int(10) unsigned NOT NULL DEFAULT '0',
59 `warning_points` int(10) unsigned NOT NULL DEFAULT '0',
60 `is_staff` tinyint(3) unsigned NOT NULL DEFAULT '0',
61 PRIMARY KEY (`user_id`),
62 UNIQUE KEY `username` (`username`),
63 KEY `email` (`email`),
64 KEY `user_state` (`user_state`),
65 KEY `last_activity` (`last_activity`),
66 KEY `message_count` (`message_count`),
67 KEY `trophy_points` (`trophy_points`),
68 KEY `like_count` (`like_count`),
69 KEY `register_date` (`register_date`),
70 KEY `staff_username` (`is_staff`,`username`)
71) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
72
73--
74-- Dumping data for table `xf_user`
75--
76
77INSERT INTO `xf_user` (`user_id`, `username`, `email`, `gender`, `custom_title`, `language_id`, `style_id`, `timezone`, `visible`, `activity_visible`, `user_group_id`, `secondary_group_ids`, `display_style_group_id`, `permission_combination_id`, `message_count`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `alerts_unread`, `avatar_date`, `avatar_width`, `avatar_height`, `gravatar`, `user_state`, `is_moderator`, `is_admin`, `is_banned`, `like_count`, `warning_points`, `is_staff`) VALUES
78(1, 'Vehqzi', 'vehqzihd@yahoo.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '3,4,5', 3, 12, 32, 1, 1475945634, 1476464116, 8, 0, 1476226504, 192, 192, '', 'valid', 1, 1, 0, 18, 0, 1),
79(2, 'Tracer', 'itsjoelrutherford@gmail.com', '', 'ovrwtch fgt', 1, 0, 'Europe/London', 1, 1, 2, '3,8', 3, 15, 1, 0, 1475952437, 1476408462, 3, 0, 1476407584, 215, 192, '', 'valid', 0, 1, 0, 2, 0, 1),
80(3, 'XenForo', 'jakeissweg61@gmail.com', 'male', 'Manager', 1, 0, 'America/Los_Angeles', 1, 1, 2, '4,6', 6, 14, 29, 1, 1475952784, 1476410113, 8, 8, 1476242002, 336, 192, '', 'valid', 0, 0, 0, 5, 0, 1),
81(4, 'Most', 'white.jadeyn@gmail.com', 'male', 'Manager', 1, 0, 'America/New_York', 1, 1, 2, '6', 6, 10, 4, 1, 1475952870, 1476393163, 3, 7, 1475962647, 192, 227, '', 'valid', 0, 0, 0, 5, 0, 1),
82(5, 'Aden', 'karenshevey@yahoo.com', 'male', '', 1, 0, 'America/Los_Angeles', 1, 1, 2, '', 2, 2, 2, 0, 1475978163, 1476397571, 1, 1, 1475978204, 192, 192, '', 'valid', 0, 0, 0, 0, 1, 0),
83(6, 'Luke020', 'bigduke019@gmail.com', 'male', 'Admin', 1, 0, 'America/Chicago', 1, 1, 2, '10', 10, 17, 5, 0, 1475984042, 1476372953, 1, 5, 1476319644, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 1),
84(7, 'DoublePotting', 'supwitaids1@gmail.com', 'male', 'Developer', 1, 0, 'America/New_York', 1, 1, 2, '7', 7, 16, 8, 1, 1475989336, 1476416111, 3, 8, 0, 0, 0, '', 'valid', 0, 0, 0, 1, 0, 1),
85(8, 'i22', 'necjester21@gmail.com', 'male', 'Trial-Mod', 1, 0, 'America/New_York', 1, 1, 2, '13', 13, 18, 32, 1, 1476042560, 1476458001, 8, 0, 1476192371, 256, 192, '', 'valid', 0, 0, 0, 4, 0, 1),
86(9, 'Noot', '73shadesofcod@gmail.com', 'male', 'Trial-Mod', 1, 3, 'America/Los_Angeles', 0, 0, 2, '13', 13, 18, 33, 1, 1476064137, 1476462048, 8, 2, 1476068730, 192, 192, '', 'valid', 0, 0, 0, 9, 0, 1),
87(10, 'Actuality', 'rccraftin@gmail.com', 'male', 'Trial-Mod', 1, 0, 'America/Chicago', 1, 1, 2, '13', 13, 18, 7, 1, 1476066693, 1476417485, 3, 3, 1476069573, 38, 38, '', 'valid', 0, 0, 0, 1, 0, 1),
88(11, 'Flexxin / FlexinBruh', 'apexstreams@gmail.com', 'male', '', 1, 3, 'America/New_York', 1, 1, 2, '', 2, 2, 2, 0, 1476068047, 1476362470, 1, 6, 1476148283, 192, 248, '', 'valid', 0, 0, 0, 2, 0, 0),
89(12, 'SorryHomie', 'ImmersfulFlame@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 0, 0, 1476072521, 1476249917, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
90(13, 'Mantice', 'ManticeBn@gmail.com', 'male', 'Trial-Mod', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '13', 13, 18, 5, 0, 1476122613, 1476465014, 1, 0, 1476164014, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 1),
91(14, 'moonball', 'zylemhc@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 0, 0, 1476123366, 1476123388, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
92(15, 'iSipDirtySprite', 'lewigginsjr@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 0, 0, 1476130310, 1476234345, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
93(16, 'Touchs', 'max.lanning99@hotmail.com', 'male', 'Trial-Mod', 1, 0, 'Europe/London', 1, 1, 2, '13', 13, 18, 28, 0, 1476131351, 1476464760, 3, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 3, 0, 1),
94(17, 'ActivatinqIzBae', 'mineplex9jason@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 25, 0, 1476136958, 1476407574, 3, 1, 1476228102, 192, 209, '', 'valid', 0, 0, 0, 3, 0, 0),
95(18, 'SOTWHype305', 'tibebujason@gmail.com', 'female', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 5, 1, 1476147185, 1476223890, 3, 5, 1476147255, 192, 192, '', 'valid', 0, 0, 0, 2, 3, 0),
96(19, 'Saltinq', 'michaelkhandani200@gmail.com', 'male', '', 1, 0, 'America/Phoenix', 1, 1, 2, '', 2, 2, 2, 0, 1476223076, 1476333546, 3, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 1, 0, 0),
97(20, 'Cbass', 'sebasdiazl@hotmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 4, 0, 1476223212, 1476229458, 1, 2, 1476225920, 192, 217, '', 'valid', 0, 0, 0, 0, 0, 0),
98(21, 'Case', 'awesomedood56@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 1, 0, 1476226762, 1476457085, 1, 0, 1476226948, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
99(22, 'czxm', 'etern1tyjinx24@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476232427, 1476312055, 1, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
100(23, 'M65', 'irepulsivehackedacc@Hotmail.com', 'male', 'Trial-Mod', 1, 0, 'America/New_York', 1, 1, 2, '13', 13, 18, 14, 1, 1476241810, 1476455176, 1, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 1),
101(24, 'Kezeurex', 'ojc2003vsgaming@gmail.com', 'male', 'Developer', 1, 0, 'Asia/Bangkok', 1, 1, 2, '7', 7, 16, 18, 1, 1476242735, 1476439140, 1, 8, 1476420613, 278, 192, '', 'valid', 0, 0, 0, 0, 0, 1),
102(25, 'InmortalPvPz', 'wvo28@hotmail.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 1, 0, 1476275096, 1476277746, 1, 4, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
103(26, 'GlawkInMyRawry', 'electralpvp@icloud.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476279289, 1476279326, 1, 3, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
104(27, 'Hausik', 'hausikhskah@gmail.com', 'male', '', 1, 0, 'Africa/Algiers', 1, 1, 2, '', 2, 2, 2, 0, 1476285235, 1476452178, 1, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
105(28, 'Kvnye', 'ndndnd@hotmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476289972, 1476290033, 1, 3, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
106(29, 'KravePvP', 'canny99@hotmail.co.uk', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 0, 0, 1476290049, 1476383899, 0, 3, 1476299421, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
107(30, 'AirJitter', 'smsm@hotmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476290081, 1476290111, 1, 2, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
108(31, 'Justin', 'jberube8881@aol.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 8, 0, 1476297045, 1476448825, 1, 3, 1476307487, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
109(32, 'Petteqh', 'scoobypetter@gmail.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 3, 0, 1476297217, 1476386920, 3, 3, 1476297281, 256, 192, '', 'valid', 0, 0, 0, 1, 0, 0),
110(33, 'FIlleJr', 'minefille@hotmail.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 9, 0, 1476297413, 1476458993, 3, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 1, 0, 0),
111(34, 'SlizzArn', 'OliverPrivate@outlook.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1476297746, 1476371734, 0, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
112(35, 'Arad', 'arad_niaki@yahoo.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 2, 0, 1476305439, 1476464905, 3, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 2, 0, 0),
113(36, 'STRATEX', 'stratexofficial@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 0, 0, 1476315627, 1476315709, 0, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
114(37, 'boogieboards', 'beckleyashley541@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 0, 0, 1476414713, 1476414891, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
115(38, 'EzBann', 'djcrunchbizness@gmail.com', 'male', '', 1, 0, 'America/Los_Angeles', 1, 1, 2, '', 2, 2, 4, 0, 1476422217, 1476465051, 1, 1, 1476423241, 256, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
116(39, 'ProxiiBlade', 'Deluxe-MC@outlook.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1476464011, 1476464127, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0);
117
118/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
119/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
120/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;