class LLDPModel(sa.Model):
__tablename__ = 'services_lldp'
id = sa.Column(sa.Integer(), primary_key=True)
lldp_intdesc = sa.Column(sa.Boolean(), default=True)
lldp_country = sa.Column(sa.String(2))
lldp_location = sa.Column(sa.String(200))
class ACMEDNSAuthenticatorModel(sa.Model):
__tablename__ = 'system_acmednsauthenticator'
id = sa.Column(sa.Integer(), primary_key=True)
authenticator = sa.Column(sa.String(64))
name = sa.Column(sa.String(64))
attributes = sa.Column(sa.JSON(encrypted=True))
class SSHModel(sa.Model):
__tablename__ = 'services_ssh'
id = sa.Column(sa.Integer(), primary_key=True)
ssh_bindiface = sa.Column(sa.MultiSelectField(), default=[])
ssh_tcpport = sa.Column(sa.Integer(), default=22)
ssh_rootlogin = sa.Column(sa.Boolean(), default=False)
ssh_passwordauth = sa.Column(sa.Boolean(), default=False)
ssh_kerberosauth = sa.Column(sa.Boolean(), default=False)
ssh_tcpfwd = sa.Column(sa.Boolean(), default=False)
ssh_compression = sa.Column(sa.Boolean(), default=False)
ssh_privatekey = sa.Column(sa.Text())
ssh_sftp_log_level = sa.Column(sa.String(20))
ssh_sftp_log_facility = sa.Column(sa.String(20))
ssh_host_dsa_key = sa.Column(sa.Text(), nullable=True)
ssh_host_dsa_key_pub = sa.Column(sa.Text(), nullable=True)
ssh_host_dsa_key_cert_pub = sa.Column(sa.Text(), nullable=True)
ssh_host_ecdsa_key = sa.Column(sa.Text(), nullable=True)
ssh_host_ecdsa_key_pub = sa.Column(sa.Text(), nullable=True)
ssh_host_ecdsa_key_cert_pub = sa.Column(sa.Text(), nullable=True)
ssh_host_ed25519_key_pub = sa.Column(sa.Text(), nullable=True)
ssh_host_ed25519_key = sa.Column(sa.Text(), nullable=True)
ssh_host_ed25519_key_cert_pub = sa.Column(sa.Text(), nullable=True)
ssh_host_key = sa.Column(sa.Text(), nullable=True)
ssh_host_key_pub = sa.Column(sa.Text(), nullable=True)
ssh_host_rsa_key = sa.Column(sa.Text(), nullable=True)
ssh_host_rsa_key_pub = sa.Column(sa.Text(), nullable=True)
ssh_host_rsa_key_cert_pub = sa.Column(sa.Text(), nullable=True)
ssh_options = sa.Column(sa.Text())
class StaticRouteModel(sa.Model):
__tablename__ = 'network_staticroute'
id = sa.Column(sa.Integer(), primary_key=True)
sr_destination = sa.Column(sa.String(120))
sr_gateway = sa.Column(sa.String(42))
sr_description = sa.Column(sa.String(120))
class CatalogModel(sa.Model):
__tablename__ = 'services_catalog'
label = sa.Column(sa.String(255), nullable=False, unique=True, primary_key=True)
repository = sa.Column(sa.Text(), nullable=False)
branch = sa.Column(sa.String(255), nullable=False)
builtin = sa.Column(sa.Boolean(), nullable=False, default=False)
class KeychainCredentialModel(sa.Model):
__tablename__ = 'system_keychaincredential'
id = sa.Column(sa.Integer(), primary_key=True)
name = sa.Column(sa.String(255))
type = sa.Column(sa.String(255))
attributes = sa.Column(sa.JSON(encrypted=True))
class CloudCredentialModel(sa.Model):
__tablename__ = 'system_cloudcredentials'
id = sa.Column(sa.Integer(), primary_key=True)
name = sa.Column(sa.String(100))
provider = sa.Column(sa.String(50))
attributes = sa.Column(sa.JSON(encrypted=True))
class ACLTempateModel(sa.Model):
__tablename__ = 'filesystem_acltemplate'
id = sa.Column(sa.Integer(), primary_key=True)
acltemplate_name = sa.Column(sa.String(120), unique=True)
acltemplate_acltype = sa.Column(sa.String(255))
acltemplate_acl = sa.Column(sa.JSON(type=list))
acltemplate_builtin = sa.Column(sa.Boolean())
class SystemDatasetModel(sa.Model):
__tablename__ = 'system_systemdataset'
id = sa.Column(sa.Integer(), primary_key=True)
sys_pool = sa.Column(sa.String(1024))
sys_syslog_usedataset = sa.Column(sa.Boolean(), default=False)
sys_uuid = sa.Column(sa.String(32))
sys_uuid_b = sa.Column(sa.String(32), nullable=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 AlertServiceModel(sa.Model):
__tablename__ = 'system_alertservice'
id = sa.Column(sa.Integer(), primary_key=True)
name = sa.Column(sa.String(120))
type = sa.Column(sa.String(20))
attributes = sa.Column(sa.JSON())
enabled = sa.Column(sa.Boolean())
level = sa.Column(sa.String(20))
class NISModel(sa.Model):
__tablename__ = 'directoryservice_nis'
id = sa.Column(sa.Integer(), primary_key=True)
nis_domain = sa.Column(sa.String(120))
nis_servers = sa.Column(sa.String(8192))
nis_secure_mode = sa.Column(sa.Boolean())
nis_manycast = sa.Column(sa.Boolean())
nis_enable = sa.Column(sa.Boolean(), default=False)
class TunableModel(sa.Model):
__tablename__ = 'system_tunable'
id = sa.Column(sa.Integer(), primary_key=True)
tun_value = sa.Column(sa.String(512))
tun_type = sa.Column(sa.String(20), default='loader')
tun_comment = sa.Column(sa.String(100))
tun_enabled = sa.Column(sa.Boolean(), default=True)
tun_var = sa.Column(sa.String(128))
class VMWareModel(sa.Model):
__tablename__ = 'storage_vmwareplugin'
id = sa.Column(sa.Integer(), primary_key=True)
hostname = sa.Column(sa.String(200))
username = sa.Column(sa.String(200))
password = sa.Column(sa.EncryptedText())
filesystem = sa.Column(sa.String(200))
datastore = sa.Column(sa.String(200))
class WebDAVSharingModel(sa.Model):
__tablename__ = 'sharing_webdav_share'
id = sa.Column(sa.Integer(), primary_key=True)
webdav_name = sa.Column(sa.String(120))
webdav_comment = sa.Column(sa.String(120))
webdav_path = sa.Column(sa.String(255))
webdav_ro = sa.Column(sa.Boolean(), default=False)
webdav_perm = sa.Column(sa.Boolean(), default=True)
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 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 TFTPModel(sa.Model):
__tablename__ = 'services_tftp'
id = sa.Column(sa.Integer(), primary_key=True)
tftp_directory = sa.Column(sa.String(255))
tftp_newfiles = sa.Column(sa.Boolean(), default=False)
tftp_port = sa.Column(sa.Integer(), default=21)
tftp_username = sa.Column(sa.String(120), default="nobody")
tftp_umask = sa.Column(sa.String(120), default='022')
tftp_options = sa.Column(sa.String(120))
tftp_host = sa.Column(sa.String(120), default="0.0.0.0")
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 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 InitShutdownScriptModel(sa.Model):
__tablename__ = 'tasks_initshutdown'
id = sa.Column(sa.Integer(), primary_key=True)
ini_type = sa.Column(sa.String(15), default='command')
ini_command = sa.Column(sa.String(300))
ini_script = sa.Column(sa.String(255), nullable=True)
ini_when = sa.Column(sa.String(15))
ini_enabled = sa.Column(sa.Boolean(), default=True)
ini_timeout = sa.Column(sa.Integer(), default=10)
ini_comment = sa.Column(sa.String(255))
ini_script_text = sa.Column(sa.Text())
class AFPModel(sa.Model):
__tablename__ = 'services_afp'
id = sa.Column(sa.Integer(), primary_key=True)
afp_srv_guest = sa.Column(sa.Boolean(), default=False)
afp_srv_guest_user = sa.Column(sa.String(120), default="nobody")
afp_srv_bindip = sa.Column(sa.MultiSelectField(), default=[])
afp_srv_connections_limit = sa.Column(sa.Integer(), default=50)
afp_srv_dbpath = sa.Column(sa.String(255), nullable=True)
afp_srv_global_aux = sa.Column(sa.Text())
afp_srv_map_acls = sa.Column(sa.String(120))
afp_srv_chmod_request = sa.Column(sa.String(120))
class KerberosRealmModel(sa.Model):
__tablename__ = 'directoryservice_kerberosrealm'
id = sa.Column(sa.Integer(), primary_key=True)
krb_realm = sa.Column(sa.String(120))
krb_kdc = sa.Column(sa.String(120))
krb_admin_server = sa.Column(sa.String(120))
krb_kpasswd_server = sa.Column(sa.String(120))
__table_args__ = (sa.Index("directoryservice_kerberosrealm_krb_realm",
"krb_realm",
unique=True), )
class MailModel(sa.Model):
__tablename__ = 'system_email'
id = sa.Column(sa.Integer(), primary_key=True)
em_fromemail = sa.Column(sa.String(120), default='')
em_outgoingserver = sa.Column(sa.String(120))
em_port = sa.Column(sa.Integer(), default=25)
em_security = sa.Column(sa.String(120), default="plain")
em_smtp = sa.Column(sa.Boolean())
em_user = sa.Column(sa.String(120), nullable=True)
em_pass = sa.Column(sa.EncryptedText(), nullable=True)
em_fromname = sa.Column(sa.String(120), default='')
em_oauth = sa.Column(sa.JSON(type=dict, encrypted=True), nullable=True)
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.String(256))
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_idmap_backend = sa.Column(sa.String(120))
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 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 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 iSCSIHostModel(sa.Model):
__tablename__ = "services_iscsihost"
id = sa.Column(sa.Integer(), primary_key=True)
ip = sa.Column(sa.String(45), unique=True)
description = sa.Column(sa.Text())
added_automatically = sa.Column(sa.Boolean())
class ISCSIGlobalModel(sa.Model):
__tablename__ = 'services_iscsitargetglobalconfiguration'
id = sa.Column(sa.Integer(), primary_key=True)
iscsi_basename = sa.Column(sa.String(120))
iscsi_isns_servers = sa.Column(sa.Text())
iscsi_pool_avail_threshold = sa.Column(sa.Integer(), nullable=True)
iscsi_alua = sa.Column(sa.Boolean(), default=False)
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)
