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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   tinyint(1)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(1)   UNSIGNED No    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
   int(11)     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
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) 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 Edit Drop id
id_2 UNIQUE Edit Drop id
name_2 UNIQUE Edit Drop name
alias_2 UNIQUE Edit Drop alias
default_con_2 UNIQUE Edit Drop default_con
published_2 UNIQUE Edit Drop published
checked_out_2 UNIQUE Edit Drop checked_out
checked_out_time_2 UNIQUE Edit Drop checked_out_time
ordering_2 UNIQUE Edit Drop ordering
user_id_2 UNIQUE Edit Drop user_id
catid_3 UNIQUE Edit Drop catid
access_2 UNIQUE Edit Drop access
mobile_2 UNIQUE Edit Drop mobile
webpage_2 UNIQUE Edit Drop webpage
con_position_2 UNIQUE None  Edit Drop con_position
suburb_2 UNIQUE None  Edit Drop suburb
state_2 UNIQUE None  Edit Drop state
country_2 UNIQUE None  Edit Drop country
postcode_2 UNIQUE None  Edit Drop postcode
telephone_2 UNIQUE None  Edit Drop telephone
fax_2 UNIQUE None  Edit Drop fax
image_2 UNIQUE None  Edit Drop image
imagepos_2 UNIQUE None  Edit Drop imagepos
email_to_2 UNIQUE None  Edit Drop email_to
catid INDEX None  Edit Drop catid
id INDEX None  Edit Drop id
name INDEX None  Edit Drop name
alias INDEX None  Edit Drop alias
con_position INDEX None  Edit Drop con_position
suburb INDEX None  Edit Drop suburb
state INDEX None  Edit Drop state
country INDEX None  Edit Drop country
postcode INDEX None  Edit Drop postcode
telephone INDEX None  Edit Drop telephone
fax INDEX None  Edit Drop fax
image INDEX None  Edit Drop image
imagepos INDEX None  Edit Drop imagepos
email_to INDEX None  Edit Drop email_to
default_con INDEX None  Edit Drop default_con
published INDEX None  Edit Drop published
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
ordering INDEX None  Edit Drop ordering
user_id INDEX None  Edit Drop user_id
catid_2 INDEX None  Edit Drop catid
access INDEX None  Edit Drop access
mobile INDEX None  Edit Drop mobile
webpage INDEX None  Edit Drop webpage
name_3 FULLTEXT None  Edit Drop name
alias_3 FULLTEXT None  Edit Drop alias
con_position_3 FULLTEXT None  Edit Drop con_position
address FULLTEXT None  Edit Drop address
suburb_3 FULLTEXT None  Edit Drop suburb
state_3 FULLTEXT None  Edit Drop state
country_3 FULLTEXT None  Edit Drop country
postcode_3 FULLTEXT None  Edit Drop postcode
telephone_3 FULLTEXT None  Edit Drop telephone
fax_3 FULLTEXT None  Edit Drop fax
misc FULLTEXT None  Edit Drop misc
image_3 FULLTEXT None  Edit Drop image
imagepos_3 FULLTEXT None  Edit Drop imagepos
email_to_3 FULLTEXT None  Edit Drop email_to
params FULLTEXT None  Edit Drop params
mobile_3 FULLTEXT None  Edit Drop mobile
Create an index on  columns  
 
Space usage: 
Type Usage
Data 576 Bytes
Index 4,096 Bytes
Total 4,672 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 1
Row length ø 576
Row size  ø 4,672 Bytes
Next Autoindex 2
Creation Oct 08, 2017 at 03:54 PM
Last update Mar 14, 2018 at 05:19 AM
Last check Apr 05, 2018 at 12:24 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: