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

Table holding user groups

   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
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     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 group_id
group_id_2 UNIQUE Edit Drop group_id
group_name_2 UNIQUE Edit Drop group_name
description_2 UNIQUE Edit Drop description
group_name_4 UNIQUE Edit Drop group_name
group_id_3 UNIQUE Edit Drop group_id
description_5 UNIQUE Edit Drop description
description_7 UNIQUE Edit Drop description
group_id_5 UNIQUE Edit Drop group_id
group_name_9 UNIQUE Edit Drop group_name
group_id_7 UNIQUE Edit Drop group_id
group_name_10 UNIQUE Edit Drop group_name
description_10 UNIQUE Edit Drop description
can_manage_accounts_5 UNIQUE Edit Drop can_manage_accounts
group_id INDEX None  Edit Drop group_id
group_name INDEX None  Edit Drop group_name
description INDEX None  Edit Drop description
has_admin_access INDEX None  Edit Drop has_admin_access
can_manage_accounts INDEX None  Edit Drop can_manage_accounts
can_change_settings INDEX None  Edit Drop can_change_settings
can_manage_cats INDEX None  Edit Drop can_manage_cats
upl_need_approval INDEX None  Edit Drop upl_need_approval
locked INDEX None  Edit Drop locked
can_edit_events INDEX None  Edit Drop can_edit_events
can_create_events INDEX None  Edit Drop can_create_events
upl_need_approval_2 INDEX None  Edit Drop upl_need_approval
locked_2 INDEX None  Edit Drop locked
can_manage_accounts_2 INDEX None  Edit Drop can_manage_accounts
can_edit_events_2 INDEX None  Edit Drop can_edit_events
can_change_settings_2 INDEX None  Edit Drop can_change_settings
group_id_4 INDEX None  Edit Drop group_id
group_name_5 INDEX None  Edit Drop group_name
description_4 INDEX None  Edit Drop description
can_manage_cats_2 INDEX None  Edit Drop can_manage_cats
can_create_events_2 INDEX None  Edit Drop can_create_events
has_admin_access_2 INDEX None  Edit Drop has_admin_access
locked_3 INDEX None  Edit Drop locked
can_manage_cats_3 INDEX None  Edit Drop can_manage_cats
upl_need_approval_3 INDEX None  Edit Drop upl_need_approval
group_name_7 INDEX None  Edit Drop group_name
can_change_settings_3 INDEX None  Edit Drop can_change_settings
can_edit_events_3 INDEX None  Edit Drop can_edit_events
description_8 INDEX None  Edit Drop description
group_id_6 INDEX None  Edit Drop group_id
can_create_events_3 INDEX None  Edit Drop can_create_events
can_manage_accounts_3 INDEX None  Edit Drop can_manage_accounts
has_admin_access_3 INDEX None  Edit Drop has_admin_access
upl_need_approval_4 INDEX None  Edit Drop upl_need_approval
can_create_events_4 INDEX None  Edit Drop can_create_events
can_change_settings_4 INDEX None  Edit Drop can_change_settings
group_id_8 INDEX None  Edit Drop group_id
can_manage_cats_4 INDEX None  Edit Drop can_manage_cats
locked_4 INDEX None  Edit Drop locked
can_manage_accounts_4 INDEX None  Edit Drop can_manage_accounts
description_11 INDEX None  Edit Drop description
can_edit_events_4 INDEX None  Edit Drop can_edit_events
group_name_11 INDEX None  Edit Drop group_name
group_name_3 FULLTEXT None  Edit Drop group_name
description_3 FULLTEXT None  Edit Drop description
group_name_6 FULLTEXT None  Edit Drop group_name
description_6 FULLTEXT None  Edit Drop description
group_name_8 FULLTEXT None  Edit Drop group_name
description_9 FULLTEXT None  Edit Drop description
group_name_12 FULLTEXT None  Edit Drop group_name
Create an index on  columns  
 
Space usage: 
Type Usage
Data 288 Bytes
Index 3,072 Bytes
Total 3,360 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 5
Row length ø 57
Row size  ø 672 Bytes
Next Autoindex 6
Creation Jan 19, 2018 at 02:43 AM
Last update Apr 03, 2018 at 11:39 AM
Last check Apr 07, 2018 at 06:39 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: