
CREATE TABLE SMSRecord
(
	[Sid] [int] IDENTITY(1,1) NOT NULL,
	[SPhone] [varchar](50) NULL,
	[SCode] [varchar](50) NULL,
	[STime] [datetime] NULL
)

GO

CREATE TABLE SMSServer
(
	[Sid] [int] IDENTITY(1,1) NOT NULL,
	[ServerName] [varchar](50) NULL,
	[ServerPwd] [varchar](50) NULL,
	[UpHost] [varchar](50) NULL,
	[UpPort] [int] NULL,
	[DownHost] [varchar](50) NULL,
	[DownPort] [int] NULL
) 

GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSMSRecord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSMSRecord
GO
CREATE PROCEDURE GetSMSRecord
(
	@sphone int,
	@stime int
)
AS
	--ݸŻԱ֤⡣ֻѯÿѷͶŵ
	select * from SMSRecord where SPhone=@sphone and STime > @stime
	
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSMSServer') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSMSServer
GO
CREATE PROCEDURE GetSMSServer
(
	@sid int
)
AS
	--ݸŻԱŽӿڵķϢѯ
	select * from SMSServer where [Sid]=@sid
	
GO
