MySQL 메시지:
#1170 - BLOB/TEXT column 'category' used in key specification without a key length
위와같은에러로 복구가 안됩니다
어느부분을 수정해야하는지 좀 알려주세요 ㅡㅡ;
그런데 이상한건 예전서버에선 문제없었거든요
이 쿼리가 mysql버전에따라서 에러가 생길수도 안생길수도있는건가요?
참고로 초짜입니다 ㅡㅡ';
그리고 수정할부분을
editplus로 수정을하고나서 서버에 올리고 mysql명령어로 복구시켜도 문제없는지도 좀 알려주세요 ;;
SQL 질의:
CREATE TABLE expand_market_data(
uid int( 11 ) NOT NULL AUTO_INCREMENT ,
gtype int( 1 ) NOT NULL ,
gid int( 10 ) NOT NULL ,
id varchar( 12 ) NOT NULL ,
category text NOT NULL ,
display int( 1 ) NOT NULL ,
name text NOT NULL ,
op_1_name varchar( 100 ) NOT NULL ,
op_1_value varchar( 200 ) NOT NULL ,
op_2_name varchar( 100 ) NOT NULL ,
op_2_value varchar( 200 ) NOT NULL ,
op_3_name varchar( 100 ) NOT NULL ,
op_3_value varchar( 200 ) NOT NULL ,
op_4_name varchar( 100 ) NOT NULL ,
op_4_value varchar( 200 ) NOT NULL ,
op_5_name varchar( 100 ) NOT NULL ,
op_5_value varchar( 200 ) NOT NULL ,
op_6_name varchar( 100 ) NOT NULL ,
op_6_value varchar( 200 ) NOT NULL ,
op_7_name varchar( 100 ) NOT NULL ,
op_7_value varchar( 200 ) NOT NULL ,
kind varchar( 100 ) NOT NULL ,
use_format varchar( 100 ) NOT NULL ,
use_tool varchar( 100 ) NOT NULL ,
use_size int( 10 ) NOT NULL ,
use_fixel varchar( 20 ) NOT NULL ,
price1 int( 8 ) NOT NULL ,
price2 int( 8 ) NOT NULL ,
point int( 7 ) NOT NULL ,
ha_term varchar( 200 ) NOT NULL ,
ha_rebuy int( 8 ) NOT NULL ,
downfile varchar( 100 ) NOT NULL ,
demo_user varchar( 200 ) NOT NULL ,
demo_admin varchar( 200 ) NOT NULL ,
photo text NOT NULL ,
upfolder varchar( 30 ) NOT NULL ,
updir varchar( 100 ) NOT NULL ,
upfiles text NOT NULL ,
html varchar( 4 ) NOT NULL ,
content1 mediumtext NOT NULL ,
review text NOT NULL ,
headcode text NOT NULL ,
tailcode text NOT NULL ,
searchstr varchar( 200 ) NOT NULL ,
hit int( 7 ) NOT NULL ,
wish int( 7 ) NOT NULL ,
cart int( 7 ) NOT NULL ,
panmae int( 7 ) NOT NULL ,
score1 int( 7 ) NOT NULL ,
score2 int( 7 ) NOT NULL ,
date1 varchar( 8 ) NOT NULL ,
date2 varchar( 8 ) NOT NULL ,
aply_site text NOT NULL ,
PRIMARY KEY ( uid ) ,
KEY gtype( gtype ) ,
KEY gid( gid ) ,
KEY id( id ) ,
KEY category( category ) ,
KEY display( display ) ,
KEY kind( kind ) ,
KEY use_format( use_format ) ,
KEY use_tool( use_tool ) ,
KEY use_size( use_size ) ,
KEY price1( price1 ) ,
KEY price2( price2 ) ,
KEY point( point ) ,
KEY searchstr( searchstr ) ,
KEY hit( hit ) ,
KEY wish( wish ) ,
KEY cart( cart ) ,
KEY panmae( panmae ) ,
KEY score1( score1 ) ,
KEY score2( score2 ) ,
KEY date1( date1 ) ,
KEY date2( date2 ) ,
KEY aply_site( aply_site )
)