db_update_versions();
include_once( $this->plugin->locations['inc_dir'] . 'db-updates.php' );
foreach ( $versions as $version ) {
if ( ! isset( $update_args['type'] ) ) {
$update_args['type'] = 'user';
}
$function = 'wp_stream_update_' . ( 'user' === $update_args['type'] ? '' : $update_args['type'] . '_' ) . str_ireplace( '.', '', $version );
if ( version_compare( $db_version, $version, '<' ) ) {
$result = function_exists( $function ) ? call_user_func( $function, $db_version, $current_version ) : $current_version;
if ( $current_version !== $result ) {
return false;
}
}
}
return $current_version;
}
/**
* Initial database install routine
*
* @param string $current_version
*
* @return string
*/
public function install( $current_version ) {
global $wpdb;
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = "CREATE TABLE {$wpdb->base_prefix}stream (
ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
site_id bigint(20) unsigned NOT NULL DEFAULT '1',
blog_id bigint(20) unsigned NOT NULL DEFAULT '1',
object_id bigint(20) unsigned NULL,
user_id bigint(20) unsigned NOT NULL DEFAULT '0',
user_role varchar(50) NOT NULL DEFAULT '',
summary longtext NOT NULL,
created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
connector varchar(100) NOT NULL,
context varchar(100) NOT NULL,
action varchar(100) NOT NULL,
ip varchar(39) NULL,
PRIMARY KEY (ID),
KEY site_id (site_id),
KEY blog_id (blog_id),
KEY object_id (object_id),
KEY user_id (user_id),
KEY created (created),
KEY connector (connector),
KEY context (context),
KEY action (action)
)";
if ( ! empty( $wpdb->charset ) ) {
$sql .= " CHARACTER SET $wpdb->charset";
}
if ( ! empty( $wpdb->collate ) ) {
$sql .= " COLLATE $wpdb->collate";
}
$sql .= ';';
\dbDelta( $sql );
if ( ! empty( $wpdb->charset ) ) {
$sql .= " CHARACTER SET $wpdb->charset";
}
if ( ! empty( $wpdb->collate ) ) {
$sql .= " COLLATE $wpdb->collate";
}
$sql .= ';';
\dbDelta( $sql );
$sql = "CREATE TABLE {$wpdb->base_prefix}stream_meta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
record_id bigint(20) unsigned NOT NULL,
meta_key varchar(200) NOT NULL,
meta_value varchar(200) NOT NULL,
PRIMARY KEY (meta_id),
KEY record_id (record_id),
KEY meta_key (meta_key(191)),
KEY meta_value (meta_value(191))
)";
if ( ! empty( $wpdb->charset ) ) {
$sql .= " CHARACTER SET $wpdb->charset";
}
if ( ! empty( $wpdb->collate ) ) {
$sql .= " COLLATE $wpdb->collate";
}
$sql .= ';';
\dbDelta( $sql );
update_site_option( $this->option_key, $this->plugin->get_version() );
return $current_version;
}
}