130 lines
6.0 KiB
Transact-SQL
130 lines
6.0 KiB
Transact-SQL
-- LosaDev 2014: src\sql\20120504\lostsaga_etc.sql as UTF-8 (functions, users). One old view fails; expected.
|
|
USE [LosaGame]
|
|
GO
|
|
/****** 개체: User [lstggame] 스크립트 날짜: 05/04/2012 14:09:58 ******/
|
|
CREATE USER [lstggame] FOR LOGIN [lstggame] WITH DEFAULT_SCHEMA=[dbo]
|
|
GO
|
|
/****** 개체: User [lstgweb] 스크립트 날짜: 05/04/2012 14:09:58 ******/
|
|
CREATE USER [lstgweb] FOR LOGIN [lstgweb] WITH DEFAULT_SCHEMA=[dbo]
|
|
GO
|
|
/****** 개체: UserDefinedFunction [dbo].[DEFINE_REGION_LIMIT_SE_RENSPOINT] 스크립트 날짜: 05/04/2012 14:09:58 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE FUNCTION [dbo].[DEFINE_REGION_LIMIT_SE_RENSPOINT]
|
|
(
|
|
)
|
|
RETURNS int
|
|
As
|
|
BEGIN
|
|
|
|
DECLARE @returnVal int
|
|
SET @returnVal = 5
|
|
|
|
RETURN @returnVal
|
|
|
|
END
|
|
GO
|
|
/****** 개체: UserDefinedFunction [dbo].[DEFINE_REGION_LIMIT_RENSPOINT] 스크립트 날짜: 05/04/2012 14:09:57 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE FUNCTION [dbo].[DEFINE_REGION_LIMIT_RENSPOINT]
|
|
(
|
|
)
|
|
RETURNS int
|
|
As
|
|
BEGIN
|
|
|
|
DECLARE @returnVal int
|
|
SET @returnVal = 5
|
|
|
|
RETURN @returnVal
|
|
|
|
END
|
|
GO
|
|
/****** 개체: UserDefinedFunction [dbo].[DEFINE_SERVER_CONNECTION_MAX_COUNT] 스크립트 날짜: 05/04/2012 14:09:58 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE FUNCTION [dbo].[DEFINE_SERVER_CONNECTION_MAX_COUNT]
|
|
(
|
|
)
|
|
RETURNS int
|
|
AS
|
|
BEGIN
|
|
|
|
DECLARE @maxcount int
|
|
SET @maxcount = 2500
|
|
|
|
RETURN @maxcount
|
|
|
|
END
|
|
GO
|
|
/****** 개체: View [dbo].[userMannerpointDB] 스크립트 날짜: 05/04/2012 14:09:58 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE VIEW [dbo].[userMannerpointDB]
|
|
|
|
AS
|
|
|
|
SELECT receiveIDX as 'accountIDX', receivepoint as 'point', reportpubIP as 'userIP', regDate FROM LosaGame_log.DBO.log_mannerpoint
|
|
UNION ALL
|
|
SELECT accountIDX, point, userIP, regDate FROM LosaGame_log.DBO.log_mannerpoint_sitevisit
|
|
GO
|
|
/****** 개체: View [dbo].[userQuestView] 스크립트 날짜: 05/04/2012 14:09:58 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE VIEW [dbo].[userQuestView] AS
|
|
|
|
SELECT * FROM (
|
|
SELECT idx, accountIDX, 1 as pos, quest1_type as quest_type, quest1_value1 as quest_value1, quest1_value2 as quest_value2, quest1_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 2 as pos, quest2_type as quest_type, quest2_value1 as quest_value1, quest2_value2 as quest_value2, quest2_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 3 as pos, quest3_type as quest_type, quest3_value1 as quest_value1, quest3_value2 as quest_value2, quest3_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 4 as pos, quest4_type as quest_type, quest4_value1 as quest_value1, quest4_value2 as quest_value2, quest4_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 5 as pos, quest5_type as quest_type, quest5_value1 as quest_value1, quest5_value2 as quest_value2, quest5_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 6 as pos, quest6_type as quest_type, quest6_value1 as quest_value1, quest6_value2 as quest_value2, quest6_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 7 as pos, quest7_type as quest_type, quest7_value1 as quest_value1, quest7_value2 as quest_value2, quest7_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 8 as pos, quest8_type as quest_type, quest8_value1 as quest_value1, quest8_value2 as quest_value2, quest8_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 9 as pos, quest9_type as quest_type, quest9_value1 as quest_value1, quest9_value2 as quest_value2, quest9_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 10 as pos, quest10_type as quest_type, quest10_value1 as quest_value1, quest10_value2 as quest_value2, quest10_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 11 as pos, quest11_type as quest_type, quest11_value1 as quest_value1, quest11_value2 as quest_value2, quest11_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 12 as pos, quest12_type as quest_type, quest12_value1 as quest_value1, quest12_value2 as quest_value2, quest12_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 13 as pos, quest13_type as quest_type, quest13_value1 as quest_value1, quest13_value2 as quest_value2, quest13_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 14 as pos, quest14_type as quest_type, quest14_value1 as quest_value1, quest14_value2 as quest_value2, quest14_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 15 as pos, quest15_type as quest_type, quest15_value1 as quest_value1, quest15_value2 as quest_value2, quest15_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 16 as pos, quest16_type as quest_type, quest16_value1 as quest_value1, quest16_value2 as quest_value2, quest16_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 17 as pos, quest17_type as quest_type, quest17_value1 as quest_value1, quest17_value2 as quest_value2, quest17_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 18 as pos, quest18_type as quest_type, quest18_value1 as quest_value1, quest18_value2 as quest_value2, quest18_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 19 as pos, quest19_type as quest_type, quest19_value1 as quest_value1, quest19_value2 as quest_value2, quest19_time as quest_time FROM userQuestDB WITH (nolock)
|
|
UNION ALL
|
|
SELECT idx, accountIDX, 20 as pos, quest20_type as quest_type, quest20_value1 as quest_value1, quest20_value2 as quest_value2, quest20_time as quest_time FROM userQuestDB WITH (nolock)
|
|
) as a
|
|
WHERE quest_type <> 0
|
|
GO
|