<?php

global 
$spip_articles,
 $spip_auteurs,
 $spip_breves,
 $spip_messages,
 $spip_mots,
 $spip_groupes_mots,
 $spip_rubriques,
 $spip_documents,
 $spip_types_documents,
 $spip_syndic,
 $spip_syndic_articles,
 $spip_forum,
 $spip_petitions,
 $spip_signatures,
 $spip_visites_temp,
 $spip_visites,
 $spip_visites_articles,
 $spip_referers_temp,
 $spip_referers,
 $spip_referers_articles,
 $spip_auteurs_articles,
 $spip_auteurs_rubriques,
 $spip_auteurs_messages,
 $spip_documents_articles,
 $spip_documents_rubriques,
 $spip_documents_breves,
 $spip_mots_articles,
 $spip_mots_breves,
 $spip_mots_rubriques,
 $spip_mots_syndic,
 $spip_mots_forum,
 $spip_forum_cache,
 $spip_meta,
 $spip_index_articles,
 $spip_index_auteurs,
 $spip_index_breves,
 $spip_index_mots,
 $spip_index_rubriques,
 $spip_index_syndic,
 $spip_index_dico ;

$spip_articles = array(
		"id_article" => "bigint(21) NOT NULL auto_increment",
		"surtitre" => "text NOT NULL",
		"titre" => "text NOT NULL",
		"soustitre" => "text NOT NULL",
		"id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
		"descriptif" => "text NOT NULL",
		"chapo" => "mediumtext NOT NULL",
		"texte" => "longblob NOT NULL",
		"ps" => "mediumtext NOT NULL",
		"date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"statut" => "varchar(10) DEFAULT '0' NOT NULL",
		"id_secteur" => "bigint(21) DEFAULT '0' NOT NULL",
		"maj" => "TIMESTAMP",
		"export" => "VARCHAR(10) DEFAULT 'oui'",
		"date_redac" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"visites" => "INTEGER DEFAULT '0' NOT NULL",
		"referers" => "INTEGER DEFAULT '0' NOT NULL",
		"popularite" => "DOUBLE DEFAULT '0' NOT NULL",
		"accepter_forum" => "CHAR(3) NOT NULL",
		"auteur_modif" => "bigint(21) DEFAULT '0' NOT NULL",
		"date_modif" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
		"langue_choisie" => "VARCHAR(3) DEFAULT 'non'",
		"id_trad" => "bigint(21) DEFAULT '0' NOT NULL",
		"extra" => "longblob NULL",
		"PRIMARY KEY" => "(id_article)",
		"KEY id_rubrique" => "(id_rubrique)",
		"KEY id_secteur" => "(id_secteur)",
		"KEY id_trad" => "(id_trad)",
		"KEY lang" => "(lang)",
		"KEY statut" => "(statut, date)",
		"KEY date_modif" => "(date_modif)");

$spip_auteurs = array(
		"id_auteur" => "bigint(21) NOT NULL auto_increment",
		"nom" => "text NOT NULL",
		"bio" => "text NOT NULL",
		"email" => "tinytext NOT NULL",
		"nom_site" => "tinytext NOT NULL",
		"url_site" => "text NOT NULL",
		"login" => "VARCHAR(255) BINARY NOT NULL",
		"pass" => "tinytext NOT NULL",
		"statut" => "VARCHAR(255) NOT NULL",
		"maj" => "TIMESTAMP",
		"pgp" => "BLOB NOT NULL",
		"htpass" => "tinyblob NOT NULL",
		"en_ligne" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"imessage" => "VARCHAR(3) NOT NULL",
		"messagerie" => "VARCHAR(3) NOT NULL",
		"alea_actuel" => "tinytext NOT NULL",
		"alea_futur" => "tinytext NOT NULL",
		"prefs" => "tinytext NOT NULL",
		"cookie_oubli" => "tinytext NOT NULL",
		"source" => "VARCHAR(10) DEFAULT 'spip' NOT NULL",
		"lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
		"extra" => "longblob NULL",
		"PRIMARY KEY" => "(id_auteur)",
		"KEY login" => "(login)",
		"KEY statut" => "(statut)",
		"KEY lang" => "(lang)",
		"KEY en_ligne" => "(en_ligne)");

$spip_breves = array(
		"id_breve" => "bigint(21) NOT NULL auto_increment",
		"date_heure" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"titre" => "text NOT NULL",
		"texte" => "longblob NOT NULL",
		"lien_titre" => "text NOT NULL",
		"lien_url" => "text NOT NULL",
		"statut" => "varchar(6) NOT NULL",
		"id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
		"lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
		"langue_choisie" => "VARCHAR(3) DEFAULT 'non'",
		"maj" => "TIMESTAMP",
		"extra" => "longblob NULL",
		"PRIMARY KEY" => "(id_breve)",
		"KEY id_rubrique" => "(id_rubrique)");

