MyISAM |
9 |
Fixed |
0 |
0 |
0 |
3655017168895 |
1024 |
0 |
|
2006/19/07/2006 |
2006/19/07/2006 |
|
utf8_bin |
|
|
Host |
char(60) |
|
PRI |
|
|
Db |
char(64) |
|
PRI |
|
|
User |
char(16) |
|
PRI |
|
|
Table_name |
char(64) |
|
PRI |
|
|
Grantor |
char(77) |
|
MUL |
|
|
Timestamp |
timestamp |
|
|
|
|
Table_priv |
set('Select', 'Insert', 'Update', 'Delete', |
|
|
|
|
Column_priv |
set('Select', 'Insert', 'Update', 'Referenc |
|
|
Total: 8 column(s)
Total: 2 indexes(s)
CREATE TABLE `tables_priv` (
`Host` char(60) collate utf8_bin NOT NULL default '',
`Db` char(64) collate utf8_bin NOT NULL default '',
`User` char(16) collate utf8_bin NOT NULL default '',
`Table_name` char(64) collate utf8_bin NOT NULL default '',
`Grantor` char(77) collate utf8_bin NOT NULL default '',
`Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') character set utf8 NOT NULL default '',
`Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',
PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges'
List of tables