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>
128 lines
2.7 KiB
Transact-SQL
128 lines
2.7 KiB
Transact-SQL
|
||
-- Å×¼· DB±¸Á¶º¯°æÇϱâ
|
||
|
||
INSERT INTO AdminList
|
||
SELECT * FROM Test.dbo.AdminList
|
||
|
||
INSERT INTO CharInfo
|
||
SELECT * FROM Test.dbo.CharInfo
|
||
|
||
INSERT INTO CharInfo_Time
|
||
SELECT * FROM Test.dbo.CharInfo_Time
|
||
|
||
INSERT INTO CharInfoEx (CID,Total,ServerID,Config)
|
||
SELECT * FROM Test.dbo.CharInfoEx
|
||
|
||
INSERT INTO CharItem
|
||
SELECT * FROM Test.dbo.CharItem
|
||
|
||
INSERT INTO CharItemEx
|
||
SELECT * FROM Test.dbo.CharItemEx
|
||
|
||
INSERT INTO CharPos
|
||
SELECT * FROM Test.dbo.CharPos
|
||
|
||
INSERT INTO CharSkill
|
||
SELECT * FROM Test.dbo.CharSkill
|
||
|
||
INSERT INTO Friend
|
||
SELECT * FROM Test.dbo.Friend
|
||
|
||
INSERT INTO ItemUID
|
||
SELECT * FROM Test.dbo.ItemUID
|
||
|
||
GO
|
||
|
||
SET IDENTITY_INSERT PartyInfo ON
|
||
|
||
INSERT INTO PartyInfo (PID,Party)
|
||
SELECT * FROM Test.dbo.PartyInfo
|
||
|
||
SET IDENTITY_INSERT PartyInfo OFF
|
||
|
||
GO
|
||
|
||
INSERT INTO Quest
|
||
SELECT * FROM Test.dbo.Quest
|
||
|
||
GO
|
||
|
||
SET IDENTITY_INSERT TblCampInfo ON
|
||
|
||
INSERT INTO TblCampInfo(nCampID,nGuildID,nHP,tnZone,tnChannel,snObjectType,tnState,tnSubState,
|
||
tnUpgradeStep,RemainTime,LastUseTime,bRight,fPosX,fPosY,fPosZ)
|
||
SELECT nCampID,nGuildID,nHP,tnZone,tnChannel,5337,tnState,0,
|
||
tnUpgradeStep,RemainTime,LastUseTime,bRight,fPosX,fPosY,fPosZ
|
||
FROM Test.dbo.TblCampInfo
|
||
|
||
SET IDENTITY_INSERT TblCampInfo OFF
|
||
|
||
GO
|
||
|
||
|
||
INSERT INTO TblEventItem
|
||
SELECT * FROM Test.dbo.TblEventItem
|
||
|
||
GO
|
||
|
||
|
||
INSERT INTO TblCharDelHistory
|
||
SELECT intCID,intUID,dateInsertTime,dateDeleteTime,0 FROM Test.dbo.TblCharDelHistory
|
||
|
||
|
||
DECLARE @OldServerGroupID TINYINT
|
||
SET @OldServerGroupID = 22
|
||
|
||
SET IDENTITY_INSERT TblGuildInfo ON
|
||
|
||
INSERT INTO TblGuildInfo (nGuildID,strGuildName,tnGuildLevel,nGuildFame,nGuildGold,tLastLogout,tCheckMember,tGMLastLogout,
|
||
bGuildMark,bRight,tnNationType,tChangeState,OldServerGroupID)
|
||
SELECT *,@OldServerGroupID FROM Test.dbo.TblGuildInfo
|
||
|
||
|
||
SET IDENTITY_INSERT TblGuildInfo OFF
|
||
|
||
|
||
INSERT INTO TblGuildMember
|
||
SELECT * FROM Test.dbo.TblGuildMember
|
||
|
||
|
||
-- CHECK
|
||
INSERT INTO TblGuildOtherList
|
||
SELECT * FROM Test.dbo.TblGuildOtherList
|
||
|
||
|
||
INSERT INTO dbo.TblItemLog
|
||
SELECT * FROM Test.dbo.TblItemLog
|
||
|
||
|
||
INSERT INTO dbo.TblGuildRestoreData
|
||
SELECT nGuildID,strGuildName,nGuildGold,tDeleteTime,NULL,@OldServerGroupID FROM Test.dbo.TblGuildRestoreData
|
||
|
||
|
||
INSERT INTO dbo.TblUnifiedItemStore1
|
||
SELECT UID,@OldServerGroupID,Password,Frag,Gold,Store FROM Test.dbo.ItemStore1
|
||
|
||
|
||
INSERT INTO dbo.TblUnifiedItemStore2
|
||
SELECT UID,@OldServerGroupID,Store FROM Test.dbo.ItemStore2
|
||
|
||
INSERT INTO dbo.UserInfo
|
||
SELECT UID,@OldServerGroupID,Nation,0,Char1,Char2,Char3,Char4,Char5 FROM Test.dbo.UserInfo
|
||
|
||
|
||
INSERT INTO TblUnifiedCharList
|
||
SELECT UID,@OldServerGroupID,B.CID,B.CID,B.Name FROM (
|
||
|
||
SELECT UID,Char1 AS CID FROM UserInfo
|
||
UNION ALL
|
||
SELECT UID,Char2 FROM UserInfo
|
||
UNION ALL
|
||
SELECT UID,Char3 FROM UserInfo
|
||
UNION ALL
|
||
SELECT UID,Char4 FROM UserInfo
|
||
UNION ALL
|
||
SELECT UID,Char5 FROM UserInfo ) A JOIN CharInfo B on A.CID = B.CID
|
||
|
||
|