table names / think we got extra's

Support for IntegraMOD 141

Moderator: Integra Moderator

table names / think we got extra's

PostAuthor: viragotech » Tue Oct 05, 2010 8:43 pm

Ever since I can member our DB has had a bunch of extra tables, never questioned it till now. only the phpBB tables are whats used right?
$table_prefix = 'phpbb_';

Do I have a bunch of unneeded tables, no clue where they came from if so.

address_book
address_format
banners
banners_history
categories
categories_description
configuration
configuration_group
counter
counter_history
countries
currencies
customers
customers_basket
customers_basket_attributes
customers_info
geo_zones
languages
manufacturers
manufacturers_info
newsletters
orders
orders_products
orders_products_attributes
orders_products_download
orders_status
orders_status_history
orders_total
phpbb_account_hist
phpbb_acronyms
phpbb_album
phpbb_album_cat
phpbb_album_comment
phpbb_album_config
phpbb_album_rate
phpbb_approve_forums
phpbb_approve_posts
phpbb_approve_topics
phpbb_approve_users
phpbb_attachments
phpbb_attachments_config
phpbb_attachments_desc
phpbb_attach_quota
phpbb_auth_access
phpbb_banlist
phpbb_banner
phpbb_banner_stats
phpbb_blocks
phpbb_block_position
phpbb_block_variable
phpbb_bookmarks
phpbb_bots
phpbb_buddy
phpbb_captcha_config
phpbb_cash
phpbb_cash_events
phpbb_cash_exchange
phpbb_cash_groups
phpbb_cash_log
phpbb_categories
phpbb_chatbox
phpbb_chatbox_session
phpbb_chatspot_messages
phpbb_chatspot_rooms
phpbb_chatspot_sessions
phpbb_config
phpbb_config_pcp_update_backup
phpbb_confirm
phpbb_contact_list
phpbb_ctracker_backup
phpbb_ctracker_config
phpbb_ctracker_filechk
phpbb_ctracker_filescanner
phpbb_ctracker_ipblocker
phpbb_ctracker_loginhistory
phpbb_digest
phpbb_digest_forums
phpbb_disallow
phpbb_email_users
phpbb_extensions
phpbb_extension_groups
phpbb_flags
phpbb_forbidden_extensions
phpbb_force_read
phpbb_force_read_users
phpbb_forums
phpbb_forum_prune
phpbb_forum_tour
phpbb_groups
phpbb_hacks_list
phpbb_im_config
phpbb_im_prefs
phpbb_im_sessions
phpbb_im_sites
phpbb_ip_tracking
phpbb_ip_tracking_config
phpbb_jr_admin_users
phpbb_kb_articles
phpbb_kb_categories
phpbb_kb_config
phpbb_kb_custom
phpbb_kb_customdata
phpbb_kb_results
phpbb_kb_types
phpbb_kb_votes
phpbb_kb_wordlist
phpbb_kb_wordmatch
phpbb_layout
phpbb_links
phpbb_link_categories
phpbb_link_config
phpbb_modules
phpbb_module_admin_panel
phpbb_module_cache
phpbb_module_group_auth
phpbb_module_info
phpbb_news
phpbb_optimize_db
phpbb_pa_auth
phpbb_pa_cat
phpbb_pa_comments
phpbb_pa_config
phpbb_pa_custom
phpbb_pa_customdata
phpbb_pa_download_info
phpbb_pa_files
phpbb_pa_license
phpbb_pa_mirrors
phpbb_pa_votes
phpbb_phpBBSecurity
phpbb_portal_config
phpbb_posts
phpbb_posts_text
phpbb_privmsgs
phpbb_privmsgs_archive
phpbb_privmsgs_text
phpbb_quota_limits
phpbb_ranks
phpbb_rating
phpbb_rating_bias
phpbb_rating_config
phpbb_rating_option
phpbb_rating_rank
phpbb_rating_temp
phpbb_referers
phpbb_rules
phpbb_search_rebuild
phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch
phpbb_serverload
phpbb_sessions
phpbb_sessions_keys
phpbb_shout
phpbb_smilies
phpbb_spelling_words
phpbb_stats_config
phpbb_stats_smilies_index
phpbb_stats_smilies_info
phpbb_themes
phpbb_themes_name
phpbb_themes_select_info
phpbb_topics
phpbb_topics_watch
phpbb_users
phpbb_user_group
phpbb_vote_desc
phpbb_vote_results
phpbb_vote_voters
phpbb_words
phpbb_wpm
products
products_attributes
products_attributes_download
products_description
products_notifications
products_options
products_options_values
products_options_values_to_products_options
products_to_categories
reviews
reviews_description
sessions
specials
tax_class
tax_rates
whos_online
zones
zones_to_geo_zones
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: table names / think we got extra's

PostAuthor: Helter » Wed Oct 06, 2010 1:48 am

yes, unless you specify for the install to use a different table prefix, it will use phpbb_ and it will not mix prefixes. Some mods do not adhere to this standard though so the other tables are probably from mods you added to your 132 or 140 sites
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4168
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 187.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: table names / think we got extra's

PostAuthor: viragotech » Wed Oct 06, 2010 10:29 am

Well I have no idea where those came from, I never did much with the 132-140 forum, I left them as is stock, never even installed more skins. To limit the chance of fouling things up. Which might explain why I don't know as much as I should by now, as I kinda just left things along to their own devices.

Thats always why I chose IM, lots of cool mods with little skill to get up and running <img>

reg phpBB stuff was stripped down no fun stuff.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00


Return to IntegraMOD 141

Who is online

Registered users: Bing [Bot], Google [Bot], Helter, Majestic-12 [Bot]