Insertion.sql

USE KargoDb

INSERT INTO tblUrunKategorisi
(Kategori_Tipi,Desi_Fiyat,Kg_Fiyat)
VALUES
('SIVI',2,15),
('KIRILACAK',3,20),
('TEHLİKELİ',4,30),
('STANDART',1,10)

GO

INSERT INTO tblMusteri
(Ad,Soyad,Mail,Dogum_Tarihi,Cinsiyet,Telno,TC)
VALUES
('Onur','Çelik','ourcelik@icloud.com','1999-05-10','Erkek','5428547892','63054879258'),
('Mehmet','Ağar','mehmetderin@hotmail.com','1992-01-12','Erkek','5423785491','32694852818'),
('Abdurrahman','çeliktan','abdurrahmançeliktan@outlook.com','1975-02-14','Erkek','5435546787','90204939534'),
('Fatma','Bilican','fatmabilican@gmail.com','1954-05-10','Kadın','5096120363','85572519754'),
('Dursun','Çelik','dursunreis@hotmail.com','1975-05-02','Erkek','6680056744','83943719420'),
('Mehtap','Çelik','mehtap123@gmail.com','1998-02-20','Kadın','9068734510','81443012294'),
('Zeynep','Suverdi','zeynepverdi@gmail.com','1989-01-30','Kadın','7609200390','35741096432'),
('Aleyna','Kuyu','aleyna53@hotmail.com','1975-02-18','Kadın','6819370490','88198104144'),
('Emre','Kandemir','emrebaba@icloud.com','1999-08-22','Erkek','6167206243','11407355556'),
('İnci','Fil','incin@gmail.com','1991-04-25','Kadın','2591211523','52882008384'),
('Livanur','Ketenci','ketenciliva@gmail.com','1979-10-12','Kadın','4468660502','58526896874'),
('Mustafa','Topaloğlu','mustafatopal@gmail.com','1965-05-13','Erkek','9119760550','85720543532'),
('Rümeysa','Akgün','rümeysaakgün@yahoo.com','1978-05-15','Kadın','8165510944','76392560682'),
('Ayşe','Güven','ayşegüv@gmail.com','1980-11-18','Kadın','1317468747','53419294546'),
('Yakup','Çolak','yakup34q@gmail.com','1959-12-22','Erkek','5751807855','91694838918'),
('Filiz','Yandaş','filizyan@gmail.com','2002-03-24','Kadın','2054158699','98578405242'),
('Sertap','Kuyu','sertaphanım61@gmail.com','2003-04-12','Kadın','2264244802','50642018680'),
('Recep','Alkan','çalışkanrecep@gmail.com','1985-09-05','Erkek','8270868135','84029591862'),
('Gamze','Şahin','gamze35@gmail.com','1986-12-03','Kadın','2217608876','55368226210'),
('Dilara','Ofluoğlu','dilara01oflu@icloud.com','1994-06-05','Kadın','5691514067','48726296116'),
('Mustafa','Şişli','şişlimusti@gmail.com','1991-07-11','Erkek','4664552167','58209438100'),
('Salih','Aydın','salih_aydin@hotmail.com','1966-08-12','Erkek','5368569541','25636985426'),
('Merve','Bulut','mervebulut@gmail.com','1975-09-28','Kadın','5319658596','11468595786'),
('Burak','Turgut','brtTurgut@hotmail.com','1978-01-29','Erkek','5362368565','25563285963'),
('Ahmet','Gölcük','ahmet@hotmail.com','2000-10-21','Erkek','5422591199','11596585740'),
('Caner','Ak','cnrAk@hotmail.com','2001-09-10','Erkek','5422658533','11635485632'),
('Sefa','Zor','jail_brakma@hotmail.com','1999-08-23','Erkek','5329622536','11536585920'),
('Deniz','Güzelgül','güzelgüldüm@hotmail.com','1985-07-10','Kadın','5325634488','22563285632'),
('Emre','Aşık','emre_e2000@hotmail.com','2000-03-21','Erkek','5455789002','46483330100'),
('Halim','Aral','halimaral@outlook.com','1987-06-10','Erkek','5411238752','12482177450'),
('Şeyda Nur','Arikan','seydanurarikan@gmail.com','1994-05-03','Kadın','5455781775','24178498578'),
('Çisem','Atok','cisematok@icloud.com','1993-04-11','Kadın','5455782177','48578764325'),
('Edip','Attila','edipattila@gmail.com','1995-03-10','Erkek','5453786747','36574124785'),
('Murat Kaan','Ayanoglu','mkaanayanoglu@gmail.com','1997-02-07','Erkek','5483781725','67841277546'),
('Gökay','Bağış','gokaybagis@gmail.com','1973-01-24','Erkek','5462786745','74512554783'),
('Özgün','Bahtıyar','ozgunbahtiyar@gmail.com','1997-12-29','Erkek','5413286727','65723412843'),
('Seung Hun','Baki','seunghunbaki@hotmail.com','1999-11-23','Erkek','5383788747','47887451491'),
('Kazım','Balta','kazimbalta@icloud.com','2000-10-27','Erkek','5383758742','22487412648'),
('Ayla','Baytın','aylabaytin@icloud.com','1987-09-21','Kadın','5363738747','21476332542'),
('Didem','Bıçaksız','ddmbicaksiz@hotmail.com','1987-08-18','Kadın','5353788743','36715948512'),
('Kübra Tansu','Bilgit','kübrat@icloud.com','1982-07-13','Kadın','5373748749','67321942556'),
('Uluç Emre','Binbay','uemrebinay@icloud.com','2002-06-24','Erkek','5323768747','55684714963'),
('Yücel','Civan','ycivan@icloud.com','2001-05-31','Erkek','5313784747', '44132278457'),
('Hülya','Delice','hulyadelice@hotmail.com','2000-04-08','Kadın','5333755747','33284575145'),
('Ziya','Doğramacı','ziyadogramaci@hotmail.com','1989-03-14','Erkek','5383768746','87455632741'),
('Ayşe Elif','Görür','gorurayseelif@hotmail.com','1990-02-23','Kadın','5384786747','32348353671'),
('Köksal','Gültaş','koksalgultas@hotmail.com','1978-01-12','Erkek','5343481747','54794172649')

