Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: extcal2_groupsextcal2_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
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_name_4 UNIQUE Edit Drop group_name
group_id_4 UNIQUE Edit Drop group_id
description_8 UNIQUE Edit Drop description
group_name_8 UNIQUE Edit Drop group_name
group_id_5 UNIQUE Edit Drop group_id
group_name_10 UNIQUE Edit Drop group_name
description_10 UNIQUE Edit Drop description
group_id_8 UNIQUE Edit Drop group_id
group_name_13 UNIQUE Edit Drop group_name
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
has_admin_access_2 INDEX None  Edit Drop has_admin_access
upl_need_approval_2 INDEX None  Edit Drop upl_need_approval
description_5 INDEX None  Edit Drop description
locked_2 INDEX None  Edit Drop locked
group_id_3 INDEX None  Edit Drop group_id
can_manage_accounts_2 INDEX None  Edit Drop can_manage_accounts
group_name_5 INDEX None  Edit Drop group_name
can_change_settings_2 INDEX None  Edit Drop can_change_settings
can_manage_cats_2 INDEX None  Edit Drop can_manage_cats
group_name_7 INDEX None  Edit Drop group_name
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
can_manage_accounts_3 INDEX None  Edit Drop can_manage_accounts
can_manage_cats_3 INDEX None  Edit Drop can_manage_cats
upl_need_approval_3 INDEX None  Edit Drop upl_need_approval
description_9 INDEX None  Edit Drop description
group_id_6 INDEX None  Edit Drop group_id
has_admin_access_4 INDEX None  Edit Drop has_admin_access
can_manage_accounts_4 INDEX None  Edit Drop can_manage_accounts
locked_4 INDEX None  Edit Drop locked
group_id_7 INDEX None  Edit Drop group_id
group_name_11 INDEX None  Edit Drop group_name
description_11 INDEX None  Edit Drop description
upl_need_approval_4 INDEX None  Edit Drop upl_need_approval
can_change_settings_4 INDEX None  Edit Drop can_change_settings
can_manage_cats_4 INDEX None  Edit Drop can_manage_cats
can_manage_accounts_5 INDEX None  Edit Drop can_manage_accounts
locked_5 INDEX None  Edit Drop locked
has_admin_access_5 INDEX None  Edit Drop has_admin_access
description_13 INDEX None  Edit Drop description
can_change_settings_5 INDEX None  Edit Drop can_change_settings
group_id_9 INDEX None  Edit Drop group_id
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
description_7 FULLTEXT None  Edit Drop description
group_name_9 FULLTEXT None  Edit Drop group_name
description_12 FULLTEXT None  Edit Drop description
group_name_12 FULLTEXT None  Edit Drop group_name
Create an index on  columns  
 
Space usage: 
Type Usage
Data 276 Bytes
Index 3,072 Bytes
Total 3,348 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 5
Row length ø 55
Row size  ø 670 Bytes
Next Autoindex 6
Creation Feb 25, 2018 at 08:57 AM
Last update Feb 25, 2018 at 08:57 AM
Last check Apr 03, 2018 at 08:22 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: