CREATE TABLE spip_articles (
		id_article INTEGER NOT NULL,
		surtitre text DEFAULT '' NOT NULL COLLATE NOCASE,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		soustitre text DEFAULT '' NOT NULL COLLATE NOCASE,
		id_rubrique bigint(21) DEFAULT '0' NOT NULL,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		chapo mediumtext DEFAULT '' NOT NULL COLLATE NOCASE,
		texte longtext DEFAULT '' NOT NULL COLLATE NOCASE,
		ps mediumtext DEFAULT '' NOT NULL COLLATE NOCASE,
		date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		statut varchar(10) DEFAULT '0' NOT NULL COLLATE NOCASE,
		id_secteur bigint(21) DEFAULT '0' NOT NULL,
		maj TIMESTAMP,
		export VARCHAR(10) DEFAULT 'oui' COLLATE NOCASE,
		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) DEFAULT '' NOT NULL COLLATE NOCASE,
		date_modif datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		lang VARCHAR(10) DEFAULT '' NOT NULL COLLATE NOCASE,
		langue_choisie VARCHAR(3) DEFAULT 'non' COLLATE NOCASE,
		id_trad bigint(21) DEFAULT '0' NOT NULL,
		nom_site tinytext DEFAULT '' NOT NULL COLLATE NOCASE,
		url_site VARCHAR(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		virtuel VARCHAR(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_article));
CREATE TABLE spip_auteurs (
		id_auteur INTEGER NOT NULL,
		nom text DEFAULT '' NOT NULL COLLATE NOCASE,
		bio text DEFAULT '' NOT NULL COLLATE NOCASE,
		email tinytext DEFAULT '' NOT NULL COLLATE NOCASE,
		nom_site tinytext DEFAULT '' NOT NULL COLLATE NOCASE,
		url_site text DEFAULT '' NOT NULL COLLATE NOCASE,
		login VARCHAR(255) COLLATE BINARY,
		pass tinytext DEFAULT '' NOT NULL COLLATE NOCASE,
		low_sec tinytext DEFAULT '' NOT NULL COLLATE NOCASE,
		statut varchar(255)  DEFAULT '0' NOT NULL COLLATE NOCASE,
		webmestre varchar(3)  DEFAULT 'non' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		pgp TEXT DEFAULT '' NOT NULL COLLATE NOCASE,
		htpass tinytext DEFAULT '' NOT NULL COLLATE NOCASE,
		en_ligne datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		alea_actuel tinytext COLLATE NOCASE,
		alea_futur tinytext COLLATE NOCASE,
		prefs tinytext COLLATE NOCASE,
		cookie_oubli tinytext COLLATE NOCASE,
		source VARCHAR(10) DEFAULT 'spip' NOT NULL COLLATE NOCASE,
		lang VARCHAR(10) DEFAULT '' NOT NULL COLLATE NOCASE,
		imessage VARCHAR(3) COLLATE NOCASE,
		messagerie VARCHAR(3) COLLATE NOCASE,
		PRIMARY KEY (id_auteur));
CREATE TABLE spip_auteurs_liens (
		id_auteur bigint(21) DEFAULT '0' NOT NULL,
		id_objet bigint(21) DEFAULT '0' NOT NULL,
		objet VARCHAR (25) DEFAULT '' NOT NULL COLLATE NOCASE,
		vu VARCHAR(6) DEFAULT 'non' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_auteur,id_objet,objet));
CREATE TABLE spip_breves (
		id_breve INTEGER NOT NULL,
		date_heure datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		texte longtext DEFAULT '' NOT NULL COLLATE NOCASE,
		lien_titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		lien_url text DEFAULT '' NOT NULL COLLATE NOCASE,
		statut varchar(6)  DEFAULT '0' NOT NULL COLLATE NOCASE,
		id_rubrique bigint(21) DEFAULT '0' NOT NULL,
		lang VARCHAR(10) DEFAULT '' NOT NULL COLLATE NOCASE,
		langue_choisie VARCHAR(3) DEFAULT 'non' COLLATE NOCASE,
		maj TIMESTAMP,
		PRIMARY KEY (id_breve));
