diff options
| author | unknown <monty@mishka.mysql.fi> | 2003-10-01 16:50:50 +0300 |
|---|---|---|
| committer | unknown <monty@mishka.mysql.fi> | 2003-10-01 16:50:50 +0300 |
| commit | 422bb4fcc5efa70436f5bbe6246438f48fce9c60 (patch) | |
| tree | 707550eb4c0b027afb168a1263f0c077e92d279b /scripts | |
| parent | 03042c7db4be039b0088de24bd5b7b50f76c91b5 (diff) | |
| download | mariadb-git-422bb4fcc5efa70436f5bbe6246438f48fce9c60.tar.gz | |
Add proc table if not exists
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/mysql_fix_privilege_tables.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/scripts/mysql_fix_privilege_tables.sql b/scripts/mysql_fix_privilege_tables.sql index 220bf4036db..4adc0655434 100644 --- a/scripts/mysql_fix_privilege_tables.sql +++ b/scripts/mysql_fix_privilege_tables.sql @@ -99,3 +99,20 @@ ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL; ALTER TABLE host ADD Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL, ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL; + +# +# Create proc table if it doesn't exists +# + +CREATE TABLE IF NOT EXISTS proc ( + name char(64) binary DEFAULT '' NOT NULL, + type enum('function','procedure') NOT NULL, + body blob DEFAULT '' NOT NULL, + creator char(77) binary DEFAULT '' NOT NULL, + modified timestamp, + created timestamp, + suid enum ('N', 'Y') DEFAULT 'Y' NOT NULL, + comment char(64) binary DEFAULT '' NOT NULL, + PRIMARY KEY (name,type) +) comment='Stored Procedures'; + |