Advertisement
Guest User

Untitled

a guest
May 22nd, 2018
297
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.36 KB | None | 0 0
  1. +--------------------------------------------+
  2. | Catalog Diff Report |
  3. +--------------------------------------------+
  4. Table `lisamodas`.`cargas_lancamentos` was created
  5. columns:
  6. - idCarga_lancamento of type INT
  7. - cargas_id of type INT
  8. - lancamentos_id of type INT
  9. __
  10. indices:
  11. - PRIMARY with columns: idCarga_lancamento
  12. - fk_cargas_lancamentos_cargas1_idx with columns: cargas_id
  13. - fk_cargas_lancamentos_lancamentos1_idx with columns: lancamentos_id
  14. __
  15. foreign keys:
  16. - fk_cargas_lancamentos_cargas1 with columns: cargas_id, referred table: cargas with columns: idCarga
  17. - action on update: NO ACTION
  18. - action on delete: NO ACTION
  19. - fk_cargas_lancamentos_lancamentos1 with columns: lancamentos_id, referred table: lancamentos with columns: idLancamento
  20. - action on update: NO ACTION
  21. - action on delete: NO ACTION
  22. __
  23. attributes:
  24. - engine: InnoDB
  25. - next auto increment: 18
  26. - default character set: latin1
  27. __
  28. Table `lisamodas`.`cargas_vendas_produtos` was created
  29. columns:
  30. - idcargas_vendas_produtos of type INT
  31. - vendas_produtos_id of type INT
  32. - quantidade of type FLOAT
  33. - cargas_id of type INT
  34. - data of type DATE
  35. __
  36. indices:
  37. - PRIMARY with columns: idcargas_vendas_produtos
  38. __
  39. attributes:
  40. - engine: InnoDB
  41. - next auto increment: 50
  42. - default character set: latin1
  43. __
  44. Table `lisamodas`.`entrada_manual` was created
  45. columns:
  46. - idEntrada of type INT
  47. - produtos_id of type INT
  48. - quantidade of type VARCHAR
  49. - precoUnitario of type DECIMAL
  50. __
  51. indices:
  52. - PRIMARY with columns: idEntrada
  53. - fk_entrada_manual_produtos1_idx with columns: produtos_id
  54. __
  55. foreign keys:
  56. - fk_entrada_manual_produtos1 with columns: produtos_id, referred table: produtos with columns: idProduto
  57. - action on update: NO ACTION
  58. - action on delete: NO ACTION
  59. __
  60. attributes:
  61. - engine: InnoDB
  62. - next auto increment: 19
  63. - default character set: latin1
  64. __
  65. Table `lisamodas`.`familia` was created
  66. columns:
  67. - idFamilia of type INT
  68. - descricao of type VARCHAR
  69. - situacao of type TINYINT
  70. __
  71. indices:
  72. - PRIMARY with columns: idFamilia
  73. __
  74. attributes:
  75. - engine: InnoDB
  76. - next auto increment: 6
  77. - default character set: latin1
  78. __
  79. Table `lisamodas`.`cargas` was modified
  80. foreign keys:
  81. - removed foreign key: fk_Cargas_Produtos1
  82. __
  83. Table `lisamodas`.`pessoas` was modified
  84. foreign keys:
  85. __
  86. Table `lisamodas`.`cargas` was modified
  87. columns:
  88. - added column terceiro of type CHAR(3)
  89. - added column preco of type DECIMAL(14,2)
  90. - added column situacao of type CHAR(1)
  91. - added column data of type DATE
  92. - added column retiradaFutura of type CHAR(1)
  93. - modified column produtos_id
  94. __
  95. indices:
  96. - removed index fk_Cargas_Produtos1_idx
  97. __
  98. foreign keys:
  99. __
  100. Table `lisamodas`.`categorias` was modified
  101. columns:
  102. - added column rateio of type CHAR(1)
  103. __
  104. Table `lisamodas`.`classificacoes` was modified
  105. columns:
  106. - added column forma of type CHAR(1)
  107. - added column limite of type DECIMAL(14,2)
  108. - added column perDesconto of type DECIMAL(14,2)
  109. __
  110. Table `lisamodas`.`compra_grao` was modified
  111. columns:
  112. - added column faturado of type INT(11)
  113. __
  114. Table `lisamodas`.`estados` was modified
  115. columns:
  116. - added column cidade of type VARCHAR(120)
  117. - removed column codigo
  118. - removed column pais
  119. __
  120. Table `lisamodas`.`etiquetas` was modified
  121. columns:
  122. - added column precoVenda of type DECIMAL(14,2)
  123. __
  124. Table `lisamodas`.`grupos` was modified
  125. columns:
  126. - removed column rateio
  127. __
  128. Table `lisamodas`.`movimentos` was modified
  129. columns:
  130. - added column juros of type FLOAT(11)
  131. - added column multas of type FLOAT(11)
  132. - added column descontos of type FLOAT(11)
  133. __
  134. Table `lisamodas`.`pessoas` was modified
  135. columns:
  136. - added column rg of type VARCHAR(45)
  137. - added column dataNascimento of type DATE
  138. - modified column cpfCgc
  139. - modified column telefone
  140. __
  141. indices:
  142. - added index idx_Cidades_id with columns: cidades_id
  143. __
  144. foreign keys:
  145. - added foreign key fk_Pessoas_idCidade with columns: cidades_id, referred table: cidades with columns: idCidade
  146. - action on update: CASCADE
  147. - action on delete: none
  148. __
  149. Table `lisamodas`.`produtos` was modified
  150. columns:
  151. - added column foto of type VARCHAR(100)
  152. - added column marcas_id of type INT(11)
  153. - added column familias_id of type INT(11)
  154. - added column cod_barra of type VARCHAR(45)
  155. __
  156. Table `lisamodas`.`vales_produtos` was modified
  157. columns:
  158. - added column precoVenda of type DECIMAL(14,2)
  159. __
  160. Table `lisamodas`.`vendas` was modified
  161. columns:
  162. - added column condicional of type CHAR(1)
  163. - added column retiradaFutura of type CHAR(1)
  164. - added column tipoVenda of type VARCHAR(6)
  165. __
  166. Table `lisamodas`.`vendas_produtos` was modified
  167. columns:
  168. - added column unidades_id of type INT(11)
  169. - added column cargaRetirada of type CHAR(1)
  170. __
  171. View `lisamodas`.`movimentoProdutor` was dropped
  172. View `lisamodas`.`estoqueProdutor` was dropped
  173. View `lisamodas`.`estoqueProduto` was created
  174. View `lisamodas`.`estoqueTerceiro` was created
  175. View `lisamodas`.`itensFaturar` was created
  176. View `lisamodas`.`movimentoProduto` was created
  177. View `lisamodas`.`movimentoTerceiro` was created
  178. ----------------------------------------------
  179. End of MySQL Workbench Report
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement