--[admin]:
CREATE TABLE [dbo].[admin] (
[ID] integer IDENTITY (1,1) not null,
[UserName] varchar(40) not null ,
[PassWord] varchar(200) not null ,
[LoginNum] integer Default (0) null ,
[Lock] smallint Default (0) null ,
[ModiTime] datetime not null ,
[RoleId] integer Default (0) null
) ON [Primary]
go
Alter TABLE [dbo].[admin] WITH NOCHECK ADD CONSTRAINT [PK_admin] Primary Key Clustered ([ID] ) ON [Primary]
go
CREATE INDEX [GroupID] on [dbo].[admin]([RoleId] ) ON [Primary]
go
CREATE INDEX [ID] on [dbo].[admin]([ID] ) ON [Primary]
go
CREATE INDEX [LoginNum] on [dbo].[admin]([LoginNum] ) ON [Primary]
go
不能用 |