"""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')