[Sommaire] [Imprimer]

   1  [action]
   2  CREATE TABLE spip_articles (
   3    id_article bigint NOT NULL default '0',
   4    surtitre text NOT NULL,
   5    titre text NOT NULL,
   6    soustitre text NOT NULL,
   7    id_rubrique bigint NOT NULL default '0',
   8    descriptif text NOT NULL,
   9    chapo text NOT NULL,
  10    texte text NOT NULL,
  11    ps text NOT NULL,
  12    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
  13    statut varchar(10) NOT NULL default '0',
  14    id_secteur bigint NOT NULL default '0',
  15    maj varchar(19) default NULL,
  16    export varchar(10) default 'oui',
  17    date_redac varchar(19) NOT NULL default '0000-00-00 00:00:00',
  18    visites int NOT NULL default '0',
  19    referers int NOT NULL default '0',
  20    popularite float NOT NULL default '0',
  21    accepter_forum varchar(14) NOT NULL default '',
  22    auteur_modif bigint NOT NULL default '0',
  23    date_modif varchar(19) NOT NULL default '0000-00-00 00:00:00',
  24    extra text NOT NULL,
  25    lang varchar(10) NOT NULL default '',
  26    langue_choisie char(3) NOT NULL default 'non',
  27    id_trad bigint NOT NULL default '0',
  28    nom_site text NOT NULL,
  29    url_site varchar(255) NOT NULL default '',
  30    version_id INT,
  31    activer_historique VARCHAR( 3 ) NOT NULL 'non',
  32    PRIMARY KEY  (id_article)
  33  );
  34  [action]
  35  CREATE TABLE spip_articles_historique (
  36    id_article_historique bigint NOT NULL default '0',
  37    id_article bigint NOT NULL default '0',
  38    surtitre text NOT NULL,
  39    titre text NOT NULL,
  40    soustitre text NOT NULL,
  41    descriptif text NOT NULL,
  42    chapo text NOT NULL,
  43    texte text NOT NULL,
  44    ps text NOT NULL,
  45    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
  46    extra text NOT NULL,
  47    PRIMARY KEY  (id_article_historique)
  48  );
  49  [action]
  50  CREATE TABLE spip_auteurs (
  51    id_auteur bigint NOT NULL default '0',
  52    nom text NOT NULL,
  53    bio text NOT NULL,
  54    email text NOT NULL,
  55    nom_site text NOT NULL,
  56    url_site text NOT NULL,
  57    login varchar(255) NOT NULL default '',
  58    pass text NOT NULL,
  59    statut varchar(255) NOT NULL default '',
  60    profil bigint NOT NULL default '0',
  61    maj varchar(19) default NULL,
  62    pgp text NOT NULL,
  63    htpass text NOT NULL,
  64    en_ligne varchar(19) NOT NULL default '0000-00-00 00:00:00',
  65    imessage varchar(4) NOT NULL default '',
  66    messagerie varchar(4) NOT NULL default '',
  67    alea_actuel text NOT NULL,
  68    alea_futur text NOT NULL,
  69    prefs text NOT NULL,
  70    cookie_oubli text NOT NULL,
  71    source varchar(10) NOT NULL default 'spip',
  72    lang varchar(20) default NULL,
  73    extra text NOT NULL,
  74    low_sec text NOT NULL,
  75    PRIMARY KEY  (id_auteur)
  76    );
  77  
  78  
  79  [action]
  80  CREATE TABLE spip_auteurs_articles (
  81    id_auteur bigint NOT NULL default '0',
  82    id_article bigint NOT NULL default '0'
  83  );
  84  
  85  [action]
  86  CREATE TABLE spip_auteurs_messages (
  87    id_auteur bigint NOT NULL default '0',
  88    id_message bigint NOT NULL default '0',
  89    vu varchar(4) NOT NULL default ''
  90  );
  91  
  92  [action]
  93  CREATE TABLE spip_auteurs_rubriques (
  94    id_auteur bigint NOT NULL default '0',
  95    id_rubrique bigint NOT NULL default '0'
  96  );
  97  
  98  [action]
  99  CREATE TABLE spip_bookmarks (
 100    id_auteur bigint NOT NULL default '0',
 101    id_objet bigint NOT NULL default '0',
 102    type_bookmark varchar(8) NOT NULL default '',
 103    PRIMARY KEY  (id_auteur,id_objet,type_bookmark)
 104  );
 105  
 106  
 107  [action]
 108  CREATE TABLE spip_breves (
 109    id_breve bigint NOT NULL default '0',
 110    date_heure varchar(19) NOT NULL default '',
 111    titre text NOT NULL,
 112    texte text NOT NULL,
 113    lien_titre text NOT NULL,
 114    lien_url text NOT NULL,
 115    statut varchar(6) NOT NULL default '',
 116    id_rubrique bigint NOT NULL default '0',
 117    maj varchar(19) default NULL,
 118    extra text NOT NULL,
 119    lang varchar(10) NOT NULL default '',
 120    langue_choisie char(3) NOT NULL default 'non',
 121    PRIMARY KEY  (id_breve)
 122  );
 123  
 124  
 125  [action]
 126  CREATE TABLE spip_cm_lists (
 127    lst_id int NOT NULL default '0',
 128    lst_name varchar(255) NOT NULL default '',
 129    lst_comment text NOT NULL,
 130    lst_moderation varchar(10) NOT NULL default '',
 131    lst_moderator_email varchar(255) NOT NULL default '',
 132    lst_subscribe_subject varchar(255) NOT NULL default '',
 133    lst_subscribe_text text NOT NULL,
 134    lst_subject varchar(255) NOT NULL default '',
 135    lst_unsubscribe_subject varchar(255) NOT NULL default '',
 136    lst_unsubscribe_text text NOT NULL,
 137    lst_subject_tag int NOT NULL default '1',
 138    lst_html_skeleton varchar(200) NOT NULL default '',
 139    lst_text_skeleton varchar(200) NOT NULL default '',
 140    lst_nb_articles int NOT NULL default '0',
 141    PRIMARY KEY  (lst_id)
 142  );
 143  
 144  [action]
 145  CREATE TABLE spip_cm_lists_subscribers (
 146    lst_id int NOT NULL default '0',
 147    sub_id bigint NOT NULL default '0',
 148    lsr_mode int NOT NULL default '0',
 149    lsr_id varchar(32) NOT NULL default '',
 150    PRIMARY KEY  (lst_id,sub_id)
 151  );
 152  
 153  [action]
 154  CREATE TABLE spip_cm_pending (
 155    lst_id int NOT NULL default '0',
 156    sub_id bigint NOT NULL default '0',
 157    pnd_action varchar(15) NOT NULL default '',
 158    pnd_mode int NOT NULL default '0',
 159    pnd_action_date int NOT NULL default '0',
 160    pnd_action_id varchar(32) NOT NULL default '',
 161    PRIMARY KEY  (lst_id,sub_id)
 162  );
 163  
 164  
 165  [action]
 166  CREATE TABLE spip_cm_posts (
 167    pst_id bigint NOT NULL default '0',
 168    lst_id int NOT NULL default '0',
 169    pst_date_create varchar(19) NOT NULL default '0000-00-00 00:00:00',
 170    pst_date_update varchar(19) NOT NULL default '0000-00-00 00:00:00',
 171    pst_date_sent varchar(19) NOT NULL default '0000-00-00 00:00:00',
 172    pst_subject varchar(255) NOT NULL default '',
 173    destinataires_specifiques text,
 174    user_group_inactif text,
 175    PRIMARY KEY  (pst_id)
 176  );
 177  
 178  
 179  [action]
 180  CREATE TABLE spip_cm_posts_articles (
 181    article_id bigint NOT NULL default '0',
 182    pst_id bigint NOT NULL default '0',
 183    art_order int NOT NULL default '0'
 184  );
 185  
 186  
 187  [action]
 188  CREATE TABLE spip_cm_posts_done (
 189    pst_id bigint NOT NULL default '0',
 190    id_auteur bigint NOT NULL default '0',
 191    id_sub bigint NOT NULL default '0',
 192    email varchar(255) NOT NULL default '',
 193    PRIMARY KEY  (pst_id,email)
 194  );
 195  
 196  [action]
 197  CREATE TABLE spip_cm_posts_links (
 198    lnk_id bigint NOT NULL default '0',
 199    pst_id bigint NOT NULL default '0',
 200    lnk_name varchar(255) NOT NULL default '',
 201    lnk_url text NOT NULL,
 202    PRIMARY KEY  (lnk_id)
 203  );
 204  
 205  [action]
 206  CREATE TABLE spip_cm_posts_queued (
 207    pst_id bigint NOT NULL default '0',
 208    id_auteur bigint NOT NULL default '0',
 209    id_sub bigint NOT NULL default '0',
 210    email varchar(255) NOT NULL default '',
 211    mode int NOT NULL default '0',
 212    psq_date varchar(19) NOT NULL default '0000-00-00 00:00:00',
 213    PRIMARY KEY  (pst_id,email)
 214  );
 215  
 216  
 217  [action]
 218  CREATE TABLE spip_cm_settings (
 219    set_name varchar(15) NOT NULL default '',
 220    set_value varchar(255) NOT NULL default '',
 221    PRIMARY KEY  (set_name)
 222  );
 223  
 224  
 225  [action]
 226  CREATE TABLE spip_cm_subscribers (
 227    sub_id bigint NOT NULL default '0',
 228    sub_email varchar(255) NOT NULL default '',
 229    sub_first_name varchar(50) NOT NULL default '',
 230    sub_middle_name varchar(50) NOT NULL default '',
 231    sub_last_name varchar(50) NOT NULL default '',
 232    sub_title varchar(10) NOT NULL default '',
 233    sub_profile varchar(32) NOT NULL default '',
 234    PRIMARY KEY  (sub_id)
 235  );
 236  
 237  
 238  [action]
 239  CREATE TABLE spip_cm_user_groups (
 240    id_groupe bigint NOT NULL default '0',
 241    lst_id bigint default NULL,
 242    pst_id bigint default NULL,
 243    titre varchar(255) default NULL,
 244    PRIMARY KEY  (id_groupe)
 245  );
 246  
 247  [action]
 248  CREATE TABLE spip_dernieres_visites (
 249    id_pers bigint NOT NULL default '0',
 250    date varchar(19) NOT NULL default '',
 251    url varchar(200) NOT NULL default '',
 252    titre varchar(100) NOT NULL default '',
 253    PRIMARY KEY  (id_pers)
 254  );
 255  
 256  [action]
 257  CREATE TABLE spip_documents (
 258    id_document bigint NOT NULL default '0',
 259    id_vignette bigint NOT NULL default '0',
 260    id_type bigint NOT NULL default '0',
 261    titre text NOT NULL,
 262    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 263    descriptif text NOT NULL,
 264    fichier varchar(255) NOT NULL default '',
 265    taille int NOT NULL default '0',
 266    largeur int NOT NULL default '0',
 267    hauteur int NOT NULL default '0',
 268    mode_spip varchar(8) NOT NULL default 'vignette',
 269    inclus varchar(4) default 'non',
 270    maj varchar(19) default NULL,
 271    PRIMARY KEY  (id_document)
 272  );
 273  
 274  [action]
 275  CREATE TABLE spip_documents_articles (
 276    id_document bigint NOT NULL default '0',
 277    id_article bigint NOT NULL default '0'
 278  );
 279  
 280  
 281  [action]
 282  CREATE TABLE spip_documents_breves (
 283    id_document bigint NOT NULL default '0',
 284    id_breve bigint NOT NULL default '0'
 285  );
 286  
 287  
 288  [action]
 289  CREATE TABLE spip_documents_rubriques (
 290    id_document bigint NOT NULL default '0',
 291    id_rubrique bigint NOT NULL default '0'
 292  );
 293  
 294  
 295  [action]
 296  CREATE TABLE spip_forum (
 297    id_forum bigint NOT NULL default '0',
 298    id_parent bigint NOT NULL default '0',
 299    id_rubrique bigint NOT NULL default '0',
 300    id_article bigint NOT NULL default '0',
 301    id_breve bigint NOT NULL default '0',
 302    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 303    titre text NOT NULL,
 304    texte text NOT NULL,
 305    auteur text NOT NULL,
 306    email_auteur text NOT NULL,
 307    nom_site text NOT NULL,
 308    url_site text NOT NULL,
 309    statut varchar(8) NOT NULL default '',
 310    ip varchar(16) default NULL,
 311    maj varchar(19) default NULL,
 312    id_auteur bigint NOT NULL default '0',
 313    id_message bigint NOT NULL default '0',
 314    id_syndic bigint NOT NULL default '0',
 315    profil_auteur int default '0',
 316    alerte_mail varchar(4) NOT NULL default 'oui',
 317    PRIMARY KEY  (id_forum)
 318  );
 319  
 320  [action]
 321  CREATE TABLE spip_forum_cache (
 322    id_forum bigint NOT NULL default '0',
 323    id_rubrique bigint NOT NULL default '0',
 324    id_article bigint NOT NULL default '0',
 325    id_breve bigint NOT NULL default '0',
 326    id_syndic bigint NOT NULL default '0',
 327    fichier varchar(150)  NOT NULL default '',
 328    maj varchar(19) default NULL,
 329    PRIMARY KEY  (fichier,id_forum,id_article,id_rubrique,id_breve,id_syndic)
 330  );
 331  
 332  [action]
 333  CREATE TABLE spip_groupes_mots (
 334    id_groupe bigint NOT NULL default '0',
 335    titre text NOT NULL,
 336    unseul varchar(4) NOT NULL default '',
 337    obligatoire varchar(4) NOT NULL default '',
 338    articles varchar(4) NOT NULL default '',
 339    breves varchar(4) NOT NULL default '',
 340    rubriques varchar(4) NOT NULL default '',
 341    syndic varchar(4) NOT NULL default '',
 342    auteurs varchar(4) NOT NULL default '',
 343    forum varchar(4) NOT NULL default '',
 344    cm varchar(4) NOT NULL default '',
 345    maj varchar(19) default NULL,
 346    profils int NOT NULL default '0',
 347    PRIMARY KEY  (id_groupe)
 348  );
 349  
 350  [action]
 351  CREATE TABLE spip_index_articles (
 352    hash varchar(255) NOT NULL default '0',
 353    points int  NOT NULL default '0',
 354    id_article int  NOT NULL default '0'
 355  );
 356  
 357  [action]
 358  CREATE TABLE spip_index_auteurs (
 359    hash varchar(255) NOT NULL default '0',
 360    points int  NOT NULL default '0',
 361    id_auteur int  NOT NULL default '0'
 362  );
 363  
 364  [action]
 365  CREATE TABLE spip_index_breves (
 366    hash varchar(255) NOT NULL default '0',
 367    points int  NOT NULL default '0',
 368    id_breve int  NOT NULL default '0'
 369  );
 370  
 371  [action]
 372  CREATE TABLE spip_index_dico (
 373    hash varchar(255) NOT NULL default '0',
 374    dico varchar(30) NOT NULL default '',
 375    PRIMARY KEY  (dico)
 376  );
 377  
 378  [action]
 379  CREATE TABLE spip_index_mots (
 380    hash varchar(255) NOT NULL default '0',
 381    points int  NOT NULL default '0',
 382    id_mot int  NOT NULL default '0'
 383  );
 384  
 385  
 386  [action]
 387  CREATE TABLE spip_index_rubriques (
 388    hash varchar(255) NOT NULL default '0',
 389    points int  NOT NULL default '0',
 390    id_rubrique int  NOT NULL default '0'
 391  );
 392  
 393  [action]
 394  CREATE TABLE spip_index_syndic (
 395    hash varchar(255) NOT NULL default '0',
 396    points int  NOT NULL default '0',
 397    id_syndic int  NOT NULL default '0'
 398  );
 399  
 400  
 401  [action]
 402  CREATE TABLE spip_liens (
 403    contenant varchar(10) NOT NULL default '',
 404    lien_interne varchar(10) NOT NULL default '',
 405    lien_externe varchar(255) NOT NULL default '',
 406    PRIMARY KEY  (contenant,lien_interne,lien_externe)
 407  );
 408  
 409  [action]
 410  CREATE TABLE spip_lock_mots (
 411    lockID varchar(100) NOT NULL default '',
 412    lockTable varchar(100) NOT NULL default '',
 413    lockStamp varchar(100) NOT NULL default '',
 414    PRIMARY KEY  (lockID)
 415  );
 416  
 417  [action]
 418  CREATE TABLE spip_messages (
 419    id_message bigint NOT NULL default '0',
 420    titre text NOT NULL,
 421    texte text NOT NULL,
 422    type varchar(6) NOT NULL default '',
 423    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 424    rv varchar(4) NOT NULL default '',
 425    statut varchar(6) NOT NULL default '',
 426    id_auteur bigint NOT NULL default '0',
 427    maj varchar(19) default NULL,
 428    date_fin varchar(19) NOT NULL default '0000-00-00 00:00:00',
 429    PRIMARY KEY  (id_message)
 430  );
 431  
 432  [action]
 433  CREATE TABLE spip_meta (
 434    nom varchar(255) NOT NULL default '',
 435    valeur varchar(255) default '',
 436    maj varchar(19) default NULL,
 437    PRIMARY KEY  (nom)
 438  );
 439  
 440  [action]
 441  CREATE TABLE spip_mots (
 442    id_mot bigint NOT NULL default '0',
 443    id_root bigint  NOT NULL default '0',
 444    l bigint  default NULL,
 445    r bigint  default NULL,
 446    streh bigint  default NULL,
 447    level_mot bigint  default NULL,
 448    strna varchar(100) default NULL,
 449    type_mot varchar(100) NOT NULL default '',
 450    titre text NOT NULL,
 451    descriptif text NOT NULL,
 452    texte text NOT NULL,
 453    id_groupe bigint NOT NULL default '0',
 454    maj varchar(19) default NULL,
 455    extra text NOT NULL,
 456    PRIMARY KEY  (id_mot)
 457  );
 458  
 459  [action]
 460  CREATE TABLE spip_mots_articles (
 461    id_mot bigint NOT NULL default '0',
 462    id_article bigint NOT NULL default '0'
 463  );
 464  
 465  [action]
 466  CREATE TABLE spip_mots_auteurs (
 467    id_mot bigint  NOT NULL default '0',
 468    id_auteur bigint  NOT NULL default '0'
 469  );
 470  
 471  [action]
 472  CREATE TABLE spip_mots_breves (
 473    id_mot bigint NOT NULL default '0',
 474    id_breve bigint NOT NULL default '0'
 475  );
 476  
 477  [action]
 478  CREATE TABLE spip_mots_cm (
 479    id_mot bigint NOT NULL default '0',
 480    id_groupe bigint NOT NULL default '0'
 481  );
 482  
 483  [action]
 484  CREATE TABLE spip_mots_forum (
 485    id_mot bigint NOT NULL default '0',
 486    id_forum bigint NOT NULL default '0'
 487  );
 488  
 489  [action]
 490  CREATE TABLE spip_mots_rubriques (
 491    id_mot bigint NOT NULL default '0',
 492    id_rubrique bigint NOT NULL default '0'
 493  );
 494  
 495  [action]
 496  CREATE TABLE spip_mots_syndic (
 497    id_mot bigint NOT NULL default '0',
 498    id_syndic bigint NOT NULL default '0'
 499  );
 500  
 501  [action]
 502  CREATE TABLE spip_petitions (
 503    id_article bigint NOT NULL default '0',
 504    email_unique varchar(4) NOT NULL default '',
 505    site_obli varchar(4) NOT NULL default '',
 506    site_unique varchar(4) NOT NULL default '',
 507    message varchar(4) NOT NULL default '',
 508    texte text NOT NULL,
 509    maj varchar(19) default NULL,
 510    PRIMARY KEY  (id_article)
 511  );
 512  
 513  [action]
 514  CREATE TABLE spip_profils (
 515    poids int NOT NULL default '0',
 516    intitule varchar(255) NOT NULL default '',
 517    PRIMARY KEY  (poids)
 518  );
 519  
 520  [action]
 521  CREATE TABLE spip_referers (
 522    referer_md5 varchar(255) NOT NULL default '0',
 523    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 524    referer varchar(255) NOT NULL default '',
 525    visites int  NOT NULL default '0',
 526    visites_jour int  NOT NULL default '0',
 527    maj varchar(19) default NULL,
 528    PRIMARY KEY  (referer_md5)
 529  );
 530  
 531  [action]
 532  CREATE TABLE spip_referers_articles (
 533    id_article int  NOT NULL default '0',
 534    referer_md5 varchar(255) NOT NULL default '0',
 535    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 536    referer varchar(255) NOT NULL default '',
 537    visites int  NOT NULL default '0',
 538    maj varchar(19) default NULL,
 539    PRIMARY KEY  (id_article,referer_md5)
 540  );
 541  
 542  [action]
 543  CREATE TABLE spip_referers_temp (
 544    ip varchar(15) NOT NULL default '0.0.0.0',
 545    referer varchar(255) NOT NULL default '',
 546    referer_md5 varchar(255) NOT NULL default '0',
 547    type_referer varchar(8) NOT NULL default 'article',
 548    id_objet int  NOT NULL default '0',
 549    maj varchar(19) default NULL,
 550    PRIMARY KEY  (type_referer,id_objet,referer_md5,ip)
 551  );
 552  
 553  [action]
 554  CREATE TABLE spip_rubriques (
 555    id_rubrique bigint NOT NULL default '0',
 556    id_parent bigint NOT NULL default '0',
 557    titre text NOT NULL,
 558    descriptif text NOT NULL,
 559    texte text NOT NULL,
 560    id_secteur bigint NOT NULL default '0',
 561    maj varchar(19) default NULL,
 562    export varchar(10) default 'oui',
 563    id_import bigint default '0',
 564    statut varchar(10) NOT NULL default '',
 565    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 566    extra text NOT NULL,
 567    lang varchar(10) NOT NULL default '',
 568    langue_choisie char(3) NOT NULL default 'non',
 569    PRIMARY KEY  (id_rubrique)
 570  );
 571  
 572  [action]
 573  CREATE TABLE spip_signatures (
 574    id_signature bigint NOT NULL default '0',
 575    id_article bigint NOT NULL default '0',
 576    date_time varchar(19) NOT NULL default '0000-00-00 00:00:00',
 577    nom_email text NOT NULL,
 578    ad_email text NOT NULL,
 579    nom_site text NOT NULL,
 580    url_site text NOT NULL,
 581    message text NOT NULL,
 582    statut varchar(10) NOT NULL default '',
 583    maj varchar(19) default NULL,
 584    PRIMARY KEY  (id_signature)
 585  );
 586  
 587  [action]
 588  CREATE TABLE spip_sondages (
 589    id_article bigint NOT NULL default '0',
 590    actif char(3) NOT NULL default 'oui',
 591    affichage_public char(3) NOT NULL default 'non',
 592    PRIMARY KEY  (id_article)
 593  );
 594  
 595  [action]
 596  CREATE TABLE spip_sondages_reponses (
 597    id_article bigint NOT NULL default '0',
 598    id_reponse bigint NOT NULL default '0',
 599    texte_reponse varchar(255) NOT NULL default '',
 600    votes int NOT NULL default '0',
 601    PRIMARY KEY  (id_article,id_reponse)
 602  );
 603  
 604  [action]
 605  CREATE TABLE spip_sondages_votes (
 606    id_article bigint NOT NULL default '0',
 607    email_votant varchar(255) NOT NULL default '',
 608    date_time varchar(19) NOT NULL default '0000-00-00 00:00:00',
 609    id_reponse bigint NOT NULL default '0',
 610    statut varchar(10) NOT NULL default '',
 611    PRIMARY KEY  (id_article,email_votant)
 612  );
 613  
 614  [action]
 615  CREATE TABLE spip_syndic (
 616    id_syndic bigint NOT NULL default '0',
 617    id_rubrique bigint NOT NULL default '0',
 618    id_secteur bigint NOT NULL default '0',
 619    nom_site text NOT NULL,
 620    url_site text NOT NULL,
 621    url_syndic text NOT NULL,
 622    descriptif text NOT NULL,
 623    maj varchar(19) default NULL,
 624    syndication varchar(4) NOT NULL default '',
 625    statut varchar(10) NOT NULL default '',
 626    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 627    date_syndic varchar(19) NOT NULL default '0000-00-00 00:00:00',
 628    date_index varchar(19) NOT NULL default '0000-00-00 00:00:00',
 629    moderation varchar(4) NOT NULL default '',
 630    PRIMARY KEY  (id_syndic)
 631  );
 632  
 633  [action]
 634  CREATE TABLE spip_syndic_articles (
 635    id_syndic_article bigint NOT NULL default '0',
 636    id_syndic bigint NOT NULL default '0',
 637    titre text NOT NULL,
 638    url varchar(255) NOT NULL default '',
 639    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 640    lesauteurs text NOT NULL,
 641    maj varchar(19) default NULL,
 642    statut varchar(10) NOT NULL default '',
 643    descriptif text NOT NULL,
 644    PRIMARY KEY  (id_syndic_article)
 645  );
 646  
 647  [action]
 648  CREATE TABLE spip_types_documents (
 649    id_type bigint NOT NULL default '0',
 650    titre text NOT NULL,
 651    descriptif text NOT NULL,
 652    extension varchar(10) NOT NULL default '',
 653    mime_type varchar(100) NOT NULL default '',
 654    inclus varchar(5) NOT NULL default 'non',
 655    upload varchar(4) NOT NULL default 'oui',
 656    maj varchar(19) default NULL,
 657    PRIMARY KEY  (id_type)
 658  );
 659  
 660  [action]
 661  CREATE TABLE spip_visites (
 662    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 663    visites int  NOT NULL default '0',
 664    maj varchar(19) default NULL,
 665    PRIMARY KEY  (date_heure)
 666  );
 667  
 668  [action]
 669  CREATE TABLE spip_visites_articles (
 670    date_heure varchar(19) NOT NULL default '0000-00-00 00:00:00',
 671    id_article int  NOT NULL default '0',
 672    visites int  NOT NULL default '0',
 673    maj varchar(19) default NULL,
 674    PRIMARY KEY  (date_heure,id_article)
 675  );
 676  
 677  [action]
 678  CREATE TABLE spip_visites_temp (
 679    ip varchar(15) NOT NULL default '0.0.0.0',
 680    type varchar(8) NOT NULL default 'article',
 681    id_objet int  NOT NULL default '0',
 682    maj varchar(19) default NULL,
 683    PRIMARY KEY  (type,id_objet,ip)
 684  );
 685  
 686  [action]
 687  CREATE TABLE spip_glossaire (
 688    id int NOT NULL,
 689    mot varchar(50) NOT NULL default '',
 690    url varchar(255) NOT NULL default '',
 691    PRIMARY KEY (id)
 692  );