GO

INSERT INTO tblUlke (Ulke)
VALUES
('Türkiye'),
('Abhazya'),
('Afganistan'),
('Almanya'),
('Amerika Birleşik Devletleri'),
('Andorra'),
('Angola'),
('Antigua ve Barbuda'),
('Arjantin'),
('Arnavutluk'),
('Avustralya'),
('Avusturya'),
('Azerbaycan'),
('Bahamalar'),
('Bahreyn'),
('Bangladeş'),
('Barbados'),
('Batı Sahra'),
('Belarus'),
('Belçika'),
('Belize'),
('Benin'),
('Bhutan'),
('Birleşik Arap Emirlikleri'),
('Bolivya'),
('Bosna Hersek'),
('Botsvana'),
('Brezilya'),
('Brunei'),
('Bulgaristan'),
('Burkina Faso'),
('Burundi'),
('Cezayir'),
('Cibuti Cumhuriyeti'),
('Çad'),
('Çek Cumhuriyeti'),
('Çin Halk Cumhuriyeti'),
('Dağlık Karabağ Cumhuriyeti'),
('Danimarka'),
('Doğu Timor'),
('Dominik Cumhuriyeti'),
('Dominika'),
('Ekvador'),
('Ekvator Ginesi'),
('El Salvador'),
('Endonezya'),
('Eritre'),
('Ermenistan'),
('Estonya'),
('Etiyopya'),
('Fas'),
('Fiji'),
('Fildişi Sahilleri'),
('Filipinler'),
('Filistin'),
('Finlandiya'),
('Fransa'),
('Gabon'),
('Gambiya')

GO
INSERT INTO tblSehir (UlkeId,Sehir)
VALUES
('1','Adana'),
('1','Adıyaman'),
('1','Afyon'),
('1','Ağrı'),
('1','Amasya'),
('1','Ankara'),
('1','Antalya'),
('1','Artvin'),
('1','Aydın'),
('1','Balıkesir'),
('1','Bilecik'),
('1','Bingöl'),
('1','Bitlis'),
('1','Bolu'),
('1','Burdur'),
('1','Bursa'),
('1','Çanakkale'),
('1','Çankırı'),
('1','Çorum'),
('1','Denizli'),
('1','Diyarbakır'),
('1','Edirne'),
('1','Elazığ'),
('1','Erzincan'),
('1','Erzurum'),
('1','Eskişehir'),
('1','Gaziantep'),
('1','Giresun'),
('1','Gümüşhane'),
('1','Hakkari'),
('1','Hatay'),
('1','Isparta'),
('1','Mersin'),
('1','İstanbul'),
('1','İzmir'),
('1','Kars'),
('1','Kastamonu'),
('1','Kayseri'),
('1','Kırklareli'),
('1','Kırşehir'),
('1','Kocaeli'),
('1','Konya'),
('1','Kütahya'),
('1','Malatya'),
('1','Manisa'),
('1','K.Maraş'),
('1','Mardin'),
('1','Muğla'),
('1','Muş'),
('1','Nevşehir'),
('1','Niğde'),
('1','Ordu'),
('1','Rize'),
('1','Sakarya'),
('1','Samsun'),
('1','Siirt'),
('1','Sinop'),
('1','Sivas'),
('1','Tekirdağ'),
('1','Tokat'),
('1','Trabzon'),
('1','Tunceli'),
('1','Şanlıurfa'),
('1','Uşak'),
('1','Van'),
('1','Yozgat'),
('1','Zonguldak'),
('1','Aksaray'),
('1','Bayburt'),
('1','Karaman'),
('1','Kırıkkale'),
('1','Batman'),
('1','Şırnak'),
('1','Bartın'),
('1','Ardahan'),
('1','Iğdır'),
('1','Yalova'),
('1','Karabük'),
('1','Kilis'),
('1','Osmaniye'),
('1','Düzce')

GO

