class PayPosters(db.Model): poster_id = db.Column(db.Integer, primary_key=True, unique=True) msg = db.Column(db.String(15), nullable=False) movie_id = db.Column(db.Integer, nullable=False) title = db.Column(db.String(47), nullable=False) type = db.Column(db.Integer, nullable=False) aspect = db.Column(db.Boolean, nullable=False)
class Posters(db.Model): poster_id = db.Column(db.Integer, primary_key=True, unique=True) msg = db.Column(db.String(15), nullable=False) movie_id = db.Column(db.Integer, nullable=False) # While a maximum of 47 characters seems arbitrary, it is what it is. # It appears they mandate the last byte in their char array is null (and sprintf), # so perhaps the internal type is char[48]? title = db.Column(db.String(47), nullable=False)
class Movies(db.Model): movie_id = db.Column(db.Integer, primary_key=True, unique=True) title = db.Column(db.String(48), nullable=False) length = db.Column(db.String(8), nullable=False) aspect = db.Column(db.Boolean, nullable=False) genre = db.Column(db.Integer, nullable=False) sp_page_id = db.Column(db.Integer, nullable=False) ds_dist = db.Column(db.Boolean, nullable=False) ds_mov_id = db.Column(db.Integer) staff = db.Column(db.Boolean, 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 PayMovies(db.Model): movie_id = db.Column(db.Integer, primary_key=True, unique=True) title = db.Column(db.String(15), nullable=False) length = db.Column(db.String(8), nullable=False) aspect = db.Column(db.Boolean, nullable=False) payenddt = db.Column(db.String(19), nullable=False) ds_dist = db.Column(db.Boolean, nullable=False) ds_mov_id = db.Column(db.Integer) staff = db.Column(db.Boolean, nullable=False) note = db.Column(db.String(76), nullable=False) dimg = db.Column(db.Boolean, nullable=False) eval = db.Column(db.Boolean, nullable=False) price = db.Column(db.Integer, nullable=False) sample = db.Column(db.Boolean, nullable=False) smpap = db.Column(db.Boolean, nullable=False) released = db.Column(db.String(10), nullable=False)
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 User(db.Model, UserMixin): # Used to login to the Admin Panel id = db.Column(db.Integer, primary_key=True, default=1) username = db.Column(db.String(100)) password_hash = db.Column(db.String) def set_password(self, password): self.password_hash = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password_hash, password)
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)
class MiiData(db.Model): mii_id = db.Column(db.Integer, primary_key=True) data = db.Column(db.LargeBinary(74), nullable=False) name = db.Column(db.String(10), nullable=False) color1 = db.Column(db.String(6), nullable=False) color2 = db.Column(db.String(6), nullable=False)
class NewMovies(db.Model): movie_id = db.Column(db.Integer, primary_key=True, unique=True) title = db.Column(db.String(48), nullable=False)