CREATE TABLE [dbo].[tblReceivedSms](
	[Id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[Mobile] [nvarchar](30) NULL,
	[RegDate] [smalldatetime] NULL,
	[SendDate] [smalldatetime] NULL,
	[Message] [ntext] NULL,
	[SmsId] [numeric](18, 0) NULL,
	[Flag] [char](10) NULL,
 CONSTRAINT [PK_tblReceiveSms\] PRIMARY KEY CLUSTERED 
(
	[Id] 
)
) ON [PRIMARY]

ALTER TABLE [dbo].[tblReceivedSms] ADD  CONSTRAINT [DF_tblReceivedSms_ReceiveDate]  DEFAULT (getdate()) FOR [RegDate]


ALTER TABLE [dbo].[tblReceivedSms] ADD  CONSTRAINT [DF_tblReceivedSms_Status]  DEFAULT ((0)) FOR [Flag]
