[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/11 21:10:09

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

Log message:
        Ajout
        create table llx_commande_fournisseur_dispatch
        (
          rowid          integer AUTO_INCREMENT PRIMARY KEY,
          fk_commande    integer,
          fk_product     integer,
          qty            float,              -- quantité
          fk_entrepot    integer,
          fk_user        integer,
          datec          datetime
        )type=innodb;
        
        ALTER TABLE llx_commande_fournisseur_dispatch ADD INDEX (fk_commande);

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