SET IDENTITY_INSERT usvspaket ON;
INSERT INTO usvspaket (paketIdentifier,subclass,Gizlilik,IslemZamani,KullaniciKodu,HastaId,Kurum) 
VALUES (1,'YatanHasta',1,'2008-19-12 08:00:00',KullaniciKodu,HastaId,'Kurum');
SET IDENTITY_INSERT usvspaket OFF;

SET IDENTITY_INSERT vatandasyabancikayit ON;
INSERT INTO vatandasyabancikayit (VatandasYabanciKayitId,HastaKimlikNo,Ad,Soyad,ResmiCinsiyet,
ResmiDogumTarihi,Uyruk) 
VALUES (1,HastaKimlikNo,'Ad','Soyad',1,'1980-19-01 10:00:00','TR');
SET IDENTITY_INSERT vatandasyabancikayit OFF;

SET IDENTITY_INSERT YatanHasta on;
INSERT INTO YatanHasta (YatanHastaId,OlayYeri,MuayeneYapilanPoliklinik) 
VALUES (1,1,'48');
SET IDENTITY_INSERT YatanHasta Off;

SET IDENTITY_INSERT MudahaleBilgisi on;
INSERT INTO MudahaleBilgisi (MudahaleBilgisiId,MudahaleKodu,YatanHastaId,
IndexId) 
VALUES (1,'530080',1,1);
SET IDENTITY_INSERT MudahaleBilgisi Off;

SET IDENTITY_INSERT DisEtkenBilgisi on;
INSERT INTO DisEtkenBilgisi (DisEtkenBilgisiId,DisEtken,YatanHastaId,
IndexId) 
VALUES (1,'O82.1',1,1);
SET IDENTITY_INSERT DisEtkenBilgisi Off;

SET IDENTITY_INSERT KullanilanTibbiMalzemeBilgisi on;
INSERT INTO KullanilanTibbiMalzemeBilgisi (KullanilanTibbiMalzemeBilgisiId,KullanilanTibbiMalzeme,
YatanHastaId,IndexId) 
VALUES (1,'212000',1,1);
SET IDENTITY_INSERT KullanilanTibbiMalzemeBilgisi Off;

SET IDENTITY_INSERT YatanHastaKabul on;
INSERT INTO YatanHastaKabul(YatanHastaKabulId,AnaTani,OdemeSekli,GeldigiPoliklinik,
KabulZamani,YatisTalebindeBulunanHekim,YatisinAciliyeti,ProtokolNo,VakaTuru,SgkTakipNumarasi) 
VALUES (1,'S62.5',3,'48','2008-12-11 08:00:00',32110375754,9,'200942',1,'6DRCJA');
SET IDENTITY_INSERT YatanHastaKabul Off;

SET IDENTITY_INSERT YatanHastaCikis on;
INSERT INTO YatanHastaCikis(YatanHastaCikisId,CikisSekli,CikisZamani,IzinSuresi,
TaburcuEdenHekim,AnaTani) 
VALUES (1,2,'2008-12-11 16:00:00',1,32110375754,'S62.5');
SET IDENTITY_INSERT YatanHastaCikis Off;

INSERT INTO PaketYatanHasta (paketIdentifier,YatanHastaKabul,
YatanHasta,YatanHastaCikis) VALUES (1,1,1,1);

SET IDENTITY_INSERT hastakayit ON;
INSERT INTO hastakayit (HastaKayitId,VatandasYabanciKayitId,VatansizKayitId,YenidoganKayitId) 
VALUES (1,1,NULL,NULL);
SET IDENTITY_INSERT hastakayit OFF;

SET IDENTITY_INSERT paketcontainer ON;
INSERT INTO paketcontainer (paketContainerId,uuid,paketIdentifier,GonderenBilgileriId,HastaKayitId) 
VALUES (1,'e627bd79-7a3a-4361-a85e-c25626ef3130',1,2,1);
SET IDENTITY_INSERT paketcontainer OFF;

SET IDENTITY_INSERT Islem ON;
INSERT INTO Islem (IslemId,IslemTuru,silmeBilgisiId,paketContainerId,degistirilecekMesajUuid) 
VALUES (1,'Yenikayit',NULL,1,NULL);
SET IDENTITY_INSERT Islem OFF;