IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bankalar]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[bankalar](
[BankaID] [tinyint] NOT NULL,
[Tanim] [varchar](50) NOT NULL,
[WebSite] [varchar](100) NOT NULL,
[Aktif] [bit] NOT NULL,
CONSTRAINT [PK_bankalar] PRIMARY KEY CLUSTERED
(
[BankaID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END

SET XACT_ABORT ON
BEGIN TRANSACTION
SET IDENTITY_INSERT [dbo].[bankalar] ON

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (1, 'ADABANK', 'http://www.adabank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (2, 'AKBANK', 'http://www.akbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (3, 'ALBARAKA TÜRK', 'http://www.albarakaturk.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (4, 'ALTERNATİF BANK', 'http://www.abank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (5, 'ANADOLU BANKASI', 'http://www.anadolubank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (6, 'ARAP TÜRK BANKASI', 'http://www.arabturkbank.com/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (7, 'BANK ASYA', 'http://www.bankasya.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (8, 'BANK EKSPRES', 'http://www.bankekspres.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (9, 'BANK POZİTİF', 'http://www.bankpozitif.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (10, 'CİTİBANK', 'http://www.citibank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (11, 'DENİZBANK', 'http://www.denizbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (12, 'FİNANSBANK', 'http://www.finansbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (13, 'FONBANK', 'http://www.fonbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (14, 'FORTİS', 'http://www.fortis.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (15, 'GARANTİ BANKASI', 'http://www.garanti.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (16, 'HALK BANKASI', 'http://www.halkbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (17, 'HSBC', 'http://www.hsbc.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (18, 'İŞ BANKASI', 'http://www.isbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (19, 'KUVEYT TÜRK', 'http://www.kuveytturk.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (20, 'T.C. MERKEZ BANKASI', 'http://www.tcmb.gov.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (21, 'MNG BANK', 'http://www.mngbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (22, 'OYAK BANK', 'http://www.oyakbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (23, 'ŞEKERBANK', 'http://www.sekerbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (24, 'TAKASBANK', 'http://www.takasbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (25, 'TEKSTİLBANK', 'http://www.tekstilbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (26, 'TEKFENBANK', 'http://www.tekfenbank.com/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (27, 'TEB - TÜRK EKONOMİ BANKASI', 'http://www.teb.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (28, 'TURKİSH BANK', 'http://www.turkishbank.com/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (29, 'TÜRKİYE FİNANS', 'http://www.turkiyefinans.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (30, 'TÜRKİYE KALKINMA BANKASI', 'http://www.tkb.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (31, 'TÜRKİYE SINAİ KALK. BANKASI', 'http://www.tskb.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (32, 'VAKIFBANK', 'http://www.vakifbank.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (33, 'YAPI KREDİ', 'http://www.ykb.com.tr/', 1)

INSERT INTO [dbo].[bankalar] ([BankaID], [Tanim], [WebSite], [Aktif])
VALUES (34, 'ZİRAAT BANKASI', 'http://www.ziraat.com.tr/', 1)

SET IDENTITY_INSERT [dbo].[bankalar] OFF
COMMIT TRANSACTION
SET XACT_ABORT OFF