Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- LA MEUTE PRISONRP FORUM DUMP xf_user by Neo
- -- phpMyAdmin SQL Dump
- -- version 4.1.13
- -- http://www.phpmyadmin.net
- --
- -- Client : localhost
- -- Généré le : Sam 07 Octobre 2017 à 22:35
- -- Version du serveur : 5.5.57-0+deb8u1-log
- -- Version de PHP : 5.6.30-0+deb8u1
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Base de données : `126558_sql`
- --
- -- --------------------------------------------------------
- --
- -- Structure de la table `xf_user`
- --
- CREATE TABLE IF NOT EXISTS `xf_user` (
- `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` varchar(50) NOT NULL,
- `email` varchar(120) NOT NULL,
- `gender` enum('','male','female') NOT NULL DEFAULT '' COMMENT 'Leave empty for ''unspecified''',
- `custom_title` varchar(50) NOT NULL DEFAULT '',
- `language_id` int(10) unsigned NOT NULL,
- `style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
- `timezone` varchar(50) NOT NULL COMMENT 'Example: ''Europe/London''',
- `visible` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Show browsing activity to others',
- `activity_visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `user_group_id` int(10) unsigned NOT NULL,
- `secondary_group_ids` varbinary(255) NOT NULL,
- `display_style_group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User group ID that provides user styling',
- `permission_combination_id` int(10) unsigned NOT NULL,
- `message_count` int(10) unsigned NOT NULL DEFAULT '0',
- `conversations_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
- `register_date` int(10) unsigned NOT NULL DEFAULT '0',
- `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
- `trophy_points` int(10) unsigned NOT NULL DEFAULT '0',
- `alerts_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
- `avatar_date` int(10) unsigned NOT NULL DEFAULT '0',
- `avatar_width` smallint(5) unsigned NOT NULL DEFAULT '0',
- `avatar_height` smallint(5) unsigned NOT NULL DEFAULT '0',
- `gravatar` varchar(120) NOT NULL DEFAULT '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
- `user_state` enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') NOT NULL DEFAULT 'valid',
- `is_moderator` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `is_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `is_banned` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `like_count` int(10) unsigned NOT NULL DEFAULT '0',
- `warning_points` int(10) unsigned NOT NULL DEFAULT '0',
- `is_staff` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`user_id`),
- UNIQUE KEY `username` (`username`),
- KEY `email` (`email`),
- KEY `user_state` (`user_state`),
- KEY `last_activity` (`last_activity`),
- KEY `message_count` (`message_count`),
- KEY `trophy_points` (`trophy_points`),
- KEY `like_count` (`like_count`),
- KEY `register_date` (`register_date`),
- KEY `staff_username` (`is_staff`,`username`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
- --
- -- Contenu de la table `xf_user`
- --
- INSERT 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
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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);
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement