tableをつくれない
CREATE TABLE `db31_dev`.`db31_dev` (
`keyword_id` SERIAL NOT NULL ,
`bc_guid` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`bc_wbs` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`keyword_h1_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`keyword_wording_in_bc` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`keywords` VARCHAR( 511 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`last_modified` DATETIME NOT NULL ,
`changefreq` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pri` INT( 5 ) NOT NULL ,
`noLocalNavi` BOOLEAN NOT NULL ,
PRIMARY KEY ( `keyword_id` ) ,
UNIQUE (
`bc_guid` ,
`bc_wbs` ,
`keyword_h1_url` ,
`keywords` ,
`description`
)
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
とphpmyadminでうったら(正確にはテキストボックスに入力)
priの部分がエラーと言われて、
MySQLのメッセージ: ドキュメント
#1071 - Specified key was too long; max key length is 767 bytes
だそうです。
どうすればいいのでしょうか?
よろしくお願い申し上げます。