CREATE TABLE [dbo].[teachers](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[fullname] [nvarchar](max) NOT NULL,
	[fath] [nvarchar](max) NOT NULL,
	[milad] [nvarchar](max) NOT NULL,
	[pass] [nvarchar](max) NOT NULL,
	[phone] [nvarchar](max) NOT NULL,
	[study] [nvarchar](max) NOT NULL,
	[snawat] [nvarchar](max) NOT NULL,
	[mharat] [nvarchar](max) NOT NULL,
	[teachers] [nvarchar](max) NOT NULL,
	[places] [nvarchar](max) NOT NULL,
	[books] [nvarchar](max) NOT NULL,
	[mob] [nvarchar](max) NOT NULL,
	[masjedname] [nvarchar](max) NOT NULL,
	[dbname] [nvarchar](max) NOT NULL,
	[del] [int] NOT NULL,
	[auth] [nvarchar](max) NOT NULL,
	[flagfaslchange] [int] NOT NULL,
 CONSTRAINT [PK_teachers] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_fullname]  DEFAULT ('') FOR [fullname]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_fath]  DEFAULT ('') FOR [fath]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_milad]  DEFAULT ('') FOR [milad]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_pass]  DEFAULT ('') FOR [pass]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_phone]  DEFAULT ('') FOR [phone]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_study]  DEFAULT ('') FOR [study]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_snawat]  DEFAULT ('') FOR [snawat]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_mharat]  DEFAULT ('') FOR [mharat]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_teachers]  DEFAULT ('') FOR [teachers]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_places]  DEFAULT ('') FOR [places]
GO

ALTER TABLE [dbo].[teachers] ADD  CONSTRAINT [DF_teachers_books]  DEFAULT ('') FOR [books]
GO

ALTER TABLE [dbo].[teachers] ADD  DEFAULT ('') FOR [mob]
GO

ALTER TABLE [dbo].[teachers] ADD  DEFAULT ('') FOR [masjedname]
GO

ALTER TABLE [dbo].[teachers] ADD  DEFAULT ('') FOR [dbname]
GO

ALTER TABLE [dbo].[teachers] ADD  DEFAULT ((0)) FOR [del]
GO

ALTER TABLE [dbo].[teachers] ADD  DEFAULT ('') FOR [auth]
GO

ALTER TABLE [dbo].[teachers] ADD  DEFAULT ((0)) FOR [flagfaslchange]
GO