{ "version": "6", "dialect": "sqlite", "id": "3e4b61d3-d610-4453-a7b2-9016e1cf514b", "prevId": "a64ca9ff-5f43-4b60-9260-a7c3809857b6", "tables": { "accounts": { "name": "accounts", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "account_id": { "name": "account_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "provider_id": { "name": "provider_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "user_id": { "name": "user_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "access_token": { "name": "access_token", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "refresh_token": { "name": "refresh_token", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "id_token": { "name": "id_token", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "access_token_expires_at": { "name": "access_token_expires_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "refresh_token_expires_at": { "name": "refresh_token_expires_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "scope": { "name": "scope", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "password": { "name": "password", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(cast(unixepoch('subsecond') * 1000 as integer))" }, "updated_at": { "name": "updated_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false } }, "indexes": { "accounts_userId_idx": { "name": "accounts_userId_idx", "columns": [ "user_id" ], "isUnique": false } }, "foreignKeys": { "accounts_user_id_users_id_fk": { "name": "accounts_user_id_users_id_fk", "tableFrom": "accounts", "tableTo": "users", "columnsFrom": [ "user_id" ], "columnsTo": [ "id" ], "onDelete": "cascade", "onUpdate": "no action" } }, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "jwkss": { "name": "jwkss", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "public_key": { "name": "public_key", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "private_key": { "name": "private_key", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "expires_at": { "name": "expires_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "alg": { "name": "alg", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "crv": { "name": "crv", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false } }, "indexes": {}, "foreignKeys": {}, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "oauth_access_tokens": { "name": "oauth_access_tokens", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "token": { "name": "token", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "client_id": { "name": "client_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "session_id": { "name": "session_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "user_id": { "name": "user_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "reference_id": { "name": "reference_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "authorization_code_id": { "name": "authorization_code_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "resources": { "name": "resources", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "requested_user_info_claims": { "name": "requested_user_info_claims", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "refresh_id": { "name": "refresh_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "expires_at": { "name": "expires_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "revoked": { "name": "revoked", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "confirmation": { "name": "confirmation", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "scopes": { "name": "scopes", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false } }, "indexes": { "oauth_access_tokens_token_unique": { "name": "oauth_access_tokens_token_unique", "columns": [ "token" ], "isUnique": true }, "oauthAccessTokens_clientId_idx": { "name": "oauthAccessTokens_clientId_idx", "columns": [ "client_id" ], "isUnique": false }, "oauthAccessTokens_sessionId_idx": { "name": "oauthAccessTokens_sessionId_idx", "columns": [ "session_id" ], "isUnique": false }, "oauthAccessTokens_userId_idx": { "name": "oauthAccessTokens_userId_idx", "columns": [ "user_id" ], "isUnique": false }, "oauthAccessTokens_authorizationCodeId_idx": { "name": "oauthAccessTokens_authorizationCodeId_idx", "columns": [ "authorization_code_id" ], "isUnique": false }, "oauthAccessTokens_refreshId_idx": { "name": "oauthAccessTokens_refreshId_idx", "columns": [ "refresh_id" ], "isUnique": false } }, "foreignKeys": { "oauth_access_tokens_client_id_oauth_clients_client_id_fk": { "name": "oauth_access_tokens_client_id_oauth_clients_client_id_fk", "tableFrom": "oauth_access_tokens", "tableTo": "oauth_clients", "columnsFrom": [ "client_id" ], "columnsTo": [ "client_id" ], "onDelete": "cascade", "onUpdate": "no action" }, "oauth_access_tokens_session_id_sessions_id_fk": { "name": "oauth_access_tokens_session_id_sessions_id_fk", "tableFrom": "oauth_access_tokens", "tableTo": "sessions", "columnsFrom": [ "session_id" ], "columnsTo": [ "id" ], "onDelete": "set null", "onUpdate": "no action" }, "oauth_access_tokens_user_id_users_id_fk": { "name": "oauth_access_tokens_user_id_users_id_fk", "tableFrom": "oauth_access_tokens", "tableTo": "users", "columnsFrom": [ "user_id" ], "columnsTo": [ "id" ], "onDelete": "cascade", "onUpdate": "no action" }, "oauth_access_tokens_refresh_id_oauth_refresh_tokens_id_fk": { "name": "oauth_access_tokens_refresh_id_oauth_refresh_tokens_id_fk", "tableFrom": "oauth_access_tokens", "tableTo": "oauth_refresh_tokens", "columnsFrom": [ "refresh_id" ], "columnsTo": [ "id" ], "onDelete": "cascade", "onUpdate": "no action" } }, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "oauth_client_assertions": { "name": "oauth_client_assertions", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "expires_at": { "name": "expires_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false } }, "indexes": {}, "foreignKeys": {}, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "oauth_client_resources": { "name": "oauth_client_resources", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "client_id": { "name": "client_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "resource_id": { "name": "resource_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "metadata": { "name": "metadata", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false } }, "indexes": { "oauthClientResources_clientId_resourceId_uidx": { "name": "oauthClientResources_clientId_resourceId_uidx", "columns": [ "client_id", "resource_id" ], "isUnique": true }, "oauthClientResources_clientId_idx": { "name": "oauthClientResources_clientId_idx", "columns": [ "client_id" ], "isUnique": false }, "oauthClientResources_resourceId_idx": { "name": "oauthClientResources_resourceId_idx", "columns": [ "resource_id" ], "isUnique": false } }, "foreignKeys": { "oauth_client_resources_client_id_oauth_clients_client_id_fk": { "name": "oauth_client_resources_client_id_oauth_clients_client_id_fk", "tableFrom": "oauth_client_resources", "tableTo": "oauth_clients", "columnsFrom": [ "client_id" ], "columnsTo": [ "client_id" ], "onDelete": "cascade", "onUpdate": "no action" }, "oauth_client_resources_resource_id_oauth_resources_identifier_fk": { "name": "oauth_client_resources_resource_id_oauth_resources_identifier_fk", "tableFrom": "oauth_client_resources", "tableTo": "oauth_resources", "columnsFrom": [ "resource_id" ], "columnsTo": [ "identifier" ], "onDelete": "cascade", "onUpdate": "no action" } }, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "oauth_clients": { "name": "oauth_clients", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "client_id": { "name": "client_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "client_secret": { "name": "client_secret", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "client_discovery_id": { "name": "client_discovery_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "disabled": { "name": "disabled", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false, "default": false }, "skip_consent": { "name": "skip_consent", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "enable_end_session": { "name": "enable_end_session", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "subject_type": { "name": "subject_type", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "scopes": { "name": "scopes", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "client_credentials_scopes": { "name": "client_credentials_scopes", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false, "default": "'[]'" }, "user_id": { "name": "user_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "updated_at": { "name": "updated_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "name": { "name": "name", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "uri": { "name": "uri", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "icon": { "name": "icon", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "contacts": { "name": "contacts", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "tos": { "name": "tos", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "policy": { "name": "policy", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "software_id": { "name": "software_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "software_version": { "name": "software_version", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "software_statement": { "name": "software_statement", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "redirect_uris": { "name": "redirect_uris", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "post_logout_redirect_uris": { "name": "post_logout_redirect_uris", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "backchannel_logout_uri": { "name": "backchannel_logout_uri", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "backchannel_logout_session_required": { "name": "backchannel_logout_session_required", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "token_endpoint_auth_method": { "name": "token_endpoint_auth_method", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "application_type": { "name": "application_type", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "jwks": { "name": "jwks", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "jwks_uri": { "name": "jwks_uri", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "grant_types": { "name": "grant_types", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "response_types": { "name": "response_types", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "require_pkce": { "name": "require_pkce", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "dpop_bound_access_tokens": { "name": "dpop_bound_access_tokens", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false, "default": false }, "reference_id": { "name": "reference_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "metadata": { "name": "metadata", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false } }, "indexes": { "oauth_clients_client_id_unique": { "name": "oauth_clients_client_id_unique", "columns": [ "client_id" ], "isUnique": true }, "oauthClients_userId_idx": { "name": "oauthClients_userId_idx", "columns": [ "user_id" ], "isUnique": false } }, "foreignKeys": { "oauth_clients_user_id_users_id_fk": { "name": "oauth_clients_user_id_users_id_fk", "tableFrom": "oauth_clients", "tableTo": "users", "columnsFrom": [ "user_id" ], "columnsTo": [ "id" ], "onDelete": "cascade", "onUpdate": "no action" } }, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "oauth_consents": { "name": "oauth_consents", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "client_id": { "name": "client_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "user_id": { "name": "user_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "reference_id": { "name": "reference_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "resources": { "name": "resources", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "requested_user_info_claims": { "name": "requested_user_info_claims", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "scopes": { "name": "scopes", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "updated_at": { "name": "updated_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false } }, "indexes": { "oauthConsents_clientId_idx": { "name": "oauthConsents_clientId_idx", "columns": [ "client_id" ], "isUnique": false }, "oauthConsents_userId_idx": { "name": "oauthConsents_userId_idx", "columns": [ "user_id" ], "isUnique": false } }, "foreignKeys": { "oauth_consents_client_id_oauth_clients_client_id_fk": { "name": "oauth_consents_client_id_oauth_clients_client_id_fk", "tableFrom": "oauth_consents", "tableTo": "oauth_clients", "columnsFrom": [ "client_id" ], "columnsTo": [ "client_id" ], "onDelete": "cascade", "onUpdate": "no action" }, "oauth_consents_user_id_users_id_fk": { "name": "oauth_consents_user_id_users_id_fk", "tableFrom": "oauth_consents", "tableTo": "users", "columnsFrom": [ "user_id" ], "columnsTo": [ "id" ], "onDelete": "cascade", "onUpdate": "no action" } }, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "oauth_refresh_tokens": { "name": "oauth_refresh_tokens", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "token": { "name": "token", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "client_id": { "name": "client_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "session_id": { "name": "session_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "user_id": { "name": "user_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "reference_id": { "name": "reference_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "authorization_code_id": { "name": "authorization_code_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "resources": { "name": "resources", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "requested_user_info_claims": { "name": "requested_user_info_claims", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "expires_at": { "name": "expires_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "revoked": { "name": "revoked", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "rotated_at": { "name": "rotated_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "rotation_replay_response": { "name": "rotation_replay_response", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "rotation_replay_expires_at": { "name": "rotation_replay_expires_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "auth_time": { "name": "auth_time", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "confirmation": { "name": "confirmation", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "scopes": { "name": "scopes", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false } }, "indexes": { "oauth_refresh_tokens_token_unique": { "name": "oauth_refresh_tokens_token_unique", "columns": [ "token" ], "isUnique": true }, "oauthRefreshTokens_clientId_idx": { "name": "oauthRefreshTokens_clientId_idx", "columns": [ "client_id" ], "isUnique": false }, "oauthRefreshTokens_sessionId_idx": { "name": "oauthRefreshTokens_sessionId_idx", "columns": [ "session_id" ], "isUnique": false }, "oauthRefreshTokens_userId_idx": { "name": "oauthRefreshTokens_userId_idx", "columns": [ "user_id" ], "isUnique": false }, "oauthRefreshTokens_authorizationCodeId_idx": { "name": "oauthRefreshTokens_authorizationCodeId_idx", "columns": [ "authorization_code_id" ], "isUnique": false } }, "foreignKeys": { "oauth_refresh_tokens_client_id_oauth_clients_client_id_fk": { "name": "oauth_refresh_tokens_client_id_oauth_clients_client_id_fk", "tableFrom": "oauth_refresh_tokens", "tableTo": "oauth_clients", "columnsFrom": [ "client_id" ], "columnsTo": [ "client_id" ], "onDelete": "cascade", "onUpdate": "no action" }, "oauth_refresh_tokens_session_id_sessions_id_fk": { "name": "oauth_refresh_tokens_session_id_sessions_id_fk", "tableFrom": "oauth_refresh_tokens", "tableTo": "sessions", "columnsFrom": [ "session_id" ], "columnsTo": [ "id" ], "onDelete": "set null", "onUpdate": "no action" }, "oauth_refresh_tokens_user_id_users_id_fk": { "name": "oauth_refresh_tokens_user_id_users_id_fk", "tableFrom": "oauth_refresh_tokens", "tableTo": "users", "columnsFrom": [ "user_id" ], "columnsTo": [ "id" ], "onDelete": "cascade", "onUpdate": "no action" } }, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "oauth_resources": { "name": "oauth_resources", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "identifier": { "name": "identifier", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "name": { "name": "name", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "access_token_ttl": { "name": "access_token_ttl", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "refresh_token_ttl": { "name": "refresh_token_ttl", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "signing_algorithm": { "name": "signing_algorithm", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "signing_key_id": { "name": "signing_key_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "allowed_scopes": { "name": "allowed_scopes", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "custom_claims": { "name": "custom_claims", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "dpop_bound_access_tokens_required": { "name": "dpop_bound_access_tokens_required", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false, "default": false }, "disabled": { "name": "disabled", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false, "default": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "updated_at": { "name": "updated_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "policy_version": { "name": "policy_version", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false, "default": 1 }, "metadata": { "name": "metadata", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false } }, "indexes": { "oauth_resources_identifier_unique": { "name": "oauth_resources_identifier_unique", "columns": [ "identifier" ], "isUnique": true } }, "foreignKeys": {}, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "sessions": { "name": "sessions", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "expires_at": { "name": "expires_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "token": { "name": "token", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(cast(unixepoch('subsecond') * 1000 as integer))" }, "updated_at": { "name": "updated_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "ip_address": { "name": "ip_address", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "user_agent": { "name": "user_agent", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "user_id": { "name": "user_id", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "impersonated_by": { "name": "impersonated_by", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false } }, "indexes": { "sessions_token_unique": { "name": "sessions_token_unique", "columns": [ "token" ], "isUnique": true }, "sessions_userId_idx": { "name": "sessions_userId_idx", "columns": [ "user_id" ], "isUnique": false } }, "foreignKeys": { "sessions_user_id_users_id_fk": { "name": "sessions_user_id_users_id_fk", "tableFrom": "sessions", "tableTo": "users", "columnsFrom": [ "user_id" ], "columnsTo": [ "id" ], "onDelete": "cascade", "onUpdate": "no action" } }, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "users": { "name": "users", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "name": { "name": "name", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "email": { "name": "email", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "email_verified": { "name": "email_verified", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": false }, "image": { "name": "image", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(cast(unixepoch('subsecond') * 1000 as integer))" }, "updated_at": { "name": "updated_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(cast(unixepoch('subsecond') * 1000 as integer))" }, "role": { "name": "role", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "banned": { "name": "banned", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false, "default": false }, "ban_reason": { "name": "ban_reason", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "ban_expires": { "name": "ban_expires", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "preferred_username": { "name": "preferred_username", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false } }, "indexes": { "users_email_unique": { "name": "users_email_unique", "columns": [ "email" ], "isUnique": true } }, "foreignKeys": {}, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "verifications": { "name": "verifications", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "identifier": { "name": "identifier", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "value": { "name": "value", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "expires_at": { "name": "expires_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(cast(unixepoch('subsecond') * 1000 as integer))" }, "updated_at": { "name": "updated_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(cast(unixepoch('subsecond') * 1000 as integer))" } }, "indexes": { "verifications_identifier_idx": { "name": "verifications_identifier_idx", "columns": [ "identifier" ], "isUnique": false } }, "foreignKeys": {}, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "invites": { "name": "invites", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "token_hash": { "name": "token_hash", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "email": { "name": "email", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "created_by": { "name": "created_by", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "created_at": { "name": "created_at", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(current_timestamp)" }, "expires_at": { "name": "expires_at", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "consumed_at": { "name": "consumed_at", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false } }, "indexes": { "idx_invites_token_hash": { "name": "idx_invites_token_hash", "columns": [ "token_hash" ], "isUnique": true }, "idx_invites_email": { "name": "idx_invites_email", "columns": [ "email" ], "isUnique": true }, "idx_invites_created_by_created_at": { "name": "idx_invites_created_by_created_at", "columns": [ "created_by", "created_at" ], "isUnique": false }, "idx_invites_expires_at": { "name": "idx_invites_expires_at", "columns": [ "expires_at" ], "isUnique": false } }, "foreignKeys": {}, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} }, "launcher_apps": { "name": "launcher_apps", "columns": { "id": { "name": "id", "type": "text", "primaryKey": true, "notNull": true, "autoincrement": false }, "name": { "name": "name", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "url": { "name": "url", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false }, "icon": { "name": "icon", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "tint": { "name": "tint", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "enabled": { "name": "enabled", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": true }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(cast(unixepoch('subsecond') * 1000 as integer))" }, "updated_at": { "name": "updated_at", "type": "integer", "primaryKey": false, "notNull": true, "autoincrement": false, "default": "(cast(unixepoch('subsecond') * 1000 as integer))" } }, "indexes": {}, "foreignKeys": {}, "compositePrimaryKeys": {}, "uniqueConstraints": {}, "checkConstraints": {} } }, "views": {}, "enums": {}, "_meta": { "schemas": {}, "tables": {}, "columns": { "\"oauth_clients\".\"type\"": "\"oauth_clients\".\"application_type\"" } }, "internal": { "indexes": {} } }