CREATE TABLE art_article ( art_id int(10) unsigned NOT NULL auto_increment, art_name varchar(50) default NULL, art_author varchar(100) default NULL, art_article text, art_category int(10) unsigned NOT NULL default '0', art_approved int(10) unsigned NOT NULL default '0', art_posted int(10) unsigned NOT NULL default '0', art_views int(10) unsigned NOT NULL default '0', art_viewers text, art_unique int(10) unsigned NOT NULL default '0', art_rate tinyint(3) unsigned NOT NULL default '0', art_comment tinyint(3) unsigned NOT NULL default '0', art_expires int(10) unsigned NOT NULL default '0', art_order int(10) unsigned NOT NULL default '0', art_forum tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (art_id), KEY art_name (art_name), KEY art_category (art_category) ) TYPE=MyISAM COMMENT='art articles table'; CREATE TABLE art_category ( art_category_id int(10) NOT NULL auto_increment, art_category_name varchar(50) default NULL, art_category_description varchar(250) default NULL, art_category_updated int(10) unsigned NOT NULL default '0', art_category_readclass int(10) unsigned NOT NULL default '0', art_category_order int(10) unsigned NOT NULL default '0', PRIMARY KEY (art_category_id), KEY art_category (art_category_name) ) TYPE=MyISAM COMMENT='art categories table';