LGram16
dd97ddec92
Move git root from Client/ to src/ to track all source code: - Client: Game client source (moved to Client/Client/) - Server: Game server source - GameTools: Development tools - CryptoSource: Encryption utilities - database: Database scripts - Script: Game scripts - rylCoder_16.02.2008_src: Legacy coder tools - GMFont, Game: Additional resources 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
55 lines
1.5 KiB
Transact-SQL
55 lines
1.5 KiB
Transact-SQL
Create Table CharDeleteData
|
|
(
|
|
[Index] [int] IDENTITY (1, 1),
|
|
[CID] [int] Not NULL,
|
|
[Name] [varchar] (16) NULL,
|
|
[Level] [tinyint] NULL,
|
|
[Class] [smallint] NULL,
|
|
|
|
PRIMARY KEY CLUSTERED
|
|
(
|
|
[CID]
|
|
)
|
|
)
|
|
|
|
go
|
|
|
|
-- 퀘스트 삭제 --
|
|
|
|
Delete From Quest Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 캐릭터 시간 --
|
|
|
|
Delete From CharInfo_Time Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 캐릭터 정보 Ex --
|
|
|
|
Delete From CharInfoEx Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 캐릭터 아이템 --
|
|
|
|
Delete From CharItem Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 캐릭터 아이템 Ex --
|
|
|
|
Delete From CharItemEx Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 캐릭터 위치 --
|
|
|
|
Delete From CharPos Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 캐릭터 스킬 --
|
|
|
|
Delete From CharSkill Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 친구, 거부 리스트 --
|
|
|
|
Delete From Friend Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 데이터 저장
|
|
|
|
Insert into CharDeleteData Select CID, [Name], [Level], Class From CharInfo where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate())
|
|
|
|
-- 캐릭터 정보 삭제 --
|
|
|
|
Delete From CharInfo Where CID In (Select intCID From TblCharDelHistory where dateDeleteTime < getdate()) |