Insert Into tblIlce(Ilce,SehirId)
Values
('ALADAĞ', 1),
('CEYHAN', 1),
('ÇUKUROVA', 1),
('FEKE', 1),
('İMAMOĞLU', 1),
('KARAİSALI', 1),
('KARATAŞ', 1),
('KOZAN', 1),
('POZANTI', 1),
('SAİMBEYLİ', 1),
('SARIÇAM', 1),
('SEYHAN', 1),
('TUFANBEYLİ', 1),
('YUMURTALIK', 1),
('YÜREĞİR', 1),
('BÜYÜK ORHAN', 16),
('GEMLİK', 16),
('GÜRSU', 16),
('HARMANCIK', 16),
('İNEGÖL', 16),
('İZNİK', 16),
('KARACABEY', 16),
('KELES', 16),
('KESTEL', 16),
('MUDANYA', 16),
('MUSTAFA K. PAŞA', 16),
('NİLÜFER', 16),
('ORHANELİ', 16),
('ORHANGAZİ', 16),
('OSMANGAZİ', 16),
('YENİŞEHİR', 16),
('YILDIRIM', 16),
('ADALAR', 34),
('ARNAVUTKÖY', 34),
('ATAŞEHİR', 34),
('AVCILAR', 34),
('BAĞCILAR', 34),
('BAHÇELİEVLER', 34),
('BAKIRKÖY', 34),
('BAŞAKŞEHİR', 34),
('BAYRAMPAŞA', 34),
('BEŞİKTAŞ', 34),
('BEYKOZ', 34),
('BEYLİKDÜZÜ', 34),
('BEYOĞLU', 34),
('BÜYÜKÇEKMECE', 34),
('ÇATALCA', 34),
('ÇEKMEKÖY', 34),
('ESENLER', 34),
('ESENYURT', 34),
('EYÜPSULTAN', 34),
('FATİH', 34),
('GAZİOSMANPAŞA', 34),
('GÜNGÖREN', 34),
('KADIKÖY', 34),
('KAĞITHANE', 34),
('KARTAL', 34),
('KÜÇÜKÇEKMECE', 34),
('MALTEPE', 34),
('PENDİK', 34),
('SANCAKTEPE', 34),
('SARIYER', 34),
('SİLİVRİ', 34),
('SULTANBEYLİ', 34),
('SULTANGAZİ', 34),
('ŞİLE', 34),
('ŞİŞLİ', 34),
('TUZLA', 34),
('ÜMRANİYE', 34),
('ÜSKÜDAR', 34),
('ZEYTİNBURNU', 34),
('ALİAĞA', 35),
('BALÇOVA', 35),
('BAYINDIR', 35),
('BAYRAKLI', 35),
('BERGAMA', 35),
('BEYDAĞ', 35),
('BORNOVA', 35),
('BUCA', 35),
('ÇEŞME', 35),
('ÇİĞLİ', 35),
('DİKİLİ', 35),
('FOÇA', 35),
('GAZİEMİR', 35),
('GÜZELBAHÇE', 35),
('KARABAĞLAR', 35),
('KARABURUN', 35),
('KARŞIYAKA', 35),
('KEMALPAŞA', 35),
('KINIK', 35),
('KİRAZ', 35),
('KONAK', 35),
('MENDERES', 35),
('MENEMEN', 35),
('NARLIDERE', 35),
('ÖDEMİŞ', 35),
('SEFERİHİSAR', 35),
('SELÇUK', 35),
('TİRE', 35),
('TORBALI', 35),
('URLA', 35),
('ARDEŞEN', 53),
('ÇAMLIHEMŞİN', 53),
('ÇAYELİ', 53),
('DEREPAZARI', 53),
('FINDIKLI', 53),
('GÜNEYSU', 53),
('HEMŞİN', 53),
('İKİZDERE', 53),
('İYİDERE', 53),
('KALKANDERE', 53),
('PAZAR', 53),
('BAĞLAR', 21),
('BİSMİL', 21),
('ÇERMİK', 21),
('ÇINAR', 21),
('ÇÜNGÜŞ', 21),
('DİCLE', 21),
('EĞİL', 21),
('ERGANİ', 21),
('HANİ', 21),
('HAZRO', 21),
('KAYAPINAR', 21),
('KOCAKÖY', 21),
('KULP', 21),
('LİCE', 21),
('SİLVAN', 21),
('SUR', 21),
('YENİŞEHİR', 21)

GO

