WordPress database error: [Failed to open the referenced table 'wp_posts']CREATE TABLE IF NOT EXISTS wp_kirki_cm_reference (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id BIGINT(20) UNSIGNED NOT NULL,
field_meta_key VARCHAR(255) NOT NULL,
ref_post_id BIGINT(20) UNSIGNED NOT NULL,
PRIMARY KEY (id),
INDEX (post_id),
INDEX (ref_post_id),
FOREIGN KEY (post_id) REFERENCES wp_posts(ID) ON DELETE CASCADE,
FOREIGN KEY (ref_post_id) REFERENCES wp_posts(ID) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Failed to open the referenced table 'wp_posts']CREATE TABLE IF NOT EXISTS wp_kirki_comments (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
user_id BIGINT(20) UNSIGNED NOT NULL,
post_id BIGINT(20) UNSIGNED NOT NULL,
parent_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
comment TEXT NOT NULL,
meta_data VARCHAR(255) NOT NULL,
status INT(1) NOT NULL COMMENT '1=active, 2=resolved, 0=deleted',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
KEY post_id (post_id),
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: [Failed to open the referenced table 'wp_kirki_comments']CREATE TABLE IF NOT EXISTS wp_kirki_comments_seen (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
comment_id BIGINT(20) UNSIGNED NOT NULL,
user_id BIGINT(20) UNSIGNED NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY user_comment_unique (user_id, comment_id),
FOREIGN KEY (comment_id) REFERENCES wp_kirki_comments(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Failed to open the referenced table 'wp_posts']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: [Failed to open the referenced table 'wp_kirki_stages']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
WordPress database error: [Failed to open the referenced table 'wp_posts']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: [Failed to open the referenced table 'wp_kirki_stages']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