1-) NOTLAR - genel not 1

USE [SigortaVip]

GO

/****** Object:  Table [dbo].[ayarlar]    Script Date: 7.07.2021 00:01:08 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ayarlar](

[ayarlar_id] [int] IDENTITY(1,1) NOT NULL,

[ayarlar_key] [nvarchar](max) NULL,

[ayarlar_value] [nvarchar](max) NULL,

[ayarlar_aciklama] [nvarchar](max) NULL,

 CONSTRAINT [PK_ayarlar] PRIMARY KEY CLUSTERED

(

[ayarlar_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] TEXTIMAGE_ON [PRIMARY]

GO

/****** Object:  Table [dbo].[firma]    Script Date: 7.07.2021 00:01:08 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[firma](

[firma_id] [int] IDENTITY(1,1) NOT NULL,

[firma_firmaAd] [nvarchar](500) NULL,

[firma_kullaniciAd] [nvarchar](500) NULL,

[firma_kullaniciSifre] [nvarchar](500) NULL,

[firma_webLink] [nvarchar](500) NULL,

[firma_aktif] [bit] NULL,

[firma_sessions] [nvarchar](max) NULL,

 CONSTRAINT [PK_firma] PRIMARY KEY CLUSTERED

(

[firma_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] TEXTIMAGE_ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[firma] ON

GO

INSERT [dbo].[firma] ([firma_id], [firma_firmaAd], [firma_kullaniciAd], [firma_kullaniciSifre], [firma_webLink], [firma_aktif], [firma_sessions]) VALUES (2, N'DogaSigorta', N'sedatektas', N'Buse343434', N'https://portal.dogasigorta.com/ajaxpro/login,ASWWebSite.ashx', 1, NULL)

GO

INSERT [dbo].[firma] ([firma_id], [firma_firmaAd], [firma_kullaniciAd], [firma_kullaniciSifre], [firma_webLink], [firma_aktif], [firma_sessions]) VALUES (3, N'GriSigorta', N'342157', N'Elvin1416', N'https://portal.grisigorta.com.tr/ajaxpro/login,ASWWebSite.ashx', 1, NULL)

GO

INSERT [dbo].[firma] ([firma_id], [firma_firmaAd], [firma_kullaniciAd], [firma_kullaniciSifre], [firma_webLink], [firma_aktif], [firma_sessions]) VALUES (4, N'KoruSigorta', N'22049', N'Sude3434', N'https://korusigortaportal.com/ajaxpro/login,ASWWebSite.ashx', 1, NULL)

GO

INSERT [dbo].[firma] ([firma_id], [firma_firmaAd], [firma_kullaniciAd], [firma_kullaniciSifre], [firma_webLink], [firma_aktif], [firma_sessions]) VALUES (5, N'TurkiyeSigorta', N'A5600361002', N'Elvin1416', N'https://pusula.turkiyesigorta.com.tr/login.seam ', 1, NULL)

GO

SET IDENTITY_INSERT [dbo].[firma] OFF

GO