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

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
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   char(1) 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 362  Edit Drop id
id_2 UNIQUE 362  Edit Drop id
id_4 UNIQUE 362  Edit Drop id
start_date INDEX None  Edit Drop start_date
user_id INDEX None  Edit Drop user_id
id 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
user_id_2 INDEX None  Edit Drop user_id
group_id INDEX None  Edit Drop group_id
showevent INDEX None  Edit Drop showevent
email_3 INDEX None  Edit Drop email
user_id_3 INDEX None  Edit Drop user_id
recur_val_2 INDEX None  Edit Drop recur_val
id_3 INDEX None  Edit Drop id
group_id_2 INDEX None  Edit Drop group_id
showevent_2 INDEX None  Edit Drop showevent
url_4 INDEX None  Edit Drop url
recur_type_3 INDEX None  Edit Drop recur_type
end_date_2 INDEX None  Edit Drop end_date
picture_3 INDEX None  Edit Drop picture
month_2 INDEX None  Edit Drop month
cat_2 INDEX None  Edit Drop cat
recur_end_type_2 INDEX None  Edit Drop recur_end_type
approved_2 INDEX None  Edit Drop approved
title_3 INDEX None  Edit Drop title
recur_until_2 INDEX None  Edit Drop recur_until
start_date_3 INDEX None  Edit Drop start_date
recur_count_2 INDEX None  Edit Drop recur_count
year_2 INDEX None  Edit Drop year
day_2 INDEX None  Edit Drop day
email_5 INDEX None  Edit Drop email
year_3 INDEX None  Edit Drop year
recur_val_3 INDEX None  Edit Drop recur_val
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
contact_2 FULLTEXT None  Edit Drop contact
url_3 FULLTEXT None  Edit Drop url
picture_4 FULLTEXT None  Edit Drop picture
title_4 FULLTEXT None  Edit Drop title
recur_type_4 FULLTEXT None  Edit Drop recur_type
email_4 FULLTEXT None  Edit Drop email
description_2 FULLTEXT None  Edit Drop description
email_6 FULLTEXT None  Edit Drop email
url_5 FULLTEXT None  Edit Drop url
Create an index on  columns  
 
Space usage: 
Type Usage
Data 860,744 Bytes
Index 4,096 Bytes
Total 864,840 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 362
Row length ø 2,377
Row size  ø 2,389 Bytes
Next Autoindex 1,223
Creation Dec 11, 2017 at 08:24 AM
Last update Mar 19, 2018 at 02:10 AM
Last check Apr 04, 2018 at 06:34 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: