SEO Test

You want to rename your Drupal tables by adding a prefix to them? There are about 57 tables in my MySQL database . Here’s the SQL code that will save you a couple of minutes. To add your own prefix just open up a text editor and use Find and Replace from drupal_ to your_prefix_. Because of additional modules, more tables may exist in your drupal database, just add those manually.

RENAME TABLE access TO drupal_access,
aggregator_category TO drupal_aggregator_category,
aggregator_category_feed TO drupal_aggregator_category_feed,
aggregator_category_item TO drupal_aggregator_category_item,
aggregator_feed TO drupal_aggregator_feed,
aggregator_item TO drupal_aggregator_item,
authmap TO drupal_authmap,
blocks TO drupal_blocks,
blocks_roles TO drupal_blocks_roles,
boxes TO drupal_boxes,
cache TO drupal_cache,
cache_filter TO drupal_cache_filter ,
cache_menu TO drupal_cache_menu ,
cache_page TO drupal_cache_page ,
category TO drupal_category ,
category_cont TO drupal_category_cont ,
category_cont_distant TO drupal_category_cont_distant ,
category_cont_node_types TO drupal_category_cont_node_types ,
category_display TO drupal_category_display ,
category_hierarchy TO drupal_category_hierarchy ,
category_node TO drupal_category_node ,
category_relation TO drupal_category_relation ,
category_synonym TO drupal_category_synonym ,
comments TO drupal_comments ,
files TO drupal_files ,
file_revisions TO drupal_file_revisions ,
filters TO drupal_filters ,
filter_formats TO drupal_filter_formats ,
flood TO drupal_flood ,
history TO drupal_history ,
menu TO drupal_menu ,
node TO drupal_node ,
nodewords TO drupal_nodewords ,
node_access TO drupal_node_access ,
node_comment_statistics TO drupal_node_comment_statistics ,
node_counter TO drupal_node_counter ,
node_revisions TO drupal_node_revisions ,
node_type TO drupal_node_type ,
permission TO drupal_permission ,
role TO drupal_role ,
sequences TO drupal_sequences ,
sessions TO drupal_sessions ,
system TO drupal_system ,
term_data TO drupal_term_data ,
term_hierarchy TO drupal_term_hierarchy ,
term_node TO drupal_term_node ,
term_relation TO drupal_term_relation ,
term_synonym TO drupal_term_synonym ,
tinymce_role TO drupal_tinymce_role ,
tinymce_settings TO drupal_tinymce_settings ,
url_alias TO drupal_url_alias ,
users TO drupal_users ,
users_roles TO drupal_users_roles ,
variable TO drupal_variable ,
vocabulary TO drupal_vocabulary ,
vocabulary_node_types TO drupal_vocabulary_node_types ,
watchdog TO drupal_watchdog ;