|
Database Schema |
  
|
|
Database Schema |
|
Note: There is no need 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) |
|
EnableSSHPubKeyAuth |
int |
enable ssh public key authentication, 1=yes,0=no |
|
SSHAuthMethod |
int |
ssh authentication method, 1=use both public key and password authentication,0=only use public key authentication |
|
EnableWeblink |
int |
enable web download link, 1=yes,0=no |
|
EnableUplink |
int |
enable web request (upload) link, 1=yes,0=no |
|
EnableTwoFactor |
int |
enable two-factor authentication (TOTP) for Web Client, 1=yes,0=no |
|
TwoFactorCode |
varchar (32) |
TOTP secret code |
|
ExtraInfo |
varchar (255) |
extra information for user account |
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 |
ID |
bigint(20) |
NOT NULL |
PRIMARY KEY, AUTO_INCREMENT |
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) |
|
EnableSSHPubKeyAuth |
int(11) |
enable ssh public key authentication, 1=yes,0=no |
|
SSHAuthMethod |
int(11) |
ssh authentication method, 1=use both public key and password authentication,0=only use public key authentication |
|
EnableWeblink |
int(11) |
enable web download link, 1=yes,0=no |
|
EnableUplink |
int(11) |
enable web request (upload) link, 1=yes,0=no |
|
EnableTwoFactor |
int(11) |
enable two-factor authentication (TOTP) for Web Client, 1=yes,0=no |
|
TwoFactorCode |
varchar (32) |
TOTP secret code |
|
ExtraInfo |
varchar (255) |
extra information for user account |
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 |
|
ID |
bigint(20) |
NOT NULL |
PRIMARY KEY, AUTO_INCREMENT |
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 |
|
ID |
bigint(20) |
NOT NULL |
PRIMARY KEY, AUTO_INCREMENT |
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 |
|
ID |
bigint(20) |
NOT NULL |
PRIMARY KEY, AUTO_INCREMENT |
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 |
|
ID |
bigint(20) |
NOT NULL |
PRIMARY KEY, AUTO_INCREMENT |
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 |
|
ID |
bigint(20) |
NOT NULL |
PRIMARY KEY, AUTO_INCREMENT |
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 |
|
ID |
bigint(20) |
NOT NULL |
PRIMARY KEY, AUTO_INCREMENT |
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 |
|
ID |
bigint(20) |
NOT NULL |
PRIMARY KEY, AUTO_INCREMENT |