CREATE TABLE dbo.userpwr
(
   USERID VARCHAR(3) NULL,
   USERPOWER VARCHAR(4) NULL,
   USERRIGHT VARCHAR(1) NULL
)

GO

CREATE INDEX IDPOWER ON dbo.userpwr(USERID,USERPOWER)

GO

CREATE INDEX USERID ON dbo.userpwr(USERID)

END