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"). |