Does anyone know what the TYPE=MyISAM clause does? I am working with an open source project that has some tables laid out like:
CREATE TABLE categories (
cat_id int(4) NOT NULL auto_increment,
parent_id int(4) default NULL,
cat_name tinytext,
deleted int(1) default NULL,
sub_counter int(11) default NULL,
counter int(11) default NULL,
cat_colour tinytext NOT NULL,
cat_image tinytext NOT NULL,
PRIMARY KEY (cat_id)
) TYPE=MyISAM;
the type=myisam is cause some people fatal errors in others, but i dont seem to recall haveing any trouble on my own system. otoh, when i do a dump none of the type clauses show up... any help appreciated.
CREATE TABLE categories (
cat_id int(4) NOT NULL auto_increment,
parent_id int(4) default NULL,
cat_name tinytext,
deleted int(1) default NULL,
sub_counter int(11) default NULL,
counter int(11) default NULL,
cat_colour tinytext NOT NULL,
cat_image tinytext NOT NULL,
PRIMARY KEY (cat_id)
) TYPE=MyISAM;
the type=myisam is cause some people fatal errors in others, but i dont seem to recall haveing any trouble on my own system. otoh, when i do a dump none of the type clauses show up... any help appreciated.