CREATE TABLE [dbo].[mercenary] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[residence_id] [int] NOT NULL ,
	[npc_id] [int] NOT NULL ,
	[x] [int] NOT NULL ,
	[y] [int] NOT NULL ,
	[z] [int] NOT NULL ,
	[angle] [int] NOT NULL ,
	[hp] [int] NOT NULL ,
	[mp] [int] NOT NULL 
) ON [PRIMARY]
GO