Script for Creating Necessary ODBC Tables

The following SQL script creates the tables necessary to run on EFT Server:

if exists (select * from sysobjects where id = object_id(N'[dbo].[ftpserver_ids]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[ftpserver_ids]

GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[ftpserver_users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[ftpserver_users]

GO

CREATE TABLE [dbo].[ftpserver_ids] (

            [User_ID] [int] NULL ,

            [Group_ID] [int] NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[ftpserver_users] (

            [ID] [int] IDENTITY (1, 1) NOT NULL ,

[name] [varchar] (50) NULL ,

            [password] [varchar] (200) NULL ,

            [description] [varchar] (200) NULL ,

            [type] [int] NULL ,

            [password_type] [int] NULL ,

            [md_iter] [int] NULL ,

            [otp_seed] [varchar] (16) NULL ,

            [anonymous] [int] NULL ,

            [anonymous_email] [int] NULL ,

            [FullName] [varchar] (200) NULL ,

            [Email] [varchar] (200) NULL ,

            [Phone] [varchar] (200) NULL ,

            [Pager] [varchar] (200) NULL ,

            [Fax] [varchar] (200) NULL ,

            [Comments] [varchar] (200) NULL ,

            [Enabled] [int] NULL ,

            [HomeDirectory] [varchar] (512) NULL ,

            [SettingsLevel] [varchar] (200) NULL

) ON [PRIMARY]

GO

 

Notice that the last variable is [Settings Level] (with an "s") contrary to EFT Administrator, in which it is labeled "User Setting Level" (no "s").