class LDAPModel(sa.Model):
__tablename__ = 'directoryservice_ldap'
id = sa.Column(sa.Integer(), primary_key=True)
ldap_hostname = sa.Column(sa.String(120))
ldap_basedn = sa.Column(sa.String(120))
ldap_binddn = sa.Column(sa.EncryptedText())
ldap_bindpw = sa.Column(sa.String(120))
ldap_anonbind = sa.Column(sa.Boolean())
ldap_ssl = sa.Column(sa.String(120))
ldap_timeout = sa.Column(sa.Integer())
ldap_dns_timeout = sa.Column(sa.Integer())
ldap_has_samba_schema = sa.Column(sa.Boolean())
ldap_auxiliary_parameters = sa.Column(sa.Text())
ldap_schema = sa.Column(sa.String(120))
ldap_enable = sa.Column(sa.Boolean())
ldap_certificate_id = sa.Column(sa.ForeignKey('system_certificate.id'),
index=True,
nullable=True)
ldap_kerberos_realm_id = sa.Column(
sa.ForeignKey('directoryservice_kerberosrealm.id'),
index=True,
nullable=True)
ldap_kerberos_principal = sa.Column(sa.String(255))
ldap_validate_certificates = sa.Column(sa.Boolean(), default=True)
ldap_disable_freenas_cache = sa.Column(sa.Boolean())
class GroupMembershipModel(sa.Model):
__tablename__ = 'account_bsdgroupmembership'
id = sa.Column(sa.Integer(), primary_key=True)
bsdgrpmember_group_id = sa.Column(
sa.Integer(), sa.ForeignKey("account_bsdgroups.id",
ondelete="CASCADE"))
bsdgrpmember_user_id = sa.Column(
sa.Integer(), sa.ForeignKey("account_bsdusers.id", ondelete="CASCADE"))
class SmartTestDiskModel(sa.Model):
__tablename__ = 'tasks_smarttest_smarttest_disks'
__table_args__ = (
sa.Index('tasks_smarttest_smarttest_disks_smarttest_id__disk_id', 'smarttest_id', 'disk_id', unique=True),
)
id = sa.Column(sa.Integer(), primary_key=True)
smarttest_id = sa.Column(sa.Integer(), sa.ForeignKey('tasks_smarttest.id', ondelete='CASCADE'))
disk_id = sa.Column(sa.String(100), sa.ForeignKey('storage_disk.disk_identifier', ondelete='CASCADE'))
class ReplicationPeriodicSnapshotTaskModel(sa.Model):
__tablename__ = 'storage_replication_repl_periodic_snapshot_tasks'
id = sa.Column(sa.Integer(), primary_key=True)
replication_id = sa.Column(sa.ForeignKey('storage_replication.id',
ondelete='CASCADE'),
index=True)
task_id = sa.Column(sa.ForeignKey('storage_task.id', ondelete='CASCADE'),
index=True)
class iSCSIHostTargetModel(sa.Model):
__tablename__ = "services_iscsihosttarget"
id = sa.Column(sa.Integer(), primary_key=True)
host_id = sa.Column(
sa.Integer(), sa.ForeignKey("services_iscsihost.id",
ondelete="CASCADE"))
target_id = sa.Column(
sa.Integer(),
sa.ForeignKey("services_iscsitarget.id", ondelete="CASCADE"))
class KMIPModel(sa.Model):
__tablename__ = 'system_kmip'
id = sa.Column(sa.Integer(), primary_key=True)
server = sa.Column(sa.String(128), default=None, nullable=True)
port = sa.Column(sa.SmallInteger(), default=5696)
certificate_id = sa.Column(sa.ForeignKey('system_certificate.id'), index=True, nullable=True)
certificate_authority_id = sa.Column(sa.ForeignKey('system_certificateauthority.id'), index=True, nullable=True)
manage_sed_disks = sa.Column(sa.Boolean(), default=False)
manage_zfs_keys = sa.Column(sa.Boolean(), default=False)
enabled = sa.Column(sa.Boolean(), default=False)
class OpenVPNClientModel(sa.Model):
__tablename__ = 'services_openvpnclient'
id = sa.Column(sa.Integer(), primary_key=True)
port = sa.Column(sa.Integer(), default=1194)
protocol = sa.Column(sa.String(4), default='UDP')
device_type = sa.Column(sa.String(4), default='TUN')
nobind = sa.Column(sa.Boolean(), default=True)
authentication_algorithm = sa.Column(sa.String(32), nullable=True)
tls_crypt_auth = sa.Column(sa.Text(), nullable=True)
cipher = sa.Column(sa.String(32), nullable=True)
compression = sa.Column(sa.String(32), nullable=True)
additional_parameters = sa.Column(sa.Text())
client_certificate_id = sa.Column(sa.ForeignKey('system_certificate.id'), index=True, nullable=True)
root_ca_id = sa.Column(sa.ForeignKey('system_certificateauthority.id'), index=True, nullable=True)
remote = sa.Column(sa.String(120))
class ReplicationModel(sa.Model):
__tablename__ = 'storage_replication'
id = sa.Column(sa.Integer(), primary_key=True)
repl_target_dataset = sa.Column(sa.String(120))
repl_recursive = sa.Column(sa.Boolean(), default=False)
repl_compression = sa.Column(sa.String(120), nullable=True, default="LZ4")
repl_speed_limit = sa.Column(sa.Integer(), nullable=True, default=None)
repl_schedule_begin = sa.Column(sa.Time(), nullable=True, default=time(hour=0))
repl_schedule_end = sa.Column(sa.Time(), nullable=True, default=time(hour=23, minute=45))
repl_enabled = sa.Column(sa.Boolean(), default=True)
repl_direction = sa.Column(sa.String(120), default="PUSH")
repl_transport = sa.Column(sa.String(120), default="SSH")
repl_ssh_credentials_id = sa.Column(sa.ForeignKey('system_keychaincredential.id'), index=True, nullable=True)
repl_netcat_active_side = sa.Column(sa.String(120), nullable=True, default=None)
repl_netcat_active_side_port_min = sa.Column(sa.Integer(), nullable=True)
repl_netcat_active_side_port_max = sa.Column(sa.Integer(), nullable=True)
repl_source_datasets = sa.Column(sa.JSON(type=list))
repl_exclude = sa.Column(sa.JSON(type=list))
repl_naming_schema = sa.Column(sa.JSON(type=list))
repl_auto = sa.Column(sa.Boolean(), default=True)
repl_schedule_minute = sa.Column(sa.String(100), nullable=True, default="00")
repl_schedule_hour = sa.Column(sa.String(100), nullable=True, default="*")
repl_schedule_daymonth = sa.Column(sa.String(100), nullable=True, default="*")
repl_schedule_month = sa.Column(sa.String(100), nullable=True, default='*')
repl_schedule_dayweek = sa.Column(sa.String(100), nullable=True, default="*")
repl_only_matching_schedule = sa.Column(sa.Boolean())
repl_readonly = sa.Column(sa.String(120))
repl_allow_from_scratch = sa.Column(sa.Boolean())
repl_hold_pending_snapshots = sa.Column(sa.Boolean())
repl_retention_policy = sa.Column(sa.String(120), default="NONE")
repl_lifetime_unit = sa.Column(sa.String(120), nullable=True, default='WEEK')
repl_lifetime_value = sa.Column(sa.Integer(), nullable=True, default=2)
repl_large_block = sa.Column(sa.Boolean(), default=True)
repl_embed = sa.Column(sa.Boolean(), default=False)
repl_compressed = sa.Column(sa.Boolean(), default=True)
repl_retries = sa.Column(sa.Integer(), default=5)
repl_restrict_schedule_minute = sa.Column(sa.String(100), nullable=True, default="00")
repl_restrict_schedule_hour = sa.Column(sa.String(100), nullable=True, default="*")
repl_restrict_schedule_daymonth = sa.Column(sa.String(100), nullable=True, default="*")
repl_restrict_schedule_month = sa.Column(sa.String(100), nullable=True, default='*')
repl_restrict_schedule_dayweek = sa.Column(sa.String(100), nullable=True, default="*")
repl_restrict_schedule_begin = sa.Column(sa.Time(), nullable=True, default=time(hour=0))
repl_restrict_schedule_end = sa.Column(sa.Time(), nullable=True, default=time(hour=23, minute=45))
repl_netcat_active_side_listen_address = sa.Column(sa.String(120), nullable=True, default=None)
repl_netcat_passive_side_connect_address = sa.Column(sa.String(120), nullable=True, default=None)
repl_logging_level = sa.Column(sa.String(120), nullable=True, default=None)
repl_name = sa.Column(sa.String(120))
repl_state = sa.Column(sa.Text(), default="{}")
repl_properties = sa.Column(sa.Boolean(), default=True)
repl_properties_exclude = sa.Column(sa.JSON(type=list))
repl_properties_override = sa.Column(sa.JSON())
repl_replicate = sa.Column(sa.Boolean())
repl_encryption = sa.Column(sa.Boolean())
repl_encryption_key = sa.Column(sa.EncryptedText(), nullable=True)
repl_encryption_key_format = sa.Column(sa.String(120), nullable=True)
repl_encryption_key_location = sa.Column(sa.Text(), nullable=True)
repl_periodic_snapshot_tasks = sa.relationship('PeriodicSnapshotTaskModel',
secondary=lambda: ReplicationPeriodicSnapshotTaskModel.__table__)
class CloudSyncModel(sa.Model):
__tablename__ = 'tasks_cloudsync'
id = sa.Column(sa.Integer(), primary_key=True)
description = sa.Column(sa.String(150))
direction = sa.Column(sa.String(10), default='PUSH')
path = sa.Column(sa.String(255))
attributes = sa.Column(sa.JSON())
minute = sa.Column(sa.String(100), default="00")
hour = sa.Column(sa.String(100), default="*")
daymonth = sa.Column(sa.String(100), default="*")
month = sa.Column(sa.String(100), default='*')
dayweek = sa.Column(sa.String(100), default="*")
enabled = sa.Column(sa.Boolean(), default=True)
credential_id = sa.Column(sa.ForeignKey('system_cloudcredentials.id'),
index=True)
transfer_mode = sa.Column(sa.String(20), default='sync')
encryption = sa.Column(sa.Boolean())
filename_encryption = sa.Column(sa.Boolean(), default=True)
encryption_password = sa.Column(sa.EncryptedText())
encryption_salt = sa.Column(sa.EncryptedText())
args = sa.Column(sa.Text())
post_script = sa.Column(sa.Text())
pre_script = sa.Column(sa.Text())
snapshot = sa.Column(sa.Boolean())
bwlimit = sa.Column(sa.JSON(type=list))
exclude = sa.Column(sa.JSON(type=list))
transfers = sa.Column(sa.Integer(), nullable=True)
follow_symlinks = sa.Column(sa.Boolean())
class FCPortModel(sa.Model):
__tablename__ = 'services_fibrechanneltotarget'
id = sa.Column(sa.Integer(), primary_key=True)
fc_port = sa.Column(sa.String(10))
fc_target_id = sa.Column(sa.ForeignKey('services_iscsitarget.id'),
nullable=True,
index=True)
class ACMERegistrationBodyModel(sa.Model):
__tablename__ = 'system_acmeregistrationbody'
id = sa.Column(sa.Integer(), primary_key=True)
contact = sa.Column(sa.String(254))
status = sa.Column(sa.String(10))
key = sa.Column(sa.Text())
acme_id = sa.Column(sa.ForeignKey('system_acmeregistration.id'), index=True)
class VMDeviceModel(sa.Model):
__tablename__ = 'vm_device'
id = sa.Column(sa.Integer(), primary_key=True)
dtype = sa.Column(sa.String(50))
attributes = sa.Column(sa.JSON())
vm_id = sa.Column(sa.ForeignKey('vm_vm.id'), index=True)
order = sa.Column(sa.Integer(), nullable=True)
class iSCSIHostIqnModel(sa.Model):
__tablename__ = "services_iscsihostiqn"
id = sa.Column(sa.Integer(), primary_key=True)
iqn = sa.Column(sa.String(223), unique=True)
host_id = sa.Column(
sa.Integer(), sa.ForeignKey("services_iscsihost.id",
ondelete="CASCADE"))
class OpenVPNServerModel(sa.Model):
__tablename__ = 'services_openvpnserver'
id = sa.Column(sa.Integer(), primary_key=True)
port = sa.Column(sa.Integer(), default=1194)
protocol = sa.Column(sa.String(4), default='UDP')
device_type = sa.Column(sa.String(4), default='TUN')
authentication_algorithm = sa.Column(sa.String(32), nullable=True)
tls_crypt_auth = sa.Column(sa.Text(), nullable=True)
cipher = sa.Column(sa.String(32), nullable=True)
compression = sa.Column(sa.String(32), nullable=True)
additional_parameters = sa.Column(sa.Text())
server_certificate_id = sa.Column(sa.ForeignKey('system_certificate.id'), index=True, nullable=True)
root_ca_id = sa.Column(sa.ForeignKey('system_certificateauthority.id'), index=True, nullable=True)
server = sa.Column(sa.String(45))
topology = sa.Column(sa.String(16), nullable=True)
netmask = sa.Column(sa.Integer(), default=24)
class WebDAVModel(sa.Model):
__tablename__ = 'services_webdav'
id = sa.Column(sa.Integer(), primary_key=True)
webdav_protocol = sa.Column(sa.String(120), default="http")
webdav_tcpport = sa.Column(sa.Integer(), default=8080)
webdav_tcpportssl = sa.Column(sa.Integer(), default=8081)
webdav_password = sa.Column(sa.String(120), default="davtest")
webdav_htauth = sa.Column(sa.String(120), default='digest')
webdav_certssl_id = sa.Column(sa.ForeignKey('system_certificate.id'), nullable=True)
class IdmapDomainModel(sa.Model):
__tablename__ = 'directoryservice_idmap_domain'
id = sa.Column(sa.Integer(), primary_key=True)
idmap_domain_name = sa.Column(sa.String(120), unique=True)
idmap_domain_dns_domain_name = sa.Column(sa.String(255), nullable=True, unique=True)
idmap_domain_range_low = sa.Column(sa.Integer())
idmap_domain_range_high = sa.Column(sa.Integer())
idmap_domain_idmap_backend = sa.Column(sa.String(120), default='rid')
idmap_domain_options = sa.Column(sa.JSON(type=dict))
idmap_domain_certificate_id = sa.Column(sa.ForeignKey('system_certificate.id'), index=True, nullable=True)
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 S3Model(sa.Model):
__tablename__ = 'services_s3'
id = sa.Column(sa.Integer(), primary_key=True)
s3_bindip = sa.Column(sa.String(128))
s3_bindport = sa.Column(sa.SmallInteger(), default=9000)
s3_access_key = sa.Column(sa.String(128), default='')
s3_secret_key = sa.Column(sa.EncryptedText(), default='')
s3_mode = sa.Column(sa.String(120), default="local")
s3_disks = sa.Column(sa.String(255), default='')
s3_certificate_id = sa.Column(sa.ForeignKey('system_certificate.id'), index=True, nullable=True)
s3_browser = sa.Column(sa.Boolean(), default=True)
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 SystemAdvancedModel(sa.Model):
__tablename__ = 'system_advanced'
id = sa.Column(sa.Integer(), primary_key=True)
adv_consolemenu = sa.Column(sa.Boolean(), default=False)
adv_serialconsole = sa.Column(sa.Boolean(), default=False)
adv_serialport = sa.Column(sa.String(120), default='ttyS0')
adv_serialspeed = sa.Column(sa.String(120), default='9600')
adv_powerdaemon = sa.Column(sa.Boolean(), default=False)
adv_swapondrive = sa.Column(sa.Integer(), default=2)
adv_overprovision = sa.Column(sa.Integer(), nullable=True, default=None)
adv_traceback = sa.Column(sa.Boolean(), default=True)
adv_advancedmode = sa.Column(sa.Boolean(), default=False)
adv_autotune = sa.Column(sa.Boolean(), default=False)
adv_debugkernel = sa.Column(sa.Boolean(), default=False)
adv_uploadcrash = sa.Column(sa.Boolean(), default=True)
adv_anonstats = sa.Column(sa.Boolean(), default=True)
adv_anonstats_token = sa.Column(sa.Text())
adv_motd = sa.Column(sa.Text(), default='Welcome')
adv_boot_scrub = sa.Column(sa.Integer(), default=7)
adv_fqdn_syslog = sa.Column(sa.Boolean(), default=False)
adv_sed_user = sa.Column(sa.String(120), default='user')
adv_sed_passwd = sa.Column(sa.EncryptedText(), default='')
adv_sysloglevel = sa.Column(sa.String(120), default='f_info')
adv_syslogserver = sa.Column(sa.String(120), default='')
adv_syslog_transport = sa.Column(sa.String(12), default='UDP')
adv_syslog_tls_certificate_id = sa.Column(
sa.ForeignKey('system_certificate.id'), index=True, nullable=True)
adv_syslog_tls_certificate_authority_id = sa.Column(
sa.ForeignKey('system_certificateauthority.id'),
index=True,
nullable=True)
adv_kmip_uid = sa.Column(sa.String(255), nullable=True, default=None)
adv_kdump_enabled = sa.Column(sa.Boolean(), default=False)
adv_isolated_gpu_pci_ids = sa.Column(sa.JSON(), default=[])
adv_kernel_extra_options = sa.Column(sa.Text(), default='', nullable=False)
class FTPModel(sa.Model):
__tablename__ = 'services_ftp'
id = sa.Column(sa.Integer(), primary_key=True)
ftp_port = sa.Column(sa.Integer(), default=21)
ftp_clients = sa.Column(sa.Integer(), default=32)
ftp_ipconnections = sa.Column(sa.Integer(), default=0)
ftp_loginattempt = sa.Column(sa.Integer(), default=3)
ftp_timeout = sa.Column(sa.Integer(), default=120)
ftp_timeout_notransfer = sa.Column(sa.Integer(), default=300)
ftp_rootlogin = sa.Column(sa.Boolean(), default=False)
ftp_onlyanonymous = sa.Column(sa.Boolean(), default=False)
ftp_anonpath = sa.Column(sa.String(255), nullable=True, default=False)
ftp_onlylocal = sa.Column(sa.Boolean(), default=False)
ftp_banner = sa.Column(sa.Text())
ftp_filemask = sa.Column(sa.String(3), default="077")
ftp_dirmask = sa.Column(sa.String(3), default="077")
ftp_fxp = sa.Column(sa.Boolean(), default=False)
ftp_resume = sa.Column(sa.Boolean(), default=False)
ftp_defaultroot = sa.Column(sa.Boolean(), default=False)
ftp_ident = sa.Column(sa.Boolean(), default=False)
ftp_reversedns = sa.Column(sa.Boolean(), default=False)
ftp_masqaddress = sa.Column(sa.String(120))
ftp_passiveportsmin = sa.Column(sa.Integer(), default=0)
ftp_passiveportsmax = sa.Column(sa.Integer(), default=0)
ftp_localuserbw = sa.Column(sa.Integer(), default=0)
ftp_localuserdlbw = sa.Column(sa.Integer(), default=0)
ftp_anonuserbw = sa.Column(sa.Integer(), default=0)
ftp_anonuserdlbw = sa.Column(sa.Integer(), default=0)
ftp_tls = sa.Column(sa.Boolean(), default=False)
ftp_tls_policy = sa.Column(sa.String(120), default="on")
ftp_tls_opt_allow_client_renegotiations = sa.Column(sa.Boolean(),
default=False)
ftp_tls_opt_allow_dot_login = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_allow_per_user = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_common_name_required = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_enable_diags = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_export_cert_data = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_no_cert_request = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_no_empty_fragments = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_no_session_reuse_required = sa.Column(sa.Boolean(),
default=False)
ftp_tls_opt_stdenvvars = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_dns_name_required = sa.Column(sa.Boolean(), default=False)
ftp_tls_opt_ip_address_required = sa.Column(sa.Boolean(), default=False)
ftp_ssltls_certificate_id = sa.Column(
sa.ForeignKey('system_certificate.id'), index=True, nullable=True)
ftp_options = sa.Column(sa.Text())
class UserModel(sa.Model):
__tablename__ = 'account_bsdusers'
id = sa.Column(sa.Integer(), primary_key=True)
bsdusr_uid = sa.Column(sa.Integer())
bsdusr_username = sa.Column(sa.String(16), default='User &')
bsdusr_unixhash = sa.Column(sa.String(128), default='*')
bsdusr_smbhash = sa.Column(sa.EncryptedText(), default='*')
bsdusr_home = sa.Column(sa.String(255), default="/nonexistent")
bsdusr_shell = sa.Column(sa.String(120), default='/bin/csh')
bsdusr_full_name = sa.Column(sa.String(120))
bsdusr_builtin = sa.Column(sa.Boolean(), default=False)
bsdusr_smb = sa.Column(sa.Boolean(), default=True)
bsdusr_password_disabled = sa.Column(sa.Boolean(), default=False)
bsdusr_locked = sa.Column(sa.Boolean(), default=False)
bsdusr_sudo = sa.Column(sa.Boolean(), default=False)
bsdusr_microsoft_account = sa.Column(sa.Boolean())
bsdusr_group_id = sa.Column(sa.ForeignKey('account_bsdgroups.id'), index=True)
bsdusr_attributes = sa.Column(sa.JSON())
bsdusr_email = sa.Column(sa.String(254), nullable=True)
class ActiveDirectoryModel(sa.Model):
__tablename__ = 'directoryservice_activedirectory'
id = sa.Column(sa.Integer(), primary_key=True)
ad_domainname = sa.Column(sa.String(120))
ad_bindname = sa.Column(sa.String(120))
ad_bindpw = sa.Column(sa.EncryptedText())
ad_verbose_logging = sa.Column(sa.Boolean())
ad_allow_trusted_doms = sa.Column(sa.Boolean())
ad_use_default_domain = sa.Column(sa.Boolean())
ad_allow_dns_updates = sa.Column(sa.Boolean())
ad_disable_freenas_cache = sa.Column(sa.Boolean())
ad_restrict_pam = sa.Column(sa.Boolean())
ad_site = sa.Column(sa.String(120), nullable=True)
ad_timeout = sa.Column(sa.Integer())
ad_dns_timeout = sa.Column(sa.Integer())
ad_nss_info = sa.Column(sa.String(120), nullable=True)
ad_enable = sa.Column(sa.Boolean())
ad_kerberos_realm_id = sa.Column(sa.ForeignKey('directoryservice_kerberosrealm.id', ondelete='SET NULL'),
index=True, nullable=True)
ad_kerberos_principal = sa.Column(sa.String(255))
ad_createcomputer = sa.Column(sa.String(255))
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)