Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS `users`;
- CREATE TABLE `users` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(250) DEFAULT NULL,
- `username` varchar(125) NOT NULL,
- `password` varchar(255) DEFAULT NULL,
- `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
- `auth_ticket` varchar(60) NOT NULL,
- `rank` int(1) unsigned DEFAULT '1',
- `rank_vip` int(1) DEFAULT '0',
- `credits` int(11) DEFAULT '50000',
- `vip_points` int(11) DEFAULT '0',
- `activity_points` int(11) DEFAULT '5000',
- `look` char(255) DEFAULT NULL,
- `gender` enum('M','F') DEFAULT 'M',
- `motto` char(50) DEFAULT NULL,
- `account_created` char(12) DEFAULT '0',
- `last_online` int(11) DEFAULT '0',
- `online` enum('0','1') DEFAULT '0',
- `ip_last` varchar(45) DEFAULT '',
- `ip_reg` varchar(45) DEFAULT NULL,
- `home_room` int(10) DEFAULT '2',
- `is_muted` enum('0','1') DEFAULT '0',
- `block_newfriends` enum('0','1') DEFAULT '0',
- `hide_online` enum('0','1') DEFAULT '0',
- `hide_inroom` enum('0','1') DEFAULT '0',
- `vip` enum('0','1') DEFAULT '0',
- `volume` varchar(15) DEFAULT '100,100,100',
- `last_change` int(20) DEFAULT '0',
- `machine_id` varchar(125) DEFAULT '',
- `focus_preference` enum('0','1') DEFAULT '0',
- `chat_preference` enum('0','1') DEFAULT '0',
- `pets_muted` enum('0','1') DEFAULT '0',
- `bots_muted` enum('0','1') DEFAULT '0',
- `advertising_report_blocked` enum('0','1') DEFAULT '0',
- `gotw_points` int(11) DEFAULT '0',
- `ignore_invites` enum('0','1') DEFAULT '0',
- `time_muted` double DEFAULT '0',
- `allow_gifts` enum('0','1') DEFAULT '1',
- `trading_locked` double DEFAULT '0',
- `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
- `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
- `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
- `publi` enum('0','1','2','3') NOT NULL DEFAULT '0',
- `guia` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
- `tarea` varchar(50) NOT NULL DEFAULT '0',
- `cms_signature` text,
- `cms_currency` int(99) NOT NULL,
- `key_colour` int(11) NOT NULL DEFAULT '0',
- `userpo` int(99) NOT NULL,
- `user_points` int(99) NOT NULL,
- `acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
- `country` text,
- `radio` varchar(100) NOT NULL DEFAULT 'autoplay',
- `bancobloq` int(99) NOT NULL,
- `builder` enum('0','1') DEFAULT '0',
- `croupier` enum('1','0') DEFAULT '0',
- `nux_user` enum('true','false') DEFAULT 'true',
- `pumpkins` int(11) DEFAULT '0',
- `targeted_buy` int(10) NOT NULL,
- `namecolor` varchar(125) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '000000',
- `bonus_points` int(11) NOT NULL,
- `nametag` varchar(125) DEFAULT '',
- PRIMARY KEY (`id`,`auth_ticket`),
- UNIQUE KEY `id` (`id`) USING HASH,
- UNIQUE KEY `username` (`username`) USING BTREE,
- KEY `rank` (`rank`),
- KEY `ip_last` (`ip_last`),
- KEY `ip_reg` (`ip_reg`),
- KEY `credits` (`credits`),
- KEY `activity_points` (`activity_points`),
- KEY `online` (`online`),
- KEY `mail` (`mail`),
- KEY `machine_id` (`machine_id`),
- KEY `auth_ticket` (`auth_ticket`),
- KEY `last_online` (`last_online`),
- KEY `home_room` (`home_room`),
- KEY `rank_vip` (`rank_vip`),
- KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement