FreeNAS Code
This project has moved to github - see https://github.com/freenas
Brought to you by:
cochard,
mattolander
CREATE TABLE "account_bsdgroupmembership" ( "id" integer NOT NULL PRIMARY KEY, "bsdgrpmember_group_id" integer NOT NULL, "bsdgrpmember_user_id" integer NOT NULL ); CREATE TABLE "account_bsdgroups" ( "bsdgrp_group" varchar(120), "bsdgrp_gid" integer, "id" integer PRIMARY KEY, "bsdgrp_builtin" bool NOT NULL DEFAULT False ); CREATE TABLE "account_bsdusers" ( "bsdusr_full_name" varchar(120), "bsdusr_username" varchar(30) UNIQUE, "bsdusr_group_id" integer, "bsdusr_uid" integer UNIQUE, "bsdusr_unixhash" varchar(128), "bsdusr_shell" varchar(120), "bsdusr_builtin" bool NOT NULL DEFAULT False, "bsdusr_home" varchar(120), "bsdusr_smbhash" varchar(128), "id" integer PRIMARY KEY ); CREATE TABLE "auth_group" ( "id" integer NOT NULL PRIMARY KEY, "name" varchar(80) NOT NULL UNIQUE ); CREATE TABLE "auth_group_permissions" ( "id" integer NOT NULL PRIMARY KEY, "group_id" integer NOT NULL, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"), UNIQUE ("group_id", "permission_id") ); CREATE TABLE "auth_message" ( "id" integer NOT NULL PRIMARY KEY, "user_id" integer NOT NULL REFERENCES "auth_user" ("id"), "message" text NOT NULL ); CREATE TABLE "auth_permission" ( "id" integer NOT NULL PRIMARY KEY, "name" varchar(50) NOT NULL, "content_type_id" integer NOT NULL, "codename" varchar(100) NOT NULL, UNIQUE ("content_type_id", "codename") ); CREATE TABLE "auth_user" ( "id" integer NOT NULL PRIMARY KEY, "username" varchar(30) NOT NULL UNIQUE, "first_name" varchar(30) NOT NULL, "last_name" varchar(30) NOT NULL, "email" varchar(75) NOT NULL, "password" varchar(128) NOT NULL, "is_staff" bool NOT NULL, "is_active" bool NOT NULL, "is_superuser" bool NOT NULL, "last_login" datetime NOT NULL, "date_joined" datetime NOT NULL ); CREATE TABLE "auth_user_groups" ( "id" integer NOT NULL PRIMARY KEY, "user_id" integer NOT NULL, "group_id" integer NOT NULL REFERENCES "auth_group" ("id"), UNIQUE ("user_id", "group_id") ); CREATE TABLE "auth_user_user_permissions" ( "id" integer NOT NULL PRIMARY KEY, "user_id" integer NOT NULL, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"), UNIQUE ("user_id", "permission_id") ); CREATE TABLE "django_content_type" ( "id" integer NOT NULL PRIMARY KEY, "name" varchar(100) NOT NULL, "app_label" varchar(100) NOT NULL, "model" varchar(100) NOT NULL, UNIQUE ("app_label", "model") ); CREATE TABLE "django_session" ( "session_key" varchar(40) NOT NULL PRIMARY KEY, "session_data" text NOT NULL, "expire_date" datetime NOT NULL ); CREATE TABLE "network_globalconfiguration" ( "gc_domain" varchar(120), "gc_ipv4gateway" varchar(42), "gc_hostname" varchar(120), "gc_ipv6gateway" varchar(42), "gc_nameserver1" varchar(42), "gc_nameserver3" varchar(42), "gc_nameserver2" varchar(42) NOT NULL, "id" integer PRIMARY KEY ); CREATE TABLE "network_interfaces" ( "int_v6netmaskbit" varchar(4), "int_ipv4address" varchar(42), "int_name" varchar(120), "int_ipv6address" varchar(42), "int_options" varchar(120), "int_dhcp" bool, "int_v4netmaskbit" varchar(3) NOT NULL, "int_ipv6auto" bool, "int_interface" varchar(300), "id" integer PRIMARY KEY ); CREATE TABLE "network_lagginterface" ( "id" integer NOT NULL PRIMARY KEY, "lagg_interface_id" integer NOT NULL UNIQUE, "lagg_protocol" varchar(120) NOT NULL ); CREATE TABLE "network_lagginterfacemembers" ( "id" integer NOT NULL PRIMARY KEY, "lagg_interfacegroup_id" integer NOT NULL, "lagg_ordernum" integer NOT NULL, "lagg_physnic" varchar(120) NOT NULL UNIQUE, "lagg_deviceoptions" varchar(120) NOT NULL ); CREATE TABLE "network_staticroute" ( "id" integer NOT NULL PRIMARY KEY, "sr_destination" varchar(120) NOT NULL, "sr_gateway" varchar(120) NOT NULL, "sr_description" varchar(120) NOT NULL ); CREATE TABLE "network_vlan" ( "id" integer NOT NULL PRIMARY KEY, "vlan_vint" varchar(120) NOT NULL, "vlan_pint" varchar(300) NOT NULL, "vlan_tag" varchar(120) NOT NULL, "vlan_description" varchar(120) NOT NULL ); CREATE TABLE "services_activedirectory" ( "ad_workgroup" varchar(120), "ad_netbiosname" varchar(120), "ad_adminname" varchar(120), "ad_windows_version" varchar(120), "ad_spnpw" varchar(120), "ad_spn" varchar(120), "ad_domainname" varchar(120), "ad_keytab" text NOT NULL DEFAULT '', "ad_adminpw" varchar(120), "id" integer PRIMARY KEY, "ad_dcname" varchar(120) ); CREATE TABLE "services_afp" ( "id" integer NOT NULL PRIMARY KEY, "afp_srv_name" varchar(120) NOT NULL, "afp_srv_guest" bool NOT NULL DEFAULT False, "afp_srv_local" bool NOT NULL DEFAULT False, "afp_srv_ddp" bool NOT NULL DEFAULT False ); CREATE TABLE "services_cifs" ( "cifs_srv_guestok" bool, "cifs_srv_dirmask" varchar(120), "cifs_srv_description" varchar(120), "cifs_srv_loglevel" varchar(120), "cifs_srv_guest" varchar(120), "cifs_srv_filemask" varchar(120), "cifs_srv_guestonly" bool, "cifs_srv_easupport" bool, "id" integer PRIMARY KEY, "cifs_srv_aio_ws" integer, "cifs_srv_dosattr" bool, "cifs_srv_timeserver" bool, "cifs_srv_homedir_enable" bool, "cifs_srv_aio_enable" bool, "cifs_srv_largerw" bool, "cifs_srv_aio_rs" integer, "cifs_srv_nullpw" bool, "cifs_srv_netbiosname" varchar(120), "cifs_srv_workgroup" varchar(120), "cifs_srv_doscharset" varchar(120), "cifs_srv_smb_options" text, "cifs_srv_localmaster" bool, "cifs_srv_authmodel" varchar(10), "cifs_srv_sendfile" bool, "cifs_srv_unixcharset" varchar(120) ); CREATE TABLE "services_dynamicdns" ( "id" integer NOT NULL PRIMARY KEY, "ddns_provider" varchar(120) NOT NULL DEFAULT 'dyndns', "ddns_domain" varchar(120) NOT NULL, "ddns_username" varchar(120) NOT NULL, "ddns_password" varchar(120) NOT NULL, "ddns_updateperiod" varchar(120) NOT NULL, "ddns_fupdateperiod" varchar(120) NOT NULL, "ddns_wildcard" bool NOT NULL DEFAULT False, "ddns_options" text NOT NULL ); CREATE TABLE "services_ftp" ( "ftp_anonuserbw" integer unsigned, "ftp_ident" bool, "ftp_timeout" integer unsigned, "ftp_resume" bool, "ftp_options" text, "ftp_masqaddress" char(15), "id" integer PRIMARY KEY, "ftp_anonpath_id" integer, "ftp_passiveportsmax" integer unsigned, "ftp_port" integer unsigned NOT NULL DEFAULT 21, "ftp_ipconnections" integer unsigned, "ftp_ssltls" bool, "ftp_defaultroot" bool, "ftp_dirmask" varchar(3), "ftp_passiveportsmin" integer unsigned, "ftp_onlylocal" bool, "ftp_loginattempt" integer unsigned, "ftp_localuserbw" integer unsigned, "ftp_rootlogin" bool, "ftp_onlyanonymous" bool, "ftp_reversedns" bool, "ftp_anonuserdlbw" integer unsigned, "ftp_clients" integer unsigned, "ftp_fxp" bool, "ftp_filemask" varchar(3), "ftp_localuserdlbw" integer unsigned, "ftp_banner" text ); CREATE TABLE "services_iscsitarget" ( "id" integer NOT NULL PRIMARY KEY, "iscsi_target_name" varchar(120) NOT NULL UNIQUE, "iscsi_target_alias" varchar(120) NOT NULL UNIQUE, "iscsi_target_type" varchar(120) NOT NULL, "iscsi_target_flags" varchar(120) NOT NULL, "iscsi_target_portalgroup" integer NOT NULL DEFAULT 1, "iscsi_target_initiatorgroup" integer NOT NULL DEFAULT 1, "iscsi_target_authtype" varchar(120) NOT NULL DEFAULT 'Auto', "iscsi_target_authgroup" integer NOT NULL DEFAULT 1, "iscsi_target_initialdigest" varchar(120) NOT NULL DEFAULT 'Auto', "iscsi_target_queue_depth" integer NOT NULL DEFAULT 0, "iscsi_target_logical_blocksize" integer NOT NULL DEFAULT 512 ); CREATE TABLE "services_iscsitargetauthcredential" ( "id" integer NOT NULL PRIMARY KEY, "iscsi_target_auth_tag" integer NOT NULL DEFAULT 1, "iscsi_target_auth_user" varchar(120) NOT NULL, "iscsi_target_auth_secret" varchar(120) NOT NULL, "iscsi_target_auth_peeruser" varchar(120) NOT NULL, "iscsi_target_auth_peersecret" varchar(120) NOT NULL ); CREATE TABLE "services_iscsitargetauthorizedinitiator" ( "id" integer NOT NULL PRIMARY KEY, "iscsi_target_initiator_tag" integer NOT NULL UNIQUE, "iscsi_target_initiator_initiators" text NOT NULL DEFAULT 'ALL', "iscsi_target_initiator_auth_network" text NOT NULL DEFAULT 'ALL', "iscsi_target_initiator_comment" varchar(120) NOT NULL ); CREATE TABLE "services_iscsitargetextent" ( "id" integer NOT NULL PRIMARY KEY, "iscsi_target_extent_name" varchar(120) NOT NULL, "iscsi_target_extent_type" varchar(120) NOT NULL, "iscsi_target_extent_path" varchar(120) NOT NULL, "iscsi_target_extent_filesize" integer NOT NULL DEFAULT 0, "iscsi_target_extent_comment" varchar(120) NOT NULL ); CREATE TABLE "services_iscsitargetglobalconfiguration" ( "iscsi_luc_authmethod" varchar(120), "iscsi_firstburst" integer, "iscsi_r2t" integer, "iscsi_luc_authnetwork" varchar(120), "iscsi_maxburst" integer, "iscsi_maxsesh" integer, "iscsi_maxoutstandingr2t" integer, "id" integer PRIMARY KEY, "iscsi_maxrecdata" integer, "iscsi_iotimeout" integer, "iscsi_lucip" char(15), "iscsi_discoveryauthmethod" varchar(120), "iscsi_maxconnect" integer, "iscsi_basename" varchar(120), "iscsi_defaultt2r" integer, "iscsi_nopinint" integer, "iscsi_discoveryauthgroup" varchar(120), "iscsi_toggleluc" bool, "iscsi_lucport" integer, "iscsi_luc_authgroup" integer NULL, "iscsi_defaultt2w" integer ); CREATE TABLE "services_iscsitargetportal" ( "id" integer NOT NULL PRIMARY KEY, "iscsi_target_portal_tag" integer NOT NULL DEFAULT 1, "iscsi_target_portal_listen" varchar(120) NOT NULL DEFAULT '0.0.0.0:3260', "iscsi_target_portal_comment" varchar(120) NOT NULL ); CREATE TABLE "services_iscsitargettoextent" ( "id" integer NOT NULL PRIMARY KEY, "iscsi_target_id" integer NOT NULL, "iscsi_extent_id" integer NOT NULL UNIQUE, "iscsi_target_lun" integer NOT NULL DEFAULT 0 ); CREATE TABLE "services_ldap" ( "ldap_hostname" varchar(120), "ldap_tls_cacertfile" text NOT NULL DEFAULT '', "ldap_basedn" varchar(120), "ldap_rootbindpw" varchar(120), "ldap_options" text, "ldap_pwencryption" varchar(120), "id" integer PRIMARY KEY, "ldap_anonbind" bool, "ldap_ssl" varchar(120), "ldap_machinesuffix" varchar(120), "ldap_groupsuffix" varchar(120), "ldap_usersuffix" varchar(120), "ldap_rootbasedn" varchar(120), "ldap_passwordsuffix" varchar(120) ); CREATE TABLE "services_nfs" ( "id" integer NOT NULL PRIMARY KEY, "nfs_srv_servers" varchar(120) NOT NULL ); CREATE TABLE "services_services" ( "id" integer NOT NULL PRIMARY KEY, "srv_service" varchar(120) NOT NULL, "srv_enable" bool NOT NULL DEFAULT False ); CREATE TABLE "services_snmp" ( "id" integer NOT NULL PRIMARY KEY, "snmp_location" varchar(120) NOT NULL, "snmp_contact" varchar(120) NOT NULL, "snmp_community" varchar(120) NOT NULL, "snmp_traps" bool NOT NULL DEFAULT False, "snmp_options" text NOT NULL ); CREATE TABLE "services_ssh" ( "ssh_host_dsa_key_pub" text, "ssh_host_rsa_key_pub" text NULL, "ssh_host_key" text, "ssh_tcpport" varchar(120), "ssh_options" text, "ssh_passwordauth" bool, "id" integer PRIMARY KEY, "ssh_compression" bool, "ssh_host_key_pub" text, "ssh_rootlogin" bool, "ssh_tcpfwd" bool, "ssh_host_rsa_key" text, "ssh_privatekey" text, "ssh_host_dsa_key" text ); CREATE TABLE "services_tftp" ( "id" integer NOT NULL PRIMARY KEY, "tftp_directory" varchar(120) NOT NULL, "tftp_newfiles" bool NOT NULL DEFAULT False, "tftp_port" varchar(120) NOT NULL, "tftp_username" varchar(120) NOT NULL DEFAULT 'nobody', "tftp_umask" varchar(120) NOT NULL, "tftp_options" varchar(120) NOT NULL ); CREATE TABLE "services_ups" ( "id" integer NOT NULL PRIMARY KEY, "ups_identifier" varchar(120) NOT NULL, "ups_driver" varchar(120) NOT NULL, "ups_port" varchar(120) NOT NULL, "ups_options" text NOT NULL, "ups_description" varchar(120) NOT NULL, "ups_shutdown" varchar(120) NOT NULL DEFAULT 'batt', "ups_shutdowntimer" varchar(120) NOT NULL, "ups_rmonitor" bool NOT NULL DEFAULT False, "ups_emailnotify" bool NOT NULL DEFAULT False, "ups_toemail" varchar(120) NOT NULL, "ups_subject" varchar(120) NOT NULL ); CREATE TABLE "sharing_afp_share" ( "id" integer NOT NULL PRIMARY KEY, "afp_name" varchar(120) NOT NULL, "afp_comment" varchar(120) NOT NULL, "afp_path_id" integer NOT NULL, "afp_sharepw" varchar(120) NOT NULL, "afp_sharecharset" varchar(120) NOT NULL, "afp_allow" varchar(120) NOT NULL, "afp_deny" varchar(120) NOT NULL, "afp_ro" varchar(120) NOT NULL, "afp_rw" varchar(120) NOT NULL, "afp_diskdiscovery" bool NOT NULL DEFAULT False, "afp_discoverymode" varchar(120) NOT NULL DEFAULT 'Default', "afp_dbpath" varchar(120) NOT NULL, "afp_cachecnid" bool NOT NULL DEFAULT False, "afp_crlf" bool NOT NULL DEFAULT False, "afp_mswindows" bool NOT NULL DEFAULT False, "afp_noadouble" bool NOT NULL DEFAULT False, "afp_nodev" bool NOT NULL DEFAULT False, "afp_nofileid" bool NOT NULL DEFAULT False, "afp_nohex" bool NOT NULL DEFAULT False, "afp_prodos" bool NOT NULL DEFAULT False, "afp_nostat" bool NOT NULL DEFAULT False, "afp_upriv" bool NOT NULL DEFAULT False ); CREATE TABLE "sharing_cifs_share" ( "cifs_hostsallow" varchar(120), "cifs_name" varchar(120), "cifs_guest" varchar(120), "cifs_path_id" integer, "cifs_showhiddenfiles" bool, "cifs_hostsdeny" varchar(120), "cifs_browsable" bool, "cifs_recyclebin" bool, "cifs_guestok" bool, "cifs_comment" varchar(120), "cifs_ro" bool, "cifs_inheritperms" bool, "cifs_guestonly" bool NOT NULL DEFAULT False, "id" integer PRIMARY KEY, "cifs_auxsmbconf" text ); CREATE TABLE "sharing_nfs_share" ( "id" integer NOT NULL PRIMARY KEY, "nfs_comment" varchar(120) NOT NULL, "nfs_path_id" integer NOT NULL, "nfs_allroot" bool NOT NULL DEFAULT False, "nfs_network" varchar(120) NOT NULL, "nfs_alldirs" bool NOT NULL DEFAULT False, "nfs_ro" bool NOT NULL DEFAULT False, "nfs_quiet" bool NOT NULL DEFAULT False ); CREATE TABLE "south_migrationhistory" ( "id" integer NOT NULL PRIMARY KEY, "app_name" varchar(255) NOT NULL, "migration" varchar(255) NOT NULL, "applied" datetime NOT NULL ); CREATE TABLE "storage_disk" ( "id" integer NOT NULL PRIMARY KEY, "disk_name" varchar(120) NOT NULL UNIQUE, "disk_disks" varchar(120) NOT NULL, "disk_description" varchar(120) NOT NULL, "disk_transfermode" varchar(120) NOT NULL DEFAULT 'Auto', "disk_hddstandby" varchar(120) NOT NULL DEFAULT 'Always On', "disk_advpowermgmt" varchar(120) NOT NULL DEFAULT 'Disabled', "disk_acousticlevel" varchar(120) NOT NULL DEFAULT 'Disabled', "disk_togglesmart" bool NOT NULL DEFAULT True, "disk_smartoptions" varchar(120) NOT NULL, "disk_group_id" integer NOT NULL ); CREATE TABLE "storage_diskgroup" ( "id" integer NOT NULL PRIMARY KEY, "group_name" varchar(120) NOT NULL UNIQUE, "group_type" varchar(120) NOT NULL, "group_volume_id" integer NOT NULL ); CREATE TABLE "storage_mountpoint" ( "mp_path" varchar(120) UNIQUE, "mp_ischild" bool NOT NULL DEFAULT False, "mp_options" varchar(120), "mp_volume_id" integer, "id" integer PRIMARY KEY ); CREATE TABLE "storage_volume" ( "id" integer NOT NULL PRIMARY KEY, "vol_name" varchar(120) NOT NULL UNIQUE, "vol_fstype" varchar(120) NOT NULL ); CREATE TABLE "system_advanced" ( "adv_systembeep" bool, "adv_serialconsole" bool, "adv_consolescreensaver" bool, "adv_zeroconfbonjour" bool, "adv_consolemsg" bool NOT NULL DEFAULT True, "adv_tuning" bool, "adv_firmwarevc" bool, "adv_powerdaemon" bool, "adv_swapondrive" integer, "adv_motd" text, "adv_consolemenu" bool, "id" integer PRIMARY KEY ); CREATE TABLE "system_email" ( "id" integer NOT NULL PRIMARY KEY, "em_fromemail" varchar(120) NOT NULL, "em_outgoingserver" varchar(120) NOT NULL, "em_port" integer NOT NULL DEFAULT 25, "em_security" varchar(120) NOT NULL DEFAULT 'plain', "em_smtp" bool NOT NULL DEFAULT False, "em_user" varchar(120) NULL, "em_pass" varchar(120) NULL ); CREATE TABLE "system_settings" ( "stg_language" varchar(120), "stg_timezone" varchar(120), "stg_guiprotocol" varchar(120), "id" integer PRIMARY KEY, "stg_ntpserver1" varchar(120), "stg_ntpserver2" varchar(120), "stg_ntpserver3" varchar(120) ); CREATE TABLE "system_ssl" ( "ssl_org" varchar(120), "ssl_unit" varchar(120), "ssl_email" varchar(120), "ssl_city" varchar(120), "ssl_state" varchar(120), "ssl_country" varchar(120), "ssl_common" varchar(120), "ssl_certfile" text ); CREATE INDEX "account_bsdgroupmembership_9303d695" ON "account_bsdgroupmembership" ("bsdgrpmember_user_id"); CREATE INDEX "account_bsdgroupmembership_d3b92950" ON "account_bsdgroupmembership" ("bsdgrpmember_group_id"); CREATE INDEX "account_bsdusers_f22bd9ef" ON "account_bsdusers" ("bsdusr_group_id"); CREATE INDEX "auth_group_permissions_1e014c8f" ON "auth_group_permissions" ("permission_id"); CREATE INDEX "auth_group_permissions_bda51c3c" ON "auth_group_permissions" ("group_id"); CREATE INDEX "auth_message_fbfc09f1" ON "auth_message" ("user_id"); CREATE INDEX "auth_permission_e4470c6e" ON "auth_permission" ("content_type_id"); CREATE INDEX "auth_user_groups_bda51c3c" ON "auth_user_groups" ("group_id"); CREATE INDEX "auth_user_groups_fbfc09f1" ON "auth_user_groups" ("user_id"); CREATE INDEX "auth_user_user_permissions_1e014c8f" ON "auth_user_user_permissions" ("permission_id"); CREATE INDEX "auth_user_user_permissions_fbfc09f1" ON "auth_user_user_permissions" ("user_id"); CREATE INDEX "network_lagginterfacemembers_c784c51" ON "network_lagginterfacemembers" ("lagg_interfacegroup_id"); CREATE INDEX "services_iscsitargettoextent_6ab3fe8b" ON "services_iscsitargettoextent" ("iscsi_target_id"); CREATE INDEX "sharing_afp_share_59543197" ON "sharing_afp_share" ("afp_path_id"); CREATE INDEX "sharing_nfs_share_4b883b8f" ON "sharing_nfs_share" ("nfs_path_id"); CREATE INDEX "storage_disk_50820085" ON "storage_disk" ("disk_group_id"); CREATE INDEX "storage_diskgroup_31360cd6" ON "storage_diskgroup" ("group_volume_id");