backup

--
-- 資料表格式： `user`
--

CREATE TABLE `user` (
`uid` int(10) NOT NULL auto_increment,
`username` varchar(20) NOT NULL,
`salt` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`email` varchar(255) NOT NULL,
`login_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`auth_type` tinyint(4) NOT NULL,
`addr` varchar(255) NOT NULL,
PRIMARY KEY  (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;