class s_data_admin(db.Model):
__bind_key__ = 'localdb'
__tablename__ = 's_data_admin'
id = db.Column(db.Integer, primary_key=True,autoincrement=True)
username = db.Column(db.String(10), unique=True)
password = db.Column(db.String(16))
def __init__(self,username,password):
self.username = username
self.password = password
def __repr__(self):
return '<s_data_admin %r>' % self.id
class s_plat_fightbfs(db.Model):
__tablename__ = 's_plat_fightbfs'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
userId = db.Column(db.Integer, db.ForeignKey('s_plat_user.id'))
wins = db.Column(db.Integer)
losts = db.Column(db.Integer)
bf = db.Column(db.Integer)
def __init__(self, id, userId, wins, losts, bf):
self.id = id
self.userId = userId
self.wins = wins
self.losts = losts
self.bf = bf
def __repr__(self):
return '<s_plat_fightbfs %r>' % self.id
class s_data_numbyday(db.Model):
__bind_key__ = 'localdb'
__tablename__ = 's_data_numbyday'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
time = db.Column(db.Numeric)
usernum = db.Column(db.Integer)
usertolnum = db.Column(db.Integer)
gamenum = db.Column(db.Integer)
gametolnum = db.Column(db.Integer)
def __init__(self, time, usernum, usertolnum, gamenum, gametolnum):
self.time = time
self.usernum = usernum
self.usertolnum = usertolnum
self.gamenum = gamenum
self.gametolnum = gametolnum
def __repr__(self):
return '<s_data_numbyday %r>' % self.id
class s_plat_fightlog(db.Model):
__tablename__ = 's_plat_fightlog'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
roomId = db.Column(db.Integer)
roomCfg = db.Column(db.String(255))
logTime = db.Column(db.Numeric(13, 0))
isHaoren = db.Column(db.Integer)
u1 = db.Column(db.Integer)
u2 = db.Column(db.Integer)
u3 = db.Column(db.Integer)
u4 = db.Column(db.Integer)
u5 = db.Column(db.Integer)
u6 = db.Column(db.Integer)
u7 = db.Column(db.Integer)
u8 = db.Column(db.Integer)
c1 = db.Column(db.Integer)
c2 = db.Column(db.Integer)
c3 = db.Column(db.Integer)
c4 = db.Column(db.Integer)
c5 = db.Column(db.Integer)
c6 = db.Column(db.Integer)
c7 = db.Column(db.Integer)
c8 = db.Column(db.Integer)
n1 = db.Column(db.Integer)
n2 = db.Column(db.Integer)
n3 = db.Column(db.Integer)
n4 = db.Column(db.Integer)
n5 = db.Column(db.Integer)
n6 = db.Column(db.Integer)
n7 = db.Column(db.Integer)
n8 = db.Column(db.Integer)
def __init__(self, id, roomId, roomCfg, logTime, isHaoren, u1, u2, u3, u4,
u5, u6, u7, u8, c1, c2, c3, c4, c5, c6, c7, c8, n1, n2, n3,
n4, n5, n6, n7, n8):
self.id = id
self.roomId = roomId
self.roomCfg = roomCfg
self.logTime = logTime
self.isHaoren = isHaoren
self.u1 = u1
self.u2 = u2
self.u3 = u3
self.u4 = u4
self.u5 = u5
self.u6 = u6
self.u7 = u7
self.u8 = u8
self.c1 = c1
self.c2 = c2
self.c3 = c3
self.c4 = c4
self.c5 = c5
self.c6 = c6
self.c7 = c7
self.c8 = c8
self.n1 = n1
self.n2 = n2
self.n3 = n3
self.n4 = n4
self.n5 = n5
self.n6 = n6
self.n7 = n7
self.n8 = n8
def __repr__(self):
return '<s_plat_fightlog %r>' % self.id
class s_data_usergeo(db.Model):
__bind_key__ = 'localdb'
__tablename__ = 's_data_usergeo'
id = db.Column(db.Integer, primary_key=True,autoincrement=True)
userid = db.Column(db.Integer)
ip = db.Column(db.String(32))
city_code = db.Column(db.Integer)
province = db.Column(db.String(32))
city = db.Column(db.String(32))
pos_x = db.Column(db.Float)
pos_y = db.Column(db.Float)
iswx = db.Column(db.Integer)
wxsex = db.Column(db.Integer)
game = db.Column(db.Integer)
name = db.Column(db.String(32))
def __init__(self,userid,ip="",city_code = 0,province = "",city = "",pos_x = 0,pos_y = 0,iswx = 0,wxsex = 0,game = 0,name = ""):
self.userid = userid
self.ip = ip
self.city_code = city_code
self.province = province
self.city = city
self.pos_x = pos_x
self.pos_y = pos_y
self.iswx = iswx
self.wxsex = wxsex
self.game = game
self.name = name
def __repr__(self):
return '<s_data_usergeo %r>' % self.id
class s_plat_user(db.Model):
__tablename__ = 's_plat_user'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
wxsex = db.Column(db.Integer)
canTuiguang = db.Column(db.Integer)
score = db.Column(db.String(32))
iswx = db.Column(db.Integer)
vipExp = db.Column(db.Integer)
regIp = db.Column(db.String(20))
regTime = db.Column(db.Numeric(13, 0))
wxtoken = db.Column(db.String(128))
createBy = db.Column(db.Integer)
tel = db.Column(db.String(16))
vipLv = db.Column(db.Integer)
webid = db.Column(db.String(20))
isLock = db.Column(db.Integer)
token = db.Column(db.String(32))
money = db.Column(db.String(32))
des = db.Column(db.String(255))
wxhead = db.Column(db.String(255))
name = db.Column(db.String(255))
wxid = db.Column(db.String(128))
bfs = db.relationship('s_plat_fightbfs',
backref='user',
lazy='select',
uselist=False)
def __init__(self, id, wxsex, canTuiguang, score, iswx, vipExp, regIp,
regTime, wxtoken, createBy, tel, vipLv, webid, isLock, token,
money, des, wxhead, name, wxid):
self.id = id
self.wxsex = wxsex
self.canTuiguang = canTuiguang
self.score = score
self.iswx = iswx
self.vipExp = vipExp
self.regIp = regIp
self.regTime = regTime
self.wxtoken = wxtoken
self.createBy = createBy
self.tel = tel
self.vipLv = vipLv
self.webid = webid
self.isLock = isLock
self.token = token
self.money = money
self.des = des
self.wxhead = wxhead
self.name = name
self.wxid = wxid
def __repr__(self):
return '<s_plat_user %r>' % self.id