function hocwp_post_trending_table_init()
{
global $wpdb;
$table_name = $wpdb->prefix . HOCWP_TRENDING_TABLE;
$sql = "ID bigint(20) unsigned NOT NULL auto_increment,\r\n post_id bigint(20) unsigned NOT NULL default '0',\r\n post_date datetime NOT NULL default '0000-00-00 00:00:00',\r\n post_type varchar(20) NOT NULL default 'post',\r\n action varchar(20) NOT NULL default '',\r\n PRIMARY KEY (ID),\r\n KEY post_id (post_id)";
hocwp_create_database_table($table_name, $sql);
}
function hocwp_statistics_table_init()
{
global $wpdb;
$table_statistics = $wpdb->prefix . HOCWP_COUNTER_TABLE_STATISTICS;
$table_online = $wpdb->prefix . HOCWP_COUNTER_TABLE_ONLINE;
$sql = "ID bigint(20) unsigned NOT NULL auto_increment,\r\n user_id bigint(20) unsigned NOT NULL default '0',\r\n visited datetime NOT NULL default '0000-00-00 00:00:00',\r\n visited_timestamp int,\r\n ip text,\r\n pc_ip text,\r\n browser text,\r\n location text,\r\n user_agent longtext,\r\n PRIMARY KEY (ID),\r\n KEY user_id (user_id)";
hocwp_create_database_table($table_statistics, $sql);
hocwp_create_database_table($table_online, $sql);
}
function hocwp_term_meta_table_init()
{
$version = hocwp_get_wp_version();
if (version_compare($version, '4.4', '>=')) {
return;
}
global $wpdb;
$max_index_length = 191;
$table = $wpdb->prefix . HOCWP_TERM_META_TABLE;
$sql = "meta_id bigint(20) unsigned NOT NULL auto_increment,\r\n\t\tterm_id bigint(20) unsigned NOT NULL default '0',\r\n\t\tmeta_key varchar(255) default NULL,\r\n\t\tmeta_value longtext,\r\n\t\tPRIMARY KEY (meta_id),\r\n\t\tKEY term_id (term_id),\r\n\t\tKEY meta_key (meta_key({$max_index_length}))";
hocwp_create_database_table($table, $sql);
}