1  from alembic import op
 2  import sqlalchemy as sa
 3  
 4  revision = '010'
 5  down_revision = '009'
 6  branch_labels = None
 7  depends_on = None
 8  
 9  def upgrade():
10      try:
11          op.create_table(
12              'guard_events',
13              sa.Column('id', sa.Integer(), primary_key=True, index=True),
14              sa.Column('project_id', sa.Integer(), sa.ForeignKey('projects.id'), nullable=False, index=True),
15              sa.Column('guard_project', sa.String(255), nullable=False),
16              sa.Column('user_id', sa.Integer(), sa.ForeignKey('users.id'), nullable=True),
17              sa.Column('phase', sa.String(10), nullable=False),
18              sa.Column('action', sa.String(10), nullable=False),
19              sa.Column('mode', sa.String(10), nullable=False, server_default='block'),
20              sa.Column('text_checked', sa.Text(), nullable=True),
21              sa.Column('guard_response', sa.Text(), nullable=True),
22              sa.Column('date', sa.DateTime(), nullable=False, index=True),
23          )
24      except Exception as e:
25          print(f"Error creating guard_events: {e}")
26  
27  def downgrade():
28      try:
29          op.drop_table('guard_events')
30      except Exception as e:
31          print(f"Error dropping guard_events: {e}")