Author: pierre.basson@gmail.com
Date: Mon Jul 24 01:57:08 2006
New Revision: 4198
Log:
ajout de l'indexation sur la table spip_sondages
Modified:
_plugins_/_contenu_editorial_/spip-sondages/base/sondages.php
_plugins_/_contenu_editorial_/spip-sondages/inc/sondages_admin.php
_plugins_/_contenu_editorial_/spip-sondages/plugin.xml
_plugins_/_contenu_editorial_/spip-sondages/resultat_sondage.html
Modified: _plugins_/_contenu_editorial_/spip-sondages/base/sondages.php
--- _plugins_/_contenu_editorial_/spip-sondages/base/sondages.php (original)
+++ _plugins_/_contenu_editorial_/spip-sondages/base/sondages.php Mon Jul 24 01:57:08 2006
@@ -39,7 +39,8 @@
"type" => "enum('simple','multiple') NOT NULL default 'simple'",
"en_ligne" => "enum('oui','non') NOT NULL default 'non'",
"statut" => "enum('en_attente','publie','termine') NOT NULL default 'en_attente'",
- "extra" => "longblob NULL"
+ "extra" => "longblob NULL",
+ "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL"
);
$spip_sondages_key = array(
"PRIMARY KEY" => "id_sondage"
Modified: _plugins_/_contenu_editorial_/spip-sondages/inc/sondages_admin.php
--- _plugins_/_contenu_editorial_/spip-sondages/inc/sondages_admin.php (original)
+++ _plugins_/_contenu_editorial_/spip-sondages/inc/sondages_admin.php Mon Jul 24 01:57:08 2006
@@ -37,12 +37,13 @@
ecrire_metas();
} else {
$version_base = $GLOBALS['meta']['spip_sondages_version'];
-/* if ($version_base < 1.1) {
+ if ($version_base < 1.1) {
creer_base();
+ spip_query("ALTER TABLE spip_sondages ADD idx ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL;");
ecrire_meta('spip_sondages_version', $version_base = 1.1);
ecrire_metas();
}
-*/ }
+ }
return true;
}
Modified: _plugins_/_contenu_editorial_/spip-sondages/plugin.xml
--- _plugins_/_contenu_editorial_/spip-sondages/plugin.xml (original)
+++ _plugins_/_contenu_editorial_/spip-sondages/plugin.xml Mon Jul 24 01:57:08 2006
@@ -1,7 +1,7 @@
<plugin>
<nom>Plugin SPIP-Sondages</nom>
<auteur>[Artégo->http://www.artego.fr]</auteur>
- <version>1</version>
+ <version>1.1</version>
<etat>stable</etat>
<description>Gestion de sondages</description>
<options>sondages.php</options>
Modified: _plugins_/_contenu_editorial_/spip-sondages/resultat_sondage.html
(empty)