Properties

Engine: MyISAM 
Row format:
Rows: Dynamic 
Avg row length: 34 
Data length: 29 
Max data length: 1000 
Index length: 4294967295 
Data free: 3072 
Auto increment:
Create time:  
Update time: 2006/19/07/2006 
Check time: 2006/19/07/2006 
Create_options:  
Comment: utf8_general_ci 

Columns

Name Data Type NULL Default
    help_category_id  smallint(5) unsigned    PRI 
    name  varchar(64)    UNI 
    parent_category_id  smallint(5) unsigned     
    url  varchar(128)     
Total: 4 column(s)

Indexes

Name Primary Unique
  PRIMARY     
  name     
Total: 2 indexes(s)

SQL

CREATE TABLE `help_category` (
  `help_category_id` smallint(5) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `parent_category_id` smallint(5) unsigned default NULL,
  `url` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`help_category_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help categories'

See Also

List of tables