Newer
Older
gnexus-book / server / alembic / versions / b59666c46655_data_ownership.py
"""data ownership

Revision ID: b59666c46655
Revises: 9d8e9f47a7b0
Create Date: 2026-11-20 15:54:42.093475

"""
from __future__ import annotations

from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision: str = 'b59666c46655'
down_revision: Union[str, None] = '9d8e9f47a7b0'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.add_column('documents', sa.Column('owner_user_id', sa.UUID(), nullable=True))
    op.create_index(op.f('ix_documents_owner_user_id'), 'documents', ['owner_user_id'], unique=False)
    op.create_foreign_key(
        'fk_documents_owner_user_id_users',
        'documents',
        'users',
        ['owner_user_id'],
        ['id'],
        ondelete='SET NULL',
    )
    op.add_column('inventory_items', sa.Column('owner_user_id', sa.UUID(), nullable=True))
    op.create_index(op.f('ix_inventory_items_owner_user_id'), 'inventory_items', ['owner_user_id'], unique=False)
    op.create_foreign_key(
        'fk_inventory_items_owner_user_id_users',
        'inventory_items',
        'users',
        ['owner_user_id'],
        ['id'],
        ondelete='SET NULL',
    )


def downgrade() -> None:
    op.drop_constraint(
        'fk_inventory_items_owner_user_id_users',
        'inventory_items',
        type_='foreignkey',
    )
    op.drop_index(op.f('ix_inventory_items_owner_user_id'), table_name='inventory_items')
    op.drop_column('inventory_items', 'owner_user_id')
    op.drop_constraint(
        'fk_documents_owner_user_id_users',
        'documents',
        type_='foreignkey',
    )
    op.drop_index(op.f('ix_documents_owner_user_id'), table_name='documents')
    op.drop_column('documents', 'owner_user_id')