INSERT INTO tblMahalle
(Mahalle,IlceId)
VALUES
('NARLI',17),
('BÜYÜKKUMLA',17),
('KÜÇÜKKUMLA',17),
('UĞURBEY',17),
('ALEMDAR',30),
('KANALBOYU',30),
('ÇUKURCA',30),
('SOĞANLI',30),
('ÇİRİŞHANE',30),
('SETBAŞI',30),
('SIRAMEŞELER',30),
('AKÇAPINAR',31),
('AKBIYIK',31),
('AYAZ',31),
('AFŞAR',31),
('AKDERE',31),
('EBEKÖY',31),
('MİLLET',32),
('VATAN',32),
('ERİKLİ',32),
('ARABAYATAĞI',32),
('BEYAZIT',32),
('GÜNGÖREN',48),
('TAŞDELEN',48),
('EKŞİ',48),
('SEYRANTEPE',48),
('ACIBADEM',55),
('CADDEBOSTAN',55),
('FİKİRTEPE',55),
('GÖZTEPE',55),
('GÖZTEPE',55),
('MERKEZ',62),
('ZÜMRÜTEVLER',62),
('MADEN',62),
('AYAZAĞ',62),
('ÇAMLITEPE',62),
('BÜYÜKDERE',62),
('BALTALİMANI',62),
('GARİPÇE',62),
('İSTİNYE',62),
('KAZIMKARABEKİRPAŞA',62),
('KOCATAŞ',62),
('POLİGON',62),
('TARABYA',62),
('YENİKÖY',62),
('NAMIKKEMAL',69),
('ALTINŞEHİR',69),
('ATAKENT',69),
('PARSELLER',69),
('ÇAKMAK',69),
('HUZUR',69),
('İNKILAB',69),
('İSTİKLAL',69),
('SİTE',69),
('ESENKENT',69),
('ÇENGELKÖY',70),
('KISIKLI',70),
('İCADİYE',70),
('FISTIKAĞACI',70),
('KUZGUNCUK',70),
('ÇAVUŞDERE',70),
('SELAMSIZ',70),
('BAĞLARBAŞI',70),
('BARBAROS',70),
('BULGURLU',70),
('BEYLERBEYİ',70),
('KANDİLLİ',70),
('ATATÜRK',83),
('CUMHURİYET',83),
('FATİH',83),
('FEVZİÇAKMAK',83),
('İSMETPAŞA',83),
('KEMALATATÜRK',83),
('KOZBEYLİ',83),
('EGEMENLİK',78),
('KARACAOĞLAN',78),
('KAVAKLIDERE',78),
('KIZILAY',78),
('ÇAYCILAR',104),
('DEMİRCİLER',104),
('ESKİPAZAR',104),
('LİMANKÖY',104),
('SABUNCULAR',104),
('SOĞUKSU',104),
('ARKADERE',104),
('ALTINTAŞ',104),
('ÇATAKLIHOCA',104),
('KÜÇÜKCAMİ',107),
('MERKEZ',107),
('AŞŞAĞIKİREMİT',107),
('BAŞARAN',107),
('BİRLİK',107),
('ÜNALAN',111),
('ÇAĞLAYAN',111),
('AKSU',111),
('CEVİZLİK',111),
('DAĞDİBİ',111),
('KURUKÖY',111),
('ADALAR',111),
('MEDRESE',111),
('KIZILTOPRAK',111),
('FIRAT',123),
('HUZUREVLERİ',123),
('MEZOPOTAMYA',123),
('ÇÖLGÜZELİ',123),
('CUMHURİYET',123),
('DİCLEKENT',123),
('ŞEHİTLİK',129),
('GÜVERCİNLİK',129),
('SANCAR',129),
('YOLALTI',129),
('ÜÇKUYU',129)


GO	

INSERT INTO tblAdres
(UlkeId,SehirId,IlceId,MahalleId,MusteriId,Postakodu,Acik_adres)
VALUES 
(1,34,48,25,1,'34215','Çiçek Sokak No:12 Daire:3'),
(1,34,48,23,2,'34212','Çakaloğlu  Sokak No:10 Daire:5'),
(1,34,48,24,3,'34211','Yunus Emre Sokak No:4 Daire:7'),
(1,34,48,25,4,'34218','Cengiz Topel Sokak No:8 Daire:5'),
(1,34,48,25,5,'34219','Yaka  Sokak No:9 Daire:3'),
(1,34,48,26,6,'34217','Kara Mahmut Çeşme Sokak No:5 Daire:5'),
(1,34,48,23,7,'34225','Kerimoğlu Sokak No:3 Daire:3'),
(1,34,55,27,8,'34218','Kekeçoğlu Sokak No:8 Daire:3'),
(1,34,55,27,9,'34265','Okul Sokak No:14 Daire:5'),
(1,34,55,28,10,'34214','Bandak Sokak No:3 Daire:9'),
(1,34,55,29,11,'34200','Kurtuluş Sokak No:7 Daire:12'),
(1,34,55,27,12,'34296','Mustafa Okumuş Sokak No:7 Daire:13'),
(1,34,55,29,13,'34274','Fevzi Paşa Sokak No:5 Daire:1'),
(1,34,62,32,14,'34232','Kavaklı Dere Sokak No:28 Daire:4'),
(1,34,62,35,15,'34245','Çınaraltı Sokak No:32 Daire:9'),
(1,34,62,36,16,'34294','Gündüzgözü Sokak No:1 Daire:2'),
(1,34,70,58,17,'34145','Ayça Sokak No:12 Daire:3'),
(1,34,70,59,18,'34324','Cevizli Sokak No:3 Daire:6'),
(1,34,70,60,19,'34974','Aşkaroğlu Sokak No:2 Daire:8'),
(1,34,70,61,20,'34541','İntepe Sokak No:6 Daire:9'),
(1,53,104,79,21,'53541','Bayır Sokak No:9 Daire:2'),
(1,53,111,100,22,'53541','Bayır Sokak No:4 Daire:3'),
(1,53,111,94,23,'53541','Kemeraltı Sokak No:2 Daire:1'),
(1,53,111,93,24,'53541','Harman Sokak No:1 Daire:4')

