2
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `bluh` /*!40100 DEFAULT CHARACTER SET latin1 */;
5
/*!40101 SET @saved_cs_client = @@character_set_client */;
6
/*!40101 SET character_set_client = utf8 */;
8
`id` int(11) DEFAULT NULL,
10
`bi_test` binary(1) DEFAULT NULL,
12
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
13
/*!40101 SET character_set_client = @saved_cs_client */;
15
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `meh` /*!40100 DEFAULT CHARACTER SET latin1 */;
18
/*!40101 SET @saved_cs_client = @@character_set_client */;
19
/*!40101 SET character_set_client = utf8 */;
20
CREATE TABLE `future``me` (
21
`bluh` char(1) DEFAULT NULL
22
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
23
/*!40101 SET character_set_client = @saved_cs_client */;
25
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */;
28
/*!40101 SET @saved_cs_client = @@character_set_client */;
29
/*!40101 SET character_set_client = utf8 */;
30
CREATE TABLE `columns_priv` (
31
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
32
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
33
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
34
`Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
35
`Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
36
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
37
`Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
38
PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
39
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';
40
/*!40101 SET character_set_client = @saved_cs_client */;
41
/*!40101 SET @saved_cs_client = @@character_set_client */;
42
/*!40101 SET character_set_client = utf8 */;
44
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
45
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
46
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
47
`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
48
`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
49
`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
50
`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
51
`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
52
`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
53
`Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
54
`References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
55
`Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
56
`Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
57
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
58
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
59
`Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
60
`Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
61
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
62
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
63
`Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
64
`Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
65
`Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
66
PRIMARY KEY (`Host`,`Db`,`User`),
68
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges';
69
/*!40101 SET character_set_client = @saved_cs_client */;
70
/*!40101 SET @saved_cs_client = @@character_set_client */;
71
/*!40101 SET character_set_client = utf8 */;
72
CREATE TABLE `event` (
73
`db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
74
`name` char(64) NOT NULL DEFAULT '',
75
`body` longblob NOT NULL,
76
`definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
77
`execute_at` datetime DEFAULT NULL,
78
`interval_value` int(11) DEFAULT NULL,
79
`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,
80
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
81
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
82
`last_executed` datetime DEFAULT NULL,
83
`starts` datetime DEFAULT NULL,
84
`ends` datetime DEFAULT NULL,
85
`status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
86
`on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
87
`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 '',
88
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
89
`originator` int(10) unsigned NOT NULL,
90
`time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
91
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
92
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
93
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
95
PRIMARY KEY (`db`,`name`)
96
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events';
97
/*!40101 SET character_set_client = @saved_cs_client */;
98
/*!40101 SET @saved_cs_client = @@character_set_client */;
99
/*!40101 SET character_set_client = utf8 */;
100
CREATE TABLE `func` (
101
`name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
102
`ret` tinyint(1) NOT NULL DEFAULT '0',
103
`dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
104
`type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,
106
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions';
107
/*!40101 SET character_set_client = @saved_cs_client */;
108
/*!40101 SET @saved_cs_client = @@character_set_client */;
109
/*!40101 SET character_set_client = utf8 */;
110
CREATE TABLE `help_category` (
111
`help_category_id` smallint(5) unsigned NOT NULL,
112
`name` char(64) NOT NULL,
113
`parent_category_id` smallint(5) unsigned DEFAULT NULL,
114
`url` char(128) NOT NULL,
115
PRIMARY KEY (`help_category_id`),
116
UNIQUE KEY `name` (`name`)
117
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help categories';
118
/*!40101 SET character_set_client = @saved_cs_client */;
119
/*!40101 SET @saved_cs_client = @@character_set_client */;
120
/*!40101 SET character_set_client = utf8 */;
121
CREATE TABLE `help_keyword` (
122
`help_keyword_id` int(10) unsigned NOT NULL,
123
`name` char(64) NOT NULL,
124
PRIMARY KEY (`help_keyword_id`),
125
UNIQUE KEY `name` (`name`)
126
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help keywords';
127
/*!40101 SET character_set_client = @saved_cs_client */;
128
/*!40101 SET @saved_cs_client = @@character_set_client */;
129
/*!40101 SET character_set_client = utf8 */;
130
CREATE TABLE `help_relation` (
131
`help_topic_id` int(10) unsigned NOT NULL,
132
`help_keyword_id` int(10) unsigned NOT NULL,
133
PRIMARY KEY (`help_keyword_id`,`help_topic_id`)
134
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='keyword-topic relation';
135
/*!40101 SET character_set_client = @saved_cs_client */;
136
/*!40101 SET @saved_cs_client = @@character_set_client */;
137
/*!40101 SET character_set_client = utf8 */;
138
CREATE TABLE `help_topic` (
139
`help_topic_id` int(10) unsigned NOT NULL,
140
`name` char(64) NOT NULL,
141
`help_category_id` smallint(5) unsigned NOT NULL,
142
`description` text NOT NULL,
143
`example` text NOT NULL,
144
`url` char(128) NOT NULL,
145
PRIMARY KEY (`help_topic_id`),
146
UNIQUE KEY `name` (`name`)
147
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help topics';
148
/*!40101 SET character_set_client = @saved_cs_client */;
149
/*!40101 SET @saved_cs_client = @@character_set_client */;
150
/*!40101 SET character_set_client = utf8 */;
151
CREATE TABLE `host` (
152
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
153
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
154
`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
155
`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
156
`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
157
`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
158
`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
159
`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
160
`Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
161
`References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
162
`Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
163
`Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
164
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
165
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
166
`Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
167
`Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
168
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
169
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
170
`Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
171
`Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
172
PRIMARY KEY (`Host`,`Db`)
173
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges; Merged with database privileges';
174
/*!40101 SET character_set_client = @saved_cs_client */;
175
/*!40101 SET @saved_cs_client = @@character_set_client */;
176
/*!40101 SET character_set_client = utf8 */;
177
CREATE TABLE `ndb_binlog_index` (
178
`Position` bigint(20) unsigned NOT NULL,
179
`File` varchar(255) NOT NULL,
180
`epoch` bigint(20) unsigned NOT NULL,
181
`inserts` bigint(20) unsigned NOT NULL,
182
`updates` bigint(20) unsigned NOT NULL,
183
`deletes` bigint(20) unsigned NOT NULL,
184
`schemaops` bigint(20) unsigned NOT NULL,
185
PRIMARY KEY (`epoch`)
186
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
187
/*!40101 SET character_set_client = @saved_cs_client */;
188
/*!40101 SET @saved_cs_client = @@character_set_client */;
189
/*!40101 SET character_set_client = utf8 */;
190
CREATE TABLE `plugin` (
191
`name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
192
`dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
194
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='MySQL plugins';
195
/*!40101 SET character_set_client = @saved_cs_client */;
196
/*!40101 SET @saved_cs_client = @@character_set_client */;
197
/*!40101 SET character_set_client = utf8 */;
198
CREATE TABLE `proc` (
199
`db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
200
`name` char(64) NOT NULL DEFAULT '',
201
`type` enum('FUNCTION','PROCEDURE') NOT NULL,
202
`specific_name` char(64) NOT NULL DEFAULT '',
203
`language` enum('SQL') NOT NULL DEFAULT 'SQL',
204
`sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
205
`is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
206
`security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
207
`param_list` blob NOT NULL,
208
`returns` longblob NOT NULL,
209
`body` longblob NOT NULL,
210
`definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
211
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
212
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
213
`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 '',
214
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
215
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
216
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
217
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
218
`body_utf8` longblob,
219
PRIMARY KEY (`db`,`name`,`type`)
220
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';
221
/*!40101 SET character_set_client = @saved_cs_client */;
222
/*!40101 SET @saved_cs_client = @@character_set_client */;
223
/*!40101 SET character_set_client = utf8 */;
224
CREATE TABLE `procs_priv` (
225
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
226
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
227
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
228
`Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
229
`Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
230
`Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
231
`Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
232
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
233
PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
234
KEY `Grantor` (`Grantor`)
235
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';
236
/*!40101 SET character_set_client = @saved_cs_client */;
237
/*!40101 SET @saved_cs_client = @@character_set_client */;
238
/*!40101 SET character_set_client = utf8 */;
239
CREATE TABLE `proxies_priv` (
240
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
241
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
242
`Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
243
`Proxied_user` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
244
`With_grant` tinyint(1) NOT NULL DEFAULT '0',
245
`Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
246
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
247
PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
248
KEY `Grantor` (`Grantor`)
249
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';
250
/*!40101 SET character_set_client = @saved_cs_client */;
251
/*!40101 SET @saved_cs_client = @@character_set_client */;
252
/*!40101 SET character_set_client = utf8 */;
253
CREATE TABLE `servers` (
254
`Server_name` char(64) NOT NULL DEFAULT '',
255
`Host` char(64) NOT NULL DEFAULT '',
256
`Db` char(64) NOT NULL DEFAULT '',
257
`Username` char(64) NOT NULL DEFAULT '',
258
`Password` char(64) NOT NULL DEFAULT '',
259
`Port` int(4) NOT NULL DEFAULT '0',
260
`Socket` char(64) NOT NULL DEFAULT '',
261
`Wrapper` char(64) NOT NULL DEFAULT '',
262
`Owner` char(64) NOT NULL DEFAULT '',
263
PRIMARY KEY (`Server_name`)
264
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';
265
/*!40101 SET character_set_client = @saved_cs_client */;
266
/*!40101 SET @saved_cs_client = @@character_set_client */;
267
/*!40101 SET character_set_client = utf8 */;
268
CREATE TABLE `tables_priv` (
269
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
270
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
271
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
272
`Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
273
`Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
274
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
275
`Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
276
`Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
277
PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
278
KEY `Grantor` (`Grantor`)
279
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';
280
/*!40101 SET character_set_client = @saved_cs_client */;
281
/*!40101 SET @saved_cs_client = @@character_set_client */;
282
/*!40101 SET character_set_client = utf8 */;
283
CREATE TABLE `time_zone` (
284
`Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
285
`Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
286
PRIMARY KEY (`Time_zone_id`)
287
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones';
288
/*!40101 SET character_set_client = @saved_cs_client */;
289
/*!40101 SET @saved_cs_client = @@character_set_client */;
290
/*!40101 SET character_set_client = utf8 */;
291
CREATE TABLE `time_zone_leap_second` (
292
`Transition_time` bigint(20) NOT NULL,
293
`Correction` int(11) NOT NULL,
294
PRIMARY KEY (`Transition_time`)
295
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones';
296
/*!40101 SET character_set_client = @saved_cs_client */;
297
/*!40101 SET @saved_cs_client = @@character_set_client */;
298
/*!40101 SET character_set_client = utf8 */;
299
CREATE TABLE `time_zone_name` (
300
`Name` char(64) NOT NULL,
301
`Time_zone_id` int(10) unsigned NOT NULL,
303
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names';
304
/*!40101 SET character_set_client = @saved_cs_client */;
305
/*!40101 SET @saved_cs_client = @@character_set_client */;
306
/*!40101 SET character_set_client = utf8 */;
307
CREATE TABLE `time_zone_transition` (
308
`Time_zone_id` int(10) unsigned NOT NULL,
309
`Transition_time` bigint(20) NOT NULL,
310
`Transition_type_id` int(10) unsigned NOT NULL,
311
PRIMARY KEY (`Time_zone_id`,`Transition_time`)
312
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions';
313
/*!40101 SET character_set_client = @saved_cs_client */;
314
/*!40101 SET @saved_cs_client = @@character_set_client */;
315
/*!40101 SET character_set_client = utf8 */;
316
CREATE TABLE `time_zone_transition_type` (
317
`Time_zone_id` int(10) unsigned NOT NULL,
318
`Transition_type_id` int(10) unsigned NOT NULL,
319
`Offset` int(11) NOT NULL DEFAULT '0',
320
`Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
321
`Abbreviation` char(8) NOT NULL DEFAULT '',
322
PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
323
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types';
324
/*!40101 SET character_set_client = @saved_cs_client */;
325
/*!40101 SET @saved_cs_client = @@character_set_client */;
326
/*!40101 SET character_set_client = utf8 */;
327
CREATE TABLE `user` (
328
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
329
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
330
`Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
331
`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
332
`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
333
`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
334
`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
335
`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
336
`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
337
`Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
338
`Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
339
`Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
340
`File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
341
`Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
342
`References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
343
`Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
344
`Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
345
`Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
346
`Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
347
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
348
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
349
`Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
350
`Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
351
`Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
352
`Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
353
`Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
354
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
355
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
356
`Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
357
`Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
358
`Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
359
`ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
360
`ssl_cipher` blob NOT NULL,
361
`x509_issuer` blob NOT NULL,
362
`x509_subject` blob NOT NULL,
363
`max_questions` int(11) unsigned NOT NULL DEFAULT '0',
364
`max_updates` int(11) unsigned NOT NULL DEFAULT '0',
365
`max_connections` int(11) unsigned NOT NULL DEFAULT '0',
366
`max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
367
PRIMARY KEY (`Host`,`User`)
368
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';
369
/*!40101 SET character_set_client = @saved_cs_client */;
371
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `percona` /*!40100 DEFAULT CHARACTER SET latin1 */;
374
/*!40101 SET @saved_cs_client = @@character_set_client */;
375
/*!40101 SET character_set_client = utf8 */;
376
CREATE TABLE `checksums` (
377
`db` char(64) NOT NULL,
378
`tbl` char(64) NOT NULL,
379
`chunk` int(11) NOT NULL,
380
`chunk_time` float DEFAULT NULL,
381
`chunk_index` varchar(200) DEFAULT NULL,
382
`lower_boundary` text,
383
`upper_boundary` text,
384
`this_crc` char(40) NOT NULL,
385
`this_cnt` int(11) NOT NULL,
386
`master_crc` char(40) DEFAULT NULL,
387
`master_cnt` int(11) DEFAULT NULL,
388
`ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
389
PRIMARY KEY (`db`,`tbl`,`chunk`),
390
KEY `ts_db_tbl` (`ts`,`db`,`tbl`)
391
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
392
/*!40101 SET character_set_client = @saved_cs_client */;
394
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8 */;
396
USE `performance_schema`;