Datuve :: Forums :: Arhīvs :: Kljuda SQL koda!

Datuve

Mana Datuve

Reģistrācija | Noteikumi | Paroles atjaunošana



Forums

Ieskaties


Raksti

Lietotāji online

Lietotāji online: 156

Reģistrētie lietotāji online: 0

Viesi online: 156

Datuve.lv video
Top.LV

Kljuda SQL koda!

Ievietoja: karlosons @ 2007.06.11 03:35  

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

Man rada!
#1214 - The used table type doesn't support FULLTEXT indexes

paldies jau ieprieksh