简析如何使用Serv-U的ODBC功能

CREATE TABLE [groupaccounts] (
[id] int IDENTITY (1,1) PRIMARY KEY,
[Index] int Default 0,
[Name] nVarChar(50) default '',
[Notes] nVarChar(255) default ''
)
CREATE INDEX [Name] on [groupaccounts]([Name] )
CREATE TABLE [groupdiraccess] (
[id] int IDENTITY PRIMARY KEY,
[Access] nVarChar(255) default '',
[Index] int Default 0,
[Name] nVarChar(50) default ''
)
CREATE INDEX [Name] on [groupdiraccess]([Name] )
CREATE TABLE [groupipaccess] (
[id] int IDENTITY PRIMARY KEY,
[Access] nVarChar(255) default '',
[Index] int Default 0,
[Name] nVarChar(50) default ''
)
CREATE INDEX [Name] on [groupipaccess]([Name] )
CREATE TABLE [useraccounts] (
[id] int IDENTITY PRIMARY KEY,
[Access] nVarChar(255) default '',
[AlwaysLogin] int Default 0,
[ChangePass] int Default 0,
[Disable] int Default 0,
[Expirationtype] int Default 0,
[Expiration] datetime Default '1980-1-1',
[Groups] nVarChar(50) default '',
[HideHidden] int Default 0,
[HomeDir] nVarChar(100) default '',
[idleTimeOut] int Default 0,
[LogMesfile] nVarChar(100) default '',
[MaxIp] int Default -1,
[MaxSpeedDown] decimal Default 0,
[MaxSpeedUp] decimal Default 0,
[MaxUsers] int Default -1,
[Name] nVarChar(50) default '',
[Needsecure] int Default 0,
[Notes] nVarChar(255) default '',
[PassType] int Default 0,
[Password] nVarChar(50) default '',
[Privilege] int Default 0,
[QuotaCurrent] decimal Default 0,
[QuotaEnable] int Default 0,
[QuotaMax] decimal Default 0,
[RatioCredit] decimal Default 0,
[RatioDown] int Default 0,
[RatioType] int Default 0,
[RatioUP] int Default 0,
[RelPaths] int Default 0,
[SessionTimeOut] int Default 0,
[SkeyValues] nVarChar(50) default ''
)
CREATE INDEX [Name] on [useraccounts]([Name] )
CREATE TABLE [userdiraccess] (
[id] int IDENTITY PRIMARY KEY,
[Access] nVarChar(255) default '',
[Index] int Default 0,
[Name] nVarChar(50) default ''
)
CREATE INDEX [Name] on [userdiraccess]([Name] )
CREATE TABLE [useripaccess] (
[id] int IDENTITY PRIMARY KEY,
[Access] nVarChar(255) default '',
[Index] int Default 0,
[Name] nVarChar(50) default ''
)
CREATE INDEX [Name] on [useripaccess]([Name]

ODBCSource=openzj.com||
ODBCTables=useraccounts|groupaccounts
|userdiraccess|groupdiraccess|useripaccess|groupipaccess
ODBCColumns=Name|Password|SkeyValues|HomeDir
|LogMesfile|Access|Disable|Needsecure|RelPaths
|HideHidden|AlwaysLogin|ChangePass|QuotaEnable
|MaxIp|MaxSpeedUp|MaxSpeedDown|MaxUsers|idleTimeOut
|SessionTimeOut|RatioUP|RatioDown|RatioCredit
|QuotaCurrent|QuotaMax|Expiration|Privilege|PassType|RatioType|Groups|Notes|Index