147 lines
4.5 KiB
Transact-SQL
147 lines
4.5 KiB
Transact-SQL
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: Table [dbo].[userDiceGameDB] Script Date: 10/11/2018 17:38:09 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[userDiceGameDB](
|
|
[AccountIDX] [int] NOT NULL,
|
|
[Position] [int] NOT NULL,
|
|
[Trace01] [int] NOT NULL,
|
|
[Trace02] [int] NOT NULL,
|
|
[Trace03] [int] NOT NULL,
|
|
[Trace04] [int] NOT NULL,
|
|
[Trace05] [int] NOT NULL,
|
|
[Trace06] [int] NOT NULL,
|
|
[Board] [tinyint] NOT NULL,
|
|
[RewardStep01] [int] NOT NULL,
|
|
[RewardStep02] [int] NOT NULL,
|
|
[RewardStep03] [int] NOT NULL,
|
|
[RewardStep04] [int] NOT NULL,
|
|
[RewardStep05] [int] NOT NULL,
|
|
[RewardStep06] [int] NOT NULL,
|
|
[RewardStep07] [int] NOT NULL,
|
|
[RewardStep08] [int] NOT NULL,
|
|
[RewardStep09] [int] NOT NULL,
|
|
[RewardStep10] [int] NOT NULL,
|
|
[UpdateTime] [datetime] NULL,
|
|
[RegDate] [datetime] NULL
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
|
|
|
|
-------------------------------------------------------------------------------------------
|
|
-------------------------------------------------------------------------------------------
|
|
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_dice_game_data_update] Script Date: 10/11/2018 17:40:00 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.game_dice_game_data_update
|
|
-- Author : bckim
|
|
-- DATE : 2018-08-30
|
|
-- Description : // 2018-08-30 by bckim, 주사위 이벤트 추가
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[game_dice_game_data_update]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@Position INT,
|
|
@Trace01 INT,
|
|
@Trace02 INT,
|
|
@Trace03 INT,
|
|
@Trace04 INT,
|
|
@Trace05 INT,
|
|
@Trace06 INT,
|
|
@Board TINYINT,
|
|
@Reward01 INT,
|
|
@Reward02 INT,
|
|
@Reward03 INT,
|
|
@Reward04 INT,
|
|
@Reward05 INT,
|
|
@Reward06 INT,
|
|
@Reward07 INT,
|
|
@Reward08 INT,
|
|
@Reward09 INT,
|
|
@Reward10 INT
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
BEGIN TRAN
|
|
UPDATE [dbo].[userDiceGameDB] WITH (XLOCK, ROWLOCK)
|
|
SET [AccountIDX] = @ACCOUNT_IDX,[Position] = @Position,[Trace01] = @Trace01,[Trace02] = @Trace02,[Trace03] = @Trace03,[Trace04] = @Trace04,[Trace05] = @Trace05,[Trace06] = @Trace06,[Board] = @Board,
|
|
[RewardStep01] = @Reward01,[RewardStep02] = @Reward02,[RewardStep03] = @Reward03,[RewardStep04] = @Reward04,[RewardStep05] = @Reward05,
|
|
[RewardStep06] = @Reward06,[RewardStep07] = @Reward07,[RewardStep08] = @Reward08,[RewardStep09] = @Reward09,[RewardStep10] = @Reward10, [UpdateTime] = GETDATE()
|
|
WHERE AccountIDX = @ACCOUNT_IDX;
|
|
|
|
IF(@@ROWCOUNT=0)
|
|
BEGIN
|
|
INSERT INTO [dbo].[userDiceGameDB] WITH(XLOCK, ROWLOCK) ([AccountIDX],[Position],[Trace01],[Trace02],[Trace03],[Trace04],[Trace05],[Trace06],[Board],
|
|
[RewardStep01],[RewardStep02],[RewardStep03],[RewardStep04],[RewardStep05],[RewardStep06],[RewardStep07],[RewardStep08],[RewardStep09],[RewardStep10],[UpdateTime],[RegDate] )
|
|
VALUES ( @ACCOUNT_IDX,@Position,@Trace01,@Trace02,@Trace03,@Trace04,@Trace05,@Trace06,@Board,
|
|
@Reward01,@Reward02,@Reward03,@Reward04,@Reward05,@Reward06,@Reward07,@Reward08,@Reward09,@Reward10, GETDATE(),GETDATE())
|
|
END
|
|
COMMIT TRAN
|
|
|
|
|
|
GO
|
|
|
|
|
|
|
|
-------------------------------------------------------------------------------------------
|
|
-------------------------------------------------------------------------------------------
|
|
|
|
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_dice_game_get_data] Script Date: 10/11/2018 17:40:32 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.game_dice_game_get_data
|
|
-- Author : bckim
|
|
-- DATE : 2018-08-30
|
|
-- Description : // 2018-08-30 by bckim, 주사위 이벤트 추가
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[game_dice_game_get_data]
|
|
|
|
@ACCOUNT_IDX INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
SELECT [Position],[Trace01],[Trace02],[Trace03],[Trace04],[Trace05],[Trace06],[Board],
|
|
[RewardStep01],[RewardStep02],[RewardStep03],[RewardStep04],[RewardStep05],
|
|
[RewardStep06],[RewardStep07],[RewardStep08],[RewardStep09],[RewardStep10]
|
|
FROM [dbo].[userDiceGameDB] WITH (NOLOCK)
|
|
WHERE [AccountIDX] = @ACCOUNT_IDX
|
|
|
|
|
|
GO
|
|
|
|
|