[Sommaire] [Imprimer]

   1  -- ========================================================================
   2  -- Copyright (C) 2004-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3  --
   4  -- This program is free software; you can redistribute it and/or modify
   5  -- it under the terms of the GNU General Public License as published by
   6  -- the Free Software Foundation; either version 2 of the License, or
   7  -- (at your option) any later version.
   8  --
   9  -- This program is distributed in the hope that it will be useful,
  10  -- but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  -- GNU General Public License for more details.
  13  --
  14  -- You should have received a copy of the GNU General Public License
  15  -- along with this program; if not, write to the Free Software
  16  -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  17  --
  18  -- $Id: llx_telephonie_import_cdr.sql,v 1.5 2005/04/04 08:17:16 rodolphe Exp $
  19  -- $Source: /cvsroot/dolibarr/dolibarr/htdocs/telephonie/sql/llx_telephonie_import_cdr.sql,v $
  20  --
  21  -- ========================================================================
  22  
  23  create table llx_telephonie_import_cdr (
  24    idx            integer,
  25    fk_ligne       integer NOT NULL,
  26    ligne          varchar(255) NOT NULL,
  27    date           varchar(255) NOT NULL,
  28    heure          varchar(255) NOT NULL,
  29    num            varchar(255) NOT NULL,
  30    dest           varchar(255) NOT NULL,
  31    dureetext      varchar(255) NOT NULL,
  32    tarif          varchar(255) NOT NULL,
  33    montant        real         NOT NULL,
  34    duree          integer      NOT NULL,
  35    fichier        varchar(255) NOT NULL,
  36    fk_fournisseur integer      NOT NULL,
  37  
  38    key (ligne)
  39  
  40  )type=innodb;
  41