Hello everyone,
Is there documentation on mySQL table names and the SQL creation command for OJS version 2.4.8-1?
I have some performance issues in DB and I noticed that there are 170 tables. This installation is old and has been administrated by several sysadmins.
The tables in my installation are:
mysql> show tables;
Tables_in_myOJS2.4
+---------------------------------------+
access_keys
announcement_settings
announcement_type_settings
announcement_types
announcements
article_author_settings
article_authors
article_comments
article_email_log
article_event_log
article_files
article_galley_settings
article_galleys
article_galleys_stats_migration
article_html_galley_images
article_notes
article_search_keyword_list
article_search_object_keywords
article_search_objects
article_settings
article_supp_file_settings
article_supplementary_files
article_xml_galleys
articles
auth_sources
author_settings
authors
books_for_review
books_for_review_authors
books_for_review_settings
captchas
citation_settings
citations
comments
completed_payments
controlled_vocab_entries
controlled_vocab_entry_settings
controlled_vocabs
custom_issue_orders
custom_section_orders
data_object_tombstone_oai_set_objects
data_object_tombstone_settings
data_object_tombstones
dataverse_files
dataverse_studies
edit_assignments
edit_decisions
email_log
email_log_users
email_templates
email_templates_data
email_templates_default
email_templates_default_data
event_log
event_log_settings
external_feed_settings
external_feeds
filter_groups
filter_settings
filters
gifts
group_memberships
group_settings
groups
institutional_subscription_ip
institutional_subscriptions
issue_files
issue_galley_settings
issue_galleys
issue_settings
issues
journal_settings
journals
metadata_description_settings
metadata_descriptions
metrics
mutex
notes
notification_mail_list
notification_settings
notification_subscription_settings
notifications
oai_resumption_tokens
object_for_review_assignments
object_for_review_persons
object_for_review_settings
objects_for_review
paypal_transactions
phpmv_a_category
phpmv_a_config
phpmv_a_file
phpmv_a_keyword
phpmv_a_newsletter
phpmv_a_page
phpmv_a_partner_name
phpmv_a_partner_url
phpmv_a_provider
phpmv_a_resolution
phpmv_a_search_engine
phpmv_a_site
phpmv_a_vars_name
phpmv_a_vars_value
phpmv_archives
phpmv_category
phpmv_groups
phpmv_ip_ignore
phpmv_link_vp
phpmv_link_vpv
phpmv_newsletter
phpmv_page
phpmv_page_md5url
phpmv_page_url
phpmv_pdf_config
phpmv_pdf_site_user
phpmv_plugin_version
phpmv_query_log
phpmv_site
phpmv_site_partner
phpmv_site_partner_url
phpmv_site_url
phpmv_users
phpmv_users_link_groups
phpmv_vars
phpmv_version
phpmv_visit
pln_deposit_objects
pln_deposits
plugin_settings
processes
published_articles
published_articles_stats_migration
queued_payments
referral_settings
referrals
review_assignments
review_form_element_settings
review_form_elements
review_form_responses
review_form_settings
review_forms
review_object_metadata
review_object_metadata_settings
review_object_type_settings
review_object_types
review_rounds
roles
rt_contexts
rt_searches
rt_versions
scheduled_tasks
section_editors
section_settings
sections
sessions
signoffs
site
site_settings
static_page_settings
static_pages
subscription_type_settings
subscription_types
subscriptions
temporary_files
theses
tmp_public_galley_ids
usage_stats_temporary_records
user_interests
user_settings
users
versions
170 rows in set (0.00 sec)
Regards,
Renato