= 1.720) {
spip_query("UPDATE spip_articles SET url_site=url_ref");
spip_query("ALTER TABLE spip_articles DROP INDEX url_ref");
spip_query("ALTER TABLE spip_articles DROP url_ref");
}
maj_version (1.722);
}
if (upgrade_vers(1.723, $version_installee, $version_cible)) {
if ($version_installee == 1.722) {
spip_query("ALTER TABLE spip_articles MODIFY url_site VARCHAR(255) NOT NULL");
spip_query("ALTER TABLE spip_articles DROP INDEX url_site;");
spip_query("ALTER TABLE spip_articles ADD INDEX url_site (url_site);");
}
maj_version (1.723);
}
if (upgrade_vers(1.724, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_messages ADD date_fin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
maj_version (1.724);
}
if (upgrade_vers(1.726, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_auteurs ADD low_sec tinytext NOT NULL");
maj_version (1.726);
}
if (upgrade_vers(1.727, $version_installee, $version_cible)) {
// occitans : oci_xx -> oc_xx
spip_query("UPDATE spip_auteurs SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
spip_query("UPDATE spip_rubriques SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
spip_query("UPDATE spip_articles SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
spip_query("UPDATE spip_breves SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
maj_version (1.727);
}
// Ici version 1.7 officielle
if (upgrade_vers(1.728, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_articles ADD id_version int unsigned DEFAULT '0' NOT NULL");
maj_version (1.728);
}
if (upgrade_vers(1.730, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_articles ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL");
spip_query("ALTER TABLE spip_articles ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_auteurs ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL");
spip_query("ALTER TABLE spip_auteurs ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_breves ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL");
spip_query("ALTER TABLE spip_breves ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_mots ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL");
spip_query("ALTER TABLE spip_mots ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_rubriques ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL");
spip_query("ALTER TABLE spip_rubriques ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_syndic ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL");
spip_query("ALTER TABLE spip_syndic ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_forum ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL");
spip_query("ALTER TABLE spip_forum ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_signatures ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL");
spip_query("ALTER TABLE spip_signatures ADD INDEX idx (idx)");
maj_version (1.730);
}
if (upgrade_vers(1.731, $version_installee, $version_cible)) {
spip_query("UPDATE spip_articles SET idx='1' where lang IN ('de','vi')");
spip_query("UPDATE spip_rubriques SET idx='1' where lang IN ('de','vi')");
spip_query("UPDATE spip_breves SET idx='1' where lang IN ('de','vi')");
spip_query("UPDATE spip_auteurs SET idx='1' where lang IN ('de','vi')");
maj_version (1.731);
}
if (upgrade_vers(1.732, $version_installee, $version_cible)) { // en correction d'un vieux truc qui avait fait sauter le champ inclus sur les bases version 1.415
spip_query("ALTER TABLE spip_documents ADD inclus VARCHAR(3) DEFAULT 'non'");
maj_version (1.732);
}
if (upgrade_vers(1.733, $version_installee, $version_cible)) {
// spip_query("ALTER TABLE spip_articles ADD id_version int unsigned DEFAULT '0' NOT NULL");
spip_query("DROP TABLE spip_versions");
spip_query("DROP TABLE spip_versions_fragments");
creer_base();
maj_version(1.733);
}
#if ($version_installee < 1.734) {
# // integrer nouvelles tables auxiliaires du compilateur ESJ
# creer_base();
# maj_version(1.734);
#}
}
?>