GO

INSERT INTO tblAdres
(UlkeId,SehirId,IlceId,MahalleId,MusteriId,Postakodu,Acik_adres)
VALUES 
(1,21,123,102,25,'21541','Uluçam Sokak No:3 Daire:1'),
(1,21,123,105,26,'21541','Beştepe Sokak No:11 Daire:3'),
(1,21,123,107,27,'21521','Boğazköy Sokak No:18 Daire:3'),
(1,21,129,108,28,'21511','Yonca Sokak No:4 Daire:4'),
(1,21,129,109,29,'21501','Vahid Sokak No:7 Daire:5'),
(1,21,129,111,30,'21501','Kozluk Sokak No:15 Daire:8'),
(1,16,17,1,31,'16315','Alpsoy Sokak No:6 Daire:9'),
(1,16,17,2,32,'16248','Meşelik Sokak No:12 Daire:10'),
(1,16,30,5,33,'16241','Koru Sokak No:12'),
(1,16,30,6,34,'16015','Lüle Sokak No:36 Daire:12'),
(1,16,31,12,35,'16054','Gelibolu Sokak No:9 Daire:12'),
(1,16,32,18,36,'16084','Talip Sokak No:17 Daire:18'),
(1,16,32,21,37,'16300','Fatih Sokak No:23 Daire:21'),
(1,35,78,75,38,'35155','Nakibey Sokak No:21 Daire:24'),
(1,35,78,75,39,'35155','Ceylan Sokak No:13 Daire:23'),
(1,35,78,76,40,'35100','Altınordu Sokak No:19 Daire:18'),
(1,35,78,77,41,'35197','İnci Sokak No:24 Daire:19'),
(1,35,83,68,42,'35941','Çınarlı Sokak No:22 Daire:11'),
(1,35,83,68,43,'35789','Harem Sokak No:20 Daire:10'),
(1,35,83,70,44,'35147','Karanfil Sokak No:7 Daire:8'),
(1,35,83,71,45,'35762','Rıhtım Sokak No:1 Daire:5'),
(1,35,78,72,46,'35142','Fesleğen Sokak No:28 Daire:1'),
(1,35,78,73,47,'35168','Ergen Sokak No:36 Daire:17')

GO

INSERT INTO tblAdres
(UlkeId,SehirId,IlceId,MahalleId,Postakodu,Acik_adres)
VALUES 
(1,35,78,75,'35155','Sümbül Sokak No:10 Daire:10'),
(1,35,83,71,'35762','7207.Sokak No:9 Daire:1'),
(1,16,30,5,'16241','Şatafatlı Sokak No:2 Daire:25'),
(1,16,32,18,'16084','Güngören Sokak No:7 Daire:9'),
(1,21,129,109,'21501','Anadolu Sokak No:12 Daire:3'),
(1,21,123,102,'21541','Güler Sokak No:23 Daire:15'),
(1,21,123,107,'21521','Çıkmaz Sokak No:7 Daire:6'),
(1,21,129,111,'21501','Papatya Sokak No:3 Daire:14'),
(1,53,111,100,'53541','Menekşe Sokak No:12 Daire:6'),
(1,34,55,27,'34296','Kartal Sokak No:8 Daire:1'),
(1,34,55,28,'34214','Aslan Sokak No:7 Daire:4'),
(1,34,48,25,'34219','Güleryüz Sokak No:4 Daire:3'),
(1,53,111,94,'53541','Kadife Sokak No:6 Daire:36'),
(1,34,48,25,'34218','Şanzelize Sokak No:4 Daire:22'),
(1,34,48,25,'34215','Palmiye Sokak No:8 Daire:12')

GO
INSERT INTO tblSube
(Sube_Kodu,Telno,AdresId)
VALUES
('35787501','8509152971',48),
('35837101','8509152972',49),
('16300501','8509152973',50),
('16321801','8509152974',51),
('2112910901','8509152975',52),
('2112310201','8509152976',53),
('2112310701','8509152977',54),
('2112911101','8509152978',55),
('5311110001','8509152979',56),
('34552701','8509152980',57),
('34552801','8509152981',58),
('34482501','8509152982',59),
('531119401','8509152983',60),
('34482502','8509152984',61),
('34482503','8509152985',62)

