if NOT exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblSmsConfig]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Begin

CREATE TABLE [dbo].[tblSmsConfig](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[Status] [char](1) NULL,
	[BaudRate] [int] NULL,
	[ComPort] [varchar](4) NULL,
	[URL] [varchar](50) NULL,
	[UserName] [nvarchar](20) NULL,
	[Password] [nvarchar](20) NULL
) ON [PRIMARY]

Insert into tblSmsConfig
(Status , BaudRate , ComPort , URL )
Values(0 , 115200 ,'Com3' , 'http://sms.rkara.com/API/SendSMS.aspx')

End
