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

Table holding events and their attributes

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(120) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   smallint(2)     No    Change Drop Primary Index Unique Fulltext
   smallint(4)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   datetime     Yes  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   varchar(16) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   tinyint(4)     Yes    Change Drop Primary Index Unique Fulltext
   tinyint(1)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   date     Yes  0000-00-00    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 28  Edit Drop id
id UNIQUE 28  Edit Drop id
id_3 UNIQUE 28  Edit Drop id
id_5 UNIQUE 28  Edit Drop id
email_6 UNIQUE 28  Edit Drop email
start_date INDEX None  Edit Drop start_date
id_2 INDEX None  Edit Drop id
title INDEX None  Edit Drop title
url INDEX None  Edit Drop url
email INDEX None  Edit Drop email
picture INDEX None  Edit Drop picture
cat INDEX None  Edit Drop cat
day INDEX None  Edit Drop day
month INDEX None  Edit Drop month
year INDEX None  Edit Drop year
approved INDEX None  Edit Drop approved
start_date_2 INDEX None  Edit Drop start_date
end_date INDEX None  Edit Drop end_date
recur_type INDEX None  Edit Drop recur_type
recur_val INDEX None  Edit Drop recur_val
recur_end_type INDEX None  Edit Drop recur_end_type
recur_count INDEX None  Edit Drop recur_count
recur_until INDEX None  Edit Drop recur_until
day_2 INDEX None  Edit Drop day
url_3 INDEX None  Edit Drop url
email_3 INDEX None  Edit Drop email
picture_3 INDEX None  Edit Drop picture
recur_until_2 INDEX None  Edit Drop recur_until
month_2 INDEX None  Edit Drop month
recur_val_2 INDEX None  Edit Drop recur_val
cat_2 INDEX None  Edit Drop cat
year_2 INDEX None  Edit Drop year
recur_type_3 INDEX None  Edit Drop recur_type
title_3 INDEX None  Edit Drop title
id_4 INDEX None  Edit Drop id
start_date_3 INDEX None  Edit Drop start_date
end_date_2 INDEX None  Edit Drop end_date
approved_2 INDEX None  Edit Drop approved
recur_count_2 INDEX None  Edit Drop recur_count
recur_end_type_2 INDEX None  Edit Drop recur_end_type
recur_end_type_3 INDEX None  Edit Drop recur_end_type
day_3 INDEX None  Edit Drop day
picture_5 INDEX None  Edit Drop picture
end_date_3 INDEX None  Edit Drop end_date
recur_count_3 INDEX None  Edit Drop recur_count
recur_type_5 INDEX None  Edit Drop recur_type
start_date_4 INDEX None  Edit Drop start_date
title_2 FULLTEXT None  Edit Drop title
description FULLTEXT None  Edit Drop description
contact FULLTEXT None  Edit Drop contact
url_2 FULLTEXT None  Edit Drop url
email_2 FULLTEXT None  Edit Drop email
picture_2 FULLTEXT None  Edit Drop picture
recur_type_2 FULLTEXT None  Edit Drop recur_type
recur_type_4 FULLTEXT None  Edit Drop recur_type
url_4 FULLTEXT None  Edit Drop url
title_4 FULLTEXT None  Edit Drop title
email_4 FULLTEXT None  Edit Drop email
description_2 FULLTEXT None  Edit Drop description
picture_4 FULLTEXT None  Edit Drop picture
contact_2 FULLTEXT None  Edit Drop contact
email_5 FULLTEXT None  Edit Drop email
url_5 FULLTEXT None  Edit Drop url
picture_6 FULLTEXT None  Edit Drop picture
Create an index on  columns  
 
Space usage: 
Type Usage
Data 3,400 Bytes
Index 4,096 Bytes
Total 7,496 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 28
Row length ø 121
Row size  ø 268 Bytes
Next Autoindex 31
Creation Nov 04, 2017 at 05:40 PM
Last update Jun 08, 2018 at 02:44 AM
Last check Jun 11, 2018 at 12:05 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: