· 8 years ago · Oct 28, 2017, 10:04 PM
1-- LA MEUTE PRISONRP FORUM DUMP xf_user by Neo
2
3-- phpMyAdmin SQL Dump
4-- version 4.1.13
5-- http://www.phpmyadmin.net
6--
7-- Client : localhost
8-- Généré le : Sam 07 Octobre 2017 à 22:35
9-- Version du serveur : 5.5.57-0+deb8u1-log
10-- Version de PHP : 5.6.30-0+deb8u1
11
12SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8 */;
20
21--
22-- Base de données : `126558_sql`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `xf_user`
29--
30
31CREATE TABLE IF NOT EXISTS `xf_user` (
32 `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
33 `username` varchar(50) NOT NULL,
34 `email` varchar(120) NOT NULL,
35 `gender` enum('','male','female') NOT NULL DEFAULT '' COMMENT 'Leave empty for ''unspecified''',
36 `custom_title` varchar(50) NOT NULL DEFAULT '',
37 `language_id` int(10) unsigned NOT NULL,
38 `style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
39 `timezone` varchar(50) NOT NULL COMMENT 'Example: ''Europe/London''',
40 `visible` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Show browsing activity to others',
41 `activity_visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
42 `user_group_id` int(10) unsigned NOT NULL,
43 `secondary_group_ids` varbinary(255) NOT NULL,
44 `display_style_group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User group ID that provides user styling',
45 `permission_combination_id` int(10) unsigned NOT NULL,
46 `message_count` int(10) unsigned NOT NULL DEFAULT '0',
47 `conversations_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
48 `register_date` int(10) unsigned NOT NULL DEFAULT '0',
49 `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
50 `trophy_points` int(10) unsigned NOT NULL DEFAULT '0',
51 `alerts_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
52 `avatar_date` int(10) unsigned NOT NULL DEFAULT '0',
53 `avatar_width` smallint(5) unsigned NOT NULL DEFAULT '0',
54 `avatar_height` smallint(5) unsigned NOT NULL DEFAULT '0',
55 `gravatar` varchar(120) NOT NULL DEFAULT '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
56 `user_state` enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') NOT NULL DEFAULT 'valid',
57 `is_moderator` tinyint(3) unsigned NOT NULL DEFAULT '0',
58 `is_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
59 `is_banned` tinyint(3) unsigned NOT NULL DEFAULT '0',
60 `like_count` int(10) unsigned NOT NULL DEFAULT '0',
61 `warning_points` int(10) unsigned NOT NULL DEFAULT '0',
62 `is_staff` tinyint(3) unsigned NOT NULL DEFAULT '0',
63 PRIMARY KEY (`user_id`),
64 UNIQUE KEY `username` (`username`),
65 KEY `email` (`email`),
66 KEY `user_state` (`user_state`),
67 KEY `last_activity` (`last_activity`),
68 KEY `message_count` (`message_count`),
69 KEY `trophy_points` (`trophy_points`),
70 KEY `like_count` (`like_count`),
71 KEY `register_date` (`register_date`),
72 KEY `staff_username` (`is_staff`,`username`)
73) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
74
75--
76-- Contenu de la table `xf_user`
77--
78
79INSERT 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
80(1, 'Tom Pablo', 'lesgameurdu59286@gmail.com', '', '', 2, 2, 'Europe/London', 1, 1, 2, '3,4', 3, 5, 502, 0, 1506505750, 1507325025, 5090, 0, 1506507959, 184, 184, '', 'valid', 1, 1, 0, 9001, 0, 1),
81(2, 'Rachid delplaza', 'kyran.tyre@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 15, 0, 1506720472, 1507300633, 3, 0, 1506723672, 325, 192, '', 'valid', 0, 0, 0, 1, 0, 0),
82(3, 'dracvar', 'zachariezuckerman@hotmail.fr', '', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506769203, 1506769316, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
83(4, 'Greg Sonny', 'chaton_130801@outlook.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506780435, 1506780625, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
84(5, 'Robot Forum', 'lesgameur@gmail.com', '', '', 2, 0, 'Europe/London', 1, 1, 4, '', 4, 6, 0, 0, 1506780548, 1507227916, 0, 0, 1507226308, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 1),
85(6, 'Matthieu', 'matth0428@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 1, 0, 1506783301, 1506965615, 1, 3, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
86(7, 'Rayan', 'hfar759@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 4, '', 4, 6, 14, 0, 1506789416, 1507320612, 3, 4, 1506794237, 297, 170, '', 'valid', 0, 0, 0, 1, 0, 1),
87(8, 'almic99', 'am021299@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506796697, 1506796697, 0, 0, 0, 0, 0, '', 'email_confirm', 0, 0, 0, 0, 0, 0),
88(9, 'almic1299', 'am0212990@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506796878, 1507123832, 0, 0, 0, 0, 0, '', 'email_confirm', 0, 0, 0, 0, 0, 0),
89(10, 'Dimitri Blackowski', 'genehennequin@orange.fr', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506799642, 1506799732, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
90(11, 'Ianis Sohn', 'SlowChips@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506808574, 1506808574, 0, 0, 0, 0, 0, '', 'email_confirm', 0, 0, 0, 0, 0, 0),
91(12, 'michiko', 'julesblc.huard@yahoo.fr', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 2, 0, 1506812901, 1507310202, 1, 0, 1507141107, 240, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
92(13, 'Abdelzak Shoutlouf', 'Yanis62.YS@gmail.com', 'male', '', 2, 0, 'Pacific/Tongatapu', 1, 1, 2, '', 2, 2, 0, 0, 1506854755, 1506854854, 0, 0, 0, 0, 0, '', 'email_confirm', 0, 0, 0, 0, 0, 0),
93(14, 'Radwan Delplaza', 'gamer33770@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 6, 0, 1506855206, 1507301304, 1, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
94(15, 'Medhi Moirien', 'KraF60@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506856467, 1506856671, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
95(16, 'Voxi57', 'pascalpons57950@outlook.fr', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506858222, 1506858758, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
96(17, 'Mahmoud Voste', 'noriro@hotmail.fr', 'male', '', 2, 0, 'Africa/Algiers', 1, 1, 2, '', 2, 2, 0, 0, 1506867867, 1506966957, 0, 0, 0, 0, 0, '', 'email_confirm', 0, 0, 0, 0, 0, 0),
97(18, 'RANI', 'ranisaada68130@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1506872705, 1506873305, 0, 0, 0, 0, 0, '', 'email_confirm', 0, 0, 0, 0, 0, 0),
98(19, 'Nahil_059', 'nahil.kerrar@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1507044963, 1507045022, 0, 0, 0, 0, 0, '', 'email_confirm', 0, 0, 0, 0, 0, 0),
99(20, 'Kaiqzz', 'justdrop64@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 8, 0, 1507124839, 1507301258, 1, 1, 1507145469, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
100(21, 'Jacky Padou', 'dragonmat59@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 6, 0, 1507130802, 1507295047, 1, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
101(22, 'yanis legrand', 'supermix1234567@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 1, 0, 1507130836, 1507133438, 1, 3, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
102(23, 'Alexander Nahrell', 'firyogaming@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 5, 0, 1507134651, 1507325143, 1, 0, 1507296813, 288, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
103(24, 'Mica_Dubois', 'oxo57800@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 4, '', 4, 6, 11, 0, 1507182643, 1507326125, 1, 0, 1507227956, 192, 249, '', 'valid', 0, 0, 0, 0, 0, 1),
104(25, 'SKIIZI HD', 'verbouyanis@gmail.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 4, '', 4, 6, 200, 0, 1507212709, 1507219135, 200, 7, 1507212954, 192, 192, '', 'valid', 0, 0, 0, 3000, 0, 1),
105(26, 'Ever_Neto', 'ben-j.02000@outlook.com', 'male', '', 2, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 3, 0, 1507229387, 1507311959, 1, 2, 1507233965, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0);
106
107/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
108/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
109/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;