class TruenasCustomerInformationModel(sa.Model):
__tablename__ = 'truenas_customerinformation'
id = sa.Column(sa.Integer(), primary_key=True)
data = sa.Column(sa.Text())
updated_at = sa.Column(sa.DateTime())
sent_at = sa.Column(sa.DateTime(), nullable=True)
form_dismissed = sa.Column(sa.Boolean())
class AlertModel(sa.Model):
__tablename__ = 'system_alert'
id = sa.Column(sa.Integer(), primary_key=True)
node = sa.Column(sa.String(100))
source = sa.Column(sa.Text())
key = sa.Column(sa.Text())
datetime = sa.Column(sa.DateTime())
last_occurrence = sa.Column(sa.DateTime())
text = sa.Column(sa.Text())
args = sa.Column(sa.JSON(type=None))
dismissed = sa.Column(sa.Boolean())
uuid = sa.Column(sa.Text())
klass = sa.Column(sa.Text())
class DiskModel(sa.Model):
__tablename__ = 'storage_disk'
disk_identifier = sa.Column(sa.String(42), primary_key=True)
disk_name = sa.Column(sa.String(120))
disk_subsystem = sa.Column(sa.String(10), default='')
disk_number = sa.Column(sa.Integer(), default=1)
disk_serial = sa.Column(sa.String(30))
disk_size = sa.Column(sa.String(20))
disk_multipath_name = sa.Column(sa.String(30))
disk_multipath_member = sa.Column(sa.String(30))
disk_description = sa.Column(sa.String(120))
disk_transfermode = sa.Column(sa.String(120), default="Auto")
disk_hddstandby = sa.Column(sa.String(120), default="Always On")
disk_hddstandby_force = sa.Column(sa.Boolean(), default=False)
disk_advpowermgmt = sa.Column(sa.String(120), default="Disabled")
disk_acousticlevel = sa.Column(sa.String(120), default="Disabled")
disk_togglesmart = sa.Column(sa.Boolean(), default=True)
disk_smartoptions = sa.Column(sa.String(120))
disk_expiretime = sa.Column(sa.DateTime(), nullable=True)
disk_enclosure_slot = sa.Column(sa.Integer(), nullable=True)
disk_passwd = sa.Column(sa.EncryptedText(), default='')
disk_critical = sa.Column(sa.Integer(), nullable=True, default=None)
disk_difference = sa.Column(sa.Integer(), nullable=True, default=None)
disk_informational = sa.Column(sa.Integer(), nullable=True, default=None)
disk_model = sa.Column(sa.String(200), nullable=True, default=None)
disk_rotationrate = sa.Column(sa.Integer(), nullable=True, default=None)
disk_type = sa.Column(sa.String(20), default='UNKNOWN')
disk_kmip_uid = sa.Column(sa.String(255), nullable=True, default=None)
class APIKeyModel(sa.Model):
__tablename__ = "account_api_key"
id = sa.Column(sa.Integer(), primary_key=True)
name = sa.Column(sa.String(200))
key = sa.Column(sa.Text())
created_at = sa.Column(sa.DateTime())
class AlertModel(sa.Model):
__tablename__ = 'system_alert'
__table_args__ = (
sa.Index('system_alert_node_f77e0d77_uniq', 'node', 'klass', 'key', unique=True),
)
id = sa.Column(sa.Integer(), primary_key=True)
node = sa.Column(sa.String(100))
source = sa.Column(sa.Text())
key = sa.Column(sa.Text())
datetime = sa.Column(sa.DateTime())
last_occurrence = sa.Column(sa.DateTime())
text = sa.Column(sa.Text())
args = sa.Column(sa.JSON())
dismissed = sa.Column(sa.Boolean())
uuid = sa.Column(sa.Text())
klass = sa.Column(sa.Text())
class CertificateAuthorityModel(sa.Model):
__tablename__ = 'system_certificateauthority'
id = sa.Column(sa.Integer(), primary_key=True)
cert_type = sa.Column(sa.Integer())
cert_name = sa.Column(sa.String(120), unique=True)
cert_certificate = sa.Column(sa.Text(), nullable=True)
cert_privatekey = sa.Column(sa.EncryptedText(), nullable=True)
cert_CSR = sa.Column(sa.Text(), nullable=True)
cert_revoked_date = sa.Column(sa.DateTime(), nullable=True)
cert_signedby_id = sa.Column(sa.ForeignKey('system_certificateauthority.id'), index=True, nullable=True)
cert_add_to_trusted_store = sa.Column(sa.Boolean(), default=False, nullable=False)
class CertificateModel(sa.Model):
__tablename__ = 'system_certificate'
id = sa.Column(sa.Integer(), primary_key=True)
cert_type = sa.Column(sa.Integer())
cert_name = sa.Column(sa.String(120), unique=True)
cert_certificate = sa.Column(sa.Text(), nullable=True)
cert_privatekey = sa.Column(sa.EncryptedText(), nullable=True)
cert_CSR = sa.Column(sa.Text(), nullable=True)
cert_signedby_id = sa.Column(
sa.ForeignKey('system_certificateauthority.id'),
index=True,
nullable=True)
cert_acme_uri = sa.Column(sa.String(200), nullable=True)
cert_domains_authenticators = sa.Column(sa.JSON(encrypted=True),
nullable=True)
cert_renew_days = sa.Column(sa.Integer(), nullable=True, default=10)
cert_acme_id = sa.Column(sa.ForeignKey('system_acmeregistration.id'),
index=True,
nullable=True)
cert_revoked_date = sa.Column(sa.DateTime(), nullable=True)
class SystemGeneralModel(sa.Model):
__tablename__ = 'system_settings'
id = sa.Column(sa.Integer(), primary_key=True)
stg_guiaddress = sa.Column(sa.JSON(type=list), default=['0.0.0.0'])
stg_guiv6address = sa.Column(sa.JSON(type=list), default=['::'])
stg_guiallowlist = sa.Column(sa.JSON(type=list), default=[])
stg_guiport = sa.Column(sa.Integer(), default=80)
stg_guihttpsport = sa.Column(sa.Integer(), default=443)
stg_guihttpsredirect = sa.Column(sa.Boolean(), default=False)
stg_guihttpsprotocols = sa.Column(sa.JSON(type=list), default=['TLSv1', 'TLSv1.1', 'TLSv1.2', 'TLSv1.3'])
stg_guix_frame_options = sa.Column(sa.String(120), default='SAMEORIGIN')
stg_guiconsolemsg = sa.Column(sa.Boolean(), default=True)
stg_language = sa.Column(sa.String(120), default='en')
stg_kbdmap = sa.Column(sa.String(120), default='us')
stg_birthday = sa.Column(sa.DateTime(), nullable=True)
stg_timezone = sa.Column(sa.String(120), default='America/Los_Angeles')
stg_wizardshown = sa.Column(sa.Boolean(), default=False)
stg_pwenc_check = sa.Column(sa.String(100))
stg_guicertificate_id = sa.Column(sa.ForeignKey('system_certificate.id'), index=True, nullable=True)
stg_crash_reporting = sa.Column(sa.Boolean(), nullable=True)
stg_usage_collection = sa.Column(sa.Boolean(), nullable=True)
