下面是以Serv-U 6.0和Sql Server 2000相结合的演示。
建表Sql 语句:
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,
【asp session】ASP+MS SQL在线修改Serv-u的密码教程
http://m.bbyears.com/wangluoxinxianshi/2595.html
推荐访问:asps