[Sommaire] [Imprimer]

   1  -- ===================================================================
   2  -- Copyright (C) 2002-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3  -- Copyright (C) 2002-2003 Jean-Louis Bergamo <jlb@j1b.org>
   4  --
   5  -- This program is free software; you can redistribute it and/or modify
   6  -- it under the terms of the GNU General Public License as published by
   7  -- the Free Software Foundation; either version 2 of the License, or
   8  -- (at your option) any later version.
   9  --
  10  -- This program is distributed in the hope that it will be useful,
  11  -- but WITHOUT ANY WARRANTY; without even the implied warranty of
  12  -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  13  -- GNU General Public License for more details.
  14  --
  15  -- You should have received a copy of the GNU General Public License
  16  -- along with this program; if not, write to the Free Software
  17  -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  18  --
  19  -- $Id: llx_adherent.sql,v 1.18 2005/08/11 18:40:41 eldy Exp $
  20  -- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_adherent.sql,v $
  21  --
  22  -- ===================================================================
  23  --
  24  -- statut
  25  -- 0 : non adherent
  26  -- 1 : adherent
  27  
  28  create table llx_adherent
  29  (
  30    rowid            integer AUTO_INCREMENT PRIMARY KEY,
  31    tms              timestamp,
  32    statut           smallint NOT NULL DEFAULT 0,
  33    public           smallint NOT NULL DEFAULT 0, -- certain champ de la fiche sont ils public ou pas ?
  34    fk_adherent_type smallint,
  35    morphy           enum('mor','phy') NOT NULL, -- personne morale / personne physique
  36    datevalid        datetime,  -- date de validation
  37    datec            datetime,  -- date de creation
  38    prenom           varchar(50),
  39    nom              varchar(50),
  40    societe          varchar(50),
  41    adresse          text,
  42    cp               varchar(30),
  43    ville            varchar(50),
  44    pays             varchar(50),
  45    email            varchar(255),
  46    login            varchar(50) NOT NULL,      -- login utilise pour editer sa fiche
  47    pass             varchar(50),      -- pass utilise pour editer sa fiche
  48    naiss            date,             -- date de naissance
  49    photo            varchar(255),     -- url vers la photo de l'adherent
  50    fk_user_author   integer NOT NULL,
  51    fk_user_mod      integer NOT NULL,
  52    fk_user_valid    integer NOT NULL,
  53    datefin          datetime,  -- date de fin de validité de la cotisation
  54    note             text,
  55   
  56    UNIQUE INDEX(login)
  57  )type=innodb;