Ban/Mute Oto Notice hakkında yardım lütfen..

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XSKIP_BM_USERS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[XSKIP_BM_USERS]

GO



CREATE TABLE [dbo].[XSKIP_BM_USERS] (

	[ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[strUserId] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[Authority] [tinyint] NULL ,

	[UpdateTime] [smalldatetime] NULL 

) ON [PRIMARY]

GO



ALTER TABLE [dbo].[XSKIP_BM_USERS] WITH NOCHECK ADD 

	CONSTRAINT [PK_XSKIP_BM_USERS] PRIMARY KEY  CLUSTERED 

	(

		[ID]

	)  ON [PRIMARY] 

GO

CREATE TRIGGER [dbo].[AUTHORITY_FOR_XSKIP] ON [dbo].[USERDATA]

AFTER UPDATE AS

IF UPDATE(Authority)

BEGIN

/*

Author : AKUMA

Update : 13.02.2010 - 12:24

*/

DECLARE @strUserId char(21)

DECLARE @Authority int



SELECT @strUserId = strUserId,@Authority = Authority FROM INSERTED



IF @Authority = 255

	INSERT INTO XSKIP_BM_USERS VALUES (@strUserId,@Authority,GETDATE())

ELSE IF @Authority = 11	

	INSERT INTO XSKIP_BM_USERS VALUES (@strUserId,@Authority,GETDATE())



END