mj/ls-2019-source
1
0 Fork 0
forked from LosaDev/ls-2019-source
Code Pull Requests Activity
Files
main
ls-2019-source/database/02_LosaGame_log.sql
T

599 lines
21 KiB
Transact-SQL
Raw Permalink Blame History

-- LosaDev 2019: LosaGame_Log.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 [LosaGame_log] Script Date: 5/4/2025 8:44:49 PM ******/
-- (LosaDev) CREATE DATABASE [LosaGame_log] is done by 00_create_databases.sql
GO
ALTER DATABASE [LosaGame_log] SET COMPATIBILITY_LEVEL = 160
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [LosaGame_log].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [LosaGame_log] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [LosaGame_log] SET ANSI_NULLS OFF
GO
ALTER DATABASE [LosaGame_log] SET ANSI_PADDING OFF
GO
ALTER DATABASE [LosaGame_log] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [LosaGame_log] SET ARITHABORT OFF
GO
ALTER DATABASE [LosaGame_log] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [LosaGame_log] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [LosaGame_log] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [LosaGame_log] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [LosaGame_log] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [LosaGame_log] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [LosaGame_log] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [LosaGame_log] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [LosaGame_log] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [LosaGame_log] SET DISABLE_BROKER
GO
ALTER DATABASE [LosaGame_log] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [LosaGame_log] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [LosaGame_log] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [LosaGame_log] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [LosaGame_log] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [LosaGame_log] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [LosaGame_log] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [LosaGame_log] SET RECOVERY SIMPLE
GO
ALTER DATABASE [LosaGame_log] SET MULTI_USER
GO
ALTER DATABASE [LosaGame_log] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [LosaGame_log] SET DB_CHAINING OFF
GO
ALTER DATABASE [LosaGame_log] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [LosaGame_log] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [LosaGame_log] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [LosaGame_log] SET ACCELERATED_DATABASE_RECOVERY = OFF
GO
ALTER DATABASE [LosaGame_log] SET QUERY_STORE = ON
GO
ALTER DATABASE [LosaGame_log] 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 [LosaGame_log]
GO
/****** Object: User [lstggame] Script Date: 5/4/2025 8:44:49 PM ******/
CREATE USER [lstggame] FOR LOGIN [lstggame] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: Table [dbo].[log_cash] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_cash](
[idx] [int] IDENTITY(1,1) NOT NULL,
[accountIDX] [int] NOT NULL,
[userIP] [varchar](16) NOT NULL,
[DBID] [varchar](16) NOT NULL,
[applyType] [char](2) NOT NULL,
[amount] [int] NOT NULL,
[note] [varchar](500) NOT NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_class_buytime] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_class_buytime](
[idx] [int] IDENTITY(1,1) NOT NULL,
[classType] [int] NOT NULL,
[buyTime] [bigint] NOT NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_class_rental_history] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_class_rental_history](
[idx] [int] IDENTITY(1,1) NOT NULL,
[accountIDX] [int] NOT NULL,
[friendIDX] [int] NOT NULL,
[classType] [int] NOT NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_data_clover] Script Date: 5/4/2025 8:44:49 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 [index] Script Date: 5/4/2025 8:44:49 PM ******/
CREATE CLUSTERED INDEX [index] ON [dbo].[log_data_clover]
(
[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: Table [dbo].[log_event_marble] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_event_marble](
[idx] [int] IDENTITY(1,1) NOT NULL,
[accountidx] [int] NOT NULL,
[userID] [varchar](20) NOT NULL,
[cpType] [int] NOT NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_event_openbeta_coin] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_event_openbeta_coin](
[idx] [int] IDENTITY(1,1) NOT NULL,
[accountIDX] [int] NOT NULL,
[coin] [int] NOT NULL,
[flag] [int] NOT NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_guild_mark] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_guild_mark](
[idx] [int] IDENTITY(1,1) NOT NULL,
[guildIDX] [int] NOT NULL,
[accountIDX] [int] NOT NULL,
[havepeso] [bigint] NOT NULL,
[markprice] [int] NOT NULL,
[nowmark] [int] NOT NULL,
[changemark] [int] NOT NULL,
[flag] [int] NOT NULL,
[userIP] [varchar](15) NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_cheer] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_cheer](
[idx] [int] IDENTITY(1,1) NOT NULL,
[cheerIDX] [int] NOT NULL,
[startDate] [int] NOT NULL,
[accountIDX] [int] NOT NULL,
[leagueIDX] [int] NOT NULL,
[teamIDX] [int] NOT NULL,
[regDate] [datetime] NOT NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_info_user] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_info_user](
[idx] [int] IDENTITY(1,1) NOT NULL,
[infoIDX] [int] NULL,
[leagueIDX] [int] NULL,
[leagueName] [nvarchar](20) NULL,
[maxRound] [smallint] NULL,
[bannerA] [int] NULL,
[bannerB] [int] NULL,
[modeType] [int] NULL,
[maxcount] [tinyint] NULL,
[autoType] [tinyint] NULL,
[announce] [nvarchar](512) NULL,
[recruitDate] [int] NULL,
[waitDate] [int] NULL,
[regDate] [datetime] NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_list] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_list](
[idx] [int] IDENTITY(1,1) NOT NULL,
[leagueIDX] [int] NULL,
[accountIDX] [int] NULL,
[startDate] [int] NULL,
[endDate] [int] NULL,
[leagueType] [tinyint] NULL,
[leagueState] [tinyint] NULL,
[regDate] [datetime] NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_list_user] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_list_user](
[idx] [int] IDENTITY(1,1) NOT NULL,
[leagueIDX] [int] NULL,
[accountIDX] [int] NULL,
[startDate] [int] NULL,
[endDate] [int] NULL,
[leagueType] [tinyint] NULL,
[leagueState] [tinyint] NULL,
[regDate] [datetime] NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_round_user] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_round_user](
[idx] [int] IDENTITY(1,1) NOT NULL,
[roundIDX] [int] NULL,
[infoIDX] [int] NULL,
[roundType1_playDate] [int] NULL,
[roundType1_presentCode1] [int] NULL,
[roundType1_presentCode2] [int] NULL,
[roundType1_presentCode3] [int] NULL,
[roundType1_presentCode4] [int] NULL,
[roundType2_playDate] [int] NULL,
[roundType2_presentCode1] [int] NULL,
[roundType2_presentCode2] [int] NULL,
[roundType2_presentCode3] [int] NULL,
[roundType2_presentCode4] [int] NULL,
[roundType3_playDate] [int] NULL,
[roundType3_presentCode1] [int] NULL,
[roundType3_presentCode2] [int] NULL,
[roundType3_presentCode3] [int] NULL,
[roundType3_presentCode4] [int] NULL,
[roundType4_playDate] [int] NULL,
[roundType4_presentCode1] [int] NULL,
[roundType4_presentCode2] [int] NULL,
[roundType4_presentCode3] [int] NULL,
[roundType4_presentCode4] [int] NULL,
[roundType5_playDate] [int] NULL,
[roundType5_presentCode1] [int] NULL,
[roundType5_presentCode2] [int] NULL,
[roundType5_presentCode3] [int] NULL,
[roundType5_presentCode4] [int] NULL,
[roundType6_playDate] [int] NULL,
[roundType6_presentCode1] [int] NULL,
[roundType6_presentCode2] [int] NULL,
[roundType6_presentCode3] [int] NULL,
[roundType6_presentCode4] [int] NULL,
[roundType7_playDate] [int] NULL,
[roundType7_presentCode1] [int] NULL,
[roundType7_presentCode2] [int] NULL,
[roundType7_presentCode3] [int] NULL,
[roundType7_presentCode4] [int] NULL,
[roundType8_playDate] [int] NULL,
[roundType8_presentCode1] [int] NULL,
[roundType8_presentCode2] [int] NULL,
[roundType8_presentCode3] [int] NULL,
[roundType8_presentCode4] [int] NULL,
[roundType9_playDate] [int] NULL,
[roundType9_presentCode1] [int] NULL,
[roundType9_presentCode2] [int] NULL,
[roundType9_presentCode3] [int] NULL,
[roundType9_presentCode4] [int] NULL,
[roundType10_playDate] [int] NULL,
[roundType10_presentCode1] [int] NULL,
[roundType10_presentCode2] [int] NULL,
[roundType10_presentCode3] [int] NULL,
[roundType10_presentCode4] [int] NULL,
[roundType11_playDate] [int] NULL,
[roundType11_presentCode1] [int] NULL,
[roundType11_presentCode2] [int] NULL,
[roundType11_presentCode3] [int] NULL,
[roundType11_presentCode4] [int] NULL,
[regDate] [datetime] NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_team] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_team](
[idx] [int] IDENTITY(1,1) NOT NULL,
[teamIDX] [int] NULL,
[leagueIDX] [int] NULL,
[startDate] [int] NULL,
[teamName] [nvarchar](20) NULL,
[leaderIDX] [int] NULL,
[leagueStartPosition] [smallint] NULL,
[leaguePosition] [smallint] NULL,
[maxcount] [tinyint] NULL,
[cheerPoint] [int] NULL,
[currentRound] [tinyint] NULL,
[factionPoint] [int] NULL,
[factionType] [tinyint] NULL,
[regDate] [datetime] NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_team_member] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_team_member](
[idx] [int] IDENTITY(1,1) NOT NULL,
[teamMemberIDX] [int] NULL,
[startDate] [int] NULL,
[accountIDX] [int] NULL,
[leagueIDX] [int] NULL,
[teamIDX] [int] NULL,
[joinType] [tinyint] NULL,
[regDate] [datetime] NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_team_member_user] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_team_member_user](
[idx] [int] IDENTITY(1,1) NOT NULL,
[teamMemberIDX] [int] NOT NULL,
[startDate] [int] NOT NULL,
[accountIDX] [int] NOT NULL,
[leagueIDX] [int] NOT NULL,
[teamIDX] [int] NOT NULL,
[joinType] [tinyint] NOT NULL,
[regDate] [datetime] NOT NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_league_team_user] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_league_team_user](
[idx] [int] IDENTITY(1,1) NOT NULL,
[teamIDX] [int] NULL,
[leagueIDX] [int] NULL,
[startDate] [int] NULL,
[teamName] [nvarchar](20) NULL,
[leaderIDX] [int] NULL,
[leagueStartPosition] [smallint] NULL,
[leaguePosition] [smallint] NULL,
[maxcount] [tinyint] NULL,
[cheerPoint] [int] NULL,
[currentRound] [tinyint] NULL,
[factionPoint] [int] NULL,
[factionType] [tinyint] NULL,
[regDate] [datetime] NULL,
[insertDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_level_playtime] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_level_playtime](
[idx] [int] IDENTITY(1,1) NOT NULL,
[userLevel] [int] NOT NULL,
[playTime] [bigint] NOT NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_mannerpoint] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_mannerpoint](
[idx] [int] IDENTITY(1,1) NOT NULL,
[playType] [int] NOT NULL,
[modeType] [int] NOT NULL,
[sub1Type] [int] NOT NULL,
[sub2Type] [int] NOT NULL,
[reportIDX] [int] NULL,
[reportNick] [varchar](20) NULL,
[reportpubIP] [varchar](15) NOT NULL,
[reportpriIP] [varchar](15) NOT NULL,
[receiveIDX] [nchar](10) NULL,
[receiveNick] [varchar](20) NULL,
[receivepubIP] [varchar](15) NOT NULL,
[roomInfo] [varchar](2000) NULL,
[chatInfo] [varchar](3000) NULL,
[note] [varchar](500) NULL,
[reason] [varchar](2000) NULL,
[flag] [tinyint] NOT NULL,
[resultType] [tinyint] NOT NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_mannerpoint_sitevisit] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_mannerpoint_sitevisit](
[idx] [int] IDENTITY(1,1) NOT NULL,
[accountIDX] [int] NOT NULL,
[point] [smallint] NOT NULL,
[userIP] [varchar](15) NOT NULL,
[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_tooni_migration] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[log_tooni_migration](
[idx] [int] IDENTITY(1,1) NOT NULL,
[TooniIDX] [int] NOT NULL,
[TooniID] [varchar](32) NOT NULL,
[AccountIDX] [int] NOT NULL,
[RegDate] [datetime] NOT NULL,
CONSTRAINT [PK_log_tooni_migration] 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: Index [accountidx] Script Date: 5/4/2025 8:44:49 PM ******/
CREATE NONCLUSTERED INDEX [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 [regDate] Script Date: 5/4/2025 8:44:49 PM ******/
CREATE NONCLUSTERED INDEX [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: Index [NC_log_tooni_migration_AccountIDX] Script Date: 5/4/2025 8:44:49 PM ******/
CREATE NONCLUSTERED INDEX [NC_log_tooni_migration_AccountIDX] ON [dbo].[log_tooni_migration]
(
[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 [NC_log_tooni_migration_TooniID] Script Date: 5/4/2025 8:44:49 PM ******/
CREATE NONCLUSTERED INDEX [NC_log_tooni_migration_TooniID] ON [dbo].[log_tooni_migration]
(
[TooniID] 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_class_buytime] ADD CONSTRAINT [DF_log_class_buytime_classType] DEFAULT ((0)) FOR [classType]
GO
ALTER TABLE [dbo].[log_class_buytime] ADD CONSTRAINT [DF_log_class_buytime_buyTime] DEFAULT ((0)) FOR [buyTime]
GO
ALTER TABLE [dbo].[log_class_buytime] ADD CONSTRAINT [DF_log_class_buytime_regDate] DEFAULT (getdate()) FOR [regDate]
GO
ALTER TABLE [dbo].[log_class_rental_history] ADD CONSTRAINT [DF_log_class_rental_history_classType] DEFAULT ((0)) FOR [classType]
GO
ALTER TABLE [dbo].[log_class_rental_history] ADD CONSTRAINT [DF_log_class_rental_history_regDate] DEFAULT (getdate()) FOR [regDate]
GO
ALTER TABLE [dbo].[log_data_clover] ADD CONSTRAINT [DF_log_clover_friendIdx] DEFAULT ((0)) FOR [friendIDX]
GO
ALTER TABLE [dbo].[log_data_clover] ADD CONSTRAINT [DF_log_clover_regDate] DEFAULT (getdate()) FOR [regDate]
GO
ALTER TABLE [dbo].[log_event_marble] ADD CONSTRAINT [DF_log_event_marble_regDate] DEFAULT (getdate()) FOR [regDate]
GO
ALTER TABLE [dbo].[log_event_openbeta_coin] ADD CONSTRAINT [DF_log_event_openbeta_coin_flag] DEFAULT ((0)) FOR [flag]
GO
ALTER TABLE [dbo].[log_event_openbeta_coin] ADD CONSTRAINT [DF_log_event_openbeta_coin_regDate] DEFAULT (getdate()) FOR [regDate]
GO
ALTER TABLE [dbo].[log_guild_mark] ADD CONSTRAINT [DF_log_guild_mark_flag] DEFAULT ((0)) FOR [flag]
GO
ALTER TABLE [dbo].[log_guild_mark] ADD CONSTRAINT [DF_log_guild_mark_regDate] DEFAULT (getdate()) FOR [regDate]
GO
ALTER TABLE [dbo].[log_league_cheer] ADD CONSTRAINT [DF_log_league_cheer_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_league_info_user] ADD CONSTRAINT [DF_log_league_info_user_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_league_list] ADD CONSTRAINT [DF_log_league_list_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_league_list_user] ADD CONSTRAINT [DF_log_league_list_user_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_league_round_user] ADD CONSTRAINT [DF_log_league_round_user_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_league_team] ADD CONSTRAINT [DF_log_league_team_leagueStartPosition] DEFAULT ((0)) FOR [leagueStartPosition]
GO
ALTER TABLE [dbo].[log_league_team] ADD CONSTRAINT [DF_log_league_team_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_league_team_member] ADD CONSTRAINT [DF_log_league_team_member_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_league_team_member_user] ADD CONSTRAINT [DF_log_league_team_member_user_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_league_team_user] ADD CONSTRAINT [DF_log_league_team_user_insertDate] DEFAULT (getdate()) FOR [insertDate]
GO
ALTER TABLE [dbo].[log_level_playtime] ADD CONSTRAINT [DF_log_level_playtime_userLevel] DEFAULT ((0)) FOR [userLevel]
GO
ALTER TABLE [dbo].[log_level_playtime] ADD CONSTRAINT [DF_log_level_playtime_playTime] DEFAULT ((0)) FOR [playTime]
GO
ALTER TABLE [dbo].[log_level_playtime] ADD CONSTRAINT [DF_log_level_playtime_regDate] DEFAULT (getdate()) FOR [regDate]
GO
ALTER TABLE [dbo].[log_mannerpoint] ADD CONSTRAINT [DF_log_mannerpoint_flag] DEFAULT ((0)) FOR [flag]
GO
ALTER TABLE [dbo].[log_mannerpoint] ADD CONSTRAINT [DF_log_mannerpoint_resultType] DEFAULT ((0)) FOR [resultType]
GO
ALTER TABLE [dbo].[log_tooni_migration] ADD DEFAULT (getdate()) FOR [RegDate]
GO
/****** Object: StoredProcedure [dbo].[game_item_etc_get_self_index] Script Date: 5/4/2025 8:44:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[game_item_etc_get_self_index]
(
@accountIDX int
)
AS
SELECT TOP 1 idx FROM userItemEtcDB WHERE accountIDX = @accountIDX ORDER BY idx DESC
GO
/****** Object: StoredProcedure [dbo].[log_data_clover_add] Script Date: 5/4/2025 8:44:49 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
INSERT INTO dbo.log_data_clover( accountIDX, friendIDX, eventType, CloverCount, regDate )
VALUES( @userIDX, @FriendIDX, @Type, @Count, GETDATE() );
GO
USE [master]
GO
ALTER DATABASE [LosaGame_log] SET READ_WRITE
GO
View Git Blame Copy Permalink