ant Posted November 15, 2016 Report Share Posted November 15, 2016 Hello, I just upgraded my install of Revive Adserver: it is running since years now, since it was called phpAdsNew. I ran quite all the upgrades during these years passing the same database through OpenAds, OpenX and finally Revive Adserver. The same install always worked fine, but now I think I have some old database tables that I can simply delete once for all. This is my actual Database structure: ox_accounts ox_account_preference_assoc ox_account_user_assoc ox_account_user_permission_assoc ox_acls ox_acls_channel ox_ad_category_assoc ox_ad_zone_assoc ox_affiliates ox_affiliates_extra ox_agency ox_application_variable ox_audit ox_banners ox_banner_vast_element ox_campaigns ox_campaigns_trackers ox_category ox_channel ox_clients ox_database_action ox_data_bkt_a ox_data_bkt_a_20101007_160828 ox_data_bkt_a_var ox_data_bkt_a_var_20101007_160828 ox_data_bkt_c ox_data_bkt_c_20101007_160828 ox_data_bkt_m ox_data_bkt_m_20101007_160828 ox_data_bkt_r ox_data_bkt_r_20101007_160828 ox_data_bkt_vast_e ox_data_intermediate_ad ox_data_intermediate_ad_connection ox_data_intermediate_ad_variable_value ox_data_raw_ad_click ox_data_raw_ad_impression ox_data_raw_ad_request ox_data_raw_tracker_impression ox_data_raw_tracker_variable_value ox_data_summary_ad_hourly ox_data_summary_ad_zone_assoc ox_data_summary_channel_daily ox_data_summary_zone_impression_history ox_ext_market_advertiser ox_ext_market_assoc_data ox_ext_market_campaign_pref ox_ext_market_general_pref ox_ext_market_plugin_variable ox_ext_market_setting ox_ext_market_stats ox_ext_market_website_pref ox_ext_market_web_stats ox_images ox_log_maintenance_forecasting ox_log_maintenance_priority ox_log_maintenance_statistics ox_password_recovery ox_placement_zone_assoc ox_preferences ox_session ox_stats_vast ox_targetstats ox_trackers ox_tracker_append ox_upgrade_action ox_userlog ox_users ox_variables ox_variable_publisher ox_zones Are all those tables really needed and in use? Could I safely delete some of them? Thank you for your support. Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted November 15, 2016 Report Share Posted November 15, 2016 I see a few tables that appear to have some sort of date/time in their name. Those are not standard. Everything else is required and should not be deleted. Quote Link to comment Share on other sites More sharing options...
ant Posted November 15, 2016 Author Report Share Posted November 15, 2016 All those that ends with " _20101007_160828 ", right? Those ones were the main reason for my question! Thank you Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted December 20, 2016 Report Share Posted December 20, 2016 I think the old "distrubuted mode" code used to create daily tables (or there was an option for daily tables), but that's really old now (and I had a feeling we took distributed mode out of the code - but I could be wrong). I'd have to check to be sure, but that may have been the source of the non-standard tables with dates on the end. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.