Navigation:  Advanced Features >

Database Schema

Previous pageReturn to chapter overviewNext page

 

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