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