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;