summaryrefslogtreecommitdiff
path: root/scripts/mysql_system_tables_fix.sql
diff options
context:
space:
mode:
authormsvensson@pilot.blaudden <>2007-04-18 16:23:19 +0200
committermsvensson@pilot.blaudden <>2007-04-18 16:23:19 +0200
commit76285bdf31d0add956441eb81db7a90b5950f05f (patch)
tree0845aba6c9b63f58b4dcb2622c2e5bba4399535a /scripts/mysql_system_tables_fix.sql
parent01133f8e6f1d1c1ef46b2befda753756e12d7252 (diff)
downloadmariadb-git-76285bdf31d0add956441eb81db7a90b5950f05f.tar.gz
Update mysql_upgrade tests for 5.1
Add "two liner" to mysqld --bootstrap that allows wo write scripts that can be run both by mysql and mysqld --bootstrap Remove duplicate create of MySQL system tables
Diffstat (limited to 'scripts/mysql_system_tables_fix.sql')
-rw-r--r--scripts/mysql_system_tables_fix.sql39
1 files changed, 0 insertions, 39 deletions
diff --git a/scripts/mysql_system_tables_fix.sql b/scripts/mysql_system_tables_fix.sql
index e9816bd21e9..7985dc1802e 100644
--- a/scripts/mysql_system_tables_fix.sql
+++ b/scripts/mysql_system_tables_fix.sql
@@ -389,43 +389,6 @@ ALTER TABLE proc MODIFY db
char(64) collate utf8_bin DEFAULT '' NOT NULL;
#
-# Create missing log tables (5.1)
-#
-
-delimiter //
-CREATE PROCEDURE create_log_tables()
-BEGIN
- DECLARE is_csv_enabled int DEFAULT 0;
- SELECT @@have_csv = 'YES' INTO is_csv_enabled;
- IF (is_csv_enabled) THEN
- CREATE TABLE IF NOT EXISTS general_log (
- event_time TIMESTAMP NOT NULL,
- user_host MEDIUMTEXT,
- thread_id INTEGER,
- server_id INTEGER,
- command_type VARCHAR(64),
- argument MEDIUMTEXT
- ) engine=CSV CHARACTER SET utf8 comment='General log';
- CREATE TABLE IF NOT EXISTS slow_log (
- start_time TIMESTAMP NOT NULL,
- user_host MEDIUMTEXT NOT NULL,
- query_time TIME NOT NULL,
- lock_time TIME NOT NULL,
- rows_sent INTEGER NOT NULL,
- rows_examined INTEGER NOT NULL,
- db VARCHAR(512),
- last_insert_id INTEGER,
- insert_id INTEGER,
- server_id INTEGER,
- sql_text MEDIUMTEXT NOT NULL
- ) engine=CSV CHARACTER SET utf8 comment='Slow log';
- END IF;
-END//
-delimiter ;
-CALL create_log_tables();
-DROP PROCEDURE create_log_tables;
-
-#
# EVENT privilege
#
SET @hadEventPriv := 0;
@@ -503,8 +466,6 @@ ALTER TABLE tables_priv MODIFY Table_priv set('Select','Insert','Update','Delete
UPDATE user SET Trigger_priv=Super_priv WHERE @hadTriggerPriv = 0;
-CREATE TABLE IF NOT EXISTS ndb_binlog_index (Position BIGINT UNSIGNED NOT NULL, File VARCHAR(255) NOT NULL, epoch BIGINT UNSIGNED NOT NULL, inserts BIGINT UNSIGNED NOT NULL, updates BIGINT UNSIGNED NOT NULL, deletes BIGINT UNSIGNED NOT NULL, schemaops BIGINT UNSIGNED NOT NULL, PRIMARY KEY(epoch)) ENGINE=MYISAM;
-
# Activate the new, possible modified privilege tables
# This should not be needed, but gives us some extra testing that the above
# changes was correct