CREATE TABLE spip_depots (
		id_depot INTEGER NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		type varchar(10) DEFAULT '' NOT NULL COLLATE NOCASE,
		url_serveur varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		url_brouteur varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		url_archives varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		url_commits varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		xml_paquets varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		sha_paquets varchar(40) DEFAULT '' NOT NULL COLLATE NOCASE,
		nbr_paquets integer DEFAULT 0 NOT NULL,
		nbr_plugins integer DEFAULT 0 NOT NULL,
		nbr_autres integer DEFAULT 0 NOT NULL,
		maj timestamp,
		PRIMARY KEY (id_depot));
CREATE TABLE spip_depots_plugins (
		id_depot bigint(21) NOT NULL DEFAULT 0,
		id_plugin bigint(21) NOT NULL DEFAULT 0,
		PRIMARY KEY (id_depot, id_plugin));
CREATE TABLE spip_documents (
		id_document INTEGER NOT NULL,
		id_vignette bigint(21) DEFAULT '0' NOT NULL,
		extension VARCHAR(10) DEFAULT '' NOT NULL COLLATE NOCASE,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		fichier text NOT NULL DEFAULT '' COLLATE NOCASE,
		taille bigint,
		largeur integer,
		hauteur integer,
		media varchar(10) DEFAULT 'file' NOT NULL COLLATE NOCASE,
		mode varchar(10) DEFAULT 'document' NOT NULL COLLATE NOCASE,
		distant VARCHAR(3) DEFAULT 'non' COLLATE NOCASE,
		statut varchar(10) DEFAULT '0' NOT NULL COLLATE NOCASE,
		credits varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		date_publication datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		brise tinyint DEFAULT 0,
		maj TIMESTAMP,
		PRIMARY KEY (id_document));
CREATE TABLE spip_documents_liens (
		id_document bigint(21) DEFAULT '0' NOT NULL,
		id_objet bigint(21) DEFAULT '0' NOT NULL,
		objet VARCHAR (25) DEFAULT '' NOT NULL COLLATE NOCASE,
		vu VARCHAR(255) DEFAULT 'non' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_document,id_objet,objet));
CREATE TABLE spip_forum (
		id_forum INTEGER NOT NULL,
		id_objet bigint(21) DEFAULT '0' NOT NULL,
		objet VARCHAR (25) DEFAULT '' NOT NULL COLLATE NOCASE,
		id_parent bigint(21) DEFAULT '0' NOT NULL,
		id_thread bigint(21) DEFAULT '0' NOT NULL,
		date_heure datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		date_thread datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		texte mediumtext DEFAULT '' NOT NULL COLLATE NOCASE,
		auteur text DEFAULT '' NOT NULL COLLATE NOCASE,
		email_auteur text DEFAULT '' NOT NULL COLLATE NOCASE,
		nom_site text DEFAULT '' NOT NULL COLLATE NOCASE,
		url_site text DEFAULT '' NOT NULL COLLATE NOCASE,
		statut varchar(8) DEFAULT '0' NOT NULL COLLATE NOCASE,
		ip varchar(40) DEFAULT '' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		id_auteur bigint DEFAULT '0' NOT NULL,
		PRIMARY KEY (id_forum));
CREATE TABLE spip_groupes_mots (
		id_groupe INTEGER NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		texte longtext DEFAULT '' NOT NULL COLLATE NOCASE,
		unseul varchar(3) DEFAULT '' NOT NULL COLLATE NOCASE,
		obligatoire varchar(3) DEFAULT '' NOT NULL COLLATE NOCASE,
		tables_liees text DEFAULT '' NOT NULL COLLATE NOCASE,
		minirezo varchar(3) DEFAULT '' NOT NULL COLLATE NOCASE,
		comite varchar(3) DEFAULT '' NOT NULL COLLATE NOCASE,
		forum varchar(3) DEFAULT '' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		PRIMARY KEY (id_groupe));
CREATE TABLE spip_jobs (
		id_job INTEGER NOT NULL,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		fonction varchar(255) NOT NULL DEFAULT '' COLLATE NOCASE,
		args longblob DEFAULT '' NOT NULL,
		md5args char(32) NOT NULL default '' COLLATE NOCASE,
		inclure varchar(255) NOT NULL DEFAULT '' COLLATE NOCASE,
		priorite smallint(6) NOT NULL default 0,
		date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		status tinyint NOT NULL default 1,
		PRIMARY KEY (id_job));
