MariaDB 10.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


10.7.5-MariaDB-1:10.7.5+maria~deb11


CREATE TABLE `ice_product` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `long_description` text DEFAULT NULL,
  `long_summary_descr` text DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `quality` varchar(255) DEFAULT NULL,
  `release_date` date DEFAULT NULL,
  `update_date` date DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `short_summary_descr` text DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `category_id` bigint(20) DEFAULT NULL,
  `supplier_id` bigint(20) DEFAULT NULL,
  `updated` bit(1) NOT NULL,
  `product_family_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ice_product_cat` (`category_id`),
  KEY `idx_ice_product_supp` (`supplier_id`),
  KEY `idx_ice_product_updated` (`updated`)
  -- CONSTRAINT `fk_icecat_product_cat_id` FOREIGN KEY (`category_id`) REFERENCES `ice_category` (`id`),
  -- CONSTRAINT `fk_icecat_product_supp_id` FOREIGN KEY (`supplier_id`) REFERENCES `ice_supplier` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
CREATE TABLE `ice_product_manuals` (
  `product_id` bigint(20) NOT NULL,
  `descr` varchar(255) DEFAULT NULL,
  `url` varchar(800) DEFAULT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_manual` (`product_id`,`url`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
ALTER TABLE ice_product_manuals 
  ADD CONSTRAINT fk_icecat_manuals_product_id 
  FOREIGN KEY (product_id) 
   REFERENCES ice_product(`id`);

Can't create table `fiddle`.`ice_product_manuals` (errno: 150 "Foreign key constraint is incorrectly formed")


ALTER TABLE ice_product_manuals
  ADD INDEX ice_product_manuals__product_id_idx (product_id) ;

Records: 0  Duplicates: 0  Warnings: 0


ALTER TABLE ice_product_manuals 
  ADD CONSTRAINT fk_icecat_manuals_product_id 
  FOREIGN KEY (product_id) 
   REFERENCES ice_product(`id`);

Records: 0  Duplicates: 0  Warnings: 0


show create table ice_product_manuals ;


Table
Create Table


ice_product_manuals
CREATE TABLE `ice_product_manuals` (
  `product_id` bigint(20) NOT NULL,
  `descr` varchar(255) DEFAULT NULL,
  `url` varchar(800) DEFAULT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_manual` (`product_id`,`url`) USING HASH,
  KEY `ice_product_manuals__product_id_idx` (`product_id`),
  CONSTRAINT `fk_icecat_manuals_product_id` FOREIGN KEY (`product_id`) REFERENCES `ice_product` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4