WordPress database error: [Can't create table `mmgcomm3_wp2`.`wp_kirki_stages` (errno: 150 "Foreign key constraint is incorrectly formed")]
CREATE TABLE IF NOT EXISTS wp_kirki_stages (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id BIGINT(20) UNSIGNED NOT NULL,
type VARCHAR(50) NOT NULL DEFAULT 'page',
version BIGINT(20) UNSIGNED NOT NULL,
name VARCHAR(255) NOT NULL DEFAULT '',
edited_by BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
is_published TINYINT(1) NOT NULL DEFAULT 0,
no_legacy_global_style TINYINT(1) NOT NULL DEFAULT 0,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY post_version (post_id, version),
KEY post_id (post_id),
KEY post_published (post_id, is_published),
FOREIGN KEY (post_id) REFERENCES wp_posts(ID) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Can't create table `mmgcomm3_wp2`.`wp_kirki_stage_data` (errno: 150 "Foreign key constraint is incorrectly formed")]
CREATE TABLE IF NOT EXISTS wp_kirki_stage_data (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
stage_id BIGINT(20) UNSIGNED NOT NULL,
meta_key VARCHAR(191) NOT NULL,
meta_value LONGTEXT NULL,
PRIMARY KEY (id),
UNIQUE KEY stage_meta_key (stage_id, meta_key),
FOREIGN KEY (stage_id) REFERENCES wp_kirki_stages(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
play_arrow
