| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 |
- """asset_audit_log
- Revision ID: 126d65cbe6b4
- Revises: 202505c5cb06
- Create Date: 2024-05-27 15:48:07.399594
- """
- from alembic import op
- import sqlalchemy as sa
- # revision identifiers, used by Alembic.
- revision = "126d65cbe6b4"
- down_revision = "202505c5cb06"
- branch_labels = None
- depends_on = None
- def upgrade():
- # ### commands auto generated by Alembic - please adjust! ###
- op.create_table(
- "asset_audit_log",
- sa.Column("id", sa.Integer(), nullable=False),
- sa.Column("event_datetime", sa.DateTime(), nullable=True),
- sa.Column("event", sa.String(length=255), nullable=True),
- sa.Column("active_user_name", sa.String(length=255), nullable=True),
- sa.Column("active_user_id", sa.Integer(), nullable=True),
- sa.Column("affected_asset_id", sa.Integer(), nullable=True),
- sa.ForeignKeyConstraint(
- ["active_user_id"],
- ["fm_user.id"],
- name=op.f("asset_audit_log_active_user_id_fm_user_fkey"),
- ondelete="SET NULL",
- ),
- sa.ForeignKeyConstraint(
- ["affected_asset_id"],
- ["generic_asset.id"],
- name=op.f("asset_audit_log_affected_asset_id_generic_asset_fkey"),
- ondelete="SET NULL",
- ),
- sa.PrimaryKeyConstraint("id", name=op.f("asset_audit_log_pkey")),
- )
- # ### end Alembic commands ###
- def downgrade():
- # ### commands auto generated by Alembic - please adjust! ###
- op.drop_table("asset_audit_log")
- # ### end Alembic commands ###
|
