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>
84 lines
956 B
Transact-SQL
84 lines
956 B
Transact-SQL
|
|
/*
|
|
디폴트 = 0
|
|
*/
|
|
|
|
CREATE VIEW dbo.CharInfo
|
|
AS
|
|
SELECT * FROM CharInfo_1
|
|
UNION ALL
|
|
SELECT * FROM CharInfo_2
|
|
UNION ALL
|
|
SELECT * FROM CharInfo_3
|
|
UNION ALL
|
|
SELECT * FROM CharInfo_4
|
|
|
|
GO
|
|
|
|
|
|
/*
|
|
캐릭터 위치 테이블 뷰
|
|
*/
|
|
CREATE VIEW dbo.CharPos
|
|
AS
|
|
SELECT * FROM CharPos_1
|
|
UNION ALL
|
|
SELECT * FROM CharPos_2
|
|
UNION ALL
|
|
SELECT * FROM CharPos_3
|
|
UNION ALL
|
|
SELECT * FROM CharPos_4
|
|
|
|
GO
|
|
|
|
|
|
/*
|
|
캐릭터 추가 정 테이블 뷰
|
|
*/
|
|
CREATE VIEW dbo.CharSkill
|
|
AS
|
|
SELECT * FROM CharSkill_1
|
|
UNION ALL
|
|
SELECT * FROM CharSkill_2
|
|
UNION ALL
|
|
SELECT * FROM CharSkill_3
|
|
UNION ALL
|
|
SELECT * FROM CharSkill_4
|
|
|
|
GO
|
|
|
|
|
|
/*
|
|
파티 정보 테이블 뷰
|
|
*/
|
|
CREATE VIEW dbo.PartyInfo
|
|
AS
|
|
SELECT * FROM PartyInfo_1
|
|
UNION ALL
|
|
SELECT * FROM PartyInfo_2
|
|
UNION ALL
|
|
SELECT * FROM PartyInfo_3
|
|
UNION ALL
|
|
SELECT * FROM PartyInfo_4
|
|
|
|
GO
|
|
|
|
|
|
/*
|
|
유저 정보 테이블 뷰
|
|
*/
|
|
CREATE VIEW dbo.UserInfo
|
|
AS
|
|
SELECT * FROM UserInfo_1
|
|
UNION ALL
|
|
SELECT * FROM UserInfo_2
|
|
UNION ALL
|
|
SELECT * FROM UserInfo_3
|
|
UNION ALL
|
|
SELECT * FROM UserInfo_4
|
|
|
|
GO
|
|
|
|
|
|
|