CREATE TABLE spip_jobs_liens (
		id_job bigint(21) DEFAULT '0' NOT NULL,
		id_objet bigint(21) DEFAULT '0' NOT NULL,
		objet VARCHAR (25) DEFAULT '' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_job,id_objet,objet));
CREATE TABLE 'spip_messages' (
		id_message INTEGER NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		texte longtext DEFAULT '' NOT NULL COLLATE NOCASE,
		type varchar(6) DEFAULT '' NOT NULL COLLATE NOCASE,
		date_heure datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		date_fin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		rv varchar(3) DEFAULT '' NOT NULL COLLATE NOCASE,
		statut varchar(6)  DEFAULT '0' NOT NULL COLLATE NOCASE,
		id_auteur bigint(21) DEFAULT 0 NOT NULL,
		destinataires text DEFAULT '' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		PRIMARY KEY (id_message));
CREATE TABLE spip_meta (
		nom VARCHAR (255) NOT NULL DEFAULT '' COLLATE NOCASE,
		valeur text DEFAULT '' COLLATE NOCASE,
		impt VARCHAR(255) DEFAULT 'oui' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		PRIMARY KEY (nom));
CREATE TABLE spip_mots (
		id_mot INTEGER NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		texte longtext DEFAULT '' NOT NULL COLLATE NOCASE,
		id_groupe bigint(21) DEFAULT 0 NOT NULL,
		type text DEFAULT '' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		PRIMARY KEY (id_mot));
CREATE TABLE spip_mots_liens (
		id_mot bigint(21) DEFAULT '0' NOT NULL,
		id_objet bigint(21) DEFAULT '0' NOT NULL,
		objet VARCHAR (25) DEFAULT '' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_mot,id_objet,objet));
