diff options
| author | monty@mysql.com <> | 2004-05-25 22:00:14 +0300 |
|---|---|---|
| committer | monty@mysql.com <> | 2004-05-25 22:00:14 +0300 |
| commit | f2e1e3ce4c72d383f16fd8c525b28c4912e8f2de (patch) | |
| tree | 2c56473da947b9807f0d1668171870a8e3dbc736 /netware/init_db.sql | |
| parent | d14e4eb57c92b987152b255ec961b1e9103d8f66 (diff) | |
| download | mariadb-git-f2e1e3ce4c72d383f16fd8c525b28c4912e8f2de.tar.gz | |
Added patches from Novell
Diffstat (limited to 'netware/init_db.sql')
| -rw-r--r-- | netware/init_db.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/netware/init_db.sql b/netware/init_db.sql index 1e8354e13a1..569c7bd5283 100644 --- a/netware/init_db.sql +++ b/netware/init_db.sql @@ -20,6 +20,6 @@ INSERT INTO user (host,user) values ('%',''); CREATE TABLE func (name char(64) binary DEFAULT '' NOT NULL, ret tinyint(1) DEFAULT '0' NOT NULL, dl char(128) DEFAULT '' NOT NULL, type enum ('function','aggregate') NOT NULL, PRIMARY KEY (name)) comment='User defined functions'; -CREATE TABLE tables_priv (Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Table_name char(60) binary DEFAULT '' NOT NULL, Grantor char(77) DEFAULT '' NOT NULL, Timestamp timestamp(14), Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL, Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name), KEY Grantor (Grantor)) comment='Table privileges'; +CREATE TABLE tables_priv (Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL, Grantor char(77) DEFAULT '' NOT NULL, Timestamp timestamp(14), Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL, Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name), KEY Grantor (Grantor)) comment='Table privileges'; CREATE TABLE columns_priv (Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL, Column_name char(64) binary 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)) comment='Column privileges'; |