Kod:
CREATE TABLE `ep_users` (
`user_id` smallint(5) unsigned NOT NULL auto_increment,
`user_name` varchar(30) collate utf8_polish_ci NOT NULL default '',
`user_password` varchar(32) collate utf8_polish_ci NOT NULL default '',
`user_email` varchar(100) collate utf8_polish_ci NOT NULL default '',
`user_hide_email` tinyint(1) unsigned NOT NULL default '1',
`user_location` varchar(50) collate utf8_polish_ci NOT NULL default '',
`user_birthdate` date NOT NULL default '0000-00-00',
`user_aim` varchar(25) collate utf8_polish_ci NOT NULL default '',
`user_icq` varchar(15) collate utf8_polish_ci NOT NULL default '',
`user_msn` varchar(100) collate utf8_polish_ci NOT NULL default '',
`user_yahoo` varchar(100) collate utf8_polish_ci NOT NULL default '',
`user_web` varchar(200) collate utf8_polish_ci NOT NULL default '',
`user_theme` varchar(100) collate utf8_polish_ci NOT NULL default 'Default',
`user_offset` char(3) collate utf8_polish_ci NOT NULL default '0',
`user_avatar` varchar(100) collate utf8_polish_ci NOT NULL default '',
`user_sig` text collate utf8_polish_ci NOT NULL,
`user_posts` smallint(5) unsigned NOT NULL default '0',
`user_joined` int(10) unsigned NOT NULL default '0',
`user_lastvisit` int(10) unsigned NOT NULL default '0',
`user_ip` varchar(20) collate utf8_polish_ci NOT NULL default '0.0.0.0',
`user_rights` text collate utf8_polish_ci NOT NULL,
`user_groups` text collate utf8_polish_ci NOT NULL,
`user_level` tinyint(3) unsigned NOT NULL default '101',
`user_status` tinyint(1) unsigned NOT NULL default '0',
`user_prefix` char(3) collate utf8_polish_ci NOT NULL default '~',
`user_color` varchar(6) collate utf8_polish_ci NOT NULL default '',
`user_adds` tinyint(4) NOT NULL default '0',
`user_email_act` tinyint(1) NOT NULL default '0',
`user_rang` varchar(30) collate utf8_polish_ci NOT NULL default '',
`user_points` smallint(5) default '0',
`points_normal` smallint(5) default '0',
`points_bonus` smallint(5) default '0',
`points_punishment` smallint(5) default '0',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=3 ;
INSERT INTO `ep_users` (`user_id`, `user_name`, `user_password`, `user_email`, `user_hide_email`, `user_location`, `user_birthdate`, `user_aim`, `user_icq`, `user_msn`, `user_yahoo`, `user_web`, `user_theme`, `user_offset`, `user_avatar`, `user_sig`, `user_posts`, `user_joined`, `user_lastvisit`, `user_ip`, `user_rights`, `user_groups`, `user_level`, `user_status`, `user_prefix`, `user_color`, `user_adds`, `user_email_act`, `user_rang`, `user_points`, `points_normal`, `points_bonus`, `points_punishment`) VALUES
(1, 'admin', '8b68fd901b30324da2a8d4d56ef57124', '[email protected]', 1, '', '0000-00-00', '', '', '', '', '', 'Default', '0', '', '', 0, 1207764554, 1210200499, '79.185.209.158', 'A.AC.AD.B.BP.C.CA.CO.CP.DB.DC.D.EP.FQ.FR.F.FU.IM.I.IP.M.N.NC.P.PH.PI.PO.RG.RS.S.SL.S1.S2.S3.S4.S5.S6.S7.SU.UG.U.W.WC', '', 103, 0, '@', 'F75013', 0, 1, '', 0, -5, 0, 0),
(2, 'test', '8b68fd901b30324da2a8d4d56ef57124', '[email protected]', 0, '', '0000-00-00', '', '', '', '', '', 'Default', '0', '', '', 0, 1208009333, 1208009384, '87.206.132.2', '', '', 101, 0, '~', '', 0, 0, '', 0, 0, 0, 0);
Hasła nie są przechowywane w jawny sposób, są podwójnie hashowane algorytmem md5 jako dane tekstowe.