I have configured MySQL Cluster. When I, importing MySQL Database Schema then it will give me an error.
ERROR 1214 (HY000) at line 2: The used table type doesn’t support FULLTEXT indexes
I have read about it on and understand. Now i want to use SphinX with MySQL Cluster i am confused what should i need to modify in order to make it work with MySQL Cluster.
DROP TABLE IF EXISTS cchistory
;
CREATE TABLE cchistory
(
LinkPointID
varchar(30) default NULL,
UID
varchar(20) NOT NULL default ‘’,
UserID
varchar(20) default NULL,
CName
varchar(40) NOT NULL default ‘’,
CAddress
tinytext NOT NULL,
CTel
varchar(30) default NULL,
CEmail
varchar(80) default NULL,
CCNumber
varchar(16) NOT NULL default ‘’,
CCType
varchar(4) NOT NULL default ‘’,
CCVNumber
char(2) default NULL,
CCExpiryMonth
char(2) NOT NULL default ‘’,
CCExpiryYear
varchar(4) NOT NULL default ‘’,
StatusCode
varchar(60) default NULL,
StatusMessage
varchar(60) default NULL,
StatusApproval
varchar(60) default NULL,
AVSCode
text,
TrackingID
varchar(40) default NULL,
Amount
decimal(6,2) default NULL,
Type
varchar(4) NOT NULL default ‘’,
Comments
text,
IsCharged
tinyint(1) NOT NULL default ‘0’,
DateTime
datetime default NULL,
FULLTEXT KEY StatusApproval
(StatusApproval
)
) ENGINE=NDBCLUSTER DEFAULT CHARSET=latin1;
Replace this line with what ?
FULLTEXT KEY StatusApproval
(StatusApproval
)
Best Regards.