mysql.puroparty.com
puroparty
photopost_usergroups
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: photopost_usergroups
|
| Field | Type | Null | Default |
|---|---|---|---|
| groupid | int(5) | No | |
| groupname | varchar(50) | No | |
| cpaccess | smallint(3) | No | 0 |
| modaccess | smallint(3) | No | 0 |
| uploads | smallint(3) | No | 1 |
| comments | smallint(3) | No | 1 |
| diskspace | int(10) | Yes | NULL |
| uploadsize | int(10) | Yes | NULL |
| uplimit | int(5) | No | 0 |
| editpho | int(3) | No | 0 |
| editposts | int(3) | No | 0 |
| useralbums | int(3) | No | 0 |
| reqmod | int(3) | No | 0 |
| canassign | int(3) | No | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 5 | groupid | |
| groupid_2 | UNIQUE | 5 | groupid | |
| groupname_2 | UNIQUE | 5 | groupname | |
| groupid_3 | UNIQUE | 5 | groupid | |
| groupname_6 | UNIQUE | 5 | groupname | |
| groupid_5 | UNIQUE | 5 | groupid | |
| groupname_9 | UNIQUE | 5 | groupname | |
| groupid_7 | UNIQUE | 5 | groupid | |
| modaccess_4 | UNIQUE | 5 | modaccess | |
| groupid | INDEX | None | groupid | |
| groupname | INDEX | None | groupname | |
| cpaccess | INDEX | None | cpaccess | |
| modaccess | INDEX | None | modaccess | |
| uploads | INDEX | None | uploads | |
| comments | INDEX | None | comments | |
| diskspace | INDEX | None | diskspace | |
| uploadsize | INDEX | None | uploadsize | |
| uplimit | INDEX | None | uplimit | |
| editpho | INDEX | None | editpho | |
| editposts | INDEX | None | editposts | |
| useralbums | INDEX | None | useralbums | |
| reqmod | INDEX | None | reqmod | |
| canassign | INDEX | None | canassign | |
| groupname_4 | INDEX | None | groupname | |
| uplimit_2 | INDEX | None | uplimit | |
| diskspace_2 | INDEX | None | diskspace | |
| uploadsize_2 | INDEX | None | uploadsize | |
| cpaccess_2 | INDEX | None | cpaccess | |
| uploads_2 | INDEX | None | uploads | |
| editpho_2 | INDEX | None | editpho | |
| useralbums_2 | INDEX | None | useralbums | |
| comments_2 | INDEX | None | comments | |
| canassign_2 | INDEX | None | canassign | |
| modaccess_2 | INDEX | None | modaccess | |
| groupid_4 | INDEX | None | groupid | |
| editposts_2 | INDEX | None | editposts | |
| reqmod_2 | INDEX | None | reqmod | |
| uplimit_3 | INDEX | None | uplimit | |
| diskspace_3 | INDEX | None | diskspace | |
| editpho_3 | INDEX | None | editpho | |
| uploads_3 | INDEX | None | uploads | |
| uploadsize_3 | INDEX | None | uploadsize | |
| cpaccess_3 | INDEX | None | cpaccess | |
| useralbums_3 | INDEX | None | useralbums | |
| groupname_8 | INDEX | None | groupname | |
| editposts_3 | INDEX | None | editposts | |
| reqmod_3 | INDEX | None | reqmod | |
| modaccess_3 | INDEX | None | modaccess | |
| groupid_6 | INDEX | None | groupid | |
| canassign_3 | INDEX | None | canassign | |
| comments_3 | INDEX | None | comments | |
| uplimit_4 | INDEX | None | uplimit | |
| diskspace_4 | INDEX | None | diskspace | |
| cpaccess_4 | INDEX | None | cpaccess | |
| editpho_4 | INDEX | None | editpho | |
| uploads_4 | INDEX | None | uploads | |
| uploadsize_4 | INDEX | None | uploadsize | |
| editposts_4 | INDEX | None | editposts | |
| useralbums_4 | INDEX | None | useralbums | |
| groupname_11 | INDEX | None | groupname | |
| groupname_3 | INDEX | None | groupname | |
| groupname_5 | INDEX | None | groupname | |
| groupname_7 | INDEX | None | groupname | |
| groupname_10 | INDEX | None | groupname | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||