alter table Invoice alter column Note nvarchar(max)

ALTER TABLE Invoice
ADD CONSTRAINT InvoiceComplate_const DEFAULT 0 FOR InvoiceComplate
ALTER TABLE Invoice
ADD CONSTRAINT InvoiceImporter_const DEFAULT 0 FOR InvoiceImporter

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EF_SABIT](
	[KULLANICI_ADI] [varchar](100) NULL,
	[KULLANICI_PAROLA] [varchar](20) NULL,
	[FATURA_EK] [varchar](20) NULL,
	[ARSIV_EK] [varchar](20) NULL,
	[MAIL_ADRES] [varchar](50) NULL,
	[FATURA_ON_EK] [varchar](20) NULL,
	[ARSIV_ON_EK] [varchar](20) NULL,
	[AD] [varchar](50) NULL,
	[SOYAD] [varchar](50) NULL,
	[ACIKLAMA] [varchar](1000) NULL,
	[ACIKLAMA2] [varchar](1000) NULL,
	[ACIKLAMA3] [varchar](1000) NULL,
	[IBAN] [varchar](1000) NULL,
	[IRSALIYE_EK] [varchar](20) NULL,
	[IRSALIYE_ON_EK] [varchar](20) NULL,
	[ACIKLAMA1] [varchar](1000) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[EF_SABIT] ([KULLANICI_ADI], [KULLANICI_PAROLA], [FATURA_EK], [ARSIV_EK], [MAIL_ADRES], [FATURA_ON_EK], [ARSIV_ON_EK], [AD], [SOYAD], [ACIKLAMA], [ACIKLAMA2], [ACIKLAMA3], [IBAN], [IRSALIYE_EK], [IRSALIYE_ON_EK], [ACIKLAMA1]) VALUES (N'yavuzdogru', N'Dogru70+', N'', N'', N' ', N'', N'', NULL, NULL, NULL, N'', NULL, N'', NULL, NULL, N'')
GO
