· 9 years ago · Dec 13, 2016, 03:52 PM
1-- --------------------------------------------------------
2-- Servidor: 127.0.0.1
3-- Versão do servidor: 5.7.14 - MySQL Community Server (GPL)
4-- OS do Servidor: Win64
5-- HeidiSQL Versão: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Copiando estrutura do banco de dados para mysql
16CREATE DATABASE IF NOT EXISTS `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `mysql`;
18
19-- Copiando estrutura para tabela mysql.columns_priv
20CREATE TABLE IF NOT EXISTS `columns_priv` (
21 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
22 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
23 `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
24 `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
25 `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
26 `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
27 `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
28 PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
29) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';
30
31-- Exportação de dados foi desmarcado.
32-- Copiando estrutura para tabela mysql.db
33CREATE TABLE IF NOT EXISTS `db` (
34 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
35 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
36 `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
37 `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
38 `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
39 `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
40 `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
41 `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
42 `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
43 `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
44 `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
45 `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
46 `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
47 `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
48 `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
49 `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
50 `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
51 `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
52 `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
53 `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
54 `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
55 `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
56 PRIMARY KEY (`Host`,`Db`,`User`),
57 KEY `User` (`User`)
58) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges';
59
60-- Exportação de dados foi desmarcado.
61-- Copiando estrutura para tabela mysql.engine_cost
62CREATE TABLE IF NOT EXISTS `engine_cost` (
63 `engine_name` varchar(64) NOT NULL,
64 `device_type` int(11) NOT NULL,
65 `cost_name` varchar(64) NOT NULL,
66 `cost_value` float DEFAULT NULL,
67 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
68 `comment` varchar(1024) DEFAULT NULL,
69 PRIMARY KEY (`cost_name`,`engine_name`,`device_type`)
70) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0;
71
72-- Exportação de dados foi desmarcado.
73-- Copiando estrutura para tabela mysql.event
74CREATE TABLE IF NOT EXISTS `event` (
75 `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
76 `name` char(64) NOT NULL DEFAULT '',
77 `body` longblob NOT NULL,
78 `definer` char(93) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
79 `execute_at` datetime DEFAULT NULL,
80 `interval_value` int(11) DEFAULT NULL,
81 `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,
82 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
83 `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
84 `last_executed` datetime DEFAULT NULL,
85 `starts` datetime DEFAULT NULL,
86 `ends` datetime DEFAULT NULL,
87 `status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
88 `on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
89 `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 '',
90 `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
91 `originator` int(10) unsigned NOT NULL,
92 `time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
93 `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
94 `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
95 `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
96 `body_utf8` longblob,
97 PRIMARY KEY (`db`,`name`)
98) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events';
99
100-- Exportação de dados foi desmarcado.
101-- Copiando estrutura para tabela mysql.func
102CREATE TABLE IF NOT EXISTS `func` (
103 `name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
104 `ret` tinyint(1) NOT NULL DEFAULT '0',
105 `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
106 `type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,
107 PRIMARY KEY (`name`)
108) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions';
109
110-- Exportação de dados foi desmarcado.
111-- Copiando estrutura para tabela mysql.general_log
112CREATE TABLE IF NOT EXISTS `general_log` (
113 `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
114 `user_host` mediumtext NOT NULL,
115 `thread_id` bigint(21) unsigned NOT NULL,
116 `server_id` int(10) unsigned NOT NULL,
117 `command_type` varchar(64) NOT NULL,
118 `argument` mediumblob NOT NULL
119) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';
120
121-- Exportação de dados foi desmarcado.
122-- Copiando estrutura para tabela mysql.gtid_executed
123CREATE TABLE IF NOT EXISTS `gtid_executed` (
124 `source_uuid` char(36) NOT NULL COMMENT 'uuid of the source where the transaction was originally executed.',
125 `interval_start` bigint(20) NOT NULL COMMENT 'First number of interval.',
126 `interval_end` bigint(20) NOT NULL COMMENT 'Last number of interval.',
127 PRIMARY KEY (`source_uuid`,`interval_start`)
128) ENGINE=InnoDB DEFAULT CHARSET=latin1;
129
130-- Exportação de dados foi desmarcado.
131-- Copiando estrutura para tabela mysql.help_category
132CREATE TABLE IF NOT EXISTS `help_category` (
133 `help_category_id` smallint(5) unsigned NOT NULL,
134 `name` char(64) NOT NULL,
135 `parent_category_id` smallint(5) unsigned DEFAULT NULL,
136 `url` text NOT NULL,
137 PRIMARY KEY (`help_category_id`),
138 UNIQUE KEY `name` (`name`)
139) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='help categories';
140
141-- Exportação de dados foi desmarcado.
142-- Copiando estrutura para tabela mysql.help_keyword
143CREATE TABLE IF NOT EXISTS `help_keyword` (
144 `help_keyword_id` int(10) unsigned NOT NULL,
145 `name` char(64) NOT NULL,
146 PRIMARY KEY (`help_keyword_id`),
147 UNIQUE KEY `name` (`name`)
148) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='help keywords';
149
150-- Exportação de dados foi desmarcado.
151-- Copiando estrutura para tabela mysql.help_relation
152CREATE TABLE IF NOT EXISTS `help_relation` (
153 `help_topic_id` int(10) unsigned NOT NULL,
154 `help_keyword_id` int(10) unsigned NOT NULL,
155 PRIMARY KEY (`help_keyword_id`,`help_topic_id`)
156) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='keyword-topic relation';
157
158-- Exportação de dados foi desmarcado.
159-- Copiando estrutura para tabela mysql.help_topic
160CREATE TABLE IF NOT EXISTS `help_topic` (
161 `help_topic_id` int(10) unsigned NOT NULL,
162 `name` char(64) NOT NULL,
163 `help_category_id` smallint(5) unsigned NOT NULL,
164 `description` text NOT NULL,
165 `example` text NOT NULL,
166 `url` text NOT NULL,
167 PRIMARY KEY (`help_topic_id`),
168 UNIQUE KEY `name` (`name`)
169) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='help topics';
170
171-- Exportação de dados foi desmarcado.
172-- Copiando estrutura para tabela mysql.innodb_index_stats
173CREATE TABLE IF NOT EXISTS `innodb_index_stats` (
174 `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
175 `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
176 `index_name` varchar(64) COLLATE utf8_bin NOT NULL,
177 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
178 `stat_name` varchar(64) COLLATE utf8_bin NOT NULL,
179 `stat_value` bigint(20) unsigned NOT NULL,
180 `sample_size` bigint(20) unsigned DEFAULT NULL,
181 `stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,
182 PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
183) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
184
185-- Exportação de dados foi desmarcado.
186-- Copiando estrutura para tabela mysql.innodb_table_stats
187CREATE TABLE IF NOT EXISTS `innodb_table_stats` (
188 `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
189 `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
190 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
191 `n_rows` bigint(20) unsigned NOT NULL,
192 `clustered_index_size` bigint(20) unsigned NOT NULL,
193 `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
194 PRIMARY KEY (`database_name`,`table_name`)
195) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
196
197-- Exportação de dados foi desmarcado.
198-- Copiando estrutura para tabela mysql.ndb_binlog_index
199CREATE TABLE IF NOT EXISTS `ndb_binlog_index` (
200 `Position` bigint(20) unsigned NOT NULL,
201 `File` varchar(255) NOT NULL,
202 `epoch` bigint(20) unsigned NOT NULL,
203 `inserts` int(10) unsigned NOT NULL,
204 `updates` int(10) unsigned NOT NULL,
205 `deletes` int(10) unsigned NOT NULL,
206 `schemaops` int(10) unsigned NOT NULL,
207 `orig_server_id` int(10) unsigned NOT NULL,
208 `orig_epoch` bigint(20) unsigned NOT NULL,
209 `gci` int(10) unsigned NOT NULL,
210 `next_position` bigint(20) unsigned NOT NULL,
211 `next_file` varchar(255) NOT NULL,
212 PRIMARY KEY (`epoch`,`orig_server_id`,`orig_epoch`)
213) ENGINE=MyISAM DEFAULT CHARSET=latin1;
214
215-- Exportação de dados foi desmarcado.
216-- Copiando estrutura para tabela mysql.plugin
217CREATE TABLE IF NOT EXISTS `plugin` (
218 `name` varchar(64) NOT NULL DEFAULT '',
219 `dl` varchar(128) NOT NULL DEFAULT '',
220 PRIMARY KEY (`name`)
221) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='MySQL plugins';
222
223-- Exportação de dados foi desmarcado.
224-- Copiando estrutura para tabela mysql.proc
225CREATE TABLE IF NOT EXISTS `proc` (
226 `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
227 `name` char(64) NOT NULL DEFAULT '',
228 `type` enum('FUNCTION','PROCEDURE') NOT NULL,
229 `specific_name` char(64) NOT NULL DEFAULT '',
230 `language` enum('SQL') NOT NULL DEFAULT 'SQL',
231 `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
232 `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
233 `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
234 `param_list` blob NOT NULL,
235 `returns` longblob NOT NULL,
236 `body` longblob NOT NULL,
237 `definer` char(93) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
238 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
239 `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
240 `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 '',
241 `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
242 `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
243 `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
244 `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
245 `body_utf8` longblob,
246 PRIMARY KEY (`db`,`name`,`type`)
247) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';
248
249-- Exportação de dados foi desmarcado.
250-- Copiando estrutura para tabela mysql.procs_priv
251CREATE TABLE IF NOT EXISTS `procs_priv` (
252 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
253 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
254 `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
255 `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
256 `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
257 `Grantor` char(93) COLLATE utf8_bin NOT NULL DEFAULT '',
258 `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
259 `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
260 PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
261 KEY `Grantor` (`Grantor`)
262) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';
263
264-- Exportação de dados foi desmarcado.
265-- Copiando estrutura para tabela mysql.proxies_priv
266CREATE TABLE IF NOT EXISTS `proxies_priv` (
267 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
268 `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
269 `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
270 `Proxied_user` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
271 `With_grant` tinyint(1) NOT NULL DEFAULT '0',
272 `Grantor` char(93) COLLATE utf8_bin NOT NULL DEFAULT '',
273 `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
274 PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
275 KEY `Grantor` (`Grantor`)
276) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';
277
278-- Exportação de dados foi desmarcado.
279-- Copiando estrutura para tabela mysql.servers
280CREATE TABLE IF NOT EXISTS `servers` (
281 `Server_name` char(64) NOT NULL DEFAULT '',
282 `Host` char(64) NOT NULL DEFAULT '',
283 `Db` char(64) NOT NULL DEFAULT '',
284 `Username` char(64) NOT NULL DEFAULT '',
285 `Password` char(64) NOT NULL DEFAULT '',
286 `Port` int(4) NOT NULL DEFAULT '0',
287 `Socket` char(64) NOT NULL DEFAULT '',
288 `Wrapper` char(64) NOT NULL DEFAULT '',
289 `Owner` char(64) NOT NULL DEFAULT '',
290 PRIMARY KEY (`Server_name`)
291) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='MySQL Foreign Servers table';
292
293-- Exportação de dados foi desmarcado.
294-- Copiando estrutura para tabela mysql.server_cost
295CREATE TABLE IF NOT EXISTS `server_cost` (
296 `cost_name` varchar(64) NOT NULL,
297 `cost_value` float DEFAULT NULL,
298 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
299 `comment` varchar(1024) DEFAULT NULL,
300 PRIMARY KEY (`cost_name`)
301) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0;
302
303-- Exportação de dados foi desmarcado.
304-- Copiando estrutura para tabela mysql.slave_master_info
305CREATE TABLE IF NOT EXISTS `slave_master_info` (
306 `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',
307 `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
308 `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',
309 `Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'The host name of the master.',
310 `User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',
311 `User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',
312 `Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
313 `Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
314 `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
315 `Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
316 `Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
317 `Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',
318 `Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',
319 `Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',
320 `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
321 `Heartbeat` float NOT NULL,
322 `Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
323 `Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
324 `Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',
325 `Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
326 `Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
327 `Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
328 `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
329 `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
330 `Tls_version` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Tls version',
331 PRIMARY KEY (`Channel_name`)
332) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';
333
334-- Exportação de dados foi desmarcado.
335-- Copiando estrutura para tabela mysql.slave_relay_log_info
336CREATE TABLE IF NOT EXISTS `slave_relay_log_info` (
337 `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
338 `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',
339 `Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.',
340 `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
341 `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.',
342 `Sql_delay` int(11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
343 `Number_of_workers` int(10) unsigned NOT NULL,
344 `Id` int(10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.',
345 `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
346 PRIMARY KEY (`Channel_name`)
347) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';
348
349-- Exportação de dados foi desmarcado.
350-- Copiando estrutura para tabela mysql.slave_worker_info
351CREATE TABLE IF NOT EXISTS `slave_worker_info` (
352 `Id` int(10) unsigned NOT NULL,
353 `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
354 `Relay_log_pos` bigint(20) unsigned NOT NULL,
355 `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
356 `Master_log_pos` bigint(20) unsigned NOT NULL,
357 `Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
358 `Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,
359 `Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
360 `Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,
361 `Checkpoint_seqno` int(10) unsigned NOT NULL,
362 `Checkpoint_group_size` int(10) unsigned NOT NULL,
363 `Checkpoint_group_bitmap` blob NOT NULL,
364 `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
365 PRIMARY KEY (`Channel_name`,`Id`)
366) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';
367
368-- Exportação de dados foi desmarcado.
369-- Copiando estrutura para tabela mysql.slow_log
370CREATE TABLE IF NOT EXISTS `slow_log` (
371 `start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
372 `user_host` mediumtext NOT NULL,
373 `query_time` time(6) NOT NULL,
374 `lock_time` time(6) NOT NULL,
375 `rows_sent` int(11) NOT NULL,
376 `rows_examined` int(11) NOT NULL,
377 `db` varchar(512) NOT NULL,
378 `last_insert_id` int(11) NOT NULL,
379 `insert_id` int(11) NOT NULL,
380 `server_id` int(10) unsigned NOT NULL,
381 `sql_text` mediumblob NOT NULL,
382 `thread_id` bigint(21) unsigned NOT NULL
383) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';
384
385-- Exportação de dados foi desmarcado.
386-- Copiando estrutura para tabela mysql.tables_priv
387CREATE TABLE IF NOT EXISTS `tables_priv` (
388 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
389 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
390 `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
391 `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
392 `Grantor` char(93) COLLATE utf8_bin NOT NULL DEFAULT '',
393 `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
394 `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
395 `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
396 PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
397 KEY `Grantor` (`Grantor`)
398) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';
399
400-- Exportação de dados foi desmarcado.
401-- Copiando estrutura para tabela mysql.time_zone
402CREATE TABLE IF NOT EXISTS `time_zone` (
403 `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
404 `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
405 PRIMARY KEY (`Time_zone_id`)
406) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zones';
407
408-- Exportação de dados foi desmarcado.
409-- Copiando estrutura para tabela mysql.time_zone_leap_second
410CREATE TABLE IF NOT EXISTS `time_zone_leap_second` (
411 `Transition_time` bigint(20) NOT NULL,
412 `Correction` int(11) NOT NULL,
413 PRIMARY KEY (`Transition_time`)
414) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Leap seconds information for time zones';
415
416-- Exportação de dados foi desmarcado.
417-- Copiando estrutura para tabela mysql.time_zone_name
418CREATE TABLE IF NOT EXISTS `time_zone_name` (
419 `Name` char(64) NOT NULL,
420 `Time_zone_id` int(10) unsigned NOT NULL,
421 PRIMARY KEY (`Name`)
422) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zone names';
423
424-- Exportação de dados foi desmarcado.
425-- Copiando estrutura para tabela mysql.time_zone_transition
426CREATE TABLE IF NOT EXISTS `time_zone_transition` (
427 `Time_zone_id` int(10) unsigned NOT NULL,
428 `Transition_time` bigint(20) NOT NULL,
429 `Transition_type_id` int(10) unsigned NOT NULL,
430 PRIMARY KEY (`Time_zone_id`,`Transition_time`)
431) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zone transitions';
432
433-- Exportação de dados foi desmarcado.
434-- Copiando estrutura para tabela mysql.time_zone_transition_type
435CREATE TABLE IF NOT EXISTS `time_zone_transition_type` (
436 `Time_zone_id` int(10) unsigned NOT NULL,
437 `Transition_type_id` int(10) unsigned NOT NULL,
438 `Offset` int(11) NOT NULL DEFAULT '0',
439 `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
440 `Abbreviation` char(8) NOT NULL DEFAULT '',
441 PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
442) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zone transition types';
443
444-- Exportação de dados foi desmarcado.
445-- Copiando estrutura para tabela mysql.user
446CREATE TABLE IF NOT EXISTS `user` (
447 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
448 `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
449 `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
450 `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
451 `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
452 `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
453 `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
454 `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
455 `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
456 `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
457 `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
458 `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
459 `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
460 `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
461 `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
462 `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
463 `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
464 `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
465 `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
466 `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
467 `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
468 `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
469 `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
470 `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
471 `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
472 `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
473 `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
474 `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
475 `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
476 `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
477 `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
478 `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
479 `ssl_cipher` blob NOT NULL,
480 `x509_issuer` blob NOT NULL,
481 `x509_subject` blob NOT NULL,
482 `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
483 `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
484 `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
485 `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
486 `plugin` char(64) COLLATE utf8_bin NOT NULL DEFAULT 'mysql_native_password',
487 `authentication_string` text COLLATE utf8_bin,
488 `password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
489 `password_last_changed` timestamp NULL DEFAULT NULL,
490 `password_lifetime` smallint(5) unsigned DEFAULT NULL,
491 `account_locked` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
492 PRIMARY KEY (`Host`,`User`)
493) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';
494
495-- Exportação de dados foi desmarcado.
496/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
497/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
498/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;