%k25u25%fgd5n!?%k25u25%fgd5n!%k25u25%fgd5n!?%k25u25%fgd5n!v010.php 0000666 00000003126 15145326552 0005761 0 ustar 00
v017.php 0000666 00000021376 15145326552 0005777 0 ustar 00 = 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);
#}
}
?>
v019.php 0000666 00000066121 15145326552 0005776 0 ustar 00 l'index numerique entier est la * par 1000 (resultat < SVN c'est ok)
// FLV est incrustable, la MAJ precedente l'avait oublie
$GLOBALS['maj'][1931] = array(
array('spip_query', "UPDATE spip_types_documents SET `inclus`='embed' WHERE `extension`='flv'")
);
// Ajout de spip_forum.date_thread, et on essaie de le remplir
// a coup de table temporaire (est-ce autorise partout... sinon
// tant pis, ca ne marchera que pour les forums recemment modifies)
$GLOBALS['maj'][1932] = array(
array('sql_alter', "TABLE spip_forum ADD `date_thread` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"),
array('sql_alter', "TABLE spip_forum ADD INDEX `date_thread` (`date_thread`)"),
array('spip_query', "DROP TABLE IF EXISTS spip_tmp"),
array('spip_query', "CREATE TABLE spip_tmp SELECT `id_thread`,MAX(`date_heure`) AS dt FROM spip_forum GROUP BY `id_thread`"),
array('sql_alter', "TABLE spip_tmp ADD INDEX `p` (`id_thread`)"),
array('spip_query', "UPDATE spip_forum AS F JOIN spip_tmp AS T ON F.id_thread=T.id_thread SET F.date_thread=T.dt"),
array('spip_query', "DROP TABLE spip_tmp"),
);
// Retrait de _DIR_IMG dans le champ fichier de la table des doc
function maj_1_934 () {
// attention, en cas de mutualisation _DIR_IMG contient quelque chose comme sites/urldusite/IMG/
// essayons en ne prenant que le dernier segment
$dir_img = basename(_DIR_IMG).'/';
$res = spip_query("SELECT fichier FROM spip_documents WHERE fichier LIKE " . _q($dir_img . '%') . " LIMIT 0,1");
if (!$row = spip_fetch_array($res)){
//Ęsinon on essaye avec le chemin complet
// il faut donc verifier qu'on a bien le bon nom de repertoire
$dir_img = substr(_DIR_IMG,strlen(_DIR_RACINE));
}
$n = strlen($dir_img) + 1;
spip_query("UPDATE spip_documents SET `fichier`=substring(fichier,$n) WHERE `fichier` LIKE " . _q($dir_img . '%'));
}
$GLOBALS['maj'][1934] = array(array('maj_1_934'));
function maj_1_935 () {
include_spip('inc/texte');
foreach(array('article'=>'id_article','rubrique'=>'id_rubrique','breve'=>'id_breve') as $type => $id_table_objet){
$table_objet = "$type"."s";
$chapo = $type=='article' ? ",a.chapo":"";
$res = spip_query("SELECT a.$id_table_objet,a.texte $chapo FROM spip_documents_$table_objet AS d JOIN spip_$table_objet AS a ON a.$id_table_objet=d.$id_table_objet GROUP BY $id_table_objet");
while ($row = sql_fetch($res)){
$GLOBALS['doublons_documents_inclus'] = array();
traiter_modeles(($chapo?$row['chapo']:"").$row['texte'],true); // detecter les doublons
if (count($GLOBALS['doublons_documents_inclus'])){
$id = $row[$id_table_objet];
$liste = "(".implode(",$id,'oui'),(",$GLOBALS['doublons_documents_inclus']).",$id,'oui')";
spip_query("REPLACE INTO spip_documents_$table_objet (`id_document`,`$id_table_objet`,`vu`) VALUES $liste");
}
}
}
}
$GLOBALS['maj'][1935] = array(
array('sql_alter', "TABLE spip_documents_articles ADD `vu` ENUM('non', 'oui') DEFAULT 'non' NOT NULL"),
array('sql_alter', "TABLE spip_documents_rubriques ADD `vu` ENUM('non', 'oui') DEFAULT 'non' NOT NULL"),
array('sql_alter', "TABLE spip_documents_breves ADD `vu` ENUM('non', 'oui') DEFAULT 'non' NOT NULL"),
array('maj_1_935')
);
// http://doc.spip.org/@convertir_un_champ_blob_en_text
function convertir_un_champ_blob_en_text($table,$champ,$type){
// precaution : definir le charset par defaut de la table, car c'est lui qui prevaut
// et il faut qu'il corresponde au charset de la connexion qui est celui
// dans lequel on a ecrit le champ en blob
if ($charset = sql_getfetsel('@@character_set_connection')){
sql_alter("TABLE $table DEFAULT CHARACTER SET ".$charset);
}
$res = spip_query("SHOW FULL COLUMNS FROM $table LIKE '$champ'");
if ($row = sql_fetch($res)){
if (strtolower($row['Type'])!=strtolower($type)) {
$default = $row['Default']?(" DEFAULT ".sql_quote($row['Default'])):"";
$notnull = ($row['Null']=='YES')?"":" NOT NULL";
sql_alter("TABLE $table CHANGE $champ $champ $type $default $notnull");
}
}
}
$GLOBALS['maj'][1937] = array(
// convertir les champs blob des tables spip en champs texte
array('convertir_un_champ_blob_en_text',"spip_articles","texte","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_articles","extra","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_auteurs","extra","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_breves","texte","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_breves","extra","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_messages","texte","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_mots","texte","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_mots","extra","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_groupes_mots","texte","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_rubriques","texte","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_rubriques","extra","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_syndic","nom_site","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_syndic","descriptif","TEXT"),
array('convertir_un_champ_blob_en_text',"spip_syndic","extra","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_syndic_articles","descriptif","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_petitions","texte","LONGTEXT"),
array('convertir_un_champ_blob_en_text',"spip_ortho_cache","suggest","TEXT"),
);
function maj_1_938 () {
$res = sql_select('extension','spip_documents',"extension='' OR extension is NULL");
if ($n = sql_count($res)) {
$repli = false;
// verifier que la colonne id_type est toujours la (update post 1.938)
$desc = sql_showtable('spip_documents');
if (!$desc OR !isset($desc['field']['id_type']))
$repli = true;
$s = sql_select('extension'.($repli?'':',id_type'),'spip_types_documents');
while ($t = sql_fetch($s)) {
if (isset($t['id_type']))
spip_query("UPDATE spip_documents SET `extension`="._q($t['extension']) ." WHERE `id_type`="._q($t['id_type']));
else
spip_query("UPDATE spip_documents SET `extension`="._q($t['extension']) ." WHERE fichier LIKE "._q("%." . $t['extension']));
}
$res = sql_select('extension','spip_documents',"extension='' OR extension is NULL");
if ($n = sql_count($res))
spip_log("Table spip_documents : Colonne extension incomplete : $n lignes vides");
}
}
$GLOBALS['maj'][1938] = array(
// Des champs NULL a l'installation
// Ajouter un champ extension aux spip_documents, et le
// remplir avec les valeurs ad hoc
array('sql_alter', "TABLE spip_documents ADD `extension` VARCHAR(10) DEFAULT '' NOT NULL "),
array('sql_alter', "TABLE spip_documents ADD INDEX `extension` (`extension`)"),
array('maj_1_938'),
array('sql_alter', "TABLE spip_documents DROP INDEX `id_type`, DROP `id_type`"),
## supprimer l'autoincrement avant de supprimer la PRIMARY KEY
array('sql_alter', "TABLE spip_types_documents CHANGE `id_type` `id_type` BIGINT( 21 ) NOT NULL ") ,
array('sql_alter', "TABLE spip_types_documents DROP PRIMARY KEY"),
array('sql_alter', "TABLE spip_types_documents DROP `id_type`"),
array('sql_alter', "TABLE spip_types_documents DROP INDEX `extension`"),
## recreer la PRIMARY KEY sur spip_types_documents.extension
array('sql_alter', "TABLE spip_types_documents ADD PRIMARY KEY (`extension`)"),
);
$GLOBALS['maj'][1939] = array(
array('sql_alter', "TABLE spip_visites CHANGE `visites` `visites` INT UNSIGNED DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_visites_articles CHANGE `visites` `visites` INT UNSIGNED DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_referers CHANGE `visites` `visites` INT UNSIGNED DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_referers CHANGE `visites_jour` `visites_jour` INT UNSIGNED DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_referers CHANGE `visites_veille` `visites_veille` INT UNSIGNED DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_referers_articles CHANGE `visites` `visites` INT UNSIGNED DEFAULT '0' NOT NULL")
);
$GLOBALS['maj'][1940] = array(
array('spip_query', "DROP TABLE spip_caches"),
);
$GLOBALS['maj'][1941] = array(
array('spip_query', "UPDATE spip_meta SET `valeur` = '' WHERE `nom`='preview' AND `valeur`='non' "),
array('spip_query', "UPDATE spip_meta SET `valeur` = ',0minirezo,1comite,' WHERE `nom`='preview' AND `valeur`='1comite' "),
array('spip_query', "UPDATE spip_meta SET `valeur` = ',0minirezo,' WHERE `nom`='preview' AND `valeur`='oui' "),
);
$GLOBALS['maj'][1942] = array(
array('sql_alter', "TABLE spip_auteurs CHANGE `statut` `statut` varchar(255) DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_breves CHANGE `statut` `statut` varchar(6) DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_messages CHANGE `statut` `statut` varchar(6) DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_rubriques CHANGE `statut` `statut` varchar(10) DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_rubriques CHANGE `statut_tmp` `statut_tmp` varchar(10) DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_syndic CHANGE `statut` `statut` varchar(10) DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_syndic_articles CHANGE `statut` `statut` varchar(10) DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_forum CHANGE `statut` `statut` varchar(8) DEFAULT '0' NOT NULL"),
array('sql_alter', "TABLE spip_signatures CHANGE `statut` `statut` varchar(10) DEFAULT '0' NOT NULL")
);
// suppression de l'indexation dans la version standard
$GLOBALS['maj'][1943] = array(
array('sql_alter', "TABLE spip_articles DROP KEY `idx`"),
array('sql_alter', "TABLE spip_articles DROP `idx`"),
array('sql_alter', "TABLE spip_auteurs DROP KEY `idx`"),
array('sql_alter', "TABLE spip_auteurs DROP `idx`"),
array('sql_alter', "TABLE spip_breves DROP KEY `idx`"),
array('sql_alter', "TABLE spip_breves DROP `idx`"),
array('sql_alter', "TABLE spip_mots DROP KEY `idx`"),
array('sql_alter', "TABLE spip_mots DROP `idx`"),
array('sql_alter', "TABLE spip_rubriques DROP KEY `idx`"),
array('sql_alter', "TABLE spip_rubriques DROP `idx`"),
# array('sql_alter', "TABLE spip_documents DROP KEY `idx`"),
array('sql_alter', "TABLE spip_documents DROP `idx`"),
array('sql_alter', "TABLE spip_syndic DROP KEY `idx`"),
array('sql_alter', "TABLE spip_syndic DROP `idx`"),
array('sql_alter', "TABLE spip_forum DROP KEY `idx`"),
array('sql_alter', "TABLE spip_forum DROP `idx`"),
array('sql_alter', "TABLE spip_signatures DROP KEY `idx`"),
array('sql_alter', "TABLE spip_signatures DROP `idx`"),
array('spip_query', "DROP TABLE spip_index"),
array('spip_query', "DROP TABLE spip_index_dico"),
);
$GLOBALS['maj'][1944] = array(
array('sql_alter', "TABLE spip_documents CHANGE `taille` `taille` integer"),
array('sql_alter', "TABLE spip_documents CHANGE `largeur` `largeur` integer"),
array('sql_alter', "TABLE spip_documents CHANGE `hauteur` `hauteur` integer")
);
$GLOBALS['maj'][1945] = array(
array('sql_alter', "TABLE spip_petitions CHANGE `email_unique` `email_unique` CHAR (3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_petitions CHANGE `site_obli` `site_obli` CHAR (3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_petitions CHANGE `site_unique` `site_unique` CHAR (3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_petitions CHANGE `message` `message` CHAR (3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_petitions CHANGE `texte` `texte` LONGTEXT DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `surtitre` `surtitre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `soustitre` `soustitre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `descriptif` `descriptif` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `chapo` `chapo` mediumtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `texte` `texte` longtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `ps` `ps` mediumtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `accepter_forum` `accepter_forum` CHAR(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `nom_site` `nom_site` tinytext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `url_site` `url_site` VARCHAR(255) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_articles CHANGE `url_propre` `url_propre` VARCHAR(255) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `nom` `nom` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `bio` `bio` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `email` `email` tinytext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `nom_site` `nom_site` tinytext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `url_site` `url_site` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `pass` `pass` tinytext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `low_sec` `low_sec` tinytext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `pgp` `pgp` TEXT DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_auteurs CHANGE `htpass` `htpass` tinytext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_breves CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_breves CHANGE `texte` `texte` longtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_breves CHANGE `lien_titre` `lien_titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_breves CHANGE `lien_url` `lien_url` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_messages CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_messages CHANGE `texte` `texte` longtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_messages CHANGE `type` `type` varchar(6) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_messages CHANGE `rv` `rv` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_mots CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_mots CHANGE `descriptif` `descriptif` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_mots CHANGE `texte` `texte` longtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_mots CHANGE `type` `type` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_mots CHANGE `url_propre` `url_propre` VARCHAR(255) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `descriptif` `descriptif` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `texte` `texte` longtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `unseul` `unseul` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `obligatoire` `obligatoire` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `articles` `articles` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `breves` `breves` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `rubriques` `rubriques` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `syndic` `syndic` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `minirezo` `minirezo` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `comite` `comite` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_groupes_mots CHANGE `forum` `forum` varchar(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_rubriques CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_rubriques CHANGE `descriptif` `descriptif` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_rubriques CHANGE `texte` `texte` longtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_rubriques CHANGE `url_propre` `url_propre` VARCHAR(255) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_documents CHANGE `extension` `extension` VARCHAR(10) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_documents CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_documents CHANGE `date` `date` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"),
array('sql_alter', "TABLE spip_documents CHANGE `descriptif` `descriptif` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_documents CHANGE `fichier` `fichier` varchar(255) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_types_documents CHANGE `extension` `extension` varchar(10) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_types_documents CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_types_documents CHANGE `descriptif` `descriptif` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_types_documents CHANGE `mime_type` `mime_type` varchar(100) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic CHANGE `nom_site` `nom_site` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic CHANGE `url_site` `url_site` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic CHANGE `url_syndic` `url_syndic` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic CHANGE `descriptif` `descriptif` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic CHANGE `url_propre` `url_propre` VARCHAR(255) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic CHANGE `syndication` `syndication` VARCHAR(3) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic_articles CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic_articles CHANGE `url` `url` VARCHAR(255) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic_articles CHANGE `lesauteurs` `lesauteurs` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_syndic_articles CHANGE `descriptif` `descriptif` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_forum CHANGE `titre` `titre` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_forum CHANGE `texte` `texte` mediumtext DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_forum CHANGE `auteur` `auteur` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_forum CHANGE `email_auteur` `email_auteur` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_forum CHANGE `nom_site` `nom_site` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_forum CHANGE `url_site` `url_site` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_forum CHANGE `ip` `ip` varchar(16) DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_signatures CHANGE `nom_email` `nom_email` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_signatures CHANGE `ad_email` `ad_email` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_signatures CHANGE `nom_site` `nom_site` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_signatures CHANGE `url_site` `url_site` text DEFAULT '' NOT NULL"),
array('sql_alter', "TABLE spip_signatures CHANGE `message` `message` mediumtext DEFAULT '' NOT NULL")
);
$GLOBALS['maj'][1946] = array(
array('sql_alter', "TABLE spip_forum DROP INDEX `id_parent`"),
array('sql_alter', "TABLE spip_forum DROP INDEX `id_article`"),
array('sql_alter', "TABLE spip_forum DROP INDEX `id_breve`"),
array('sql_alter', "TABLE spip_forum DROP INDEX `id_syndic`"),
array('sql_alter', "TABLE spip_forum DROP INDEX `id_rubrique`"),
array('sql_alter', "TABLE spip_forum DROP INDEX `date_thread`"),
array('sql_alter', "TABLE spip_forum DROP INDEX `statut`"),
array('sql_alter', "TABLE spip_forum ADD INDEX `optimal` (`statut`,`id_parent`,`id_article`,`date_heure`,`id_breve`,`id_syndic`,`id_rubrique`)")
);
$GLOBALS['maj'][1947] = array(
array('sql_alter', "TABLE spip_articles DROP INDEX `url_site`"),
array('sql_alter', "TABLE spip_articles DROP INDEX `date_modif`"),
array('sql_alter', "TABLE spip_auteurs DROP INDEX `lang`")
);
// mauvaise manip
$GLOBALS['maj'][1949] = array(
array('sql_alter', "TABLE spip_versions DROP INDEX `date`"),
array('sql_alter', "TABLE spip_versions DROP INDEX `id_auteur`")
);
function maj_1_950($installee) {
// oubli de gerer le prefixe lors l'introduction de l'abstraction
// => Relancer les MAJ concernees si la version dont on part les avait fait
if ($installee >= 1.946) serie_alter('950a', $GLOBALS['maj'][1946]);
if ($installee >= 1.947) serie_alter('950b', $GLOBALS['maj'][1947]);
if ($installee >= 1.949) @serie_alter('950c', $GLOBALS['maj'][1949]);
global $tables_auxiliaires;
include_spip('base/auxiliaires');
$v = $tables_auxiliaires[$k='spip_urls'];
sql_create($k, $v['field'], $v['key'], false, false);
foreach(array('article'=>'id_article',
'rubrique'=>'id_rubrique',
'breve'=>'id_breve',
'auteur' => 'id_auteur',
'mot' => 'id_mot',
'syndic' => 'id_syndic') as $type => $id_objet){
$table = ($type == 'syndic') ? $type : ($type ."s");
$date = ($type == 'breve') ? 'date_heure' :
(($type == 'auteur') ? 'maj' :
(($type == 'mot') ? 'maj' : 'date'));
$q = @sql_select("url_propre AS url, $id_objet AS id_objet, '$type' AS type, $date as date", "spip_$table", "url_propre<>''");
if (!$q) return; // anormal, mais ne pas boucler en erreur
while ($r = sql_fetch($q)) sql_replace('spip_urls', $r);
spip_log("table $table : " . sql_count($q) . " urls propres copiees");
sql_alter("TABLE spip_$table DROP INDEX `url_propre`");
sql_alter("TABLE spip_$table DROP `url_propre`");
}
}
// Donner a la fonction ci-dessus le numero de version installee
// AVANT que la mise a jour ait commencee
$GLOBALS['maj'][1950] = array(array('maj_1_950', $GLOBALS['meta']['version_installee'] ));
// Erreur dans maj_1_948():
// // http://trac.rezo.net/trac/spip/changeset/10194
// // Gestion du verrou SQL par PHP
$GLOBALS['maj'][1951] = array(
array('sql_alter', "TABLE spip_versions CHANGE `id_version` `id_version` bigint(21) DEFAULT 0 NOT NULL")
);
// Transformation des documents :
// - image => mode=image
// - vignette => mode=vignette
function maj_1_952() {
$ok = sql_alter("TABLE spip_documents CHANGE `mode` `mode` enum('vignette','image','document') DEFAULT NULL");
if($ok) {
$s = sql_select("v.id_document as id_document", "spip_documents as d join spip_documents as v ON d.id_vignette=v.id_document");
$vignettes = array();
while ($t = sql_fetch($s))
$vignettes[] = intval($t['id_document']);
$ok &= spip_query("UPDATE spip_documents SET `mode`='image' WHERE `mode`='vignette'");
$ok &= spip_query("UPDATE spip_documents SET `mode`='vignette' WHERE `mode`='image' AND ".sql_in('id_document', $vignettes));
}
if (!$ok) die('echec sur maj_1_952()');
}
$GLOBALS['maj'][1952] = array(array('maj_1_952'));
$GLOBALS['maj'][1953] = array(array('upgrade_types_documents'));
$GLOBALS['maj'][1954] = array(
//pas de psd en ![]()
array('spip_query', "UPDATE spip_types_documents SET `inclus`='non' WHERE `extension`='psd'"),
//ajout csv
array('spip_query', "INSERT IGNORE INTO spip_types_documents (`extension`, `titre`) VALUES ('csv', 'CSV')"),
array('spip_query', "UPDATE spip_types_documents SET `mime_type`='text/csv' WHERE `extension`='csv'"),
//ajout mkv
array('spip_query', "INSERT IGNORE INTO spip_types_documents (`extension`, `titre`, `inclus`) VALUES ('mkv', 'Matroska Video', 'embed')"),
array('spip_query', "UPDATE spip_types_documents SET `mime_type`='video/x-mkv' WHERE `extension`='mkv'"),
//ajout mka
array('spip_query', "INSERT IGNORE INTO spip_types_documents (`extension`, `titre`, `inclus`) VALUES ('mka', 'Matroska Audio', 'embed')"),
array('spip_query', "UPDATE spip_types_documents SET `mime_type`='audio/x-mka' WHERE `extension`='mka'"),
//ajout kml
array('spip_query', "INSERT IGNORE INTO spip_types_documents (`extension`, `titre`) VALUES ('kml', 'Keyhole Markup Language')"),
array('spip_query', "UPDATE spip_types_documents SET `mime_type`='application/vnd.google-earth.kml+xml' WHERE `extension`='kml'"),
//ajout kmz
array('spip_query', "INSERT IGNORE INTO spip_types_documents (`extension`, `titre`) VALUES ('kmz', 'Google Earth Placemark File')"),
array('spip_query', "UPDATE spip_types_documents SET `mime_type`='application/vnd.google-earth.kmz' WHERE `extension`='kmz'")
);
if ($GLOBALS['meta']['version_installee'] > 1.950)
// 1.950 lisait un bug dans auxiliaires.php corrige a present
$GLOBALS['maj'][1955] = array(
array('sql_alter', "TABLE spip_urls CHANGE `maj` date DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL")
);
// la mise a jour vers 1.938 contient une erreur
// il faut supprimer l'autoincrement avant de supprimer la PRIMARY KEY
$GLOBALS['maj'][1938] = array(
# creer un champ plus informatif, et son index
array('sql_alter', "TABLE spip_documents ADD `extension` VARCHAR(10) DEFAULT '' NOT NULL "),
# recopier l'ancien champ dans le nouveau
array('maj_1_938'),
# supprimer l'ancien champ et son index
array('sql_alter', "TABLE spip_documents DROP INDEX `id_type`, DROP `id_type`"),
## supprimer l'autoincrement avant de supprimer la PRIMARY KEY
array('sql_alter', "TABLE spip_types_documents CHANGE `id_type` `id_type` BIGINT( 21 ) NOT NULL ") ,
# le champ id_type devient superflu
array('sql_alter', "TABLE spip_types_documents DROP `id_type`"),
array('sql_alter', "TABLE spip_types_documents ADD PRIMARY KEY (`extension`)")
);
// PG veut une valeur par defaut a l'insertion
// http://trac.rezo.net/trac/spip/changeset/10482
$GLOBALS['maj'][1957] = array(
array('sql_alter', "TABLE spip_mots CHANGE `id_groupe` `id_groupe` bigint(21) DEFAULT 0 NOT NULL"),
array('sql_alter', "TABLE spip_documents CHANGE `mode` `mode` ENUM('vignette', 'image', 'document') DEFAULT 'document' NOT NULL")
);
// Ce champ est inutile et provoque une erreur a l'insertion qui l'oublie
$GLOBALS['maj'][1958] = array(
array('sql_alter', "TABLE spip_referers_articles DROP date")
);
?>
v019_pre193.php 0000666 00000034236 15145326552 0007103 0 ustar 00 id_table
$liste_tables = array();
$liste_tables[1]='spip_articles';
$liste_tables[2]='spip_auteurs';
$liste_tables[3]='spip_breves';
$liste_tables[4]='spip_documents';
$liste_tables[5]='spip_forum';
$liste_tables[6]='spip_mots';
$liste_tables[7]='spip_rubriques';
$liste_tables[8]='spip_signatures';
$liste_tables[9]='spip_syndic';
ecrire_meta('index_table', serialize($liste_tables));
## devenu inutile car suppression totale de l'indexation
/*
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_article` as id_objet,'1' as id_table FROM spip_index_articles");
spip_query("DROP TABLE IF EXISTS spip_index_articles");
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_auteur` as id_objet,'2' as id_table FROM spip_index_auteurs");
spip_query("DROP TABLE IF EXISTS spip_index_auteurs");
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_breve` as id_objet,'3' as id_table FROM spip_index_breves");
spip_query("DROP TABLE IF EXISTS spip_index_breves");
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_document` as id_objet,'4' as id_table FROM spip_index_documents");
spip_query("DROP TABLE IF EXISTS spip_index_documents");
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_forum` as id_objet,'5' as id_table FROM spip_index_forum");
spip_query("DROP TABLE IF EXISTS spip_index_forum");
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_mot` as id_objet,'6' as id_table FROM spip_index_mots");
spip_query("DROP TABLE IF EXISTS spip_index_mots");
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_rubrique` as id_objet,'7' as id_table FROM spip_index_rubriques");
spip_query("DROP TABLE IF EXISTS spip_index_rubriques");
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_signature` as id_objet,'8' as id_table FROM spip_index_signatures");
spip_query("DROP TABLE IF EXISTS spip_index_signatures");
spip_query("INSERT INTO spip_index (`hash`,`points`,`id_objet`,`id_table`) SELECT `hash`,`points`,`id_syndic` as id_objet,'9' as `id_table FROM spip_index_syndic");
spip_query("DROP TABLE IF EXISTS spip_index_syndic");
*/
maj_version(1.905);
}
// cette table est desormais geree par le plugin "podcast_client", on la
// supprime si le plugin n'est pas active ; risque inherent a l'utilisation
// de versions alpha :-)
if (upgrade_vers(1.906, $version_installee, $version_cible)) {
if (!@in_array('podcast_client', $GLOBALS['plugins'])) {
spip_query("DROP TABLE spip_documents_syndic");
}
maj_version(1.906);
}
if (upgrade_vers(1.907, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_forum ADD INDEX `idx` (`idx`)");
maj_version(1.907);
}
// Oups ! on stockait les tags de syndication sous la forme rel="category"
// au lieu de rel="directory" - http://microformats.org/wiki/rel-directory
if (upgrade_vers(1.908, $version_installee, $version_cible)) {
spip_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)) {
spip_query("ALTER IGNORE TABLE spip_mots_articles ADD PRIMARY KEY (`id_article`, `id_mot`)");
spip_query("ALTER IGNORE TABLE spip_mots_breves ADD PRIMARY KEY (`id_breve`, `id_mot`)");
spip_query("ALTER IGNORE TABLE spip_mots_rubriques ADD PRIMARY KEY (`id_rubrique`, `id_mot`)");
spip_query("ALTER IGNORE TABLE spip_mots_syndic ADD PRIMARY KEY (`id_syndic`, `id_mot`)");
spip_query("ALTER IGNORE TABLE spip_mots_documents ADD PRIMARY KEY (`id_document`, `id_mot`)");
spip_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)) {
spip_query("ALTER IGNORE TABLE spip_auteurs_articles ADD PRIMARY KEY (`id_auteur`, `id_article`)");
spip_query("ALTER IGNORE TABLE spip_auteurs_rubriques ADD PRIMARY KEY (`id_auteur`, `id_rubrique`)");
spip_query("ALTER IGNORE TABLE spip_auteurs_messages ADD PRIMARY KEY (`id_auteur`, `id_message`)");
maj_version(1.910);
}
if (upgrade_vers(1.911, $version_installee, $version_cible)) {
spip_query("ALTER IGNORE TABLE spip_auteurs_articles DROP INDEX `id_auteur`");
spip_query("ALTER IGNORE TABLE spip_auteurs_rubriques DROP INDEX `id_auteur`");
spip_query("ALTER IGNORE TABLE spip_auteurs_messages DROP INDEX `id_auteur`");
spip_query("ALTER IGNORE TABLE spip_mots_articles DROP INDEX `id_article`");
spip_query("ALTER IGNORE TABLE spip_mots_breves DROP INDEX `id_breve`");
spip_query("ALTER IGNORE TABLE spip_mots_rubriques DROP INDEX `id_rubrique`");
spip_query("ALTER IGNORE TABLE spip_mots_syndic DROP INDEX `id_syndic`");
spip_query("ALTER IGNORE TABLE spip_mots_forum DROP INDEX `id_forum`");
spip_query("ALTER IGNORE TABLE spip_mots_documents DROP INDEX `id_document`");
# 18 juillet 2007: table depreciee
# spip_query("ALTER IGNORE TABLE spip_caches DROP INDEX fichier");
maj_version(1.911);
}
// Le logo du site n'est plus le logo par defaut des rubriques
// mais pour assurer la compatibilite ascendante, on le duplique
if (upgrade_vers(1.912, $version_installee, $version_cible)) {
@copy(_DIR_LOGOS.'rubon0.gif', _DIR_LOGOS.'siteon0.gif');
@copy(_DIR_LOGOS.'ruboff0.gif', _DIR_LOGOS.'siteoff0.gif');
@copy(_DIR_LOGOS.'rubon0.jpg', _DIR_LOGOS.'siteon0.jpg');
@copy(_DIR_LOGOS.'ruboff0.jpg', _DIR_LOGOS.'siteoff0.jpg');
@copy(_DIR_LOGOS.'rubon0.png', _DIR_LOGOS.'siteon0.png');
@copy(_DIR_LOGOS.'ruboff0.png', _DIR_LOGOS.'siteoff0.png');
maj_version(1.912);
}
// suppression de auteur_modif qui n'est plus utilise nulle part
if (upgrade_vers(1.913, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_articles DROP `auteur_modif`");
maj_version(1.913);
}
// Ajout de SVG
if (upgrade_vers(1.914, $version_installee, $version_cible)) {
spip_query("INSERT IGNORE INTO spip_types_documents (`extension`, `titre`, `inclus`) VALUES ('svg', 'Scalable Vector Graphics', 'embed')");
spip_query("UPDATE spip_types_documents SET `mime_type`='image/svg+xml' WHERE `extension`='svg'");
maj_version(1.914);
}
// Ajout de plein de type mime
if (upgrade_vers(1.915, $version_installee, $version_cible)) {
maj_version(1.915);
}
// refaire l'upgrade 1.905 qui a pu foirer en partie a cause de la requete ALTER sur spip_meta
if (upgrade_vers(1.916, $version_installee, $version_cible)) {
// agrandir le champ "valeur" de spip_meta pour pouvoir y stocker
// des choses plus sympa
spip_query("ALTER TABLE spip_meta DROP INDEX `valeur`");
spip_query("ALTER TABLE spip_meta CHANGE `valeur` `valeur` TEXT");
#8/08/07 plus d'indexation dans le core
//include_spip('inc/indexation');
//update_index_tables();
maj_version(1.916);
}
if (upgrade_vers(1.917, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_documents DROP `inclus`");
maj_version(1.917);
}
// Permettre d'enregistrer un numero IP dans les revisions d'articles
// a la place de l'id_auteur
if (upgrade_vers(1.918, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_versions CHANGE `id_auteur` `id_auteur` VARCHAR(23)");
maj_version(1.918);
}
if (upgrade_vers(1.919, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_ajax_fonc DROP `id_auteur`");
maj_version('1.919');
}
if (upgrade_vers(1.920, $version_installee, $version_cible)) {
spip_query("ALTER IGNORE TABLE spip_documents_articles ADD PRIMARY KEY (`id_article`, `id_document`)");
spip_query("ALTER IGNORE TABLE spip_documents_breves ADD PRIMARY KEY (`id_breve`, `id_document`)");
spip_query("ALTER IGNORE TABLE spip_documents_rubriques ADD PRIMARY KEY (`id_rubrique`, `id_document`)");
spip_query("ALTER IGNORE TABLE spip_documents_articles DROP INDEX `id_article`");
spip_query("ALTER IGNORE TABLE spip_documents_breves DROP INDEX `id_breve`");
spip_query("ALTER IGNORE TABLE spip_documents_rubriques DROP INDEX `id_rubrique`");
maj_version('1.920');
}
if (upgrade_vers(1.922, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_meta ADD `impt` ENUM('non', 'oui') DEFAULT 'oui' NOT NULL AFTER `valeur`");
$meta_serveur = array('version_installee','adresse_site','alea_ephemere_ancien','alea_ephemere','alea_ephemere_date','langue_site','langues_proposees','date_calcul_rubriques','derniere_modif','optimiser_table','drapeau_edition','creer_preview','taille_preview','creer_htpasswd','creer_htaccess','gd_formats_read','gd_formats',
'netpbm_formats','formats_graphiques','image_process','plugin_header','plugin');
foreach($meta_serveur as $nom)
spip_query("UPDATE spip_meta SET `impt`='non' WHERE `nom`="._q($nom));
maj_version('1.922');
}
if (upgrade_vers(1.923, $version_installee, $version_cible)) {
if (isset($GLOBALS['meta']['IMPORT_tables_noimport'])){
$IMPORT_tables_noimport = unserialize($GLOBALS['meta']['IMPORT_tables_noimport']);
foreach ($IMPORT_tables_noimport as $key=>$table)
if ($table=='spip_meta') unset($IMPORT_tables_noimport[$key]);
ecrire_meta('IMPORT_tables_noimport',serialize($IMPORT_tables_noimport),'non');
}
maj_version('1.923');
}
if (upgrade_vers(1.924, $version_installee, $version_cible)) {
spip_query('DROP TABLE spip_ajax_fonc');
maj_version('1.924');
}
if (upgrade_vers(1.925, $version_installee, $version_cible)) {
include_spip('inc/flock');
/* deplacement des sessions */
$f_session = preg_files('data', 'session_');
$repertoire = _DIR_SESSIONS;
if(!@file_exists($repertoire)) {
$repertoire = preg_replace(','._DIR_TMP.',', '', $repertoire);
$repertoire = sous_repertoire(_DIR_TMP, $repertoire);
}
foreach($f_session as $f) {
$d = basename($f);
@copy($f, $repertoire.$d);
}
/* deplacement des visites */
$f_visites = preg_files('data/visites');
$repertoire = sous_repertoire(_DIR_TMP, 'visites');
foreach($f_visites as $f) {
$d = basename($f);
@copy($f, $repertoire.$d);
}
/* deplacement des upload */
$auteurs = array();
$req = spip_query("SELECT `login` FROM spip_auteurs WHERE `statut` = '0minirezo'");
while($row = sql_fetch($req))
$auteurs[] = $row['login'];
$f_upload = preg_files('upload', -1, 10000, $auteurs);
$repertoire = _DIR_TRANSFERT;
if(!@file_exists($repertoire)) {
$repertoire = preg_replace(','._DIR_TMP.',', '', $repertoire);
$repertoire = sous_repertoire(_DIR_TMP, $repertoire);
}
foreach($auteurs as $login) {
if(is_dir('upload/'.$login))
$sous_repertoire = sous_repertoire(_DIR_TRANSFERT, $login);
}
foreach($f_upload as $f) {
@copy($f, _DIR_TMP.$f);
}
/* deplacement des dumps */
$f_session = preg_files('data', 'dump');
$repertoire = _DIR_DUMP;
if(!@file_exists($repertoire)) {
$repertoire = preg_replace(','._DIR_TMP.',', '', $repertoire);
$repertoire = sous_repertoire(_DIR_TMP, $repertoire);
}
foreach($f_session as $f) {
$d = basename($f);
@copy($f, $repertoire.$d);
}
maj_version('1.925');
}
// Ajout de MP4
if (upgrade_vers(1.926, $version_installee, $version_cible)) {
spip_query("INSERT IGNORE INTO spip_types_documents (`extension`, `titre`, `inclus`) VALUES ('mp4', 'MPEG4', 'embed')");
spip_query("UPDATE spip_types_documents SET `mime_type`='application/mp4' WHERE `extension`='mp4'");
maj_version('1.926');
}
}
?>
svn10000.php 0000666 00000024613 15145326552 0006466 0 ustar 00 $r['type']), 'id_mot='.sql_quote($r['id_mot']));
}
}
}
$GLOBALS['maj'][11431] = array(array('maj_11431'));
// reparer spip_types_documents.id_type
// qui est parfois encore present
function maj_11778 () {
// si presence id_type
$s = sql_showtable('spip_types_documents');
if (isset($s['field']['id_type'])) {
sql_alter('TABLE spip_types_documents CHANGE id_type id_type BIGINT(21) NOT NULL');
sql_alter('TABLE spip_types_documents DROP id_type');
sql_alter('TABLE spip_types_documents ADD PRIMARY KEY (extension)');
}
}
$GLOBALS['maj'][11778] = array(array('maj_11778'));
// Optimisation des forums
function maj_11790 () {
# sql_alter('TABLE spip_forum DROP INDEX id_message id_message');
sql_alter('TABLE spip_forum ADD INDEX id_parent (id_parent)');
sql_alter('TABLE spip_forum ADD INDEX id_auteur (id_auteur)');
sql_alter('TABLE spip_forum ADD INDEX id_thread (id_thread)');
}
$GLOBALS['maj'][11790] = array(array('maj_11790'));
$GLOBALS['maj'][11794] = array(); // ajout de spip_documents_forum
$GLOBALS['maj'][11961] = array(
array('sql_alter',"TABLE spip_groupes_mots CHANGE `tables` tables_liees text DEFAULT '' NOT NULL AFTER obligatoire"), // si tables a ete cree on le renomme
array('sql_alter',"TABLE spip_groupes_mots ADD tables_liees text DEFAULT '' NOT NULL AFTER obligatoire"), // sinon on l'ajoute
array('sql_update','spip_groupes_mots',array('tables_liees'=>"''"),"articles REGEXP '.*'"), // si le champ articles est encore la, on reinit la conversion
array('sql_update','spip_groupes_mots',array('tables_liees'=>"concat(tables_liees,'articles,')"),"articles='oui'"), // sinon ces 4 requetes ne feront rien
array('sql_update','spip_groupes_mots',array('tables_liees'=>"concat(tables_liees,'breves,')"),"breves='oui'"),
array('sql_update','spip_groupes_mots',array('tables_liees'=>"concat(tables_liees,'rubriques,')"),"rubriques='oui'"),
array('sql_update','spip_groupes_mots',array('tables_liees'=>"concat(tables_liees,'syndic,')"),"syndic='oui'"),
);
// Reunir en une seule table les liens de documents
// spip_documents_articles et spip_documents_forum
function maj_12008 () {
// Creer spip_documents_liens
global $tables_auxiliaires;
include_spip('base/auxiliaires');
$v = $tables_auxiliaires[$k='spip_documents_liens'];
sql_create($k, $v['field'], $v['key'], false, false);
// Recopier les donnees
foreach (array('article', 'breve', 'rubrique', 'auteur', 'forum') as $l) {
if ($s = sql_select('*', 'spip_documents_'.$l.'s')
OR $s = sql_select('*', 'spip_documents_'.$l)) {
$tampon = array();
while ($t = sql_fetch($s)) {
// transformer id_xx=N en (id_objet=N, objet=xx)
$t['id_objet'] = $t["id_$l"];
$t['objet'] = $l;
unset($t["id_$l"]);
unset($t['maj']);
$tampon[] = $t;
if (count($tampon)>10000) {
sql_insertq_multi('spip_documents_liens',$tampon);
$tampon = array();
}
}
if (count($tampon)) {
sql_insertq_multi('spip_documents_liens', $tampon);
}
}
}
}
$GLOBALS['maj'][12008] = array(
//array('sql_drop_table',"spip_documents_liens"), // tant pis pour ceux qui ont joue a 11974
array('sql_alter',"TABLE spip_documents_liens DROP PRIMARY KEY"),
array('sql_alter',"TABLE spip_documents_liens ADD id_objet bigint(21) DEFAULT '0' NOT NULL AFTER id_document"),
array('sql_alter',"TABLE spip_documents_liens ADD objet VARCHAR (25) DEFAULT '' NOT NULL AFTER id_objet"),
array('sql_update','spip_documents_liens',array('id_objet'=>"id_article",'objet'=>"'article'"),"id_article IS NOT NULL AND id_article>0"),
array('sql_update','spip_documents_liens',array('id_objet'=>"id_rubrique",'objet'=>"'rubrique'"),"id_rubrique IS NOT NULL AND id_rubrique>0"),
array('sql_update','spip_documents_liens',array('id_objet'=>"id_breve",'objet'=>"'breve'"),"id_breve IS NOT NULL AND id_breve>0"),
array('sql_update','spip_documents_liens',array('id_objet'=>"id_auteur",'objet'=>"'auteur'"),"id_auteur IS NOT NULL AND id_auteur>0"),
array('sql_update','spip_documents_liens',array('id_objet'=>"id_forum",'objet'=>"'forum'"),"id_forum IS NOT NULL AND id_forum>0"),
array('sql_alter',"TABLE spip_documents_liens ADD PRIMARY KEY (id_document,id_objet,objet)"),
array('sql_alter',"TABLE spip_documents_liens DROP id_article"),
array('sql_alter',"TABLE spip_documents_liens DROP id_rubrique"),
array('sql_alter',"TABLE spip_documents_liens DROP id_breve"),
array('sql_alter',"TABLE spip_documents_liens DROP id_auteur"),
array('sql_alter',"TABLE spip_documents_liens DROP id_forum"),
array('maj_12008'),
);
// destruction des tables spip_documents_articles etc, cf. 12008
$GLOBALS['maj'][12009] = array(
array('sql_drop_table',"spip_documents_articles"),
array('sql_drop_table',"spip_documents_breves"),
array('sql_drop_table',"spip_documents_rubriques"),
array('sql_drop_table',"spip_documents_auteurs"), # plugin #FORMULAIRE_UPLOAD
array('sql_drop_table',"spip_documents_syndic") # plugin podcast_client
);
// destruction des champs articles breves rubriques et syndic, cf. 11961
$GLOBALS['maj'][12010] = array(
array('sql_alter',"TABLE spip_groupes_mots DROP articles"),
array('sql_alter',"TABLE spip_groupes_mots DROP breves"),
array('sql_alter',"TABLE spip_groupes_mots DROP rubriques"),
array('sql_alter',"TABLE spip_groupes_mots DROP syndic"),
);
function maj_13135 () {
include_spip('inc/rubriques');
calculer_prochain_postdate();
// supprimer les eventuels vieux cache plugin qui n'utilisaient pas _chemin
@spip_unlink(_CACHE_PLUGINS_OPT);
@spip_unlink(_CACHE_PLUGINS_FCT);
@spip_unlink(_CACHE_PLUGINS_VERIF);
}
$GLOBALS['maj'][13135] = array(array('maj_13135'));
// Type flac: http://flac.sourceforge.net
$GLOBALS['maj'][13333] = array(array('upgrade_types_documents'));
// http://archives.rezo.net/spip-zone.mbox/200903.mbox/%3Cbfc33ad70903141606q2e4c53f2k4fef6b45e611a04f@mail.gmail.com%3E
$GLOBALS['maj'][13833] = array(
array('sql_alter',"TABLE spip_documents_liens ADD INDEX objet(id_objet,objet)"))
;
// Fin upgrade commun branche 2.0
include_spip('inc/autoriser');
$GLOBALS['maj'][13904] = array(
array('sql_alter',"TABLE spip_auteurs ADD webmestre varchar(3) DEFAULT 'non' NOT NULL"),
array('sql_update','spip_auteurs',array('webmestre'=>"'oui'"),sql_in("id_auteur",defined('_ID_WEBMESTRES')?explode(':',_ID_WEBMESTRES):(autoriser('configurer')?array($GLOBALS['visiteur_session']['id_auteur']):array(0)))) // le webmestre est celui qui fait l'upgrade si rien de defini
)
;
// sites plantes en mode "'su" au lieu de "sus"
$GLOBALS['maj'][13929] = array(
array('sql_update',"spip_syndic",array('syndication'=>"'sus'"),"syndication LIKE '\\'%'")
);
// Types de fichiers m4a/m4b/m4p/m4u/m4v/dv
// Types de fichiers Open XML (cro$oft)
$GLOBALS['maj'][14558] = array(array('upgrade_types_documents'));
// refaire les upgrade dont les numeros sont inferieurs a ceux de la branche 2.0
// etre sur qu'ils sont bien unipotents(?)...
$GLOBALS['maj'][14559] = $GLOBALS['maj'][13904]+$GLOBALS['maj'][13929]+$GLOBALS['maj'][14558];
// Restauration correcte des types mime des fichiers Ogg
// http://trac.rezo.net/trac/spip/ticket/1941
// + Types de fichiers : f4a/f4b/f4p/f4v/mpc http://en.wikipedia.org/wiki/Flv#File_formats
$GLOBALS['maj'][15676] = array(array('upgrade_types_documents'));
// Type de fichiers : webm http://en.wikipedia.org/wiki/Flv#File_formats
$GLOBALS['maj'][15827] = array(array('upgrade_types_documents'));
// IP en 40 caracteres pour IP v6
$GLOBALS['maj'][15828] = array(array('sql_alter',"TABLE spip_forum CHANGE `ip` `ip` VARCHAR(40) DEFAULT '' NOT NULL"));
?>
v009.php 0000666 00000012642 15145326552 0005774 0 ustar 00
v018.php 0000666 00000017273 15145326552 0006001 0 ustar 00 sites et articles syndiques (podcasting)
if (upgrade_vers(1.815, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_documents ADD distant VARCHAR(3) DEFAULT 'non'");
maj_version(1.815);
}
// Indexation des documents (rien a faire sauf reinstaller inc_auxbase)
if (upgrade_vers(1.816, $version_installee, $version_cible)) {
maj_version(1.816);
}
// Texte et descriptif des groupes de mots-cles
if (upgrade_vers(1.817, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_groupes_mots ADD descriptif text NOT NULL AFTER titre");
spip_query("ALTER TABLE spip_groupes_mots ADD COLUMN texte longblob NOT NULL AFTER descriptif");
maj_version(1.817);
}
// Conformite des noms de certains champs (0minirezo => minirezo)
if (upgrade_vers(1.818, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 0minirezo minirezo char(3) NOT NULL");
spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 1comite comite char(3) NOT NULL");
spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 6forum forum char(3) NOT NULL");
maj_version(1.818);
}
// Options de syndication : miroir + oubli
if (upgrade_vers(1.819, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_syndic ADD miroir VARCHAR(3) DEFAULT 'non'");
spip_query("ALTER TABLE spip_syndic ADD oubli VARCHAR(3) DEFAULT 'non'");
maj_version(1.819);
}
// Un bug dans les 1.730 (il manquait le "ADD")
if (upgrade_vers(1.820, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_articles ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_auteurs ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_breves ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_mots ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_rubriques ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_syndic ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_forum ADD INDEX idx (idx)");
spip_query("ALTER TABLE spip_signatures ADD INDEX idx (idx)");
maj_version(1.820);
}
// reindexer les articles (on avait oublie les auteurs)
if (upgrade_vers(1.821, $version_installee, $version_cible)) {
spip_query("UPDATE spip_articles SET idx='1' WHERE idx='oui'");
maj_version(1.821);
}
// le 'type' des mots doit etre du texte, sinon on depasse en champ multi
if (upgrade_vers(1.822, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_mots DROP INDEX type");
spip_query("ALTER TABLE spip_mots CHANGE type type TEXT NOT NULL");
maj_version(1.822);
}
// ajouter une table de fonctions pour ajax
if (upgrade_vers(1.825, $version_installee, $version_cible)) {
maj_version(1.825);
}
if (upgrade_vers(1.826, $version_installee, $version_cible)) {
spip_query("ALTER TABLE spip_ajax_fonc DROP fonction");
maj_version(1.826);
}
}
?>
v016.php 0000666 00000003752 15145326552 0005774 0 ustar 00
v011.php 0000666 00000001750 15145326552 0005763 0 ustar 00
v012.php 0000666 00000007610 15145326552 0005765 0 ustar 00
v015.php 0000666 00000001460 15145326552 0005765 0 ustar 00
vieille_base/charger.php 0000666 00000003634 15145326552 0011335 0 ustar 00 '1813',
'1.821'=>'1821',
'1.915'=>'1915',
'1.917'=>'1917',
'1.927'=>'1927',
'10000'=>'10000',
'12000'=>'13000',
);
$version = false;
foreach($vieilles_bases as $v=>$n){
if (!$version OR spip_version_compare($v,$version_cible,'<'))
$version = $n;
}
/*
include_spip('base/serial');
include_spip('base/auxiliaires');
$GLOBALS['nouvelle_base']['tables_principales'] = $GLOBALS['tables_principales'];
$GLOBALS['nouvelle_base']['tables_auxiliaires'] = $GLOBALS['tables_auxiliaires'];*/
unset($GLOBALS['tables_principales']);
unset($GLOBALS['tables_auxiliaires']);
unset($GLOBALS['tables_images']);
unset($GLOBALS['tables_sequences']);
unset($GLOBALS['tables_documents']);
unset($GLOBALS['tables_mime']);
// chargera les descriptions de table
$create = charger_fonction('create',"maj/vieille_base/$version");
if (!isset($GLOBALS['tables_auxiliaires']['spip_meta']['field']['impt']))
$GLOBALS['tables_auxiliaires']['spip_meta']['field']['impt'] = "ENUM('non', 'oui') DEFAULT 'oui' NOT NULL";
return $version;
}
?>
vieille_base/1917/auxiliaires.php 0000666 00000030367 15145326552 0012645 0 ustar 00 "BIGINT (21) DEFAULT '0' NOT NULL",
"email_unique" => "CHAR (3) NOT NULL",
"site_obli" => "CHAR (3) NOT NULL",
"site_unique" => "CHAR (3) NOT NULL",
"message" => "CHAR (3) NOT NULL",
"texte" => "LONGBLOB NOT NULL",
"maj" => "TIMESTAMP");
$spip_petitions_key = array(
"PRIMARY KEY" => "id_article");
$spip_visites = array(
"date" => "DATE NOT NULL",
"visites" => "INT UNSIGNED NOT NULL",
"maj" => "TIMESTAMP");
$spip_visites_key = array(
"PRIMARY KEY" => "date");
$spip_visites_articles = array(
"date" => "DATE NOT NULL",
"id_article" => "INT UNSIGNED NOT NULL",
"visites" => "INT UNSIGNED NOT NULL",
"maj" => "TIMESTAMP");
$spip_visites_articles_key = array(
"PRIMARY KEY" => "date, id_article");
$spip_referers = array(
"referer_md5" => "BIGINT UNSIGNED NOT NULL",
"date" => "DATE NOT NULL",
"referer" => "VARCHAR (255) NOT NULL",
"visites" => "INT UNSIGNED NOT NULL",
"visites_jour" => "INT UNSIGNED NOT NULL",
"visites_veille"=> "INT UNSIGNED NOT NULL",
"maj" => "TIMESTAMP");
$spip_referers_key = array(
"PRIMARY KEY" => "referer_md5");
$spip_referers_articles = array(
"id_article" => "INT UNSIGNED NOT NULL",
"referer_md5" => "BIGINT UNSIGNED NOT NULL",
"date" => "DATE NOT NULL",
"referer" => "VARCHAR (255) NOT NULL",
"visites" => "INT UNSIGNED NOT NULL",
"maj" => "TIMESTAMP");
$spip_referers_articles_key = array(
"PRIMARY KEY" => "id_article, referer_md5",
"KEY referer_md5" => "referer_md5");
$spip_auteurs_articles = array(
"id_auteur" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_article" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_auteurs_articles_key = array(
"PRIMARY KEY" => "id_auteur, id_article",
"KEY id_article" => "id_article");
$spip_auteurs_rubriques = array(
"id_auteur" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_rubrique" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_auteurs_rubriques_key = array(
"PRIMARY KEY" => "id_auteur, id_rubrique",
"KEY id_rubrique" => "id_rubrique");
$spip_auteurs_messages = array(
"id_auteur" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_message" => "BIGINT (21) DEFAULT '0' NOT NULL",
"vu" => "CHAR (3) NOT NULL");
$spip_auteurs_messages_key = array(
"PRIMARY KEY" => "id_auteur, id_message",
"KEY id_message" => "id_message");
$spip_documents_articles = array(
"id_document" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_article" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_documents_articles_key = array(
"KEY id_document" => "id_document",
"KEY id_article" => "id_article");
$spip_documents_rubriques = array(
"id_document" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_rubrique" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_documents_rubriques_key = array(
"KEY id_document" => "id_document",
"KEY id_rubrique" => "id_rubrique");
$spip_documents_breves = array(
"id_document" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_breve" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_documents_breves_key = array(
"KEY id_document" => "id_document",
"KEY id_breve" => "id_breve");
$spip_mots_articles = array(
"id_mot" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_article" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_mots_articles_key = array(
"PRIMARY KEY" => "id_article, id_mot",
"KEY id_mot" => "id_mot");
$spip_mots_breves = array(
"id_mot" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_breve" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_mots_breves_key = array(
"PRIMARY KEY" => "id_breve, id_mot",
"KEY id_mot" => "id_mot");
$spip_mots_rubriques = array(
"id_mot" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_rubrique" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_mots_rubriques_key = array(
"PRIMARY KEY" => "id_rubrique, id_mot",
"KEY id_mot" => "id_mot");
$spip_mots_syndic = array(
"id_mot" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_syndic" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_mots_syndic_key = array(
"PRIMARY KEY" => "id_syndic, id_mot",
"KEY id_mot" => "id_mot");
$spip_mots_forum = array(
"id_mot" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_forum" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_mots_forum_key = array(
"PRIMARY KEY" => "id_forum, id_mot",
"KEY id_mot" => "id_mot");
$spip_mots_documents = array(
"id_mot" => "BIGINT (21) DEFAULT '0' NOT NULL",
"id_document" => "BIGINT (21) DEFAULT '0' NOT NULL");
$spip_mots_documents_key = array(
"PRIMARY KEY" => "id_document, id_mot",
"KEY id_mot" => "id_mot");
$spip_meta = array(
"nom" => "VARCHAR (255) NOT NULL",
"valeur" => "text DEFAULT ''",
"maj" => "TIMESTAMP");
$spip_meta_key = array(
"PRIMARY KEY" => "nom");
$spip_index = array(
"`hash`" => "BIGINT UNSIGNED NOT NULL",
"points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
"id_objet" => "INT UNSIGNED NOT NULL",
"id_table" => "TINYINT UNSIGNED NOT NULL" );
$spip_index_key = array(
"KEY `hash`" => "`hash`",
"KEY id_objet" => "id_objet",
"KEY id_table" => "id_table");
$spip_index_dico = array(
"`hash`" => "BIGINT UNSIGNED NOT NULL",
"dico" => "VARCHAR (30) NOT NULL");
$spip_index_dico_key = array(
"PRIMARY KEY" => "dico");
$spip_versions = array (
"id_article" => "bigint(21) NOT NULL",
"id_version" => "int unsigned DEFAULT '0' NOT NULL",
"date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
"id_auteur" => "bigint(21) NOT NULL",
"titre_version" => "text DEFAULT '' NOT NULL",
"permanent" => "char(3) NOT NULL",
"champs" => "text NOT NULL");
$spip_versions_key = array (
"PRIMARY KEY" => "id_article, id_version",
"KEY date" => "id_article, date",
"KEY id_auteur" => "id_auteur");
$spip_versions_fragments = array(
"id_fragment" => "int unsigned DEFAULT '0' NOT NULL",
"version_min" => "int unsigned DEFAULT '0' NOT NULL",
"version_max" => "int unsigned DEFAULT '0' NOT NULL",
"id_article" => "bigint(21) NOT NULL",
"compress" => "tinyint NOT NULL",
"fragment" => "longblob NOT NULL");
$spip_versions_fragments_key = array(
"PRIMARY KEY" => "id_article, id_fragment, version_min");
$spip_caches = array(
"fichier" => "char (64) NOT NULL",
"id" => "char (64) NOT NULL",
// i=par id, t=timer, x=suppression
"type" => "CHAR (1) DEFAULT 'i' NOT NULL",
"taille" => "integer DEFAULT '0' NOT NULL");
$spip_caches_key = array(
"PRIMARY KEY" => "fichier, id",
"KEY fichier" => "fichier",
"KEY id" => "id");
$spip_ortho_cache = array(
"lang" => "VARCHAR(10) NOT NULL",
"mot" => "VARCHAR(255) BINARY NOT NULL",
"ok" => "TINYINT NOT NULL",
"suggest" => "BLOB NOT NULL",
"maj" => "TIMESTAMP");
$spip_ortho_cache_key = array(
"PRIMARY KEY" => "lang, mot",
"KEY maj" => "maj");
$spip_ortho_dico = array(
"lang" => "VARCHAR(10) NOT NULL",
"mot" => "VARCHAR(255) BINARY NOT NULL",
"id_auteur" => "BIGINT UNSIGNED NOT NULL",
"maj" => "TIMESTAMP");
$spip_ortho_dico_key = array(
"PRIMARY KEY" => "lang, mot");
global $tables_auxiliaires;
$tables_auxiliaires['spip_petitions'] = array(
'field' => &$spip_petitions,
'key' => &$spip_petitions_key
);
$tables_auxiliaires['spip_visites'] = array(
'field' => &$spip_visites,
'key' => &$spip_visites_key);
$tables_auxiliaires['spip_visites_articles'] = array(
'field' => &$spip_visites_articles,
'key' => &$spip_visites_articles_key);
$tables_auxiliaires['spip_referers'] = array(
'field' => &$spip_referers,
'key' => &$spip_referers_key);
$tables_auxiliaires['spip_referers_articles'] = array(
'field' => &$spip_referers_articles,
'key' => &$spip_referers_articles_key);
$tables_auxiliaires['spip_auteurs_articles'] = array(
'field' => &$spip_auteurs_articles,
'key' => &$spip_auteurs_articles_key);
$tables_auxiliaires['spip_auteurs_rubriques'] = array(
'field' => &$spip_auteurs_rubriques,
'key' => &$spip_auteurs_rubriques_key);
$tables_auxiliaires['spip_auteurs_messages'] = array(
'field' => &$spip_auteurs_messages,
'key' => &$spip_auteurs_messages_key);
$tables_auxiliaires['spip_documents_articles'] = array(
'field' => &$spip_documents_articles,
'key' => &$spip_documents_articles_key);
$tables_auxiliaires['spip_documents_rubriques'] = array(
'field' => &$spip_documents_rubriques,
'key' => &$spip_documents_rubriques_key);
$tables_auxiliaires['spip_documents_breves'] = array(
'field' => &$spip_documents_breves,
'key' => &$spip_documents_breves_key);
$tables_auxiliaires['spip_mots_articles'] = array(
'field' => &$spip_mots_articles,
'key' => &$spip_mots_articles_key);
$tables_auxiliaires['spip_mots_breves'] = array(
'field' => &$spip_mots_breves,
'key' => &$spip_mots_breves_key);
$tables_auxiliaires['spip_mots_rubriques'] = array(
'field' => &$spip_mots_rubriques,
'key' => &$spip_mots_rubriques_key);
$tables_auxiliaires['spip_mots_syndic'] = array(
'field' => &$spip_mots_syndic,
'key' => &$spip_mots_syndic_key);
$tables_auxiliaires['spip_mots_forum'] = array(
'field' => &$spip_mots_forum,
'key' => &$spip_mots_forum_key);
$tables_auxiliaires['spip_mots_documents'] = array(
'field' => &$spip_mots_documents,
'key' => &$spip_mots_documents_key);
$tables_auxiliaires['spip_meta'] = array(
'field' => &$spip_meta,
'key' => &$spip_meta_key);
$tables_auxiliaires['spip_index'] = array(
'field' => &$spip_index,
'key' => &$spip_index_key);
$tables_auxiliaires['spip_index_dico'] = array(
'field' => &$spip_index_dico,
'key' => &$spip_index_dico_key);
$tables_auxiliaires['spip_versions'] = array(
'field' => &$spip_versions,
'key' => &$spip_versions_key);
$tables_auxiliaires['spip_versions_fragments'] = array(
'field' => &$spip_versions_fragments,
'key' => &$spip_versions_fragments_key);
$tables_auxiliaires['spip_caches'] = array(
'field' => &$spip_caches,
'key' => &$spip_caches_key);
$tables_auxiliaires['spip_ortho_cache'] = array(
'field' => &$spip_ortho_cache,
'key' => &$spip_ortho_cache_key);
$tables_auxiliaires['spip_ortho_dico'] = array(
'field' => &$spip_ortho_dico,
'key' => &$spip_ortho_dico_key);
//
// tableau des tables de jointures
// Ex: gestion du critere {id_mot} dans la boucle(ARTICLES)
global $tables_jointures;
$tables_jointures['spip_articles'][]= 'mots_articles';
$tables_jointures['spip_articles'][]= 'auteurs_articles';
$tables_jointures['spip_articles'][]= 'documents_articles';
$tables_jointures['spip_articles'][]= 'mots';
$tables_jointures['spip_articles'][]= 'signatures';
$tables_jointures['spip_auteurs'][]= 'auteurs_articles';
$tables_jointures['spip_auteurs'][]= 'mots';
$tables_jointures['spip_breves'][]= 'mots_breves';
$tables_jointures['spip_breves'][]= 'documents_breves';
$tables_jointures['spip_breves'][]= 'mots';
$tables_jointures['spip_documents'][]= 'documents_articles';
$tables_jointures['spip_documents'][]= 'documents_rubriques';
$tables_jointures['spip_documents'][]= 'documents_breves';
$tables_jointures['spip_documents'][]= 'mots_documents';
$tables_jointures['spip_documents'][]= 'types_documents';
$tables_jointures['spip_documents'][]= 'mots';
$tables_jointures['spip_forum'][]= 'mots_forum';
$tables_jointures['spip_forum'][]= 'mots';
$tables_jointures['spip_rubriques'][]= 'mots_rubriques';
$tables_jointures['spip_rubriques'][]= 'documents_rubriques';
$tables_jointures['spip_rubriques'][]= 'mots';
$tables_jointures['spip_syndic'][]= 'mots_syndic';
$tables_jointures['spip_syndic'][]= 'mots';
$tables_jointures['spip_syndic_articles'][]= 'syndic';
$tables_jointures['spip_syndic_articles'][]= 'mots';
$tables_jointures['spip_mots'][]= 'mots_articles';
$tables_jointures['spip_mots'][]= 'mots_breves';
$tables_jointures['spip_mots'][]= 'mots_forum';
$tables_jointures['spip_mots'][]= 'mots_rubriques';
$tables_jointures['spip_mots'][]= 'mots_syndic';
$tables_jointures['spip_mots'][]= 'mots_documents';
$tables_jointures['spip_groupes_mots'][]= 'mots';
?>
vieille_base/1917/typedoc.php 0000666 00000014222 15145326552 0011765 0 ustar 00 1,
'png' => 2,
'gif' => 3,
// Autres images (peuvent utiliser le tag ![]()
)
'bmp' => 'BMP',
'psd' => 'Photoshop',
'tif' => 'TIFF'
);
// Multimedia (peuvent utiliser le tag