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