diff --git 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
@@ -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",