Here we go:
CREATE TABLE `security_token` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`token` varchar(255) NOT NULL,
`creation_date` bigint(20) unsigned NOT NULL,
`expiration_date` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_token` (`token`),
KEY `token_index` (`token`),
KEY `expiration_index` (`expiration_date`)
) ENGINE=InnoDB AUTO_INCREMENT=31270 DEFAULT CHARSET=utf8;
CREATE TABLE `security_authentication_tokens` (
`token` varchar(255) NOT NULL,
`provider_token_id` int(11) DEFAULT NULL,
`provider_token_refresh_id` int(11) DEFAULT NULL,
`provider_configuration_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`token`),
KEY `security_authentication_tokens_token_fk` (`token`),
KEY `security_authentication_tokens_provider_token_id_fk` (`provider_token_id`),
KEY `security_authentication_tokens_provider_token_refresh_id_fk` (`provider_token_refresh_id`),
KEY `security_authentication_tokens_configuration_id_fk` (`provider_configuration_id`),
KEY `security_authentication_tokens_user_id_fk` (`user_id`),
CONSTRAINT `security_authentication_tokens_configuration_id_fk` FOREIGN KEY (`provider_configuration_id`) REFERENCES `provider_configuration` (`id`) ON DELETE CASCADE,
CONSTRAINT `security_authentication_tokens_provider_token_id_fk` FOREIGN KEY (`provider_token_id`) REFERENCES `security_token` (`id`) ON DELETE CASCADE,
CONSTRAINT `security_authentication_tokens_provider_token_refresh_id_fk` FOREIGN KEY (`provider_token_refresh_id`) REFERENCES `security_token` (`id`) ON DELETE SET NULL,
CONSTRAINT `security_authentication_tokens_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `contact` (`contact_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `security_token` VALUES (31208,'7ZuKM890VBZUOQPqGekOKRWvz04/z+btOpR2cCju72HwIvxfrCAvPhghFlq3WJvH',1643365783,1646316822),(31268,'prsc83mbq9fq8ejrgrgbm19kg0',1646299161,1646306454),(31269,'3NXyO/DY48X7ouCzKlsWt6DY7xT7o8NdjCdy8OCmhDhMhGRAPM9jvBFlvW5S3++c',1646299214,1646306415);
INSERT INTO `security_authentication_tokens` VALUES ('3NXyO/DY48X7ouCzKlsWt6DY7xT7o8NdjCdy8OCmhDhMhGRAPM9jvBFlvW5S3++c',31269,NULL,1,1),('7ZuKM890VBZUOQPqGekOKRWvz04/z+btOpR2cCju72HwIvxfrCAvPhghFlq3WJvH',31208,NULL,1,1),('prsc83mbq9fq8ejrgrgbm19kg0',31268,NULL,1,1);
I hope that I forgot nothing.
