phpBB.de

Code: Alles auswählen

CREATE TABLE `SVF_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default NULL,
  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '0',
  `user_notify_pm` tinyint(1) NOT NULL default '1',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_post_sort` tinyint(2) NOT NULL default '0',
  `user_rank` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_geburtsdatum` date default '0000-00-00',
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  `user_javabox` tinyint(1) NOT NULL default '0',
  `user_chat` mediumint(8) NOT NULL default '0',
  `user_irc` tinyint(4) NOT NULL default '1',
  `user_show_posts` tinyint(2) NOT NULL default '20',
  `user_show_topics` tinyint(2) NOT NULL default '30',
  `user_show_650` tinyint(1) NOT NULL default '1',
  `user_show_1000` tinyint(1) NOT NULL default '1',
  `user_ignorstatus` varchar(6) NOT NULL default '000001',
  `user_refreshtime` tinyint(2) NOT NULL default '0',
  `user_default_adress` smallint(6) NOT NULL default '1',
  `user_fr` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`),
  FULLTEXT KEY `username` (`username`)
) TYPE=MyISAM;

#
# Daten für Tabelle `SVF_users`
#

INSERT INTO `SVF_users` VALUES (2151, 1, 'svmatze', '91ce30_geheim_8dd0ca', 1085816138, 44, 1085815498, 1064510527, 0, 6, '1.00', 5, 'german', 'd.m.Y G:i', 0, 0, 1076092176, NULL, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, '', 0, 'adresse@dada.de', '1999-01-01', '', '', 'SVMatze....\r\n\r\n\r\n[url=http://www.pixum.de/viewalbum/?id=2]Mein Mopped[/url]', '', '', '', '', 'Autosattler', '', '', '', 0, 0, 6, 30, 40, 1, 1, '000000', 0, 2029, '7,13,23,10,2,22,15,8,27,1,4,20,6,17,5,21,11,3,19,14,25,12,16,24,26');