-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathscheme-change-innodb.sql
298 lines (296 loc) · 14.4 KB
/
scheme-change-innodb.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
ALTER TABLE pre_forum_post
MODIFY COLUMN position INT unsigned NOT NULL DEFAULT '0';
ALTER TABLE pre_common_member_grouppm
ADD INDEX gpmid(gpmid);
ALTER TABLE pre_common_admincp_cmenu ENGINE=innodb;
ALTER TABLE pre_common_admincp_group ENGINE=innodb;
ALTER TABLE pre_common_admincp_member ENGINE=innodb;
ALTER TABLE pre_common_admincp_perm ENGINE=innodb;
ALTER TABLE pre_common_admincp_session ENGINE=innodb;
ALTER TABLE pre_common_admingroup ENGINE=innodb;
ALTER TABLE pre_common_adminnote ENGINE=innodb;
ALTER TABLE pre_common_advertisement ENGINE=innodb;
ALTER TABLE pre_common_advertisement_custom ENGINE=innodb;
ALTER TABLE pre_common_banned ENGINE=innodb;
ALTER TABLE pre_common_block ENGINE=innodb;
ALTER TABLE pre_common_block_favorite ENGINE=innodb;
ALTER TABLE pre_common_block_item ENGINE=innodb;
ALTER TABLE pre_common_block_item_data ENGINE=innodb;
ALTER TABLE pre_common_block_permission ENGINE=innodb;
ALTER TABLE pre_common_block_pic ENGINE=innodb;
ALTER TABLE pre_common_block_style ENGINE=innodb;
ALTER TABLE pre_common_block_xml ENGINE=innodb;
ALTER TABLE pre_common_cache ENGINE=innodb;
ALTER TABLE pre_common_card ENGINE=innodb;
ALTER TABLE pre_common_card_log ENGINE=innodb;
ALTER TABLE pre_common_card_type ENGINE=innodb;
ALTER TABLE pre_common_connect_guest ENGINE=innodb;
ALTER TABLE pre_common_credit_log ENGINE=innodb;
ALTER TABLE pre_common_credit_log_field ENGINE=innodb;
ALTER TABLE pre_common_credit_rule ENGINE=innodb;
ALTER TABLE pre_common_credit_rule_log ENGINE=innodb;
ALTER TABLE pre_common_credit_rule_log_field ENGINE=innodb;
ALTER TABLE pre_common_cron ENGINE=innodb;
ALTER TABLE pre_common_devicetoken ENGINE=innodb;
ALTER TABLE pre_common_district ENGINE=innodb;
ALTER TABLE pre_common_diy_data ENGINE=innodb;
ALTER TABLE pre_common_domain ENGINE=innodb;
ALTER TABLE pre_common_failedip ENGINE=innodb;
ALTER TABLE pre_common_failedlogin ENGINE=innodb;
ALTER TABLE pre_common_friendlink ENGINE=innodb;
ALTER TABLE pre_common_grouppm ENGINE=innodb;
ALTER TABLE pre_common_invite ENGINE=innodb;
ALTER TABLE pre_common_magic ENGINE=innodb;
ALTER TABLE pre_common_magiclog ENGINE=innodb;
ALTER TABLE pre_common_mailcron ENGINE=innodb;
ALTER TABLE pre_common_mailqueue ENGINE=innodb;
ALTER TABLE pre_common_member ENGINE=innodb;
ALTER TABLE pre_common_member_action_log ENGINE=innodb;
ALTER TABLE pre_common_member_connect ENGINE=innodb;
ALTER TABLE pre_common_member_count ENGINE=innodb;
ALTER TABLE pre_common_member_crime ENGINE=innodb;
ALTER TABLE pre_common_member_field_forum ENGINE=innodb;
ALTER TABLE pre_common_member_field_home ENGINE=innodb;
ALTER TABLE pre_common_member_forum_buylog ENGINE=innodb;
ALTER TABLE pre_common_member_grouppm ENGINE=innodb;
ALTER TABLE pre_common_member_log ENGINE=innodb;
ALTER TABLE pre_common_member_magic ENGINE=innodb;
ALTER TABLE pre_common_member_medal ENGINE=innodb;
ALTER TABLE pre_common_member_newprompt ENGINE=innodb;
ALTER TABLE pre_common_member_profile ENGINE=innodb;
ALTER TABLE pre_common_member_profile_setting ENGINE=innodb;
ALTER TABLE pre_common_member_security ENGINE=innodb;
ALTER TABLE pre_common_member_secwhite ENGINE=innodb;
ALTER TABLE pre_common_member_stat_field ENGINE=innodb;
ALTER TABLE pre_common_member_status ENGINE=innodb;
ALTER TABLE pre_common_member_validate ENGINE=innodb;
ALTER TABLE pre_common_member_verify ENGINE=innodb;
ALTER TABLE pre_common_member_verify_info ENGINE=innodb;
ALTER TABLE pre_common_myapp ENGINE=innodb;
ALTER TABLE pre_common_myinvite ENGINE=innodb;
ALTER TABLE pre_common_mytask ENGINE=innodb;
ALTER TABLE pre_common_nav ENGINE=innodb;
ALTER TABLE pre_common_onlinetime ENGINE=innodb;
ALTER TABLE pre_common_optimizer ENGINE=innodb;
ALTER TABLE pre_common_patch ENGINE=innodb;
ALTER TABLE pre_common_plugin ENGINE=innodb;
ALTER TABLE pre_common_pluginvar ENGINE=innodb;
ALTER TABLE pre_common_process ENGINE=innodb;
ALTER TABLE pre_common_regip ENGINE=innodb;
ALTER TABLE pre_common_relatedlink ENGINE=innodb;
ALTER TABLE pre_common_remote_port ENGINE=innodb;
ALTER TABLE pre_common_report ENGINE=innodb;
ALTER TABLE pre_common_searchindex ENGINE=innodb;
ALTER TABLE pre_common_seccheck ENGINE=innodb;
ALTER TABLE pre_common_secquestion ENGINE=innodb;
ALTER TABLE pre_common_session ENGINE=innodb;
ALTER TABLE pre_common_setting ENGINE=innodb;
ALTER TABLE pre_common_smiley ENGINE=innodb;
ALTER TABLE pre_common_sphinxcounter ENGINE=innodb;
ALTER TABLE pre_common_stat ENGINE=innodb;
ALTER TABLE pre_common_statuser ENGINE=innodb;
ALTER TABLE pre_common_style ENGINE=innodb;
ALTER TABLE pre_common_stylevar ENGINE=innodb;
ALTER TABLE pre_common_syscache ENGINE=innodb;
ALTER TABLE pre_common_tag ENGINE=innodb;
ALTER TABLE pre_common_tagitem ENGINE=innodb;
ALTER TABLE pre_common_task ENGINE=innodb;
ALTER TABLE pre_common_taskvar ENGINE=innodb;
ALTER TABLE pre_common_template ENGINE=innodb;
ALTER TABLE pre_common_template_block ENGINE=innodb;
ALTER TABLE pre_common_template_permission ENGINE=innodb;
ALTER TABLE pre_common_uin_black ENGINE=innodb;
ALTER TABLE pre_common_usergroup ENGINE=innodb;
ALTER TABLE pre_common_usergroup_field ENGINE=innodb;
ALTER TABLE pre_common_visit ENGINE=innodb;
ALTER TABLE pre_common_word ENGINE=innodb;
ALTER TABLE pre_common_word_type ENGINE=innodb;
ALTER TABLE pre_connect_disktask ENGINE=innodb;
ALTER TABLE pre_connect_feedlog ENGINE=innodb;
ALTER TABLE pre_connect_memberbindlog ENGINE=innodb;
ALTER TABLE pre_connect_postfeedlog ENGINE=innodb;
ALTER TABLE pre_connect_tthreadlog ENGINE=innodb;
ALTER TABLE pre_forum_access ENGINE=innodb;
ALTER TABLE pre_forum_activity ENGINE=innodb;
ALTER TABLE pre_forum_activityapply ENGINE=innodb;
ALTER TABLE pre_forum_announcement ENGINE=innodb;
ALTER TABLE pre_forum_attachment ENGINE=innodb;
ALTER TABLE pre_forum_attachment_0 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_1 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_2 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_3 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_4 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_5 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_6 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_7 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_8 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_9 ENGINE=innodb;
ALTER TABLE pre_forum_attachment_exif ENGINE=innodb;
ALTER TABLE pre_forum_attachment_unused ENGINE=innodb;
ALTER TABLE pre_forum_attachtype ENGINE=innodb;
ALTER TABLE pre_forum_bbcode ENGINE=innodb;
ALTER TABLE pre_forum_collection ENGINE=innodb;
ALTER TABLE pre_forum_collectioncomment ENGINE=innodb;
ALTER TABLE pre_forum_collectionfollow ENGINE=innodb;
ALTER TABLE pre_forum_collectioninvite ENGINE=innodb;
ALTER TABLE pre_forum_collectionrelated ENGINE=innodb;
ALTER TABLE pre_forum_collectionteamworker ENGINE=innodb;
ALTER TABLE pre_forum_collectionthread ENGINE=innodb;
ALTER TABLE pre_forum_creditslog ENGINE=innodb;
ALTER TABLE pre_forum_debate ENGINE=innodb;
ALTER TABLE pre_forum_debatepost ENGINE=innodb;
ALTER TABLE pre_forum_faq ENGINE=innodb;
ALTER TABLE pre_forum_filter_post ENGINE=innodb;
ALTER TABLE pre_forum_forum ENGINE=innodb;
ALTER TABLE pre_forum_forum_threadtable ENGINE=innodb;
ALTER TABLE pre_forum_forumfield ENGINE=innodb;
ALTER TABLE pre_forum_forumrecommend ENGINE=innodb;
ALTER TABLE pre_forum_groupcreditslog ENGINE=innodb;
ALTER TABLE pre_forum_groupfield ENGINE=innodb;
ALTER TABLE pre_forum_groupinvite ENGINE=innodb;
ALTER TABLE pre_forum_grouplevel ENGINE=innodb;
ALTER TABLE pre_forum_groupuser ENGINE=innodb;
ALTER TABLE pre_forum_hotreply_member ENGINE=innodb;
ALTER TABLE pre_forum_hotreply_number ENGINE=innodb;
ALTER TABLE pre_forum_imagetype ENGINE=innodb;
ALTER TABLE pre_forum_medal ENGINE=innodb;
ALTER TABLE pre_forum_medallog ENGINE=innodb;
ALTER TABLE pre_forum_memberrecommend ENGINE=innodb;
ALTER TABLE pre_forum_moderator ENGINE=innodb;
ALTER TABLE pre_forum_modwork ENGINE=innodb;
ALTER TABLE pre_forum_newthread ENGINE=innodb;
ALTER TABLE pre_forum_onlinelist ENGINE=innodb;
ALTER TABLE pre_forum_order ENGINE=innodb;
ALTER TABLE pre_forum_poll ENGINE=innodb;
ALTER TABLE pre_forum_polloption ENGINE=innodb;
ALTER TABLE pre_forum_polloption_image ENGINE=innodb;
ALTER TABLE pre_forum_pollvoter ENGINE=innodb;
ALTER TABLE pre_forum_post ENGINE=innodb;
ALTER TABLE pre_forum_post_location ENGINE=innodb;
ALTER TABLE pre_forum_post_moderate ENGINE=innodb;
ALTER TABLE pre_forum_post_tableid ENGINE=innodb;
ALTER TABLE pre_forum_postcache ENGINE=innodb;
ALTER TABLE pre_forum_postcomment ENGINE=innodb;
ALTER TABLE pre_forum_postlog ENGINE=innodb;
ALTER TABLE pre_forum_poststick ENGINE=innodb;
ALTER TABLE pre_forum_promotion ENGINE=innodb;
ALTER TABLE pre_forum_ratelog ENGINE=innodb;
ALTER TABLE pre_forum_relatedthread ENGINE=innodb;
ALTER TABLE pre_forum_replycredit ENGINE=innodb;
ALTER TABLE pre_forum_rsscache ENGINE=innodb;
ALTER TABLE pre_forum_sofa ENGINE=innodb;
ALTER TABLE pre_forum_spacecache ENGINE=innodb;
ALTER TABLE pre_forum_statlog ENGINE=innodb;
ALTER TABLE pre_forum_thread ENGINE=innodb;
ALTER TABLE pre_forum_thread_moderate ENGINE=innodb;
ALTER TABLE pre_forum_threadaddviews ENGINE=innodb;
ALTER TABLE pre_forum_threadcalendar ENGINE=innodb;
ALTER TABLE pre_forum_threadclass ENGINE=innodb;
ALTER TABLE pre_forum_threadclosed ENGINE=innodb;
ALTER TABLE pre_forum_threaddisablepos ENGINE=innodb;
ALTER TABLE pre_forum_threadhidelog ENGINE=innodb;
ALTER TABLE pre_forum_threadhot ENGINE=innodb;
ALTER TABLE pre_forum_threadimage ENGINE=innodb;
ALTER TABLE pre_forum_threadlog ENGINE=innodb;
ALTER TABLE pre_forum_threadmod ENGINE=innodb;
ALTER TABLE pre_forum_threadpartake ENGINE=innodb;
ALTER TABLE pre_forum_threadpreview ENGINE=innodb;
ALTER TABLE pre_forum_threadprofile ENGINE=innodb;
ALTER TABLE pre_forum_threadprofile_group ENGINE=innodb;
ALTER TABLE pre_forum_threadrush ENGINE=innodb;
ALTER TABLE pre_forum_threadtype ENGINE=innodb;
ALTER TABLE pre_forum_trade ENGINE=innodb;
ALTER TABLE pre_forum_tradecomment ENGINE=innodb;
ALTER TABLE pre_forum_tradelog ENGINE=innodb;
ALTER TABLE pre_forum_typeoption ENGINE=innodb;
ALTER TABLE pre_forum_typeoptionvar ENGINE=innodb;
ALTER TABLE pre_forum_typevar ENGINE=innodb;
ALTER TABLE pre_forum_warning ENGINE=innodb;
ALTER TABLE pre_home_album ENGINE=innodb;
ALTER TABLE pre_home_album_category ENGINE=innodb;
ALTER TABLE pre_home_appcreditlog ENGINE=innodb;
ALTER TABLE pre_home_blacklist ENGINE=innodb;
ALTER TABLE pre_home_blog ENGINE=innodb;
ALTER TABLE pre_home_blog_category ENGINE=innodb;
ALTER TABLE pre_home_blog_moderate ENGINE=innodb;
ALTER TABLE pre_home_blogfield ENGINE=innodb;
ALTER TABLE pre_home_class ENGINE=innodb;
ALTER TABLE pre_home_click ENGINE=innodb;
ALTER TABLE pre_home_clickuser ENGINE=innodb;
ALTER TABLE pre_home_comment ENGINE=innodb;
ALTER TABLE pre_home_comment_moderate ENGINE=innodb;
ALTER TABLE pre_home_docomment ENGINE=innodb;
ALTER TABLE pre_home_doing ENGINE=innodb;
ALTER TABLE pre_home_doing_moderate ENGINE=innodb;
ALTER TABLE pre_home_favorite ENGINE=innodb;
ALTER TABLE pre_home_feed ENGINE=innodb;
ALTER TABLE pre_home_feed_app ENGINE=innodb;
ALTER TABLE pre_home_follow ENGINE=innodb;
ALTER TABLE pre_home_follow_feed ENGINE=innodb;
ALTER TABLE pre_home_follow_feed_archiver ENGINE=innodb;
ALTER TABLE pre_home_friend ENGINE=innodb;
ALTER TABLE pre_home_friend_request ENGINE=innodb;
ALTER TABLE pre_home_friendlog ENGINE=innodb;
ALTER TABLE pre_home_notification ENGINE=innodb;
ALTER TABLE pre_home_pic ENGINE=innodb;
ALTER TABLE pre_home_pic_moderate ENGINE=innodb;
ALTER TABLE pre_home_picfield ENGINE=innodb;
ALTER TABLE pre_home_poke ENGINE=innodb;
ALTER TABLE pre_home_pokearchive ENGINE=innodb;
ALTER TABLE pre_home_share ENGINE=innodb;
ALTER TABLE pre_home_share_moderate ENGINE=innodb;
ALTER TABLE pre_home_show ENGINE=innodb;
ALTER TABLE pre_home_specialuser ENGINE=innodb;
ALTER TABLE pre_home_userapp ENGINE=innodb;
ALTER TABLE pre_home_userappfield ENGINE=innodb;
ALTER TABLE pre_home_visitor ENGINE=innodb;
ALTER TABLE pre_mobile_setting ENGINE=innodb;
ALTER TABLE pre_mobile_wsq_threadlist ENGINE=innodb;
ALTER TABLE pre_portal_article_content ENGINE=innodb;
ALTER TABLE pre_portal_article_count ENGINE=innodb;
ALTER TABLE pre_portal_article_moderate ENGINE=innodb;
ALTER TABLE pre_portal_article_related ENGINE=innodb;
ALTER TABLE pre_portal_article_title ENGINE=innodb;
ALTER TABLE pre_portal_article_trash ENGINE=innodb;
ALTER TABLE pre_portal_attachment ENGINE=innodb;
ALTER TABLE pre_portal_category ENGINE=innodb;
ALTER TABLE pre_portal_category_permission ENGINE=innodb;
ALTER TABLE pre_portal_comment ENGINE=innodb;
ALTER TABLE pre_portal_comment_moderate ENGINE=innodb;
ALTER TABLE pre_portal_rsscache ENGINE=innodb;
ALTER TABLE pre_portal_topic ENGINE=innodb;
ALTER TABLE pre_portal_topic_pic ENGINE=innodb;
ALTER TABLE pre_security_evilpost ENGINE=innodb;
ALTER TABLE pre_security_eviluser ENGINE=innodb;
ALTER TABLE pre_security_failedlog ENGINE=innodb;
ALTER TABLE pre_ucenter_admins ENGINE=innodb;
ALTER TABLE pre_ucenter_applications ENGINE=innodb;
ALTER TABLE pre_ucenter_badwords ENGINE=innodb;
ALTER TABLE pre_ucenter_domains ENGINE=innodb;
ALTER TABLE pre_ucenter_failedlogins ENGINE=innodb;
ALTER TABLE pre_ucenter_feeds ENGINE=innodb;
ALTER TABLE pre_ucenter_friends ENGINE=innodb;
ALTER TABLE pre_ucenter_mailqueue ENGINE=innodb;
ALTER TABLE pre_ucenter_memberfields ENGINE=innodb;
ALTER TABLE pre_ucenter_members ENGINE=innodb;
ALTER TABLE pre_ucenter_mergemembers ENGINE=innodb;
ALTER TABLE pre_ucenter_newpm ENGINE=innodb;
ALTER TABLE pre_ucenter_notelist ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_indexes ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_lists ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_members ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_0 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_1 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_2 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_3 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_4 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_5 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_6 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_7 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_8 ENGINE=innodb;
ALTER TABLE pre_ucenter_pm_messages_9 ENGINE=innodb;
ALTER TABLE pre_ucenter_protectedmembers ENGINE=innodb;
ALTER TABLE pre_ucenter_settings ENGINE=innodb;
ALTER TABLE pre_ucenter_sqlcache ENGINE=innodb;
ALTER TABLE pre_ucenter_tags ENGINE=innodb;
ALTER TABLE pre_ucenter_vars ENGINE=innodb;