diff options
| author | jimw@mysql.com <> | 2005-01-07 19:50:41 +0100 |
|---|---|---|
| committer | jimw@mysql.com <> | 2005-01-07 19:50:41 +0100 |
| commit | 804a952f9bd1b70ada98449c09274f1f95b57a19 (patch) | |
| tree | 1aa2d0e1afc8f261011d30042de178d4860fbb51 /scripts | |
| parent | 6db617149451124fbe5ee211be76b87a82fdb355 (diff) | |
| download | mariadb-git-804a952f9bd1b70ada98449c09274f1f95b57a19.tar.gz | |
Create columns_priv with correct column lengths (the alter table
that used to fix it was removed in a merge, and now the alter table
that fixes the length comes before the create table so it fixes
pre-existing tables but not the newly-created one).
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/mysql_fix_privilege_tables.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/scripts/mysql_fix_privilege_tables.sql b/scripts/mysql_fix_privilege_tables.sql index 975d8dddbb0..9373a888bc2 100644 --- a/scripts/mysql_fix_privilege_tables.sql +++ b/scripts/mysql_fix_privilege_tables.sql @@ -93,10 +93,10 @@ CREATE TABLE IF NOT EXISTS tables_priv ( CREATE TABLE IF NOT EXISTS columns_priv ( Host char(60) DEFAULT '' NOT NULL, - Db char(60) DEFAULT '' NOT NULL, + Db char(64) DEFAULT '' NOT NULL, User char(16) DEFAULT '' NOT NULL, - Table_name char(60) DEFAULT '' NOT NULL, - Column_name char(59) DEFAULT '' NOT NULL, + Table_name char(64) DEFAULT '' NOT NULL, + Column_name char(64) DEFAULT '' NOT NULL, Timestamp timestamp(14), Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name,Column_name) |