{ "version": "6", "dialect": "sqlite", "id": "7f089d59-cb5c-47cc-8239-ca1a364ef440", "prevId": "d4f89d76-5a52-4091-a049-2723db104b27", "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 } }, "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": false, "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 }, "refresh_id": { "name": "refresh_id", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "expires_at": { "name": "expires_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "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 } }, "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_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 }, "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 }, "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 }, "token_endpoint_auth_method": { "name": "token_endpoint_auth_method", "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 }, "public": { "name": "public", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "type": { "name": "type", "type": "text", "primaryKey": false, "notNull": false, "autoincrement": false }, "require_pkce": { "name": "require_pkce", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": 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 } }, "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 }, "scopes": { "name": "scopes", "type": "text", "primaryKey": false, "notNull": true, "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 } }, "indexes": {}, "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 }, "expires_at": { "name": "expires_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "created_at": { "name": "created_at", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "revoked": { "name": "revoked", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "auth_time": { "name": "auth_time", "type": "integer", "primaryKey": false, "notNull": false, "autoincrement": false }, "scopes": { "name": "scopes", "type": "text", "primaryKey": false, "notNull": true, "autoincrement": false } }, "indexes": {}, "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": {} }, "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": {} }, "internal": { "indexes": {} } }