Advanced Features > Database Schema

Navigation: Advanced Features > Database Schema |

Note: You needn't to create database schemas or tables by yourself, Wing FTP Server will create them automatically when configuring ODBC/Mysql settings(if you use Mysql, please create a mysql database first, the default database name is "wftp_database").

Schemas for ODBC database

1) table for mapping relations of user and group(wftp_table_user_group)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
Group_Name | varchar (64) | NOT NULL | the group name

2) table for user information(wftp_table_user)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
EnableAccount | int |  | enable account?,1=yes,0=no
EnablePassword | int |  | enable password?,1=yes,0=no
Password | varchar (64) | NOT NULL | the user password
ProtocolType | int |  | enabled protocols mask, FTP=1,FTP(TLS)=2,FTP(SSL)=4,HTTP=8,HTTP(SSL)=16,SSH=32,if only allow FTP and HTTP, the mask number is 1+8 = 9
EnableExpire | int |  | enable account expire?,1=yes,0=no
ExpireTime | varchar (32) |  | the account expire time,such as "2009-09-09 00:00:00"
MaxDownloadSpeed | int |  | max session download speed
MaxUploadSpeed | int |  | max session upload speed
MaxConnection | int |  | max number of connections
SessionNoCommandTimeOut | int |  | ftp connection timeout value
SessionNoTransferTimeOut | int |  | ftp idle timeout value
ConnectionPerIp | int |  | max number of connections per Ip
PasswordLength | int |  | max password length
ShowHiddenFile | int |  | show the hidden file?, 1=show,0=hide
CanChangePassword | int |  | user can change password?, 1=allow,0=deny
CanSendMessageToServer | int |  | send chat message?, 1=allow,0=deny
CurrentCredit | varchar (64) |  | current ratio credit
RatioDownload | int |  | ratio download
RatioUpload | int |  | ratio upload
RatioCountMethod | int |  | ratio count method,0=count for files,1=count for bytes
EnableRatio | int |  | enable ratio?, 1=yes,0=no
MaxQuota | varchar (64) |  | max quota size
CurrentQuota | varchar (64) |  | current quota size
EnableQuota | int |  | enable quota?, 1=yes,0=no
NotesName | varchar (64) |  | note name text
NotesAddress | varchar (255) |  | note address text
NotesZipCode | varchar (64) |  | note zipcode text
NotesPhone | varchar (64) |  | note phone number text
NotesFax | varchar (64) |  | note fax number text
NotesEmail | varchar (128) |  | note email text
NotesMemo | varchar (255) |  | note memo text
TotalReceivedBytes | varchar (64) |  | total received bytes
TotalSentBytes | varchar (64) |  | total sent bytes
LoginCount | int |  | login count
FileDownload | int |  | total downloaded files
FileUpload | int |  | total uploaded files
FailedDownload | int |  | total download failed files
FailedUpload | int |  | total upload failed files
LastLoginIp | varchar (64) |  | the last login IP
LastLoginTime | varchar (64) |  | the last login time
EnableGroup | int |  | enable group?, 1=yes,0=no
EnableSchedule | int |  | enable access schedule?, 1=yes,0=no
LimitResetTime | int |  | transfer limit reset time
LimitResetType | int |  | transfer limit reset type, 0=reset never,1=reset hourly,2=reset daily,3=reset weekly,4=reset monthly
EnableUploadLimit | int |  | enable transfer limit upload?, 1=yes,0=no
CurLimitUploadSize | int |  | current upload size
MaxLimitUploadSize | int |  | max upload size
EnableDownloadLimit | int |  | enable transfer limit download?, 1=yes,0=no
CurLimitDownLoadSize | int |  | current download size
MaxLimitDownloadSize | int |  | max download size
SSHPublicKeyPath | varchar (255) |  | SSH public key path (optional)

