COUPON_EVENT 存储及表格

ctgwglzc

/****** Object: Table [dbo].[COUPON_EVENT] Script Date: 08/29/2009 05:21:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COUPON_EVENT](
[AccountID] [char](21) NOT NULL,
[CharID] [char](21) NOT NULL,
[CouponID] [char](20) NOT NULL,
[ItemID] [int] NOT NULL,
[ItemCount] [int] NOT NULL,
[RegisterTime] [smalldatetime] NOT NULL,
CONSTRAINT [PK_COUPON_EVENT] PRIMARY KEY CLUSTERED
(
[CouponID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
ALTER TABLE [dbo].[COUPON_EVENT] ADD CONSTRAINT [DF_COUPON_EVENT_RegisterTime] DEFAULT (getdate()) FOR [RegisterTime]
GO

复制代码

ctgwglzc · 2009-9-22 01:55:58

/****** Object: Table [dbo].[COUPON_SERIAL_LIST] Script Date: 08/29/2009 05:22:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COUPON_SERIAL_LIST](
[nIndex] [int] NOT NULL,
[strSerialNum] [char](16) NOT NULL,
[nItemNum] [int] NOT NULL,
[sItemCount] [smallint] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO

复制代码

ctgwglzc · 2009-9-22 01:56:17

CREATE PROCEDURE [dbo].[CHECK_COUPON_EVENT]
@strAccountID char(21),
@strCouponID char(21),
@nRet smallint OUTPUT
AS
DECLARE @Row tinyint
SELECT @Row = COUNT(AccountID) FROM COUPON_EVENT WHERE CouponID = @strCouponID OR AccountID = @strAccountID
IF @Row = 0
BEGIN
SET @nRet = 0
RETURN
END
SET @nRet = 1

复制代码

复制代码

yangwx · 2009-9-22 12:42:26

本帖最后由 yangwx 于 2009-9-22 12:50 编辑

都是干啥用滴？？？？？代码似乎不全。

ctgwglzc · 2009-9-22 18:06:10

公服的COUPON活动

账号		自动登录	找回密码
密码			加入

4 回复