本帖最后由 jianweis 于 2012-4-17 12:27 编辑
- /****** Object: Table [dbo].[ITEM_LOG] Script Date: 04/16/2012 21:32:19 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[ITEM_LOG](
- [srcid] [varchar](50) NULL,
- [tarid] [varchar](100) NULL,
- [type] [int] NULL,
- [putserial] [bigint] NULL,
- [putitemid] [int] NULL,
- [money] [int] NULL,
- [putdure] [int] NULL,
- [putcount] [int] NULL,
- [getcount] [int] NULL,
- [uscroll] [int] NULL,
- [getitem] [int] NULL
- ) ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- /****** Object: StoredProcedure [dbo].[INSERT_ITEM_LOG] Script Date: 04/16/2012 21:32:46 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- -- =============================================
- -- Author: SJW
- -- Create date: 2012-4-14
- -- Description: ItemManger
- -- =============================================
- CREATE PROCEDURE [dbo].[INSERT_ITEM_LOG]
- @srcid varchar(50),
- @tarid varchar(100),
- @type int,
- @putserial bigint,
- @putitemid int,
- @money int,
- @putdure int,
- @putcount int,
- @getcount int,
- @uscroll int,
- @getitem int
- AS
- BEGIN
- insert into ITEM_LOG(srcid,tarid,type,putserial,putitemid,money,putdure,putcount,getcount,uscroll,getitem)
- values(@srcid,@tarid,@type,@putserial,@putitemid,@money,@putdure,@putcount,@getcount,@uscroll,@getitem)
- END
- GO
复制代码 下载地址:
5.rar |