OpenRAG is a comprehensive, single package Retrieval-Augmented Generation platform built on Langflow, Docling, and Opensearch.
Python
"""initial RBAC schema
Revision ID: 0001_initial
Revises:
Create Date: 2026-05-01 00:00:00.000000
"""
from typing import Sequence, Union
from alembic import op
import sqlalchemy as sa
revision: str = "0001_initial"
down_revision: Union[str, Sequence[str], None] = None
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None
def upgrade() -> None:
op.create_table(
"users",
sa.Column("id", sa.String(length=64), primary_key=True),
sa.Column("oauth_provider", sa.String(length=32), nullable=False),
sa.Column("oauth_subject", sa.String(length=255), nullable=False),
sa.Column("email", sa.String(), nullable=True),
sa.Column("email_lookup_hash", sa.String(length=64), nullable=True),
sa.Column("display_name", sa.String(), nullable=True),
sa.Column("picture_url", sa.String(length=2048), nullable=True),
sa.Column("is_active", sa.Boolean(), nullable=False, server_default=sa.true()),
sa.Column("created_at", sa.DateTime(), nullable=False),
sa.Column("updated_at", sa.DateTime(), nullable=False),
sa.Column("last_login", sa.DateTime(), nullable=True),
sa.UniqueConstraint("oauth_provider", "oauth_subject", name="uq_users_oauth"),
sa.UniqueConstraint("email_lookup_hash", name="uq_users_email_lookup_hash"),
)
op.create_index("ix_users_oauth_provider", "users", ["oauth_provider"])
op.create_index("ix_users_oauth_subject", "users", ["oauth_subject"])
op.create_index("ix_users_email_lookup_hash", "users", ["email_lookup_hash"])
op.create_table(
"roles",
sa.Column("id", sa.String(length=64), primary_key=True),
sa.Column("name", sa.String(length=64), nullable=False),
sa.Column("description", sa.String(length=512), nullable=True),
sa.Column("is_system", sa.Boolean(), nullable=False, server_default=sa.false()),
sa.Column("created_at", sa.DateTime(), nullable=False),
sa.Column("updated_at", sa.DateTime(), nullable=False),
sa.UniqueConstraint("name", name="uq_roles_name"),
)
op.create_index("ix_roles_name", "roles", ["name"])
op.create_table(
"permissions",
sa.Column("id", sa.String(length=64), primary_key=True),
sa.Column("name", sa.String(length=128), nullable=False),
sa.Column("resource", sa.String(length=64), nullable=False),
sa.Column("action", sa.String(length=64), nullable=False),
sa.Column("description", sa.String(length=512), nullable=True),
sa.UniqueConstraint("name", name="uq_permissions_name"),
)
op.create_index("ix_permissions_name", "permissions", ["name"])
op.create_index("ix_permissions_resource", "permissions", ["resource"])
op.create_table(
"role_permissions",
sa.Column("role_id", sa.String(length=64), nullable=False),
sa.Column("permission_id", sa.String(length=64), nullable=False),
sa.ForeignKeyConstraint(["role_id"], ["roles.id"], name="fk_role_permissions_role_id_roles"),
sa.ForeignKeyConstraint(
["permission_id"], ["permissions.id"],
name="fk_role_permissions_permission_id_permissions",
),
sa.PrimaryKeyConstraint("role_id", "permission_id", name="pk_role_permissions"),
)
op.create_table(
"user_roles",
sa.Column("user_id", sa.String(length=64), nullable=False),
sa.Column("role_id", sa.String(length=64), nullable=False),
sa.Column("granted_by", sa.String(length=64), nullable=True),
sa.Column("granted_at", sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(["user_id"], ["users.id"], name="fk_user_roles_user_id_users"),
sa.ForeignKeyConstraint(["role_id"], ["roles.id"], name="fk_user_roles_role_id_roles"),
sa.ForeignKeyConstraint(
["granted_by"], ["users.id"], name="fk_user_roles_granted_by_users"
),
sa.PrimaryKeyConstraint("user_id", "role_id", name="pk_user_roles"),
)
op.create_table(
"user_preferences",
sa.Column("user_id", sa.String(length=64), primary_key=True),
sa.Column("agent_system_prompt_override", sa.String(), nullable=True),
sa.Column("default_kf_id", sa.String(length=128), nullable=True),
sa.Column("theme", sa.String(length=32), nullable=True),
sa.Column("language", sa.String(length=16), nullable=True),
sa.Column("provider_overrides", sa.String(), nullable=True),
sa.Column("preferences_json", sa.String(), nullable=True),
sa.Column("updated_at", sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(
["user_id"], ["users.id"], name="fk_user_preferences_user_id_users"
),
)
op.create_table(
"api_keys",
sa.Column("id", sa.String(length=64), primary_key=True),
sa.Column("user_id", sa.String(length=64), nullable=False),
sa.Column("name", sa.String(length=128), nullable=False),
sa.Column("key_hash", sa.String(length=128), nullable=False),
sa.Column("key_prefix", sa.String(length=32), nullable=False),
sa.Column("scope_role_ids", sa.JSON(), nullable=True),
sa.Column("last_used_at", sa.DateTime(), nullable=True),
sa.Column("created_at", sa.DateTime(), nullable=False),
sa.Column("revoked_at", sa.DateTime(), nullable=True),
sa.Column("revoked", sa.Boolean(), nullable=False, server_default=sa.false()),
sa.ForeignKeyConstraint(["user_id"], ["users.id"], name="fk_api_keys_user_id_users"),
sa.UniqueConstraint("key_hash", name="uq_api_keys_key_hash"),
)
op.create_index("ix_api_keys_user_id", "api_keys", ["user_id"])
op.create_index("ix_api_keys_key_hash", "api_keys", ["key_hash"])
op.create_table(
"audit_log",
sa.Column("id", sa.String(length=64), primary_key=True),
sa.Column("ts", sa.DateTime(), nullable=False),
sa.Column("actor_user_id", sa.String(length=64), nullable=True),
sa.Column("actor_api_key_id", sa.String(length=64), nullable=True),
sa.Column("event", sa.String(length=128), nullable=False),
sa.Column("target_type", sa.String(length=64), nullable=True),
sa.Column("target_id", sa.String(length=128), nullable=True),
sa.Column("metadata", sa.JSON(), nullable=True),
sa.Column("ip", sa.String(length=64), nullable=True),
sa.Column("user_agent", sa.String(length=512), nullable=True),
sa.ForeignKeyConstraint(
["actor_user_id"], ["users.id"], name="fk_audit_log_actor_user_id_users"
),
)
op.create_index("ix_audit_log_ts", "audit_log", ["ts"])
op.create_index("ix_audit_log_event", "audit_log", ["event"])
op.create_index("ix_audit_log_actor_user_id", "audit_log", ["actor_user_id"])
op.create_table(
"migration_status",
sa.Column("name", sa.String(length=128), primary_key=True),
sa.Column("completed_at", sa.DateTime(), nullable=False),
sa.Column("notes", sa.String(length=2048), nullable=False, server_default=""),
)
def downgrade() -> None:
op.drop_table("migration_status")
op.drop_index("ix_audit_log_actor_user_id", table_name="audit_log")
op.drop_index("ix_audit_log_event", table_name="audit_log")
op.drop_index("ix_audit_log_ts", table_name="audit_log")
op.drop_table("audit_log")
op.drop_index("ix_api_keys_key_hash", table_name="api_keys")
op.drop_index("ix_api_keys_user_id", table_name="api_keys")
op.drop_table("api_keys")
op.drop_table("user_preferences")
op.drop_table("user_roles")
op.drop_table("role_permissions")
op.drop_index("ix_permissions_resource", table_name="permissions")
op.drop_index("ix_permissions_name", table_name="permissions")
op.drop_table("permissions")
op.drop_index("ix_roles_name", table_name="roles")
op.drop_table("roles")
op.drop_index("ix_users_email_lookup_hash", table_name="users")
op.drop_index("ix_users_oauth_subject", table_name="users")
op.drop_index("ix_users_oauth_provider", table_name="users")
op.drop_table("users")