class Messages(db.Model):
__tablename__ = dbtableprefix + "messages"
id = db.Column(db.Integer(),
db.Sequence(dbtableprefix + 'messages_id_seq'),
primary_key=True)
message = db.Column(db.Text())
create_time = db.Column(db.DateTime(), server_default=db.func.now())
class Attachments(db.Model):
__tablename__ = dbtableprefix + "attachments"
id = db.Column(db.Integer(), primary_key=True)
key = db.Column(db.String(250))
dictionary = db.Column(db.Text())
question = db.Column(db.Integer())
filename = db.Column(db.Text())
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)
user_id = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
role_id = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'role.id', ondelete='CASCADE'))
class Install(db.Model):
__tablename__ = dbtableprefix + "install"
id = db.Column(db.Integer(), primary_key=True)
hostname = db.Column(db.Text())
version = db.Column(db.Integer())
packageversion = db.Column(db.Text())
package_id = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'package.id', ondelete='CASCADE'))
class PackageAuth(db.Model):
__tablename__ = dbtableprefix + 'package_auth'
id = db.Column(db.Integer, primary_key=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')
class SpeakList(db.Model):
__tablename__ = dbtableprefix + "speaklist"
id = db.Column(db.Integer(), primary_key=True)
filename = db.Column(db.Text())
key = db.Column(db.String(250))
phrase = db.Column(db.Text())
question = db.Column(db.Integer())
type = db.Column(db.String(20))
language = db.Column(db.String(10))
dialect = db.Column(db.String(10))
upload = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'))
encrypted = db.Column(db.Boolean(), nullable=False, server_default='1')
class UserAuth(db.Model, UserMixin):
__tablename__ = dbtableprefix + 'user_auth'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
password = db.Column(db.String(255), nullable=False, server_default='')
reset_password_token = db.Column(db.String(100),
nullable=False,
server_default='')
#active = db.Column(db.Boolean(), nullable=False, server_default='0')
user = db.relationship('User',
uselist=False,
primaryjoin="User.id==UserAuth.user_id")
class Attachments(db.Model):
__tablename__ = dbtableprefix + "attachments"
id = db.Column(db.Integer(), primary_key=True)
key = db.Column(db.String(250))
dictionary = db.Column(db.Text())
question = db.Column(db.Integer())
filename = db.Column(db.Text())
encrypted = db.Column(db.Boolean(), nullable=False, server_default='1')
class UserDict(db.Model):
__tablename__ = dbtableprefix + "userdict"
indexno = db.Column(db.Integer(), primary_key=True)
filename = db.Column(db.Text())
key = db.Column(db.String(250))
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')
class TicketNote(db.Model):
__tablename__ = dbtableprefix + "ticketnote"
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
note_type = db.Column(db.String(50), nullable=False)
ticket_id = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'ticket.id', ondelete='CASCADE'))
create_time = db.Column(db.DateTime(), server_default=db.func.now())
description = db.Column(db.Text())
class UserDictLock(db.Model):
__tablename__ = dbtableprefix + "userdictlock"
indexno = db.Column(db.Integer(), primary_key=True)
filename = db.Column(db.Text())
key = db.Column(db.String(250))
locktime = db.Column(db.DateTime(), server_default=db.func.now())
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 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 User(UserMixin, db.Model):
__tablename__ = dbtableprefix + 'user'
id = db.Column(db.Integer, primary_key=True)
social_id = db.Column(db.String(64), nullable=False, unique=True)
nickname = db.Column(db.String(64), nullable=False)
email = db.Column(db.String(64), nullable=True, unique=True)
confirmed_at = db.Column(db.DateTime())
active = db.Column('active',
db.Boolean(),
nullable=False,
server_default='0')
first_name = db.Column(db.String(50), nullable=False, server_default='')
last_name = db.Column(db.String(50), nullable=False, server_default='')
country = db.Column(db.String(2))
subdivisionfirst = db.Column(db.String(2))
subdivisionsecond = db.Column(db.String(50))
subdivisionthird = db.Column(db.String(50))
organization = db.Column(db.String(64))
user_auth = db.relationship('UserAuth',
uselist=False,
primaryjoin="UserAuth.user_id==User.id")
roles = db.relationship('Role',
secondary='user_roles',
backref=db.backref('user', lazy='dynamic'))
class Role(db.Model):
__tablename__ = dbtableprefix + 'role'
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(50), unique=True)
description = db.Column(db.String(255))
class Supervisors(db.Model):
__tablename__ = dbtableprefix + "supervisors"
id = db.Column(db.Integer(), primary_key=True)
hostname = db.Column(db.Text())
url = db.Column(db.Text())
start_time = db.Column(db.DateTime(), server_default=db.func.now())
class KVStore(db.Model):
__tablename__ = dbtableprefix + "kvstore"
key = db.Column(db.String(250), primary_key=True)
value = db.Column(db.LargeBinary(), nullable=False)
class Ticket(db.Model):
__tablename__ = dbtableprefix + 'ticket'
id = db.Column(db.Integer(), primary_key=True)
filename = db.Column(db.String(255))
request_type = db.Column(db.String(50), nullable=False)
description = db.Column(db.Text())
opened_by = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
open_time = db.Column(db.DateTime(), server_default=db.func.now())
close_time = db.Column(db.DateTime())
closed_by = db.Column(
db.Integer(),
db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
close_type = db.Column(db.String(50))
close_description = db.Column(db.Text())
status = db.Column(db.String(50))
