كود:
CREATE TABLE 4images_categories(
cat_id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
cat_name varchar( 255 ) NOT NULL default '',
cat_description text NOT NULL ,
cat_parent_id int( 10 ) unsigned NOT NULL default '0',
cat_hits int( 10 ) unsigned NOT NULL default '0',
cat_order int( 10 ) unsigned NOT NULL default '0',
auth_viewcat tinyint( 2 ) NOT NULL default '0',
auth_viewimage tinyint( 2 ) NOT NULL default '0',
auth_download tinyint( 2 ) NOT NULL default '0',
auth_upload tinyint( 2 ) NOT NULL default '0',
auth_directupload tinyint( 2 ) NOT NULL default '0',
auth_vote tinyint( 2 ) NOT NULL default '0',
auth_sendpostcard tinyint( 2 ) NOT NULL default '0',
auth_readcomment tinyint( 2 ) NOT NULL default '0',
auth_postcomment tinyint( 2 ) NOT NULL default '0',
PRIMARY KEY ( cat_id ) ,
KEY cat_parent_id( cat_parent_id ) ,
KEY cat_order( cat_order )
)ENGINE = MYISAM;