moodthemes —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| moodthemeid | int unsigned auto_increment | |||
| ownerid | int unsigned | 0 | ||
| name | varchar(50) | YES | ||
| des | varchar(100) | YES | ||
| is_public | enum('Y','N') | N |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| is_public | INDEX | |
| ownerid | INDEX |