in src/Backend/migrations/versions/2023_05_01_150034-172b63b65b0c_add_session_model.py [0:0]
def upgrade() -> None:
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"sessions",
sa.Column("id", sa.UUID(), nullable=False),
sa.Column("user_id", sa.UUID(), nullable=False),
sa.Column("expires_at", sa.DateTime(timezone=True), nullable=False),
sa.Column("created_at", sa.DateTime(timezone=True), nullable=False),
sa.Column("updated_at", sa.DateTime(timezone=True), nullable=False),
sa.ForeignKeyConstraint(
["user_id"], ["users.id"], onupdate="CASCADE", ondelete="CASCADE"
),
sa.PrimaryKeyConstraint("id"),
)
op.alter_column(
"users", "firebase_id", existing_type=sa.VARCHAR(length=100), nullable=False
)
op.alter_column(
"users", "name", existing_type=sa.VARCHAR(length=100), nullable=False
)
op.alter_column(
"users", "email_address", existing_type=sa.VARCHAR(length=100), nullable=False
)
op.create_unique_constraint(None, "users", ["firebase_id"])