summaryrefslogtreecommitdiff
path: root/scripts/mysql_fix_privilege_tables.sql
diff options
context:
space:
mode:
authorunknown <pem@mysql.comhem.se>2003-12-16 19:14:10 +0100
committerunknown <pem@mysql.comhem.se>2003-12-16 19:14:10 +0100
commitfd4544879b91fec027909f3607fe9fa68a214241 (patch)
tree12a86bd8ee75acaeb07b307f9ac5935d4e1fe80d /scripts/mysql_fix_privilege_tables.sql
parentbc748bef530dcbcd155f3fe58f68d77520d7d264 (diff)
downloadmariadb-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.sql4
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';