1-- tiki_convert_myisam_to_innodb.sql 2-- Script to convert a Tiki database from MyISAM to InnoDB 3-- Make sure you take a full backup and disable the MySQL fulltext search option if needed in Tiki before running this script 4-- 5-- DROP all FULLTEXT indexes 6-- If you are running MySQL 5.5 or before, InnoDB does not supports fulltext indexes. 7-- Then this section should be uncommented 8 9-- ALTER TABLE tiki_articles DROP INDEX ft; 10-- ALTER TABLE tiki_blog_posts DROP INDEX ft; 11-- ALTER TABLE tiki_blogs DROP INDEX ft; 12-- ALTER TABLE tiki_calendar_items DROP INDEX ft; 13-- ALTER TABLE tiki_comments DROP INDEX ft; 14-- ALTER TABLE tiki_directory_sites DROP INDEX ft; 15-- ALTER TABLE tiki_faq_questions DROP INDEX ft; 16-- ALTER TABLE tiki_faqs DROP INDEX ft; 17-- ALTER TABLE tiki_files DROP INDEX ft; 18-- ALTER TABLE tiki_galleries DROP INDEX ft; 19-- ALTER TABLE tiki_images DROP INDEX ft; 20-- ALTER TABLE tiki_pages DROP INDEX ft; 21-- ALTER TABLE tiki_tracker_item_fields DROP INDEX ft; 22 23-- Convert engine type to InnoDB 24ALTER TABLE `messu_archive` ENGINE=InnoDB; 25ALTER TABLE `messu_messages` ENGINE=InnoDB; 26ALTER TABLE `messu_sent` ENGINE=InnoDB; 27-- ALTER TABLE `metrics_assigned` ENGINE=InnoDB; 28-- ALTER TABLE `metrics_metric` ENGINE=InnoDB; 29-- ALTER TABLE `metrics_tab` ENGINE=InnoDB; 30ALTER TABLE `sessions` ENGINE=InnoDB; 31ALTER TABLE `tiki_acct_account` ENGINE=InnoDB; 32ALTER TABLE `tiki_acct_bankaccount` ENGINE=InnoDB; 33ALTER TABLE `tiki_acct_book` ENGINE=InnoDB; 34ALTER TABLE `tiki_acct_item` ENGINE=InnoDB; 35ALTER TABLE `tiki_acct_journal` ENGINE=InnoDB; 36ALTER TABLE `tiki_acct_stack` ENGINE=InnoDB; 37ALTER TABLE `tiki_acct_stackitem` ENGINE=InnoDB; 38ALTER TABLE `tiki_acct_statement` ENGINE=InnoDB; 39ALTER TABLE `tiki_acct_tax` ENGINE=InnoDB; 40ALTER TABLE `tiki_actionlog` ENGINE=InnoDB; 41ALTER TABLE `tiki_actionlog_conf` ENGINE=InnoDB; 42ALTER TABLE `tiki_actionlog_params` ENGINE=InnoDB; 43ALTER TABLE `tiki_activity_stream` ENGINE=InnoDB; 44ALTER TABLE `tiki_activity_stream_mapping` ENGINE=InnoDB; 45ALTER TABLE `tiki_activity_stream_rules` ENGINE=InnoDB; 46ALTER TABLE `tiki_areas` ENGINE=InnoDB; 47ALTER TABLE `tiki_article_types` ENGINE=InnoDB; 48ALTER TABLE `tiki_articles` ENGINE=InnoDB; 49ALTER TABLE `tiki_auth_tokens` ENGINE=InnoDB; 50ALTER TABLE `tiki_banners` ENGINE=InnoDB; 51ALTER TABLE `tiki_banning` ENGINE=InnoDB; 52ALTER TABLE `tiki_banning_sections` ENGINE=InnoDB; 53ALTER TABLE `tiki_blog_activity` ENGINE=InnoDB; 54ALTER TABLE `tiki_blog_posts` ENGINE=InnoDB; 55ALTER TABLE `tiki_blog_posts_images` ENGINE=InnoDB; 56ALTER TABLE `tiki_blogs` ENGINE=InnoDB; 57ALTER TABLE `tiki_calendar_categories` ENGINE=InnoDB; 58ALTER TABLE `tiki_calendar_items` ENGINE=InnoDB; 59ALTER TABLE `tiki_calendar_locations` ENGINE=InnoDB; 60ALTER TABLE `tiki_calendar_options` ENGINE=InnoDB; 61ALTER TABLE `tiki_calendar_recurrence` ENGINE=InnoDB; 62ALTER TABLE `tiki_calendar_roles` ENGINE=InnoDB; 63ALTER TABLE `tiki_calendars` ENGINE=InnoDB; 64ALTER TABLE `tiki_cart_inventory_hold` ENGINE=InnoDB; 65ALTER TABLE `tiki_categories` ENGINE=InnoDB; 66ALTER TABLE `tiki_categories_roles` ENGINE = InnoDB; 67ALTER TABLE `tiki_categories_roles_available` ENGINE = InnoDB; 68ALTER TABLE `tiki_categorized_objects` ENGINE=InnoDB; 69ALTER TABLE `tiki_category_objects` ENGINE=InnoDB; 70ALTER TABLE `tiki_category_sites` ENGINE=InnoDB; 71-- ALTER TABLE `tiki_chart_items` ENGINE=InnoDB; 72-- ALTER TABLE `tiki_charts` ENGINE=InnoDB; 73-- ALTER TABLE `tiki_charts_rankings` ENGINE=InnoDB; 74-- ALTER TABLE `tiki_charts_votes` ENGINE=InnoDB; 75ALTER TABLE `tiki_chat_channels` ENGINE=InnoDB; 76ALTER TABLE `tiki_chat_messages` ENGINE=InnoDB; 77ALTER TABLE `tiki_chat_users` ENGINE=InnoDB; 78ALTER TABLE `tiki_comments` ENGINE=InnoDB; 79ALTER TABLE `tiki_connect` ENGINE=InnoDB; 80ALTER TABLE `tiki_content` ENGINE=InnoDB; 81ALTER TABLE `tiki_content_templates` ENGINE=InnoDB; 82ALTER TABLE `tiki_content_templates_sections` ENGINE=InnoDB; 83ALTER TABLE `tiki_contributions` ENGINE=InnoDB; 84ALTER TABLE `tiki_contributions_assigned` ENGINE=InnoDB; 85ALTER TABLE `tiki_cookies` ENGINE=InnoDB; 86ALTER TABLE `tiki_copyrights` ENGINE=InnoDB; 87ALTER TABLE `tiki_credits` ENGINE=InnoDB; 88ALTER TABLE `tiki_credits_types` ENGINE=InnoDB; 89ALTER TABLE `tiki_credits_usage` ENGINE=InnoDB; 90ALTER TABLE `tiki_db_status` ENGINE=InnoDB; 91ALTER TABLE `tiki_directory_categories` ENGINE=InnoDB; 92ALTER TABLE `tiki_directory_search` ENGINE=InnoDB; 93ALTER TABLE `tiki_directory_sites` ENGINE=InnoDB; 94ALTER TABLE `tiki_discount` ENGINE=InnoDB; 95ALTER TABLE `tiki_download` ENGINE=InnoDB; 96-- ALTER TABLE `tiki_drawings` ENGINE=InnoDB; 97ALTER TABLE `tiki_dsn` ENGINE=InnoDB; 98ALTER TABLE `tiki_dynamic_variables` ENGINE=InnoDB; 99-- ALTER TABLE `tiki_eph` ENGINE=InnoDB; 100-- ALTER TABLE `tiki_event_subscriptions` ENGINE=InnoDB; 101ALTER TABLE `tiki_extwiki` ENGINE=InnoDB; 102ALTER TABLE `tiki_faq_questions` ENGINE=InnoDB; 103ALTER TABLE `tiki_faqs` ENGINE=InnoDB; 104ALTER TABLE `tiki_feature` ENGINE=InnoDB; 105ALTER TABLE `tiki_featured_links` ENGINE=InnoDB; 106ALTER TABLE `tiki_file_backlinks` ENGINE=InnoDB; 107ALTER TABLE `tiki_file_drafts` ENGINE=InnoDB; 108ALTER TABLE `tiki_file_galleries` ENGINE=InnoDB; 109ALTER TABLE `tiki_file_handlers` ENGINE=InnoDB; 110ALTER TABLE `tiki_files` ENGINE=InnoDB; 111ALTER TABLE `tiki_file_drafts` ENGINE=InnoDB; 112ALTER TABLE `tiki_forum_attachments` ENGINE=InnoDB; 113ALTER TABLE `tiki_forum_reads` ENGINE=InnoDB; 114ALTER TABLE `tiki_forums` ENGINE=InnoDB; 115ALTER TABLE `tiki_forums_queue` ENGINE=InnoDB; 116ALTER TABLE `tiki_forums_reported` ENGINE=InnoDB; 117ALTER TABLE `tiki_freetagged_objects` ENGINE=InnoDB; 118ALTER TABLE `tiki_freetags` ENGINE=InnoDB; 119ALTER TABLE `tiki_galleries` ENGINE=InnoDB; 120ALTER TABLE `tiki_galleries_scales` ENGINE=InnoDB; 121ALTER TABLE `tiki_group_inclusion` ENGINE=InnoDB; 122ALTER TABLE `tiki_group_watches` ENGINE=InnoDB; 123ALTER TABLE `tiki_groupalert` ENGINE=InnoDB; 124ALTER TABLE `tiki_h5p_contents` ENGINE=InnoDB; 125ALTER TABLE `tiki_h5p_contents_libraries` ENGINE=InnoDB; 126ALTER TABLE `tiki_h5p_libraries` ENGINE=InnoDB; 127ALTER TABLE `tiki_h5p_libraries_cachedassets` ENGINE=InnoDB; 128ALTER TABLE `tiki_h5p_libraries_hub_cache` ENGINE=InnoDB; 129ALTER TABLE `tiki_h5p_libraries_libraries` ENGINE=InnoDB; 130ALTER TABLE `tiki_h5p_libraries_languages` ENGINE=InnoDB; 131ALTER TABLE `tiki_h5p_results` ENGINE=InnoDB; 132ALTER TABLE `tiki_h5p_tmpfiles` ENGINE=InnoDB; 133ALTER TABLE `tiki_history` ENGINE=InnoDB; 134ALTER TABLE `tiki_hotwords` ENGINE=InnoDB; 135ALTER TABLE `tiki_html_pages` ENGINE=InnoDB; 136ALTER TABLE `tiki_html_pages_dynamic_zones` ENGINE=InnoDB; 137ALTER TABLE `tiki_images` ENGINE=InnoDB; 138ALTER TABLE `tiki_images_data` ENGINE=InnoDB; 139ALTER TABLE `tiki_integrator_reps` ENGINE=InnoDB; 140ALTER TABLE `tiki_integrator_rules` ENGINE=InnoDB; 141ALTER TABLE `tiki_invite` ENGINE=InnoDB; 142ALTER TABLE `tiki_invited` ENGINE=InnoDB; 143ALTER TABLE `tiki_language` ENGINE=InnoDB; 144ALTER TABLE `tiki_link_cache` ENGINE=InnoDB; 145ALTER TABLE `tiki_links` ENGINE=InnoDB; 146ALTER TABLE `tiki_live_support_events` ENGINE=InnoDB; 147ALTER TABLE `tiki_live_support_message_comments` ENGINE=InnoDB; 148ALTER TABLE `tiki_live_support_messages` ENGINE=InnoDB; 149ALTER TABLE `tiki_live_support_modules` ENGINE=InnoDB; 150ALTER TABLE `tiki_live_support_operators` ENGINE=InnoDB; 151ALTER TABLE `tiki_live_support_requests` ENGINE=InnoDB; 152ALTER TABLE `tiki_logs` ENGINE=InnoDB; 153ALTER TABLE `tiki_mail_events` ENGINE=InnoDB; 154ALTER TABLE `tiki_mail_queue` ENGINE=InnoDB; 155ALTER TABLE `tiki_mailin_accounts` ENGINE=InnoDB; 156ALTER TABLE `tiki_menu_languages` ENGINE=InnoDB; 157ALTER TABLE `tiki_menu_options` ENGINE=InnoDB; 158ALTER TABLE `tiki_menus` ENGINE=InnoDB; 159ALTER TABLE `tiki_minical_events` ENGINE=InnoDB; 160ALTER TABLE `tiki_minical_topics` ENGINE=InnoDB; 161ALTER TABLE `tiki_minichat` ENGINE=InnoDB; 162ALTER TABLE `tiki_modules` ENGINE=InnoDB; 163-- ALTER TABLE `tiki_mypage` ENGINE=InnoDB; 164-- ALTER TABLE `tiki_mypage_types` ENGINE=InnoDB; 165-- ALTER TABLE `tiki_mypage_types_components` ENGINE=InnoDB; 166-- ALTER TABLE `tiki_mypagewin` ENGINE=InnoDB; 167ALTER TABLE `tiki_newsletter_groups` ENGINE=InnoDB; 168ALTER TABLE `tiki_newsletter_included` ENGINE=InnoDB; 169ALTER TABLE `tiki_newsletter_pages` ENGINE=InnoDB; 170ALTER TABLE `tiki_newsletter_subscriptions` ENGINE=InnoDB; 171ALTER TABLE `tiki_newsletters` ENGINE=InnoDB; 172-- ALTER TABLE `tiki_newsreader_marks` ENGINE=InnoDB; 173-- ALTER TABLE `tiki_newsreader_servers` ENGINE=InnoDB; 174ALTER TABLE `tiki_object_attributes` ENGINE=InnoDB; 175ALTER TABLE `tiki_object_ratings` ENGINE=InnoDB; 176ALTER TABLE `tiki_object_relations` ENGINE=InnoDB; 177ALTER TABLE `tiki_object_scores` ENGINE=InnoDB; 178ALTER TABLE `tiki_objects` ENGINE=InnoDB; 179-- ALTER TABLE `tiki_page_drafts` ENGINE=InnoDB; 180ALTER TABLE `tiki_page_footnotes` ENGINE=InnoDB; 181ALTER TABLE `tiki_page_references` ENGINE=InnoDB; 182ALTER TABLE `tiki_pages` ENGINE=InnoDB; 183ALTER TABLE `tiki_pages_changes` ENGINE=InnoDB; 184ALTER TABLE `tiki_pages_translation_bits` ENGINE=InnoDB; 185ALTER TABLE `tiki_pageviews` ENGINE=InnoDB; 186ALTER TABLE `tiki_payment_received` ENGINE=InnoDB; 187ALTER TABLE `tiki_payment_requests` ENGINE=InnoDB; 188ALTER TABLE `tiki_perspective_preferences` ENGINE=InnoDB; 189ALTER TABLE `tiki_perspectives` ENGINE=InnoDB; 190ALTER TABLE `tiki_plugin_security` ENGINE=InnoDB; 191ALTER TABLE `tiki_poll_objects` ENGINE=InnoDB; 192ALTER TABLE `tiki_poll_options` ENGINE=InnoDB; 193ALTER TABLE `tiki_polls` ENGINE=InnoDB; 194ALTER TABLE `tiki_preferences` ENGINE=InnoDB; 195ALTER TABLE `tiki_private_messages` ENGINE=InnoDB; 196ALTER TABLE `tiki_profile_symbols` ENGINE=InnoDB; 197ALTER TABLE `tiki_programmed_content` ENGINE=InnoDB; 198ALTER TABLE `tiki_queue` ENGINE=InnoDB; 199-- ALTER TABLE `tiki_quicktags` ENGINE=InnoDB; 200ALTER TABLE `tiki_quiz_question_options` ENGINE=InnoDB; 201ALTER TABLE `tiki_quiz_questions` ENGINE=InnoDB; 202ALTER TABLE `tiki_quiz_results` ENGINE=InnoDB; 203ALTER TABLE `tiki_quiz_stats` ENGINE=InnoDB; 204ALTER TABLE `tiki_quiz_stats_sum` ENGINE=InnoDB; 205ALTER TABLE `tiki_quizzes` ENGINE=InnoDB; 206ALTER TABLE `tiki_rating_configs` ENGINE=InnoDB; 207ALTER TABLE `tiki_rating_obtained` ENGINE=InnoDB; 208ALTER TABLE `tiki_received_articles` ENGINE=InnoDB; 209ALTER TABLE `tiki_received_pages` ENGINE=InnoDB; 210ALTER TABLE `tiki_referer_stats` ENGINE=InnoDB; 211ALTER TABLE `tiki_registration_fields` ENGINE=InnoDB; 212ALTER TABLE `tiki_related_categories` ENGINE=InnoDB; 213ALTER TABLE `tiki_rss_feeds` ENGINE=InnoDB; 214ALTER TABLE `tiki_rss_items` ENGINE=InnoDB; 215ALTER TABLE `tiki_rss_modules` ENGINE=InnoDB; 216ALTER TABLE `tiki_schema` ENGINE=InnoDB; 217ALTER TABLE `tiki_score` ENGINE=InnoDB; 218ALTER TABLE `tiki_search_stats` ENGINE=InnoDB; 219ALTER TABLE `tiki_secdb` ENGINE=InnoDB; 220ALTER TABLE `tiki_sefurl_regex_out` ENGINE=InnoDB; 221ALTER TABLE `tiki_semantic_tokens` ENGINE=InnoDB; 222ALTER TABLE `tiki_semaphores` ENGINE=InnoDB; 223ALTER TABLE `tiki_sent_newsletters` ENGINE=InnoDB; 224ALTER TABLE `tiki_sent_newsletters_errors` ENGINE=InnoDB; 225ALTER TABLE `tiki_sent_newsletters_files` ENGINE=InnoDB; 226ALTER TABLE `tiki_sessions` ENGINE=InnoDB; 227ALTER TABLE `tiki_sheet_layout` ENGINE=InnoDB; 228ALTER TABLE `tiki_sheet_values` ENGINE=InnoDB; 229ALTER TABLE `tiki_sheets` ENGINE=InnoDB; 230ALTER TABLE `tiki_shoutbox` ENGINE=InnoDB; 231ALTER TABLE `tiki_shoutbox_words` ENGINE=InnoDB; 232ALTER TABLE `tiki_source_auth` ENGINE=InnoDB; 233ALTER TABLE `tiki_stats` ENGINE=InnoDB; 234ALTER TABLE `tiki_structure_versions` ENGINE=InnoDB; 235ALTER TABLE `tiki_structures` ENGINE=InnoDB; 236ALTER TABLE `tiki_submissions` ENGINE=InnoDB; 237ALTER TABLE `tiki_suggested_faq_questions` ENGINE=InnoDB; 238ALTER TABLE `tiki_survey_question_options` ENGINE=InnoDB; 239ALTER TABLE `tiki_survey_questions` ENGINE=InnoDB; 240ALTER TABLE `tiki_surveys` ENGINE=InnoDB; 241ALTER TABLE `tiki_tags` ENGINE=InnoDB; 242ALTER TABLE `tiki_theme_control_categs` ENGINE=InnoDB; 243ALTER TABLE `tiki_theme_control_objects` ENGINE=InnoDB; 244ALTER TABLE `tiki_theme_control_sections` ENGINE=InnoDB; 245ALTER TABLE `tiki_todo` ENGINE=InnoDB; 246ALTER TABLE `tiki_todo_notif` ENGINE=InnoDB; 247ALTER TABLE `tiki_topics` ENGINE=InnoDB; 248ALTER TABLE `tiki_tracker_fields` ENGINE=InnoDB; 249ALTER TABLE `tiki_tracker_item_attachments` ENGINE=InnoDB; 250ALTER TABLE `tiki_tracker_item_field_logs` ENGINE=InnoDB; 251ALTER TABLE `tiki_tracker_item_fields` ENGINE=InnoDB; 252ALTER TABLE `tiki_tracker_items` ENGINE=InnoDB; 253ALTER TABLE `tiki_tracker_options` ENGINE=InnoDB; 254ALTER TABLE `tiki_trackers` ENGINE=InnoDB; 255ALTER TABLE `tiki_transitions` ENGINE=InnoDB; 256ALTER TABLE `tiki_translated_objects` ENGINE=InnoDB; 257ALTER TABLE `tiki_translations_in_progress` ENGINE=InnoDB; 258ALTER TABLE `tiki_untranslated` ENGINE=InnoDB; 259ALTER TABLE `tiki_url_shortener` ENGINE=InnoDB; 260ALTER TABLE `tiki_user_answers` ENGINE=InnoDB; 261ALTER TABLE `tiki_user_answers_uploads` ENGINE=InnoDB; 262ALTER TABLE `tiki_user_assigned_modules` ENGINE=InnoDB; 263ALTER TABLE `tiki_user_bookmarks_folders` ENGINE=InnoDB; 264ALTER TABLE `tiki_user_bookmarks_urls` ENGINE=InnoDB; 265ALTER TABLE `tiki_user_login_cookies` ENGINE=InnoDB; 266ALTER TABLE `tiki_user_mailin_struct` ENGINE=InnoDB; 267ALTER TABLE `tiki_user_menus` ENGINE=InnoDB; 268ALTER TABLE `tiki_user_modules` ENGINE=InnoDB; 269ALTER TABLE `tiki_user_notes` ENGINE=InnoDB; 270ALTER TABLE `tiki_user_postings` ENGINE=InnoDB; 271ALTER TABLE `tiki_user_preferences` ENGINE=InnoDB; 272ALTER TABLE `tiki_user_quizzes` ENGINE=InnoDB; 273ALTER TABLE `tiki_user_reports` ENGINE=InnoDB; 274ALTER TABLE `tiki_user_reports_cache` ENGINE=InnoDB; 275ALTER TABLE `tiki_user_taken_quizzes` ENGINE=InnoDB; 276ALTER TABLE `tiki_user_tasks_history` ENGINE=InnoDB; 277ALTER TABLE `tiki_user_tasks` ENGINE=InnoDB; 278ALTER TABLE `tiki_user_tasks_history` ENGINE=InnoDB; 279ALTER TABLE `tiki_user_votings` ENGINE=InnoDB; 280ALTER TABLE `tiki_user_watches` ENGINE=InnoDB; 281ALTER TABLE `tiki_userfiles` ENGINE=InnoDB; 282ALTER TABLE `tiki_userpoints` ENGINE=InnoDB; 283-- ALTER TABLE `tiki_users` ENGINE=InnoDB; 284-- ALTER TABLE `tiki_users_score` ENGINE=InnoDB; 285ALTER TABLE `tiki_webmail_contacts` ENGINE=InnoDB; 286ALTER TABLE `tiki_webmail_contacts_ext` ENGINE=InnoDB; 287ALTER TABLE `tiki_webmail_contacts_fields` ENGINE=InnoDB; 288ALTER TABLE `tiki_webmail_contacts_groups` ENGINE=InnoDB; 289ALTER TABLE `tiki_webservice` ENGINE=InnoDB; 290ALTER TABLE `tiki_webservice_template` ENGINE=InnoDB; 291ALTER TABLE `tiki_wiki_attachments` ENGINE=InnoDB; 292ALTER TABLE `tiki_workspace_templates` ENGINE=InnoDB; 293ALTER TABLE `tiki_zones` ENGINE=InnoDB; 294ALTER TABLE `users_grouppermissions` ENGINE=InnoDB; 295ALTER TABLE `users_groups` ENGINE=InnoDB; 296ALTER TABLE `users_objectpermissions` ENGINE=InnoDB; 297ALTER TABLE `users_permissions` ENGINE=InnoDB; 298-- ALTER TABLE `users_score` ENGINE=InnoDB; 299ALTER TABLE `users_usergroups` ENGINE=InnoDB; 300ALTER TABLE `users_users` ENGINE=InnoDB; 301ALTER TABLE `tiki_search_queries` ENGINE=InnoDB; 302ALTER TABLE `tiki_user_monitors` ENGINE=InnoDB; 303ALTER TABLE `tiki_output` ENGINE=InnoDB; 304ALTER TABLE `tiki_goals` ENGINE=InnoDB; 305ALTER TABLE `tiki_goal_events` ENGINE=InnoDB; 306-- ALTER TABLE `tiki_addon_profiles` ENGINE=InnoDB; 307ALTER TABLE `tiki_tabular_formats` ENGINE=InnoDB; 308ALTER TABLE `tiki_scheduler` ENGINE=InnoDB; 309ALTER TABLE `tiki_scheduler_run` ENGINE=InnoDB; 310ALTER TABLE `tiki_custom_route` ENGINE=InnoDB; 311ALTER TABLE `tiki_h5p_libraries_hub_cache` ENGINE=InnoDB; 312ALTER TABLE `tiki_oauthserver_clients` ENGINE=InnoDB; 313ALTER TABLE `tiki_calendar_instances` ENGINE=InnoDB; 314ALTER TABLE `tiki_calendar_changes` ENGINE=InnoDB; 315ALTER TABLE `tiki_calendar_subscriptions` ENGINE=InnoDB; 316ALTER TABLE `tiki_calendar_scheduling_objects` ENGINE=InnoDB; 317ALTER TABLE `tiki_address_books` ENGINE = InnoDB; 318ALTER TABLE `tiki_address_cards` ENGINE = InnoDB;