diff --git a/app/db/migrations/versions/058eb11c5b17_user_reset_in_table.py b/app/db/migrations/versions/058eb11c5b17_user_reset_in_table.py index 8f18a01..ff7f620 100644 --- a/app/db/migrations/versions/058eb11c5b17_user_reset_in_table.py +++ b/app/db/migrations/versions/058eb11c5b17_user_reset_in_table.py @@ -24,8 +24,8 @@ def upgrade() -> None: sa.Column( "lifetime_used_traffic", sa.BigInteger(), - server_default=sa.sql.null(), - nullable=True, + server_default="0", + nullable=False, ), ) op.add_column( diff --git a/app/db/models.py b/app/db/models.py index 497d2f6..f322f58 100644 --- a/app/db/models.py +++ b/app/db/models.py @@ -91,7 +91,9 @@ class User(Base): # proxies = relationship("Proxy", back_populates="user", cascade="all, delete-orphan") status = Column(Enum(UserStatus), nullable=False, default=UserStatus.active) used_traffic = Column(BigInteger, default=0) - lifetime_used_traffic = Column(BigInteger, default=0) + lifetime_used_traffic = Column( + BigInteger, default=0, server_default="0", nullable=False + ) traffic_reset_at = Column(DateTime) node_usages = relationship( "NodeUserUsage",