CREATE TABLE cpg_pictures( 
pid int( 11 ) NOT NULL AUTO_INCREMENT , 
aid int( 11 ) DEFAULT '0' NOT NULL , 
filepath varchar( 255 ) NOT NULL , 
filename varchar( 255 ) NOT NULL , 
filesize int( 11 ) DEFAULT '0' NOT NULL , 
total_filesize int( 11 ) DEFAULT '0' NOT NULL , 
pwidth smallint( 6 ) DEFAULT '0' NOT NULL , 
pheight smallint( 6 ) DEFAULT '0' NOT NULL , 
hits int( 10 ) DEFAULT '0' NOT NULL , 
mtime timestamp DEFAULT 'CURRENT_TIMESTAMP', 
ctime int( 11 ) DEFAULT '0' NOT NULL , 
owner_id int( 11 ) DEFAULT '0' NOT NULL , 
owner_name varchar( 40 ) NOT NULL , 
pic_rating int( 11 ) DEFAULT '0' NOT NULL , 
votes int( 11 ) DEFAULT '0' NOT NULL , 
title varchar( 255 ) NOT NULL , 
caption text NOT NULL , 
keywords varchar( 255 ) NOT NULL , 
approved enum( 'YES', 'NO' ) DEFAULT 'NO' NOT NULL , 
user1 varchar( 255 ) NOT NULL , 
user2 varchar( 255 ) NOT NULL , 
user3 varchar( 255 ) NOT NULL , 
user4 varchar( 255 ) NOT NULL , 
url_prefix tinyint( 4 ) DEFAULT '0' NOT NULL , 
randpos int( 11 ) DEFAULT '0' NOT NULL , 
pic_raw_ip tinytext, 
pic_hdr_ip tinytext, 
PRIMARY KEY ( pid ) , 
KEY pic_hits( hits ) , 
KEY pic_rate( pic_rating ) , 
KEY aid_approved( aid, approved ) , 
KEY randpos( randpos ) , 
KEY pic_aid( aid ) , 
KEY search( title, keywords, filename ) 
)