[Dolibarr-cvs] dolibarr/mysql/migration 2.0.0-2.1.0.sql

[Rodolphe Quiedeville]

CVSROOT:        /cvsroot/dolibarr
Module name:    dolibarr
Changes by:     Rodolphe Quiedeville <rodolphe> 06/12/09 21:49:16

Modified files:
        mysql/migration: 2.0.0-2.1.0.sql 

Log message:
        Ajout
        
        create table llx_fournisseur_ca
        (
          fk_societe    integer,
          date_calcul   datetime,
          year          smallint UNSIGNED,
          ca_genere     float,
          UNIQUE (fk_societe, year)
        )type=innodb;
        
        create table llx_product_ca
        (
          fk_product    integer,
          date_calcul   datetime,
          year          smallint UNSIGNED,
          ca_genere     float,
          UNIQUE (fk_product, year)
        )type=innodb;

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/dolibarr/mysql/migration/2.0.0-2.1.0.sql?cvsroot=dolibarr&r1=1.171&r2=1.172