CREATE TABLE [dbo].[BATTLEPASS_MISSIONS](
	[mission_id] [int] IDENTITY(1,1) NOT NULL,
	[season_id] [int] NOT NULL,
	[mission_scope] [varchar](15) NOT NULL,
	[event_key] [varchar](50) NOT NULL,
	[target_value] [int] NOT NULL,
	[xp_reward] [int] NOT NULL,
	[title] [varchar](120) NOT NULL,
	[description] [varchar](300) NULL,
	[hidden] [tinyint] NOT NULL DEFAULT 0,
	[active] [tinyint] NOT NULL DEFAULT 1,
	[sort_order] [int] NOT NULL DEFAULT 0,
	[monster_index] [int] NULL,
	[mission_image] [varchar](255) NULL,
	CONSTRAINT [PK_BATTLEPASS_MISSIONS] PRIMARY KEY CLUSTERED ([mission_id] ASC)
)
