Skip to content

Instantly share code, notes, and snippets.

@DeepDiver1975

DeepDiver1975/kratos-0.11.1-mysql-schema.sql

Created April 4, 2023 09:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DeepDiver1975/25b3089921f695e13c47a6e4dbfd5300 to your computer and use it in GitHub Desktop.
Save DeepDiver1975/25b3089921f695e13c47a6e4dbfd5300 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
kratos-0.11.1-mysql-schema.sql
-- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
--
-- Host: 172.21.0.5 Database: kratos
-- ------------------------------------------------------
-- Server version 5.7.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `continuity_containers`
--
DROP TABLE IF EXISTS `continuity_containers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `continuity_containers` (
`id` char(36) NOT NULL,
`identity_id` char(36) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`payload` json DEFAULT NULL,
`expires_at` datetime NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`nid` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `identity_id` (`identity_id`),
KEY `continuity_containers_nid_id_idx` (`nid`,`id`),
KEY `continuity_containers_id_nid_idx` (`id`,`nid`),
CONSTRAINT `continuity_containers_ibfk_1` FOREIGN KEY (`identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE,
CONSTRAINT `continuity_containers_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `continuity_containers`
--
LOCK TABLES `continuity_containers` WRITE;
/*!40000 ALTER TABLE `continuity_containers` DISABLE KEYS */;
/*!40000 ALTER TABLE `continuity_containers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `courier_messages`
--
DROP TABLE IF EXISTS `courier_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `courier_messages` (
`id` char(36) NOT NULL,
`type` int(11) NOT NULL,
`status` int(11) NOT NULL,
`body` text NOT NULL,
`subject` varchar(255) NOT NULL,
`recipient` varchar(255) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`template_type` varchar(255) NOT NULL DEFAULT '',
`template_data` blob,
`nid` char(36) DEFAULT NULL,
`send_count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `courier_messages_status_idx` (`status`),
KEY `courier_messages_nid_id_idx` (`nid`,`id`),
KEY `courier_messages_id_nid_idx` (`id`,`nid`),
CONSTRAINT `courier_messages_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `courier_messages`
--
LOCK TABLES `courier_messages` WRITE;
/*!40000 ALTER TABLE `courier_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `courier_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identities`
--
DROP TABLE IF EXISTS `identities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identities` (
`id` char(36) NOT NULL,
`schema_id` varchar(2048) NOT NULL,
`traits` json NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`nid` char(36) DEFAULT NULL,
`state` varchar(255) NOT NULL DEFAULT 'active',
`state_changed_at` datetime DEFAULT NULL,
`metadata_public` json DEFAULT NULL,
`metadata_admin` json DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `identities_id_nid_idx` (`id`,`nid`),
KEY `identities_nid_id_idx` (`nid`,`id`),
CONSTRAINT `identities_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identities`
--
LOCK TABLES `identities` WRITE;
/*!40000 ALTER TABLE `identities` DISABLE KEYS */;
/*!40000 ALTER TABLE `identities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_credential_identifiers`
--
DROP TABLE IF EXISTS `identity_credential_identifiers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_credential_identifiers` (
`id` char(36) NOT NULL,
`identifier` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`identity_credential_id` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`nid` char(36) DEFAULT NULL,
`identity_credential_type_id` char(36) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `identity_credential_identifiers_identifier_nid_type_uq_idx` (`nid`,`identity_credential_type_id`,`identifier`),
KEY `identity_credential_id` (`identity_credential_id`),
KEY `identity_credential_identifiers_type_id_fk_idx` (`identity_credential_type_id`),
KEY `identity_credential_identifiers_nid_id_idx` (`nid`,`id`),
KEY `identity_credential_identifiers_id_nid_idx` (`id`,`nid`),
CONSTRAINT `identity_credential_identifiers_ibfk_1` FOREIGN KEY (`identity_credential_id`) REFERENCES `identity_credentials` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_credential_identifiers_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_credential_identifiers_type_id_fk_idx` FOREIGN KEY (`identity_credential_type_id`) REFERENCES `identity_credential_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_credential_identifiers`
--
LOCK TABLES `identity_credential_identifiers` WRITE;
/*!40000 ALTER TABLE `identity_credential_identifiers` DISABLE KEYS */;
/*!40000 ALTER TABLE `identity_credential_identifiers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_credential_types`
--
DROP TABLE IF EXISTS `identity_credential_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_credential_types` (
`id` char(36) NOT NULL,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `identity_credential_types_name_idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_credential_types`
--
LOCK TABLES `identity_credential_types` WRITE;
/*!40000 ALTER TABLE `identity_credential_types` DISABLE KEYS */;
INSERT INTO `identity_credential_types` VALUES ('567a0730-7f48-4dd7-a13d-df87a51c245f','lookup_secret'),('6fa5e2e0-bfce-4631-b62b-cf2b0252b289','oidc'),('78c1b41d-8341-4507-aa60-aff1d4369670','password'),('5e29b036-aa47-457f-9fe6-aa8b854a752b','totp'),('6b213fa0-e6ad-46cb-8878-b088d2ce2e3c','webauthn');
/*!40000 ALTER TABLE `identity_credential_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_credentials`
--
DROP TABLE IF EXISTS `identity_credentials`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_credentials` (
`id` char(36) NOT NULL,
`config` json NOT NULL,
`identity_credential_type_id` char(36) NOT NULL,
`identity_id` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`nid` char(36) DEFAULT NULL,
`version` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `identity_id` (`identity_id`),
KEY `identity_credential_type_id` (`identity_credential_type_id`),
KEY `identity_credentials_nid_id_idx` (`nid`,`id`),
KEY `identity_credentials_id_nid_idx` (`id`,`nid`),
CONSTRAINT `identity_credentials_ibfk_1` FOREIGN KEY (`identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_credentials_ibfk_2` FOREIGN KEY (`identity_credential_type_id`) REFERENCES `identity_credential_types` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_credentials_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_credentials`
--
LOCK TABLES `identity_credentials` WRITE;
/*!40000 ALTER TABLE `identity_credentials` DISABLE KEYS */;
/*!40000 ALTER TABLE `identity_credentials` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_recovery_addresses`
--
DROP TABLE IF EXISTS `identity_recovery_addresses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_recovery_addresses` (
`id` char(36) NOT NULL,
`via` varchar(16) NOT NULL,
`value` varchar(400) NOT NULL,
`identity_id` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`nid` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `identity_recovery_addresses_status_via_uq_idx` (`nid`,`via`,`value`),
KEY `identity_id` (`identity_id`),
KEY `identity_recovery_addresses_status_via_idx` (`nid`,`via`,`value`),
KEY `identity_recovery_addresses_nid_id_idx` (`nid`,`id`),
KEY `identity_recovery_addresses_id_nid_idx` (`id`,`nid`),
CONSTRAINT `identity_recovery_addresses_ibfk_1` FOREIGN KEY (`identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_recovery_addresses_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_recovery_addresses`
--
LOCK TABLES `identity_recovery_addresses` WRITE;
/*!40000 ALTER TABLE `identity_recovery_addresses` DISABLE KEYS */;
/*!40000 ALTER TABLE `identity_recovery_addresses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_recovery_codes`
--
DROP TABLE IF EXISTS `identity_recovery_codes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_recovery_codes` (
`id` char(36) NOT NULL,
`code` varchar(64) NOT NULL,
`used_at` timestamp NULL DEFAULT NULL,
`identity_recovery_address_id` char(36) DEFAULT NULL,
`code_type` int(11) NOT NULL,
`expires_at` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
`issued_at` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
`selfservice_recovery_flow_id` char(36) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`nid` char(36) NOT NULL,
`identity_id` char(36) NOT NULL,
PRIMARY KEY (`id`),
KEY `identity_recovery_codes_identity_recovery_addresses_id_fk` (`identity_recovery_address_id`),
KEY `identity_recovery_codes_selfservice_recovery_flows_id_fk` (`selfservice_recovery_flow_id`),
KEY `identity_recovery_tokens_identity_id_fk` (`identity_id`),
KEY `identity_recovery_codes_nid_flow_id_idx` (`nid`,`selfservice_recovery_flow_id`),
KEY `identity_recovery_codes_id_nid_idx` (`id`,`nid`),
CONSTRAINT `identity_recovery_codes_identity_recovery_addresses_id_fk` FOREIGN KEY (`identity_recovery_address_id`) REFERENCES `identity_recovery_addresses` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_recovery_codes_networks_id_fk` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_recovery_codes_selfservice_recovery_flows_id_fk` FOREIGN KEY (`selfservice_recovery_flow_id`) REFERENCES `selfservice_recovery_flows` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_recovery_tokens_identity_id_fk` FOREIGN KEY (`identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_recovery_codes`
--
LOCK TABLES `identity_recovery_codes` WRITE;
/*!40000 ALTER TABLE `identity_recovery_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `identity_recovery_codes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_recovery_tokens`
--
DROP TABLE IF EXISTS `identity_recovery_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_recovery_tokens` (
`id` char(36) NOT NULL,
`token` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`used` tinyint(1) NOT NULL DEFAULT '0',
`used_at` datetime DEFAULT NULL,
`identity_recovery_address_id` char(36) DEFAULT NULL,
`selfservice_recovery_flow_id` char(36) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`expires_at` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`issued_at` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`nid` char(36) DEFAULT NULL,
`identity_id` char(36) NOT NULL,
`token_type` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `identity_recovery_addresses_code_uq_idx` (`token`),
KEY `identity_recovery_tokens_identity_id_fk_idx` (`identity_id`),
KEY `identity_recovery_tokens_nid_id_idx` (`nid`,`id`),
KEY `identity_recovery_tokens_id_nid_idx` (`id`,`nid`),
KEY `identity_recovery_tokens_selfservice_recovery_flow_id_idx` (`selfservice_recovery_flow_id`),
KEY `identity_recovery_tokens_identity_recovery_address_id_idx` (`identity_recovery_address_id`),
KEY `identity_recovery_tokens_token_nid_used_idx` (`nid`,`token`,`used`),
CONSTRAINT `identity_recovery_tokens_ibfk_1` FOREIGN KEY (`identity_recovery_address_id`) REFERENCES `identity_recovery_addresses` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_recovery_tokens_ibfk_2` FOREIGN KEY (`selfservice_recovery_flow_id`) REFERENCES `selfservice_recovery_flows` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_recovery_tokens_identity_id_fk_idx` FOREIGN KEY (`identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_recovery_tokens_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_recovery_tokens`
--
LOCK TABLES `identity_recovery_tokens` WRITE;
/*!40000 ALTER TABLE `identity_recovery_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `identity_recovery_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_verifiable_addresses`
--
DROP TABLE IF EXISTS `identity_verifiable_addresses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_verifiable_addresses` (
`id` char(36) NOT NULL,
`status` varchar(16) NOT NULL,
`via` varchar(16) NOT NULL,
`verified` tinyint(1) NOT NULL,
`value` varchar(400) NOT NULL,
`verified_at` datetime DEFAULT NULL,
`identity_id` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`nid` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `identity_verifiable_addresses_status_via_uq_idx` (`nid`,`via`,`value`),
KEY `identity_id` (`identity_id`),
KEY `identity_verifiable_addresses_status_via_idx` (`nid`,`via`,`value`),
KEY `identity_verifiable_addresses_nid_id_idx` (`nid`,`id`),
KEY `identity_verifiable_addresses_id_nid_idx` (`id`,`nid`),
CONSTRAINT `identity_verifiable_addresses_ibfk_1` FOREIGN KEY (`identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_verifiable_addresses_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_verifiable_addresses`
--
LOCK TABLES `identity_verifiable_addresses` WRITE;
/*!40000 ALTER TABLE `identity_verifiable_addresses` DISABLE KEYS */;
/*!40000 ALTER TABLE `identity_verifiable_addresses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_verification_codes`
--
DROP TABLE IF EXISTS `identity_verification_codes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_verification_codes` (
`id` char(36) NOT NULL,
`code_hmac` varchar(64) NOT NULL,
`used_at` timestamp NULL DEFAULT NULL,
`identity_verifiable_address_id` char(36) DEFAULT NULL,
`expires_at` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
`issued_at` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
`selfservice_verification_flow_id` char(36) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`nid` char(36) NOT NULL,
PRIMARY KEY (`id`),
KEY `identity_verification_codes_identity_verifiable_addresses_id_fk` (`identity_verifiable_address_id`),
KEY `identity_verification_codes_selfservice_verification_flows_id_fk` (`selfservice_verification_flow_id`),
KEY `identity_verification_codes_nid_flow_id_idx` (`nid`,`selfservice_verification_flow_id`),
KEY `identity_verification_codes_id_nid_idx` (`id`,`nid`),
CONSTRAINT `identity_verification_codes_identity_verifiable_addresses_id_fk` FOREIGN KEY (`identity_verifiable_address_id`) REFERENCES `identity_verifiable_addresses` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_verification_codes_networks_id_fk` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_verification_codes_selfservice_verification_flows_id_fk` FOREIGN KEY (`selfservice_verification_flow_id`) REFERENCES `selfservice_verification_flows` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_verification_codes`
--
LOCK TABLES `identity_verification_codes` WRITE;
/*!40000 ALTER TABLE `identity_verification_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `identity_verification_codes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `identity_verification_tokens`
--
DROP TABLE IF EXISTS `identity_verification_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identity_verification_tokens` (
`id` char(36) NOT NULL,
`token` varchar(64) NOT NULL,
`used` tinyint(1) NOT NULL DEFAULT '0',
`used_at` datetime DEFAULT NULL,
`expires_at` datetime NOT NULL,
`issued_at` datetime NOT NULL,
`identity_verifiable_address_id` char(36) NOT NULL,
`selfservice_verification_flow_id` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`nid` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `identity_verification_tokens_token_uq_idx` (`token`),
KEY `identity_verification_tokens_verifiable_address_id_idx` (`identity_verifiable_address_id`),
KEY `identity_verification_tokens_verification_flow_id_idx` (`selfservice_verification_flow_id`),
KEY `identity_verification_tokens_nid_id_idx` (`nid`,`id`),
KEY `identity_verification_tokens_id_nid_idx` (`id`,`nid`),
KEY `identity_verification_tokens_token_nid_used_flow_id_idx` (`nid`,`token`,`used`,`selfservice_verification_flow_id`),
CONSTRAINT `identity_verification_tokens_ibfk_1` FOREIGN KEY (`identity_verifiable_address_id`) REFERENCES `identity_verifiable_addresses` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_verification_tokens_ibfk_2` FOREIGN KEY (`selfservice_verification_flow_id`) REFERENCES `selfservice_verification_flows` (`id`) ON DELETE CASCADE,
CONSTRAINT `identity_verification_tokens_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identity_verification_tokens`
--
LOCK TABLES `identity_verification_tokens` WRITE;
/*!40000 ALTER TABLE `identity_verification_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `identity_verification_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `networks`
--
DROP TABLE IF EXISTS `networks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `networks` (
`id` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `networks`
--
LOCK TABLES `networks` WRITE;
/*!40000 ALTER TABLE `networks` DISABLE KEYS */;
INSERT INTO `networks` VALUES ('c9e0351b-8a03-443c-95eb-c583f317eca7','2023-04-04 08:57:13','2023-04-04 08:57:13');
/*!40000 ALTER TABLE `networks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `schema_migration`
--
DROP TABLE IF EXISTS `schema_migration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `schema_migration` (
`version` varchar(48) NOT NULL,
`version_self` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `schema_migration_version_idx` (`version`),
KEY `schema_migration_version_self_idx` (`version_self`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `schema_migration`
--
LOCK TABLES `schema_migration` WRITE;
/*!40000 ALTER TABLE `schema_migration` DISABLE KEYS */;
INSERT INTO `schema_migration` VALUES ('20150100000001000000',0),('20191100000001000000',0),('20191100000001000001',0),('20191100000001000002',0),('20191100000001000003',0),('20191100000001000004',0),('20191100000001000005',0),('20191100000002000000',0),('20191100000002000001',0),('20191100000002000002',0),('20191100000002000003',0),('20191100000002000004',0),('20191100000003000000',0),('20191100000004000000',0),('20191100000005000000',0),('20191100000005000001',0),('20191100000006000000',0),('20191100000007000000',0),('20191100000008000000',0),('20191100000008000001',0),('20191100000008000002',0),('20191100000008000003',0),('20191100000008000004',0),('20191100000008000005',0),('20191100000009000000',0),('20191100000009000001',0),('20191100000010000000',0),('20191100000010000001',0),('20191100000011000000',0),('20191100000012000000',0),('20200317160354000000',0),('20200317160354000001',0),('20200317160354000002',0),('20200317160354000003',0),('20200317160354000004',0),('20200401183443000000',0),('20200402142539000000',0),('20200402142539000001',0),('20200402142539000002',0),('20200519101057000000',0),('20200519101057000001',0),('20200519101057000002',0),('20200519101057000003',0),('20200519101057000004',0),('20200519101057000005',0),('20200519101057000006',0),('20200519101057000007',0),('20200519101058000000',0),('20200519101058000001',0),('20200601101000000000',0),('20200601101001000000',0),('20200601101001000001',0),('20200605111551000000',0),('20200605111551000001',0),('20200605111551000002',0),('20200607165100000000',0),('20200607165100000001',0),('20200705105359000000',0),('20200810141652000000',0),('20200810141652000001',0),('20200810141652000002',0),('20200810141652000003',0),('20200810141652000004',0),('20200810161022000000',0),('20200810161022000001',0),('20200810161022000002',0),('20200810161022000003',0),('20200810161022000004',0),('20200810161022000005',0),('20200810161022000006',0),('20200810161022000007',0),('20200810161022000008',0),('20200810162450000000',0),('20200810162450000001',0),('20200810162450000002',0),('20200810162450000003',0),('20200812124254000000',0),('20200812124254000001',0),('20200812124254000002',0),('20200812124254000003',0),('20200812124254000004',0),('20200812160551000000',0),('20200830121710000000',0),('20200830130642000000',0),('20200830130642000001',0),('20200830130642000002',0),('20200830130642000003',0),('20200830130642000004',0),('20200830130642000005',0),('20200830130642000006',0),('20200830130642000007',0),('20200830130643000000',0),('20200830130644000000',0),('20200830130644000001',0),('20200830130645000000',0),('20200830130646000000',0),('20200830130646000001',0),('20200830130646000002',0),('20200830154602000000',0),('20200830154602000001',0),('20200830154602000002',0),('20200830154602000003',0),('20200830154602000004',0),('20200830172221000000',0),('20200830172221000001',0),('20200830172221000002',0),('20200830172221000003',0),('20200831110752000000',0),('20200831110752000001',0),('20200831110752000002',0),('20200831110752000003',0),('20200831110752000004',0),('20200831110752000005',0),('20200831110752000006',0),('20200831110752000007',0),('20201201161451000000',0),('20201201161451000001',0),('20210307130558000000',0),('20210307130559000000',0),('20210307130559000001',0),('20210311102338000000',0),('20210311102338000001',0),('20210311102338000002',0),('20210311102338000003',0),('20210311102338000004',0),('20210311102338000005',0),('20210311102338000006',0),('20210311102338000007',0),('20210311102338000008',0),('20210311102338000009',0),('20210311102338000010',0),('20210311102338000011',0),('20210311102338000012',0),('20210311102338000013',0),('20210311102338000014',0),('20210311102338000015',0),('20210311102338000016',0),('20210311102338000017',0),('20210311102338000018',0),('20210311102338000019',0),('20210311102338000020',0),('20210311102338000021',0),('20210311102338000022',0),('20210311102338000023',0),('20210311102338000024',0),('20210410175418000000',0),('20210410175418000001',0),('20210410175418000002',0),('20210410175418000003',0),('20210410175418000004',0),('20210410175418000005',0),('20210410175418000006',0),('20210410175418000007',0),('20210410175418000008',0),('20210410175418000009',0),('20210410175418000010',0),('20210410175418000011',0),('20210410175418000012',0),('20210410175418000013',0),('20210410175418000014',0),('20210410175418000015',0),('20210410175418000016',0),('20210410175418000017',0),('20210410175418000018',0),('20210410175418000019',0),('20210410175418000020',0),('20210410175418000021',0),('20210410175418000022',0),('20210410175418000023',0),('20210410175418000024',0),('20210410175418000025',0),('20210410175418000026',0),('20210410175418000027',0),('20210410175418000028',0),('20210410175418000029',0),('20210410175418000030',0),('20210410175418000031',0),('20210410175418000032',0),('20210410175418000033',0),('20210410175418000034',0),('20210410175418000035',0),('20210410175418000036',0),('20210410175418000037',0),('20210410175418000038',0),('20210410175418000039',0),('20210410175418000040',0),('20210410175418000041',0),('20210410175418000042',0),('20210410175418000043',0),('20210410175418000044',0),('20210410175418000045',0),('20210410175418000046',0),('20210410175418000047',0),('20210410175418000048',0),('20210410175418000049',0),('20210410175418000050',0),('20210410175418000051',0),('20210410175418000052',0),('20210410175418000053',0),('20210410175418000054',0),('20210410175418000055',0),('20210410175418000056',0),('20210410175418000057',0),('20210410175418000058',0),('20210410175418000059',0),('20210410175418000060',0),('20210410175418000061',0),('20210410175418000062',0),('20210410175418000063',0),('20210410175418000064',0),('20210410175418000065',0),('20210410175418000066',0),('20210410175418000067',0),('20210410175418000068',0),('20210410175418000069',0),('20210410175418000070',0),('20210410175418000071',0),('20210410175418000072',0),('20210410175418000073',0),('20210410175418000074',0),('20210410175418000075',0),('20210410175418000076',0),('20210410175418000077',0),('20210410175418000078',0),('20210410175418000079',0),('20210410175418000080',0),('20210410175418000081',0),('20210410175418000082',0),('20210410175418000083',0),('20210410175418000084',0),('20210410175418000085',0),('20210410175418000086',0),('20210410175418000087',0),('20210410175418000088',0),('20210410175418000089',0),('20210504121624000000',0),('20210504121624000001',0),('20210618103120000000',0),('20210618103120000001',0),('20210618103120000002',0),('20210618103120000003',0),('20210618103120000004',0),('20210805112414000000',0),('20210805112414000001',0),('20210805112414000002',0),('20210805122535000000',0),('20210810153530000000',0),('20210810153530000001',0),('20210810153530000002',0),('20210810153530000003',0),('20210810153530000004',0),('20210813150152000000',0),('20210816113956000000',0),('20210816142650000000',0),('20210816142650000001',0),('20210816142650000002',0),('20210816142650000003',0),('20210816142650000004',0),('20210816142650000005',0),('20210817181232000000',0),('20210817181232000001',0),('20210817181232000002',0),('20210817181232000003',0),('20210817181232000004',0),('20210817181232000005',0),('20210817181232000006',0),('20210817181232000007',0),('20210829131458000000',0),('20210913095309000000',0),('20210913095309000001',0),('20210913095309000002',0),('20210913095309000003',0),('20210913095309000004',0),('20220301102701000000',0),('20220301102701000001',0),('20220420102701000000',0),('20220512102703000000',0),('20220607000001000000',0),('20220610155809000000',0),('20220802103909000000',0),('20220824165300000000',0),('20220824165300000001',0),('20220824165300000002',0),('20220825134336000000',0),('20220825134336000001',0),('20220901123209000000',0),('20220907132836000000',0),('20221024182336000000',0);
/*!40000 ALTER TABLE `schema_migration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `selfservice_errors`
--
DROP TABLE IF EXISTS `selfservice_errors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `selfservice_errors` (
`id` char(36) NOT NULL,
`errors` json NOT NULL,
`seen_at` datetime DEFAULT NULL,
`was_seen` tinyint(1) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`csrf_token` varchar(255) NOT NULL DEFAULT '',
`nid` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `selfservice_errors_nid_fk_idx` (`nid`),
KEY `selfservice_errors_nid_idx` (`id`,`nid`),
CONSTRAINT `selfservice_errors_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `selfservice_errors`
--
LOCK TABLES `selfservice_errors` WRITE;
/*!40000 ALTER TABLE `selfservice_errors` DISABLE KEYS */;
/*!40000 ALTER TABLE `selfservice_errors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `selfservice_login_flows`
--
DROP TABLE IF EXISTS `selfservice_login_flows`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `selfservice_login_flows` (
`id` char(36) NOT NULL,
`request_url` varchar(2048) NOT NULL,
`issued_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`expires_at` datetime NOT NULL,
`active_method` varchar(32) NOT NULL,
`csrf_token` varchar(255) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`forced` tinyint(1) NOT NULL DEFAULT '0',
`type` varchar(16) NOT NULL DEFAULT 'browser',
`ui` json DEFAULT NULL,
`nid` char(36) DEFAULT NULL,
`requested_aal` varchar(4) NOT NULL DEFAULT 'aal1',
`internal_context` json NOT NULL,
`oauth2_login_challenge` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `selfservice_login_flows_nid_id_idx` (`nid`,`id`),
KEY `selfservice_login_flows_id_nid_idx` (`id`,`nid`),
CONSTRAINT `selfservice_login_flows_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `selfservice_login_flows`
--
LOCK TABLES `selfservice_login_flows` WRITE;
/*!40000 ALTER TABLE `selfservice_login_flows` DISABLE KEYS */;
/*!40000 ALTER TABLE `selfservice_login_flows` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `selfservice_recovery_flows`
--
DROP TABLE IF EXISTS `selfservice_recovery_flows`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `selfservice_recovery_flows` (
`id` char(36) NOT NULL,
`request_url` varchar(2048) NOT NULL,
`issued_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`expires_at` datetime NOT NULL,
`active_method` varchar(32) DEFAULT NULL,
`csrf_token` varchar(255) NOT NULL,
`state` varchar(32) NOT NULL,
`recovered_identity_id` char(36) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`type` varchar(16) NOT NULL DEFAULT 'browser',
`ui` json DEFAULT NULL,
`nid` char(36) DEFAULT NULL,
`submit_count` int(11) NOT NULL DEFAULT '0',
`skip_csrf_check` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `recovered_identity_id` (`recovered_identity_id`),
KEY `selfservice_recovery_flows_nid_id_idx` (`nid`,`id`),
KEY `selfservice_recovery_flows_id_nid_idx` (`id`,`nid`),
CONSTRAINT `selfservice_recovery_flows_ibfk_1` FOREIGN KEY (`recovered_identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE,
CONSTRAINT `selfservice_recovery_flows_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `selfservice_recovery_flows`
--
LOCK TABLES `selfservice_recovery_flows` WRITE;
/*!40000 ALTER TABLE `selfservice_recovery_flows` DISABLE KEYS */;
/*!40000 ALTER TABLE `selfservice_recovery_flows` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `selfservice_registration_flows`
--
DROP TABLE IF EXISTS `selfservice_registration_flows`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `selfservice_registration_flows` (
`id` char(36) NOT NULL,
`request_url` varchar(2048) NOT NULL,
`issued_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`expires_at` datetime NOT NULL,
`active_method` varchar(32) NOT NULL,
`csrf_token` varchar(255) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`type` varchar(16) NOT NULL DEFAULT 'browser',
`ui` json DEFAULT NULL,
`nid` char(36) DEFAULT NULL,
`internal_context` json NOT NULL,
`oauth2_login_challenge` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `selfservice_registration_flows_nid_id_idx` (`nid`,`id`),
KEY `selfservice_registration_flows_id_nid_idx` (`id`,`nid`),
CONSTRAINT `selfservice_registration_flows_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `selfservice_registration_flows`
--
LOCK TABLES `selfservice_registration_flows` WRITE;
/*!40000 ALTER TABLE `selfservice_registration_flows` DISABLE KEYS */;
/*!40000 ALTER TABLE `selfservice_registration_flows` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `selfservice_settings_flows`
--
DROP TABLE IF EXISTS `selfservice_settings_flows`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `selfservice_settings_flows` (
`id` char(36) NOT NULL,
`request_url` varchar(2048) NOT NULL,
`issued_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`expires_at` datetime NOT NULL,
`identity_id` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`active_method` varchar(32) DEFAULT NULL,
`state` varchar(255) NOT NULL DEFAULT 'show_form',
`type` varchar(16) NOT NULL DEFAULT 'browser',
`ui` json DEFAULT NULL,
`nid` char(36) DEFAULT NULL,
`internal_context` json NOT NULL,
PRIMARY KEY (`id`),
KEY `identity_id` (`identity_id`),
KEY `selfservice_settings_flows_nid_id_idx` (`nid`,`id`),
KEY `selfservice_settings_flows_id_nid_idx` (`id`,`nid`),
CONSTRAINT `selfservice_settings_flows_ibfk_1` FOREIGN KEY (`identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE,
CONSTRAINT `selfservice_settings_flows_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `selfservice_settings_flows`
--
LOCK TABLES `selfservice_settings_flows` WRITE;
/*!40000 ALTER TABLE `selfservice_settings_flows` DISABLE KEYS */;
/*!40000 ALTER TABLE `selfservice_settings_flows` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `selfservice_verification_flows`
--
DROP TABLE IF EXISTS `selfservice_verification_flows`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `selfservice_verification_flows` (
`id` char(36) NOT NULL,
`request_url` varchar(2048) NOT NULL,
`issued_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`expires_at` datetime NOT NULL,
`csrf_token` varchar(255) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`type` varchar(16) NOT NULL DEFAULT 'browser',
`state` varchar(255) NOT NULL DEFAULT 'show_form',
`active_method` varchar(32) DEFAULT NULL,
`ui` json DEFAULT NULL,
`nid` char(36) DEFAULT NULL,
`submit_count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `selfservice_verification_flows_nid_id_idx` (`nid`,`id`),
KEY `selfservice_verification_flows_id_nid_idx` (`id`,`nid`),
CONSTRAINT `selfservice_verification_flows_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `selfservice_verification_flows`
--
LOCK TABLES `selfservice_verification_flows` WRITE;
/*!40000 ALTER TABLE `selfservice_verification_flows` DISABLE KEYS */;
/*!40000 ALTER TABLE `selfservice_verification_flows` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `session_devices`
--
DROP TABLE IF EXISTS `session_devices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `session_devices` (
`id` char(36) NOT NULL,
`ip_address` varchar(50) DEFAULT '',
`user_agent` varchar(512) DEFAULT '',
`location` varchar(512) DEFAULT '',
`session_id` char(36) NOT NULL,
`nid` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_session_device` (`nid`,`session_id`,`ip_address`,`user_agent`),
KEY `session_devices_id_nid_idx` (`id`,`nid`),
KEY `session_devices_session_id_nid_idx` (`session_id`,`nid`),
CONSTRAINT `session_devices_ibfk_1` FOREIGN KEY (`session_id`) REFERENCES `sessions` (`id`) ON DELETE CASCADE,
CONSTRAINT `session_devices_ibfk_2` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `session_devices`
--
LOCK TABLES `session_devices` WRITE;
/*!40000 ALTER TABLE `session_devices` DISABLE KEYS */;
/*!40000 ALTER TABLE `session_devices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
`id` char(36) NOT NULL,
`issued_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`expires_at` datetime NOT NULL,
`authenticated_at` datetime NOT NULL,
`identity_id` char(36) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`token` varchar(32) DEFAULT NULL,
`active` tinyint(1) DEFAULT '0',
`nid` char(36) DEFAULT NULL,
`logout_token` varchar(32) DEFAULT NULL,
`aal` varchar(4) NOT NULL DEFAULT 'aal1',
`authentication_methods` json NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sessions_token_uq_idx` (`token`),
UNIQUE KEY `sessions_logout_token_uq_idx` (`logout_token`),
KEY `sessions_identity_id_nid_idx` (`identity_id`,`nid`),
KEY `sessions_nid_id_identity_id_idx` (`nid`,`identity_id`,`id`),
KEY `sessions_id_nid_idx` (`id`,`nid`),
KEY `sessions_token_nid_idx` (`nid`,`token`),
CONSTRAINT `sessions_ibfk_1` FOREIGN KEY (`identity_id`) REFERENCES `identities` (`id`) ON DELETE CASCADE,
CONSTRAINT `sessions_nid_fk_idx` FOREIGN KEY (`nid`) REFERENCES `networks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sessions`
--
LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-04-04 10:59:15
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment