-- 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