text: DROP TABLE IF EXISTS `person`;
  CREATE TABLE `person` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
  
  DROP TABLE IF EXISTS persistent_logins;
  create table persistent_logins (
  	username varchar(64) not null, 
  	series varchar(64) primary key, 
  	token varchar(64) not null, 
  	last_used timestamp not null
  )ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  DROP TABLE IF EXISTS UserConnection;
  create table UserConnection (
  	userId varchar(255) not null,
  	providerId varchar(255) not null,
  	providerUserId varchar(255),
  	rank int not null,
  	displayName varchar(255),
  	profileUrl varchar(512),
  	imageUrl varchar(512),
  	accessToken varchar(512) not null,
  	secret varchar(512),
  	refreshToken varchar(512),
  	expireTime bigint,
  	primary key (userId, providerId, providerUserId)
  )ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  create unique index UserConnectionRank on UserConnection(userId, providerId, rank);
  