-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 5.6.10 - MySQL Community Server (GPL)
-- Server OS: Win64
-- HeidiSQL Version: 7.0.0.4359
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!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' */;
-- Dumping structure for table zapdb.users
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`real_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(50) NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT 'defaultuser@zaphotel.net',
`auth_ticket` text NOT NULL,
`rank` int(11) unsigned NOT NULL DEFAULT '1',
`credits` int(11) NOT NULL DEFAULT '25000',
`vip_points` int(11) NOT NULL DEFAULT '0',
`activity_points` int(11) NOT NULL DEFAULT '0',
`activity_points_lastupdate` double NOT NULL DEFAULT '0',
`look` varchar(500) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
`gender` enum('M','F') NOT NULL DEFAULT 'M',
`motto` varchar(50) NOT NULL DEFAULT 'Zap Newbie',
`about` varchar(65) DEFAULT '',
`account_created` varchar(50) NOT NULL DEFAULT 'NULL',
`last_online` varchar(50) NOT NULL DEFAULT 'Never',
`online` enum('0','1') NOT NULL DEFAULT '0',
`ip_last` varchar(120) NOT NULL,
`ip_reg` varchar(120) NOT NULL,
`home_room` int(10) unsigned NOT NULL DEFAULT '0',
`respect` int(11) NOT NULL DEFAULT '0',
`daily_respect_points` int(11) NOT NULL DEFAULT '5',
`daily_pet_respect_points` int(11) NOT NULL DEFAULT '5',
`newbie_status` int(11) NOT NULL DEFAULT '0',
`is_muted` enum('0','1') NOT NULL DEFAULT '0',
`mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
`mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
`block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
`hide_online` enum('0','1') NOT NULL DEFAULT '0',
`hide_video` enum('0','1') NOT NULL DEFAULT '1',
`hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
`vip` enum('0','1') NOT NULL DEFAULT '0',
`mail_verified` varchar(6) NOT NULL DEFAULT 'true',
`expert` varchar(1) NOT NULL,
`points` int(3) NOT NULL DEFAULT '1',
`temp` int(1) NOT NULL DEFAULT '0',
`forumname` varchar(30) NOT NULL DEFAULT 'NewUser',
`mod_leader` varchar(2) NOT NULL DEFAULT '0',
`adm_leader` varchar(2) NOT NULL DEFAULT '0',
`founder` varchar(1) NOT NULL DEFAULT '0',
`c_h` int(1) NOT NULL DEFAULT '0',
`volume` int(3) NOT NULL DEFAULT '100',
`logged_today` varchar(30) DEFAULT '0',
`has_voted` varchar(30) NOT NULL DEFAULT '0',
`newcrypto` varchar(30) NOT NULL DEFAULT '0',
`lastdailycredits` char(18) NOT NULL DEFAULT '0',
`currentquestid` int(11) NOT NULL DEFAULT '0',
`currentquestprogress` int(11) NOT NULL DEFAULT '0',
`achievement_points` int(11) NOT NULL DEFAULT '0',
`last_offline` varchar(50) DEFAULT '0',
`crystals` int(11) NOT NULL DEFAULT '0',
`block_trade` varchar(30) NOT NULL DEFAULT '0',
`trial_admin` enum('0','1') NOT NULL DEFAULT '0',
`playermod` enum('0','1') NOT NULL DEFAULT '0',
`legend` enum('0','1') NOT NULL DEFAULT '0',
`quests` varchar(200) DEFAULT '',
`queststates` varchar(200) DEFAULT '',
`canchangename` enum('0','1') DEFAULT '0',
`FavoriteGroup` int(11) DEFAULT '0',
`one_password` varchar(500) DEFAULT '',
`datosreg` varchar(500) DEFAULT '',
`country` varchar(500) DEFAULT '',
`facebook_id` varchar(255) DEFAULT '',
`marketing` varchar(1) DEFAULT '',
`showhome` varchar(10) DEFAULT '',
`main` varchar(10) DEFAULT '',
`registered` varchar(10) DEFAULT '',
`lastonline` varchar(10) DEFAULT '',
`passed_quiz` enum('0','1') DEFAULT '1',
`points_online` int(11) DEFAULT '0',
`acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
`acc_pornbanned` enum('0','1') NOT NULL DEFAULT '0',
`position` varchar(50) DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `rank` (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Data exporting was unselected.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;