3) table for user's directory(wftp_table_dir)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
DirPath | varchar (255) | NOT NULL | the directory real path
DirAlias | varchar (128) |  | the directory virtual path
Home_Dir | int |  | is home directory?, 1=yes,0=no
File_Read | int |  | enable file read?, 1=yes,0=no
File_Write | int |  | enable file write?, 1=yes,0=no
File_Append | int |  | enable file append?, 1=yes,0=no
File_Delete | int |  | enable file delete?, 1=yes,0=no
Directory_List | int |  | enable directory list?, 1=yes,0=no
Directory_Rename | int |  | enable directory/file rename?, 1=yes,0=no
Directory_Make | int |  | enable directory create?, 1=yes,0=no
Directory_Delete | int |  | enable directory delete?, 1=yes,0=no
File_Rename | int |  | enable file rename?, 1=yes,0=no
Zip_File | int |  | enable zip files?, 1=yes,0=no
Unzip_File | int |  | enable unzip files?, 1=yes,0=no

4) table for user's filemask(wftp_table_filemask)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
Filename | varchar (128) | NOT NULL | the file mask
Refuse | int |  | refuse access?, 1=yes,0=no

5) table for user's ipmask(wftp_table_ipmask)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
Ip | varchar (128) | NOT NULL | the ip mask
Refuse | int |  | refuse access?, 1=yes,0=no

6) table for user's access schedule(wftp_table_schedule)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
Weekday | int |  | the day for access schedule. 0=Sunday,1=Monday,2=Tuesday,3=Wednesday,4=Thursday,5=Friday,6=Saturday
TimeFrom | varchar (32) |  | start time for access
TimeTo | varchar (32) |  | end time for access

7) table for group information(wftp_table_group)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
Group_Name | varchar (64) | NOT NULL | the group name
MaxDownloadSpeed | int |  | max session download speed
MaxUploadSpeed | int |  | max session upload speed
MaxConnection | int |  | max number of connections
SessionNoCommandTimeOut | int |  | ftp connection timeout value
SessionNoTransferTimeOut | int |  | ftp idle timeout value
ConnectionPerIp | int |  | max number of connections per Ip
ShowHiddenFile | int |  | show the hidden file?, 1=show,0=hide
CanSendMessageToServer | int |  | send chat message?, 1=allow,0=deny
TotalReceivedBytes | varchar (64) |  | total received bytes
TotalSentBytes | varchar (64) |  | total sent bytes
LoginCount | int |  | login count
FileDownload | int |  | total downloaded files
FileUpload | int |  | total uploaded files
FailedDownload | int |  | total download failed files
FailedUpload | int |  | total upload failed files

8) table for group's directory(wftp_table_dir2)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
Group_Name | varchar (64) | NOT NULL | the group name
DirPath | varchar (255) | NOT NULL | the directory real path
DirAlias | varchar (128) |  | the directory virtual path
Home_Dir | int |  | is home directory?, 1=yes,0=no
File_Read | int |  | enable file read?, 1=yes,0=no
File_Write | int |  | enable file write?, 1=yes,0=no
File_Append | int |  | enable file append?, 1=yes,0=no
File_Delete | int |  | enable file delete?, 1=yes,0=no
Directory_List | int |  | enable directory list?, 1=yes,0=no
Directory_Rename | int |  | enable directory/file rename?, 1=yes,0=no
Directory_Make | int |  | enable directory create?, 1=yes,0=no
Directory_Delete | int |  | enable directory delete?, 1=yes,0=no
File_Rename | int |  | enable file rename?, 1=yes,0=no
Zip_File | int |  | enable zip files?, 1=yes,0=no
Unzip_File | int |  | enable unzip files?, 1=yes,0=no

9) table for group's filemask(wftp_table_filemask2)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
Group_Name | varchar (64) | NOT NULL | the group name
Filename | varchar (128) | NOT NULL | the file mask
Refuse | int |  | refuse access?, 1=yes,0=no

10) table for group's ipmask(wftp_table_ipmask2)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
Group_Name | varchar (64) | NOT NULL | the group name
Ip | varchar (128) | NOT NULL | the ip mask
Refuse | int |  | refuse access?, 1=yes,0=no

Schemas for Mysql database

1) table for mapping relations of user and group(wftp_mysqltable_user_group)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
Group_Name | varchar (64) | NOT NULL | the group name

