Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Host | CHAR | 255 |
|
|
||||
| Db | CHAR | 64 |
|
|
||||
| User | CHAR | 32 |
|
|
||||
| Select_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Insert_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Update_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Delete_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Drop_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Grant_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| References_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Index_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Alter_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_tmp_table_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Lock_tables_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_view_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Show_view_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_routine_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Alter_routine_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Execute_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Event_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Trigger_priv | enum('N', 'Y') | 1 | N |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | Host + Db + User |
| User | Performance | Asc | User |
Relationships
Close relationships within degrees of separation
