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