

CREATE TABLE IF NOT EXISTS `wp_bs_oauth_userinfo_api_known` (
  `userinfo_api_known_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_name` text,
  `data_format` enum('FORM','JSON','XML') DEFAULT 'JSON',
  `first_name` text,
  `last_name` text,
  `user_email` text,
  `user_url` text,
  `user_nicename` text,
  `user_login` text,
  `request_method` enum('GET','POST') DEFAULT 'GET',
  `external_id` text,
  `scope` text,
  `email_verified` text,
  PRIMARY KEY (`userinfo_api_known_id`)
);

INSERT INTO `wp_bs_oauth_userinfo_api_known` (`userinfo_api_known_id`, `api_name`, `data_format`, `first_name`, `last_name`, `user_email`, `user_url`, `user_nicename`, `user_login`, `request_method`, `external_id`, `scope`, `email_verified`) VALUES
(1, 'OpenID Connect userinfo endpoint', 'JSON', 'given_name', 'family_name', 'email', 'profile', 'name', 'preferred_username', 'POST', 'sub', 'openid profile email', 'email_verified'),
(2, 'Facebook Graph /me eindpoint', 'JSON', 'first_name', 'last_name', 'email', 'link', 'name', NULL, 'GET', 'id', 'public_profile,email', NULL),
(3, 'Twitter account/verify_credentials', 'JSON', NULL, NULL, NULL, 'url', 'name', 'screen_name', 'GET', 'id', NULL, NULL),
(4, 'Microsoft Live Connect', 'JSON', 'first_name', 'last_name', NULL, NULL, 'name', NULL, 'GET', 'id', 'wl.basic wl.emails  wl.signin', NULL),
(5, 'Github API v3', 'JSON', NULL, NULL, 'email', 'url', 'name', 'login', 'GET', 'id', NULL, NULL),
(6, 'LinkedIn API', 'JSON', 'firstName', 'lastName', NULL, NULL, NULL, NULL, 'GET', 'id', NULL, NULL);
