Donwload: https://anonfiles.com/R9Z807udu7/smogon.tar_xz


-- MySQL dump 10.16  Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: xenforo
-- ------------------------------------------------------
-- Server version	10.1.29-MariaDB-6

/*!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 utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `xf_user`
--

DROP TABLE IF EXISTS `xf_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xf_user` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(150) NOT NULL,
  `email` varchar(360) NOT NULL,
  `gender` enum('male','female') NOT NULL COMMENT 'Leave empty for "unspecified"',
  `custom_title` varchar(180) DEFAULT NULL,
  `language_id` int(10) unsigned NOT NULL,
  `style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
  `timezone` varchar(150) NOT NULL COMMENT 'Example: "Europe/London"',
  `visible` tinyint(3) unsigned NOT NULL COMMENT 'Show browsing activity to others',
  `user_group_id` int(10) unsigned NOT NULL,
  `secondary_group_ids` varchar(255) NOT NULL,
  `display_style_group_id` int(10) unsigned NOT NULL COMMENT 'User group ID that provides user styling',
  `permission_combination_id` int(10) unsigned NOT NULL,
  `message_count` int(10) unsigned NOT NULL,
  `conversations_unread` smallint(5) unsigned NOT NULL,
  `register_date` int(10) unsigned NOT NULL,
  `last_activity` int(10) unsigned NOT NULL,
  `trophy_points` int(10) unsigned NOT NULL,
  `alerts_unread` smallint(5) unsigned NOT NULL,
  `avatar_date` int(10) unsigned NOT NULL,
  `avatar_width` smallint(5) unsigned NOT NULL,
  `avatar_height` smallint(5) unsigned NOT NULL,
  `gravatar` varchar(360) NOT NULL COMMENT 'If specified, this is an email address corresponding to the user"s "Gravatar"',
  `user_state` enum('valid','email_confirm','email_confirm_edit','moderated') NOT NULL,
  `is_moderator` tinyint(3) unsigned NOT NULL,
  `is_admin` tinyint(3) unsigned NOT NULL,
  `is_banned` tinyint(3) unsigned NOT NULL,
  `like_count` int(10) unsigned NOT NULL,
  `warning_points` int(10) unsigned NOT NULL,
  `is_staff` tinyint(3) unsigned NOT NULL,
  `ps_id` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`),
  KEY `email` (`email`(191)),
  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 AUTO_INCREMENT=423433 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xf_user`
--

LOCK TABLES `xf_user` WRITE;
/*!40000 ALTER TABLE `xf_user` DISABLE KEYS */;
INSERT INTO `xf_user` VALUES (1,'chaos','chris@monsan.to','male','',1,0,'America/New_York',0,2,'3,12,17,19,21,26,27,62,67,332',3,10100,10621,3,1103408700,1505018707,0,0,1431832225,192,211,'','valid',1,1,0,5634,0,1,NULL),(6,'Articuno64','jwynja@uvic.ca','male','1 to 63 were taken',1,0,'America/Los_Angeles',1,2,'12,61,64,67,72,76,84',12,1744,2460,0,1103427780,1393129830,0,10,1415656176,137,150,'','valid',0,0,0,5,0,0,NULL),(10,'ls','cfickle@gmail.com','male','',1,0,'Europe/London',1,2,'12,76,82',12,1745,414,6,1103433480,1217297657,0,1,1416134943,101,76,'','valid',0,0,0,1,0,0,NULL),(11,'skarm','smogonskarm@gmail.com','male','I HAVE HOTEL ROOMS',1,0,'America/Denver',1,2,'12,59,64,67,72,76,84',12,1746,2280,0,1103438700,1391479706,0,7,1415657094,192,192,'','valid',0,0,0,3,0,0,NULL),(12,'Jumpman16','tekky@post.harvard.edu','male','np: Michael Jackson - \"Mon in the Mirror\" (DW mix)',1,0,'America/New_York',1,2,'12,59,62,63,64,71,72,76,84,202',64,5999,4799,78,1103445480,1504449949,0,6,1373303914,100,100,'','valid',0,0,0,336,0,0,NULL),(13,'Curby','flybynite16@yahoo.com','male','',1,0,'Europe/London',1,2,'12,76,83',12,2986,1181,0,1103445600,1202454660,0,1,0,0,0,'','valid',0,0,0,0,0,0,NULL),(14,'havoc','freeway018@yahoo.com','male','pottlepalooza',1,0,'America/Chicago',1,2,'12,59,76,78,83',12,9532,2453,0,1103445900,1420346232,0,21,1396989104,192,208,'','valid',0,0,0,6,0,0,NULL),(15,'andii56','Andii56@aol.com','male','',1,0,'Europe/London',1,2,'',2,2,225,1,1103446190,1334270433,0,3,0,0,0,'','valid',0,0,0,0,0,0,NULL),(16,'Kumar','awwnicks@hotmail.com','male','',1,0,'America/New_York',1,2,'12,62,64,78,82',12,1749,3107,0,1103446320,1459155348,0,5,1416134787,69,89,'','valid',0,0,0,2,0,0,NULL),(17,'Steelicks','danstan_nz@hotmail.com','male','Come here and Battle me!',1,0,'Asia/Irkutsk',1,2,'12,59,76,78,83',12,9532,3767,0,1103446440,1504768044,0,0,1373165059,130,130,'','valid',0,0,0,97,0,0,NULL),(19,'Hipmonlee','clorier@gmail.com','male','Have a rice day',1,0,'Pacific/Auckland',1,2,'12,59,76,78,83,130',12,9533,7376,0,1103446680,1486762291,0,85,1386010998,192,246,'','valid',0,0,0,357,0,0,NULL),(20,'omni','chasqui975@hotmail.com','male','',1,0,'America/Los_Angeles',1,2,'12,59,76,78,83',12,9532,1800,1,1103474040,1287778819,0,2,1416135339,192,192,'','valid',0,0,0,0,0,0,NULL)