2) table for user information(wftp_mysqltable_user)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
EnableAccount | int(11) |  | enable account?,1=yes,0=no
EnablePassword | int(11) |  | enable password?,1=yes,0=no
Password | varchar (64) | NOT NULL | the user password
ProtocolType | int(11) |  | enabled protocols mask, FTP=1,FTP(TLS)=2,FTP(SSL)=4,HTTP=8,HTTP(SSL)=16,SSH=32,if only allow FTP and HTTP, the mask number is 1+8 = 9
EnableExpire | int(11) |  | enable account expire?,1=yes,0=no
ExpireTime | varchar (32) |  | the account expire time,such as "2009-09-09 00:00:00"
MaxDownloadSpeed | int(11) |  | max session download speed
MaxUploadSpeed | int(11) |  | max session upload speed
MaxConnection | int(11) |  | max number of connections
SessionNoCommandTimeOut | int(11) |  | ftp connection timeout value
SessionNoTransferTimeOut | int(11) |  | ftp idle timeout value
ConnectionPerIp | int(11) |  | max number of connections per Ip
PasswordLength | int(11) |  | max password length
ShowHiddenFile | int(11) |  | show the hidden file?, 1=show,0=hide
CanChangePassword | int(11) |  | user can change password?, 1=allow,0=deny
CanSendMessageToServer | int(11) |  | send chat message?, 1=allow,0=deny
CurrentCredit | bigint(20) |  | current ratio credit
RatioDownload | int(11) |  | ratio download
RatioUpload | int(11) |  | ratio upload
RatioCountMethod | int(11) |  | ratio count method,0=count for files,1=count for bytes
EnableRatio | int(11) |  | enable ratio?, 1=yes,0=no
MaxQuota | bigint(20) |  | max quota size
CurrentQuota | bigint(20) |  | current quota size
EnableQuota | int(11) |  | enable quota?, 1=yes,0=no
NotesName | varchar (64) |  | note name text
NotesAddress | varchar (255) |  | note address text
NotesZipCode | varchar (64) |  | note zipcode text
NotesPhone | varchar (64) |  | note phone number text
NotesFax | varchar (64) |  | note fax number text
NotesEmail | varchar (128) |  | note email text
NotesMemo | varchar (255) |  | note memo text
TotalReceivedBytes | bigint(20) |  | total received bytes
TotalSentBytes | bigint(20) |  | total sent bytes
LoginCount | int(11) |  | login count
FileDownload | int(11) |  | total downloaded files
FileUpload | int(11) |  | total uploaded files
FailedDownload | int(11) |  | total download failed files
FailedUpload | int(11) |  | total upload failed files
LastLoginIp | varchar (64) |  | the last login IP
LastLoginTime | varchar (64) |  | the last login time
EnableGroup | int(11) |  | enable group?, 1=yes,0=no
EnableSchedule | int(11) |  | enable access schedule?, 1=yes,0=no
LimitResetTime | int(11) |  | transfer limit reset time
LimitResetType | int(11) |  | transfer limit reset type, 0=reset never,1=reset hourly,2=reset daily,3=reset weekly,4=reset monthly
EnableUploadLimit | int(11) |  | enable transfer limit upload?, 1=yes,0=no
CurLimitUploadSize | int(11) |  | current upload size
MaxLimitUploadSize | int(11) |  | max upload size
EnableDownloadLimit | int(11) |  | enable transfer limit download?, 1=yes,0=no
CurLimitDownLoadSize | int(11) |  | current download size
MaxLimitDownloadSize | int(11) |  | max download size
SSHPublicKeyPath | varchar (255) |  | SSH public key path (optional)

3) table for user's directory(wftp_mysqltable_dir)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
DirPath | varchar (255) | NOT NULL | the directory real path
DirAlias | varchar (128) |  | the directory virtual path
Home_Dir | int(11) |  | is home directory?, 1=yes,0=no
File_Read | int(11) |  | enable file read?, 1=yes,0=no
File_Write | int(11) |  | enable file write?, 1=yes,0=no
File_Append | int(11) |  | enable file append?, 1=yes,0=no
File_Delete | int(11) |  | enable file delete?, 1=yes,0=no
Directory_List | int(11) |  | enable directory list?, 1=yes,0=no
Directory_Rename | int(11) |  | enable directory/file rename?, 1=yes,0=no
Directory_Make | int(11) |  | enable directory create?, 1=yes,0=no
Directory_Delete | int(11) |  | enable directory delete?, 1=yes,0=no
File_Rename | int(11) |  | enable file rename?, 1=yes,0=no
Zip_File | int(11) |  | enable zip files?, 1=yes,0=no
Unzip_File | int(11) |  | enable unzip files?, 1=yes,0=no

