Properties

Engine: MyISAM 
Row format:
Rows: Fixed 
Avg row length:
Data length:
Max data length:
Index length: 3655017168895 
Data free: 1024 
Auto increment:
Create time:  
Update time: 2006/19/07/2006 
Check time: 2006/19/07/2006 
Create_options:  
Comment: utf8_bin 

Columns

Name Data Type NULL Default
    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)

Indexes

Name Primary Unique
  PRIMARY     
  Grantor     
Total: 2 indexes(s)

SQL

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'

See Also

List of tables