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))
