SQL INT needs to be BIGINT

Hi there,

Could you please ensure that within the plugin tables which are setup by the plugin, that they mirror integer sizes of other tables. For example:

//fc_action_history table
$table_name = OW_Utility::instance()->get_action_history_table_name();
if ( $wpdb->get_var( “SHOW TABLES LIKE ‘{$table_name}'” ) != $table_name ) {
$sql = “CREATE TABLE IF NOT EXISTS {$table_name} (
ID int(11) NOT NULL AUTO_INCREMENT,
action_status varchar(20) NOT NULL,
comment longtext NOT NULL,
step_id int(11) NOT NULL,
assign_actor_id int(11) NOT NULL,
post_id int(11) NOT NULL,
from_id int(11) NOT NULL,
due_date date DEFAULT NULL,
history_meta longtext DEFAULT NULL,
reminder_date date DEFAULT NULL,
reminder_date_after date DEFAULT NULL,
create_datetime datetime NOT NULL,
PRIMARY KEY (ID)
){$charset_collate};”;
dbDelta( $sql );
}

post_id needs to be bigint(20) rather than int(11) to mirror wp_posts table. For both pro and light versions.

Thanks,
Theo