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 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 RsyncTaskModel(sa.Model): __tablename__ = 'tasks_rsync' id = sa.Column(sa.Integer(), primary_key=True) rsync_path = sa.Column(sa.String(255)) rsync_remotehost = sa.Column(sa.String(120)) rsync_remotemodule = sa.Column(sa.String(120)) rsync_desc = sa.Column(sa.String(120)) rsync_minute = sa.Column(sa.String(100), default="00") rsync_hour = sa.Column(sa.String(100), default="*") rsync_daymonth = sa.Column(sa.String(100), default="*") rsync_month = sa.Column(sa.String(100), default='*') rsync_dayweek = sa.Column(sa.String(100), default="*") rsync_user = sa.Column(sa.String(60)) rsync_recursive = sa.Column(sa.Boolean(), default=True) rsync_times = sa.Column(sa.Boolean(), default=True) rsync_compress = sa.Column(sa.Boolean(), default=True) rsync_archive = sa.Column(sa.Boolean(), default=False) rsync_delete = sa.Column(sa.Boolean(), default=False) rsync_quiet = sa.Column(sa.Boolean(), default=False) rsync_preserveperm = sa.Column(sa.Boolean(), default=False) rsync_preserveattr = sa.Column(sa.Boolean(), default=False) rsync_extra = sa.Column(sa.Text()) rsync_enabled = sa.Column(sa.Boolean(), default=True) rsync_mode = sa.Column(sa.String(20), default='module') rsync_remotepath = sa.Column(sa.String(255)) rsync_direction = sa.Column(sa.String(10), default='PUSH') rsync_remoteport = sa.Column(sa.SmallInteger(), default=22) rsync_delayupdates = sa.Column(sa.Boolean(), default=True)
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 NetworkConfigurationModel(sa.Model): __tablename__ = 'network_globalconfiguration' id = sa.Column(sa.Integer(), primary_key=True) gc_hostname = sa.Column(sa.String(120), default='nas') gc_hostname_b = sa.Column(sa.String(120), nullable=True) gc_domain = sa.Column(sa.String(120), default='local') gc_ipv4gateway = sa.Column(sa.String(42), default='') gc_ipv6gateway = sa.Column(sa.String(45), default='') gc_nameserver1 = sa.Column(sa.String(45), default='') gc_nameserver2 = sa.Column(sa.String(45), default='') gc_nameserver3 = sa.Column(sa.String(45), default='') gc_httpproxy = sa.Column(sa.String(255)) gc_netwait_enabled = sa.Column(sa.Boolean(), default=False) gc_netwait_ip = sa.Column(sa.String(300)) gc_hosts = sa.Column(sa.Text(), default='') gc_domains = sa.Column(sa.Text(), default='') gc_service_announcement = sa.Column(sa.JSON(type=dict), default={ 'mdns': True, 'wsdd': True, "netbios": False }) gc_hostname_virtual = sa.Column(sa.String(120), nullable=True) gc_activity = sa.Column(sa.JSON(type=dict))
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 SharingSMBModel(sa.Model): __tablename__ = 'sharing_cifs_share' id = sa.Column(sa.Integer(), primary_key=True) cifs_purpose = sa.Column(sa.String(120)) cifs_path = sa.Column(sa.String(255), nullable=True) cifs_path_suffix = sa.Column(sa.String(255), nullable=False) cifs_home = sa.Column(sa.Boolean(), default=False) cifs_name = sa.Column(sa.String(120)) cifs_comment = sa.Column(sa.String(120)) cifs_ro = sa.Column(sa.Boolean(), default=False) cifs_browsable = sa.Column(sa.Boolean(), default=True) cifs_recyclebin = sa.Column(sa.Boolean(), default=False) cifs_guestok = sa.Column(sa.Boolean(), default=False) cifs_hostsallow = sa.Column(sa.Text()) cifs_hostsdeny = sa.Column(sa.Text()) cifs_auxsmbconf = sa.Column(sa.Text()) cifs_aapl_name_mangling = sa.Column(sa.Boolean()) cifs_abe = sa.Column(sa.Boolean()) cifs_acl = sa.Column(sa.Boolean()) cifs_durablehandle = sa.Column(sa.Boolean()) cifs_streams = sa.Column(sa.Boolean()) cifs_timemachine = sa.Column(sa.Boolean(), default=False) cifs_vuid = sa.Column(sa.String(36)) cifs_shadowcopy = sa.Column(sa.Boolean()) cifs_fsrvp = sa.Column(sa.Boolean()) cifs_enabled = sa.Column(sa.Boolean(), default=True) cifs_share_acl = sa.Column(sa.Text())
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 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 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 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 SNMPModel(sa.Model): __tablename__ = 'services_snmp' id = sa.Column(sa.Integer(), primary_key=True) snmp_location = sa.Column(sa.String(255)) snmp_contact = sa.Column(sa.String(120)) snmp_traps = sa.Column(sa.Boolean(), default=False) snmp_v3 = sa.Column(sa.Boolean(), default=False) snmp_community = sa.Column(sa.String(120), default='public') snmp_v3_username = sa.Column(sa.String(20)) snmp_v3_authtype = sa.Column(sa.String(3), default='SHA') snmp_v3_password = sa.Column(sa.EncryptedText()) snmp_v3_privproto = sa.Column(sa.String(3), nullable=True) snmp_v3_privpassphrase = sa.Column(sa.EncryptedText(), nullable=True) snmp_options = sa.Column(sa.Text()) snmp_loglevel = sa.Column(sa.Integer(), default=3) snmp_zilstat = sa.Column(sa.Boolean(), default=False)
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 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 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 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 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 VMModel(sa.Model): __tablename__ = 'vm_vm' id = sa.Column(sa.Integer(), primary_key=True) name = sa.Column(sa.String(150)) description = sa.Column(sa.String(250)) vcpus = sa.Column(sa.Integer(), default=1) memory = sa.Column(sa.Integer()) min_memory = sa.Column(sa.Integer(), nullable=True) autostart = sa.Column(sa.Boolean(), default=False) time = sa.Column(sa.String(5), default='LOCAL') bootloader = sa.Column(sa.String(50), default='UEFI') cores = sa.Column(sa.Integer(), default=1) threads = sa.Column(sa.Integer(), default=1) hyperv_enlightenments = sa.Column(sa.Boolean(), default=False) shutdown_timeout = sa.Column(sa.Integer(), default=90) cpu_mode = sa.Column(sa.Text()) cpu_model = sa.Column(sa.Text(), nullable=True) cpuset = sa.Column(sa.Text(), default=None, nullable=True) nodeset = sa.Column(sa.Text(), default=None, nullable=True) pin_vcpus = sa.Column(sa.Boolean(), default=False) hide_from_msr = sa.Column(sa.Boolean(), default=False) ensure_display_device = sa.Column(sa.Boolean(), default=True) arch_type = sa.Column(sa.String(255), default=None, nullable=True) machine_type = sa.Column(sa.String(255), default=None, nullable=True) uuid = sa.Column(sa.String(255))
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 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 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 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 NFSModel(sa.Model): __tablename__ = 'services_nfs' id = sa.Column(sa.Integer(), primary_key=True) nfs_srv_servers = sa.Column(sa.Integer(), default=4) nfs_srv_udp = sa.Column(sa.Boolean(), default=False) nfs_srv_allow_nonroot = sa.Column(sa.Boolean(), default=False) nfs_srv_v4 = sa.Column(sa.Boolean(), default=False) nfs_srv_v4_v3owner = sa.Column(sa.Boolean(), default=False) nfs_srv_v4_krb = sa.Column(sa.Boolean(), default=False) nfs_srv_bindip = sa.Column(sa.MultiSelectField()) nfs_srv_mountd_port = sa.Column(sa.SmallInteger(), nullable=True) nfs_srv_rpcstatd_port = sa.Column(sa.SmallInteger(), nullable=True) nfs_srv_rpclockd_port = sa.Column(sa.SmallInteger(), nullable=True) nfs_srv_16 = sa.Column(sa.Boolean(), default=False) nfs_srv_mountd_log = sa.Column(sa.Boolean(), default=True) nfs_srv_statd_lockd_log = sa.Column(sa.Boolean(), default=False) nfs_srv_v4_domain = sa.Column(sa.String(120))
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 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 PeriodicSnapshotTaskModel(sa.Model): __tablename__ = 'storage_task' id = sa.Column(sa.Integer(), primary_key=True) task_dataset = sa.Column(sa.String(150)) task_recursive = sa.Column(sa.Boolean(), default=False) task_lifetime_value = sa.Column(sa.Integer(), default=2) task_lifetime_unit = sa.Column(sa.String(120), default='WEEK') task_begin = sa.Column(sa.Time(), default=time(hour=9)) task_end = sa.Column(sa.Time(), default=time(hour=18)) task_enabled = sa.Column(sa.Boolean(), default=True) task_exclude = sa.Column(sa.JSON(type=list)) task_naming_schema = sa.Column(sa.String(150), default='auto-%Y-%m-%d_%H-%M') task_minute = sa.Column(sa.String(100), default="00") task_hour = sa.Column(sa.String(100), default="*") task_daymonth = sa.Column(sa.String(100), default="*") task_month = sa.Column(sa.String(100), default='*') task_dayweek = sa.Column(sa.String(100), default="*") task_allow_empty = sa.Column(sa.Boolean(), default=True)
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 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 ACMERegistrationModel(sa.Model): __tablename__ = 'system_acmeregistration' id = sa.Column(sa.Integer(), primary_key=True) uri = sa.Column(sa.String(200)) directory = sa.Column(sa.String(200)) tos = sa.Column(sa.String(200)) new_account_uri = sa.Column(sa.String(200)) new_nonce_uri = sa.Column(sa.String(200)) new_order_uri = sa.Column(sa.String(200)) revoke_cert_uri = sa.Column(sa.String(200))