class UploadsUserAuth(db.Model):
__tablename__ = dbtableprefix + "uploadsuserauth"
id = db.Column(db.Integer(), primary_key=True, unique=True)
uploads_indexno = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'), nullable=False, index=True)
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'), index=True)
temp_user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE'), index=True)
class UserDictKeys(db.Model):
__tablename__ = dbtableprefix + "userdictkeys"
indexno = db.Column(db.Integer(), primary_key=True)
filename = db.Column(db.Text())
key = db.Column(db.String(250))
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
class UserRoles(db.Model):
__tablename__ = dbtableprefix + 'user_roles'
id = db.Column(db.Integer(), primary_key=True, unique=True)
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'), index=True)
role_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'role.id', ondelete='CASCADE'), index=True)
class PackageAuth(db.Model):
__tablename__ = dbtableprefix + 'package_auth'
id = db.Column(db.Integer, primary_key=True, unique=True)
package_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'package.id', ondelete='CASCADE'))
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
authtype = db.Column(db.String(255), server_default='owner')