diff options
author | unknown <pem@mysql.comhem.se> | 2003-12-16 19:14:10 +0100 |
---|---|---|
committer | unknown <pem@mysql.comhem.se> | 2003-12-16 19:14:10 +0100 |
commit | fd4544879b91fec027909f3607fe9fa68a214241 (patch) | |
tree | 12a86bd8ee75acaeb07b307f9ac5935d4e1fe80d /scripts/mysql_fix_privilege_tables.sql | |
parent | bc748bef530dcbcd155f3fe58f68d77520d7d264 (diff) | |
download | mariadb-git-fd4544879b91fec027909f3607fe9fa68a214241.tar.gz |
Renamed the "schema" column to "db" in mysql.proc to keep it in style with
all the other mysql.* tables.
Diffstat (limited to 'scripts/mysql_fix_privilege_tables.sql')
-rw-r--r-- | scripts/mysql_fix_privilege_tables.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/mysql_fix_privilege_tables.sql b/scripts/mysql_fix_privilege_tables.sql index 788913fa38e..115236948c9 100644 --- a/scripts/mysql_fix_privilege_tables.sql +++ b/scripts/mysql_fix_privilege_tables.sql @@ -140,7 +140,7 @@ unique index (name) # CREATE TABLE IF NOT EXISTS proc ( - schema char(64) binary DEFAULT '' NOT NULL, + db char(64) binary DEFAULT '' NOT NULL, name char(64) binary DEFAULT '' NOT NULL, type enum('FUNCTION','PROCEDURE') NOT NULL, specific_name char(64) binary DEFAULT '' NOT NULL, @@ -177,5 +177,5 @@ CREATE TABLE IF NOT EXISTS proc ( 'NO_AUTO_VALUE_ON_ZERO' ) DEFAULT 0 NOT NULL, comment char(64) binary DEFAULT '' NOT NULL, - PRIMARY KEY (schema,name,type) + PRIMARY KEY (db,name,type) ) comment='Stored Procedures'; |