Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: phorum_banlistsphorum_banlists

phorum_banlists

Field Type Null Default
id  int(11) No   
forum_id  int(11) No 
type  tinyint(4) No 
pcre  tinyint(4) No 
string  varchar(255) No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 id
id_2 UNIQUE 0 id
forum_id_3 UNIQUE 0 forum_id
type_2 UNIQUE 0 type
pcre_2 UNIQUE 0 pcre
string_2 UNIQUE 0 string
pcre_3 UNIQUE 0 pcre
string_4 UNIQUE 0 string
forum_id_4 UNIQUE 0 forum_id
id_4 UNIQUE 0 id
type_4 UNIQUE 0 type
forum_id_6 UNIQUE 0 forum_id
id_6 UNIQUE 0 id
pcre_6 UNIQUE 0 pcre
string_7 UNIQUE 0 string
type_6 UNIQUE 0 type
id_7 UNIQUE 0 id
forum_id_8 UNIQUE 0 forum_id
pcre_8 UNIQUE 0 pcre
id_9 UNIQUE 0 id
string_11 UNIQUE 0 string
pcre_10 UNIQUE 0 pcre
string_12 UNIQUE 0 string
forum_id_10 UNIQUE 0 forum_id
type_8 UNIQUE 0 type
forum_id INDEX None forum_id
id INDEX None id
forum_id_2 INDEX None forum_id
type INDEX None type
pcre INDEX None pcre
string INDEX None string
pcre_4 INDEX None pcre
id_3 INDEX None id
type_3 INDEX None type
string_6 INDEX None string
forum_id_5 INDEX None forum_id
id_5 INDEX None id
pcre_5 INDEX None pcre
type_5 INDEX None type
forum_id_7 INDEX None forum_id
string_9 INDEX None string
pcre_7 INDEX None pcre
id_8 INDEX None id
pcre_9 INDEX None pcre
forum_id_9 INDEX None forum_id
id_10 INDEX None id
string_10 INDEX None string
type_7 INDEX None type
forum_id_11 INDEX None forum_id
string_3 INDEX None string
string_5 INDEX None string
string_8 INDEX None string
string_13 INDEX None string


 Space usage :
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Apr 19, 2018 at 07:11 AM
Last update Apr 19, 2018 at 07:11 AM
Last check Apr 19, 2018 at 07:11 AM