CREATE TABLE [dbo].[MK_Quest](
   [Name] [nvarchar](10) NOT NULL,
   [quest1] [smallint] NOT NULL,
   [quest2] [smallint] NOT NULL,
   [quest3] [smallint] NOT NULL,
   [quest4] [smallint] NOT NULL,
   [quest5] [smallint] NOT NULL,
   [quest6] [smallint] NOT NULL,
   [quest7] [smallint] NOT NULL,
   [quest8] [smallint] NOT NULL,
   [quest9] [smallint] NOT NULL,
   [quest10] [smallint] NOT NULL,
   [quest11] [smallint] NOT NULL,
   [quest12] [smallint] NOT NULL,
   [quest13] [smallint] NOT NULL,
   [quest14] [smallint] NOT NULL,
   [quest15] [smallint] NOT NULL,
   [quest16] [smallint] NOT NULL,
   [quest17] [smallint] NOT NULL,
   [quest18] [smallint] NOT NULL,
   [quest19] [smallint] NOT NULL,
   [quest20] [smallint] NOT NULL,
   [nivel] [smallint] NOT NULL,
   [quest21] [smallint] NOT NULL,
   [quest22] [smallint] NOT NULL,
   [quest23] [smallint] NOT NULL,
   [quest24] [smallint] NOT NULL,
   [quest25] [smallint] NOT NULL,
   [quest26] [smallint] NOT NULL,
   [quest27] [smallint] NOT NULL,
   [quest28] [smallint] NOT NULL,
   [quest29] [smallint] NOT NULL,
   [quest30] [smallint] NOT NULL,
   [quest31] [smallint] NOT NULL,
   [quest32] [smallint] NOT NULL,
   [quest33] [smallint] NOT NULL,
   [quest34] [smallint] NOT NULL,
   [quest35] [smallint] NOT NULL,
 CONSTRAINT [PK_Quest] PRIMARY KEY CLUSTERED
(
   [Name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MK_Quest]  WITH CHECK ADD  CONSTRAINT [fk_name_char] FOREIGN KEY([Name])
REFERENCES [dbo].[Character] ([Name])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[MK_Quest] CHECK CONSTRAINT [fk_name_char]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest1]  DEFAULT ((0)) FOR [quest1]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest2]  DEFAULT ((0)) FOR [quest2]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest3]  DEFAULT ((0)) FOR [quest3]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest4]  DEFAULT ((0)) FOR [quest4]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest5]  DEFAULT ((0)) FOR [quest5]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest6]  DEFAULT ((0)) FOR [quest6]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest7]  DEFAULT ((0)) FOR [quest7]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest8]  DEFAULT ((0)) FOR [quest8]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest9]  DEFAULT ((0)) FOR [quest9]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest10]  DEFAULT ((0)) FOR [quest10]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest11]  DEFAULT ((0)) FOR [quest11]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest12]  DEFAULT ((0)) FOR [quest12]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest13]  DEFAULT ((0)) FOR [quest13]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest14]  DEFAULT ((0)) FOR [quest14]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest15]  DEFAULT ((0)) FOR [quest15]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest16]  DEFAULT ((0)) FOR [quest16]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest17]  DEFAULT ((0)) FOR [quest17]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest18]  DEFAULT ((0)) FOR [quest18]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest19]  DEFAULT ((0)) FOR [quest19]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest20]  DEFAULT ((0)) FOR [quest20]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_nivel]  DEFAULT ((0)) FOR [nivel]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest21]  DEFAULT ((0)) FOR [quest21]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest22]  DEFAULT ((0)) FOR [quest22]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest23]  DEFAULT ((0)) FOR [quest23]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest24]  DEFAULT ((0)) FOR [quest24]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest25]  DEFAULT ((0)) FOR [quest25]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest26]  DEFAULT ((0)) FOR [quest26]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest27]  DEFAULT ((0)) FOR [quest27]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest28]  DEFAULT ((0)) FOR [quest28]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest29]  DEFAULT ((0)) FOR [quest29]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest30]  DEFAULT ((0)) FOR [quest30]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest31]  DEFAULT ((0)) FOR [quest31]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest32]  DEFAULT ((0)) FOR [quest32]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest33]  DEFAULT ((0)) FOR [quest33]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest34]  DEFAULT ((0)) FOR [quest34]
GO
ALTER TABLE [dbo].[MK_Quest] ADD  CONSTRAINT [DF_Quest_quest35]  DEFAULT ((0)) FOR [quest35]
GO