{"table_name":"gs_coaches","full_table_name":"wp_gs_coaches","description":"Stores gs coaches data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_gs_coaches ( id BIGINT(20) unsigned NOT NULL AUTO_INCREMENT, shortcode_name TEXT NOT NULL, shortcode_settings LONGTEXT NOT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id) )\".$wpdb->get_charset_collate().\";\"; if ( get_option(\"wp_gs_coach_db_version\") < $gs_coach_db_version ) { dbDelta( $sql );","columns":[{"name":"id","type":"BIGINT(20) unsigned","nullable":false,"primary_key":true},{"name":"shortcode_name","type":"TEXT","nullable":false,"primary_key":false},{"name":"shortcode_settings","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"gs-coach","name":"GS Coach – Professional Team Showcase for Coaches & Consultants","active_installs":10,"version":"3.0.0","wp_org_url":"https://wordpress.org/plugins/gs-coach/"}}