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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop id
id_2 UNIQUE Edit Drop id
forum_id_3 UNIQUE Edit Drop forum_id
type_2 UNIQUE Edit Drop type
pcre_2 UNIQUE Edit Drop pcre
string_2 UNIQUE Edit Drop string
pcre_3 UNIQUE Edit Drop pcre
string_4 UNIQUE Edit Drop string
forum_id_4 UNIQUE Edit Drop forum_id
id_4 UNIQUE Edit Drop id
type_4 UNIQUE Edit Drop type
forum_id_6 UNIQUE Edit Drop forum_id
id_6 UNIQUE Edit Drop id
pcre_6 UNIQUE Edit Drop pcre
string_7 UNIQUE Edit Drop string
type_6 UNIQUE Edit Drop type
id_7 UNIQUE Edit Drop id
forum_id_8 UNIQUE Edit Drop forum_id
pcre_8 UNIQUE Edit Drop pcre
id_9 UNIQUE Edit Drop id
string_11 UNIQUE Edit Drop string
pcre_10 UNIQUE Edit Drop pcre
string_12 UNIQUE Edit Drop string
forum_id_10 UNIQUE Edit Drop forum_id
type_8 UNIQUE Edit Drop type
id_12 UNIQUE Edit Drop id
forum_id_13 UNIQUE Edit Drop forum_id
type_10 UNIQUE Edit Drop type
pcre_12 UNIQUE Edit Drop pcre
string_16 UNIQUE Edit Drop string
forum_id INDEX None  Edit Drop forum_id
id INDEX None  Edit Drop id
forum_id_2 INDEX None  Edit Drop forum_id
type INDEX None  Edit Drop type
pcre INDEX None  Edit Drop pcre
string INDEX None  Edit Drop string
pcre_4 INDEX None  Edit Drop pcre
id_3 INDEX None  Edit Drop id
type_3 INDEX None  Edit Drop type
string_6 INDEX None  Edit Drop string
forum_id_5 INDEX None  Edit Drop forum_id
id_5 INDEX None  Edit Drop id
pcre_5 INDEX None  Edit Drop pcre
type_5 INDEX None  Edit Drop type
forum_id_7 INDEX None  Edit Drop forum_id
string_9 INDEX None  Edit Drop string
pcre_7 INDEX None  Edit Drop pcre
id_8 INDEX None  Edit Drop id
pcre_9 INDEX None  Edit Drop pcre
forum_id_9 INDEX None  Edit Drop forum_id
id_10 INDEX None  Edit Drop id
string_10 INDEX None  Edit Drop string
type_7 INDEX None  Edit Drop type
forum_id_11 INDEX None  Edit Drop forum_id
string_14 INDEX None  Edit Drop string
id_11 INDEX None  Edit Drop id
forum_id_12 INDEX None  Edit Drop forum_id
type_9 INDEX None  Edit Drop type
pcre_11 INDEX None  Edit Drop pcre
string_15 INDEX None  Edit Drop string
string_3 FULLTEXT None  Edit Drop string
string_5 FULLTEXT None  Edit Drop string
string_8 FULLTEXT None  Edit Drop string
string_13 FULLTEXT None  Edit Drop string
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 0
Next Autoindex 1
Creation Apr 20, 2018 at 03:40 AM
Last update Apr 20, 2018 at 03:40 AM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: