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