mysql-full-install-version-1.7.0.RELEASE.sql need to be updated

paxagape
Messages : 7
Inscription : mer. oct. 30, 2013 4:31 pm

mysql-full-install-version-1.7.0.RELEASE.sql need to be updated

Message par paxagape »

The mysql-full-install-version-1.7.0.RELEASE.sql need to updated to avoid the following error
when converting from H2 DB to MySQL DB.

Error Code: 1074. Column length too big for column 'VALUE' (max = 21845); use BLOB or TEXT instead

Original:
[code]CREATE TABLE `CORE_CONFIG` (`STR_KEY` VARCHAR(255) NOT NULL, `VALUE` VARCHAR(32000) NULL, CONSTRAINT `PK_CORE_CONFIG` PRIMARY KEY (`STR_KEY`));[/code]

Updated:
[code]CREATE TABLE `CORE_CONFIG` (`STR_KEY` VARCHAR(255) NOT NULL, `VALUE` TEXT NULL, CONSTRAINT `PK_CORE_CONFIG` PRIMARY KEY (`STR_KEY`));[/code]
Verrouillé

Revenir à « Installation & Base de données / Installation & Database »