WordPress database error: [Can't create table `db_a1de4a_icaro_2`.`7juflzr_icwp_wpsf_ip_meta` (errno: 150 "Foreign key constraint is incorrectly formed")]CREATE TABLE `7juflzr_icwp_wpsf_ip_meta` (
id int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary ID',
ip_ref int(11) UNSIGNED NOT NULL COMMENT 'Foreign Key For Primary ID',
asn int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ASN',
country_iso2 char(2) NOT NULL DEFAULT '' COMMENT 'Country Code ISO 3166-1 alpha-2',
pc_is_proxy tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ProxyCheck: Is Proxy?',
geo_updated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Geolocation data updated at',
pc_last_check_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ProxyCheck last lookup at',
updated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Updated',
created_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Created',
deleted_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Soft Deleted',
PRIMARY KEY (id),
FOREIGN KEY (ip_ref) REFERENCES 7juflzr_icwp_wpsf_ips(id) ON DELETE CASCADE ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Can't create table `db_a1de4a_icaro_2`.`7juflzr_icwp_wpsf_ip_meta` (errno: 150 "Foreign key constraint is incorrectly formed")]CREATE TABLE `7juflzr_icwp_wpsf_ip_meta` (
id int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary ID',
ip_ref int(11) UNSIGNED NOT NULL COMMENT 'Foreign Key For Primary ID',
asn int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ASN',
country_iso2 char(2) NOT NULL DEFAULT '' COMMENT 'Country Code ISO 3166-1 alpha-2',
pc_is_proxy tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ProxyCheck: Is Proxy?',
geo_updated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Geolocation data updated at',
pc_last_check_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ProxyCheck last lookup at',
updated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Updated',
created_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Created',
deleted_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Soft Deleted',
PRIMARY KEY (id),
FOREIGN KEY (ip_ref) REFERENCES 7juflzr_icwp_wpsf_ips(id) ON DELETE CASCADE ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Can't create table `db_a1de4a_icaro_2`.`7juflzr_icwp_wpsf_ip_rules` (errno: 150 "Foreign key constraint is incorrectly formed")]CREATE TABLE `7juflzr_icwp_wpsf_ip_rules` (
id int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary ID',
ip_ref int(11) UNSIGNED NOT NULL COMMENT 'Foreign Key For Primary ID',
cidr int(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'CIDR',
is_range tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is IP Range',
offenses int(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Offenses Count',
type char(2) NOT NULL DEFAULT '' COMMENT 'List',
label varchar(255) NOT NULL DEFAULT '' COMMENT 'IP Description',
can_export tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Can This IP Be Exported',
last_access_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Access',
blocked_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'IP Blocked',
unblocked_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Visitor Requested Unblock',
last_unblock_attempt_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Time An Auto-Unblock Attempt Was Made',
expires_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The IP Rule on this lists expires at this time.',
imported_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'This IP rule was imported from a master site.',
updated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Updated',
created_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Created',
deleted_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Soft Deleted',
PRIMARY KEY (id),
FOREIGN KEY (ip_ref) REFERENCES 7juflzr_icwp_wpsf_ips(id) ON DELETE CASCADE ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Can't create table `db_a1de4a_icaro_2`.`7juflzr_icwp_wpsf_ip_rules` (errno: 150 "Foreign key constraint is incorrectly formed")]CREATE TABLE `7juflzr_icwp_wpsf_ip_rules` (
id int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary ID',
ip_ref int(11) UNSIGNED NOT NULL COMMENT 'Foreign Key For Primary ID',
cidr int(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'CIDR',
is_range tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is IP Range',
offenses int(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Offenses Count',
type char(2) NOT NULL DEFAULT '' COMMENT 'List',
label varchar(255) NOT NULL DEFAULT '' COMMENT 'IP Description',
can_export tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Can This IP Be Exported',
last_access_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Access',
blocked_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'IP Blocked',
unblocked_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Visitor Requested Unblock',
last_unblock_attempt_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Time An Auto-Unblock Attempt Was Made',
expires_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The IP Rule on this lists expires at this time.',
imported_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'This IP rule was imported from a master site.',
updated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Updated',
created_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Created',
deleted_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Soft Deleted',
PRIMARY KEY (id),
FOREIGN KEY (ip_ref) REFERENCES 7juflzr_icwp_wpsf_ips(id) ON DELETE CASCADE ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
