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

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
description_4 UNIQUE Edit Drop description
group_id_4 UNIQUE Edit Drop group_id
group_name_5 UNIQUE Edit Drop group_name
group_name_7 UNIQUE Edit Drop group_name
group_id_5 UNIQUE Edit Drop group_id
description_9 UNIQUE Edit Drop description
description_10 UNIQUE Edit Drop description
group_id_8 UNIQUE Edit Drop group_id
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
group_name_4 INDEX None  Edit Drop group_name
has_admin_access_2 INDEX None  Edit Drop has_admin_access
can_submit_events_2 INDEX None  Edit Drop can_submit_events
description_5 INDEX None  Edit Drop description
can_create_events_2 INDEX None  Edit Drop can_create_events
can_change_settings_2 INDEX None  Edit Drop can_change_settings
upl_need_approval_2 INDEX None  Edit Drop upl_need_approval
can_edit_events_2 INDEX None  Edit Drop can_edit_events
can_manage_accounts_2 INDEX None  Edit Drop can_manage_accounts
can_manage_cats_2 INDEX None  Edit Drop can_manage_cats
locked_2 INDEX None  Edit Drop locked
can_edit_events_3 INDEX None  Edit Drop can_edit_events
upl_need_approval_3 INDEX None  Edit Drop upl_need_approval
description_7 INDEX None  Edit Drop description
group_id_6 INDEX None  Edit Drop group_id
can_manage_accounts_3 INDEX None  Edit Drop can_manage_accounts
can_manage_cats_3 INDEX None  Edit Drop can_manage_cats
can_submit_events_3 INDEX None  Edit Drop can_submit_events
group_name_9 INDEX None  Edit Drop group_name
can_create_events_3 INDEX None  Edit Drop can_create_events
can_change_settings_3 INDEX None  Edit Drop can_change_settings
locked_3 INDEX None  Edit Drop locked
has_admin_access_3 INDEX None  Edit Drop has_admin_access
upl_need_approval_4 INDEX None  Edit Drop upl_need_approval
group_id_7 INDEX None  Edit Drop group_id
can_create_events_4 INDEX None  Edit Drop can_create_events
can_change_settings_4 INDEX None  Edit Drop can_change_settings
can_submit_events_4 INDEX None  Edit Drop can_submit_events
description_12 INDEX None  Edit Drop description
group_name_10 INDEX None  Edit Drop group_name
has_admin_access_4 INDEX None  Edit Drop has_admin_access
group_name_3 FULLTEXT None  Edit Drop group_name
description_3 FULLTEXT None  Edit Drop description
description_6 FULLTEXT None  Edit Drop description
group_name_6 FULLTEXT None  Edit Drop group_name
group_name_8 FULLTEXT None  Edit Drop group_name
description_8 FULLTEXT None  Edit Drop description
description_11 FULLTEXT None  Edit Drop description
group_name_11 FULLTEXT None  Edit Drop group_name
Create an index on  columns  
 
Space usage: 
Type Usage
Data 296 Bytes
Index 3,072 Bytes
Total 3,368 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 5
Row length ø 59
Row size  ø 674 Bytes
Next Autoindex 6
Creation Jan 17, 2018 at 05:04 PM
Last update Apr 07, 2018 at 05:24 PM
Last check Apr 07, 2018 at 05: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: