diff options
author | Aleksey Midenkov <midenok@gmail.com> | 2017-12-17 12:29:01 +0300 |
---|---|---|
committer | Aleksey Midenkov <midenok@gmail.com> | 2017-12-17 12:32:33 +0300 |
commit | d5e37621cf1dd2fe1a1226992be05ca57d595b79 (patch) | |
tree | 04e9630f52062f7795ae638c9ffa32e0ec16aa5e /scripts/mysql_system_tables.sql | |
parent | 62b44b0efa36c6670780cea448d52101c728273f (diff) | |
download | mariadb-git-d5e37621cf1dd2fe1a1226992be05ca57d595b79.tar.gz |
Scripts: VTMD_TEMPLATE removed [#286]
Diffstat (limited to 'scripts/mysql_system_tables.sql')
-rw-r--r-- | scripts/mysql_system_tables.sql | 16 |
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.', |