From fd4544879b91fec027909f3607fe9fa68a214241 Mon Sep 17 00:00:00 2001
From: unknown <pem@mysql.comhem.se>
Date: Tue, 16 Dec 2003 19:14:10 +0100
Subject: Renamed the "schema" column to "db" in mysql.proc to keep it in style
 with all the other mysql.* tables.

---
 scripts/mysql_fix_privilege_tables.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'scripts/mysql_fix_privilege_tables.sql')

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';
-- 
cgit v1.2.1

