# --------------------------------------------------------
#
# Table structure for table 'pbb_users'
#
ALTER TABLE xoops_users
	DROP   user_session_time ,
	DROP   user_session_page ,
	DROP   user_level ,
	DROP   user_style ,
	DROP   user_lang ,
	DROP   user_dateformat ,
	DROP   user_new_privmsg ,
	DROP   user_unread_privmsg ,
	DROP   user_last_privmsg ,
	DROP   user_emailtime ,
	DROP   user_allowhtml ,
	DROP   user_allowbbcode ,
	DROP   user_allowsmile ,
	DROP   user_allowavatar ,
	DROP   user_allow_pm ,
	DROP   user_allow_viewonline ,
	DROP   user_notify ,
	DROP   user_notify_pm ,
	DROP   user_popup_pm ,
	DROP   user_avatar_type ,
	DROP   user_sig_bbcode_uid ,
	DROP   user_newpasswd ,
	DROP   user_lastvisit,	
        DROP   user_bank,
	DROP   user_gender,
	DROP   INDEX user_session_time
;
DELETE FROM users WHERE uname = 'Anonymous';

# --------------------------------------------------------
#
# Table structure for table 'pbb_sessions'
#
ALTER TABLE xoops_session
	DROP   session_user_id ,
	DROP   session_start ,
	DROP   session_page ,
	DROP   session_logged_in ,
	DROP   INDEX session_user_id ,
	DROP   INDEX session_id_ip_user_id
;
DROP TABLE `xoops_pbb_attach_quota`, `xoops_pbb_attachments`, `xoops_pbb_attachments_config`, `xoops_pbb_attachments_desc`, `xoops_pbb_auth_access`, `xoops_pbb_banlist`, `xoops_pbb_cash`, `xoops_pbb_cash_exchange`, `xoops_pbb_cash_log`, `xoops_pbb_categories`, `xoops_pbb_config`, `xoops_pbb_confirm`, `xoops_pbb_disallow`, `xoops_pbb_extension_groups`, `xoops_pbb_extensions`, `xoops_pbb_forbidden_extensions`, `xoops_pbb_forum_prune`, `xoops_pbb_forums`, `xoops_pbb_groups`, `xoops_pbb_posts`, `xoops_pbb_posts_text`, `xoops_pbb_privmsgs`, `xoops_pbb_privmsgs_text`, `xoops_pbb_quota_limits`, `xoops_pbb_search_results`, `xoops_pbb_search_wordlist`, `xoops_pbb_search_wordmatch`, `xoops_pbb_themes`, `xoops_pbb_themes_name`, `xoops_pbb_topics`, `xoops_pbb_topics_watch`, `xoops_pbb_user_group`, `xoops_pbb_vote_desc`, `xoops_pbb_vote_results`, `xoops_pbb_vote_voters`, `xoops_pbb_words`, `xoops_pbb_cash`, `xoops_pbb_cash_events`, `xoops_pbb_cash_exchange`, `xoops_pbb_cash_groups`, `xoops_pbb_cash_log`;