CREATE TABLE 'phpwcms_sysvalue' Missing TYPE=MyISAM

Use GitHub to post bug reports and error descriptions for phpwcms. Describe your problem detailed!
Locked
michael69
Posts: 4
Joined: Sat 5. Jun 2004, 07:18
Location: California, USA
Contact:

CREATE TABLE 'phpwcms_sysvalue' Missing TYPE=MyISAM

Post by michael69 »

In setup/phpwcms_init.sql (version 1.2.3-DEV)

The Create statement is:
CREATE TABLE `phpwcms_sysvalue` (
`sysvalue_key` VARCHAR( 255 ) NOT NULL ,
`sysvalue_tstamp` TIMESTAMP NOT NULL ,
`sysvalue_value` MEDIUMBLOB NOT NULL ,
PRIMARY KEY ( `sysvalue_key` ) ,
FULLTEXT ( `sysvalue_key` )
);

but it should be:
CREATE TABLE `phpwcms_sysvalue` (
`sysvalue_key` VARCHAR( 255 ) NOT NULL ,
`sysvalue_tstamp` TIMESTAMP NOT NULL ,
`sysvalue_value` MEDIUMBLOB NOT NULL ,
PRIMARY KEY ( `sysvalue_key` ) ,
FULLTEXT ( `sysvalue_key` )
) TYPE=MyISAM AUTO_INCREMENT=1;
Locked