Properties

Engine:	MyISAM
Row format:	9
Rows:	Dynamic
Avg row length:	34
Data length:	29
Max data length:	1000
Index length:	4294967295
Data free:	3072
Auto increment:	0
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