Creating Tables for your ODBC Data Source

You must create two tables in the database for your data source. A SQL script is provided that will create the necessary tables.

The ftpserver_users table lists the user accounts and permissions groups in the Site. A user account uses the information from all fields. A permission group uses only the ID, Name, and Description fields and is used only for organizational purposes, not as a user login.

Field Name

Data Type

Field Size

Description

ID (Primary Key)

AutoNumber

Long Integer

User ID

Name

Text

50

Login name for this user

Password

Text

200

Password for this user

Description

Text

200

Description for this user

Type

Number

Integer

0=Group, 1=User

Password_Type

Number

Integer

Standard, OTP_MD4, OTP_MD5: Differentiates Regular vs. SKEY (OTP (One-Time Password; intended to make it more difficult to gain unauthorized access. By constantly altering the password, as is done with a one-time password, this risk can be greatly reduced)) password type. 0 = standard FTP password, 1=MD4 OTP, 2=MD5 OTP.

MD_Iter

Number

Long Integer

Current MDX iteration - used by OTP accounts only

OTP_Seed

Text

16

OTP Seed to be used for MDX Passwords - used by OTP accounts only.

Anonymous

Number

Long Integer

0=Normal Password, 1=Any password

Anonymous_Email

Number

Long Integer

0=Any anonymous password, 1=e-mail password required

Fullname

Text

200

User's full name

Email

Text

200

User's e-mail address

Phone

Text

200

User's phone number

Pager

Text

200

User's pager number

Fax

Text

200

User's fax number

Comments

Text

200

User comments

Enabled

Number

Integer

0=Account disabled, 1=Account enabled

HomeDirectory

Text

512

Legacy field no longer used, but must be present in the database.

SettingsLevel

Text

200

Name of user's User Setting Level.

The ftpserver_ids organizes users into "groups" of permission levels. For each permission Group to which a user belongs there should be one entry in the table below.

Field Name

Data Type

Field Size

Description

ID

AutoNumber

Long Integer

Unique ID for the record (key field).

User_ID

Number

Long Integer

This value refers to a user record in the ftpserver_users table. A corresponding (where ftpserver_ids.User_ID = ftpserver_users.ID) ftpserver_users record must exist with Type = 1.

Group_ID

Number

Long Integer

This value refers to the User Setting Level that the User_ID user record belongs to. A corresponding (where ftpserver_ids.Group_ID == ftpserver_users.ID) ftpserver_users record must exist with Type = 0.