INSERT INTO tblCalisan
(Ad,Soyad,Cinsiyet,Dogum_Tarihi,Mail,TC,Telno,SubeId)
VALUES
('Sezen','İlerigiden','Kadın','1975-05-10','Sezenİlerigiden12@gmail.com','63014284732','5423315433',1),
('Fatma','Özlem','Kadın','1982-02-18','FatmaÖzlem45@yahoo.com','63014873653','5423982077',1),
('Özde','Acarkan','Kadın','1990-09-21','ÖzdeAcarkan76@outlook.com','73014217022','5433214589',1),
('Atahan','Adanır','Erkek','1992-08-19','AtahanAdanır32@yahoo.com','73014490708','5443343146',2),
('Mehmet','Adıgüzel','Erkek','1975-10-12','MehmetAdıgüzel12@outlook.com','73014664696','5433572007',2),
('Mükerrem','Ağca','Erkek','1974-10-29','MükerremAğca32@yahoo.com','73014669130','5423683855',2),
('Fazıl ','Ağırağaç','Erkek','1972-11-22','FazılAğırağaç11@gmail.com','62914323837','5443802730',3),
('Orhun','Ağıroğlu','Erkek','1985-12-21','OrhunAğıroğlu@yahoo.com','63414972398','5423188626',3),
('Şennur','Ağnar','Kadın','1979-09-13','ŞennurAğnar@gmail.com','75014759786','5423908789',3),
('Ceylan','Balcı','Kadın','1991-01-25','CeylanBalcı43@gmail.com','78014186708','5443715392',4),
('Mügenur','Atol','Kadın','1955-03-15','MügenurAtol34@outlook.com','71014297818','5423731047',4),
('Nedim','Atmaca','Erkek','1969-09-25','NedimAtmaca75@gmail.com','69014177750','5453362965',4),
('Cihan','Akçay','Erkek','1999-01-12','CihanAkçay@gmail.com','62114617833','5303609557',5),
('Rafi','Akdoğan','Erkek','1998-02-11','RafiAkdoğan43@outlook.com','63514515921','5303501602',5),
('Mehmetcan','Akbilmez','Erkek','1997-05-18','MehmetcanAkbilmez@icloud.com','63014339114','5253418163',5),
('Mehmet','Çakmak','Erkek','1975-05-25','mehmetcakmak@gmail.com','63014284563','5453574589',6),
('Nesrin','Düzgün','Kadın','1985-02-15','nesrindüzgun@hotmail.com','22563285743','5326987463',6),
('Özde','Acarkan','Kadın','1965-01-08','özdeacrk@icloud.com','22536585780','5356328596',6),
('Alper','Şadi','Erken','1976-06-21','alpersadi@hotmail.com','22585685720','5325237799',7),
('Abbas','Şahabettinoğlu','Erken','1969-09-05','abbasşahabettinoğlu@hotmail.com','22563296324','5326324896',7),
('Buraktan','Buraktan','Erkek','1975-04-24','buraktandüzgun@gmail.com','12345285743','5315687463',7),
('Gürkan','Şendağ','Erkek','1998-04-29','GürkanŞendağ@hotmail.com','22512455743','5325632163',10),
('Dilara','Taçgın','Kadın','1995-10-15','DilaraTaçgın@outlook.com','12365285962','5456328866',8),
('Seven','Taş','Kadın','1977-12-25','seventş@gmail.com','88963258654','5365479933',8),
('Güven','Taşlı','Erkek','1975-07-28','GüvenTaşlı@hotmail.com','77463285963','5368540182',8),
('İsmail','Tazegül','Erkek','1982-08-14','İsmailTazegül@hotmail.com','88596345856','5312571185',9),
('Aktan','Teker','Erkek','1971-01-11','AktanTeker@hotmail.com','11423685963','5356254585',9),
('Tuğbanur','Tiftikci','Kadın','1979-06-05','Tuğbanur@outlook.com','55636845862','5315896633',9),
('Erdem','Temizer','Erkek','1981-05-13','ErdemTemizer@icloud.com','22569785423','5368740269',10),
('Baysal','Tolunay','Erkek','1968-11-11','BaysalTolunay@outlook.com','11569856320','5315962288',10),
('Ahmet','Öner','Erkek','1985-01-03','ahmetöner@gmail.com','13518353048','5323224579',11),
('Beyza','Yalçınkaya','Kadın','1979-04-05','beyzyalcink@outlook.com','21493231410','5453517559',11),
('Şadi','Şeker','Erkek','1988-03-07','sadiseker@icloud.com','33495096230','5423214589',11),
('Kemal','Kılıç','Erkek','1977-07-09','kkilicc@icloud.com','34503842938','5328213569',12),
('Sefa','Boduroğlu','Erkek','1982-08-02','sefaboduroglu@gmail.com','52489030751','5354216589',12),
('Kenan','Yıldız','Erkek','1983-09-04','kenanyildiz@gmail.com','61488575567','5783314589',12),
('Filiz','Özsoy','Kadın','1984-10-06','filizozsoy@outlook.com','43024254712','5533428512',13),
('Miray','Üstün','Kadın','1986-11-08','mirayustun@icloud.com','33011283732','5417217519',13),
('Mihriban','Atay','Kadın','1998-12-10','mihribanatay@gmail.com','43017284832','5456213544',13),
('Melis','Çetin','Kadın','1999-02-12','meliscetin@outlook.com','43017283782','5447214546',14),
('Eray','Çelik','Erkek','2000-03-24','eraycelik@icloud.com','23014284782','5375214532',14),
('Bircan','Kaya','Erkek','1980-06-16','brcnkaya@outlook.com','22014284739','5365223521',14),
('Leyla','Özer','Kadın','1981-08-18','leylaozer@gmail.com','43014484632','5351214567',15),
('Canan','Alpınar','Kadın','1995-02-20','cananalpinar@outlook.com','55614284732','5334272530',15),
('Nusret','Akduman','Erkek','1992-03-22','nusretakduman@gmail.com','89214284732','5389277520',15),
('Mehtap','Baysal','Kadın','1991-01-24','mehtapbaysal@gmail.com','43214284732','5385218560',10),
('Mısra','Uzun','Kadın','1994-09-11','misrauzun@outlook.com','33014354732','5328219542',11),
('Elif','Çimen','Kadın','1986-11-13','elifcimen@gmail.com','93012284732','5323214562',12),
('Rana','Ak','Kadın','1985-12-15','ranaak@gmail.com','83014274752','5413217579',14),
('Pınar','Sayın','Kadın','1991-10-17','pinarsayin@outlook.com','12214284732','5345224539',15),
('Hasan','Akın','Erkek','1993-08-17','hasanakin@outlook.com','56014384132','5357314519',15)

