ZF3AwWir

1DROP PROCEDURE IF EXISTS modif_spip_auteurs_messages|
2CREATE PROCEDURE modif_spip_auteurs_messages()
3BEGIN
4        IF (SELECT COUNT(*) FROM `information_schema`.`COLUMNS` WHERE `TABLE_NAME`='spip_auteurs_messages' AND `COLUMN_NAME`='id_message') THEN
5                ALTER TABLE `spip_auteurs_messages` CHANGE `id_message` `id_objet` bigint(21) NOT NULL default '0';
6        END IF;
7        IF (SELECT COUNT(*) FROM `information_schema`.`COLUMNS` WHERE `TABLE_NAME`='spip_auteurs_messages' AND `COLUMN_NAME`='objet') = 0) THEN
8                ALTER TABLE `spip_auteurs_messages` ADD `objet` varchar(25) NOT NULL default '';
9        END IF;
10        IF (SELECT COUNT(*) FROM `information_schema`.`COLUMNS` WHERE `TABLE_NAME`='spip_auteurs_messages' AND `COLUMN_NAME`='vu') THEN
11                ALTER TABLE `spip_auteurs_messages` MODIFY `vu` varchar(6) NOT NULL default 'non';
12        END IF;
13        IF (SELECT COUNT(*) FROM `information_schema`.`KEY_COLUMN_USAGE` WHERE `TABLE_SCHEMA`='spip' AND `CONSTRAINT_NAME`='PRIMARY' AND `TABLE_NAME`='spip_auteurs_messages') THEN
14                ALTER TABLE `spip_auteurs_messages` DROP PRIMARY KEY;
15                ALTER TABLE `spip_auteurs_messages` ADD PRIMARY KEY  (`id_auteur`,`id_objet`,`objet`);
16        END IF;
17END