Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +--------------------------------------------+
- | Catalog Diff Report |
- +--------------------------------------------+
- Table `lisamodas`.`cargas_lancamentos` was created
- columns:
- - idCarga_lancamento of type INT
- - cargas_id of type INT
- - lancamentos_id of type INT
- __
- indices:
- - PRIMARY with columns: idCarga_lancamento
- - fk_cargas_lancamentos_cargas1_idx with columns: cargas_id
- - fk_cargas_lancamentos_lancamentos1_idx with columns: lancamentos_id
- __
- foreign keys:
- - fk_cargas_lancamentos_cargas1 with columns: cargas_id, referred table: cargas with columns: idCarga
- - action on update: NO ACTION
- - action on delete: NO ACTION
- - fk_cargas_lancamentos_lancamentos1 with columns: lancamentos_id, referred table: lancamentos with columns: idLancamento
- - action on update: NO ACTION
- - action on delete: NO ACTION
- __
- attributes:
- - engine: InnoDB
- - next auto increment: 18
- - default character set: latin1
- __
- Table `lisamodas`.`cargas_vendas_produtos` was created
- columns:
- - idcargas_vendas_produtos of type INT
- - vendas_produtos_id of type INT
- - quantidade of type FLOAT
- - cargas_id of type INT
- - data of type DATE
- __
- indices:
- - PRIMARY with columns: idcargas_vendas_produtos
- __
- attributes:
- - engine: InnoDB
- - next auto increment: 50
- - default character set: latin1
- __
- Table `lisamodas`.`entrada_manual` was created
- columns:
- - idEntrada of type INT
- - produtos_id of type INT
- - quantidade of type VARCHAR
- - precoUnitario of type DECIMAL
- __
- indices:
- - PRIMARY with columns: idEntrada
- - fk_entrada_manual_produtos1_idx with columns: produtos_id
- __
- foreign keys:
- - fk_entrada_manual_produtos1 with columns: produtos_id, referred table: produtos with columns: idProduto
- - action on update: NO ACTION
- - action on delete: NO ACTION
- __
- attributes:
- - engine: InnoDB
- - next auto increment: 19
- - default character set: latin1
- __
- Table `lisamodas`.`familia` was created
- columns:
- - idFamilia of type INT
- - descricao of type VARCHAR
- - situacao of type TINYINT
- __
- indices:
- - PRIMARY with columns: idFamilia
- __
- attributes:
- - engine: InnoDB
- - next auto increment: 6
- - default character set: latin1
- __
- Table `lisamodas`.`cargas` was modified
- foreign keys:
- - removed foreign key: fk_Cargas_Produtos1
- __
- Table `lisamodas`.`pessoas` was modified
- foreign keys:
- __
- Table `lisamodas`.`cargas` was modified
- columns:
- - added column terceiro of type CHAR(3)
- - added column preco of type DECIMAL(14,2)
- - added column situacao of type CHAR(1)
- - added column data of type DATE
- - added column retiradaFutura of type CHAR(1)
- - modified column produtos_id
- __
- indices:
- - removed index fk_Cargas_Produtos1_idx
- __
- foreign keys:
- __
- Table `lisamodas`.`categorias` was modified
- columns:
- - added column rateio of type CHAR(1)
- __
- Table `lisamodas`.`classificacoes` was modified
- columns:
- - added column forma of type CHAR(1)
- - added column limite of type DECIMAL(14,2)
- - added column perDesconto of type DECIMAL(14,2)
- __
- Table `lisamodas`.`compra_grao` was modified
- columns:
- - added column faturado of type INT(11)
- __
- Table `lisamodas`.`estados` was modified
- columns:
- - added column cidade of type VARCHAR(120)
- - removed column codigo
- - removed column pais
- __
- Table `lisamodas`.`etiquetas` was modified
- columns:
- - added column precoVenda of type DECIMAL(14,2)
- __
- Table `lisamodas`.`grupos` was modified
- columns:
- - removed column rateio
- __
- Table `lisamodas`.`movimentos` was modified
- columns:
- - added column juros of type FLOAT(11)
- - added column multas of type FLOAT(11)
- - added column descontos of type FLOAT(11)
- __
- Table `lisamodas`.`pessoas` was modified
- columns:
- - added column rg of type VARCHAR(45)
- - added column dataNascimento of type DATE
- - modified column cpfCgc
- - modified column telefone
- __
- indices:
- - added index idx_Cidades_id with columns: cidades_id
- __
- foreign keys:
- - added foreign key fk_Pessoas_idCidade with columns: cidades_id, referred table: cidades with columns: idCidade
- - action on update: CASCADE
- - action on delete: none
- __
- Table `lisamodas`.`produtos` was modified
- columns:
- - added column foto of type VARCHAR(100)
- - added column marcas_id of type INT(11)
- - added column familias_id of type INT(11)
- - added column cod_barra of type VARCHAR(45)
- __
- Table `lisamodas`.`vales_produtos` was modified
- columns:
- - added column precoVenda of type DECIMAL(14,2)
- __
- Table `lisamodas`.`vendas` was modified
- columns:
- - added column condicional of type CHAR(1)
- - added column retiradaFutura of type CHAR(1)
- - added column tipoVenda of type VARCHAR(6)
- __
- Table `lisamodas`.`vendas_produtos` was modified
- columns:
- - added column unidades_id of type INT(11)
- - added column cargaRetirada of type CHAR(1)
- __
- View `lisamodas`.`movimentoProdutor` was dropped
- View `lisamodas`.`estoqueProdutor` was dropped
- View `lisamodas`.`estoqueProduto` was created
- View `lisamodas`.`estoqueTerceiro` was created
- View `lisamodas`.`itensFaturar` was created
- View `lisamodas`.`movimentoProduto` was created
- View `lisamodas`.`movimentoTerceiro` was created
- ----------------------------------------------
- End of MySQL Workbench Report
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement