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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   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
   text utf8_general_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 15  Edit Drop id
id_2 UNIQUE 15  Edit Drop id
id_3 UNIQUE 15  Edit Drop id
id_5 UNIQUE 15  Edit Drop id
numnews_4 UNIQUE 15  Edit Drop numnews
module_2 UNIQUE None  Edit Drop module
module_4 UNIQUE None  Edit Drop module
module_9 UNIQUE None  Edit Drop module
published INDEX None  Edit Drop published
access
newsfeeds INDEX None  Edit Drop module
published
id INDEX None  Edit Drop id
ordering INDEX None  Edit Drop ordering
position INDEX None  Edit Drop position
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
published_2 INDEX None  Edit Drop published
module INDEX None  Edit Drop module
numnews INDEX None  Edit Drop numnews
access INDEX None  Edit Drop access
showtitle INDEX None  Edit Drop showtitle
iscore INDEX None  Edit Drop iscore
client_id INDEX None  Edit Drop client_id
access_2 INDEX None  Edit Drop access
published_3 INDEX None  Edit Drop published
checked_out_2 INDEX None  Edit Drop checked_out
client_id_2 INDEX None  Edit Drop client_id
showtitle_2 INDEX None  Edit Drop showtitle
module_6 INDEX None  Edit Drop module
numnews_2 INDEX None  Edit Drop numnews
id_4 INDEX None  Edit Drop id
iscore_2 INDEX None  Edit Drop iscore
ordering_2 INDEX None  Edit Drop ordering
position_3 INDEX None  Edit Drop position
checked_out_time_2 INDEX None  Edit Drop checked_out_time
access_3 INDEX None  Edit Drop access
checked_out_time_3 INDEX None  Edit Drop checked_out_time
position_5 INDEX None  Edit Drop position
checked_out_3 INDEX None  Edit Drop checked_out
published_4 INDEX None  Edit Drop published
numnews_3 INDEX None  Edit Drop numnews
id_6 INDEX None  Edit Drop id
client_id_3 INDEX None  Edit Drop client_id
iscore_3 INDEX None  Edit Drop iscore
showtitle_3 INDEX None  Edit Drop showtitle
ordering_3 INDEX None  Edit Drop ordering
module_8 INDEX None  Edit Drop module
title FULLTEXT None  Edit Drop title
content FULLTEXT None  Edit Drop content
position_2 FULLTEXT None  Edit Drop position
module_3 FULLTEXT None  Edit Drop module
params FULLTEXT None  Edit Drop params
control FULLTEXT None  Edit Drop control
content_2 FULLTEXT None  Edit Drop content
control_2 FULLTEXT None  Edit Drop control
module_5 FULLTEXT None  Edit Drop module
title_2 FULLTEXT None  Edit Drop title
position_4 FULLTEXT None  Edit Drop position
params_2 FULLTEXT None  Edit Drop params
control_3 FULLTEXT None  Edit Drop control
params_3 FULLTEXT None  Edit Drop params
title_3 FULLTEXT None  Edit Drop title
module_7 FULLTEXT None  Edit Drop module
position_6 FULLTEXT None  Edit Drop position
content_3 FULLTEXT None  Edit Drop content
Create an index on  columns  
 
Space usage: 
Type Usage
Data 824 Bytes
Index 4,096 Bytes
Total 4,920 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 15
Row length ø 54
Row size  ø 328 Bytes
Next Autoindex 16
Creation Oct 28, 2017 at 10:41 PM
Last update Jun 08, 2018 at 06:27 PM
Last check Jun 08, 2018 at 06:27 PM

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: