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