spip /
SPIP
@@ -16,7 +16,7 @@ discard block |
||
| 16 | 16 | * @package SPIP\Core\SQL\Upgrade |
| 17 | 17 | **/ |
| 18 | 18 | if (!defined('_ECRIRE_INC_VERSION')) { |
| 19 | - return; |
|
| 19 | + return; |
|
| 20 | 20 | } |
| 21 | 21 | |
| 22 | 22 | /** |
@@ -26,66 +26,66 @@ discard block |
||
| 26 | 26 | * @param float $version_cible Version de destination |
| 27 | 27 | **/ |
| 28 | 28 | function maj_legacy_v012_dist($version_installee, $version_cible) { |
| 29 | - // Correction de l'oubli des modifs creations depuis 1.04 |
|
| 30 | - if (upgrade_vers(1.204, $version_installee, $version_cible)) { |
|
| 31 | - sql_query("ALTER TABLE spip_articles ADD accepter_forum VARCHAR(3) NOT NULL"); |
|
| 32 | - sql_query("ALTER TABLE spip_forum ADD id_message bigint(21) NOT NULL"); |
|
| 33 | - sql_query("ALTER TABLE spip_forum ADD INDEX id_message (id_message)"); |
|
| 34 | - sql_query("ALTER TABLE spip_auteurs ADD en_ligne datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"); |
|
| 35 | - sql_query("ALTER TABLE spip_auteurs ADD imessage VARCHAR(3) not null"); |
|
| 36 | - sql_query("ALTER TABLE spip_auteurs ADD messagerie VARCHAR(3) not null"); |
|
| 37 | - maj_version(1.204); |
|
| 38 | - } |
|
| 29 | + // Correction de l'oubli des modifs creations depuis 1.04 |
|
| 30 | + if (upgrade_vers(1.204, $version_installee, $version_cible)) { |
|
| 31 | + sql_query("ALTER TABLE spip_articles ADD accepter_forum VARCHAR(3) NOT NULL"); |
|
| 32 | + sql_query("ALTER TABLE spip_forum ADD id_message bigint(21) NOT NULL"); |
|
| 33 | + sql_query("ALTER TABLE spip_forum ADD INDEX id_message (id_message)"); |
|
| 34 | + sql_query("ALTER TABLE spip_auteurs ADD en_ligne datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"); |
|
| 35 | + sql_query("ALTER TABLE spip_auteurs ADD imessage VARCHAR(3) not null"); |
|
| 36 | + sql_query("ALTER TABLE spip_auteurs ADD messagerie VARCHAR(3) not null"); |
|
| 37 | + maj_version(1.204); |
|
| 38 | + } |
|
| 39 | 39 | |
| 40 | - if (upgrade_vers(1.207, $version_installee, $version_cible)) { |
|
| 41 | - sql_query("ALTER TABLE spip_rubriques DROP INDEX id_rubrique"); |
|
| 42 | - sql_query("ALTER TABLE spip_rubriques ADD INDEX id_parent (id_parent)"); |
|
| 43 | - sql_query("ALTER TABLE spip_rubriques ADD statut VARCHAR(10) NOT NULL"); |
|
| 44 | - // Declencher le calcul des rubriques publiques |
|
| 45 | - include_spip('inc/rubriques'); |
|
| 46 | - calculer_rubriques(); |
|
| 47 | - maj_version(1.207); |
|
| 48 | - } |
|
| 40 | + if (upgrade_vers(1.207, $version_installee, $version_cible)) { |
|
| 41 | + sql_query("ALTER TABLE spip_rubriques DROP INDEX id_rubrique"); |
|
| 42 | + sql_query("ALTER TABLE spip_rubriques ADD INDEX id_parent (id_parent)"); |
|
| 43 | + sql_query("ALTER TABLE spip_rubriques ADD statut VARCHAR(10) NOT NULL"); |
|
| 44 | + // Declencher le calcul des rubriques publiques |
|
| 45 | + include_spip('inc/rubriques'); |
|
| 46 | + calculer_rubriques(); |
|
| 47 | + maj_version(1.207); |
|
| 48 | + } |
|
| 49 | 49 | |
| 50 | - if (upgrade_vers(1.208, $version_installee, $version_cible)) { |
|
| 51 | - sql_query("ALTER TABLE spip_auteurs_messages CHANGE forum vu CHAR(3) NOT NULL"); |
|
| 52 | - sql_query("UPDATE spip_auteurs_messages SET vu='oui'"); |
|
| 53 | - sql_query("UPDATE spip_auteurs_messages SET vu='non' WHERE statut='a'"); |
|
| 50 | + if (upgrade_vers(1.208, $version_installee, $version_cible)) { |
|
| 51 | + sql_query("ALTER TABLE spip_auteurs_messages CHANGE forum vu CHAR(3) NOT NULL"); |
|
| 52 | + sql_query("UPDATE spip_auteurs_messages SET vu='oui'"); |
|
| 53 | + sql_query("UPDATE spip_auteurs_messages SET vu='non' WHERE statut='a'"); |
|
| 54 | 54 | |
| 55 | - sql_query("ALTER TABLE spip_messages ADD id_auteur bigint(21) NOT NULL"); |
|
| 56 | - sql_query("ALTER TABLE spip_messages ADD INDEX id_auteur (id_auteur)"); |
|
| 57 | - $result = sql_query("SELECT id_auteur, id_message FROM spip_auteurs_messages WHERE statut='de'"); |
|
| 58 | - while ($row = sql_fetch($result)) { |
|
| 59 | - $id_auteur = $row['id_auteur']; |
|
| 60 | - $id_message = $row['id_message']; |
|
| 61 | - sql_query("UPDATE spip_messages SET id_auteur=$id_auteur WHERE id_message=$id_message"); |
|
| 62 | - } |
|
| 55 | + sql_query("ALTER TABLE spip_messages ADD id_auteur bigint(21) NOT NULL"); |
|
| 56 | + sql_query("ALTER TABLE spip_messages ADD INDEX id_auteur (id_auteur)"); |
|
| 57 | + $result = sql_query("SELECT id_auteur, id_message FROM spip_auteurs_messages WHERE statut='de'"); |
|
| 58 | + while ($row = sql_fetch($result)) { |
|
| 59 | + $id_auteur = $row['id_auteur']; |
|
| 60 | + $id_message = $row['id_message']; |
|
| 61 | + sql_query("UPDATE spip_messages SET id_auteur=$id_auteur WHERE id_message=$id_message"); |
|
| 62 | + } |
|
| 63 | 63 | |
| 64 | - sql_query("ALTER TABLE spip_auteurs_messages DROP statut"); |
|
| 65 | - maj_version(1.208); |
|
| 66 | - } |
|
| 64 | + sql_query("ALTER TABLE spip_auteurs_messages DROP statut"); |
|
| 65 | + maj_version(1.208); |
|
| 66 | + } |
|
| 67 | 67 | |
| 68 | - if (upgrade_vers(1.209, $version_installee, $version_cible)) { |
|
| 69 | - sql_query("ALTER TABLE spip_syndic ADD maj TIMESTAMP"); |
|
| 70 | - sql_query("ALTER TABLE spip_syndic_articles ADD maj TIMESTAMP"); |
|
| 71 | - sql_query("ALTER TABLE spip_messages ADD maj TIMESTAMP"); |
|
| 72 | - maj_version(1.209); |
|
| 73 | - } |
|
| 68 | + if (upgrade_vers(1.209, $version_installee, $version_cible)) { |
|
| 69 | + sql_query("ALTER TABLE spip_syndic ADD maj TIMESTAMP"); |
|
| 70 | + sql_query("ALTER TABLE spip_syndic_articles ADD maj TIMESTAMP"); |
|
| 71 | + sql_query("ALTER TABLE spip_messages ADD maj TIMESTAMP"); |
|
| 72 | + maj_version(1.209); |
|
| 73 | + } |
|
| 74 | 74 | |
| 75 | - if (upgrade_vers(1.210, $version_installee, $version_cible)) { |
|
| 76 | - sql_query("ALTER TABLE spip_messages DROP page"); |
|
| 75 | + if (upgrade_vers(1.210, $version_installee, $version_cible)) { |
|
| 76 | + sql_query("ALTER TABLE spip_messages DROP page"); |
|
| 77 | 77 | |
| 78 | - stripslashes_base('spip_articles', array('surtitre', 'titre', 'soustitre', 'descriptif', 'chapo', 'texte', 'ps')); |
|
| 79 | - stripslashes_base('spip_auteurs', array('nom', 'bio', 'nom_site')); |
|
| 80 | - stripslashes_base('spip_breves', array('titre', 'texte', 'lien_titre')); |
|
| 81 | - stripslashes_base('spip_forum', array('titre', 'texte', 'auteur', 'nom_site')); |
|
| 82 | - stripslashes_base('spip_messages', array('titre', 'texte')); |
|
| 83 | - stripslashes_base('spip_mots', array('type', 'titre', 'descriptif', 'texte')); |
|
| 84 | - stripslashes_base('spip_petitions', array('texte')); |
|
| 85 | - stripslashes_base('spip_rubriques', array('titre', 'descriptif', 'texte')); |
|
| 86 | - stripslashes_base('spip_signatures', array('nom_email', 'nom_site', 'message')); |
|
| 87 | - stripslashes_base('spip_syndic', array('nom_site', 'descriptif')); |
|
| 88 | - stripslashes_base('spip_syndic_articles', array('titre', 'lesauteurs')); |
|
| 89 | - maj_version(1.210); |
|
| 90 | - } |
|
| 78 | + stripslashes_base('spip_articles', array('surtitre', 'titre', 'soustitre', 'descriptif', 'chapo', 'texte', 'ps')); |
|
| 79 | + stripslashes_base('spip_auteurs', array('nom', 'bio', 'nom_site')); |
|
| 80 | + stripslashes_base('spip_breves', array('titre', 'texte', 'lien_titre')); |
|
| 81 | + stripslashes_base('spip_forum', array('titre', 'texte', 'auteur', 'nom_site')); |
|
| 82 | + stripslashes_base('spip_messages', array('titre', 'texte')); |
|
| 83 | + stripslashes_base('spip_mots', array('type', 'titre', 'descriptif', 'texte')); |
|
| 84 | + stripslashes_base('spip_petitions', array('texte')); |
|
| 85 | + stripslashes_base('spip_rubriques', array('titre', 'descriptif', 'texte')); |
|
| 86 | + stripslashes_base('spip_signatures', array('nom_email', 'nom_site', 'message')); |
|
| 87 | + stripslashes_base('spip_syndic', array('nom_site', 'descriptif')); |
|
| 88 | + stripslashes_base('spip_syndic_articles', array('titre', 'lesauteurs')); |
|
| 89 | + maj_version(1.210); |
|
| 90 | + } |
|
| 91 | 91 | } |
@@ -16,7 +16,7 @@ discard block |
||
| 16 | 16 | * @package SPIP\Core\SQL\Upgrade |
| 17 | 17 | **/ |
| 18 | 18 | if (!defined('_ECRIRE_INC_VERSION')) { |
| 19 | - return; |
|
| 19 | + return; |
|
| 20 | 20 | } |
| 21 | 21 | |
| 22 | 22 | /** |
@@ -26,177 +26,177 @@ discard block |
||
| 26 | 26 | * @param float $version_cible Version de destination |
| 27 | 27 | **/ |
| 28 | 28 | function maj_legacy_v017_dist($version_installee, $version_cible) { |
| 29 | - if (upgrade_vers(1.702, $version_installee, $version_cible)) { |
|
| 30 | - sql_query("ALTER TABLE spip_articles ADD extra longblob NULL"); |
|
| 31 | - sql_query("ALTER TABLE spip_auteurs ADD extra longblob NULL"); |
|
| 32 | - sql_query("ALTER TABLE spip_breves ADD extra longblob NULL"); |
|
| 33 | - sql_query("ALTER TABLE spip_rubriques ADD extra longblob NULL"); |
|
| 34 | - sql_query("ALTER TABLE spip_mots ADD extra longblob NULL"); |
|
| 35 | - |
|
| 36 | - // recuperer les eventuels 'supplement' installes en 1.701 |
|
| 37 | - if ($version_installee == 1.701) { |
|
| 38 | - sql_query("UPDATE spip_articles SET extra = supplement"); |
|
| 39 | - sql_query("ALTER TABLE spip_articles DROP supplement"); |
|
| 40 | - sql_query("UPDATE spip_auteurs SET extra = supplement"); |
|
| 41 | - sql_query("ALTER TABLE spip_auteurs DROP supplement"); |
|
| 42 | - sql_query("UPDATE spip_breves SET extra = supplement"); |
|
| 43 | - sql_query("ALTER TABLE spip_breves DROP supplement"); |
|
| 44 | - sql_query("UPDATE spip_rubriques SET extra = supplement"); |
|
| 45 | - sql_query("ALTER TABLE spip_rubriques DROP supplement"); |
|
| 46 | - sql_query("UPDATE spip_mots SET extra = supplement"); |
|
| 47 | - sql_query("ALTER TABLE spip_mots DROP supplement"); |
|
| 48 | - } |
|
| 49 | - |
|
| 50 | - $u = sql_query("SELECT extra FROM spip_articles"); |
|
| 51 | - $u &= sql_query("SELECT extra FROM spip_auteurs"); |
|
| 52 | - $u &= sql_query("SELECT extra FROM spip_breves"); |
|
| 53 | - $u &= sql_query("SELECT extra FROM spip_rubriques"); |
|
| 54 | - $u &= sql_query("SELECT extra FROM spip_mots"); |
|
| 55 | - maj_version(1.702, $u); |
|
| 56 | - } |
|
| 57 | - |
|
| 58 | - if (upgrade_vers(1.703, $version_installee, $version_cible)) { |
|
| 59 | - sql_query("ALTER TABLE spip_articles ADD lang VARCHAR(10) DEFAULT '' NOT NULL"); |
|
| 60 | - sql_query("ALTER TABLE spip_rubriques ADD lang VARCHAR(10) DEFAULT '' NOT NULL"); |
|
| 61 | - maj_version(1.703); |
|
| 62 | - } |
|
| 63 | - |
|
| 64 | - if (upgrade_vers(1.704, $version_installee, $version_cible)) { |
|
| 65 | - sql_query("ALTER TABLE spip_articles ADD INDEX lang (lang)"); |
|
| 66 | - sql_query("ALTER TABLE spip_auteurs ADD INDEX lang (lang)"); |
|
| 67 | - sql_query("ALTER TABLE spip_rubriques ADD INDEX lang (lang)"); |
|
| 68 | - maj_version(1.704); |
|
| 69 | - } |
|
| 70 | - |
|
| 71 | - if (upgrade_vers(1.705, $version_installee, $version_cible)) { |
|
| 72 | - sql_query("ALTER TABLE spip_articles ADD langue_choisie VARCHAR(3) DEFAULT 'non'"); |
|
| 73 | - sql_query("ALTER TABLE spip_rubriques ADD langue_choisie VARCHAR(3) DEFAULT 'non'"); |
|
| 74 | - maj_version(1.705); |
|
| 75 | - } |
|
| 76 | - |
|
| 77 | - if (upgrade_vers(1.707, $version_installee, $version_cible)) { |
|
| 78 | - sql_query("UPDATE spip_articles SET langue_choisie='oui' WHERE MID(lang,1,1) != '.' AND lang != ''"); |
|
| 79 | - sql_query("UPDATE spip_articles SET lang=MID(lang,2,8) WHERE langue_choisie = 'non'"); |
|
| 80 | - sql_query("UPDATE spip_rubriques SET langue_choisie='oui' WHERE MID(lang,1,1) != '.' AND lang != ''"); |
|
| 81 | - sql_query("UPDATE spip_rubriques SET lang=MID(lang,2,8) WHERE langue_choisie = 'non'"); |
|
| 82 | - maj_version(1.707); |
|
| 83 | - } |
|
| 84 | - |
|
| 85 | - if (upgrade_vers(1.708, $version_installee, $version_cible)) { |
|
| 86 | - sql_query("ALTER TABLE spip_breves ADD lang VARCHAR(10) DEFAULT '' NOT NULL"); |
|
| 87 | - sql_query("ALTER TABLE spip_breves ADD langue_choisie VARCHAR(3) DEFAULT 'non'"); |
|
| 88 | - maj_version(1.708); |
|
| 89 | - } |
|
| 90 | - |
|
| 91 | - if (upgrade_vers(1.709, $version_installee, $version_cible)) { |
|
| 92 | - sql_query("ALTER TABLE spip_articles ADD id_trad bigint(21) DEFAULT '0' NOT NULL"); |
|
| 93 | - sql_query("ALTER TABLE spip_articles ADD INDEX id_trad (id_trad)"); |
|
| 94 | - maj_version(1.709); |
|
| 95 | - } |
|
| 96 | - |
|
| 97 | - if (upgrade_vers(1.717, $version_installee, $version_cible)) { |
|
| 98 | - sql_query("ALTER TABLE spip_articles ADD INDEX date_modif (date_modif)"); |
|
| 99 | - maj_version(1.717); |
|
| 100 | - } |
|
| 101 | - |
|
| 102 | - if (upgrade_vers(1.718, $version_installee, $version_cible)) { |
|
| 103 | - sql_query("ALTER TABLE spip_referers DROP domaine"); |
|
| 104 | - sql_query("ALTER TABLE spip_referers_articles DROP domaine"); |
|
| 105 | - sql_query("ALTER TABLE spip_referers_temp DROP domaine"); |
|
| 106 | - maj_version(1.718); |
|
| 107 | - } |
|
| 108 | - |
|
| 109 | - if (upgrade_vers(1.722, $version_installee, $version_cible)) { |
|
| 110 | - sql_query("ALTER TABLE spip_articles ADD nom_site tinytext NOT NULL"); |
|
| 111 | - sql_query("ALTER TABLE spip_articles ADD url_site VARCHAR(255) NOT NULL"); |
|
| 112 | - sql_query("ALTER TABLE spip_articles ADD INDEX url_site (url_site)"); |
|
| 113 | - if ($version_installee >= 1.720) { |
|
| 114 | - sql_query("UPDATE spip_articles SET url_site=url_ref"); |
|
| 115 | - sql_query("ALTER TABLE spip_articles DROP INDEX url_ref"); |
|
| 116 | - sql_query("ALTER TABLE spip_articles DROP url_ref"); |
|
| 117 | - } |
|
| 118 | - maj_version(1.722); |
|
| 119 | - } |
|
| 120 | - |
|
| 121 | - if (upgrade_vers(1.723, $version_installee, $version_cible)) { |
|
| 122 | - if ($version_installee == 1.722) { |
|
| 123 | - sql_query("ALTER TABLE spip_articles MODIFY url_site VARCHAR(255) NOT NULL"); |
|
| 124 | - sql_query("ALTER TABLE spip_articles DROP INDEX url_site;"); |
|
| 125 | - sql_query("ALTER TABLE spip_articles ADD INDEX url_site (url_site);"); |
|
| 126 | - } |
|
| 127 | - maj_version(1.723); |
|
| 128 | - } |
|
| 129 | - |
|
| 130 | - if (upgrade_vers(1.724, $version_installee, $version_cible)) { |
|
| 131 | - sql_query("ALTER TABLE spip_messages ADD date_fin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"); |
|
| 132 | - maj_version(1.724); |
|
| 133 | - } |
|
| 134 | - |
|
| 135 | - if (upgrade_vers(1.726, $version_installee, $version_cible)) { |
|
| 136 | - sql_query("ALTER TABLE spip_auteurs ADD low_sec tinytext NOT NULL"); |
|
| 137 | - maj_version(1.726); |
|
| 138 | - } |
|
| 139 | - |
|
| 140 | - if (upgrade_vers(1.727, $version_installee, $version_cible)) { |
|
| 141 | - // occitans : oci_xx -> oc_xx |
|
| 142 | - sql_query("UPDATE spip_auteurs SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'"); |
|
| 143 | - sql_query("UPDATE spip_rubriques SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'"); |
|
| 144 | - sql_query("UPDATE spip_articles SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'"); |
|
| 145 | - sql_query("UPDATE spip_breves SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'"); |
|
| 146 | - maj_version(1.727); |
|
| 147 | - } |
|
| 148 | - |
|
| 149 | - // Ici version 1.7 officielle |
|
| 150 | - if (upgrade_vers(1.728, $version_installee, $version_cible)) { |
|
| 151 | - sql_query("ALTER TABLE spip_articles ADD id_version int unsigned DEFAULT '0' NOT NULL"); |
|
| 152 | - maj_version(1.728); |
|
| 153 | - } |
|
| 154 | - |
|
| 155 | - if (upgrade_vers(1.730, $version_installee, $version_cible)) { |
|
| 156 | - sql_query("ALTER TABLE spip_articles ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 157 | - sql_query("ALTER TABLE spip_articles ADD INDEX idx (idx)"); |
|
| 158 | - sql_query("ALTER TABLE spip_auteurs ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 159 | - sql_query("ALTER TABLE spip_auteurs ADD INDEX idx (idx)"); |
|
| 160 | - sql_query("ALTER TABLE spip_breves ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 161 | - sql_query("ALTER TABLE spip_breves ADD INDEX idx (idx)"); |
|
| 162 | - sql_query("ALTER TABLE spip_mots ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 163 | - sql_query("ALTER TABLE spip_mots ADD INDEX idx (idx)"); |
|
| 164 | - sql_query("ALTER TABLE spip_rubriques ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 165 | - sql_query("ALTER TABLE spip_rubriques ADD INDEX idx (idx)"); |
|
| 166 | - sql_query("ALTER TABLE spip_syndic ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 167 | - sql_query("ALTER TABLE spip_syndic ADD INDEX idx (idx)"); |
|
| 168 | - sql_query("ALTER TABLE spip_forum ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 169 | - sql_query("ALTER TABLE spip_forum ADD INDEX idx (idx)"); |
|
| 170 | - sql_query("ALTER TABLE spip_signatures ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 171 | - sql_query("ALTER TABLE spip_signatures ADD INDEX idx (idx)"); |
|
| 172 | - maj_version(1.730); |
|
| 173 | - } |
|
| 174 | - |
|
| 175 | - if (upgrade_vers(1.731, $version_installee, $version_cible)) { |
|
| 176 | - sql_query("UPDATE spip_articles SET idx='1' where lang IN ('de','vi')"); |
|
| 177 | - sql_query("UPDATE spip_rubriques SET idx='1' where lang IN ('de','vi')"); |
|
| 178 | - sql_query("UPDATE spip_breves SET idx='1' where lang IN ('de','vi')"); |
|
| 179 | - sql_query("UPDATE spip_auteurs SET idx='1' where lang IN ('de','vi')"); |
|
| 180 | - maj_version(1.731); |
|
| 181 | - } |
|
| 182 | - |
|
| 183 | - if (upgrade_vers(1.732, $version_installee, |
|
| 184 | - $version_cible)) { // en correction d'un vieux truc qui avait fait sauter le champ inclus sur les bases version 1.415 |
|
| 185 | - sql_query("ALTER TABLE spip_documents ADD inclus VARCHAR(3) DEFAULT 'non'"); |
|
| 186 | - maj_version(1.732); |
|
| 187 | - } |
|
| 188 | - |
|
| 189 | - if (upgrade_vers(1.733, $version_installee, $version_cible)) { |
|
| 190 | - // sql_query("ALTER TABLE spip_articles ADD id_version int unsigned DEFAULT '0' NOT NULL"); |
|
| 191 | - sql_query("DROP TABLE spip_versions"); |
|
| 192 | - sql_query("DROP TABLE spip_versions_fragments"); |
|
| 193 | - creer_base(); |
|
| 194 | - maj_version(1.733); |
|
| 195 | - } |
|
| 196 | - |
|
| 197 | - #if ($version_installee < 1.734) { |
|
| 198 | - # // integrer nouvelles tables auxiliaires du compilateur ESJ |
|
| 199 | - # creer_base(); |
|
| 200 | - # maj_version(1.734); |
|
| 201 | - #} |
|
| 29 | + if (upgrade_vers(1.702, $version_installee, $version_cible)) { |
|
| 30 | + sql_query("ALTER TABLE spip_articles ADD extra longblob NULL"); |
|
| 31 | + sql_query("ALTER TABLE spip_auteurs ADD extra longblob NULL"); |
|
| 32 | + sql_query("ALTER TABLE spip_breves ADD extra longblob NULL"); |
|
| 33 | + sql_query("ALTER TABLE spip_rubriques ADD extra longblob NULL"); |
|
| 34 | + sql_query("ALTER TABLE spip_mots ADD extra longblob NULL"); |
|
| 35 | + |
|
| 36 | + // recuperer les eventuels 'supplement' installes en 1.701 |
|
| 37 | + if ($version_installee == 1.701) { |
|
| 38 | + sql_query("UPDATE spip_articles SET extra = supplement"); |
|
| 39 | + sql_query("ALTER TABLE spip_articles DROP supplement"); |
|
| 40 | + sql_query("UPDATE spip_auteurs SET extra = supplement"); |
|
| 41 | + sql_query("ALTER TABLE spip_auteurs DROP supplement"); |
|
| 42 | + sql_query("UPDATE spip_breves SET extra = supplement"); |
|
| 43 | + sql_query("ALTER TABLE spip_breves DROP supplement"); |
|
| 44 | + sql_query("UPDATE spip_rubriques SET extra = supplement"); |
|
| 45 | + sql_query("ALTER TABLE spip_rubriques DROP supplement"); |
|
| 46 | + sql_query("UPDATE spip_mots SET extra = supplement"); |
|
| 47 | + sql_query("ALTER TABLE spip_mots DROP supplement"); |
|
| 48 | + } |
|
| 49 | + |
|
| 50 | + $u = sql_query("SELECT extra FROM spip_articles"); |
|
| 51 | + $u &= sql_query("SELECT extra FROM spip_auteurs"); |
|
| 52 | + $u &= sql_query("SELECT extra FROM spip_breves"); |
|
| 53 | + $u &= sql_query("SELECT extra FROM spip_rubriques"); |
|
| 54 | + $u &= sql_query("SELECT extra FROM spip_mots"); |
|
| 55 | + maj_version(1.702, $u); |
|
| 56 | + } |
|
| 57 | + |
|
| 58 | + if (upgrade_vers(1.703, $version_installee, $version_cible)) { |
|
| 59 | + sql_query("ALTER TABLE spip_articles ADD lang VARCHAR(10) DEFAULT '' NOT NULL"); |
|
| 60 | + sql_query("ALTER TABLE spip_rubriques ADD lang VARCHAR(10) DEFAULT '' NOT NULL"); |
|
| 61 | + maj_version(1.703); |
|
| 62 | + } |
|
| 63 | + |
|
| 64 | + if (upgrade_vers(1.704, $version_installee, $version_cible)) { |
|
| 65 | + sql_query("ALTER TABLE spip_articles ADD INDEX lang (lang)"); |
|
| 66 | + sql_query("ALTER TABLE spip_auteurs ADD INDEX lang (lang)"); |
|
| 67 | + sql_query("ALTER TABLE spip_rubriques ADD INDEX lang (lang)"); |
|
| 68 | + maj_version(1.704); |
|
| 69 | + } |
|
| 70 | + |
|
| 71 | + if (upgrade_vers(1.705, $version_installee, $version_cible)) { |
|
| 72 | + sql_query("ALTER TABLE spip_articles ADD langue_choisie VARCHAR(3) DEFAULT 'non'"); |
|
| 73 | + sql_query("ALTER TABLE spip_rubriques ADD langue_choisie VARCHAR(3) DEFAULT 'non'"); |
|
| 74 | + maj_version(1.705); |
|
| 75 | + } |
|
| 76 | + |
|
| 77 | + if (upgrade_vers(1.707, $version_installee, $version_cible)) { |
|
| 78 | + sql_query("UPDATE spip_articles SET langue_choisie='oui' WHERE MID(lang,1,1) != '.' AND lang != ''"); |
|
| 79 | + sql_query("UPDATE spip_articles SET lang=MID(lang,2,8) WHERE langue_choisie = 'non'"); |
|
| 80 | + sql_query("UPDATE spip_rubriques SET langue_choisie='oui' WHERE MID(lang,1,1) != '.' AND lang != ''"); |
|
| 81 | + sql_query("UPDATE spip_rubriques SET lang=MID(lang,2,8) WHERE langue_choisie = 'non'"); |
|
| 82 | + maj_version(1.707); |
|
| 83 | + } |
|
| 84 | + |
|
| 85 | + if (upgrade_vers(1.708, $version_installee, $version_cible)) { |
|
| 86 | + sql_query("ALTER TABLE spip_breves ADD lang VARCHAR(10) DEFAULT '' NOT NULL"); |
|
| 87 | + sql_query("ALTER TABLE spip_breves ADD langue_choisie VARCHAR(3) DEFAULT 'non'"); |
|
| 88 | + maj_version(1.708); |
|
| 89 | + } |
|
| 90 | + |
|
| 91 | + if (upgrade_vers(1.709, $version_installee, $version_cible)) { |
|
| 92 | + sql_query("ALTER TABLE spip_articles ADD id_trad bigint(21) DEFAULT '0' NOT NULL"); |
|
| 93 | + sql_query("ALTER TABLE spip_articles ADD INDEX id_trad (id_trad)"); |
|
| 94 | + maj_version(1.709); |
|
| 95 | + } |
|
| 96 | + |
|
| 97 | + if (upgrade_vers(1.717, $version_installee, $version_cible)) { |
|
| 98 | + sql_query("ALTER TABLE spip_articles ADD INDEX date_modif (date_modif)"); |
|
| 99 | + maj_version(1.717); |
|
| 100 | + } |
|
| 101 | + |
|
| 102 | + if (upgrade_vers(1.718, $version_installee, $version_cible)) { |
|
| 103 | + sql_query("ALTER TABLE spip_referers DROP domaine"); |
|
| 104 | + sql_query("ALTER TABLE spip_referers_articles DROP domaine"); |
|
| 105 | + sql_query("ALTER TABLE spip_referers_temp DROP domaine"); |
|
| 106 | + maj_version(1.718); |
|
| 107 | + } |
|
| 108 | + |
|
| 109 | + if (upgrade_vers(1.722, $version_installee, $version_cible)) { |
|
| 110 | + sql_query("ALTER TABLE spip_articles ADD nom_site tinytext NOT NULL"); |
|
| 111 | + sql_query("ALTER TABLE spip_articles ADD url_site VARCHAR(255) NOT NULL"); |
|
| 112 | + sql_query("ALTER TABLE spip_articles ADD INDEX url_site (url_site)"); |
|
| 113 | + if ($version_installee >= 1.720) { |
|
| 114 | + sql_query("UPDATE spip_articles SET url_site=url_ref"); |
|
| 115 | + sql_query("ALTER TABLE spip_articles DROP INDEX url_ref"); |
|
| 116 | + sql_query("ALTER TABLE spip_articles DROP url_ref"); |
|
| 117 | + } |
|
| 118 | + maj_version(1.722); |
|
| 119 | + } |
|
| 120 | + |
|
| 121 | + if (upgrade_vers(1.723, $version_installee, $version_cible)) { |
|
| 122 | + if ($version_installee == 1.722) { |
|
| 123 | + sql_query("ALTER TABLE spip_articles MODIFY url_site VARCHAR(255) NOT NULL"); |
|
| 124 | + sql_query("ALTER TABLE spip_articles DROP INDEX url_site;"); |
|
| 125 | + sql_query("ALTER TABLE spip_articles ADD INDEX url_site (url_site);"); |
|
| 126 | + } |
|
| 127 | + maj_version(1.723); |
|
| 128 | + } |
|
| 129 | + |
|
| 130 | + if (upgrade_vers(1.724, $version_installee, $version_cible)) { |
|
| 131 | + sql_query("ALTER TABLE spip_messages ADD date_fin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"); |
|
| 132 | + maj_version(1.724); |
|
| 133 | + } |
|
| 134 | + |
|
| 135 | + if (upgrade_vers(1.726, $version_installee, $version_cible)) { |
|
| 136 | + sql_query("ALTER TABLE spip_auteurs ADD low_sec tinytext NOT NULL"); |
|
| 137 | + maj_version(1.726); |
|
| 138 | + } |
|
| 139 | + |
|
| 140 | + if (upgrade_vers(1.727, $version_installee, $version_cible)) { |
|
| 141 | + // occitans : oci_xx -> oc_xx |
|
| 142 | + sql_query("UPDATE spip_auteurs SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'"); |
|
| 143 | + sql_query("UPDATE spip_rubriques SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'"); |
|
| 144 | + sql_query("UPDATE spip_articles SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'"); |
|
| 145 | + sql_query("UPDATE spip_breves SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'"); |
|
| 146 | + maj_version(1.727); |
|
| 147 | + } |
|
| 148 | + |
|
| 149 | + // Ici version 1.7 officielle |
|
| 150 | + if (upgrade_vers(1.728, $version_installee, $version_cible)) { |
|
| 151 | + sql_query("ALTER TABLE spip_articles ADD id_version int unsigned DEFAULT '0' NOT NULL"); |
|
| 152 | + maj_version(1.728); |
|
| 153 | + } |
|
| 154 | + |
|
| 155 | + if (upgrade_vers(1.730, $version_installee, $version_cible)) { |
|
| 156 | + sql_query("ALTER TABLE spip_articles ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 157 | + sql_query("ALTER TABLE spip_articles ADD INDEX idx (idx)"); |
|
| 158 | + sql_query("ALTER TABLE spip_auteurs ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 159 | + sql_query("ALTER TABLE spip_auteurs ADD INDEX idx (idx)"); |
|
| 160 | + sql_query("ALTER TABLE spip_breves ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 161 | + sql_query("ALTER TABLE spip_breves ADD INDEX idx (idx)"); |
|
| 162 | + sql_query("ALTER TABLE spip_mots ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 163 | + sql_query("ALTER TABLE spip_mots ADD INDEX idx (idx)"); |
|
| 164 | + sql_query("ALTER TABLE spip_rubriques ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 165 | + sql_query("ALTER TABLE spip_rubriques ADD INDEX idx (idx)"); |
|
| 166 | + sql_query("ALTER TABLE spip_syndic ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 167 | + sql_query("ALTER TABLE spip_syndic ADD INDEX idx (idx)"); |
|
| 168 | + sql_query("ALTER TABLE spip_forum ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 169 | + sql_query("ALTER TABLE spip_forum ADD INDEX idx (idx)"); |
|
| 170 | + sql_query("ALTER TABLE spip_signatures ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"); |
|
| 171 | + sql_query("ALTER TABLE spip_signatures ADD INDEX idx (idx)"); |
|
| 172 | + maj_version(1.730); |
|
| 173 | + } |
|
| 174 | + |
|
| 175 | + if (upgrade_vers(1.731, $version_installee, $version_cible)) { |
|
| 176 | + sql_query("UPDATE spip_articles SET idx='1' where lang IN ('de','vi')"); |
|
| 177 | + sql_query("UPDATE spip_rubriques SET idx='1' where lang IN ('de','vi')"); |
|
| 178 | + sql_query("UPDATE spip_breves SET idx='1' where lang IN ('de','vi')"); |
|
| 179 | + sql_query("UPDATE spip_auteurs SET idx='1' where lang IN ('de','vi')"); |
|
| 180 | + maj_version(1.731); |
|
| 181 | + } |
|
| 182 | + |
|
| 183 | + if (upgrade_vers(1.732, $version_installee, |
|
| 184 | + $version_cible)) { // en correction d'un vieux truc qui avait fait sauter le champ inclus sur les bases version 1.415 |
|
| 185 | + sql_query("ALTER TABLE spip_documents ADD inclus VARCHAR(3) DEFAULT 'non'"); |
|
| 186 | + maj_version(1.732); |
|
| 187 | + } |
|
| 188 | + |
|
| 189 | + if (upgrade_vers(1.733, $version_installee, $version_cible)) { |
|
| 190 | + // sql_query("ALTER TABLE spip_articles ADD id_version int unsigned DEFAULT '0' NOT NULL"); |
|
| 191 | + sql_query("DROP TABLE spip_versions"); |
|
| 192 | + sql_query("DROP TABLE spip_versions_fragments"); |
|
| 193 | + creer_base(); |
|
| 194 | + maj_version(1.733); |
|
| 195 | + } |
|
| 196 | + |
|
| 197 | + #if ($version_installee < 1.734) { |
|
| 198 | + # // integrer nouvelles tables auxiliaires du compilateur ESJ |
|
| 199 | + # creer_base(); |
|
| 200 | + # maj_version(1.734); |
|
| 201 | + #} |
|
| 202 | 202 | } |
@@ -19,10 +19,10 @@ |
||
| 19 | 19 | * @package SPIP\Core\SQL\Upgrade |
| 20 | 20 | **/ |
| 21 | 21 | if (!defined('_ECRIRE_INC_VERSION')) { |
| 22 | - return; |
|
| 22 | + return; |
|
| 23 | 23 | } |
| 24 | 24 | |
| 25 | 25 | $GLOBALS['maj'][2021021800] = [ |
| 26 | - ['sql_alter', "TABLE spip_auteurs CHANGE imessage imessage VARCHAR(3) DEFAULT '' NOT NULL" ], |
|
| 27 | - ['sql_updateq', "spip_auteurs", ['imessage' => 'oui'], "imessage != 'non' OR imessage IS NULL" ], |
|
| 26 | + ['sql_alter', "TABLE spip_auteurs CHANGE imessage imessage VARCHAR(3) DEFAULT '' NOT NULL" ], |
|
| 27 | + ['sql_updateq', "spip_auteurs", ['imessage' => 'oui'], "imessage != 'non' OR imessage IS NULL" ], |
|
| 28 | 28 | ]; |
@@ -23,6 +23,6 @@ |
||
| 23 | 23 | } |
| 24 | 24 | |
| 25 | 25 | $GLOBALS['maj'][2021021800] = [ |
| 26 | - ['sql_alter', "TABLE spip_auteurs CHANGE imessage imessage VARCHAR(3) DEFAULT '' NOT NULL" ], |
|
| 27 | - ['sql_updateq', "spip_auteurs", ['imessage' => 'oui'], "imessage != 'non' OR imessage IS NULL" ], |
|
| 26 | + ['sql_alter', "TABLE spip_auteurs CHANGE imessage imessage VARCHAR(3) DEFAULT '' NOT NULL"], |
|
| 27 | + ['sql_updateq', "spip_auteurs", ['imessage' => 'oui'], "imessage != 'non' OR imessage IS NULL"], |
|
| 28 | 28 | ]; |
