SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[kullanici]') AND type IN (N'U')) BEGIN CREATE TABLE [dbo].[kullanici]( [pname] [char](10) NULL, [pword] [char](10) NULL, [adisoyadi] [char](50) NULL, [gorev] [char](50) NULL, [id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Table_1_guid] DEFAULT (newid()) ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[personel]') AND type IN (N'U')) BEGIN CREATE TABLE [dbo].[personel]( [sicil] [nchar](10) NULL, [adi] [nchar](30) NULL, [soyadi] [nchar](30) NULL, [departman] [nchar](10) NULL, [maas] [numeric](18, 4) NULL, [gunlukucret] [numeric](18, 4) NULL, [adres] [text] NULL, [telefon] [nchar](40) NULL, [aciklama] [text] NULL, [id] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_personel_id] DEFAULT (newid()), [departmanid] [uniqueidentifier] NULL, CONSTRAINT [PK_personel] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END