WordPress database error: [Cannot add foreign key constraint]
CREATE TABLE `wp_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', 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.', 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 wp_icwp_wpsf_ips(id) ON DELETE CASCADE ON UPDATE CASCADE ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

WordPress database error: [Cannot add foreign key constraint]
CREATE TABLE `wp_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', 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.', 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 wp_icwp_wpsf_ips(id) ON DELETE CASCADE ON UPDATE CASCADE ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

WordPress database error: [Table 'beyondiversity.wp_icwp_wpsf_ip_rules' doesn't exist]
SELECT `ips`.`ip` as `ip`, `ir`.id, `ir`.ip_ref, `ir`.cidr, `ir`.is_range, `ir`.offenses, `ir`.type, `ir`.label, `ir`.last_access_at, `ir`.blocked_at, `ir`.unblocked_at, `ir`.last_unblock_attempt_at, `ir`.expires_at, `ir`.updated_at, `ir`.created_at, `ir`.deleted_at FROM `wp_icwp_wpsf_ip_rules` as `ir` INNER JOIN `wp_icwp_wpsf_ips` as `ips` ON `ir`.ip_ref = `ips`.id WHERE (`ips`.ip=INET6_ATON('3.238.90.95') AND `ir`.`is_range`='0') OR (`ir`.`is_range`='1') ORDER BY `ir`.`created_at` DESC ;

One Woman in every Boardroom - BD Foundation | Beyond Diversity

While conducting Interviews with CEOs for my research CEO Commitment to Diversity, I often heard the common lament We want to have more diversity in our boardroom. Butwhere are the women? We just dont know any, when questioned why they dont have women on their boards. Though some of the Indian CEOs are cognizant with the fact that having diversity in the boardroom would benefit the organizational performance but they usually fail implementing it at the C Suite level. But, with the Companies Bill 2012 making it mandatory for a woman to be present in every boardroom in the country, change is finally on its way. The Bill states, There will be an appointment of at least one woman director in prescribed class or classes of companies.

The truth is, its not hard to find qualified women to serve on corporate boards. In addition to _II_0008professional executive search firms that maintain databases of men and women who are qualified to serve, there are many womens business organizations across the country that perform board searches for a nominal fee, or at no charge. Many colleges and universities have womens leadership programs that can help identify qualified individuals from their alumni network. Business and trade associations can also be a good resource for finding senior-level women from different business sectors. Some CEOs have even reported that they have found candidates for their boards by reading articles about businesswomen and women of achievement in national and local business publications.

So why, in 2012 does this inequity persist? Research suggests that all the board positions get filled by the still-existent old boys network and references. Usually, these positions never get advertised. This brings us to the need of having more visibility for the women talent pool we have currently in India. Not all qualified board candidates mirror the traditional director profile executives with C-titles. Companies may consider modifying their board criteria to broaden the pool of candidates. Experts believe boards need to recognize that they shouldnt be recruiting members based on subject-matter knowledge (technology, financing, etc.), but rather should be seeking effective leaders. After all, it has to be best fit for the position or role.

Find a qualified women director:

Work with an executive search firm.
Find a local womens business organization that offers board searches services.
Contact your local universitys womens leadership program.
Identify businesswomen who are quoted in the business media.

Our vision to see One woman in every Boardroom by 2020 is supported through our various initiatives:

  • Search Capabilities of our Diversity Consulting Firm, Altavis which works with Fortune 500 MNC firms to identify Women Directors for their boards.
  • Diversity & Inclusion Roadmap Consulting for large organisations to plug their leaking talent pipeline.
  • Biz Divas network of more than 15000+ women leaders across India in corporates, business & public leadership.
  • Biz Divas Mentoring Leadership Program which aims to train and mentor 100+ women by 2020 to reach leadership positions.