$spip_messages = array(
		"id_message" => "bigint(21) NOT NULL auto_increment",
		"titre" => "text NOT NULL",
		"texte" => "longblob NOT NULL",
		"type" => "varchar(6) NOT NULL",
		"date_heure" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"rv" => "varchar(3) NOT NULL",
		"statut" => "varchar(6) NOT NULL",
		"id_auteur" => "bigint(21) NOT NULL",
		"maj" => "TIMESTAMP",
		"KEY id_auteur" => "(id_auteur)",
		"PRIMARY KEY" => "(id_message)");

$spip_mots = array(
		"id_mot" => "bigint(21) NOT NULL auto_increment",
		"type" => "VARCHAR(100) NOT NULL",
		"titre" => "text NOT NULL",
		"descriptif" => "text NOT NULL",
		"texte" => "longblob NOT NULL",
		"id_groupe" => "bigint(21) NOT NULL",
		"extra" => "longblob NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(id_mot)",
		"KEY type" => "(type)");

$spip_groupes_mots = array(
		"id_groupe" => "bigint(21) NOT NULL auto_increment",
		"titre" => "text NOT NULL",
		"unseul" => "varchar(3) NOT NULL",
		"obligatoire" => "varchar(3) NOT NULL",
		"articles" => "varchar(3) NOT NULL",
		"breves" => "varchar(3) NOT NULL",
		"rubriques" => "varchar(3) NOT NULL",
		"syndic" => "varchar(3) NOT NULL",
		"0minirezo" => "varchar(3) NOT NULL",
		"1comite" => "varchar(3) NOT NULL",
		"6forum" => "varchar(3) NOT NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(id_groupe)");

$spip_rubriques = array(
		"id_rubrique" => "bigint(21) NOT NULL auto_increment",
		"id_parent" => "bigint(21) DEFAULT '0' NOT NULL",
		"titre" => "text NOT NULL",
		"descriptif" => "text NOT NULL",
		"texte" => "longblob NOT NULL",
		"id_secteur" => "bigint(21) DEFAULT '0' NOT NULL",
		"maj" => "TIMESTAMP",
		"export" => "VARCHAR(10) DEFAULT 'oui'",
		"id_import" => "BIGINT DEFAULT '0'",
		"statut" => "VARCHAR(10) NOT NULL",
		"date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
		"langue_choisie" => "VARCHAR(3) DEFAULT 'non'",
		"extra" => "longblob NULL",
		"PRIMARY KEY" => "(id_rubrique)",
		"KEY lang" => "(lang)",
		"KEY id_parent" => "(id_parent)");

$spip_documents = array(
		"id_document" => "bigint(21) NOT NULL auto_increment",
		"id_vignette" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_type" => "bigint(21) DEFAULT '0' NOT NULL",
		"titre" => "text NOT NULL",
		"date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"descriptif" => "text NOT NULL",
		"fichier" => "varchar(255) NOT NULL",
		"taille" => "integer NOT NULL",
		"largeur" => "integer NOT NULL",
		"hauteur" => "integer NOT NULL",
		"mode" => "ENUM('vignette', 'document') NOT NULL",
		"inclus" => "VARCHAR(3) DEFAULT 'non'",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(id_document)",
		"KEY id_vignette" => "(id_vignette)",
		"KEY mode" => "(mode)",
		"KEY id_type" => "(id_type)");

$spip_types_documents = array(
		"id_type" => "bigint(21) NOT NULL auto_increment",
		"titre" => "text NOT NULL",
		"descriptif" => "text NOT NULL",
		"extension" => "varchar(10) NOT NULL",
		"mime_type" => "varchar(100) NOT NULL",
		"inclus" => "ENUM('non', 'image', 'embed') NOT NULL DEFAULT 'non'",
		"upload" => "ENUM('oui', 'non') NOT NULL DEFAULT 'oui'",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(id_type)",
		"UNIQUE" => "extension (extension)",
		"KEY inclus" => "(inclus)");

