-- ========================================================================
-- Copyright (C) 2004-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 2 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
--
-- $Id$
-- $Source$
--
-- ========================================================================

create table llx_telephonie_import_cdr (
  idx            integer,
  fk_ligne       integer NOT NULL,
  ligne          varchar(255) NOT NULL,
  date           varchar(255) NOT NULL,
  heure          varchar(255) NOT NULL,
  num            varchar(255) NOT NULL,
  dest           varchar(255) NOT NULL,
  dureetext      varchar(255) NOT NULL,
  tarif          varchar(255) NOT NULL,
  montant        real         NOT NULL,
  duree          integer      NOT NULL,
  fichier        varchar(255) NOT NULL,
  fk_fournisseur integer      NOT NULL,

  key (ligne)

)type=innodb;

