IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[DBO].[TFIYATANLASMAONAYLARI]') AND type IN (N'U'))
BEGIN
CREATE TABLE .[DBO].[TFIYATANLASMAONAYLARI](
	[ID] [INT] IDENTITY(1,1) NOT NULL,
	[ACIKLAMA] [NVARCHAR](50) NULL,
	
 CONSTRAINT [PK_TFIYATANLASMAONAYLARI] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_TFIYATANLASMAONAYLARI] UNIQUE NONCLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO

IF NOT EXISTS(SELECT TOP 1 ID FROM TFIYATANLASMAONAYLARI)
BEGIN
    SET IDENTITY_INSERT TFIYATANLASMAONAYLARI ON

	INSERT INTO TFIYATANLASMAONAYLARI(ID,ACIKLAMA) VALUES('1','Yeni')
	INSERT INTO TFIYATANLASMAONAYLARI(ID,ACIKLAMA) VALUES('2','Onaylama İsteği')
	INSERT INTO TFIYATANLASMAONAYLARI(ID,ACIKLAMA) VALUES('3','Yetkili Onayladı')

    SET IDENTITY_INSERT TFIYATANLASMAONAYLARI OFF
END


