Debian Codegraph @

mysql-test/suite/mariabackup/xb_history.result

raw
1 DROP TABLE IF EXISTS mysql.mariadb_backup_history;
2 SHOW CREATE TABLE mysql.mariadb_backup_history;
3 Table Create Table
4 mariadb_backup_history CREATE TABLE `mariadb_backup_history` (
5 `uuid` varchar(40) NOT NULL,
6 `name` varchar(255) DEFAULT NULL,
7 `tool_name` varchar(255) DEFAULT NULL,
8 `tool_command` text DEFAULT NULL,
9 `tool_version` varchar(255) DEFAULT NULL,
10 `ibbackup_version` varchar(255) DEFAULT NULL,
11 `server_version` varchar(255) DEFAULT NULL,
12 `start_time` timestamp NULL DEFAULT NULL,
13 `end_time` timestamp NULL DEFAULT NULL,
14 `lock_time` bigint(20) unsigned DEFAULT NULL,
15 `binlog_pos` varchar(128) DEFAULT NULL,
16 `innodb_from_lsn` bigint(20) unsigned DEFAULT NULL,
17 `innodb_to_lsn` bigint(20) unsigned DEFAULT NULL,
18 `partial` enum('Y','N') DEFAULT NULL,
19 `incremental` enum('Y','N') DEFAULT NULL,
20 `format` enum('file','tar','mbstream') DEFAULT NULL,
21 `compressed` enum('Y','N') DEFAULT NULL,
22 PRIMARY KEY (`uuid`)
23 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
24 SELECT COUNT(*) FROM mysql.mariadb_backup_history;
25 COUNT(*)
26 1
27 SELECT name FROM mysql.mariadb_backup_history;
28 name
29 foo
30 SELECT COUNT(*) FROM mysql.mariadb_backup_history;
31 COUNT(*)
32 2
33 SELECT name FROM mysql.mariadb_backup_history;
34 name
35
36 foo
37 DROP TABLE mysql.mariadb_backup_history;