4) table for user's filemask(wftp_mysqltable_filemask)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
Filename | varchar (128) | NOT NULL | the file mask
Refuse | int(11) |  | refuse access?, 1=yes,0=no

5) table for user's ipmask(wftp_mysqltable_ipmask)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
Ip | varchar (128) | NOT NULL | the ip mask
Refuse | int(11) |  | refuse access?, 1=yes,0=no

6) table for user's access schedule(wftp_mysqltable_schedule)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
User_Name | varchar (64) | NOT NULL | the user name
Weekday | int(11) |  | the day for access schedule. 0=Sunday,1=Monday,2=Tuesday,3=Wednesday,4=Thursday,5=Friday,6=Saturday
TimeFrom | varchar (32) |  | start time for access
TimeTo | varchar (32) |  | end time for access

7) table for group information(wftp_mysqltable_group)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
Group_Name | varchar (64) | NOT NULL | the group name
MaxDownloadSpeed | int(11) |  | max session download speed
MaxUploadSpeed | int(11) |  | max session upload speed
MaxConnection | int(11) |  | max number of connections
SessionNoCommandTimeOut | int(11) |  | ftp connection timeout value
SessionNoTransferTimeOut | int(11) |  | ftp idle timeout value
ConnectionPerIp | int(11) |  | max number of connections per Ip
ShowHiddenFile | int(11) |  | show the hidden file?, 1=show,0=hide
CanSendMessageToServer | int(11) |  | send chat message?, 1=allow,0=deny
TotalReceivedBytes | bigint(20) |  | total received bytes
TotalSentBytes | bigint(20) |  | total sent bytes
LoginCount | int(11) |  | login count
FileDownload | int(11) |  | total downloaded files
FileUpload | int(11) |  | total uploaded files
FailedDownload | int(11) |  | total download failed files
FailedUpload | int(11) |  | total upload failed files

8) table for group's directory(wftp_mysqltable_dir2)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
Group_Name | varchar (64) | NOT NULL | the group name
DirPath | varchar (255) | NOT NULL | the directory real path
DirAlias | varchar (128) |  | the directory virtual path
Home_Dir | int(11) |  | is home directory?, 1=yes,0=no
File_Read | int(11) |  | enable file read?, 1=yes,0=no
File_Write | int(11) |  | enable file write?, 1=yes,0=no
File_Append | int(11) |  | enable file append?, 1=yes,0=no
File_Delete | int(11) |  | enable file delete?, 1=yes,0=no
Directory_List | int(11) |  | enable directory list?, 1=yes,0=no
Directory_Rename | int(11) |  | enable directory/file rename?, 1=yes,0=no
Directory_Make | int(11) |  | enable directory create?, 1=yes,0=no
Directory_Delete | int(11) |  | enable directory delete?, 1=yes,0=no
File_Rename | int(11) |  | enable file rename?, 1=yes,0=no
Zip_File | int(11) |  | enable zip files?, 1=yes,0=no
Unzip_File | int(11) |  | enable unzip files?, 1=yes,0=no

9) table for group's filemask(wftp_mysqltable_filemask2)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
Group_Name | varchar (64) | NOT NULL | the group name
Filename | varchar (128) | NOT NULL | the file mask
Refuse | int(11) |  | refuse access?, 1=yes,0=no

10) table for group's ipmask(wftp_mysqltable_ipmask2)

Field Name | Type | NULL | Description
--- | --- | --- | ---
Domain | varchar (64) | NOT NULL | the domain name
Group_Name | varchar (64) | NOT NULL | the group name
Ip | varchar (128) | NOT NULL | the ip mask
Refuse | int(11) |  | refuse access?, 1=yes,0=no