$spip_syndic = array(
		"id_syndic" => "bigint(21) NOT NULL auto_increment",
		"id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_secteur" => "bigint(21) DEFAULT '0' NOT NULL",
		"nom_site" => "blob NOT NULL",
		"url_site" => "blob NOT NULL",
		"url_syndic" => "blob NOT NULL",
		"descriptif" => "blob NOT NULL",
		"maj" => "TIMESTAMP",
		"syndication" => "VARCHAR(3) NOT NULL",
		"statut" => "VARCHAR(10) NOT NULL",
		"date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"date_syndic" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"date_index" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"moderation" => "VARCHAR(3) NOT NULL",
		"PRIMARY KEY" => "(id_syndic)",
		"KEY id_rubrique" => "(id_rubrique)",
		"KEY id_secteur" => "(id_secteur)",
		"KEY statut" => "(statut, date_syndic)");

$spip_syndic_articles = array(
		"id_syndic_article" => "bigint(21) NOT NULL auto_increment",
		"id_syndic" => "bigint(21) DEFAULT '0' NOT NULL",
		"titre" => "text NOT NULL",
		"url" => "VARCHAR(255) NOT NULL",
		"date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"lesauteurs" => "text NOT NULL",
		"maj" => "TIMESTAMP",
		"statut" => "VARCHAR(10) NOT NULL",
		"descriptif" => "blob NOT NULL",
		"PRIMARY KEY" => "(id_syndic_article)",
		"KEY id_syndic" => "(id_syndic)",
		"KEY statut" => "(statut)",
		"KEY url" => "(url)");


$spip_forum = array(
		"id_forum" => "bigint(21) NOT NULL auto_increment",
		"id_parent" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_article" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_breve" => "bigint(21) DEFAULT '0' NOT NULL",
		"date_heure" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"titre" => "text NOT NULL",
		"texte" => "mediumtext NOT NULL",
		"auteur" => "text NOT NULL",
		"email_auteur" => "text NOT NULL",
		"nom_site" => "text NOT NULL",
		"url_site" => "text NOT NULL",
		"statut" => "varchar(8) NOT NULL",
		"ip" => "varchar(16)",
		"maj" => "TIMESTAMP",
		"id_auteur" => "BIGINT DEFAULT '0' NOT NULL",
		"id_message" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_syndic" => "bigint(21) DEFAULT '0' NOT NULL",
		"PRIMARY KEY" => "(id_forum)",
		"KEY id_parent" => "(id_parent)",
		"KEY id_rubrique" => "(id_rubrique)",
		"KEY id_article" => "(id_article)",
		"KEY id_breve" => "(id_breve)",
		"KEY id_message" => "(id_message)",
		"KEY id_syndic" => "(id_syndic)",
		"KEY statut" => "(statut, date_heure)");

$spip_petitions = array(
		"id_article" => "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",
		"PRIMARY KEY" => "(id_article)");

$spip_signatures = array(
		"id_signature" => "bigint(21) NOT NULL auto_increment",
		"id_article" => "bigint(21) DEFAULT '0' NOT NULL",
		"date_time" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"nom_email" => "text NOT NULL",
		"ad_email" => "text NOT NULL",
		"nom_site" => "text NOT NULL",
		"url_site" => "text NOT NULL",
		"message" => "mediumtext NOT NULL",
		"statut" => "varchar(10) NOT NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(id_signature)",
		"KEY id_article" => "(id_article)",
		"KEY statut"=> "statut)");

$spip_visites_temp = array(
		"ip" => "INTEGER UNSIGNED NOT NULL",
		"type" => "ENUM('article', 'rubrique', 'breve', 'autre') NOT NULL",
		"id_objet" => "INTEGER UNSIGNED NOT NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(type, id_objet, ip)");

$spip_visites = array(
		"date" => "DATE NOT NULL",
		"visites" => "INTEGER UNSIGNED NOT NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(date)");

$spip_visites_articles = array(
		"date" => "DATE NOT NULL",
		"id_article" => "INTEGER UNSIGNED NOT NULL",
		"visites" => "INTEGER UNSIGNED NOT NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(date, id_article)");

$spip_referers_temp = array(
		"ip" => "INTEGER UNSIGNED NOT NULL",
		"referer" => "VARCHAR(255) NOT NULL",
		"referer_md5" => "BIGINT UNSIGNED NOT NULL",
		"type" => "ENUM('article', 'rubrique', 'breve', 'autre') NOT NULL",
		"id_objet" => "INTEGER UNSIGNED NOT NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(type, id_objet, referer_md5, ip)");

$spip_referers = array(
		"referer_md5" => "BIGINT UNSIGNED NOT NULL",
		"date" => "DATE NOT NULL",
		"referer" => "VARCHAR(255) NOT NULL",
		"visites" => "INTEGER UNSIGNED NOT NULL",
		"visites_jour" => "INTEGER UNSIGNED NOT NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(referer_md5)");

