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>
92 lines
1.5 KiB
Transact-SQL
92 lines
1.5 KiB
Transact-SQL
alter table PartyInfo
|
|
drop column GID
|
|
|
|
go
|
|
|
|
alter Table TblGuildMember
|
|
add Tactics tinyint NULL
|
|
|
|
go
|
|
|
|
drop proc dbo.InsertParty_Part2
|
|
|
|
go
|
|
|
|
/*
|
|
파티 추가 프로시져
|
|
*/
|
|
|
|
CREATE PROCEDURE dbo.InsertParty_Part2
|
|
@Party AS varBINARY(202), /* 친구 리스트 */
|
|
@UserInfo AS varBINARY(72) /* 유저 정보 */
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
|
|
INSERT INTO PartyInfo (Party, UserInfo) VALUES (@Party, @UserInfo)
|
|
|
|
/* 고유 아이디 돌려줌 */
|
|
SELECT CAST(SCOPE_IDENTITY() AS INT)
|
|
|
|
go
|
|
|
|
drop proc dbo.GetPartyInfo_Part2
|
|
|
|
go
|
|
|
|
/*
|
|
파티 정보 보기 프로시져
|
|
*/
|
|
|
|
CREATE PROCEDURE dbo.GetPartyInfo_Part2
|
|
@Party_uid AS INT /* 파티 아이디 */
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
SELECT Party, UserInfo FROM PartyInfo WHERE PID = @Party_uid
|
|
|
|
go
|
|
|
|
drop proc dbo.UpdatePartyInfo_Part2
|
|
|
|
go
|
|
|
|
CREATE PROCEDURE dbo.UpdatePartyInfo_Part2
|
|
@Party_uid AS INT, /* 파티 고유 아이디 */
|
|
@Party AS varBINARY(202), /* 친구 리스트 */
|
|
@UserInfo AS varBINARY(72) /* 유저 정보 */
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
UPDATE PartyInfo SET Party = @Party, UserInfo = @UserInfo WHERE PID = @Party_uid
|
|
|
|
|
|
/*
|
|
길드 관계 DB
|
|
|
|
DESC : 옛날 관계 DB 인 TblGuildOtherList 테이블을 삭제하고
|
|
TblGuildRelation 을 추가한다.
|
|
*/
|
|
|
|
DROP TABLE dbo.TblGuildOtherList
|
|
|
|
GO
|
|
|
|
CREATE TABLE [TblGuildRelation] (
|
|
[nGuildID] [int] NOT NULL ,
|
|
[nTargetGuildID] [int] NOT NULL ,
|
|
[tnRelation] [tinyint] NOT NULL ,
|
|
CONSTRAINT [PK_TblGuildRelation_1] PRIMARY KEY CLUSTERED
|
|
(
|
|
[nGuildID],
|
|
[nTargetGuildID]
|
|
) ON [PRIMARY] ,
|
|
CHECK ([tnRelation] = 1 or [tnRelation] = 2 or [tnRelation] = 3)
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|