GO

INSERT INTO tblArac
(Plaka)
VALUES
('34SEO01'),
('34SEO02'),
('34SEO03'),
('34SEO04'),
('34SEO05'),
('34SEO06'),
('21SEO01'),
('21SEO02'),
('21SEO03'),
('53SEO01'),
('53SEO02'),
('53SEO03'),
('35SEO01'),
('35SEO02'),
('35SEO03'),
('16SEO01'),
('16SEO02'),
('16SEO03'),
('16SEO04')

GO

INSERT INTO tblOdemeTipi
(Tip)
VALUES
('Nakit'),
('Kredi Kartı'),
('Banka Kartı'),
('Kripto')

GO

INSERT INTO tblKargoDurumu
(Durum)
VALUES
('Gönderi Hazırlanıyor'),
('Transfer Merkezinde'),
('Gönderi Yolda'),
('Teslimat Şubesinde'),
('Kurye Dağıtımda'),
('Teslim Edildi'),
('Teslim Edilemedi')

GO

INSERT INTO tblGeridonut
(MusteriId,Icerik,Tarih)
VALUES
(36,'Ürün zamanında elime ulaştı','2021-03-13'),
(30,'Ürünün paketlemesi çok kötüydü , yinede zamanında elime ulaştı','2021-03-19'),
(23,'Teşekkürler,güzel hizmet','2021-05-19'),
(30,'Kuryenizin hal ve hareketleri hiç hoşuma gitmedi.','2021-03-22'),
(45,'İlgili ve detaylı hizmet,Teşekkürler','2021-02-03'),
(45,'Kusursuz Hizmet','2021-02-28'),
(4,'Hızlı teslimat sözü verildi,iki gün sonra geldi.','2021-03-22'),
(29,'Ürünün ambalajı açık geldi','2021-02-28'),
(33,'Ürün elime ulaştı','2021-01-22'),
(9,'Teşekkürler','2021-03-07')

GO

INSERT INTO tblKargo
(Barkod_Numarası,Toplam_Ucret,AlisSubeId,VarisSubeId,CikisAdresId,
VarisAdresId,GönderenMusteriId,TeslimAlanMusteriId,Teslim_Alım_Tarihi,
Teslim_Edilme_Tarihi,TeslimAlanCalisanId,OdemeTipiId,KargoSonDurumId,GeriDonutID)
VALUES
('SEO53211601',510,1,4,38,36,38,36,'2021-03-10','2021-03-13',1,1,6,1),
('SEO53211602',120,2,8,45,30,45,30,'2021-03-15','2021-03-17',5,2,6,2),
('SEO53211603',110,4,13,36,23,36,23,'2021-05-12','2021-05-15',10,1,6,3),
('SEO53211604',690,5,8,29,30,29,30,'2021-03-18','2021-03-21',14,3,6,4),
('SEO53211605',280,11,2,10,45,10,45,'2021-02-01','2021-02-03',32,2,6,5),
('SEO53211606',816.50,15,2,1,45,1,45,'2021-02-25','2021-02-26',43,1,6,6),
('SEO53211607',429.8,4,12,36,4,36,4,'2021-03-19','2021-03-21',12,2,6,7),
('SEO53211608',75,13,5,23,29,23,29,'2021-02-24','2021-02-27',39,2,6,8),
('SEO53211609',140,12,3,5,33,5,33,'2021-01-19','2021-01-21',35,3,6,9),
('SEO53211610',90,13,10,23,9,23,9,'2021-03-05','2021-03-07',37,1,6,10)

GO

INSERT INTO tblUrun
(Kg,En,Boy,Yukseklik,UrunKategoriId,Desi,Fiyat,KargoId)
VALUES
(5,100,150,100,4,500,500,1),
(1,10,15,10,4,0.5,10,1),
(10,80,15,30,4,12,100,2),
(2,100,15,10,4,5,20,2),
(3,70,10,10,1,2.33,35,3),
(5,110,15,10,1,5.5,75,3),
(4,90,25,10,2,7.5,80,4),
(8,85,15,10,2,4.25,160,4),
(15,120,25,10,3,10,450,4),
(1,55,15,35,1,9.625,19.25,5),
(9,75,25,45,2,28.125,180,5),
(5,95,30,85,4,80.75,80.75,5),
(4,35,45,65,3,34.125,136.5,6),
(7,25,60,85,4,42.5,42.5,6),
(10,100,85,75,2,212.5,637.5,6),
(25,65,100,150,4,325,325,7),
(10,250,50,25,4,104.166,104.20,7),
(5,90,45,10,1,13.5,75,8),
(4,10,65,10,2,6.5,80,9),
(3,50,25,20,2,8.333,60,9),
(1,5,15,10,3,0.25,30,10),
(6,30,30,40,4,12,60,10)

