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

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
   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_id_4 UNIQUE Edit Drop group_id
description_5 UNIQUE Edit Drop description
group_name_6 UNIQUE Edit Drop group_name
description_8 UNIQUE Edit Drop description
group_id_6 UNIQUE Edit Drop group_id
group_name_9 UNIQUE Edit Drop group_name
group_id_8 UNIQUE Edit Drop group_id
upl_need_approval_5 UNIQUE Edit Drop upl_need_approval
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
can_create_events INDEX None  Edit Drop can_create_events
can_edit_events INDEX None  Edit Drop can_edit_events
can_submit_events INDEX None  Edit Drop can_submit_events
upl_need_approval INDEX None  Edit Drop upl_need_approval
locked INDEX None  Edit Drop locked
group_id_3 INDEX None  Edit Drop group_id
can_edit_events_2 INDEX None  Edit Drop can_edit_events
has_admin_access_2 INDEX None  Edit Drop has_admin_access
can_change_settings_2 INDEX None  Edit Drop can_change_settings
description_4 INDEX None  Edit Drop description
can_create_events_2 INDEX None  Edit Drop can_create_events
locked_2 INDEX None  Edit Drop locked
upl_need_approval_2 INDEX None  Edit Drop upl_need_approval
group_name_5 INDEX None  Edit Drop group_name
can_manage_cats_2 INDEX None  Edit Drop can_manage_cats
can_submit_events_2 INDEX None  Edit Drop can_submit_events
can_manage_accounts_2 INDEX None  Edit Drop can_manage_accounts
description_7 INDEX None  Edit Drop description
can_edit_events_3 INDEX None  Edit Drop can_edit_events
can_submit_events_3 INDEX None  Edit Drop can_submit_events
can_manage_cats_3 INDEX None  Edit Drop can_manage_cats
locked_3 INDEX None  Edit Drop locked
group_name_8 INDEX None  Edit Drop group_name
group_id_5 INDEX None  Edit Drop group_id
can_change_settings_3 INDEX None  Edit Drop can_change_settings
upl_need_approval_3 INDEX None  Edit Drop upl_need_approval
has_admin_access_3 INDEX None  Edit Drop has_admin_access
can_create_events_3 INDEX None  Edit Drop can_create_events
can_manage_accounts_3 INDEX None  Edit Drop can_manage_accounts
can_submit_events_4 INDEX None  Edit Drop can_submit_events
can_change_settings_4 INDEX None  Edit Drop can_change_settings
locked_4 INDEX None  Edit Drop locked
can_manage_cats_4 INDEX None  Edit Drop can_manage_cats
has_admin_access_4 INDEX None  Edit Drop has_admin_access
group_id_7 INDEX None  Edit Drop group_id
group_name_10 INDEX None  Edit Drop group_name
upl_need_approval_4 INDEX None  Edit Drop upl_need_approval
description_10 INDEX None  Edit Drop description
can_manage_accounts_4 INDEX None  Edit Drop can_manage_accounts
group_name_3 FULLTEXT None  Edit Drop group_name
description_3 FULLTEXT None  Edit Drop description
group_name_4 FULLTEXT None  Edit Drop group_name
description_6 FULLTEXT None  Edit Drop description
group_name_7 FULLTEXT None  Edit Drop group_name
description_9 FULLTEXT None  Edit Drop description
Create an index on  columns  
 
Space usage: 
Type Usage
Data 340 Bytes
Index 3,072 Bytes
Total 3,412 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 6
Row length ø 56
Row size  ø 569 Bytes
Next Autoindex 7
Creation Feb 23, 2018 at 07:08 PM
Last update Mar 31, 2018 at 03:17 AM
Last check Apr 05, 2018 at 06:21 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: