class UserDict(db.Model): __tablename__ = dbtableprefix + "userdict" indexno = db.Column(db.Integer(), primary_key=True) filename = db.Column(db.String(255), index=True) key = db.Column(db.String(250), index=True) dictionary = db.Column(db.Text()) user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) encrypted = db.Column(db.Boolean(), nullable=False, server_default='1') modtime = db.Column(db.DateTime())
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')) temp_user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE'))
class Package(db.Model): __tablename__ = dbtableprefix + 'package' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=False) type = db.Column(db.Text()) #github, zip, pip giturl = db.Column(db.String(255), nullable=True) gitsubdir = db.Column(db.Text(), nullable=True) upload = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE')) package_auth = db.relationship( 'PackageAuth', uselist=False, primaryjoin="PackageAuth.package_id==Package.id") version = db.Column(db.Integer(), server_default='1') packageversion = db.Column(db.Text()) limitation = db.Column(db.Text()) dependency = db.Column(db.Boolean(), nullable=False, server_default='0') core = db.Column(db.Boolean(), nullable=False, server_default='0') active = db.Column(db.Boolean(), nullable=False, server_default='1')
class GlobalObjectStorage(db.Model): __tablename__ = dbtableprefix + "globalobjectstorage" id = db.Column(db.Integer(), primary_key=True) key = db.Column(db.String(1024), index=True) value = db.Column(db.Text()) encrypted = db.Column(db.Boolean(), nullable=False, server_default=true()) user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) temp_user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE'))
class ChatLog(db.Model): __tablename__ = dbtableprefix + "chatlog" id = db.Column(db.Integer(), primary_key=True) filename = db.Column(db.Text()) key = db.Column(db.String(250)) message = db.Column(db.Text()) user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) temp_user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE')) owner_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) temp_owner_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE')) open_to_peer = db.Column(db.Boolean(), nullable=False, server_default='0') encrypted = db.Column(db.Boolean(), nullable=False, server_default='1') modtime = db.Column(db.DateTime())
class Email(db.Model): __tablename__ = dbtableprefix + "email" id = db.Column(db.Integer(), primary_key=True, unique=True) short = db.Column(db.String(250), db.ForeignKey(dbtableprefix + 'shortener.short', ondelete='CASCADE')) all_addr = db.Column(db.Text()) to_addr = db.Column(db.Text()) cc_addr = db.Column(db.Text()) from_addr = db.Column(db.Text()) reply_to_addr = db.Column(db.Text()) return_path_addr = db.Column(db.Text()) subject = db.Column(db.Text()) datetime_message = db.Column(db.DateTime()) datetime_received = db.Column(db.DateTime())
class ObjectStorage(db.Model): __tablename__ = dbtableprefix + "objectstorage" id = db.Column(db.Integer(), primary_key=True) key = db.Column(db.Text()) value = db.Column(db.Text())
class Uploads(db.Model): __tablename__ = dbtableprefix + "uploads" indexno = db.Column(db.Integer(), primary_key=True) key = db.Column(db.String(250)) filename = db.Column(db.Text()) yamlfile = db.Column(db.Text())
class ObjectStorage(db.Model): __tablename__ = dbtableprefix + "objectstorage" id = db.Column(db.Integer(), primary_key=True, unique=True) key = db.Column(db.String(1024), index=True) value = db.Column(db.Text())