GO

Insert Into tblKargoHareketleri(CikisTarihi,VarisTarihi,CikisSaati,VarisSaati,AracId,CikisSubeId,VarisSubeId,KargoDurumId,KargoId)
Values
('2021-03-10','2021-03-11','12:30','16:00',13,1,1,1,1),
('2021-03-11','2021-03-11','18:00','21:00',13,1,2,2,1),
('2021-03-12','2021-03-12','09:00',null,13,2,null,3,1),
('2021-03-13','2021-03-13',null,'09:00',13,null,4,4,1),
('2021-03-13','2021-03-13','10:00','16:00',16,4,null,5,1),
('2021-03-13','2021-03-13',null,'16:00',16,4,null,6,1),
('2021-03-15','2021-03-16','10:00','16:00',15,2,2,1,2),
('2021-03-16','2021-03-17','19:00',null,15,2,null,3,2),
('2021-03-17','2021-03-17',null,'09:00',15,null,8,4,2),
('2021-03-17','2021-03-17','10:00','16:00',8,8,null,5,2),
('2021-03-17','2021-03-17',null,'16:00',8,8,null,6,2),
('2021-05-12','2021-05-13','10:00','14:00',18,4,4,1,3),
('2021-05-13','2021-05-14','16:00',null,18,4,null,3,3),
('2021-05-13','2021-05-15',null,'09:00',18,null,13,4,3),
('2021-05-15','2021-05-15','10:00','16:00',11,13,null,5,3),
('2021-05-15','2021-05-15',null,'16:00',11,13,null,6,3),
('2021-03-18','2021-03-18','12:30','14:00',8,5,5,1,4),
('2021-03-20','2021-03-20','09:00',null,8,5,null,3,4),
('2021-03-21','2021-03-21',null,'09:00',8,null,13,4,4),
('2021-03-21','2021-03-21','10:00','13:00',9,13,null,5,4),
('2021-03-21','2021-03-21',null,'13:00',9,13,null,6,4),
('2021-02-01','2021-02-01','10:00','12:30',4,11,11,1,5),
('2021-02-02','2021-02-02','10:00',null,4,11,null,3,5),
('2021-02-03','2021-02-03',null,'08:45',4,null,2,4,5),
('2021-02-03','2021-02-03','09:30','11:45',14,2,null,5,5),
('2021-02-03','2021-02-03',null,'11:45',14,2,null,6,5),
('2021-02-25','2021-02-25','10:00','11:30',1,15,15,1,6),
('2021-02-25','2021-02-25','12:30','13:00',1,15,14,2,6),
('2021-02-25','2021-02-26','13:00',null,2,14,null,3,6),
('2021-02-26','2021-02-26',null,'01:00',2,null,2,4,6),
('2021-03-13','2021-02-26','09:30','16:00',15,2,null,5,6),
('2021-02-26','2021-02-26',null,'16:00',15,2,null,6,6),
('2021-03-19','2021-03-19','10:00','11:30',17,4,4,1,7),
('2021-03-20','2021-03-20','12:30','13:00',17,4,3,2,7),
('2021-03-20','2021-03-21','13:00',null,19,3,null,3,7),
('2021-03-21','2021-03-21',null,'03:00',19,null,12,4,7),
('2021-03-21','2021-03-21','09:30','18:45',6,12,null,5,7),
('2021-03-21','2021-03-21',null,'18:45',6,12,null,6,7),
('2021-02-24','2021-02-24','12:30','16:00',10,13,13,1,8),
('2021-02-25','2021-02-25','9:00','13:00',10,13,9,2,8),
('2021-02-25','2021-02-26','13:00',null,11,9,null,3,8),
('2021-02-26','2021-02-26',null,'19:00',11,null,5,4,8),
('2021-02-27','2021-02-27','09:30','14:30',7,5,null,5,8),
('2021-02-27','2021-02-27',null,'14:30',7,5,null,6,8),
('2021-01-19','2021-01-19','10:00','15:00',12,12,12,1,9),
('2021-01-19','2021-01-20','19:00',null,12,12,null,3,9),
('2021-01-20','2021-01-21',null,'11:00',12,null,3,4,9),
('2021-01-21','2021-01-21','13:00','18:30',16,3,null,5,9),
('2021-01-21','2021-01-21',null,'18:30',16,3,null,6,9),
('2021-03-05','2021-03-05','12:30','15:00',11,13,13,1,10),
('2021-03-05','2021-03-06','18:00',null,11,13,null,3,10),
('2021-03-06','2021-03-07',null,'11:00',11,null,10,4,10),
('2021-03-07','2021-03-07','14:00','20:00',4,10,null,5,10),
('2021-03-07','2021-03-07',null,'20:00',4,10,null,6,10)