--ENTEGRE 7 AKTARIM

ALTER TABLE Kullanicilar add Aktif bit DEFAULT 1 
GO
UPDATE K SET Aktif =1 from Kullanicilar K WHERE NOT EXISTS (Select 1 from KullaniciAyarlari Where KullaniciNo=K.No And Ayar='Kullanıcı Pasif' And Deger='-1')
GO
UPDATE K SET Aktif =0 from Kullanicilar K WHERE NOT EXISTS (Select 1 from KullaniciAyarlari Where KullaniciNo=K.No And Ayar='Kullanıcı Pasif' And Deger='0')
GO
UPDATE Kullanicilar SET Sifre=0
go
ALTER TABLE [dbo].[KullaniciAyarlari] alter column [Deger] [nvarchar](1000) NULL
GO
delete from GridView
go


create   proc sp_AsabitUyari  
with encryption
as

Declare @Byt int
Declare @tt1 int
Declare @tt2 int
Declare @ayy int
Declare @bb1 int
Declare @bb2 int
Declare @sonuc int 

select @ayy=AA.AY,@tt1=T1,@tt2=T2,@Byt=Boyut, @bb1=B1,@bb2=B2 from
(SELECT MAX (AY) - MIN (AY) AY, T1, T2,B1,B2
               FROM (  SELECT (SELECT T1 FROM ASABIT)    T1, 
                             (SELECT T2 FROM ASABIT)     T2, 
 		 (SELECT B1 FROM ASABIT)     B1,
 		 (SELECT B2 FROM ASABIT)     B2,
                            Month (TARIH)                AY,
 		
                             COUNT (*)                   CNT 
                        FROM ACARI 
                    GROUP BY Month (TARIH) 
                      HAVING COUNT (*) > 50) X 
              GROUP BY T1, T2,B1,B2)AA,(SELECT SUM(SizeMB) as Boyut
 			FROM (
 				SELECT DB_NAME(database_id) AS DatabaseName,
     Name AS Logical_Name,
     Physical_Name,
     (size * 8) / 1024  SizeMB
 				FROM sys.master_files
 				WHERE DB_NAME(database_id) = (SELECT DB_NAME() AS [Current Database])
 			)Boyut)BB

if (@bb1=null or @bb1 <100 )
  Set @bb1=100
if (@bb2=null or @bb2 <500 )
  Set @bb2=500

if (@tt1=null or @tt1 <12 )
  Set @tt1=12
if (@tt2=null or @tt2 <100 )
  Set @tt2=100

if (@Byt>@bb2 or @ayy>@tt2)
  Set @sonuc=2
else
if (@Byt>@bb1 or @ayy>@tt1)
  Set @sonuc=1
else
  Set @sonuc=0

select @sonuc as sonuc, @ayy as ay, @Byt as boyut
go--


ALTER TABLE STOKHAR ADD  	
    [Iskonto1] [float] NULL,	
    [Iskonto2] [float] NULL,	
    [Iskonto3] [float] NULL,	
    [Iskonto4] [float] NULL,	
    [SatIskTut1] [float] NOT NULL DEFAULT 0,	
    [SatIskTut2] [float] NOT NULL DEFAULT 0,	
    [SatIskTut3] [float] NOT NULL DEFAULT 0,	
    [SatIskTut4] [float] NOT NULL DEFAULT 0,
	SatIskTut5 [float] NOT NULL DEFAULT 0,
	SatIskTut6 [float] NOT NULL DEFAULT 0,
	SatIskTut7 [float] NOT NULL DEFAULT 0,
	SatIskTut8 [float] NOT NULL DEFAULT 0,
	SatIskTut9 [float] NOT NULL DEFAULT 0,
	SatIskTut10 [float] NOT NULL DEFAULT 0
    [Iskonto5] [float] NOT NULL DEFAULT 0,	
    [Iskonto6] [float] NOT NULL DEFAULT 0,	
    [Iskonto7] [float] NOT NULL DEFAULT 0,	
    [Iskonto8] [float] NOT NULL DEFAULT 0, 	
    [Iskonto9] [float] NOT NULL DEFAULT 0,	
    [Iskonto10] [float] NOT NULL DEFAULT 0;

	GO

		declare @CNTNAME NVARCHAR(100),@SQL NVARCHAR(MAX)
	select @CNTNAME=name from sys.default_constraints where name like 'DF__STOKHAR__sGuid%'
	SET @SQL='ALTER TABLE [dbo].[STOKHAR] DROP CONSTRAINT ['+ CONVERT(VARCHAR(100),@CNTNAME)+']'
	EXEC (@SQL)
	GO
 	ALTER TABLE STOKHAR DROP COLUMN  sGuid	,rGuid
	GO
	
CREATE TABLE [dbo].[AnaMenuAyar](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[EkranX] [int] NULL,
	[EkranY] [int] NULL,
	[FormHeight] [int] NULL,
	[FormWidth] [int] NULL,
	[StartX] [int] NULL,
	[StartY] [int] NULL,
	[Varsayilan] [bit] NULL,
	[AnaMenu] [bit] NULL,
	[Kart] [bit] NULL,
	[Rapor] [bit] NULL,
	[IslemGiris] [bit] NULL,
	[ComputerName] [nvarchar](50) NULL
) ON [PRIMARY]
GO

ALTER TABLE Kullanicilar DROP COLUMN sGuid
go

alter table STOKHAR ADD [DovizKuru] [float] NULL
GO

CREATE TABLE [dbo].[tblTevkifat](
	[Kod] [nvarchar](50) NULL,
	[TevkifatAdi] [nvarchar](200) NULL,
	[NoId] [int] IDENTITY(1,1) NOT NULL,
	[Oran] [float] NULL
) ON [PRIMARY]
GO


truncate table YetkiTanimlari
go
select * from Ent_PROJE.dbo.YetkiTanimlari order by YetkiNo;

SET IDENTITY_INSERT YetkiTanimlari ON;

INSERT INTO YetkiTanimlari (ID, YetkiNo, GrupAdi, YetkiAdi) 
SELECT ID, YetkiNo, GrupAdi, YetkiAdi
FROM Ent_PROJE.dbo.YetkiTanimlari;

SET IDENTITY_INSERT YetkiTanimlari OFF;
go
select * into Anahtar from Ent_PROJE.dbo.Anahtar
go
drop table  Ats
drop table  AtsDetay
drop table  BABS
BARKOD
BHSSTOKLAR
BORDROT
[BSR_AnalizorID]
[BSR_AnalizorHareket01]