upgrade 1.4.6 ALTER table error

[oka]

Hi all.

 

Privileges to mysql user from the prestashop wiki:

 

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP
 > ON `prestashop`.* TO 'new_user'@'localhost';
mysql> FLUSH PRIVILEGES;

 

Now if you update to 1.4.6 you will see 6 errors :

 

ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`;
ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`);
ALTER TABLE `ps_store` CHANGE `latitude` `latitude` DECIMAL(11, 8) NULL DEFAULT NULL;
ALTER TABLE `ps_store` CHANGE `longitude` `longitude` DECIMAL(11, 8) NULL DEFAULT NULL;
ALTER TABLE `ps_address_format` ADD PRIMARY KEY (`id_country`);
ALTER TABLE `ps_address_format` DROP INDEX `country`;

 

So the wiki is wrong about the privileges and we should give ALTER privileges to the mysql user ?

 

regards.