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