1
drop table if exists t1,t1aa,t2aa;
16
online_backup_progress
27
time_zone_transition_type
31
db CREATE TABLE `db` (
32
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
33
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
34
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
35
`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
36
`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
37
`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
38
`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
39
`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
40
`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
41
`Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
42
`References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
43
`Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
44
`Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
45
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
46
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
47
`Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
48
`Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
49
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
50
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
51
`Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
52
`Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
53
`Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
54
PRIMARY KEY (`Host`,`Db`,`User`),
56
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges'
57
show create table host;
59
host CREATE TABLE `host` (
60
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
61
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
62
`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
63
`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
64
`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
65
`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
66
`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
67
`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
68
`Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
69
`References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
70
`Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
71
`Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
72
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
73
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
74
`Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
75
`Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
76
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
77
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
78
`Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
79
`Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
80
PRIMARY KEY (`Host`,`Db`)
81
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges; Merged with database privileges'
82
show create table user;
84
user CREATE TABLE `user` (
85
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
86
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
87
`Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
88
`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
89
`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
90
`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
91
`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
92
`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
93
`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
94
`Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
95
`Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
96
`Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
97
`File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
98
`Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
99
`References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
100
`Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
101
`Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
102
`Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
103
`Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
104
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
105
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
106
`Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
107
`Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
108
`Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
109
`Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
110
`Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
111
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
112
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
113
`Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
114
`Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
115
`Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
116
`ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
117
`ssl_cipher` blob NOT NULL,
118
`x509_issuer` blob NOT NULL,
119
`x509_subject` blob NOT NULL,
120
`max_questions` int(11) unsigned NOT NULL DEFAULT '0',
121
`max_updates` int(11) unsigned NOT NULL DEFAULT '0',
122
`max_connections` int(11) unsigned NOT NULL DEFAULT '0',
123
`max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
124
PRIMARY KEY (`Host`,`User`)
125
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'
126
show create table func;
128
func CREATE TABLE `func` (
129
`name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
130
`ret` tinyint(1) NOT NULL DEFAULT '0',
131
`dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
132
`type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,
134
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions'
135
show create table tables_priv;
137
tables_priv CREATE TABLE `tables_priv` (
138
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
139
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
140
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
141
`Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
142
`Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
143
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
144
`Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
145
`Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
146
PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
147
KEY `Grantor` (`Grantor`)
148
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges'
149
show create table columns_priv;
151
columns_priv CREATE TABLE `columns_priv` (
152
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
153
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
154
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
155
`Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
156
`Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
157
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
158
`Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
159
PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
160
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges'
161
show create table procs_priv;
163
procs_priv CREATE TABLE `procs_priv` (
164
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
165
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
166
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
167
`Routine_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
168
`Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
169
`Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
170
`Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
171
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
172
PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
173
KEY `Grantor` (`Grantor`)
174
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges'
175
show create table servers;
177
servers CREATE TABLE `servers` (
178
`Server_name` char(64) NOT NULL DEFAULT '',
179
`Host` char(64) NOT NULL DEFAULT '',
180
`Db` char(64) NOT NULL DEFAULT '',
181
`Username` char(64) NOT NULL DEFAULT '',
182
`Password` char(64) NOT NULL DEFAULT '',
183
`Port` int(4) NOT NULL DEFAULT '0',
184
`Socket` char(64) NOT NULL DEFAULT '',
185
`Wrapper` char(64) NOT NULL DEFAULT '',
186
`Owner` char(64) NOT NULL DEFAULT '',
187
PRIMARY KEY (`Server_name`)
188
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table'
189
show create table proc;
191
proc CREATE TABLE `proc` (
192
`db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
193
`name` char(64) NOT NULL DEFAULT '',
194
`type` enum('FUNCTION','PROCEDURE') NOT NULL,
195
`specific_name` char(64) NOT NULL DEFAULT '',
196
`language` enum('SQL') NOT NULL DEFAULT 'SQL',
197
`sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
198
`is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
199
`security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
200
`param_list` blob NOT NULL,
201
`returns` longblob NOT NULL,
202
`body` longblob NOT NULL,
203
`definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
204
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
205
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
206
`sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
207
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
208
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
209
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
210
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
211
`body_utf8` longblob,
212
PRIMARY KEY (`db`,`name`,`type`)
213
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'
214
show create table event;
216
event CREATE TABLE `event` (
217
`db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
218
`name` char(64) NOT NULL DEFAULT '',
219
`body` longblob NOT NULL,
220
`definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
221
`execute_at` datetime DEFAULT NULL,
222
`interval_value` int(11) DEFAULT NULL,
223
`interval_field` enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') DEFAULT NULL,
224
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
225
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
226
`last_executed` datetime DEFAULT NULL,
227
`starts` datetime DEFAULT NULL,
228
`ends` datetime DEFAULT NULL,
229
`status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
230
`on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
231
`sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
232
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
233
`originator` int(10) NOT NULL,
234
`time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
235
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
236
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
237
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
238
`body_utf8` longblob,
239
PRIMARY KEY (`db`,`name`)
240
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events'
241
show create table general_log;
243
general_log CREATE TABLE `general_log` (
244
`event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
245
`user_host` mediumtext NOT NULL,
246
`thread_id` int(11) NOT NULL,
247
`server_id` int(11) NOT NULL,
248
`command_type` varchar(64) NOT NULL,
249
`argument` mediumtext NOT NULL
250
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log'
251
show create table slow_log;
253
slow_log CREATE TABLE `slow_log` (
254
`start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
255
`user_host` mediumtext NOT NULL,
256
`query_time` time NOT NULL,
257
`lock_time` time NOT NULL,
258
`rows_sent` int(11) NOT NULL,
259
`rows_examined` int(11) NOT NULL,
260
`db` varchar(512) NOT NULL,
261
`last_insert_id` int(11) NOT NULL,
262
`insert_id` int(11) NOT NULL,
263
`server_id` int(11) NOT NULL,
264
`sql_text` mediumtext NOT NULL
265
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log'