summaryrefslogtreecommitdiff
path: root/scripts/mysql_system_tables.sql
diff options
context:
space:
mode:
authorAleksey Midenkov <midenok@gmail.com>2017-12-17 12:29:01 +0300
committerAleksey Midenkov <midenok@gmail.com>2017-12-17 12:32:33 +0300
commitd5e37621cf1dd2fe1a1226992be05ca57d595b79 (patch)
tree04e9630f52062f7795ae638c9ffa32e0ec16aa5e /scripts/mysql_system_tables.sql
parent62b44b0efa36c6670780cea448d52101c728273f (diff)
downloadmariadb-git-d5e37621cf1dd2fe1a1226992be05ca57d595b79.tar.gz
Scripts: VTMD_TEMPLATE removed [#286]
Diffstat (limited to 'scripts/mysql_system_tables.sql')
-rw-r--r--scripts/mysql_system_tables.sql16
1 files changed, 0 insertions, 16 deletions
diff --git a/scripts/mysql_system_tables.sql b/scripts/mysql_system_tables.sql
index c010fffbf67..a607c096337 100644
--- a/scripts/mysql_system_tables.sql
+++ b/scripts/mysql_system_tables.sql
@@ -144,17 +144,6 @@ SET @create_transaction_registry="CREATE TABLE IF NOT EXISTS transaction_registr
INDEX (commit_timestamp, transaction_id)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0";
-SET @create_vtmd_template="CREATE OR REPLACE TABLE vtmd_template (
- start BIGINT UNSIGNED GENERATED ALWAYS AS ROW START COMMENT 'TRX_ID of table lifetime start',
- end BIGINT UNSIGNED GENERATED ALWAYS AS ROW END COMMENT 'TRX_ID of table lifetime end',
- name VARCHAR(64) NOT NULL COMMENT 'Table name during current lifetime period',
- archive_name VARCHAR(64) NULL COMMENT 'Name of archive table',
- col_renames BLOB COMMENT 'Column name mappings from previous lifetime',
- PERIOD FOR SYSTEM_TIME(start, end),
- PRIMARY KEY (end),
- INDEX (archive_name)
-) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0 WITH SYSTEM VERSIONING";
-
SET @str=IF(@have_innodb <> 0, @create_innodb_table_stats, "SET @dummy = 0");
PREPARE stmt FROM @str;
EXECUTE stmt;
@@ -170,11 +159,6 @@ PREPARE stmt FROM @str;
EXECUTE stmt;
DROP PREPARE stmt;
-SET @str=IF(@have_innodb <> 0, @create_vtmd_template, "SET @dummy = 0");
-PREPARE stmt FROM @str;
-EXECUTE stmt;
-DROP PREPARE stmt;
-
SET @cmd="CREATE TABLE IF NOT EXISTS slave_relay_log_info (
Number_of_lines INTEGER UNSIGNED NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
Relay_log_name TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',