{"table_name":"rp_sessions","full_table_name":"wp_rp_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_rp_sessions ( session_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_key char(32) NOT NULL, session_value longtext NOT NULL, session_expiry BIGINT UNSIGNED NOT NULL, PRIMARY KEY (session_key), UNIQUE KEY session_id (session_id) ) $charset_collate; \"; /** * Term meta is only needed for old installs and is now @deprecated by WordPress term meta. */ if ( ! function_exists( 'get_term_meta' ) ) { $tables .= \" CREATE TABLE wp_restaurantpress_termmeta ( meta_id bigint(20) NOT NULL auto_increment, restaurantpress_term_id bigint(20) NOT NULL, meta_key varchar(255) default NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY restaurantpress_term_id (restaurantpress_term_id), KEY meta_key (meta_key(32)) ) $charset_collate; \"; } return $tables; } /** * Return a list of RestaurantPress tables. Used to make sure all RP tables are dropped when uninstalling the plugin * in a single site or multi site environment. * * @return array RP tables. */ public static function get_tables() { global $wpdb; $tables = array( \"wp_rp_sessions\", );","columns":[{"name":"session_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"session_key","type":"char(32)","nullable":false,"primary_key":false},{"name":"session_value","type":"longtext","nullable":false,"primary_key":false},{"name":"session_expiry","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"restaurantpress_term_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false}],"plugin":{"slug":"restaurantpress","name":"RestaurantPress","active_installs":600,"version":"1.8.1","wp_org_url":"https://wordpress.org/plugins/restaurantpress/"}}