FreeNAS Code
This project has moved to github - see https://github.com/freenas
Brought to you by:
cochard,
mattolander
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" ( "id" integer NOT NULL PRIMARY KEY, "gc_hostname" varchar(120) NOT NULL, "gc_domain" varchar(120) NOT NULL, "gc_ipv4gateway" varchar(120) NOT NULL, "gc_ipv6gateway" varchar(120) NOT NULL, "gc_nameserver1" varchar(120) NOT NULL, "gc_nameserver2" varchar(120) NOT NULL, "gc_nameserver3" varchar(120) NOT NULL ); CREATE TABLE "network_interfaces" ( "id" integer NOT NULL PRIMARY KEY, "int_interface" varchar(300) NOT NULL, "int_name" varchar(120) NOT NULL, "int_dhcp" bool NOT NULL, "int_ipv4address" varchar(18) NOT NULL, "int_ipv6auto" bool NOT NULL, "int_ipv6address" varchar(42) NOT NULL, "int_options" varchar(120) NOT NULL ); CREATE TABLE "network_lagg" ( "id" integer NOT NULL PRIMARY KEY, "lagg_vint" varchar(120) NOT NULL, "lagg_ports" varchar(120) NOT NULL, "lagg_description" 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" ( "id" integer NOT NULL PRIMARY KEY, "ad_dcname" varchar(120) NOT NULL, "ad_domainname" varchar(120) NOT NULL, "ad_netbiosname" varchar(120) NOT NULL, "ad_adminname" varchar(120) NOT NULL, "ad_adminpw" varchar(120) NOT NULL ); CREATE TABLE "services_afp" ( "id" integer NOT NULL PRIMARY KEY, "afp_srv_name" varchar(120) NOT NULL, "afp_srv_guest" bool NOT NULL, "afp_srv_local" bool NOT NULL, "afp_srv_ddp" bool NOT NULL ); CREATE TABLE "services_bittorrent" ( "id" integer NOT NULL PRIMARY KEY, "bt_peerport" varchar(120) NOT NULL, "bt_downloaddir" varchar(120) NOT NULL, "bt_configdir" varchar(120) NOT NULL, "bt_portfwd" bool NOT NULL, "bt_pex" bool NOT NULL, "bt_disthash" bool NOT NULL, "bt_encrypt" varchar(120) NOT NULL, "bt_uploadbw" varchar(120) NOT NULL, "bt_downloadbw" varchar(120) NOT NULL, "bt_watchdir" varchar(120) NOT NULL, "bt_incompletedir" varchar(120) NOT NULL, "bt_umask" varchar(120) NOT NULL, "bt_options" varchar(120) NOT NULL, "bt_adminport" varchar(120) NOT NULL, "bt_adminauth" varchar(120) NOT NULL, "bt_adminuser" varchar(120) NOT NULL, "bt_adminpass" varchar(120) NOT NULL ); CREATE TABLE "services_cifs" ( "id" integer NOT NULL PRIMARY KEY, "cifs_srv_netbiosname" varchar(120) NOT NULL, "cifs_srv_workgroup" varchar(120) NOT NULL, "cifs_srv_description" varchar(120) NOT NULL, "cifs_srv_doscharset" varchar(120) NOT NULL, "cifs_srv_unixcharset" varchar(120) NOT NULL, "cifs_srv_loglevel" varchar(120) NOT NULL, "cifs_srv_localmaster" bool NOT NULL, "cifs_srv_timeserver" bool NOT NULL, "cifs_srv_guest" varchar(120) NOT NULL, "cifs_srv_filemask" varchar(120) NOT NULL, "cifs_srv_dirmask" varchar(120) NOT NULL, "cifs_srv_sendbuffer" varchar(120) NOT NULL, "cifs_srv_recvbuffer" varchar(120) NOT NULL, "cifs_srv_largerw" bool NOT NULL, "cifs_srv_sendfile" bool NOT NULL, "cifs_srv_easupport" bool NOT NULL, "cifs_srv_dosattr" bool NOT NULL, "cifs_srv_nullpw" bool NOT NULL, "cifs_srv_smb_options" text NOT NULL ); CREATE TABLE "services_dynamicdns" ( "id" integer NOT NULL PRIMARY KEY, "ddns_provider" varchar(120) NOT NULL, "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, "ddns_options" text NOT NULL ); CREATE TABLE "services_ftp" ( "id" integer NOT NULL PRIMARY KEY, "ftp_clients" varchar(120) NOT NULL, "ftp_ipconnections" varchar(120) NOT NULL, "ftp_loginattempt" varchar(120) NOT NULL, "ftp_timeout" varchar(120) NOT NULL, "ftp_rootlogin" bool NOT NULL, "ftp_onlyanonymous" bool NOT NULL, "ftp_onlylocal" bool NOT NULL, "ftp_banner" text NOT NULL, "ftp_filemask" varchar(120) NOT NULL, "ftp_dirmask" varchar(120) NOT NULL, "ftp_fxp" bool NOT NULL, "ftp_resume" bool NOT NULL, "ftp_defaultroot" bool NOT NULL, "ftp_ident" bool NOT NULL, "ftp_reversedns" bool NOT NULL, "ftp_masqaddress" varchar(120) NOT NULL, "ftp_passiveportsmin" varchar(120) NOT NULL, "ftp_passiveportsmax" varchar(120) NOT NULL, "ftp_localuserbw" varchar(120) NOT NULL, "ftp_localuserdlbw" varchar(120) NOT NULL, "ftp_anonuserbw" varchar(120) NOT NULL, "ftp_anonuserdlbw" varchar(120) NOT NULL, "ftp_ssltls" bool NOT NULL, "ftp_options" text NOT NULL ); CREATE TABLE "services_iscsitarget" ( "id" integer NOT NULL PRIMARY KEY, "iscsi_basename" varchar(120) NOT NULL, "iscsi_discoveryauthmethod" varchar(120) NOT NULL, "iscsi_discoveryauthgroup" varchar(120) NOT NULL, "iscsi_io" varchar(120) NOT NULL, "iscsi_nopinint" varchar(120) NOT NULL, "iscsi_maxsesh" varchar(120) NOT NULL, "iscsi_maxconnect" varchar(120) NOT NULL, "iscsi_firstburst" varchar(120) NOT NULL, "iscsi_maxburst" varchar(120) NOT NULL, "iscsi_maxrecdata" varchar(120) NOT NULL, "iscsi_toggleluc" bool NOT NULL ); CREATE TABLE "services_ldap" ( "id" integer NOT NULL PRIMARY KEY, "ldap_hostname" varchar(120) NOT NULL, "ldap_basedn" varchar(120) NOT NULL, "ldap_anonbind" bool NOT NULL, "ldap_rootbasedn" varchar(120) NOT NULL, "ldap_rootbindpw" varchar(120) NOT NULL, "ldap_pwencryption" varchar(120) NOT NULL, "ldap_usersuffix" varchar(120) NOT NULL, "ldap_groupsuffix" varchar(120) NOT NULL, "ldap_passwordsuffix" varchar(120) NOT NULL, "ldap_machinesuffix" varchar(120) NOT NULL, "ldap_options" text NOT NULL ); CREATE TABLE "services_nfs" ( "id" integer NOT NULL PRIMARY KEY, "nfs_srv_servers" varchar(120) NOT NULL ); CREATE TABLE "services_rsyncjob" ( "id" integer NOT NULL PRIMARY KEY, "rj_type" varchar(120) NOT NULL, "rj_path" varchar(120) NOT NULL, "rj_server" varchar(120) NOT NULL, "rj_who" varchar(120) NOT NULL, "rj_description" varchar(120) NOT NULL, "rj_ToggleMinutes" varchar(120) NOT NULL, "rj_Minutes1" varchar(120) NOT NULL, "rj_Minutes2" varchar(120) NOT NULL, "rj_Minutes3" varchar(120) NOT NULL, "rj_Minutes4" varchar(120) NOT NULL, "rj_ToggleHours" varchar(120) NOT NULL, "rj_Hours1" varchar(120) NOT NULL, "rj_Hours2" varchar(120) NOT NULL, "rj_ToggleDays" varchar(120) NOT NULL, "rj_Days1" varchar(120) NOT NULL, "rj_Days2" varchar(120) NOT NULL, "rj_Days3" varchar(120) NOT NULL, "rj_ToggleMonths" varchar(120) NOT NULL, "rj_Months" varchar(120) NOT NULL, "rj_ToggleWeekdays" varchar(120) NOT NULL, "rj_Weekdays" varchar(120) NOT NULL, "rj_recursive" bool NOT NULL, "rj_times" bool NOT NULL, "rj_compress" bool NOT NULL, "rj_archive" bool NOT NULL, "rj_delete" bool NOT NULL, "rj_quiet" bool NOT NULL, "rj_preserveperms" bool NOT NULL, "rj_extattr" bool NOT NULL, "rj_options" 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 ); 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, "snmp_options" text NOT NULL ); CREATE TABLE "services_ssh" ( "id" integer NOT NULL PRIMARY KEY, "ssh_tcpport" varchar(120) NOT NULL, "ssh_rootlogin" bool NOT NULL, "ssh_passwordauth" bool NOT NULL, "ssh_tcpfwd" bool NOT NULL, "ssh_compression" bool NOT NULL, "ssh_privatekey" text NOT NULL, "ssh_options" text NOT NULL ); CREATE TABLE "services_tftp" ( "id" integer NOT NULL PRIMARY KEY, "tftp_directory" varchar(120) NOT NULL, "tftp_newfiles" bool NOT NULL, "tftp_port" varchar(120) NOT NULL, "tftp_username" varchar(120) NOT NULL, "tftp_umask" varchar(120) NOT NULL, "tftp_options" varchar(120) NOT NULL ); CREATE TABLE "services_unison" ( "id" integer NOT NULL PRIMARY KEY, "uni_workingdir" varchar(120) NOT NULL, "uni_createworkingdir" bool 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, "ups_shutdowntimer" varchar(120) NOT NULL, "ups_rmonitor" bool NOT NULL, "ups_emailnotify" bool NOT NULL, "ups_toemail" varchar(120) NOT NULL, "ups_subject" varchar(120) NOT NULL ); CREATE TABLE "services_webserver" ( "id" integer NOT NULL PRIMARY KEY, "web_protocol" varchar(120) NOT NULL, "web_port" varchar(120) NOT NULL, "web_docroot" varchar(120) NOT NULL, "web_auth" bool NOT NULL, "web_dirlisting" bool 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 REFERENCES "storage_mountpoint" ("id"), "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, "afp_discoverymode" varchar(120) NOT NULL, "afp_dbpath" varchar(120) NOT NULL, "afp_cachecnid" bool NOT NULL, "afp_crlf" bool NOT NULL, "afp_mswindows" bool NOT NULL, "afp_noadouble" bool NOT NULL, "afp_nodev" bool NOT NULL, "afp_nofileid" bool NOT NULL, "afp_nohex" bool NOT NULL, "afp_prodos" bool NOT NULL, "afp_nostat" bool NOT NULL, "afp_upriv" bool NOT NULL ); CREATE TABLE "sharing_cifs_share" ( "id" integer NOT NULL PRIMARY KEY, "cifs_name" varchar(120) NOT NULL, "cifs_comment" varchar(120) NOT NULL, "cifs_path_id" integer NOT NULL REFERENCES "storage_mountpoint" ("id"), "cifs_ro" bool NOT NULL, "cifs_browsable" bool NOT NULL, "cifs_inheritperms" bool NOT NULL, "cifs_recyclebin" bool NOT NULL, "cifs_showhiddenfiles" bool NOT NULL, "cifs_hostsallow" varchar(120) NOT NULL, "cifs_hostsdeny" varchar(120) NOT NULL, "cifs_auxsmbconf" text NOT NULL ); CREATE TABLE "sharing_nfs_share" ( "id" integer NOT NULL PRIMARY KEY, "nfs_comment" varchar(120) NOT NULL, "nfs_path_id" integer NOT NULL REFERENCES "storage_mountpoint" ("id"), "nfs_allroot" bool NOT NULL, "nfs_network" varchar(120) NOT NULL, "nfs_alldirs" bool NOT NULL, "nfs_ro" bool NOT NULL, "nfs_quiet" bool 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, "disk_hddstandby" varchar(120) NOT NULL, "disk_advpowermgmt" varchar(120) NOT NULL, "disk_acousticlevel" varchar(120) NOT NULL, "disk_togglesmart" bool NOT NULL, "disk_smartoptions" varchar(120) NOT NULL, "disk_group_id" integer NOT NULL REFERENCES "storage_diskgroup" ("id") ); 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 REFERENCES "storage_volume" ("id") ); CREATE TABLE "storage_mountpoint" ( "id" integer NOT NULL PRIMARY KEY, "mp_volume_id" integer NOT NULL REFERENCES "storage_volume" ("id"), "mp_path" varchar(120) NOT NULL UNIQUE, "mp_options" varchar(120) ); 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" ( "id" integer NOT NULL PRIMARY KEY, "adv_consolemenu" bool NOT NULL, "adv_serialconsole" bool NOT NULL, "adv_consolescreensaver" bool NOT NULL, "adv_firmwarevc" bool NOT NULL, "adv_systembeep" bool NOT NULL, "adv_tuning" bool NOT NULL, "adv_powerdaemon" bool NOT NULL, "adv_zeroconfbonjour" bool NOT NULL, "adv_motd" text NOT NULL ); CREATE TABLE "system_commandscripts" ( "id" integer NOT NULL PRIMARY KEY, "cmds_command" varchar(120) NOT NULL, "cmds_commandtype" varchar(120) NOT NULL ); CREATE TABLE "system_cronjob" ( "id" integer NOT NULL PRIMARY KEY, "cron_enable" bool NOT NULL, "cron_command" varchar(120) NOT NULL, "cron_who" varchar(120) NOT NULL, "cron_description" varchar(120) NOT NULL, "cron_ToggleMinutes" varchar(120) NOT NULL, "cron_Minutes1" varchar(120) NOT NULL, "cron_Minutes2" varchar(120) NOT NULL, "cron_Minutes3" varchar(120) NOT NULL, "cron_Minutes4" varchar(120) NOT NULL, "cron_ToggleHours" varchar(120) NOT NULL, "cron_Hours1" varchar(120) NOT NULL, "cron_Hours2" varchar(120) NOT NULL, "cron_ToggleDays" varchar(120) NOT NULL, "cron_Days1" varchar(120) NOT NULL, "cron_Days2" varchar(120) NOT NULL, "cron_Days3" varchar(120) NOT NULL, "cron_ToggleMonths" varchar(120) NOT NULL, "cron_Months" varchar(120) NOT NULL, "cron_ToggleWeekdays" varchar(120) NOT NULL, "cron_Weekdays" varchar(120) NOT NULL ); CREATE TABLE "system_email" ( "id" integer NOT NULL PRIMARY KEY, "em_fromemail" varchar(120) NOT NULL, "em_outgoingserver" varchar(120) NOT NULL, "em_port" varchar(120) NOT NULL, "em_security" varchar(120) NOT NULL, "em_smtp" bool NOT NULL ); CREATE TABLE "system_password" ( "id" integer NOT NULL PRIMARY KEY, "pw_currentpw" varchar(120) NOT NULL, "pw_newpw" varchar(120) NOT NULL, "pw_newpw2" varchar(120) NOT NULL ); CREATE TABLE "system_proxy" ( "id" integer NOT NULL PRIMARY KEY, "pxy_httpproxy" bool NOT NULL, "pxy_httpproxyaddress" varchar(120) NOT NULL, "pxy_httpproxyport" varchar(120) NOT NULL, "pxy_httpproxyauth" bool NOT NULL, "pxy_ftpproxy" bool NOT NULL, "pxy_ftpproxyaddress" varchar(120) NOT NULL, "pxy_ftpproxyport" varchar(120) NOT NULL, "pxy_ftpproxyauth" bool NOT NULL ); CREATE TABLE "system_rcconf" ( "id" integer NOT NULL PRIMARY KEY, "rcc_varname" varchar(120) NOT NULL, "rcc_varvalue" varchar(120) NOT NULL, "rcc_varcomment" varchar(120) NOT NULL ); CREATE TABLE "system_settings" ( "id" integer NOT NULL PRIMARY KEY, "stg_username" varchar(120) NOT NULL, "stg_guiprotocol" varchar(120) NOT NULL, "stg_language" varchar(120) NOT NULL, "stg_timezone" varchar(120) NOT NULL ); CREATE TABLE "system_swap" ( "id" integer NOT NULL PRIMARY KEY, "swap_memory" bool NOT NULL, "swap_type" varchar(120) NOT NULL, "swap_mountpoint" varchar(120) NOT NULL, "swap_size" varchar(120) NOT NULL ); CREATE TABLE "system_sysctl" ( "id" integer NOT NULL PRIMARY KEY, "sctl_MIBname" varchar(120) NOT NULL, "sctl_MIBvalue" varchar(120) NOT NULL, "sctl_MIBcomment" varchar(120) NOT NULL ); 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 "sharing_afp_share_59543197" ON "sharing_afp_share" ("afp_path_id"); CREATE INDEX "sharing_cifs_share_f37b7640" ON "sharing_cifs_share" ("cifs_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"); CREATE INDEX "storage_mountpoint_67d4317f" ON "storage_mountpoint" ("mp_volume_id");