pense-bête de bruno sanchiz

Accueil > CMS > Spip > tables de spip

tables de spip

Publié le 5 avril 2020, dernière mise-à-jour le 30 avril 2024, 5 visites, visites totales.

spip 3.2.7

https://www.spip.net/fr_article713.html


--
-- Structure de la table 'spip_articles'
--

CREATE TABLE IF NOT EXISTS 'spip_articles' (
  'id_article' bigint(21) NOT NULL,
  'surtitre' text NOT NULL,
  'titre' text NOT NULL,
  'soustitre' text NOT NULL,
  'id_rubrique' bigint(21) NOT NULL DEFAULT '0',
  'descriptif' text NOT NULL,
  'chapo' mediumtext NOT NULL,
  'texte' longtext NOT NULL,
  'ps' mediumtext NOT NULL,
  'date' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'statut' varchar(10) NOT NULL DEFAULT '0',
  'id_secteur' bigint(21) NOT NULL DEFAULT '0',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'export' varchar(10) DEFAULT 'oui',
  'date_redac' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'visites' int(11) NOT NULL DEFAULT '0',
  'referers' int(11) NOT NULL DEFAULT '0',
  'popularite' double NOT NULL DEFAULT '0',
  'accepter_forum' char(3) NOT NULL DEFAULT '',
  'date_modif' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'lang' varchar(10) NOT NULL DEFAULT '',
  'langue_choisie' varchar(3) DEFAULT 'non',
  'id_trad' bigint(21) NOT NULL DEFAULT '0',
  'nom_site' tinytext NOT NULL,
  'url_site' text NOT NULL,
  'virtuel' text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_auteurs'
--

CREATE TABLE IF NOT EXISTS 'spip_auteurs' (
  'id_auteur' bigint(21) NOT NULL,
  '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) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  'pass' tinytext NOT NULL,
  'low_sec' tinytext NOT NULL,
  'statut' varchar(255) NOT NULL DEFAULT '0',
  'webmestre' varchar(3) NOT NULL DEFAULT 'non',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'pgp' text NOT NULL,
  'htpass' tinytext NOT NULL,
  'en_ligne' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'alea_actuel' tinytext,
  'alea_futur' tinytext,
  'prefs' text,
  'cookie_oubli' tinytext,
  'source' varchar(10) NOT NULL DEFAULT 'spip',
  'lang' varchar(10) NOT NULL DEFAULT '',
  'imessage' varchar(3) DEFAULT NULL,
  'messagerie' varchar(3) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_auteurs_liens'
--

CREATE TABLE IF NOT EXISTS 'spip_auteurs_liens' (
  'id_auteur' bigint(21) NOT NULL DEFAULT '0',
  'id_objet' bigint(21) NOT NULL DEFAULT '0',
  'objet' varchar(25) NOT NULL DEFAULT '',
  'vu' varchar(6) NOT NULL DEFAULT 'non'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_breves'
--

CREATE TABLE IF NOT EXISTS 'spip_breves' (
  'id_breve' bigint(21) NOT NULL,
  'date_heure' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'titre' text NOT NULL,
  'texte' longtext NOT NULL,
  'lien_titre' text NOT NULL,
  'lien_url' text NOT NULL,
  'statut' varchar(6) NOT NULL DEFAULT '0',
  'id_rubrique' bigint(21) NOT NULL DEFAULT '0',
  'lang' varchar(10) NOT NULL DEFAULT '',
  'langue_choisie' varchar(3) DEFAULT 'non',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_depots'
--

CREATE TABLE IF NOT EXISTS 'spip_depots' (
  'id_depot' bigint(21) NOT NULL,
  'titre' text NOT NULL,
  'descriptif' text NOT NULL,
  'type' varchar(10) NOT NULL DEFAULT '',
  'url_serveur' varchar(255) NOT NULL DEFAULT '',
  'url_brouteur' varchar(255) NOT NULL DEFAULT '',
  'url_archives' varchar(255) NOT NULL DEFAULT '',
  'url_commits' varchar(255) NOT NULL DEFAULT '',
  'xml_paquets' varchar(255) NOT NULL DEFAULT '',
  'sha_paquets' varchar(40) NOT NULL DEFAULT '',
  'nbr_paquets' int(11) NOT NULL DEFAULT '0',
  'nbr_plugins' int(11) NOT NULL DEFAULT '0',
  'nbr_autres' int(11) NOT NULL DEFAULT '0',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_depots_plugins'
--

CREATE TABLE IF NOT EXISTS 'spip_depots_plugins' (
  'id_depot' bigint(21) NOT NULL,
  'id_plugin' bigint(21) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_documents'
--

CREATE TABLE IF NOT EXISTS 'spip_documents' (
  'id_document' bigint(21) NOT NULL,
  'id_vignette' bigint(21) NOT NULL DEFAULT '0',
  'extension' varchar(10) NOT NULL DEFAULT '',
  'titre' text NOT NULL,
  'date' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'descriptif' text NOT NULL,
  'fichier' text NOT NULL,
  'taille' bigint(20) DEFAULT NULL,
  'largeur' int(11) DEFAULT NULL,
  'hauteur' int(11) DEFAULT NULL,
  'duree' int(11) DEFAULT NULL,
  'media' varchar(10) NOT NULL DEFAULT 'file',
  'mode' varchar(10) NOT NULL DEFAULT 'document',
  'distant' varchar(3) DEFAULT 'non',
  'statut' varchar(10) NOT NULL DEFAULT '0',
  'credits' text NOT NULL,
  'date_publication' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'brise' tinyint(4) DEFAULT '0',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_documents_liens'
--

CREATE TABLE IF NOT EXISTS 'spip_documents_liens' (
  'id_document' bigint(21) NOT NULL DEFAULT '0',
  'id_objet' bigint(21) NOT NULL DEFAULT '0',
  'objet' varchar(25) NOT NULL DEFAULT '',
  'vu' enum('non','oui') NOT NULL DEFAULT 'non',
  'rang_lien' int(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_forum'
--

CREATE TABLE IF NOT EXISTS 'spip_forum' (
  'id_forum' bigint(21) NOT NULL,
  'id_objet' bigint(21) NOT NULL DEFAULT '0',
  'objet' varchar(25) NOT NULL DEFAULT '',
  'id_parent' bigint(21) NOT NULL DEFAULT '0',
  'id_thread' bigint(21) NOT NULL DEFAULT '0',
  'date_heure' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'date_thread' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  '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 DEFAULT '0',
  'ip' varchar(40) NOT NULL DEFAULT '',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'id_auteur' bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_groupes_mots'
--

CREATE TABLE IF NOT EXISTS 'spip_groupes_mots' (
  'id_groupe' bigint(21) NOT NULL,
  'titre' text NOT NULL,
  'descriptif' text NOT NULL,
  'texte' longtext NOT NULL,
  'unseul' varchar(3) NOT NULL DEFAULT '',
  'obligatoire' varchar(3) NOT NULL DEFAULT '',
  'tables_liees' text NOT NULL,
  'minirezo' varchar(3) NOT NULL DEFAULT '',
  'comite' varchar(3) NOT NULL DEFAULT '',
  'forum' varchar(3) NOT NULL DEFAULT '',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_jobs'
--

CREATE TABLE IF NOT EXISTS 'spip_jobs' (
  'id_job' bigint(21) NOT NULL,
  'descriptif' text NOT NULL,
  'fonction' varchar(255) NOT NULL,
  'args' longblob NOT NULL,
  'md5args' char(32) NOT NULL DEFAULT '',
  'inclure' varchar(255) NOT NULL,
  'priorite' smallint(6) NOT NULL DEFAULT '0',
  'date' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'status' tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_jobs_liens'
--

CREATE TABLE IF NOT EXISTS 'spip_jobs_liens' (
  'id_job' bigint(21) NOT NULL DEFAULT '0',
  'id_objet' bigint(21) NOT NULL DEFAULT '0',
  'objet' varchar(25) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_messages'
--

CREATE TABLE IF NOT EXISTS 'spip_messages' (
  'id_message' bigint(21) NOT NULL,
  'titre' text NOT NULL,
  'texte' longtext NOT NULL,
  'type' varchar(6) NOT NULL DEFAULT '',
  'date_heure' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'date_fin' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'rv' varchar(3) NOT NULL DEFAULT '',
  'statut' varchar(6) NOT NULL DEFAULT '0',
  'id_auteur' bigint(21) NOT NULL DEFAULT '0',
  'destinataires' text NOT NULL,
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_meta'
--

CREATE TABLE IF NOT EXISTS 'spip_meta' (
  'nom' varchar(255) NOT NULL,
  'valeur' text,
  'impt' enum('non','oui') NOT NULL DEFAULT 'oui',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_mots'
--

CREATE TABLE IF NOT EXISTS 'spip_mots' (
  'id_mot' bigint(21) NOT NULL,
  'titre' text NOT NULL,
  'descriptif' text NOT NULL,
  'texte' longtext NOT NULL,
  'id_groupe' bigint(21) NOT NULL DEFAULT '0',
  'type' text NOT NULL,
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_mots_liens'
--

CREATE TABLE IF NOT EXISTS 'spip_mots_liens' (
  'id_mot' bigint(21) NOT NULL DEFAULT '0',
  'id_objet' bigint(21) NOT NULL DEFAULT '0',
  'objet' varchar(25) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_paquets'
--

CREATE TABLE IF NOT EXISTS 'spip_paquets' (
  'id_paquet' bigint(21) NOT NULL,
  'id_plugin' bigint(21) NOT NULL,
  'prefixe' varchar(30) NOT NULL DEFAULT '',
  'logo' varchar(255) NOT NULL DEFAULT '',
  'version' varchar(24) NOT NULL DEFAULT '',
  'version_base' varchar(24) NOT NULL DEFAULT '',
  'compatibilite_spip' varchar(24) NOT NULL DEFAULT '',
  'branches_spip' varchar(255) NOT NULL DEFAULT '',
  'description' text NOT NULL,
  'auteur' text NOT NULL,
  'credit' text NOT NULL,
  'licence' text NOT NULL,
  'copyright' text NOT NULL,
  'lien_doc' text NOT NULL,
  'lien_demo' text NOT NULL,
  'lien_dev' text NOT NULL,
  'etat' varchar(16) NOT NULL DEFAULT '',
  'etatnum' int(1) NOT NULL DEFAULT '0',
  'dependances' text NOT NULL,
  'procure' text NOT NULL,
  'date_crea' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'date_modif' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'id_depot' bigint(21) NOT NULL DEFAULT '0',
  'nom_archive' varchar(255) NOT NULL DEFAULT '',
  'nbo_archive' int(11) NOT NULL DEFAULT '0',
  'maj_archive' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'src_archive' varchar(255) NOT NULL DEFAULT '',
  'traductions' text NOT NULL,
  'actif' varchar(3) NOT NULL DEFAULT 'non',
  'installe' varchar(3) NOT NULL DEFAULT 'non',
  'recent' int(2) NOT NULL DEFAULT '0',
  'maj_version' varchar(255) NOT NULL DEFAULT '',
  'superieur' varchar(3) NOT NULL DEFAULT 'non',
  'obsolete' varchar(3) NOT NULL DEFAULT 'non',
  'attente' varchar(3) NOT NULL DEFAULT 'non',
  'constante' varchar(30) NOT NULL DEFAULT '',
  'signature' varchar(32) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_petitions'
--

CREATE TABLE IF NOT EXISTS 'spip_petitions' (
  'id_petition' bigint(21) NOT NULL,
  'id_article' bigint(21) NOT NULL DEFAULT '0',
  'email_unique' char(3) NOT NULL DEFAULT '',
  'site_obli' char(3) NOT NULL DEFAULT '',
  'site_unique' char(3) NOT NULL DEFAULT '',
  'message' char(3) NOT NULL DEFAULT '',
  'texte' longtext NOT NULL,
  'statut' varchar(10) NOT NULL DEFAULT 'publie',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_plugins'
--

CREATE TABLE IF NOT EXISTS 'spip_plugins' (
  'id_plugin' bigint(21) NOT NULL,
  'prefixe' varchar(30) NOT NULL DEFAULT '',
  'nom' text NOT NULL,
  'slogan' text NOT NULL,
  'categorie' varchar(100) NOT NULL DEFAULT '',
  'tags' text NOT NULL,
  'vmax' varchar(24) NOT NULL DEFAULT '',
  'date_crea' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'date_modif' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'compatibilite_spip' varchar(24) NOT NULL DEFAULT '',
  'branches_spip' varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_referers'
--

CREATE TABLE IF NOT EXISTS 'spip_referers' (
  'referer_md5' bigint(20) UNSIGNED NOT NULL,
  'date' date NOT NULL,
  'referer' varchar(255) DEFAULT NULL,
  'visites' int(10) UNSIGNED NOT NULL,
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'visites_veille' int(10) UNSIGNED NOT NULL DEFAULT '0',
  'visites_jour' int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

’referer_ md5’ ’date’ ’referer’ ’visites’ ’maj’ ’visites_ veille’ ’visites_ jour’
111112222233333444 ’2019-01-01’ http://www.dindoun.lautre.net/spip.php?page=recherche&recherche=trou+noir 1 ’2019-01-01 18:05:22’ 0 0

--
-- Structure de la table 'spip_referers_articles'
--

CREATE TABLE IF NOT EXISTS 'spip_referers_articles' (
  'id_article' int(10) UNSIGNED NOT NULL,
  'referer_md5' bigint(20) UNSIGNED NOT NULL,
  'referer' varchar(255) NOT NULL DEFAULT '',
  'visites' int(10) UNSIGNED NOT NULL,
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

’id_article’ ’referer_md5’ ’referer’ ’visites’ ’maj’
330 000001111122222333 http://www.dindoun.lautre.net/spip.php?page=recherche&recherche=buster 13 ’2020-01-01 13:03:26’

--
-- Structure de la table 'spip_resultats'
--

CREATE TABLE IF NOT EXISTS 'spip_resultats' (
  'recherche' char(16) NOT NULL DEFAULT '',
  'id' int(10) UNSIGNED NOT NULL,
  'points' int(10) UNSIGNED NOT NULL DEFAULT '0',
  'table_objet' varchar(30) NOT NULL DEFAULT '',
  'serveur' char(16) NOT NULL DEFAULT '',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_rubriques'
--

CREATE TABLE IF NOT EXISTS 'spip_rubriques' (
  'id_rubrique' bigint(21) NOT NULL,
  'id_parent' bigint(21) NOT NULL DEFAULT '0',
  'titre' text NOT NULL,
  'descriptif' text NOT NULL,
  'texte' longtext NOT NULL,
  'id_secteur' bigint(21) NOT NULL DEFAULT '0',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'statut' varchar(10) NOT NULL DEFAULT '0',
  'date' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'lang' varchar(10) NOT NULL DEFAULT '',
  'langue_choisie' varchar(3) DEFAULT 'non',
  'statut_tmp' varchar(10) NOT NULL DEFAULT '0',
  'date_tmp' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'profondeur' smallint(5) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_signatures'
--

CREATE TABLE IF NOT EXISTS 'spip_signatures' (
  'id_signature' bigint(21) NOT NULL,
  'id_petition' bigint(21) NOT NULL DEFAULT '0',
  'date_time' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  '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 DEFAULT '0',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_syndic'
--

CREATE TABLE IF NOT EXISTS 'spip_syndic' (
  'id_syndic' bigint(21) NOT NULL,
  'id_rubrique' bigint(21) NOT NULL DEFAULT '0',
  'id_secteur' bigint(21) NOT NULL DEFAULT '0',
  'nom_site' text NOT NULL,
  'url_site' text NOT NULL,
  'url_syndic' text NOT NULL,
  'descriptif' text NOT NULL,
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'syndication' varchar(3) NOT NULL DEFAULT '',
  'statut' varchar(10) NOT NULL DEFAULT '0',
  'date' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'date_syndic' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'date_index' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'moderation' varchar(3) DEFAULT 'non',
  'miroir' varchar(3) DEFAULT 'non',
  'oubli' varchar(3) DEFAULT 'non',
  'resume' varchar(3) DEFAULT 'oui'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_syndic_articles'
--

CREATE TABLE IF NOT EXISTS 'spip_syndic_articles' (
  'id_syndic_article' bigint(21) NOT NULL,
  'id_syndic' bigint(21) NOT NULL DEFAULT '0',
  'titre' text NOT NULL,
  'url' text NOT NULL,
  'date' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'lesauteurs' text NOT NULL,
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'statut' varchar(10) NOT NULL DEFAULT '0',
  'descriptif' text NOT NULL,
  'lang' varchar(10) NOT NULL DEFAULT '',
  'url_source' tinytext NOT NULL,
  'source' tinytext NOT NULL,
  'tags' text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_types_documents'
--

CREATE TABLE IF NOT EXISTS 'spip_types_documents' (
  'extension' varchar(10) NOT NULL DEFAULT '',
  'titre' text NOT NULL,
  'descriptif' text NOT NULL,
  'mime_type' varchar(100) NOT NULL DEFAULT '',
  'inclus' enum('non','image','embed') NOT NULL DEFAULT 'non',
  'upload' enum('oui','non') NOT NULL DEFAULT 'oui',
  'media_defaut' varchar(10) NOT NULL DEFAULT 'file',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_urls'
--

CREATE TABLE IF NOT EXISTS 'spip_urls' (
  'id_parent' bigint(21) NOT NULL DEFAULT '0',
  'url' varchar(255) NOT NULL,
  'type' varchar(25) NOT NULL DEFAULT 'article',
  'id_objet' bigint(21) NOT NULL,
  'date' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'segments' smallint(3) NOT NULL DEFAULT '1',
  'perma' tinyint(1) NOT NULL DEFAULT '0',
  'langue' varchar(10) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_versions'
--

CREATE TABLE IF NOT EXISTS 'spip_versions' (
  'id_version' bigint(21) NOT NULL DEFAULT '0',
  'id_objet' bigint(21) NOT NULL DEFAULT '0',
  'objet' varchar(25) NOT NULL DEFAULT '',
  'date' datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  'id_auteur' varchar(23) NOT NULL DEFAULT '',
  'titre_version' text NOT NULL,
  'permanent' char(3) NOT NULL DEFAULT '',
  'champs' text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_versions_fragments'
--

CREATE TABLE IF NOT EXISTS 'spip_versions_fragments' (
  'id_fragment' int(10) UNSIGNED NOT NULL DEFAULT '0',
  'version_min' int(10) UNSIGNED NOT NULL DEFAULT '0',
  'version_max' int(10) UNSIGNED NOT NULL DEFAULT '0',
  'id_objet' bigint(21) NOT NULL,
  'objet' varchar(25) NOT NULL DEFAULT '',
  'compress' tinyint(4) NOT NULL,
  'fragment' longblob
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Structure de la table 'spip_visites'
--

CREATE TABLE IF NOT EXISTS 'spip_visites' (
  'date' date NOT NULL,
  'visites' int(10) UNSIGNED NOT NULL DEFAULT '0',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

date visites maj
2020-01-01 15 2020-01-01 20:11:24

--
-- Structure de la table 'spip_visites_articles'
--

CREATE TABLE IF NOT EXISTS 'spip_visites_articles' (
  'date' date NOT NULL,
  'id_article' int(10) UNSIGNED NOT NULL,
  'visites' int(10) UNSIGNED NOT NULL DEFAULT '0',
  'maj' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

date id_article visites maj
2020-01-01 160 15 2020-01-01 20:11:24

clés

-- Index pour la table 'spip_articles'
--
ALTER TABLE 'spip_articles'
  ADD PRIMARY KEY ('id_article'),
  ADD KEY 'id_rubrique' ('id_rubrique'),
  ADD KEY 'id_secteur' ('id_secteur'),
  ADD KEY 'id_trad' ('id_trad'),
  ADD KEY 'lang' ('lang'),
  ADD KEY 'statut' ('statut','date');

--
-- Index pour la table 'spip_auteurs'
--
ALTER TABLE 'spip_auteurs'
  ADD PRIMARY KEY ('id_auteur'),
  ADD KEY 'login' ('login'),
  ADD KEY 'statut' ('statut'),
  ADD KEY 'en_ligne' ('en_ligne');

--
-- Index pour la table 'spip_auteurs_liens'
--
ALTER TABLE 'spip_auteurs_liens'
  ADD PRIMARY KEY ('id_auteur','id_objet','objet'),
  ADD KEY 'id_auteur' ('id_auteur'),
  ADD KEY 'id_objet' ('id_objet'),
  ADD KEY 'objet' ('objet');

--
-- Index pour la table 'spip_breves'
--
ALTER TABLE 'spip_breves'
  ADD PRIMARY KEY ('id_breve'),
  ADD KEY 'id_rubrique' ('id_rubrique');

--
-- Index pour la table 'spip_depots'
--
ALTER TABLE 'spip_depots'
  ADD PRIMARY KEY ('id_depot');

--
-- Index pour la table 'spip_depots_plugins'
--
ALTER TABLE 'spip_depots_plugins'
  ADD PRIMARY KEY ('id_depot','id_plugin');

--
-- Index pour la table 'spip_documents'
--
ALTER TABLE 'spip_documents'
  ADD PRIMARY KEY ('id_document'),
  ADD KEY 'id_vignette' ('id_vignette'),
  ADD KEY 'mode' ('mode'),
  ADD KEY 'extension' ('extension');

--
-- Index pour la table 'spip_documents_liens'
--
ALTER TABLE 'spip_documents_liens'
  ADD PRIMARY KEY ('id_document','id_objet','objet'),
  ADD KEY 'id_document' ('id_document'),
  ADD KEY 'id_objet' ('id_objet'),
  ADD KEY 'objet' ('objet');

--
-- Index pour la table 'spip_forum'
--
ALTER TABLE 'spip_forum'
  ADD PRIMARY KEY ('id_forum'),
  ADD KEY 'id_auteur' ('id_auteur'),
  ADD KEY 'id_parent' ('id_parent'),
  ADD KEY 'id_thread' ('id_thread'),
  ADD KEY 'optimal' ('statut','id_parent','id_objet','objet','date_heure');

--
-- Index pour la table 'spip_groupes_mots'
--
ALTER TABLE 'spip_groupes_mots'
  ADD PRIMARY KEY ('id_groupe');

--
-- Index pour la table 'spip_jobs'
--
ALTER TABLE 'spip_jobs'
  ADD PRIMARY KEY ('id_job'),
  ADD KEY 'date' ('date'),
  ADD KEY 'status' ('status');

--
-- Index pour la table 'spip_jobs_liens'
--
ALTER TABLE 'spip_jobs_liens'
  ADD PRIMARY KEY ('id_job','id_objet','objet'),
  ADD KEY 'id_job' ('id_job');

--
-- Index pour la table 'spip_messages'
--
ALTER TABLE 'spip_messages'
  ADD PRIMARY KEY ('id_message'),
  ADD KEY 'id_auteur' ('id_auteur');

--
-- Index pour la table 'spip_meta'
--
ALTER TABLE 'spip_meta'
  ADD PRIMARY KEY ('nom');

--
-- Index pour la table 'spip_mots'
--
ALTER TABLE 'spip_mots'
  ADD PRIMARY KEY ('id_mot'),
  ADD KEY 'id_groupe' ('id_groupe');

--
-- Index pour la table 'spip_mots_liens'
--
ALTER TABLE 'spip_mots_liens'
  ADD PRIMARY KEY ('id_mot','id_objet','objet'),
  ADD KEY 'id_mot' ('id_mot'),
  ADD KEY 'id_objet' ('id_objet'),
  ADD KEY 'objet' ('objet');

--
-- Index pour la table 'spip_paquets'
--
ALTER TABLE 'spip_paquets'
  ADD PRIMARY KEY ('id_paquet'),
  ADD KEY 'id_plugin' ('id_plugin');

--
-- Index pour la table 'spip_petitions'
--
ALTER TABLE 'spip_petitions'
  ADD PRIMARY KEY ('id_petition'),
  ADD UNIQUE KEY 'id_article' ('id_article');

--
-- Index pour la table 'spip_plugins'
--
ALTER TABLE 'spip_plugins'
  ADD PRIMARY KEY ('id_plugin'),
  ADD KEY 'prefixe' ('prefixe');

--
-- Index pour la table 'spip_referers'
--
ALTER TABLE 'spip_referers'
  ADD PRIMARY KEY ('referer_md5');

--
-- Index pour la table 'spip_referers_articles'
--
ALTER TABLE 'spip_referers_articles'
  ADD PRIMARY KEY ('id_article','referer_md5'),
  ADD KEY 'referer_md5' ('referer_md5');

--
-- Index pour la table 'spip_rubriques'
--
ALTER TABLE 'spip_rubriques'
  ADD PRIMARY KEY ('id_rubrique'),
  ADD KEY 'lang' ('lang'),
  ADD KEY 'id_parent' ('id_parent');

--
-- Index pour la table 'spip_signatures'
--
ALTER TABLE 'spip_signatures'
  ADD PRIMARY KEY ('id_signature'),
  ADD KEY 'id_petition' ('id_petition'),
  ADD KEY 'statut' ('statut');

--
-- Index pour la table 'spip_syndic'
--
ALTER TABLE 'spip_syndic'
  ADD PRIMARY KEY ('id_syndic'),
  ADD KEY 'id_rubrique' ('id_rubrique'),
  ADD KEY 'id_secteur' ('id_secteur'),
  ADD KEY 'statut' ('statut','date_syndic');

--
-- Index pour la table 'spip_syndic_articles'
--
ALTER TABLE 'spip_syndic_articles'
  ADD PRIMARY KEY ('id_syndic_article'),
  ADD KEY 'id_syndic' ('id_syndic'),
  ADD KEY 'statut' ('statut'),
  ADD KEY 'url' ('url'(255));

--
-- Index pour la table 'spip_types_documents'
--
ALTER TABLE 'spip_types_documents'
  ADD PRIMARY KEY ('extension'),
  ADD KEY 'inclus' ('inclus');

--
-- Index pour la table 'spip_urls'
--
ALTER TABLE 'spip_urls'
  ADD PRIMARY KEY ('id_parent','url'),
  ADD KEY 'type' ('type','id_objet'),
  ADD KEY 'langue' ('langue'),
  ADD KEY 'url' ('url');

--
-- Index pour la table 'spip_versions'
--
ALTER TABLE 'spip_versions'
  ADD PRIMARY KEY ('id_version','id_objet','objet'),
  ADD KEY 'id_version' ('id_version'),
  ADD KEY 'id_objet' ('id_objet'),
  ADD KEY 'objet' ('objet');

--
-- Index pour la table 'spip_versions_fragments'
--
ALTER TABLE 'spip_versions_fragments'
  ADD PRIMARY KEY ('id_objet','objet','id_fragment','version_min');

--
-- Index pour la table 'spip_visites'
--
ALTER TABLE 'spip_visites'
  ADD PRIMARY KEY ('date');

--
-- Index pour la table 'spip_visites_articles'
--
ALTER TABLE 'spip_visites_articles'
  ADD PRIMARY KEY ('date','id_article');

[bruno sanchiz]