Ciao a tutti,
ho creato un modello con workbench, ma quando vado a sincronizzare con il database, ricevo il questo errore. Ho provato e riprovata ma proprio non capisco dove č l'errore. Qualcuno di voi riesce a capire dov'č il problema?

codice:
Executing SQL script in server
ERROR: Error 1005: Can't create table 'test_001.vnt_products' (errno: 150)
SQL Code:
        CREATE TABLE IF NOT EXISTS `test_001`.`vnt_products` (
          `id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `item_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `product_state_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `sku` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
          `supplier_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL COMMENT '',
          `price` DECIMAL(10,2) NULL DEFAULT NULL COMMENT '',
          `availability` INT(11) NULL DEFAULT 1 COMMENT '',
          `updated` DATETIME NULL DEFAULT NULL COMMENT '',
          `created` DATETIME NULL DEFAULT NULL COMMENT '',
          `note` TEXT NULL DEFAULT NULL COMMENT '',
          `product_type_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `product_vat_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `product_um_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          PRIMARY KEY (`id`)  COMMENT '',
          INDEX `fk_vnt_products_vnt_users1_idx` (`supplier_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_product_states1_idx` (`product_state_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_items1_idx` (`item_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_product_types1_idx` (`product_type_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_product_vats1_idx` (`product_vat_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_product_ums1_idx` (`product_um_id` ASC)  COMMENT '',
          CONSTRAINT `fk_vnt_products_vnt_users1`
            FOREIGN KEY (`supplier_id`)
            REFERENCES `vedanet_001`.`vnt_users` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_product_states1`
            FOREIGN KEY (`product_state_id`)
            REFERENCES `vedanet_001`.`vnt_product_states` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_items1`
            FOREIGN KEY (`item_id`)
            REFERENCES `vedanet_001`.`vnt_items` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_product_types1`
            FOREIGN KEY (`product_type_id`)
            REFERENCES `vedanet_001`.`vnt_product_types` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_product_vats1`
            FOREIGN KEY (`product_vat_id`)
            REFERENCES `vedanet_001`.`vnt_product_vats` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_product_ums1`
            FOREIGN KEY (`product_um_id`)
            REFERENCES `vedanet_001`.`vnt_product_ums` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION)
        ENGINE = InnoDB
        DEFAULT CHARACTER SET = utf8
        COLLATE = utf8_unicode_ci

SQL script execution finished: statements: 3 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch