wjdrGiftcode/models.py at master · Superheroff/wjdrGiftcode · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
from datebase import db
import time

class BaseUser(db.Model):
    __abstract__ = True
    id = db.Column(db.Integer, primary_key=True)
    created_at = db.Column(db.String(20), default=lambda: str(round(time.time() * 1000)))
    username = db.Column(db.String(128), nullable=True)
    email = db.Column(db.String(50), nullable=False)
    fid = db.Column(db.Integer, nullable=False, unique=False)
    endTime = db.Column(db.String(20), nullable=True)
    total = db.Column(db.Integer, nullable=True, default=0)
    success = db.Column(db.Integer, nullable=True, default=0)
    failed = db.Column(db.Integer, nullable=True, default=0)
    status = db.Column(db.Integer, nullable=True, default=0)


class User(BaseUser):
    __tablename__ = 'user'


class redeemCode(db.Model):
    # 兑换码表
    __tablename__ = 'redeemCode'
    id = db.Column(db.Integer, primary_key=True)
    created_at = db.Column(db.String(20), default=lambda: str(round(time.time() * 1000)))
    code = db.Column(db.String(30), nullable=False, unique=True)
    total = db.Column(db.Integer, nullable=True, default=0)
    success = db.Column(db.Integer, nullable=True, default=0)
    failed = db.Column(db.Integer, nullable=True, default=0)
    type = db.Column(db.Integer, nullable=False)  # 0 长期，1 限时
    endTime = db.Column(db.String(20), nullable=True)


class danmu(db.Model):
    # 弹幕
    __tablename__ = 'danmu'
    id = db.Column(db.Integer, primary_key=True)
    created_at = db.Column(db.String(20), default=lambda: str(round(time.time() * 1000)))
    username = db.Column(db.String(128), nullable=True)
    amount = db.Column(db.String(10), nullable=False)
    fid = db.Column(db.Integer, nullable=True, unique=False)
    avatar = db.Column(db.String(256), nullable=True)


class Admin(db.Model):
    # 管理员
    __tablename__ = 'admin'
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(128), nullable=True)
    password = db.Column(db.String(128), nullable=False)
    created_at = db.Column(db.String(20), default=lambda: str(round(time.time() * 1000)))
    status = db.Column(db.Integer, nullable=True, default=0)