CREATE TABLE spip_paquets (
		id_paquet INTEGER NOT NULL,
		id_plugin bigint(21) NOT NULL DEFAULT 0,
		prefixe varchar(30) DEFAULT '' NOT NULL COLLATE NOCASE,
		logo varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		version varchar(24) DEFAULT '' NOT NULL COLLATE NOCASE,
		version_base varchar(24) DEFAULT '' NOT NULL COLLATE NOCASE,
		compatibilite_spip varchar(24) DEFAULT '' NOT NULL COLLATE NOCASE,
		branches_spip varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		description text DEFAULT '' NOT NULL COLLATE NOCASE,
		auteur text DEFAULT '' NOT NULL COLLATE NOCASE,
		credit text DEFAULT '' NOT NULL COLLATE NOCASE,
		licence text DEFAULT '' NOT NULL COLLATE NOCASE,
		copyright text DEFAULT '' NOT NULL COLLATE NOCASE,
		lien_doc text DEFAULT '' NOT NULL COLLATE NOCASE,
		lien_demo text DEFAULT '' NOT NULL COLLATE NOCASE,
		lien_dev text DEFAULT '' NOT NULL COLLATE NOCASE,
		etat varchar(16) DEFAULT '' NOT NULL COLLATE NOCASE,
		etatnum int(1) DEFAULT 0 NOT NULL,
		dependances text DEFAULT '' NOT NULL COLLATE NOCASE,
		date_crea datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		date_modif datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		id_depot bigint(21) DEFAULT 0 NOT NULL,
		nom_archive VARCHAR(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		nbo_archive integer DEFAULT 0 NOT NULL,
		maj_archive datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		src_archive VARCHAR(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		traductions text DEFAULT '' NOT NULL COLLATE NOCASE,
		actif varchar(3) DEFAULT 'non' NOT NULL COLLATE NOCASE,
		installe varchar(3) DEFAULT 'non' NOT NULL COLLATE NOCASE,
		recent int(2) DEFAULT 0 NOT NULL,
		maj_version VARCHAR(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		superieur varchar(3) DEFAULT 'non' NOT NULL COLLATE NOCASE,
		obsolete varchar(3) DEFAULT 'non' NOT NULL COLLATE NOCASE,
		attente varchar(3) DEFAULT 'non' NOT NULL COLLATE NOCASE,
		constante VARCHAR(30) DEFAULT '' NOT NULL COLLATE NOCASE,
		signature VARCHAR(32) DEFAULT '' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_paquet));
CREATE TABLE spip_petitions (
		id_petition INTEGER NOT NULL,
		id_article bigint(21) DEFAULT '0' NOT NULL,
		email_unique CHAR (3) DEFAULT '' NOT NULL COLLATE NOCASE,
		site_obli CHAR (3) DEFAULT '' NOT NULL COLLATE NOCASE,
		site_unique CHAR (3) DEFAULT '' NOT NULL COLLATE NOCASE,
		message CHAR (3) DEFAULT '' NOT NULL COLLATE NOCASE,
		texte LONGTEXT DEFAULT '' NOT NULL COLLATE NOCASE,
		statut VARCHAR (10) DEFAULT 'publie' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		PRIMARY KEY (id_petition));
CREATE TABLE spip_plugins (
		id_plugin INTEGER NOT NULL,
		prefixe varchar(30) DEFAULT '' NOT NULL COLLATE NOCASE,
		nom text DEFAULT '' NOT NULL COLLATE NOCASE,
		slogan text DEFAULT '' NOT NULL COLLATE NOCASE,
		categorie varchar(100) DEFAULT '' NOT NULL COLLATE NOCASE,
		tags text DEFAULT '' NOT NULL COLLATE NOCASE,
		vmax varchar(24) DEFAULT '' NOT NULL COLLATE NOCASE,
		date_crea datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		date_modif datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		compatibilite_spip varchar(24) DEFAULT '' NOT NULL COLLATE NOCASE,
		branches_spip varchar(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_plugin));
CREATE TABLE spip_referers (
		referer_md5 bigint UNSIGNED NOT NULL,
		date DATE NOT NULL DEFAULT '0000-00-00',
		referer VARCHAR (255) COLLATE NOCASE,
		visites int UNSIGNED NOT NULL,
		visites_jour int UNSIGNED NOT NULL,
		visites_veille int UNSIGNED NOT NULL,
		maj TIMESTAMP,
		PRIMARY KEY (referer_md5));
CREATE TABLE spip_referers_articles (
		id_article int UNSIGNED NOT NULL,
		referer_md5 bigint UNSIGNED NOT NULL,
		referer VARCHAR (255) DEFAULT '' NOT NULL COLLATE NOCASE,
		visites int UNSIGNED NOT NULL,
		maj TIMESTAMP,
		PRIMARY KEY (id_article, referer_md5));
CREATE TABLE spip_resultats (
		recherche char(16) DEFAULT '' NOT NULL COLLATE NOCASE,
		id INT UNSIGNED NOT NULL,
		points INT UNSIGNED DEFAULT '0' NOT NULL,
		table_objet varchar(30) DEFAULT '' NOT NULL COLLATE NOCASE,
		serveur char(16) DEFAULT '' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP);
CREATE TABLE spip_rubriques (
		id_rubrique INTEGER NOT NULL,
		id_parent bigint(21) DEFAULT '0' NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		texte longtext DEFAULT '' NOT NULL COLLATE NOCASE,
		id_secteur bigint(21) DEFAULT '0' NOT NULL,
		maj TIMESTAMP,
		statut varchar(10) DEFAULT '0' NOT NULL COLLATE NOCASE,
		date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		lang VARCHAR(10) DEFAULT '' NOT NULL COLLATE NOCASE,
		langue_choisie VARCHAR(3) DEFAULT 'non' COLLATE NOCASE,
		statut_tmp varchar(10) DEFAULT '0' NOT NULL COLLATE NOCASE,
		date_tmp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		profondeur smallint(5) DEFAULT '0' NOT NULL,
		PRIMARY KEY (id_rubrique));
CREATE TABLE spip_signatures (
		id_signature INTEGER NOT NULL,
		id_petition bigint(21) DEFAULT '0' NOT NULL,
		date_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		nom_email text DEFAULT '' NOT NULL COLLATE NOCASE,
		ad_email text DEFAULT '' NOT NULL COLLATE NOCASE,
		nom_site text DEFAULT '' NOT NULL COLLATE NOCASE,
		url_site text DEFAULT '' NOT NULL COLLATE NOCASE,
		message mediumtext DEFAULT '' NOT NULL COLLATE NOCASE,
		statut varchar(10) DEFAULT '0' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		PRIMARY KEY (id_signature));
CREATE TABLE spip_syndic (
		id_syndic INTEGER NOT NULL,
		id_rubrique bigint(21) DEFAULT '0' NOT NULL,
		id_secteur bigint(21) DEFAULT '0' NOT NULL,
		nom_site text DEFAULT '' NOT NULL COLLATE NOCASE,
		url_site text DEFAULT '' NOT NULL COLLATE NOCASE,
		url_syndic text DEFAULT '' NOT NULL COLLATE NOCASE,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		syndication VARCHAR(3) DEFAULT '' NOT NULL COLLATE NOCASE,
		statut varchar(10) DEFAULT '0' NOT NULL COLLATE NOCASE,
		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) DEFAULT 'non' COLLATE NOCASE,
		miroir VARCHAR(3) DEFAULT 'non' COLLATE NOCASE,
		oubli VARCHAR(3) DEFAULT 'non' COLLATE NOCASE,
		resume VARCHAR(3) DEFAULT 'oui' COLLATE NOCASE,
		PRIMARY KEY (id_syndic));
CREATE TABLE spip_syndic_articles (
		id_syndic_article INTEGER NOT NULL,
		id_syndic bigint(21) DEFAULT '0' NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		url VARCHAR(255) DEFAULT '' NOT NULL COLLATE NOCASE,
		date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		lesauteurs text DEFAULT '' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		statut varchar(10) DEFAULT '0' NOT NULL COLLATE NOCASE,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		lang VARCHAR(10) DEFAULT '' NOT NULL COLLATE NOCASE,
		url_source TINYTEXT DEFAULT '' NOT NULL COLLATE NOCASE,
		source TINYTEXT DEFAULT '' NOT NULL COLLATE NOCASE,
		tags TEXT DEFAULT '' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_syndic_article));
