forked from LosaDev/ls-2019-source
4767 lines
166 KiB
Transact-SQL
4767 lines
166 KiB
Transact-SQL
-- LosaDev 2019: LosaLogData.sql of the 2021 release (the 2019 release's own scripts lack 212 of the 401 procedures
|
|
-- the 2019 server calls; the 2021 schema matches all but a few, see 07_losadev_2019_procs.sql).
|
|
-- Unchanged except the CREATE DATABASE block. Run after 00_create_databases.sql and 01_logins.sql.
|
|
USE [master]
|
|
GO
|
|
/****** Object: Database [LosaLogData] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
-- (LosaDev) CREATE DATABASE [LosaLogData] is done by 00_create_databases.sql
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET COMPATIBILITY_LEVEL = 160
|
|
GO
|
|
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
|
|
begin
|
|
EXEC [LosaLogData].[dbo].[sp_fulltext_database] @action = 'enable'
|
|
end
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET ANSI_NULL_DEFAULT OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET ANSI_NULLS OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET ANSI_PADDING OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET ANSI_WARNINGS OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET ARITHABORT OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET AUTO_CLOSE OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET AUTO_SHRINK OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET AUTO_UPDATE_STATISTICS ON
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET CURSOR_CLOSE_ON_COMMIT OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET CURSOR_DEFAULT GLOBAL
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET CONCAT_NULL_YIELDS_NULL OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET NUMERIC_ROUNDABORT OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET QUOTED_IDENTIFIER OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET RECURSIVE_TRIGGERS OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET DISABLE_BROKER
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET DATE_CORRELATION_OPTIMIZATION OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET TRUSTWORTHY OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET ALLOW_SNAPSHOT_ISOLATION OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET PARAMETERIZATION SIMPLE
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET READ_COMMITTED_SNAPSHOT OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET HONOR_BROKER_PRIORITY OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET RECOVERY SIMPLE
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET MULTI_USER
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET PAGE_VERIFY CHECKSUM
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET DB_CHAINING OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET TARGET_RECOVERY_TIME = 60 SECONDS
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET DELAYED_DURABILITY = DISABLED
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET ACCELERATED_DATABASE_RECOVERY = OFF
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET QUERY_STORE = ON
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)
|
|
GO
|
|
USE [LosaLogData]
|
|
GO
|
|
/****** Object: User [lstglog] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE USER [lstglog] FOR LOGIN [lstglog] WITH DEFAULT_SCHEMA=[dbo]
|
|
GO
|
|
/****** Object: User [lstggame] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE USER [lstggame] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
|
|
GO
|
|
/****** Object: Table [dbo].[GAME_LOG] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[GAME_LOG](
|
|
[RegDate] [datetime] NOT NULL,
|
|
[LogIDX] [bigint] IDENTITY(1,1) NOT NULL,
|
|
[LogType] [int] NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[UserID] [varchar](20) NOT NULL,
|
|
[UserName] [varchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[UserExp] [int] NOT NULL,
|
|
[CpType] [int] NOT NULL,
|
|
[TBLIDX] [int] NOT NULL,
|
|
[ObjCode] [int] NOT NULL,
|
|
[EventType] [tinyint] NOT NULL,
|
|
[Param1] [int] NOT NULL,
|
|
[Param2] [int] NOT NULL,
|
|
[Param3] [int] NOT NULL,
|
|
[Param4] [int] NOT NULL,
|
|
[Param5] [varchar](50) NOT NULL,
|
|
[UserIP] [varchar](15) NOT NULL,
|
|
CONSTRAINT [PK_GAME_LOG_LogIndex] PRIMARY KEY CLUSTERED
|
|
(
|
|
[RegDate] ASC,
|
|
[LogIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[Log_buy_gold_item] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Log_buy_gold_item](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickname] [varchar](12) NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](200) NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[Log_buy_item] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Log_buy_item](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[userID] [varchar](12) NOT NULL,
|
|
[applyType] [char](2) NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[playType] [int] NOT NULL,
|
|
[modeType] [int] NOT NULL,
|
|
[sub1Type] [int] NOT NULL,
|
|
[sub2Type] [int] NOT NULL,
|
|
[buyplace] [int] NULL,
|
|
[classType] [int] NOT NULL,
|
|
[kindred] [int] NOT NULL,
|
|
[decoType] [int] NOT NULL,
|
|
[decoCode] [int] NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[buyType] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[note] [varchar](100) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_regDate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [idx_regDate] ON [dbo].[Log_buy_item]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_buy_item_accessory] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_buy_item_accessory](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[eventType] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](100) NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_buy_item_accessory] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_buy_item_class] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_buy_item_class](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[classType] [int] NOT NULL,
|
|
[limitType] [int] NOT NULL,
|
|
[eventType] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](100) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_buy_item_costume] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_buy_item_costume](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[eventType] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](100) NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [CL_log_buy_item_costume] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [CL_log_buy_item_costume] ON [dbo].[log_buy_item_costume]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_buy_item_decoration] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_buy_item_decoration](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[classType] [int] NOT NULL,
|
|
[kindred] [int] NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[eventType] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](100) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_buy_item_equip] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_buy_item_equip](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[reinforce] [int] NOT NULL,
|
|
[machineType] [int] NOT NULL,
|
|
[limitDate] [int] NOT NULL,
|
|
[eventType] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](100) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_buy_item_gold] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_buy_item_gold](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[itemValue] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[cpType] [smallint] NOT NULL,
|
|
[billingID] [varchar](64) NULL,
|
|
[buyType] [tinyint] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](100) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_buy_item_sbox] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_buy_item_sbox](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[presentType] [smallint] NOT NULL,
|
|
[value1] [int] NOT NULL,
|
|
[value2] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[cpType] [smallint] NOT NULL,
|
|
[billingID] [varchar](64) NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [nvarchar](100) NULL,
|
|
[limitDate] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_buy_item_special] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_buy_item_special](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](15) NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[itemValue] [int] NOT NULL,
|
|
[eventType] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](100) NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_accessory_upgrade] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_accessory_upgrade](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[nowUpgradeValue] [int] NOT NULL,
|
|
[resultUpgradeValue] [int] NOT NULL,
|
|
[pieceCode] [int] NOT NULL,
|
|
[logType] [tinyint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_awake] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_awake](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[classType] [int] NOT NULL,
|
|
[pieceCode] [int] NOT NULL,
|
|
[pieceUseCount] [smallint] NOT NULL,
|
|
[awakeType] [tinyint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [CI_log_data_awake] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [CI_log_data_awake] ON [dbo].[log_data_awake]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_cardmatching] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_cardmatching](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[NickName] [nvarchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[LogType] [int] NOT NULL,
|
|
[MissionType] [int] NOT NULL,
|
|
[MissionMark1] [int] NOT NULL,
|
|
[MissionMark2] [int] NOT NULL,
|
|
[UserMark1] [int] NOT NULL,
|
|
[UserMark2] [int] NOT NULL,
|
|
[RewardStep] [int] NOT NULL,
|
|
[ItemType] [int] NOT NULL,
|
|
[ItemCode] [int] NOT NULL,
|
|
[ItemValue] [int] NOT NULL,
|
|
[RegDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_cardmatching] PRIMARY KEY CLUSTERED
|
|
(
|
|
[RegDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_character] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_character](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[playType] [int] NOT NULL,
|
|
[modeType] [int] NOT NULL,
|
|
[subType1] [int] NOT NULL,
|
|
[subType2] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[characterType] [int] NOT NULL,
|
|
[kill] [int] NOT NULL,
|
|
[death] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_cheating] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_cheating](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[userID] [varchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[userIP] [varchar](20) NOT NULL,
|
|
[mainIDX] [int] NOT NULL,
|
|
[subIDX] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_cheating] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_clover] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_clover](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[friendIDX] [int] NOT NULL,
|
|
[eventType] [smallint] NOT NULL,
|
|
[CloverCount] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_regDate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [idx_regDate] ON [dbo].[log_data_clover]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_custom_medal] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_custom_medal](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[MedalIDX] [int] NOT NULL,
|
|
[MedalCode] [int] NOT NULL,
|
|
[BasicGrowth1] [int] NOT NULL,
|
|
[BasicGrowth2] [int] NOT NULL,
|
|
[BasicGrowth3] [int] NOT NULL,
|
|
[BasicGrowth4] [int] NOT NULL,
|
|
[SkillGrowth1] [int] NOT NULL,
|
|
[SkillGrowth2] [int] NOT NULL,
|
|
[SkillGrowth3] [int] NOT NULL,
|
|
[SkillGrowth4] [int] NOT NULL,
|
|
[LimitType] [int] NOT NULL,
|
|
[LimitDate] [datetime] NOT NULL,
|
|
[LogType] [tinyint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_custom_medal] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_DiceGame] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_DiceGame](
|
|
[AccountIDX] [int] NOT NULL,
|
|
[GameState] [int] NOT NULL,
|
|
[DiceCountUsed] [int] NOT NULL,
|
|
[BoardCountUsed] [int] NOT NULL,
|
|
[RewardCountUsed] [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,
|
|
[StartTime] [datetime] NULL,
|
|
[EndTime] [datetime] NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_excavating_new] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_excavating_new](
|
|
[RegDate] [datetime] NOT NULL,
|
|
[LogIDX] [bigint] IDENTITY(1,1) NOT NULL,
|
|
[LogType] [int] NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[UserID] [varchar](20) NOT NULL,
|
|
[UserName] [varchar](20) NOT NULL,
|
|
[ExLevel] [int] NOT NULL,
|
|
[ExEXP] [int] NOT NULL,
|
|
[CType] [int] NOT NULL,
|
|
[CLevel] [int] NOT NULL,
|
|
[CExpert] [int] NOT NULL,
|
|
[RCount] [tinyint] NOT NULL,
|
|
[MapID] [int] NOT NULL,
|
|
[X] [int] NOT NULL,
|
|
[Y] [int] NOT NULL,
|
|
[Z] [int] NOT NULL,
|
|
[RewardType] [int] NOT NULL,
|
|
[Index] [int] NOT NULL,
|
|
[Price] [int] NOT NULL,
|
|
[Mutiple] [int] NOT NULL,
|
|
[ResultMoney] [int] NOT NULL,
|
|
[UserIP] [varchar](15) NOT NULL,
|
|
CONSTRAINT [PK_log_data_excavating_new_idx] PRIMARY KEY CLUSTERED
|
|
(
|
|
[RegDate] ASC,
|
|
[LogIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_gear_upgrade] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_gear_upgrade](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[gearCode] [int] NOT NULL,
|
|
[nowUpgradeValue] [tinyint] NOT NULL,
|
|
[resultUpgradeValue] [tinyint] NOT NULL,
|
|
[pieceCode] [int] NOT NULL,
|
|
[logType] [tinyint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [CL_log_data_gear_upgrade] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [CL_log_data_gear_upgrade] ON [dbo].[log_data_gear_upgrade]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_league_present] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_league_present](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[leagueIDX] [int] NOT NULL,
|
|
[currentRound] [tinyint] NOT NULL,
|
|
[presentCode1] [int] NOT NULL,
|
|
[presentCode2] [int] NOT NULL,
|
|
[presentCode3] [int] NOT NULL,
|
|
[presentCode4] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_localinfo] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_localinfo](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[os] [nvarchar](100) NOT NULL,
|
|
[ie] [nvarchar](100) NOT NULL,
|
|
[directx] [nvarchar](100) NOT NULL,
|
|
[cpu] [nvarchar](100) NOT NULL,
|
|
[gpu] [nvarchar](100) NOT NULL,
|
|
[memory] [nvarchar](100) NOT NULL,
|
|
[systemResolution] [nvarchar](20) NOT NULL,
|
|
[losaResolution] [nvarchar](20) NOT NULL,
|
|
[screenType] [tinyint] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
[hdd_serial] [nvarchar](100) NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_matchmode] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_matchmode](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[Tier1] [int] NOT NULL,
|
|
[Tier2] [int] NOT NULL,
|
|
[MatchTime] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
[RoomNumber] [int] NOT NULL,
|
|
CONSTRAINT [PK_log_data_matchmode] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_matchmode2] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_matchmode2](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[Tier1] [int] NOT NULL,
|
|
[Tier2] [int] NOT NULL,
|
|
[MatchTime] [int] NOT NULL,
|
|
[MatchPoint] [int] NOT NULL,
|
|
[WinningStreakCount] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[MatchType] [int] NOT NULL,
|
|
[RoomNumber] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_matchmode2] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_medal] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_medal](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[medalType] [int] NOT NULL,
|
|
[limitType] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_regDate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [idx_regDate] ON [dbo].[log_data_medal]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_medal_extend] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_medal_extend](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[classType] [int] NOT NULL,
|
|
[slotNum] [tinyint] NOT NULL,
|
|
[period] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_oakbarrel] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_oakbarrel](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[NickName] [nvarchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[ItemType] [int] NOT NULL,
|
|
[ItemCode] [int] NOT NULL,
|
|
[ItemValue] [int] NOT NULL,
|
|
[SwordCount] [int] NOT NULL,
|
|
[LogType] [int] NOT NULL,
|
|
[RegDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_oakbarrel] PRIMARY KEY CLUSTERED
|
|
(
|
|
[RegDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_pcroom] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_pcroom](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[pcnum] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[pcrType] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_peso] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_peso](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[peso] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_pet] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_pet](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[petIDX] [int] NOT NULL,
|
|
[petCode] [int] NOT NULL,
|
|
[petRank] [tinyint] NOT NULL,
|
|
[petLevel] [int] NOT NULL,
|
|
[petExp] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[logType] [tinyint] NOT NULL,
|
|
[logSubType] [int] NOT NULL,
|
|
[logNote] [varchar](200) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [CI_log_data_pet] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [CI_log_data_pet] ON [dbo].[log_data_pet]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_piece_divide] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_piece_divide](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[materialCode] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_piece_mix] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_piece_mix](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[mixType] [smallint] NOT NULL,
|
|
[mixCode] [int] NOT NULL,
|
|
[resultType] [tinyint] NOT NULL,
|
|
[useA] [int] NOT NULL,
|
|
[useB] [int] NOT NULL,
|
|
[resultA] [int] NOT NULL,
|
|
[resultB] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_piece_obtain] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_piece_obtain](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](50) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[step] [tinyint] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_play] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_play](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[playType] [int] NOT NULL,
|
|
[modeType] [int] NOT NULL,
|
|
[subType1] [int] NOT NULL,
|
|
[subType2] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[deathTime] [int] NOT NULL,
|
|
[peso] [int] NOT NULL,
|
|
[win] [int] NOT NULL,
|
|
[lose] [int] NOT NULL,
|
|
[kill] [int] NOT NULL,
|
|
[death] [int] NOT NULL,
|
|
[roomNumber] [int] NOT NULL,
|
|
[contribution] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[pcnum] [int] NOT NULL,
|
|
[blueTeamMember] [int] NOT NULL,
|
|
[redTeamMember] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_play_regDate] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_play_old] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_play_old](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[playType] [int] NOT NULL,
|
|
[modeType] [int] NOT NULL,
|
|
[subType1] [int] NOT NULL,
|
|
[subType2] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[deathTime] [int] NOT NULL,
|
|
[peso] [int] NOT NULL,
|
|
[win] [int] NOT NULL,
|
|
[lose] [int] NOT NULL,
|
|
[kill] [int] NOT NULL,
|
|
[death] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[pcnum] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_quest] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_quest](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[mainIDX] [int] NOT NULL,
|
|
[subIDX] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_quest_vfun] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_quest_vfun](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[mainIDX] [int] NOT NULL,
|
|
[subIDX] [int] NOT NULL,
|
|
[channelingType] [int] NOT NULL,
|
|
[success] [int] NOT NULL,
|
|
[reason] [varchar](256) NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_roominfo] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_roominfo](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[RoomNumber] [int] NOT NULL,
|
|
[BlueWin] [int] NOT NULL,
|
|
[BlueLose] [int] NOT NULL,
|
|
[BlueTeamMember] [int] NOT NULL,
|
|
[RedWin] [int] NOT NULL,
|
|
[RedLose] [int] NOT NULL,
|
|
[RedTeamMember] [int] NOT NULL,
|
|
[PlayType] [int] NOT NULL,
|
|
[ModeType] [int] NOT NULL,
|
|
[ModeSubType] [int] NOT NULL,
|
|
[RegDate] [datetime] NOT NULL,
|
|
[Tier1] [int] NOT NULL,
|
|
[Tier2] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
CONSTRAINT [PK_log_data_roominfo] PRIMARY KEY CLUSTERED
|
|
(
|
|
[RegDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_spirit_change] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_spirit_change](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[NickName] [nvarchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[SetSpiritCode] [int] NOT NULL,
|
|
[SetSpiritCount] [int] NOT NULL,
|
|
[GetSpiritCode] [int] NOT NULL,
|
|
[GetSpiritCount] [int] NOT NULL,
|
|
[CriticalType] [tinyint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_spirit_change] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_spirit_divide] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_spirit_divide](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[NickName] [nvarchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[HeroType] [int] NOT NULL,
|
|
[SpiritCode] [int] NOT NULL,
|
|
[SpiritCount] [int] NOT NULL,
|
|
[SoulStoneCount] [int] NOT NULL,
|
|
[CriticalType] [tinyint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_spirit_divide] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_spirit_mix] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_spirit_mix](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[NickName] [nvarchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[HeroType] [int] NOT NULL,
|
|
[SpiritCode] [int] NOT NULL,
|
|
[SpiritCount] [int] NOT NULL,
|
|
[UnknownSpiritCode] [int] NOT NULL,
|
|
[UnknownSpiritCount] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_spirit_mix] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_spirit_obtain] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_spirit_obtain](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[NickName] [nvarchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[SpiritCode] [int] NOT NULL,
|
|
[SpiritCount] [int] NOT NULL,
|
|
[Value] [int] NOT NULL,
|
|
[logType] [tinyint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_spirit_obtain] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_spirit_peso] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_spirit_peso](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[NickName] [nvarchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[PieceCount] [int] NOT NULL,
|
|
[DimensionCount] [int] NOT NULL,
|
|
[Peso] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_data_spirit_peso] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_time] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_time](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_trade] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_trade](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickname] [varchar](20) NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[value1] [int] NOT NULL,
|
|
[value2] [int] NOT NULL,
|
|
[price] [bigint] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[userIP] [varchar](16) NULL,
|
|
[note] [varchar](100) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_data_tutorial] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_data_tutorial](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [varchar](20) NOT NULL,
|
|
[step] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_define] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_define](
|
|
[objName] [varchar](32) NOT NULL,
|
|
[code] [int] NOT NULL,
|
|
[itemNameKO] [varchar](100) NULL,
|
|
[itemNameID] [varchar](100) NULL,
|
|
[itemNameEN] [varchar](100) NULL,
|
|
CONSTRAINT [PK_define_manage] PRIMARY KEY CLUSTERED
|
|
(
|
|
[objName] ASC,
|
|
[code] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_error_billing] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_error_billing](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[cpType] [smallint] NOT NULL,
|
|
[errType] [int] NOT NULL,
|
|
[note] [varchar](200) NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_event_bingo] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_event_bingo](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[choiceType] [tinyint] NOT NULL,
|
|
[number] [tinyint] NOT NULL,
|
|
[stateType] [tinyint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_event_cash] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_event_cash](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickName] [nvarchar](20) NOT NULL,
|
|
[userLevel] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[amount] [int] NOT NULL,
|
|
[eventType] [tinyint] NOT NULL,
|
|
[userIP] [nvarchar](16) NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[Log_game_concurrent] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Log_game_concurrent](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[serverID] [bigint] NOT NULL,
|
|
[serverIP] [varchar](15) NOT NULL,
|
|
[serverPort] [int] NOT NULL,
|
|
[serverName] [varchar](32) NULL,
|
|
[concurrent] [int] NOT NULL,
|
|
[cpType] [smallint] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_regDate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [idx_regDate] ON [dbo].[Log_game_concurrent]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[Log_play_character] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Log_play_character](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[userID] [varchar](12) NOT NULL,
|
|
[playType] [int] NOT NULL,
|
|
[modeType] [int] NOT NULL,
|
|
[sub1Type] [int] NOT NULL,
|
|
[sub2Type] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[characterType] [int] NOT NULL,
|
|
[cnt_kill] [int] NOT NULL,
|
|
[cnt_killed] [int] NOT NULL,
|
|
[cnt_selfkilled] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_regDate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [idx_regDate] ON [dbo].[Log_play_character]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[Log_play_game] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Log_play_game](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[userID] [varchar](12) NOT NULL,
|
|
[playType] [int] NOT NULL,
|
|
[modeType] [int] NOT NULL,
|
|
[sub1Type] [int] NOT NULL,
|
|
[sub2Type] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[deathTime] [int] NOT NULL,
|
|
[basicPeso] [int] NOT NULL,
|
|
[total_peso] [int] NOT NULL,
|
|
[total_emblem] [int] NOT NULL,
|
|
[total_play_num] [int] NOT NULL,
|
|
[total_round] [int] NOT NULL,
|
|
[total_contribute] [int] NOT NULL,
|
|
[total_win] [int] NOT NULL,
|
|
[total_lose] [int] NOT NULL,
|
|
[cnt_kill] [int] NOT NULL,
|
|
[cnt_killed] [int] NOT NULL,
|
|
[cnt_selfkilled] [int] NOT NULL,
|
|
[logType] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_regDate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [idx_regDate] ON [dbo].[Log_play_game]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[Log_play_tutorial] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Log_play_tutorial](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[userID] [varchar](12) NOT NULL,
|
|
[step] [int] NOT NULL,
|
|
[playTime] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_regDate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [idx_regDate] ON [dbo].[Log_play_tutorial]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_present] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_present](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickname] [varchar](20) NOT NULL,
|
|
[receiveIDX] [int] NOT NULL,
|
|
[presentType] [smallint] NOT NULL,
|
|
[value1] [int] NOT NULL,
|
|
[value2] [int] NOT NULL,
|
|
[eventType] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](100) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[Log_system_info] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Log_system_info](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[logType] [varchar](32) NULL,
|
|
[serverIP] [varchar](15) NULL,
|
|
[concurrent] [int] NULL,
|
|
[cpu] [int] NULL,
|
|
[memory] [int] NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_regDate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE CLUSTERED INDEX [idx_regDate] ON [dbo].[Log_system_info]
|
|
(
|
|
[regDate] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_temp_bckim] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_temp_bckim](
|
|
[accountIDX] [int] NULL,
|
|
[regdate] [datetime] NULL,
|
|
[regdate_str] [varchar](10) NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_trace_prisoner_option] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_trace_prisoner_option](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[BlueMember] [int] NOT NULL,
|
|
[RedMember] [int] NOT NULL,
|
|
[BlueMaxMember] [int] NOT NULL,
|
|
[RedMaxMember] [int] NOT NULL,
|
|
[TeamMixOption] [int] NOT NULL,
|
|
[regDate] [datetime] NOT NULL,
|
|
[closedRoomOption] [int] NOT NULL,
|
|
[userModeOption] [int] NOT NULL,
|
|
CONSTRAINT [PK_log_trace_prisoner_option] PRIMARY KEY CLUSTERED
|
|
(
|
|
[regDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[log_trace_prisoner_start] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[log_trace_prisoner_start](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[ServerID] [bigint] NOT NULL,
|
|
[MakeRoom] [int] NOT NULL,
|
|
[QuickStart] [int] NOT NULL,
|
|
[ListSelect] [int] NOT NULL,
|
|
[RegDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_log_trace_prisoner_start] PRIMARY KEY CLUSTERED
|
|
(
|
|
[RegDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[Log_use_item] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[Log_use_item](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[accountIDX] [int] NOT NULL,
|
|
[nickname] [varchar](20) NOT NULL,
|
|
[itemType] [int] NOT NULL,
|
|
[itemCode] [int] NOT NULL,
|
|
[rowIDX] [int] NOT NULL,
|
|
[colIDX] [int] NOT NULL,
|
|
[userIP] [varchar](15) NOT NULL,
|
|
[note] [varchar](200) NULL,
|
|
[regDate] [datetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM](
|
|
[AccountIDX] [int] NOT NULL,
|
|
[Term_05220612] [int] NULL,
|
|
[Term_06120619] [int] NULL,
|
|
[Term_05220619] [int] NULL,
|
|
[progress] [int] NULL,
|
|
[result] [int] NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM_logdate] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM_logdate](
|
|
[AccountIDX] [int] NOT NULL,
|
|
[logincnt] [int] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM_progress] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM_progress](
|
|
[AccountIDX] [int] NOT NULL,
|
|
[progress] [int] NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[SQL_ERROR_LOG] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[SQL_ERROR_LOG](
|
|
[ErrorID] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[ErrorNo] [int] NOT NULL,
|
|
[ErrorProcedure] [varchar](50) NULL,
|
|
[ErrorLine] [int] NULL,
|
|
[ErrorServerity] [int] NULL,
|
|
[ErrorState] [int] NULL,
|
|
[ErrorMessage] [varchar](500) NOT NULL,
|
|
[ErrorTime] [datetime] NOT NULL,
|
|
PRIMARY KEY CLUSTERED
|
|
(
|
|
[ErrorID] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[TBL_LOG_HACK] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[TBL_LOG_HACK](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[NickName] [nvarchar](20) NOT NULL,
|
|
[UserLevel] [int] NOT NULL,
|
|
[PlayType] [int] NOT NULL,
|
|
[ModeType] [int] NOT NULL,
|
|
[SubType1] [int] NOT NULL,
|
|
[SubType2] [int] NOT NULL,
|
|
[ItemType] [int] NOT NULL,
|
|
[ItemCode] [int] NOT NULL,
|
|
[ItemValue] [int] NOT NULL,
|
|
[RegDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_TBL_LOG_HACK] PRIMARY KEY CLUSTERED
|
|
(
|
|
[RegDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Table [dbo].[TBL_LOG_HACK_MESSAGE] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE TABLE [dbo].[TBL_LOG_HACK_MESSAGE](
|
|
[idx] [int] IDENTITY(1,1) NOT NULL,
|
|
[AccountIDX] [int] NOT NULL,
|
|
[Msg] [nvarchar](1000) NOT NULL,
|
|
[RegDate] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_TBL_LOG_HACK_MESSAGE] PRIMARY KEY CLUSTERED
|
|
(
|
|
[RegDate] ASC,
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
SET ANSI_PADDING ON
|
|
GO
|
|
/****** Object: Index [idx_userID] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_userID] ON [dbo].[Log_buy_item]
|
|
(
|
|
[userID] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_buy_item_accessory_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_buy_item_accessory_accountIDX] ON [dbo].[log_buy_item_accessory]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_buy_item_costume_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_buy_item_costume_accountIDX] ON [dbo].[log_buy_item_costume]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_awake_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_awake_accountIDX] ON [dbo].[log_data_awake]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_awake_idx] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_awake_idx] ON [dbo].[log_data_awake]
|
|
(
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_cheating_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_cheating_accountIDX] ON [dbo].[log_data_cheating]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_accountIDX] ON [dbo].[log_data_clover]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_eventType] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_eventType] ON [dbo].[log_data_clover]
|
|
(
|
|
[eventType] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_excavating_new_AccountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_excavating_new_AccountIDX] ON [dbo].[log_data_excavating_new]
|
|
(
|
|
[AccountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_pet_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_pet_accountIDX] ON [dbo].[log_data_gear_upgrade]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_pet_idx] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_pet_idx] ON [dbo].[log_data_gear_upgrade]
|
|
(
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_accountIDX] ON [dbo].[log_data_medal]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [idx_eventType] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_eventType] ON [dbo].[log_data_medal]
|
|
(
|
|
[logType] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_oakbarrel_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_oakbarrel_accountIDX] ON [dbo].[log_data_oakbarrel]
|
|
(
|
|
[AccountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NX_log_data_pet_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NX_log_data_pet_accountIDX] ON [dbo].[log_data_pet]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NX_log_data_pet_idx] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NX_log_data_pet_idx] ON [dbo].[log_data_pet]
|
|
(
|
|
[idx] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NX_log_data_play_accountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NX_log_data_play_accountIDX] ON [dbo].[log_data_play]
|
|
(
|
|
[accountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NX_log_data_play_logType] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NX_log_data_play_logType] ON [dbo].[log_data_play]
|
|
(
|
|
[logType] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_spirit_change_AccountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_spirit_change_AccountIDX] ON [dbo].[log_data_spirit_change]
|
|
(
|
|
[AccountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_spirit_divide_AccountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_spirit_divide_AccountIDX] ON [dbo].[log_data_spirit_divide]
|
|
(
|
|
[AccountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_spirit_mix_AccountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_spirit_mix_AccountIDX] ON [dbo].[log_data_spirit_mix]
|
|
(
|
|
[AccountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_spirit_obtain_AccountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_spirit_obtain_AccountIDX] ON [dbo].[log_data_spirit_obtain]
|
|
(
|
|
[AccountIDX] ASC,
|
|
[logType] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_log_data_spirit_peso_AccountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_log_data_spirit_peso_AccountIDX] ON [dbo].[log_data_spirit_peso]
|
|
(
|
|
[AccountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
SET ANSI_PADDING ON
|
|
GO
|
|
/****** Object: Index [idx_userID] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_userID] ON [dbo].[Log_play_character]
|
|
(
|
|
[userID] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
SET ANSI_PADDING ON
|
|
GO
|
|
/****** Object: Index [idx_userID] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_userID] ON [dbo].[Log_play_game]
|
|
(
|
|
[userID] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
SET ANSI_PADDING ON
|
|
GO
|
|
/****** Object: Index [idx_userID] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_userID] ON [dbo].[Log_play_tutorial]
|
|
(
|
|
[userID] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
SET ANSI_PADDING ON
|
|
GO
|
|
/****** Object: Index [idx_logType] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [idx_logType] ON [dbo].[Log_system_info]
|
|
(
|
|
[logType] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_TBL_LOG_HACK_AccountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_TBL_LOG_HACK_AccountIDX] ON [dbo].[TBL_LOG_HACK]
|
|
(
|
|
[AccountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
/****** Object: Index [NC_TBL_LOG_HACK_MESSAGE_AccountIDX] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
CREATE NONCLUSTERED INDEX [NC_TBL_LOG_HACK_MESSAGE_AccountIDX] ON [dbo].[TBL_LOG_HACK_MESSAGE]
|
|
(
|
|
[AccountIDX] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_gold_item] ADD CONSTRAINT [DF_Log_buy_gold_item_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_gold_item] ADD CONSTRAINT [DF_Log_buy_gold_item_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_gold_item] ADD CONSTRAINT [DF_Log_buy_gold_item_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_gold_item] ADD CONSTRAINT [DF_Log_buy_gold_item_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_playType] DEFAULT ((0)) FOR [playType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_modeType] DEFAULT ((0)) FOR [modeType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_sub1Type] DEFAULT ((0)) FOR [sub1Type]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_sub2Type] DEFAULT ((0)) FOR [sub2Type]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_buyplace] DEFAULT ((0)) FOR [buyplace]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_classType] DEFAULT ((0)) FOR [classType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_kindred] DEFAULT ((-1)) FOR [kindred]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_decoType] DEFAULT ((-1)) FOR [decoType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_decoCode] DEFAULT ((-1)) FOR [decoCode]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_buyType] DEFAULT ((0)) FOR [buyType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_buy_item] ADD CONSTRAINT [DF_Log_buy_item_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_accessory] ADD DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_accessory] ADD DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_accessory] ADD DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_accessory] ADD DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_accessory] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_class] ADD CONSTRAINT [DF_log_buy_item_class_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_class] ADD CONSTRAINT [DF_log_buy_item_class_classType] DEFAULT ((0)) FOR [classType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_class] ADD CONSTRAINT [DF_log_buy_item_class_limitType] DEFAULT ((0)) FOR [limitType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_class] ADD CONSTRAINT [DF_log_buy_item_class_eventType] DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_class] ADD CONSTRAINT [DF_log_buy_item_class_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_class] ADD CONSTRAINT [DF_log_buy_item_class_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_costume] ADD CONSTRAINT [DF_log_buy_item_costume_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_costume] ADD CONSTRAINT [DF_log_buy_item_costume_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_costume] ADD CONSTRAINT [DF_log_buy_item_costume_eventType] DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_costume] ADD CONSTRAINT [DF_log_buy_item_costume_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_costume] ADD CONSTRAINT [DF_log_buy_item_costume_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_decoration] ADD CONSTRAINT [DF_log_buy_item_decoration_classType] DEFAULT ((0)) FOR [classType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_decoration] ADD CONSTRAINT [DF_log_buy_item_decoration_kindred] DEFAULT ((0)) FOR [kindred]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_decoration] ADD CONSTRAINT [DF_log_buy_item_decoration_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_decoration] ADD CONSTRAINT [DF_log_buy_item_decoration_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_decoration] ADD CONSTRAINT [DF_log_buy_item_decoration_eventType] DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_decoration] ADD CONSTRAINT [DF_log_buy_item_decoration_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_decoration] ADD CONSTRAINT [DF_log_buy_item_decoration_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_equip] ADD CONSTRAINT [DF_log_buy_item_equip_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_equip] ADD CONSTRAINT [DF_log_buy_item_equip_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_equip] ADD CONSTRAINT [DF_log_buy_item_equip_reinforce] DEFAULT ((0)) FOR [reinforce]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_equip] ADD CONSTRAINT [DF_log_buy_item_equip_machineType] DEFAULT ((0)) FOR [machineType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_equip] ADD CONSTRAINT [DF_log_buy_item_equip_limitDate] DEFAULT ((0)) FOR [limitDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_equip] ADD CONSTRAINT [DF_log_buy_item_equip_eventType] DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_equip] ADD CONSTRAINT [DF_log_buy_item_equip_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_equip] ADD CONSTRAINT [DF_log_buy_item_equip_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_gold] ADD CONSTRAINT [DF_log_buy_item_gold_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_gold] ADD CONSTRAINT [DF_log_buy_item_gold_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_gold] ADD CONSTRAINT [DF_log_buy_item_gold_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_gold] ADD CONSTRAINT [DF_log_buy_item_gold_itemValue] DEFAULT ((0)) FOR [itemValue]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_gold] ADD CONSTRAINT [DF_log_buy_item_gold_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_gold] ADD CONSTRAINT [DF_log_buy_item_gold_cpType] DEFAULT ((0)) FOR [cpType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_gold] ADD CONSTRAINT [DF_log_buy_item_gold_buyType] DEFAULT ((0)) FOR [buyType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_gold] ADD CONSTRAINT [DF_log_buy_item_gold_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_presentType] DEFAULT ((0)) FOR [presentType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_value1] DEFAULT ((0)) FOR [value1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_value2] DEFAULT ((0)) FOR [value2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_cpType] DEFAULT ((0)) FOR [cpType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_billingID] DEFAULT ((0)) FOR [billingID]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_sbox] ADD CONSTRAINT [DF_log_buy_item_sbox_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_special] ADD CONSTRAINT [DF_log_buy_item_special_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_special] ADD CONSTRAINT [DF_log_buy_item_special_itemValue] DEFAULT ((0)) FOR [itemValue]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_special] ADD CONSTRAINT [DF_log_buy_item_special_eventType] DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_special] ADD CONSTRAINT [DF_log_buy_item_special_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_buy_item_special] ADD CONSTRAINT [DF_log_buy_item_special_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_accessory_upgrade] ADD CONSTRAINT [DF__log_data___userL__7FD5EEA5] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_accessory_upgrade] ADD CONSTRAINT [DF__log_data___itemC__00CA12DE] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_accessory_upgrade] ADD CONSTRAINT [DF__log_data___nowUp__01BE3717] DEFAULT ((0)) FOR [nowUpgradeValue]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_accessory_upgrade] ADD CONSTRAINT [DF__log_data___resul__02B25B50] DEFAULT ((0)) FOR [resultUpgradeValue]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_accessory_upgrade] ADD CONSTRAINT [DF__log_data___piece__03A67F89] DEFAULT ((0)) FOR [pieceCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_accessory_upgrade] ADD CONSTRAINT [DF__log_data___logTy__049AA3C2] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_accessory_upgrade] ADD CONSTRAINT [DF__log_data___regDa__058EC7FB] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_awake] ADD DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_awake] ADD DEFAULT ((0)) FOR [classType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_awake] ADD DEFAULT ((0)) FOR [pieceCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_awake] ADD DEFAULT ((0)) FOR [pieceUseCount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_awake] ADD DEFAULT ((0)) FOR [awakeType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_awake] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [LogType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [MissionType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [MissionMark1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [MissionMark2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [UserMark1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [UserMark2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [RewardStep]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [ItemType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [ItemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT ((0)) FOR [ItemValue]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cardmatching] ADD DEFAULT (getdate()) FOR [RegDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_playType] DEFAULT ((0)) FOR [playType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_modeType] DEFAULT ((0)) FOR [modeType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_subType1] DEFAULT ((0)) FOR [subType1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_subType2] DEFAULT ((0)) FOR [subType2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_characterType] DEFAULT ((0)) FOR [characterType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_kill] DEFAULT ((0)) FOR [kill]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_death] DEFAULT ((0)) FOR [death]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_character] ADD CONSTRAINT [DF_log_data_character_regDate] DEFAULT ((0)) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cheating] ADD DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cheating] ADD DEFAULT ((0)) FOR [mainIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cheating] ADD DEFAULT ((0)) FOR [subIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_cheating] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_clover] ADD DEFAULT ((0)) FOR [friendIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_clover] ADD DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_clover] ADD DEFAULT ((0)) FOR [CloverCount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_clover] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [AccountIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [MedalIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [MedalCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [BasicGrowth1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [BasicGrowth2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [BasicGrowth3]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [BasicGrowth4]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [SkillGrowth1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [SkillGrowth2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [SkillGrowth3]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [SkillGrowth4]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [LimitType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT ((0)) FOR [LogType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_custom_medal] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_gear_upgrade] ADD DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_gear_upgrade] ADD DEFAULT ((0)) FOR [gearCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_gear_upgrade] ADD DEFAULT ((0)) FOR [nowUpgradeValue]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_gear_upgrade] ADD DEFAULT ((0)) FOR [resultUpgradeValue]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_gear_upgrade] ADD DEFAULT ((0)) FOR [pieceCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_gear_upgrade] ADD DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_gear_upgrade] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_league_present] ADD CONSTRAINT [DF_log_data_league_present_leagueIDX] DEFAULT ((0)) FOR [leagueIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_league_present] ADD CONSTRAINT [DF_log_data_league_present_presentCode1] DEFAULT ((0)) FOR [presentCode1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_league_present] ADD CONSTRAINT [DF_log_data_league_present_presentCode2] DEFAULT ((0)) FOR [presentCode2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_league_present] ADD CONSTRAINT [DF_log_data_league_present_presentCode3] DEFAULT ((0)) FOR [presentCode3]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_league_present] ADD CONSTRAINT [DF_log_data_league_present_presentCode4] DEFAULT ((0)) FOR [presentCode4]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_league_present] ADD CONSTRAINT [DF_log_data_league_present_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_localinfo] ADD CONSTRAINT [DF_log_data_localinfo_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_localinfo] ADD CONSTRAINT [DF_log_data_localinfo_systemResolution] DEFAULT ((0)) FOR [systemResolution]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_localinfo] ADD CONSTRAINT [DF_log_data_localinfo_losaResolution] DEFAULT ((0)) FOR [losaResolution]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_localinfo] ADD CONSTRAINT [DF_log_data_localinfo_screenType] DEFAULT ((0)) FOR [screenType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_localinfo] ADD CONSTRAINT [DF_log_data_localinfo_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_localinfo] ADD DEFAULT (NULL) FOR [hdd_serial]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode] ADD DEFAULT ((0)) FOR [MatchTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode] ADD DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode] ADD DEFAULT ((0)) FOR [RoomNumber]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode2] ADD CONSTRAINT [DF__log_data___Match__43F60EC8] DEFAULT ((0)) FOR [MatchTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode2] ADD CONSTRAINT [DF_log_data_matchmode2_MatchPoint] DEFAULT ((0)) FOR [MatchPoint]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode2] ADD CONSTRAINT [DF__log_data___Winni__44EA3301] DEFAULT ((0)) FOR [WinningStreakCount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode2] ADD CONSTRAINT [DF__log_data___logTy__45DE573A] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode2] ADD CONSTRAINT [DF_log_data_matchmode2_MatchType] DEFAULT ((0)) FOR [MatchType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode2] ADD CONSTRAINT [DF__log_data___RoomN__46D27B73] DEFAULT ((0)) FOR [RoomNumber]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_matchmode2] ADD CONSTRAINT [DF__log_data___regDa__47C69FAC] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_medal] ADD DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_medal] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_medal_extend] ADD CONSTRAINT [DF_log_data_medal_extend_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_medal_extend] ADD CONSTRAINT [DF_log_data_medal_extend_classType] DEFAULT ((0)) FOR [classType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_medal_extend] ADD CONSTRAINT [DF_log_data_medal_extend_slotNum] DEFAULT ((0)) FOR [slotNum]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_medal_extend] ADD CONSTRAINT [DF_log_data_medal_extend_period] DEFAULT ((0)) FOR [period]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_medal_extend] ADD CONSTRAINT [DF_log_data_medal_extend_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_medal_extend] ADD CONSTRAINT [DF_log_data_medal_extend_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_oakbarrel] ADD DEFAULT ((0)) FOR [ItemType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_oakbarrel] ADD DEFAULT ((0)) FOR [ItemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_oakbarrel] ADD DEFAULT ((0)) FOR [ItemValue]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_oakbarrel] ADD DEFAULT ((0)) FOR [SwordCount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_oakbarrel] ADD DEFAULT ((0)) FOR [LogType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_oakbarrel] ADD DEFAULT (getdate()) FOR [RegDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pcroom] ADD CONSTRAINT [DF_log_data_pcroom_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pcroom] ADD CONSTRAINT [DF_log_data_pcroom_pcnum] DEFAULT ((0)) FOR [pcnum]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pcroom] ADD CONSTRAINT [DF_log_data_pcroom_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pcroom] ADD CONSTRAINT [DF_log_data_pcroom_pcrType] DEFAULT ((0)) FOR [pcrType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pcroom] ADD CONSTRAINT [DF_log_data_pcroom_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_peso] ADD CONSTRAINT [DF_log_data_peso_peso] DEFAULT ((0)) FOR [peso]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_peso] ADD CONSTRAINT [DF_log_data_peso_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_peso] ADD CONSTRAINT [DF_log_data_peso_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF_log_data_pet_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF__log_data___petCo__23BE4960] DEFAULT ((0)) FOR [petCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF__log_data___petRa__24B26D99] DEFAULT ((0)) FOR [petRank]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF__log_data___petLe__25A691D2] DEFAULT ((0)) FOR [petLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF__log_data___petEx__269AB60B] DEFAULT ((0)) FOR [petExp]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF_log_data_pet_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF__log_data___logTy__278EDA44] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF__log_data___logSu__2882FE7D] DEFAULT ((0)) FOR [logSubType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_pet] ADD CONSTRAINT [DF__log_data___regDa__297722B6] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_divide] ADD CONSTRAINT [DF_log_data_piece_divide_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_divide] ADD CONSTRAINT [DF_log_data_piece_divide_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_divide] ADD CONSTRAINT [DF_log_data_piece_divide_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_divide] ADD CONSTRAINT [DF_log_data_piece_divide_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_divide] ADD CONSTRAINT [DF_log_data_piece_divide_materialType] DEFAULT ((0)) FOR [materialCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_divide] ADD CONSTRAINT [DF_log_data_piece_divide_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_futionType] DEFAULT ((0)) FOR [mixType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_futionCode] DEFAULT ((0)) FOR [mixCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_resultType] DEFAULT ((0)) FOR [resultType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_useA] DEFAULT ((0)) FOR [useA]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_useB] DEFAULT ((0)) FOR [useB]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_resultA] DEFAULT ((0)) FOR [resultA]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_resultB] DEFAULT ((0)) FOR [resultB]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_mix] ADD CONSTRAINT [DF_log_data_piece_fusion_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_obtain] ADD CONSTRAINT [DF_log_data_piece_obtain_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_obtain] ADD CONSTRAINT [DF_log_data_piece_obtain_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_obtain] ADD CONSTRAINT [DF_log_data_piece_obtain_step] DEFAULT ((0)) FOR [step]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_obtain] ADD CONSTRAINT [DF_log_data_piece_obtain_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_piece_obtain] ADD CONSTRAINT [DF_log_data_piece_obtain_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___playT__0F824689] DEFAULT ((0)) FOR [playType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___modeT__10766AC2] DEFAULT ((0)) FOR [modeType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___subTy__116A8EFB] DEFAULT ((0)) FOR [subType1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___subTy__125EB334] DEFAULT ((0)) FOR [subType2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___playT__1352D76D] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___death__1446FBA6] DEFAULT ((0)) FOR [deathTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data_p__peso__153B1FDF] DEFAULT ((0)) FOR [peso]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data_pl__win__162F4418] DEFAULT ((0)) FOR [win]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data_p__lose__17236851] DEFAULT ((0)) FOR [lose]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data_p__kill__18178C8A] DEFAULT ((0)) FOR [kill]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___death__190BB0C3] DEFAULT ((0)) FOR [death]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___roomN__19FFD4FC] DEFAULT ((0)) FOR [roomNumber]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___contr__1AF3F935] DEFAULT ((0)) FOR [contribution]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___logTy__1BE81D6E] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___pcnum__1CDC41A7] DEFAULT ((0)) FOR [pcnum]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF_log_data_play_blueTeamMember] DEFAULT ((0)) FOR [blueTeamMember]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF_log_data_play_redTeamMember] DEFAULT ((0)) FOR [redTeamMember]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play] ADD CONSTRAINT [DF__log_data___regDa__1DD065E0] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_playType] DEFAULT ((0)) FOR [playType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_modeType] DEFAULT ((0)) FOR [modeType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_subType1] DEFAULT ((0)) FOR [subType1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_subType2] DEFAULT ((0)) FOR [subType2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_deathTime] DEFAULT ((0)) FOR [deathTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_peso] DEFAULT ((0)) FOR [peso]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_win] DEFAULT ((0)) FOR [win]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_lose] DEFAULT ((0)) FOR [lose]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_kill] DEFAULT ((0)) FOR [kill]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_death] DEFAULT ((0)) FOR [death]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_pcnum] DEFAULT ((0)) FOR [pcnum]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_play_old] ADD CONSTRAINT [DF_log_data_play_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest] ADD CONSTRAINT [DF_log_data_quest_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest] ADD CONSTRAINT [DF_log_data_quest_mainIDX] DEFAULT ((0)) FOR [mainIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest] ADD CONSTRAINT [DF_log_data_quest_subIDX] DEFAULT ((0)) FOR [subIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest] ADD CONSTRAINT [DF_log_data_quest_questType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest] ADD CONSTRAINT [DF_log_data_quest_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest_vfun] ADD CONSTRAINT [DF_log_data_quest_vfun_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest_vfun] ADD CONSTRAINT [DF_log_data_quest_vfun_mainIDX] DEFAULT ((0)) FOR [mainIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest_vfun] ADD CONSTRAINT [DF_log_data_quest_vfun_subIDX] DEFAULT ((0)) FOR [subIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_quest_vfun] ADD CONSTRAINT [DF_log_data_quest_vfun_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [RoomNumber]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [BlueWin]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [BlueLose]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [BlueTeamMember]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [RedWin]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [RedLose]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [RedTeamMember]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [PlayType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [ModeType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [ModeSubType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT (getdate()) FOR [RegDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [Tier1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD DEFAULT ((0)) FOR [Tier2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD CONSTRAINT [DF_log_data_roominfo_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_roominfo] ADD CONSTRAINT [DF_log_data_roominfo_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_spirit_change] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_spirit_divide] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_spirit_mix] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_spirit_obtain] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_spirit_peso] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_time] ADD CONSTRAINT [DF_log_data_time_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_time] ADD CONSTRAINT [DF_log_data_time_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_time] ADD CONSTRAINT [DF_log_data_time_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_trade] ADD CONSTRAINT [DF_log_data_trade_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_trade] ADD CONSTRAINT [DF_log_data_trade_value1] DEFAULT ((0)) FOR [value1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_trade] ADD CONSTRAINT [DF_log_data_trade_value2] DEFAULT ((0)) FOR [value2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_trade] ADD CONSTRAINT [DF_log_data_trade_price] DEFAULT ((0)) FOR [price]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_trade] ADD CONSTRAINT [DF_log_data_trade_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_trade] ADD CONSTRAINT [DF_log_data_trade_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_tutorial] ADD CONSTRAINT [DF_log_data_tutorial_step] DEFAULT ((0)) FOR [step]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_tutorial] ADD CONSTRAINT [DF_log_data_tutorial_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[log_data_tutorial] ADD CONSTRAINT [DF_log_data_tutorial_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_error_billing] ADD CONSTRAINT [DF_log_error_billing_cpType] DEFAULT ((0)) FOR [cpType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_error_billing] ADD CONSTRAINT [DF_log_error_billing_errType] DEFAULT ((0)) FOR [errType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_error_billing] ADD CONSTRAINT [DF_log_error_billing_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_event_bingo] ADD CONSTRAINT [DF_log_event_bingo_choiceType] DEFAULT ((0)) FOR [choiceType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_event_bingo] ADD CONSTRAINT [DF_log_event_bingo_number] DEFAULT ((0)) FOR [number]
|
|
GO
|
|
ALTER TABLE [dbo].[log_event_bingo] ADD CONSTRAINT [DF_log_event_bingo_stateType] DEFAULT ((0)) FOR [stateType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_event_cash] ADD CONSTRAINT [DF_log_event_cash_userLevel] DEFAULT ((0)) FOR [userLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[log_event_cash] ADD CONSTRAINT [DF_log_event_cash_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[log_event_cash] ADD CONSTRAINT [DF_log_event_cash_amount] DEFAULT ((0)) FOR [amount]
|
|
GO
|
|
ALTER TABLE [dbo].[log_event_cash] ADD CONSTRAINT [DF_log_event_cash_eventType] DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_event_cash] ADD CONSTRAINT [DF_log_event_cash_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_game_concurrent] ADD CONSTRAINT [DF_Log_game_concurrent_serverID] DEFAULT ((0)) FOR [serverID]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_game_concurrent] ADD CONSTRAINT [DF_Log_game_concurrent_concurrent] DEFAULT ((0)) FOR [concurrent]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_game_concurrent] ADD CONSTRAINT [DF_Log_game_concurrent_cpType] DEFAULT ((0)) FOR [cpType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_game_concurrent] ADD CONSTRAINT [DF_Log_game_concurrent_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_playType] DEFAULT ((0)) FOR [playType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_modeType] DEFAULT ((0)) FOR [modeType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_sub1Type] DEFAULT ((0)) FOR [sub1Type]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_sub2Type] DEFAULT ((0)) FOR [sub2Type]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_characterType] DEFAULT ((0)) FOR [characterType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_cnt_kill] DEFAULT ((0)) FOR [cnt_kill]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_cnt_killed] DEFAULT ((0)) FOR [cnt_killed]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_cnt_selfkilled] DEFAULT ((0)) FOR [cnt_selfkilled]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_character] ADD CONSTRAINT [DF_Log_play_character_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_playType] DEFAULT ((0)) FOR [playType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_modeType] DEFAULT ((0)) FOR [modeType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_sub1Type] DEFAULT ((0)) FOR [sub1Type]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_sub2Type] DEFAULT ((0)) FOR [sub2Type]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_waitTime] DEFAULT ((0)) FOR [deathTime]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_basePeso] DEFAULT ((0)) FOR [basicPeso]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_get_peso] DEFAULT ((0)) FOR [total_peso]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_get_emblem] DEFAULT ((0)) FOR [total_emblem]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_total_play_num] DEFAULT ((0)) FOR [total_play_num]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_total_round] DEFAULT ((0)) FOR [total_round]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_total_contribute] DEFAULT ((0)) FOR [total_contribute]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_total_win] DEFAULT ((0)) FOR [total_win]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_total_lose] DEFAULT ((0)) FOR [total_lose]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_cnt_kill] DEFAULT ((0)) FOR [cnt_kill]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_cnt_killed] DEFAULT ((0)) FOR [cnt_killed]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_cnt_selfkilled] DEFAULT ((0)) FOR [cnt_selfkilled]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_logType] DEFAULT ((0)) FOR [logType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_game] ADD CONSTRAINT [DF_Log_play_game_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_tutorial] ADD CONSTRAINT [DF_Log_play_tutorial_step] DEFAULT ((0)) FOR [step]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_tutorial] ADD CONSTRAINT [DF_Log_play_tutorial_playTime] DEFAULT ((0)) FOR [playTime]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_play_tutorial] ADD CONSTRAINT [DF_Log_play_tutorial_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_present] ADD CONSTRAINT [DF_log_present_presentType] DEFAULT ((0)) FOR [presentType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_present] ADD CONSTRAINT [DF_log_present_value1] DEFAULT ((0)) FOR [value1]
|
|
GO
|
|
ALTER TABLE [dbo].[log_present] ADD CONSTRAINT [DF_log_present_value2] DEFAULT ((0)) FOR [value2]
|
|
GO
|
|
ALTER TABLE [dbo].[log_present] ADD CONSTRAINT [DF_log_present_eventType] DEFAULT ((0)) FOR [eventType]
|
|
GO
|
|
ALTER TABLE [dbo].[log_present] ADD CONSTRAINT [DF_log_present_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_system_info] ADD CONSTRAINT [DF_Log_system_info_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_option] ADD DEFAULT ((0)) FOR [BlueMember]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_option] ADD DEFAULT ((0)) FOR [RedMember]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_option] ADD DEFAULT ((0)) FOR [BlueMaxMember]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_option] ADD DEFAULT ((0)) FOR [RedMaxMember]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_option] ADD DEFAULT ((0)) FOR [TeamMixOption]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_option] ADD DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_option] ADD DEFAULT ((0)) FOR [closedRoomOption]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_option] ADD DEFAULT ((0)) FOR [userModeOption]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_start] ADD DEFAULT ((0)) FOR [ServerID]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_start] ADD DEFAULT ((0)) FOR [MakeRoom]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_start] ADD DEFAULT ((0)) FOR [QuickStart]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_start] ADD DEFAULT ((0)) FOR [ListSelect]
|
|
GO
|
|
ALTER TABLE [dbo].[log_trace_prisoner_start] ADD DEFAULT (getdate()) FOR [RegDate]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_use_item] ADD CONSTRAINT [DF_Log_use_item_itemType] DEFAULT ((0)) FOR [itemType]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_use_item] ADD CONSTRAINT [DF_Log_use_item_itemCode] DEFAULT ((0)) FOR [itemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_use_item] ADD CONSTRAINT [DF_Log_use_item_rowIDX] DEFAULT ((0)) FOR [rowIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_use_item] ADD CONSTRAINT [DF_Log_use_item_colIDX] DEFAULT ((0)) FOR [colIDX]
|
|
GO
|
|
ALTER TABLE [dbo].[Log_use_item] ADD CONSTRAINT [DF_Log_use_item_regDate] DEFAULT (getdate()) FOR [regDate]
|
|
GO
|
|
ALTER TABLE [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM] ADD DEFAULT ((0)) FOR [Term_05220612]
|
|
GO
|
|
ALTER TABLE [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM] ADD DEFAULT ((0)) FOR [Term_06120619]
|
|
GO
|
|
ALTER TABLE [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM] ADD DEFAULT ((0)) FOR [Term_05220619]
|
|
GO
|
|
ALTER TABLE [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM] ADD DEFAULT ((0)) FOR [progress]
|
|
GO
|
|
ALTER TABLE [dbo].[LosaGamelog_TEMP_QUEST_LOGIN_BCKIM] ADD DEFAULT ((0)) FOR [result]
|
|
GO
|
|
ALTER TABLE [dbo].[SQL_ERROR_LOG] ADD DEFAULT (getdate()) FOR [ErrorTime]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT ((0)) FOR [UserLevel]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT ((0)) FOR [PlayType]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT ((0)) FOR [ModeType]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT ((0)) FOR [SubType1]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT ((0)) FOR [SubType2]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT ((0)) FOR [ItemType]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT ((0)) FOR [ItemCode]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT ((0)) FOR [ItemValue]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK] ADD DEFAULT (getdate()) FOR [RegDate]
|
|
GO
|
|
ALTER TABLE [dbo].[TBL_LOG_HACK_MESSAGE] ADD DEFAULT (getdate()) FOR [RegDate]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[backup_log_item_gold_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[backup_log_item_gold_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @userLevel int
|
|
, @itemType int
|
|
, @itemCode int
|
|
, @itemValue int
|
|
, @amount int
|
|
, @cpType smallint
|
|
, @billingID varchar(64)
|
|
, @userIP varchar(15)
|
|
, @note varchar(100)
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_buy_item_gold (
|
|
accountIDX, nickname, userLevel, itemType, itemCode, itemValue, amount, cpType, billingID, userIP, note, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickname, @userLevel, @itemType, @itemCode, @itemValue, @amount, @cpType, @billingID, @userIP, @note, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_log_buy_gold_item] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[game_log_buy_gold_item]
|
|
(
|
|
@accountIDX int
|
|
, @nickname varchar(12)
|
|
, @itemType int
|
|
, @itemCode int
|
|
, @amount int
|
|
, @userIP varchar(15)
|
|
, @note varchar(200)
|
|
)
|
|
AS
|
|
|
|
INSERT INTO Log_buy_gold_item (accountIDX, nickname, itemType, itemCode, amount, userIP, note, regDate)
|
|
VALUES (@accountIDX, @nickname, @itemType, @itemCode, @amount, @userIP, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_log_buy_item] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[game_log_buy_item]
|
|
(
|
|
@userID varchar(12)
|
|
, @applyType char(2)
|
|
, @amount int
|
|
, @userIP varchar(16)
|
|
, @playType int
|
|
, @modeType int
|
|
, @sub1Type int
|
|
, @sub2Type int
|
|
, @classType int
|
|
, @kindred int
|
|
, @decoType int
|
|
, @decoCode int
|
|
, @itemType int
|
|
, @buyType int
|
|
, @note varchar(100)
|
|
)
|
|
As
|
|
|
|
INSERT INTO Log_buy_item (userID, applyType, userIP, playType, modeType, sub1Type, sub2Type, classType, kindred, decoType, decoCode, itemType, buyType, amount, note, regDate)
|
|
VALUES (@userID, @applyType, @userIP, @playType, @modeType, @sub1Type, @sub2Type, @classType, @kindred, @decoType, @decoCode, @itemType, @buyType, @amount, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_log_concurrent] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[game_log_concurrent]
|
|
(
|
|
@serverID bigint
|
|
, @serverIP varchar(15)
|
|
, @serverPort int
|
|
, @serverName varchar(32)
|
|
, @concurrent int
|
|
, @cpType smallint
|
|
)
|
|
As
|
|
|
|
INSERT INTO Log_game_concurrent (serverID, serverIP, serverPort, serverName, concurrent, cpType, regDate)
|
|
VALUES (@serverID, @serverIP, @serverPort, @serverName, @concurrent, @cpType, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_log_play_character] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[game_log_play_character]
|
|
(
|
|
@userID varchar(12)
|
|
, @playType int
|
|
, @modeType int
|
|
, @sub1Type int
|
|
, @sub2Type int
|
|
, @playTime int
|
|
, @characterType int
|
|
, @cnt_kill int
|
|
, @cnt_killed int
|
|
, @cnt_selfkilled int
|
|
)
|
|
As
|
|
|
|
INSERT INTO Log_play_character (userID, playType, modeType, sub1Type, sub2Type, playTime, characterType, cnt_kill, cnt_killed, cnt_selfkilled, regDate)
|
|
VALUES (@userID, @playType, @modeType, @sub1Type, @sub2Type, @playTime, @characterType, @cnt_kill, @cnt_killed, @cnt_selfkilled, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_log_play_game] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[game_log_play_game]
|
|
(
|
|
@userID varchar(12)
|
|
, @playType int
|
|
, @modeType int
|
|
, @sub1Type int
|
|
, @sub2Type int
|
|
, @playTime int
|
|
, @deathTime int
|
|
, @basicPeso int
|
|
, @total_peso int
|
|
, @total_emblem int
|
|
, @total_play_num int
|
|
, @total_round int
|
|
, @total_contribute int
|
|
, @total_win int
|
|
, @total_lose int
|
|
, @cnt_kill int
|
|
, @cnt_killed int
|
|
, @cnt_selfkilled int
|
|
, @logType int
|
|
)
|
|
As
|
|
|
|
INSERT INTO Log_play_game (userID, playType, modeType, sub1Type, sub2Type, playTime, deathTime, basicPeso, total_peso, total_emblem, total_play_num, total_round, total_contribute, total_win, total_lose, cnt_kill, cnt_killed, cnt_selfkilled, logType, regDate)
|
|
VALUES (@userID, @playType, @modeType, @sub1Type, @sub2Type, @playTime, @deathTime, @basicPeso, @total_peso, @total_emblem, @total_play_num, @total_round, @total_contribute, @total_win, @total_lose, @cnt_kill, @cnt_killed, @cnt_selfkilled, @logType, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_log_play_tutorial] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[game_log_play_tutorial]
|
|
(
|
|
@userID varchar(12)
|
|
, @step int
|
|
, @playTime int
|
|
)
|
|
As
|
|
|
|
INSERT INTO Log_play_tutorial (userID, step, playTime, regDate)
|
|
VALUES (@userID, @step, @playTime, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_log_system_add_data] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[game_log_system_add_data]
|
|
(
|
|
@logType varchar(32)
|
|
, @serverIP varchar(15)
|
|
, @concurrent int
|
|
, @cpu int
|
|
, @memory int
|
|
)
|
|
As
|
|
INSERT INTO Log_system_info (logType, serverIP, concurrent, cpu, memory)
|
|
VALUES (@logType, @serverIP, @concurrent, @cpu, @memory)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_log_use_item] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[game_log_use_item]
|
|
(
|
|
@accountIDX int
|
|
, @nickname varchar(12)
|
|
, @itemType int
|
|
, @itemCode int
|
|
, @itemRowIDX int
|
|
, @itemColIDX int
|
|
, @userIP varchar(15)
|
|
, @note varchar(200)
|
|
)
|
|
AS
|
|
INSERT INTO Log_use_item (accountIDX, nickname, itemType, itemCode, rowIDX, colIDX, userIP, note, regDate)
|
|
VALUES (@accountIDX, @nickname, @itemType, @itemCode, @itemRowIDX, @itemColIDX, @userIP, @note, getDate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[game_mission_data_delete] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
-- Subject : dbo.game_mission_data_delete
|
|
-- Author : hryoon
|
|
-- DATE : 2016-12-16
|
|
-- Description : 미션데이터 초기화
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[game_mission_data_delete]
|
|
@YEAR VARCHAR(5),
|
|
@MONTH VARCHAR(5),
|
|
@DAY VARCHAR(5)
|
|
AS
|
|
|
|
DECLARE @REG_DATE VARCHAR(20)
|
|
SET @REG_DATE = @YEAR+'-'+@MONTH+'-'+@DAY
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
DELETE FROM dbo.userMissionDB WHERE RegDate < @REG_DATE
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_accessory_upgrade_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_accessory_upgrade_add]
|
|
(
|
|
@accountIDX INT, -- 유저 인덱스
|
|
@nickName NVARCHAR(20), -- 유저 닉네임
|
|
@userLevel INT, -- 유저 레벨
|
|
@itemCode INT, -- 강화 악세서리 코드
|
|
@nowUpgradeValue INT, -- 업그레이드 전 강화 값
|
|
@resultUpgradeValue INT, -- 업그레이드 이후 강화 값
|
|
@pieceCode INT, -- 강화에 사용한 악세서리 코드
|
|
@logType INT -- 로그 구분 [1: 강화 성공, 2: 강화 실패]
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
SET LOCK_TIMEOUT 10000
|
|
|
|
BEGIN
|
|
|
|
INSERT dbo.log_data_accessory_upgrade (
|
|
accountIDX, nickName, userLevel, itemCode, nowUpgradeValue, resultUpgradeValue, pieceCode, logType, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @itemCode, @nowUpgradeValue, @resultUpgradeValue, @pieceCode, @logType, GETDATE()
|
|
)
|
|
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_awake_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_awake_add]
|
|
(
|
|
@accountIDX INT, -- 사용자 고유키
|
|
@nickName NVARCHAR(20), -- 닉네임
|
|
@userLevel INT, -- 유저 레벨
|
|
@classType INT, -- 용병 코드
|
|
@pieceCode INT, -- 조각 코드
|
|
@pieceUseCount SMALLINT, -- 사용 된 조각 개수
|
|
@awakeType TINYINT -- 각성 타입 (1: 일반각성, 2: 초월각성)
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
BEGIN
|
|
|
|
INSERT dbo.log_data_awake (
|
|
accountIDX, nickName, userLevel, classType, pieceCode, pieceUseCount, awakeType, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @classType, @pieceCode, @pieceUseCount, @awakeType, GETDATE()
|
|
)
|
|
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_cardmatching_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
-- Subject : log_data_cardmatching_add
|
|
-- Author : bckim
|
|
-- Date : 2018-07-01
|
|
-- Description : 카드 매칭 로그
|
|
-- // 2018-06-18 by bckim, 카드 짝 마추기 이벤트 추가
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_cardmatching_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@LOG_TYPE INT,
|
|
|
|
@MISSION_TYPE INT,
|
|
@MISSION_MARK1 INT,
|
|
@MISSION_MARK2 INT,
|
|
@USER_MARK1 INT,
|
|
@USER_MARK2 INT,
|
|
|
|
@REWARD_STEP INT,
|
|
@ITEM_TYPE INT,
|
|
@ITEM_CODE INT,
|
|
@ITEM_VALUE INT
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO log_data_cardmatching (AccountIDX, NickName,UserLevel,LogType,MissionType,MissionMark1,MissionMark2,UserMark1,UserMark2,RewardStep,ItemType,ItemCode, ItemValue,RegDate)
|
|
VALUES (@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @LOG_TYPE, @MISSION_TYPE,@MISSION_MARK1,@MISSION_MARK2,@USER_MARK1,@USER_MARK2,@REWARD_STEP, @ITEM_TYPE, @ITEM_CODE, @ITEM_VALUE, GETDATE())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_character_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_character_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @playType int
|
|
, @modeType int
|
|
, @subType1 int
|
|
, @subType2 int
|
|
, @playTime int
|
|
, @characterType int
|
|
, @kill int
|
|
, @death int
|
|
)
|
|
As
|
|
|
|
INSERT INTO log_data_character (accountIDX, nickName, playType, modeType, subType1, subType2, playTime, characterType, [kill], death, regDate)
|
|
VALUES (@accountIDX, @nickName, @playType, @modeType, @subType1, @subType2, @playTime, @characterType, @kill, @death, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_cheating_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.log_data_pet_add', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.log_data_pet_add
|
|
--
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_cheating_add
|
|
-- Author : hryoon
|
|
-- DATE : 2017-01-13
|
|
-- Description : 치팅퀘스트로그추가
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_cheating_add]
|
|
|
|
@accountIDX INT,
|
|
@userID VARCHAR(20),
|
|
@userLevel INT,
|
|
@userIP VARCHAR(20),
|
|
@mainIDX INT,
|
|
@subIDX INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_cheating (
|
|
accountIDX, userID, userLevel, userIP, mainIDX, subIDX, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @userID, @userLevel, @userIP, @mainIDX, @subIDX, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_clover_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_clover_add]
|
|
(
|
|
@userIDX int
|
|
, @FriendIDX int
|
|
, @Type smallint
|
|
, @Count int
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_data_clover( accountIDX, friendIDX, eventType, CloverCount, regDate )
|
|
VALUES( @userIDX, @FriendIDX, @Type, @Count, GETDATE() )
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_custom_medal_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
--IF OBJECT_ID('dbo.log_data_custom_medal_add','P') IS NOT NULL
|
|
--
|
|
-- DROP PROC dbo.log_data_custom_medal_add
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_custom_medal_add
|
|
-- Author : galura
|
|
-- Date : 2017-03-16
|
|
-- Description : 커스텀 메달 로그 Insert
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_custom_medal_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@MEDAL_IDX INT,
|
|
@MEDAL_CODE INT,
|
|
@BASIC_GROWTH1 INT,
|
|
@BASIC_GROWTH2 INT,
|
|
@BASIC_GROWTH3 INT,
|
|
@BASIC_GROWTH4 INT,
|
|
@SKILL_GROWTH1 INT,
|
|
@SKILL_GROWTH2 INT,
|
|
@SKILL_GROWTH3 INT,
|
|
@SKILL_GROWTH4 INT,
|
|
@LIMIT_TYPE INT,
|
|
@LIMIT_DATE DATETIME,
|
|
@LOG_TYPE TINYINT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_custom_medal (
|
|
AccountIDX, MedalIDX, MedalCode, BasicGrowth1, BasicGrowth2, BasicGrowth3, BasicGrowth4, SkillGrowth1, SkillGrowth2, SkillGrowth3, SkillGrowth4, LimitType, LimitDate, LogType, RegDate
|
|
)
|
|
VALUES (
|
|
@ACCOUNT_IDX, @MEDAL_IDX, @MEDAL_CODE, @BASIC_GROWTH1, @BASIC_GROWTH2, @BASIC_GROWTH3, @BASIC_GROWTH4, @SKILL_GROWTH1, @SKILL_GROWTH2, @SKILL_GROWTH3, @SKILL_GROWTH4, @LIMIT_TYPE, @LIMIT_DATE, @LOG_TYPE, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_DiceGame_update] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_DiceGame_update
|
|
-- Author : bckim
|
|
-- DATE : 2018-08-30
|
|
-- Description : // 2018-08-30 by bckim, 주사위 이벤트 추가_ 로그
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_DiceGame_update]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@Game_State INT,
|
|
@DiceCountUsed INT,
|
|
@BoardCountUsed INT,
|
|
@RewardCountUsed 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
|
|
IF EXISTS( SELECT * FROM [dbo].[log_data_DiceGame] WHERE @ACCOUNT_IDX = [AccountIDX] AND [GameState] = 0 )
|
|
BEGIN
|
|
UPDATE [dbo].[log_data_DiceGame] WITH (XLOCK, ROWLOCK)
|
|
SET [GameState] = @Game_State,[DiceCountUsed] = [DiceCountUsed] + @DiceCountUsed,[BoardCountUsed] = [BoardCountUsed] + @BoardCountUsed, [RewardCountUsed] = [RewardCountUsed] + @RewardCountUsed,
|
|
[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, [EndTime] = GETDATE()
|
|
WHERE @ACCOUNT_IDX = [AccountIDX] AND [GameState] = 0
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
INSERT INTO [dbo].[log_data_DiceGame] WITH(XLOCK, ROWLOCK)
|
|
([AccountIDX],[GameState],[DiceCountUsed],[BoardCountUsed],[RewardCountUsed],[Position],[Trace01],[Trace02],[Trace03],[Trace04],[Trace05],[Trace06],[Board],
|
|
[RewardStep01],[RewardStep02],[RewardStep03],[RewardStep04],[RewardStep05],[RewardStep06],[RewardStep07],[RewardStep08],[RewardStep09],[RewardStep10],[StartTime],[EndTime] )
|
|
VALUES ( @ACCOUNT_IDX,@Game_State,@DiceCountUsed,@BoardCountUsed,@RewardCountUsed,@Position,@Trace01,@Trace02,@Trace03,@Trace04,@Trace05,@Trace06,@Board,
|
|
@Reward01,@Reward02,@Reward03,@Reward04,@Reward05,@Reward06,@Reward07,@Reward08,@Reward09,@Reward10, GETDATE(),GETDATE())
|
|
END
|
|
COMMIT TRAN
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_gear_upgrade_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_gear_upgrade_add]
|
|
(
|
|
@accountIDX INT, -- 유저 인덱스
|
|
@nickName NVARCHAR(20), -- 유저 닉네임
|
|
@userLevel INT, -- 유저 레벨
|
|
@gearCode INT, -- 강화 장비 코드
|
|
@nowUpgradeValue TINYINT, -- 업그레이드 전 강화 값
|
|
@resultUpgradeValue TINYINT, -- 업그레이드 이후 강화 값
|
|
@pieceCode INT, -- 조각 코드
|
|
@logType INT -- 로그 구분 [1: 강화 성공, 2: 강화 실패]
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
SET LOCK_TIMEOUT 10000
|
|
|
|
BEGIN
|
|
|
|
INSERT dbo.log_data_gear_upgrade (
|
|
accountIDX, nickName, userLevel, gearCode, nowUpgradeValue, resultUpgradeValue, pieceCode, logType, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @gearCode, @nowUpgradeValue, @resultUpgradeValue, @pieceCode, @logType, GETDATE()
|
|
)
|
|
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_league_present_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_league_present_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName nvarchar(20)
|
|
, @leagueIDX int
|
|
, @currentRound tinyint
|
|
, @presentCode1 int
|
|
, @presentCode2 int
|
|
, @presentCode3 int
|
|
, @presentCode4 int
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_data_league_present (
|
|
accountIDX, nickName, leagueIDX, currentRound, presentCode1, presentCode2, presentCode3, presentCode4, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @leagueIDX, @currentRound, @presentCode1, @presentCode2, @presentCode3, @presentCode4, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_localinfo_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_localinfo_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @userLevel int
|
|
, @os nvarchar(100)
|
|
, @ie nvarchar(100)
|
|
, @directx nvarchar(100)
|
|
, @cpu nvarchar(100)
|
|
, @gpu nvarchar(100)
|
|
, @memory nvarchar(100)
|
|
, @systemResolution nvarchar(20)
|
|
, @losaResolution nvarchar(20)
|
|
, @screenType tinyint
|
|
, @userIP varchar(15)
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_data_localinfo (
|
|
accountIDX, nickName, userLevel, os, ie, directx, cpu, gpu, memory, systemResolution, losaResolution, screenType, userIP, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @os, @ie, @directx, @cpu, @gpu, @memory, @systemResolution, @losaResolution, @screenType, @userIP, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_localinfo_add_2] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_localinfo_add_2]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @userLevel int
|
|
, @os nvarchar(100)
|
|
, @ie nvarchar(100)
|
|
, @directx nvarchar(100)
|
|
, @cpu nvarchar(100)
|
|
, @gpu nvarchar(100)
|
|
, @memory nvarchar(100)
|
|
, @systemResolution nvarchar(20)
|
|
, @losaResolution nvarchar(20)
|
|
, @screenType tinyint
|
|
, @userIP varchar(15)
|
|
, @user_hdd_serial nvarchar(100)
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_data_localinfo (
|
|
accountIDX, nickName, userLevel, os, ie, directx, cpu, gpu, memory, systemResolution, losaResolution, screenType, userIP, regDate, hdd_serial
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @os, @ie, @directx, @cpu, @gpu, @memory, @systemResolution, @losaResolution, @screenType, @userIP, GETDATE(),@user_hdd_serial
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_matchmode_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
--IF OBJECT_ID('dbo.log_data_matchmode_add', 'U') IS NOT NULL
|
|
-- DROP TABLE dbo.log_data_matchmode_add
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_matchmode_add
|
|
-- Author : galura
|
|
-- Date : 2016-08-19
|
|
-- Description : 랭킹전 관련 로그
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_matchmode_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@TIER1 INT,
|
|
@TIER2 INT,
|
|
@MATCH_TIME INT,
|
|
@LOG_TYPE INT,
|
|
@ROOM_NUMBER INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_matchmode (AccountIDX, nickName, userLevel, Tier1, Tier2, MatchTime, logType, regDate, RoomNumber)
|
|
VALUES (@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @TIER1, @TIER2, @MATCH_TIME, @LOG_TYPE, GETDATE(), @ROOM_NUMBER);
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_matchmode2_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.log_data_matchmode2_add', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.log_data_matchmode2_add
|
|
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_matchmode2_add
|
|
-- Author : galura
|
|
-- DATE : 2016-12-07
|
|
-- Description : 1:1 모드 관련 로그
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_matchmode2_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@TIER1 INT,
|
|
@TIER2 INT,
|
|
@MATCH_TIME INT,
|
|
@MATCH_POINT INT,
|
|
@WINNING_STREAK_COUNT INT,
|
|
@LOG_TYPE INT,
|
|
@ROOM_NUMBER INT,
|
|
@MATCH_TYPE INT
|
|
|
|
AS
|
|
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_matchmode2 (AccountIDX, nickName, userLevel, Tier1, Tier2, MatchTime, MatchPoint, WinningStreakCount, logType, MatchType, RoomNumber, regDate)
|
|
VALUES (@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @TIER1, @TIER2, @MATCH_TIME, @MATCH_POINT, @WINNING_STREAK_COUNT, @LOG_TYPE, @MATCH_TYPE, @ROOM_NUMBER, GETDATE());
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_medal_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_medal_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @medalType int
|
|
, @limitType int
|
|
, @logType int
|
|
)
|
|
As
|
|
|
|
INSERT INTO log_data_medal (accountIDX, nickName, medalType, limitType, logType, regDate)
|
|
VALUES (@accountIDX, @nickName, @medalType, @limitType, @logType, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_medal_extend_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_medal_extend_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @userLevel int
|
|
, @classType int
|
|
, @slotNum tinyint
|
|
, @period int
|
|
, @logType int
|
|
)
|
|
AS
|
|
|
|
INSERT INTO dbo.log_data_medal_extend (
|
|
accountIDX, nickName, userLevel, classType, slotNum, period, logType, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @classType, @slotNum, @period, @logType, getdate()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_oakbarrel_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
--IF OBJECT_ID('dbo.log_data_oakbarrel_add','P') IS NOT NULL
|
|
--
|
|
-- DROP PROC dbo.log_data_oakbarrel_add
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_oakbarrel_add
|
|
-- Author : galura
|
|
-- Date : 2016-07-01
|
|
-- Description : 오크통 로그
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_oakbarrel_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@ITEM_TYPE INT,
|
|
@ITEM_CODE INT,
|
|
@ITEM_VALUE INT,
|
|
@SWORD_COUNT INT,
|
|
@LOG_TYPE INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO log_data_oakbarrel (AccountIDX, NickName, UserLevel, ItemType, ItemCode, ItemValue, SwordCount, LogType, RegDate)
|
|
VALUES (@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @ITEM_TYPE, @ITEM_CODE, @ITEM_VALUE, @SWORD_COUNT, @LOG_TYPE, GETDATE())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_pcroom_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_pcroom_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @playTime int
|
|
, @userIP varchar(15)
|
|
, @pcnum int
|
|
, @logType int
|
|
, @pcrType int
|
|
)
|
|
AS
|
|
|
|
INSERT INTO log_data_pcroom (accountIDX, nickName, playTime, userIP, pcnum, logType, pcrType, regDate)
|
|
VALUES (@accountIDX, @nickName, @playTime, @userIP, @pcnum, @logType, @pcrType, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_peso_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_peso_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @peso int
|
|
, @logType int
|
|
)
|
|
As
|
|
|
|
INSERT INTO log_data_peso (accountIDX, nickName, peso, logType, regDate)
|
|
VALUES (@accountIDX, @nickName, @peso, @logType, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_pet_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_pet_add]
|
|
|
|
@ACCOUNT_IDX INT, -- 사용자 고유키
|
|
@NICKNAME NVARCHAR(20), -- 닉네임
|
|
@USERLEVEL INT, -- 유저 레벨
|
|
@PET_IDX INT, -- 펫 고유키
|
|
@PTE_CODE INT, -- 펫 인덱스
|
|
@PET_RANK TINYINT, -- 랭크
|
|
@PET_LEVEL INT, -- 레벨
|
|
@PET_EXP INT, -- 경험치
|
|
@ITEM_CODE INT, -- 펫 획득 가챠 코드
|
|
@LOG_TYPE TINYINT, -- 로그 구분 - 1: 생성 2: 삭제 3: 장착 4: 랭크업 5: 레벨업 6: 육성 7:교배
|
|
@LOG_SUB_TYPE INT, -- LogType에 해당하는 값. 없으면 0;
|
|
@LOG_NOTE VARCHAR(200) -- 기타 비고란.
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
SET LOCK_TIMEOUT 10000
|
|
|
|
BEGIN
|
|
|
|
INSERT dbo.log_data_pet WITH(ROWLOCK, XLOCK) (accountIDX, nickName, userLevel, petIDX, petCode, petRank, petLevel, petExp, itemCode, logType, logSubType, logNote) VALUES
|
|
(@ACCOUNT_IDX, @NICKNAME, @USERLEVEL, @PET_IDX, @PTE_CODE, @PET_RANK, @PET_LEVEL, @PET_EXP, @ITEM_CODE, @LOG_TYPE, @LOG_SUB_TYPE, @LOG_NOTE)
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_piece_divide_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_piece_divide_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName nvarchar(20)
|
|
, @userLevel int
|
|
, @itemType int
|
|
, @itemCode int
|
|
, @amount int
|
|
, @materialCode int
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_data_piece_divide (
|
|
accountIDX, nickName, userLevel, itemType, itemCode, amount, materialCode, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @itemType, @itemCode, @amount, @materialCode, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_piece_mix_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_piece_mix_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName nvarchar(20)
|
|
, @userLevel int
|
|
, @mixType smallint
|
|
, @mixCode int
|
|
, @resultType tinyint
|
|
, @useA int
|
|
, @useB int
|
|
, @resultA int
|
|
, @resultB int
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_data_piece_mix (
|
|
accountIDX, nickName, userLevel, mixType, mixCode, resultType, useA, useB, resultA, resultB, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @mixType, @mixCode, @resultType, @useA, @useB, @resultA, @resultB, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_piece_obtain_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_piece_obtain_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName nvarchar(20)
|
|
, @userLevel int
|
|
, @playTime int
|
|
, @step tinyint
|
|
, @amount int
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_data_piece_obtain (
|
|
accountIDX, nickName, userLevel, playTime, step, amount, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @playTime, @step, @amount, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_play_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.log_data_play_add', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.log_data_play_add
|
|
--
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_play_add
|
|
-- Authod :
|
|
-- Date :
|
|
-- Description :
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_play_add]
|
|
|
|
@accountIDX INT,
|
|
@nickName VARCHAR(20),
|
|
@playType INT,
|
|
@modeType INT,
|
|
@subType1 INT,
|
|
@subType2 INT,
|
|
@playTime INT,
|
|
@deathTime INT,
|
|
@peso INT,
|
|
@win INT,
|
|
@lose INT,
|
|
@kill INT,
|
|
@death INT,
|
|
@logType INT,
|
|
@pcnum INT,
|
|
@roomNumber INT,
|
|
@contribution INT,
|
|
@blueTeamMember INT,
|
|
@redTeamMember INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_play (
|
|
accountIDX, nickName, playType, modeType, subType1, subType2, playTime, deathTime, peso, win, lose, [kill], death, roomNumber, contribution, logType, pcnum, blueTeamMember, redTeamMember, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @playType, @modeType, @subType1, @subType2, @playTime, @deathTime, @peso, @win, @lose, @kill, @death, @roomNumber, @contribution, @logType, @pcnum, @blueTeamMember, @redTeamMember, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_play_room_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_play_room_add
|
|
-- Author : galura
|
|
-- Date : 2016-06-13
|
|
-- Description : 룸 정보
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_play_room_add]
|
|
|
|
@RoomNumber INT,
|
|
@BlueWin INT,
|
|
@BlueLose INT,
|
|
@BlueTeamMember INT,
|
|
@RedWin INT,
|
|
@RedLose INT,
|
|
@RedTeamMember INT,
|
|
@PlayType INT,
|
|
@ModeType INT,
|
|
@ModeSubType INT,
|
|
@Tier1 INT,
|
|
@Tier2 INT,
|
|
@LogType INT,
|
|
@playTime INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_roominfo (
|
|
RoomNumber, BlueWin, BlueLose, BlueTeamMember, RedWin, RedLose, RedTeamMember, PlayType, ModeType, ModeSubType, RegDate, Tier1, Tier2, LogType, playTime
|
|
)
|
|
VALUES (
|
|
@RoomNumber, @BlueWin, @BlueLose, @BlueTeamMember, @RedWin, @RedLose, @RedTeamMember, @PlayType, @ModeType, @ModeSubType, GETDATE(), @Tier1, @Tier2, @LogType, @playTime
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_quest_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_quest_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @userLevel int
|
|
, @mainIDX int
|
|
, @subIDX int
|
|
, @logType int
|
|
)
|
|
As
|
|
|
|
INSERT INTO log_data_quest (accountIDX, nickName, userLevel, mainIDX, subIDX, logType, regDate)
|
|
VALUES (@accountIDX, @nickName, @userLevel, @mainIDX, @subIDX, @logType, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_quest_vfun_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_quest_vfun_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @userLevel int
|
|
, @mainIDX int
|
|
, @subIDX int
|
|
, @channelingType int
|
|
, @success int
|
|
, @reason varchar(256)
|
|
)
|
|
As
|
|
|
|
INSERT INTO log_data_quest_vfun (accountIDX, nickName, userLevel, mainIDX, subIDX, channelingType, success, reason, regDate)
|
|
VALUES (@accountIDX, @nickName, @userLevel, @mainIDX, @subIDX, @channelingType,@success,@reason,getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_spirit_change_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.log_data_spirit_change_add', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.log_data_spirit_change_add
|
|
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_spirit_change_add
|
|
-- Author : galura
|
|
-- DATE : 2016-12-07
|
|
-- Description : 1:1 모드 관련 로그
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_spirit_change_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@SET_SPIRIT_CODE INT,
|
|
@SET_SPIRIT_COUNT INT,
|
|
@GET_SPIRIT_CODE INT,
|
|
@GET_SPIRIT_COUNT INT,
|
|
@CRITICAL_TYPE TINYINT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_spirit_change (
|
|
AccountIDX, NickName, UserLevel, SetSpiritCode, SetSpiritCount, GetSpiritCode, GetSpiritCount, CriticalType, regDate
|
|
)
|
|
VALUES (
|
|
@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @SET_SPIRIT_CODE, @SET_SPIRIT_COUNT, @GET_SPIRIT_CODE, @GET_SPIRIT_COUNT, @CRITICAL_TYPE, GETDATE()
|
|
);
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_spirit_divide_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.log_data_spirit_divide_add', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.log_data_spirit_divide_add
|
|
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_spirit_divide_add
|
|
-- Author : galura
|
|
-- DATE : 2016-12-07
|
|
-- Description : 1:1 모드 관련 로그
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_spirit_divide_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@HERO_TYPE INT,
|
|
@SPIRIT_CODE INT,
|
|
@SPIRIT_COUNT INT,
|
|
@SOUL_STONE_COUNT INT,
|
|
@CRITICAL_TYPE TINYINT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_spirit_divide (
|
|
AccountIDX, NickName, UserLevel, HeroType, SpiritCode, SpiritCount, SoulStoneCount, CriticalType, regDate
|
|
)
|
|
VALUES (
|
|
@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @HERO_TYPE, @SPIRIT_CODE, @SPIRIT_COUNT, @SOUL_STONE_COUNT, @CRITICAL_TYPE, GETDATE()
|
|
);
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_spirit_mix_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.log_data_spirit_mix_add', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.log_data_spirit_mix_add
|
|
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_spirit_mix_add
|
|
-- Author : galura
|
|
-- DATE : 2016-12-07
|
|
-- Description : 1:1 모드 관련 로그
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_spirit_mix_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@HERO_TYPE INT,
|
|
@SPIRIT_CODE INT,
|
|
@SPIRIT_COUNT INT,
|
|
@UNKNOWN_SPIRIT_CODE INT,
|
|
@UNKNOWN_SPIRIT_COUNT INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_spirit_mix (
|
|
AccountIDX, NickName, UserLevel, HeroType, SpiritCode, SpiritCount, UnknownSpiritCode, UnknownSpiritCount, regDate
|
|
)
|
|
VALUES (
|
|
@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @HERO_TYPE, @SPIRIT_CODE, @SPIRIT_COUNT, @UNKNOWN_SPIRIT_CODE, @UNKNOWN_SPIRIT_COUNT, GETDATE()
|
|
);
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_spirit_obtain_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.log_data_spirit_obtain_add', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.log_data_spirit_obtain_add
|
|
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_spirit_obtain_add
|
|
-- Author : galura
|
|
-- DATE : 2016-12-07
|
|
-- Description : 1:1 모드 관련 로그
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_spirit_obtain_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@SPIRIT_CODE INT,
|
|
@SPIRIT_COUNT INT,
|
|
@VALUE INT,
|
|
@LOG_TYPE TINYINT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_spirit_obtain (
|
|
AccountIDX, NickName, UserLevel, SpiritCode, SpiritCount, Value, logType, regDate
|
|
)
|
|
VALUES (
|
|
@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @SPIRIT_CODE, @SPIRIT_COUNT, @VALUE, @LOG_TYPE, GETDATE()
|
|
);
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_spirit_peso_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.log_data_spirit_peso_add', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.log_data_spirit_peso_add
|
|
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_data_spirit_peso_add
|
|
-- Author : galura
|
|
-- DATE : 2016-12-07
|
|
-- Description : 1:1 모드 관련 로그
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_data_spirit_peso_add]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@PIECE_COUNT INT,
|
|
@DIMENSION_COUNT INT,
|
|
@GET_PESO INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_data_spirit_peso (
|
|
AccountIDX, NickName, UserLevel, PieceCount, DimensionCount, Peso, regDate
|
|
)
|
|
VALUES (
|
|
@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @PIECE_COUNT, @DIMENSION_COUNT, @GET_PESO, GETDATE()
|
|
);
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_time_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_time_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @playTime int
|
|
, @logType int
|
|
)
|
|
As
|
|
|
|
INSERT INTO log_data_time (accountIDX, nickName, playTime, logType, regDate)
|
|
VALUES (@accountIDX, @nickName, @playTime, @logType, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_trade_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_trade_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickname varchar(20)
|
|
, @itemType int
|
|
, @value1 int
|
|
, @value2 int
|
|
, @price bigint
|
|
, @logType int
|
|
, @userIP varchar(16)
|
|
, @note varchar(100)
|
|
)
|
|
AS
|
|
|
|
INSERT INTO log_data_trade (accountIDX, nickname, itemType, value1, value2, price, logType, userIP, note, regDate)
|
|
VALUES (@accountIDX, @nickName, @itemType, @value1, @value2, @price, @logType, @userIP, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_data_tutorial_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_data_tutorial_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @step int
|
|
, @playTime int
|
|
)
|
|
As
|
|
|
|
INSERT INTO log_data_tutorial (accountIDX, nickName, step, playTime, regDate)
|
|
VALUES (@accountIDX, @nickName, @step, @playTime, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_error_billing_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_error_billing_add]
|
|
(
|
|
@cpType smallint
|
|
, @errType int
|
|
, @note varchar(200)
|
|
)
|
|
AS
|
|
INSERT INTO log_error_billing (cpType, errType, note, regDate)
|
|
VALUES (@cpType, @errType, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_errorLog_set_log] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
-- Subject : dbo.log_errorLog_set_log
|
|
-- DBA : KeuN
|
|
-- DATE : 2014-11-26 10:10:00
|
|
-- Description : 예외 처리 및 SQL 에러 로그
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROC [dbo].[log_errorLog_set_log]
|
|
|
|
@ACCOUNT_IDX INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
DECLARE @ERROR_NO INT
|
|
DECLARE @ERROR_PROC VARCHAR(50)
|
|
DECLARE @ERROR_LINE INT
|
|
DECLARE @ERROR_SEVERITY INT
|
|
DECLARE @ERROR_STATE INT
|
|
DECLARE @ERROR_MESSAGE VARCHAR(500)
|
|
|
|
SELECT @ERROR_NO = ERROR_NUMBER(),
|
|
@ERROR_PROC = ERROR_PROCEDURE(),
|
|
@ERROR_LINE = ERROR_LINE(),
|
|
@ERROR_SEVERITY = ERROR_SEVERITY(),
|
|
@ERROR_STATE = ERROR_STATE(),
|
|
@ERROR_MESSAGE = ERROR_MESSAGE()
|
|
|
|
|
|
BEGIN TRAN
|
|
|
|
INSERT dbo.SQL_ERROR_LOG VALUES
|
|
(@ACCOUNT_IDX, @ERROR_NO, @ERROR_PROC, @ERROR_LINE, @ERROR_SEVERITY, @ERROR_STATE, @ERROR_MESSAGE, GETDATE())
|
|
|
|
COMMIT TRAN
|
|
|
|
RETURN 1
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_event_bingo_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_event_bingo_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName nvarchar( 20 )
|
|
, @choiceType tinyint
|
|
, @number tinyint
|
|
, @stateType tinyint
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_event_bingo (accountIDX, nickName, choiceType, number, stateType, regDate)
|
|
VALUES (@accountIDX, @nickName, @choiceType, @number, @stateType, GETDATE())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_event_cash_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_event_cash_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName nvarchar(20)
|
|
, @userLevel int
|
|
, @itemCode int
|
|
, @amount int
|
|
, @eventType tinyint
|
|
, @userIP nvarchar(16)
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_event_cash (accountIDX, nickName, userLevel, itemCode, amount, eventType, userIP, regDate)
|
|
VALUES (@accountIDX, @nickName, @userLevel, @itemCode, @amount, @eventType, @userIP, GETDATE())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_Excavating_log_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_Excavating_log_add]
|
|
|
|
@LOG_TYPE INT,
|
|
@ACCOUNT_IDX INT,
|
|
@USER_ID VARCHAR(20),
|
|
@USER_NAME VARCHAR(20),
|
|
@USER_EX_LEVEL INT,
|
|
|
|
@USER_EX_EXP INT,
|
|
@CLASS_TYPE INT,
|
|
@CLASS_LEVEL INT,
|
|
@CLASS_EXPERT INT,
|
|
@REMAIN_COUNT INT,
|
|
|
|
@MAP_ID INT,
|
|
@X INT,
|
|
@Y INT,
|
|
@Z INT,
|
|
@REWARD_TYPE INT,
|
|
|
|
@INDEX INT,
|
|
@PRICE INT,
|
|
@MULIPLE INT,
|
|
@RESULT_MONEY BIGINT,
|
|
@USER_IP VARCHAR(15)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
SET LOCK_TIMEOUT 10000
|
|
|
|
DECLARE @REG_DATE DATETIME
|
|
SET @REG_DATE=GETDATE()
|
|
|
|
BEGIN TRY
|
|
|
|
BEGIN TRAN
|
|
INSERT dbo.log_data_excavating_new WITH (XLOCK, ROWLOCK) ([RegDate],
|
|
[LogType],[AccountIDX],[UserID],[UserName],[ExLevel],
|
|
[ExEXP],[CType],[CLevel],[CExpert],[RCount],
|
|
[MapID],[X],[Y],[Z],[RewardType],
|
|
[Index],[Price],[Mutiple],[ResultMoney],[UserIP] )
|
|
VALUES (@REG_DATE,
|
|
@LOG_TYPE,@ACCOUNT_IDX,@USER_ID, @USER_NAME,@USER_EX_LEVEL,
|
|
@USER_EX_EXP,@CLASS_TYPE,@CLASS_LEVEL,@CLASS_EXPERT,@REMAIN_COUNT,
|
|
@MAP_ID,@X,@Y,@Z,@REWARD_TYPE,
|
|
@INDEX,@PRICE,@MULIPLE,@RESULT_MONEY,@USER_IP
|
|
)
|
|
COMMIT TRAN
|
|
|
|
END TRY
|
|
BEGIN CATCH
|
|
|
|
ROLLBACK TRAN
|
|
EXEC dbo.log_errorLog_set_log @ACCOUNT_IDX
|
|
RETURN -1
|
|
|
|
END CATCH
|
|
|
|
RETURN 0;
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_gameLog_set_log] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
-- Subject : dbo.dbo.log_gameLog_set_log
|
|
-- DBA : KeuN
|
|
-- DATE : 2014-11-26 10:10:00
|
|
-- Description : 통합 게임 로그 Insert
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[log_gameLog_set_log]
|
|
|
|
@LOG_TYPE INT,
|
|
@ACCOUNT_IDX INT,
|
|
@USER_ID VARCHAR(20),
|
|
@USER_NAME VARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@USER_EXP INT,
|
|
@CHANNEL_TYPE INT,
|
|
@TBL_INDEX INT,
|
|
@OBJECT_CODE INT,
|
|
@EVENT_TYPE TINYINT,
|
|
@PARAM_1 INT,
|
|
@PARAM_2 INT,
|
|
@PARAM_3 INT,
|
|
@PARAM_4 INT,
|
|
@PARAM_5 VARCHAR(50),
|
|
@USER_IP VARCHAR(15)
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
SET LOCK_TIMEOUT 10000
|
|
|
|
DECLARE @nReturn INT
|
|
DECLARE @REG_DATE DATETIME
|
|
|
|
SET @nReturn=0 -- True
|
|
SET @REG_DATE=GETDATE()
|
|
|
|
|
|
|
|
BEGIN TRY
|
|
|
|
BEGIN TRAN
|
|
INSERT dbo.GAME_LOG WITH (XLOCK, ROWLOCK) (RegDate, LogType, AccountIDX, UserID, UserName, UserLevel, UserExp, CpType, TBLIDX, ObjCode, EventType, Param1, Param2, Param3, Param4, Param5, UserIP)
|
|
VALUES (@REG_DATE, @LOG_TYPE, @ACCOUNT_IDX, @USER_ID, @USER_NAME, @USER_LEVEL, @USER_EXP, @CHANNEL_TYPE, @TBL_INDEX, @OBJECT_CODE, @EVENT_TYPE, @PARAM_1, @PARAM_2, @PARAM_3, @PARAM_4, @PARAM_5, @USER_IP)
|
|
COMMIT TRAN
|
|
|
|
END TRY
|
|
BEGIN CATCH
|
|
|
|
ROLLBACK TRAN
|
|
EXEC dbo.log_errorLog_set_log @ACCOUNT_IDX
|
|
RETURN -1
|
|
|
|
END CATCH
|
|
|
|
RETURN 0;
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_item_accessory_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_item_accessory_add]
|
|
|
|
@accountIDX INT,
|
|
@nickName NVARCHAR(20),
|
|
@userLevel INT,
|
|
@itemCode INT,
|
|
@eventType INT,
|
|
@amount INT,
|
|
@userIP VARCHAR(15),
|
|
@note VARCHAR(100)
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
|
|
INSERT INTO dbo.log_buy_item_accessory (
|
|
accountIDX, nickName, userLevel, itemCode, eventType, amount, userIP, note, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @itemCode, @eventType, @amount, @userIP, @note, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_item_class_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_item_class_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @userLevel int
|
|
, @classType int
|
|
, @limitType int
|
|
, @eventType int
|
|
, @amount int
|
|
, @userIP varchar(15)
|
|
, @note varchar(100)
|
|
)
|
|
AS
|
|
INSERT INTO log_buy_item_class (accountIDX, nickName, userLevel, classType, limitType, eventType, amount, userIP, note, regDate)
|
|
VALUES (@accountIDX, @nickName, @userLevel, @classType, @limitType, @eventType, @amount, @userIP, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_item_costume_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_item_costume_add]
|
|
(
|
|
@accountIDX INT
|
|
, @nickName NVARCHAR(20)
|
|
, @userLevel INT
|
|
, @itemCode INT
|
|
, @eventType INT
|
|
, @amount INT
|
|
, @userIP VARCHAR(15)
|
|
, @note VARCHAR(100)
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_buy_item_costume (
|
|
accountIDX, nickName, userLevel, itemCode, eventType, amount, userIP, note, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @itemCode, @eventType, @amount, @userIP, @note, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_item_decoration_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_item_decoration_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @classType int
|
|
, @kindred int
|
|
, @itemType int
|
|
, @itemCode int
|
|
, @eventType int
|
|
, @amount int
|
|
, @userIP varchar(15)
|
|
, @note varchar(100)
|
|
)
|
|
AS
|
|
INSERT INTO log_buy_item_decoration (accountIDX, nickName, classType, kindred, itemType, itemCode, eventType, amount, userIP, note, regDate)
|
|
VALUES (@accountIDX, @nickName, @classType, @kindred, @itemType, @itemCode, @eventType, @amount, @userIP, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_item_equip_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_item_equip_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @itemType int
|
|
, @itemCode int
|
|
, @reinforce int
|
|
, @machineType int
|
|
, @limitDate int
|
|
, @eventType int
|
|
, @amount int
|
|
, @userIP varchar(15)
|
|
, @note varchar(100)
|
|
)
|
|
AS
|
|
INSERT INTO log_buy_item_equip (accountIDX, nickName, itemType, itemCode, reinforce, machineType, limitDate, eventType, amount, userIP, note, regDate)
|
|
VALUES (@accountIDX, @nickName, @itemType, @itemCode, @reinforce, @machineType, @limitDate, @eventType, @amount, @userIP, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_item_gold_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_item_gold_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @userLevel int
|
|
, @itemType int
|
|
, @itemCode int
|
|
, @itemValue int
|
|
, @amount int
|
|
, @cpType smallint
|
|
, @billingID varchar(64)
|
|
, @userIP varchar(15)
|
|
, @note varchar(100)
|
|
, @buyType tinyint
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_buy_item_gold (
|
|
accountIDX, nickname, userLevel, itemType, itemCode, itemValue, amount, cpType, billingID, buyType, userIP, note, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickname, @userLevel, @itemType, @itemCode, @itemValue, @amount, @cpType, @billingID, @buyType, @userIP, @note, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_item_sbox_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_item_sbox_add]
|
|
(
|
|
@accountIDX INT
|
|
, @nickName NVARCHAR(20)
|
|
, @userLevel INT
|
|
, @presentType SMALLINT
|
|
, @value1 INT
|
|
, @value2 INT
|
|
, @amount INT
|
|
, @cpType INT
|
|
, @billingID VARCHAR(64)
|
|
, @logType INT
|
|
, @userIP VARCHAR(15)
|
|
, @note NVARCHAR(100)
|
|
, @limitDate INT
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
INSERT INTO dbo.log_buy_item_sbox (
|
|
accountIDX, nickName, userLevel, presentType, value1, value2, amount, cpType, billingID, logType, userIP, note, limitDate, regDate
|
|
)
|
|
VALUES (
|
|
@accountIDX, @nickName, @userLevel, @presentType, @value1, @value2, @amount, @cpType, @billingID, @logType, @userIP, @note, @limitDate, GETDATE()
|
|
)
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_item_special_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_item_special_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickName varchar(20)
|
|
, @itemType int
|
|
, @itemValue int
|
|
, @eventType int
|
|
, @amount int
|
|
, @userIP varchar(15)
|
|
, @note varchar(100)
|
|
)
|
|
AS
|
|
INSERT INTO log_buy_item_special (accountIDX, nickName, itemType, itemValue, eventType, amount, userIP, note, regDate)
|
|
VALUES (@accountIDX, @nickName, @itemType, @itemValue, @eventType, @amount, @userIP, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_present_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROCEDURE [dbo].[log_present_add]
|
|
(
|
|
@accountIDX int
|
|
, @nickname varchar(20)
|
|
, @receiveIDX int
|
|
, @presentType smallint
|
|
, @value1 int
|
|
, @value2 int
|
|
, @eventType int
|
|
, @userIP varchar(15)
|
|
, @note varchar(100)
|
|
)
|
|
AS
|
|
|
|
INSERT INTO log_present (accountIDX, nickname, receiveIDX, presentType, value1, value2, eventType, userIP, note, regDate)
|
|
VALUES (@accountIDX, @nickName, @receiveIDX, @presentType, @value1, @value2, @eventType, @userIP, @note, getdate())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_trace_prisoner_option_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
--IF OBJECT_ID('dbo.log_trace_prisoner_option_add','P') IS NOT NULL
|
|
--
|
|
-- DROP PROC dbo.log_trace_prisoner_option_add
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_trace_prisoner_option_add
|
|
-- Author : galura
|
|
-- Date : 2016-08-26
|
|
-- Description : 포로탈출 방 옵션
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[log_trace_prisoner_option_add]
|
|
|
|
@BLUE_MEMBER INT,
|
|
@RED_MEMBER INT,
|
|
@BLUE_MAX_MEMBER INT,
|
|
@RED_MAX_MEMBER INT,
|
|
@TEAM_MIX_OPTION INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_trace_prisoner_option (BlueMember, RedMember, BlueMaxMember, RedMaxMember, TeamMixOption, RegDate)
|
|
VALUES (@BLUE_MEMBER, @RED_MEMBER, @BLUE_MAX_MEMBER, @RED_MAX_MEMBER, @TEAM_MIX_OPTION, GETDATE())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_trace_prisoner_start_add] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
--IF OBJECT_ID('dbo.log_trace_prisoner_start_add','P') IS NOT NULL
|
|
--
|
|
-- DROP PROC dbo.log_trace_prisoner_start_add
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.log_trace_prisoner_start_add
|
|
-- Author : galura
|
|
-- Date : 2016-08-26
|
|
-- Description : 포로탈출 시작 방법 로그
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[log_trace_prisoner_start_add]
|
|
|
|
@SERVER_ID BIGINT,
|
|
@MAKE_ROOM INT,
|
|
@QUICK_START INT,
|
|
@LIST_SELECT INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.log_trace_prisoner_start (ServerID, MakeRoom, QuickStart, ListSelect, RegDate)
|
|
VALUES (@SERVER_ID, @MAKE_ROOM, @QUICK_START, @LIST_SELECT, GETDATE())
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_buy_class] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_buy_class]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, classtype, limittype, eventtype, amount, userip, note, regdate
|
|
FROM log_buy_item_class WITH(NOLOCK)
|
|
WHERE CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_buy_deco] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_buy_deco]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, classtype, kindred, itemtype, itemcode, eventtype, amount, userip, note, regdate
|
|
FROM log_buy_item_decoration WITH(NOLOCK)
|
|
WHERE CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_buy_equip] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_buy_equip]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, itemtype, itemcode, reinforce, machinetype, limitdate, eventtype, amount, userip, note, regdate
|
|
FROM log_buy_item_equip WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_buy_gold] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_buy_gold]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, userLevel, itemType, itemCode, itemValue, amount, cpType, billingID, userIP, note, regdate
|
|
FROM log_buy_item_gold WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_buy_sbox] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_buy_sbox]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, userLevel, presentType, value1, value2, amount, cpType, billingID, logType, userIP, note, limitDate, regdate
|
|
FROM log_buy_item_sbox WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_buy_special] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_buy_special]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, itemtype, itemValue, eventtype, amount, userip, note, regdate
|
|
FROM log_buy_item_special WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_data_medal] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_data_medal]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, medalType, limitType, logType, regdate
|
|
FROM log_data_medal WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_data_peso] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_data_peso]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, peso, logtype, regdate
|
|
FROM log_data_peso WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_data_play] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_data_play]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, playtype, modetype, subtype1, subtype2, playtime, deathtime, peso, win, lose, [kill], death, logtype, pcnum, regdate
|
|
FROM log_data_play WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_data_quest] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_data_quest]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, userlevel, mainidx, subidx, logtype, regdate
|
|
FROM log_data_quest WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_data_time] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_data_time]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, playtime, logtype, regdate
|
|
FROM log_data_time WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_data_trade] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_data_trade]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, itemType, value1, value2, price, logType, userIP, note, regdate
|
|
FROM log_data_trade WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_define_data] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_define_data]
|
|
@OBJ_NAME VARCHAR(32)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT code, ISNULL(itemNameKO, '') AS itemNameKO, ISNULL(itemNameID, '') AS itemNameID
|
|
FROM log_define WITH(NOLOCK)
|
|
WHERE objName=@OBJ_NAME
|
|
ORDER BY code ASC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_piece_divide] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_piece_divide]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickName, userLevel, itemType, itemCode, amount, materialCode, regdate
|
|
FROM log_data_piece_divide WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_piece_mix] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_piece_mix]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickName, userLevel, mixType, mixCode, resultType, useA, useB, resultA, resultB, regdate
|
|
FROM log_data_piece_mix WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_piece_obtain] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_piece_obtain]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickName, userLevel, playTime, step, amount, regdate
|
|
FROM log_data_piece_obtain WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[log_view_present] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- =============================================
|
|
--
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[log_view_present]
|
|
@SEARCH_NICK VARCHAR(20),
|
|
@SEARCH_SDATE VARCHAR(10),
|
|
@SEARCH_EDATE VARCHAR(10)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT TOP 1000 accountIdx, nickname, presenttype, value1, value2, eventtype, regdate
|
|
FROM log_present WITH(NOLOCK)
|
|
WHERE
|
|
CASE WHEN @SEARCH_NICK='' THEN '' ELSE nickname END = @SEARCH_NICK
|
|
AND regdate >= @SEARCH_SDATE AND regdate < DATEADD(day, 1, @SEARCH_EDATE)
|
|
ORDER BY idx DESC
|
|
END
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[USP_LOG_HACK_MESSAGE_SET_ADD] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.USP_LOG_HACK_MESSAGE_SET_ADD', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.USP_LOG_HACK_MESSAGE_SET_ADD
|
|
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.USP_LOG_HACK_MESSAGE_SET_ADD
|
|
-- Author : galura
|
|
-- Date : 2017-06-13
|
|
-- Description : 해킹 로그 추가
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[USP_LOG_HACK_MESSAGE_SET_ADD]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@MSG NVARCHAR(1000)
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.TBL_LOG_HACK_MESSAGE (
|
|
AccountIDX, Msg, RegDate
|
|
)
|
|
VALUES (
|
|
@ACCOUNT_IDX, @MSG, GETDATE()
|
|
);
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[USP_LOG_HACK_SET_ADD] Script Date: 5/4/2025 8:46:21 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
-- IF OBJECT_ID('dbo.USP_LOG_HACK_SET_ADD', 'P') IS NOT NULL
|
|
-- DROP PROC dbo.USP_LOG_HACK_SET_ADD
|
|
|
|
-- GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.USP_LOG_HACK_SET_ADD
|
|
-- Author : galura
|
|
-- Date : 2017-05-18
|
|
-- Description : 해킹 로그 추가
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[USP_LOG_HACK_SET_ADD]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@NICK_NAME NVARCHAR(20),
|
|
@USER_LEVEL INT,
|
|
@PLAY_TYPE INT,
|
|
@MODE_TYPE INT,
|
|
@SUB_TYPE1 INT,
|
|
@SUB_TYPE2 INT,
|
|
@ITEM_TYPE INT,
|
|
@ITEM_CODE INT,
|
|
@ITEM_VALUE INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
INSERT INTO dbo.TBL_LOG_HACK (
|
|
AccountIDX, NickName, UserLevel, PlayType, ModeType, SubType1, SubType2, ItemType, ItemCode, ItemValue, RegDate
|
|
)
|
|
VALUES (
|
|
@ACCOUNT_IDX, @NICK_NAME, @USER_LEVEL, @PLAY_TYPE, @MODE_TYPE, @SUB_TYPE1, @SUB_TYPE2, @ITEM_TYPE, @ITEM_CODE, @ITEM_VALUE, GETDATE()
|
|
);
|
|
GO
|
|
USE [master]
|
|
GO
|
|
ALTER DATABASE [LosaLogData] SET READ_WRITE
|
|
GO
|