10.09.2006, 17:34
SQL-запрос:
# --------------------------------------------------------
#
# Table structure for table 'cpg_pictures'
#
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, caption, keywords, filename )
Ответ MySQL:
#1170 - BLOB/TEXT column 'caption' used in key specification without a key length
)
|