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())
