spip / SPIP

 **/

function maj_legacy_v012_dist($version_installee, $version_cible) {

	// Correction de l'oubli des modifs creations depuis 1.04

	if (upgrade_vers(1.204, $version_installee, $version_cible)) {

		sql_query("ALTER TABLE spip_articles ADD accepter_forum VARCHAR(3) NOT NULL");

		sql_query("ALTER TABLE spip_forum ADD id_message bigint(21) NOT NULL");

		sql_query("ALTER TABLE spip_forum ADD INDEX id_message (id_message)");

		sql_query("ALTER TABLE spip_auteurs ADD en_ligne datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");

		sql_query("ALTER TABLE spip_auteurs ADD imessage VARCHAR(3) not null");

		sql_query("ALTER TABLE spip_auteurs ADD messagerie VARCHAR(3) not null");

		maj_version(1.204);

	}

	if (upgrade_vers(1.207, $version_installee, $version_cible)) {

		sql_query("ALTER TABLE spip_rubriques DROP INDEX id_rubrique");

		maj_version(1.204);

	}

	if (upgrade_vers(1.207, $version_installee, $version_cible)) {

		sql_query("ALTER TABLE spip_rubriques DROP INDEX id_rubrique");

		sql_query("ALTER TABLE spip_rubriques ADD INDEX id_parent (id_parent)");

		sql_query("ALTER TABLE spip_rubriques ADD statut VARCHAR(10) NOT NULL");

		// Declencher le calcul des rubriques publiques

		include_spip('inc/rubriques');

		calculer_rubriques();

		maj_version(1.207);

	}

	if (upgrade_vers(1.208, $version_installee, $version_cible)) {

		sql_query("ALTER TABLE spip_auteurs_messages CHANGE forum vu CHAR(3) NOT NULL");

 * @param float $version_cible Version de destination

 **/

function maj_legacy_v013_dist($version_installee, $version_cible) {

	if (upgrade_vers(1.3, $version_installee, $version_cible)) {

		// Modifier la syndication (pour liste de sites)

		sql_query("ALTER TABLE spip_syndic ADD syndication VARCHAR(3) NOT NULL");

		sql_query("ALTER TABLE spip_syndic ADD statut VARCHAR(10) NOT NULL");

		sql_query("ALTER TABLE spip_syndic ADD date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");

		sql_query("UPDATE spip_syndic SET syndication='oui', statut='publie', date=NOW()");

		// Statut pour articles syndication, pour pouvoir desactiver un article

		sql_query("ALTER TABLE spip_syndic_articles ADD statut VARCHAR(10) NOT NULL");

		sql_query("UPDATE spip_syndic_articles SET statut='publie'");

		maj_version(1.3);

	}

	if (upgrade_vers(1.301, $version_installee, $version_cible)) {

		sql_query("ALTER TABLE spip_forum ADD id_syndic bigint(21) DEFAULT '0' NOT NULL");

		maj_version(1.718);

	}

	if (upgrade_vers(1.722, $version_installee, $version_cible)) {

		sql_query("ALTER TABLE spip_articles ADD nom_site tinytext NOT NULL");

		sql_query("ALTER TABLE spip_articles ADD url_site VARCHAR(255) NOT NULL");

		sql_query("ALTER TABLE spip_articles ADD INDEX url_site (url_site)");

		if ($version_installee >= 1.720) {

			sql_query("UPDATE spip_articles SET url_site=url_ref");

			sql_query("ALTER TABLE spip_articles DROP INDEX url_ref");

			sql_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) {

	// corrections diverses

	if (upgrade_vers(1.809, $version_installee, $version_cible)) {

		// plus de retour possible vers 1.7.2

		sql_query("DROP TABLE spip_forum_cache");

		// les requetes ci-dessous ne s'appliqueront que si on est passe

		// par une certaine version de developpement - oublie de le faire

		// plus tot, car le code d'alors recreait purement et simplement

		// cette table

		sql_query("ALTER TABLE spip_versions DROP chapo");

		sql_query("ALTER TABLE spip_versions DROP texte");

		sql_query("ALTER TABLE spip_versions DROP ps");

		sql_query("ALTER TABLE spip_versions DROP extra");

		sql_query("ALTER TABLE spip_versions ADD champs text NOT NULL");

		maj_version(1.809);

	}

	// Annuler les brouillons de forum jamais valides

	if (upgrade_vers(1.810, $version_installee, $version_cible)) {

		sql_query("UPDATE spip_syndic_articles SET `tags` = REPLACE(`tags`, 'rel=\"category\">', 'rel=\"directory\">') WHERE `tags` like '%category%'");

		maj_version(1.908);

	}

	if (upgrade_vers(1.909, $version_installee, $version_cible)) {

		sql_query("ALTER IGNORE TABLE spip_mots_articles ADD PRIMARY KEY (`id_article`, `id_mot`)");

		sql_query("ALTER IGNORE TABLE spip_mots_breves ADD PRIMARY KEY (`id_breve`, `id_mot`)");

		sql_query("ALTER IGNORE TABLE spip_mots_rubriques ADD PRIMARY KEY (`id_rubrique`, `id_mot`)");

		sql_query("ALTER IGNORE TABLE spip_mots_syndic ADD PRIMARY KEY (`id_syndic`, `id_mot`)");

		sql_query("ALTER IGNORE TABLE spip_mots_documents ADD PRIMARY KEY (`id_document`, `id_mot`)");

		sql_query("ALTER IGNORE TABLE spip_mots_forum ADD PRIMARY KEY (`id_forum`, `id_mot`)");

		maj_version(1.909);

	}

	if (upgrade_vers(1.910, $version_installee, $version_cible)) {

		sql_query("ALTER IGNORE TABLE spip_auteurs_articles ADD PRIMARY KEY (`id_auteur`, `id_article`)");

		maj_version('1.919');

	}

	if (upgrade_vers(1.920, $version_installee, $version_cible)) {

		sql_query("ALTER IGNORE TABLE spip_documents_articles ADD PRIMARY KEY (`id_article`, `id_document`)");

		sql_query("ALTER IGNORE TABLE spip_documents_breves ADD PRIMARY KEY (`id_breve`, `id_document`)");

		sql_query("ALTER IGNORE TABLE spip_documents_rubriques ADD PRIMARY KEY (`id_rubrique`, `id_document`)");

		sql_query("ALTER IGNORE TABLE spip_documents_articles DROP INDEX `id_article`");

		sql_query("ALTER IGNORE TABLE spip_documents_breves DROP INDEX `id_breve`");

		sql_query("ALTER IGNORE TABLE spip_documents_rubriques DROP INDEX `id_rubrique`");

		maj_version('1.920');

	}

	if (upgrade_vers(1.922, $version_installee, $version_cible)) {

		sql_query("ALTER TABLE spip_meta ADD `impt` ENUM('non', 'oui') DEFAULT 'oui' NOT NULL AFTER `valeur`");

		$meta_serveur = array(