CREATE TABLE spip_types_documents (
		extension varchar(10) DEFAULT '' NOT NULL,
		titre text DEFAULT '' NOT NULL COLLATE NOCASE,
		descriptif text DEFAULT '' NOT NULL COLLATE NOCASE,
		mime_type varchar(100) DEFAULT '' NOT NULL COLLATE NOCASE,
		inclus VARCHAR(255) DEFAULT 'non'  NOT NULL COLLATE NOCASE,
		upload VARCHAR(255) DEFAULT 'oui'  NOT NULL COLLATE NOCASE,
		media_defaut varchar(10) DEFAULT 'file' NOT NULL COLLATE NOCASE,
		maj TIMESTAMP,
		PRIMARY KEY (extension));
CREATE TABLE 'spip_urls' (
		id_parent bigint(21) DEFAULT '0' NOT NULL,
		url VARCHAR(255) NOT NULL DEFAULT '' COLLATE NOCASE,
		type varchar(15) DEFAULT 'article' NOT NULL COLLATE NOCASE,
		id_objet bigint(21) NOT NULL DEFAULT 0,
		date DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,
		segments SMALLINT(3) DEFAULT '1' NOT NULL,
		perma TINYINT(1) DEFAULT '0' NOT NULL,
		PRIMARY KEY (id_parent, url));
CREATE TABLE 'spip_versions' (
		id_version bigint(21) DEFAULT 0 NOT NULL,
		id_objet bigint(21) DEFAULT 0 NOT NULL,
		objet VARCHAR (25) DEFAULT '' NOT NULL COLLATE NOCASE,
		date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		id_auteur VARCHAR(23) DEFAULT '' NOT NULL COLLATE NOCASE,
		titre_version text DEFAULT '' NOT NULL COLLATE NOCASE,
		permanent char(3) DEFAULT '' NOT NULL COLLATE NOCASE,
		champs text DEFAULT '' NOT NULL COLLATE NOCASE,
		PRIMARY KEY (id_version, id_objet, objet));
CREATE TABLE 'spip_versions_fragments' (
		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_objet bigint(21) NOT NULL DEFAULT 0,
		objet VARCHAR (25) DEFAULT '' NOT NULL COLLATE NOCASE,
		compress tinyint NOT NULL DEFAULT 0,
		fragment longblob,
		PRIMARY KEY (id_objet, objet, id_fragment, version_min));
CREATE TABLE spip_visites (
		date DATE NOT NULL DEFAULT '0000-00-00',
		visites int UNSIGNED DEFAULT '0' NOT NULL,
		maj TIMESTAMP,
		PRIMARY KEY (date));
CREATE TABLE spip_visites_articles (
		date DATE NOT NULL DEFAULT '0000-00-00',
		id_article int UNSIGNED NOT NULL,
		visites int UNSIGNED DEFAULT '0' NOT NULL,
		maj TIMESTAMP,
		PRIMARY KEY (date, id_article));