$spip_referers_articles = array(
		"id_article" => "INTEGER UNSIGNED NOT NULL",
		"referer_md5" => "BIGINT UNSIGNED NOT NULL",
		"date" => "DATE NOT NULL",
		"referer" => "VARCHAR(255) NOT NULL",
		"visites" => "INTEGER UNSIGNED NOT NULL",
		"maj" => "TIMESTAMP",
		"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",
		"KEY id_auteur" => "(id_auteur)",
		"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",
		"KEY id_auteur" => "(id_auteur)",
		"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",
		"KEY id_auteur" => "(id_auteur)",
		"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",
		"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",
		"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",
		"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",
		"KEY id_mot" => "(id_mot)",
		"KEY id_article" => "(id_article)");

$spip_mots_breves = array(
		"id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_breve" => "bigint(21) DEFAULT '0' NOT NULL",
		"KEY id_mot" => "(id_mot)",
		"KEY id_breve" => "(id_breve)");

$spip_mots_rubriques = array(
		"id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
		"KEY id_mot" => "(id_mot)",
		"KEY id_rubrique" => "(id_rubrique)");

$spip_mots_syndic = array(
		"id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_syndic" => "bigint(21) DEFAULT '0' NOT NULL",
		"KEY id_mot" => "(id_mot)",
		"KEY id_syndic" => "(id_syndic)");

$spip_mots_forum = array(
		"id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_forum" => "bigint(21) DEFAULT '0' NOT NULL",
		"KEY id_mot" => "(id_mot)",
		"KEY id_forum" => "(id_forum)");


$spip_forum_cache = array(
		"id_forum" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_article" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_breve" => "bigint(21) DEFAULT '0' NOT NULL",
		"id_syndic" => "bigint(21) DEFAULT '0' NOT NULL",
		"fichier" => "char(150) binary NOT NULL",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(fichier, id_forum, id_article, id_rubrique, id_breve, id_syndic)",
		"KEY id_forum"=> "(id_forum)",
		"KEY id_rubrique"=> "(id_rubrique)",
		"KEY id_article"=> "(id_article)",
		"KEY id_syndic"=> "(id_syndic)",
		"KEY id_breve"=> "(id_breve)");

$spip_meta = array(
		"nom" => "VARCHAR(255) NOT NULL",
		"valeur" => "VARCHAR(255) DEFAULT ''",
		"maj" => "TIMESTAMP",
		"PRIMARY KEY" => "(nom)");

$spip_index_articles = array(
		"hash" => "bigint unsigned NOT NULL",
		"points" => "int unsigned DEFAULT '0' NOT NULL",
		"id_article" => "int unsigned NOT NULL",
		"KEY hash" => "(hash)",
		"KEY id_article" => "(id_article)");

$spip_index_auteurs = array(
		"hash" => "bigint unsigned NOT NULL",
		"points" => "int unsigned DEFAULT '0' NOT NULL",
		"id_auteur" => "int unsigned NOT NULL",
		"KEY hash" => "(hash)",
		"KEY id_auteur" => "(id_auteur)");

$spip_index_breves = array(
		"hash" => "bigint unsigned NOT NULL",
		"points" => "int unsigned DEFAULT '0' NOT NULL",
		"id_breve" => "int unsigned NOT NULL",
		"KEY hash" => "(hash)",
		"KEY id_breve" => "(id_breve)");

$spip_index_mots = array(
		"hash" => "bigint unsigned NOT NULL",
		"points" => "int unsigned DEFAULT '0' NOT NULL",
		"id_mot" => "int unsigned NOT NULL",
		"KEY hash" => "(hash), KEY id_mot (id_mot)");

$spip_index_rubriques = array(
		"hash" => "bigint unsigned NOT NULL",
		"points" => "int unsigned DEFAULT '0' NOT NULL",
		"id_rubrique" => "int unsigned NOT NULL",
		"KEY hash" => "(hash)",
		"KEY id_rubrique" => "(id_rubrique)");

$spip_index_syndic = array(
		"hash" => "bigint unsigned NOT NULL",
		"points" => "int unsigned DEFAULT '0' NOT NULL",
		"id_syndic" => "int unsigned NOT NULL",
		"KEY hash" => "(hash)",
		"KEY id_syndic" => "(id_syndic)");

$spip_index_dico = array(
		"hash" => "bigint unsigned NOT NULL",
		"dico" => "VARCHAR(30) NOT NULL",
		"PRIMARY KEY" => "(dico)");
?>