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