Code:
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 */;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`old_password` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`passhash` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`secret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`email` varchar(80) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`status` enum('pending','confirmed') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'pending',
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_catchup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editsecret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`privacy` enum('normal','strong') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'normal',
`stylesheet` int(10) DEFAULT '1',
`info` text CHARACTER SET latin1 COLLATE latin1_general_ci,
`acceptpms` enum('yes','friends','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`class` tinyint(2) unsigned NOT NULL DEFAULT '1',
`avatar` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`title` varchar(60) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`country` int(10) unsigned NOT NULL DEFAULT '0',
`notifs` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`modcomment` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
`disable_reason` text NOT NULL,
`imunity` enum('yes','no') NOT NULL DEFAULT 'no',
`avatars` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`donor` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`warned` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`warneduntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`torrentsperpage` int(3) unsigned NOT NULL DEFAULT '0',
`topicsperpage` int(3) unsigned NOT NULL DEFAULT '0',
`postsperpage` int(3) unsigned NOT NULL DEFAULT '0',
`deletepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`savepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`parked` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`announce` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`passkey` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`last_browse` int(11) NOT NULL DEFAULT '0',
`last_browsex` int(11) NOT NULL DEFAULT '0',
`last_browsem` int(11) NOT NULL DEFAULT '0',
`fader` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`fadecolor` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'FF0000',
`support` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`supportfor` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`supportlang` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`invited_by` int(10) NOT NULL DEFAULT '0',
`invitees` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`totalinvite` int(10) unsigned NOT NULL DEFAULT '0',
`invites` int(1) NOT NULL DEFAULT '0',
`gender` enum('Male','Female','N/A') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N/A',
`invitedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`view_adult` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_music` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_adult_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_music_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_musiclo_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_musicvi_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_musicpks_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`advertisename` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`signatures` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`signature` varchar(225) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`uploadpos` enum('yes','no') NOT NULL DEFAULT 'no',
`downloadpos` enum('yes','no') NOT NULL DEFAULT 'yes',
`forumpost` enum('yes','no') NOT NULL DEFAULT 'yes',
`chatpost` enum('yes','no') NOT NULL DEFAULT 'no',
`chatdisable` enum('yes','no') NOT NULL DEFAULT 'no',
`donated` decimal(8,2) NOT NULL DEFAULT '0.00',
`last_pm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_comment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_post` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`forum_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_staffmsg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`timezone` smallint(3) NOT NULL DEFAULT '120',
`dst` tinyint(2) NOT NULL DEFAULT '0',
`commentpm` enum('yes','no') NOT NULL DEFAULT 'yes',
`staff_chat_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`groups` int(10) unsigned NOT NULL DEFAULT '0',
`rangclass` int(10) unsigned NOT NULL DEFAULT '0',
`zodiac` int(10) unsigned NOT NULL DEFAULT '0',
`donoruntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`total_donated` decimal(8,2) NOT NULL DEFAULT '0.00',
`last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`leechwarn` enum('yes','no') NOT NULL DEFAULT 'no',
`cell` varchar(255) NOT NULL DEFAULT '',
`tenpercent` enum('yes','no') NOT NULL DEFAULT 'no',
`seedbonus` decimal(5,1) NOT NULL DEFAULT '0.0',
`bonuscomment` text,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `status_added` (`status`,`added`),
KEY `ip` (`ip`),
KEY `uploaded` (`uploaded`),
KEY `downloaded` (`downloaded`),
KEY `country` (`country`),
KEY `last_access` (`last_access`),
KEY `warned` (`warned`),
KEY `passkey` (`passkey`),
KEY `id` (`id`,`username`,`old_password`,`passhash`,`secret`),
KEY `stylesheet` (`stylesheet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=121 ;
--
-- Daten für Tabelle `users`
--
INSERT INTO `users` (`id`, `username`, `old_password`, `passhash`, `secret`, `email`, `status`, `added`, `last_login`, `last_access`, `last_catchup`, `editsecret`, `privacy`, `stylesheet`, `info`, `acceptpms`, `ip`, `class`, `avatar`, `uploaded`, `downloaded`, `title`, `country`, `notifs`, `modcomment`, `enabled`, `disable_reason`, `imunity`, `avatars`, `donor`, `warned`, `warneduntil`, `torrentsperpage`, `topicsperpage`, `postsperpage`, `deletepms`, `savepms`, `parked`, `announce`, `passkey`, `last_browse`, `last_browsex`, `last_browsem`, `fader`, `fadecolor`, `support`, `supportfor`, `supportlang`, `invited_by`, `invitees`, `totalinvite`, `invites`, `gender`, `invitedate`, `view_adult`, `view_music`, `view_adult_browse`, `view_music_browse`, `view_musiclo_browse`, `view_musicvi_browse`, `view_musicpks_browse`, `advertisename`, `signatures`, `signature`, `uploadpos`, `downloadpos`, `forumpost`, `chatpost`, `chatdisable`, `donated`, `last_pm`, `last_comment`, `last_post`, `forum_access`, `last_staffmsg`, `timezone`, `dst`, `commentpm`, `staff_chat_access`, `groups`, `rangclass`, `zodiac`, `donoruntil`, `total_donated`, `last_check`, `leechwarn`, `cell`, `tenpercent`, `seedbonus`, `bonuscomment`) VALUES
(1, 'Admin', '', '805ea6f2bc4228dc63747f7915d107d8', '„éá×dM˜Ï€A\nAw~â†x', 'admin@blabla.com', 'confirmed', '2014-05-19 14:41:30', '0000-00-00 00:00:00', '2014-05-19 14:41:30', '0000-00-00 00:00:00', '', 'normal', 1, NULL, 'yes', '', 15, '', 0, 0, '', 0, '', '', 'yes', '', 'no', 'yes', 'no', 'no', '0000-00-00 00:00:00', 0, 0, 0, 'yes', 'no', 'no', 'yes', '', 0, 0, 0, 'yes', 'FF0000', 'no', '', '', 0, '', 0, 0, 'N/A', '0000-00-00 00:00:00', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', '', 'no', 'yes', 'yes', 'no', 'no', 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 120, 0, 'yes', '0000-00-00 00:00:00', 0, 0, 0, '0000-00-00 00:00:00', 0.00, '0000-00-00 00:00:00', 'no', '', 'no', 0.0, NULL);
/*!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 */;