CREATE TABLE categories (
categories_id int(5) NOT NULL auto_increment,
categories_image varchar(64) default NULL,
parent_id int(5) NOT NULL default '0',
sort_order int(3) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
PRIMARY KEY  (categories_id),
KEY idx_categories_parent_id (parent_id)
) TYPE=MyISAM