diff options
| author | unknown <kent@mysql.com> | 2005-05-26 02:07:13 +0200 |
|---|---|---|
| committer | unknown <kent@mysql.com> | 2005-05-26 02:07:13 +0200 |
| commit | 6a77c469f3bb7900b2a5cf0fbc27ebd585802de0 (patch) | |
| tree | 1dede67d0ebdee8278e70e2411b6868f3e2528cf /mysql-test | |
| parent | 5752ecea9585df2f85316ed04bd099b75147b2e1 (diff) | |
| download | mariadb-git-6a77c469f3bb7900b2a5cf0fbc27ebd585802de0.tar.gz | |
init_db.sql:
Updated test data in system tables
mysql-test/lib/init_db.sql:
Updated test data in system tables
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/lib/init_db.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/mysql-test/lib/init_db.sql b/mysql-test/lib/init_db.sql index 18699497b64..9671de49ca5 100644 --- a/mysql-test/lib/init_db.sql +++ b/mysql-test/lib/init_db.sql @@ -50,6 +50,9 @@ CREATE TABLE host ( Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, + Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, + Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, + Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, PRIMARY KEY Host (Host,Db) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin @@ -489,10 +492,11 @@ CREATE TABLE procs_priv ( Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Routine_name char(64) binary DEFAULT '' NOT NULL, + Routine_type enum('FUNCTION','PROCEDURE') NOT NULL, Grantor char(77) DEFAULT '' NOT NULL, - Timestamp timestamp(14), Proc_priv set('Execute','Alter Routine','Grant') COLLATE utf8_general_ci DEFAULT '' NOT NULL, - PRIMARY KEY (Host,Db,User,Routine_name), + Timestamp timestamp(14), + PRIMARY KEY (Host,Db,User,Routine_name,Routine_type), KEY Grantor (Grantor) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin |