IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE SYSOBJECTS.name = 'HYBILGILENDIRMEEGITIM')
CREATE TABLE [dbo].[HYBILGILENDIRMEEGITIM](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[TARIH] [datetime] NULL,
	[HYATISID] [int] NULL,
	
	[SOE1] bit not null CONSTRAINT DF_TITEM_SOE1 DEFAULT 0,
	[SOE2] bit not null CONSTRAINT DF_TITEM_SOE2 DEFAULT 0,
	[SOE3] bit not null CONSTRAINT DF_TITEM_SOE3 DEFAULT 0,
	[SOE4] bit not null CONSTRAINT DF_TITEM_SOE4 DEFAULT 0,
	[SOE5] bit not null CONSTRAINT DF_TITEM_SOE5 DEFAULT 0,
	[SOE6] bit not null CONSTRAINT DF_TITEM_SOE6 DEFAULT 0,
	[SOE7] bit not null CONSTRAINT DF_TITEM_SOE7 DEFAULT 0,
	[SOE8] bit not null CONSTRAINT DF_TITEM_SOE8 DEFAULT 0,
	[SOE9] bit not null CONSTRAINT DF_TITEM_SOE9 DEFAULT 0,
	[TOE1] bit not null CONSTRAINT DF_TITEM_TOE1 DEFAULT 0,
	[TOE2] bit not null CONSTRAINT DF_TITEM_TOE2 DEFAULT 0,
	[TOE3] bit not null CONSTRAINT DF_TITEM_TOE3 DEFAULT 0,
	[TOE4] bit not null CONSTRAINT DF_TITEM_TOE4 DEFAULT 0,
	[TOE5] bit not null CONSTRAINT DF_TITEM_TOE5 DEFAULT 0,
	[TOE6] bit not null CONSTRAINT DF_TITEM_TOE6 DEFAULT 0,
	[TOE7] bit not null CONSTRAINT DF_TITEM_TOE7 DEFAULT 0,
	[TOE8] bit not null CONSTRAINT DF_TITEM_TOE8 DEFAULT 0,
	[TOE9] bit not null CONSTRAINT DF_TITEM_TOE9 DEFAULT 0,
	[TOE10] bit not null CONSTRAINT DF_TITEM_TOE10 DEFAULT 0,
	[TOE11] bit not null CONSTRAINT DF_TITEM_TOE11 DEFAULT 0,
	[TOE12] bit not null CONSTRAINT DF_TITEM_TOE12 DEFAULT 0,
	[TOE13] bit not null CONSTRAINT DF_TITEM_TOE13 DEFAULT 0,
	[TOE14] bit not null CONSTRAINT DF_TITEM_TOE14 DEFAULT 0,	
	[TOE15] bit not null CONSTRAINT DF_TITEM_TOE15 DEFAULT 0,
	[TOE16] bit not null CONSTRAINT DF_TITEM_TOE16 DEFAULT 0,
	[TOE17] bit not null CONSTRAINT DF_TITEM_TOE17 DEFAULT 0,
	HASTAYAKINIADSOYAD NVARCHAR(100) NULL,			
	[SPID] [int] NULL,
	[KYUSER] [nvarchar](25) NULL,
	[KYTTARIHI] [datetime] NULL,
 CONSTRAINT [PK_HYBILGILENDIRMEEGITIM] PRIMARY KEY CLUSTERED 
(
	[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]
GO




