CREATE TABLE [dbo].[students](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[fullname] [nvarchar](max) NOT NULL,
	[fath] [nvarchar](max) NOT NULL,
	[milad] [nvarchar](max) NOT NULL,
	[saf] [int] NOT NULL,
	[usr] [nvarchar](max) NOT NULL,
	[pass] [nvarchar](max) NOT NULL,
	[mob] [nvarchar](max) NOT NULL,
	[phone] [nvarchar](max) NOT NULL,
	[hid] [int] NOT NULL,
	[del] [int] NOT NULL,
	[maxpoint] [int] NOT NULL,
	[bonus] [int] NOT NULL,
	[bonusotherpoints] [int] NOT NULL,
 CONSTRAINT [PK_students] 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].[students] ADD  CONSTRAINT [DF_students_fullname]  DEFAULT ('') FOR [fullname]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_fath]  DEFAULT ('') FOR [fath]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_milad]  DEFAULT ('') FOR [milad]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_saf]  DEFAULT ((0)) FOR [saf]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_usr]  DEFAULT ('') FOR [usr]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_pass]  DEFAULT ('') FOR [pass]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_mob]  DEFAULT ('') FOR [mob]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_phone]  DEFAULT ('') FOR [phone]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_hid]  DEFAULT ((0)) FOR [hid]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF_students_del]  DEFAULT ((0)) FOR [del]
GO

ALTER TABLE [dbo].[students] ADD  CONSTRAINT [DF__students__maxpoi__47DBAE45]  DEFAULT ((15)) FOR [maxpoint]
GO

ALTER TABLE [dbo].[students] ADD  DEFAULT ((0)) FOR [bonus]
GO

ALTER TABLE [dbo].[students] ADD  DEFAULT ((0)) FOR [bonusotherpoints]
GO