CREATE INDEX spip_articles_id_rubrique ON spip_articles (id_rubrique);
CREATE INDEX spip_articles_id_secteur ON spip_articles (id_secteur);
CREATE INDEX spip_articles_id_trad ON spip_articles (id_trad);
CREATE INDEX spip_articles_lang ON spip_articles (lang);
CREATE INDEX spip_articles_statut ON spip_articles (statut, date);
CREATE INDEX spip_auteurs_en_ligne ON spip_auteurs (en_ligne);
CREATE INDEX spip_auteurs_liens_id_auteur ON spip_auteurs_liens (id_auteur);
CREATE INDEX spip_auteurs_liens_id_objet ON spip_auteurs_liens (id_objet);
CREATE INDEX spip_auteurs_liens_objet ON spip_auteurs_liens (objet);
CREATE INDEX spip_auteurs_login ON spip_auteurs (login);
CREATE INDEX spip_auteurs_statut ON spip_auteurs (statut);
CREATE INDEX spip_breves_id_rubrique ON spip_breves (id_rubrique);
CREATE INDEX spip_documents_extension ON spip_documents (extension);
CREATE INDEX spip_documents_id_vignette ON spip_documents (id_vignette);
CREATE INDEX spip_documents_liens_id_document ON spip_documents_liens (id_document);
CREATE INDEX spip_documents_liens_id_objet ON spip_documents_liens (id_objet);
CREATE INDEX spip_documents_liens_objet ON spip_documents_liens (objet);
CREATE INDEX spip_documents_mode ON spip_documents (mode);
CREATE INDEX spip_forum_id_auteur ON spip_forum (id_auteur);
CREATE INDEX spip_forum_id_parent ON spip_forum (id_parent);
CREATE INDEX spip_forum_id_thread ON spip_forum (id_thread);
CREATE INDEX spip_forum_optimal ON spip_forum (statut,id_parent,id_objet,objet,date_heure);
CREATE INDEX spip_jobs_date ON spip_jobs (date);
CREATE INDEX spip_jobs_liens_id_job ON spip_jobs_liens (id_job);
CREATE INDEX spip_jobs_status ON spip_jobs (status);
CREATE INDEX spip_messages_id_auteur ON spip_messages (id_auteur);
CREATE INDEX spip_mots_id_groupe ON spip_mots (id_groupe);
CREATE INDEX spip_mots_liens_id_mot ON spip_mots_liens (id_mot);
CREATE INDEX spip_mots_liens_id_objet ON spip_mots_liens (id_objet);
CREATE INDEX spip_mots_liens_objet ON spip_mots_liens (objet);
CREATE INDEX spip_paquets_id_plugin ON spip_paquets (id_plugin);
CREATE UNIQUE INDEX spip_petitions_id_article ON spip_petitions (id_article);
CREATE INDEX spip_plugins_prefixe ON spip_plugins (prefixe);
CREATE INDEX spip_referers_articles_referer_md5 ON spip_referers_articles (referer_md5);
CREATE INDEX spip_rubriques_id_parent ON spip_rubriques (id_parent);
CREATE INDEX spip_rubriques_lang ON spip_rubriques (lang);
CREATE INDEX spip_signatures_id_petition ON spip_signatures (id_petition);
CREATE INDEX spip_signatures_statut ON spip_signatures (statut);
CREATE INDEX spip_syndic_articles_id_syndic ON spip_syndic_articles (id_syndic);
CREATE INDEX spip_syndic_articles_statut ON spip_syndic_articles (statut);
CREATE INDEX spip_syndic_articles_url ON spip_syndic_articles (url);
CREATE INDEX spip_syndic_id_rubrique ON spip_syndic (id_rubrique);
CREATE INDEX spip_syndic_id_secteur ON spip_syndic (id_secteur);
CREATE INDEX spip_syndic_statut ON spip_syndic (statut, date_syndic);
CREATE INDEX spip_types_documents_inclus ON spip_types_documents (inclus);
CREATE INDEX spip_urls_type ON spip_urls (type, id_objet);
CREATE INDEX spip_versions_id_objet ON spip_versions (id_objet);
CREATE INDEX spip_versions_id_version ON spip_versions (id_version);
CREATE INDEX spip_versions_objet ON spip_versions (objet);