[Sommaire] [Imprimer]

   1  -- ===================================================================
   2  -- Copyright (C) 2002-2003 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_type.sql,v 1.8 2004/02/05 16:19:06 rodolphe Exp $
  20  -- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_adherent_type.sql,v $
  21  --
  22  -- ===================================================================
  23  --
  24  -- statut
  25  -- 0 : actif
  26  -- 1 : inactif
  27  
  28  create table llx_adherent_type
  29  (
  30    rowid            integer AUTO_INCREMENT PRIMARY KEY,
  31    tms              timestamp,
  32    statut           smallint NOT NULL DEFAULT 0,
  33    libelle          varchar(50),
  34    cotisation       enum('yes','no') NOT NULL DEFAULT 'yes',
  35    vote             enum('yes','no') NOT NULL DEFAULT 'yes',
  36    note             text,
  37    mail_valid       text -- mail envoye a la validation
  38  )type=innodb;