DROP DATABASE IF EXISTS innodb_test;

CREATE DATABASE innodb_test;
USE innodb_test;

CREATE TABLE contents (
  id int PRIMARY KEY AUTO_INCREMENT,
  text text
) DEFAULT CHARSET utf8mb4 ROW_FORMAT=DYNAMIC;

CREATE TABLE c_refs (
  id int PRIMARY KEY AUTO_INCREMENT,
  content_id int,
  KEY `index_c_refs_on_content_id` (`content_id`),
  CONSTRAINT `content_id` FOREIGN KEY (`content_id`) REFERENCES `contents` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) DEFAULT CHARSET utf8mb4 ROW_FORMAT=DYNAMIC;

SHOW CREATE TABLE contents;
SHOW CREATE TABLE c_refs;

DROP DATABASE innodb_test;