class CategoryMovies(db.Model):
category_id = db.Column(
db.Integer,
db.ForeignKey("categories.category_id"),
primary_key=True,
nullable=False,
)
movie_id = db.Column(
db.Integer,
db.ForeignKey("movies.movie_id"),
primary_key=True,
nullable=False,
)
class ParadeMiis(db.Model):
# We need to be able to select by both the Mii's ID and the logo.
mii_id = db.Column(db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True)
logo_id = db.Column(db.String(5), primary_key=True)
logo_bin = db.Column(db.LargeBinary(8000))
news = db.Column(db.String)
level = db.Column(db.Integer, default=1)
class ConciergeMiis(db.Model):
mii_id = db.Column(
db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True, unique=True
)
clothes = db.Column(db.Integer, nullable=False)
action = db.Column(db.Integer, nullable=False)
prof = db.Column(db.String(129), nullable=False)
movie_id = db.Column(db.Integer, nullable=False)
voice = db.Column(db.Boolean, default=False, nullable=False)
class MiiMsgInfo(db.Model):
# We make both the Mii's ID and message type unique, as to allow row
# identification for SQLAlchemy.
mii_id = db.Column(
db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True, nullable=False
)
type = db.Column(db.Integer, primary_key=True, nullable=False)
seq = db.Column(db.Integer, primary_key=True, nullable=False)
msg = db.Column(db.String, nullable=False)
face = db.Column(db.Integer, nullable=False)
class Rooms(db.Model):
room_id = db.Column(
db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True, nullable=False
)
bgm = db.Column(db.Enum(RoomBGMTypes))
mascot = db.Column(db.Boolean)
contact = db.Column(db.Boolean)
intro_msg = db.Column(db.String)
mii_msg = db.Column(db.String)
# TODO: implement room type specific logic
logo2_id = db.Column(db.String)
class ConciergeMiis(db.Model):
mii_id = db.Column(db.Integer,
db.ForeignKey("mii_data.mii_id"),
primary_key=True,
unique=True)
clothes = db.Column(db.Integer, nullable=False)
action = db.Column(db.Integer, nullable=False)
prof = db.Column(db.String(129), nullable=False)
movie_id = db.Column(db.Integer, nullable=False)
update_date = db.Column(db.DateTime,
default=datetime.utcnow,
onupdate=datetime.utcnow)