Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[tbl_questprogressinfo](
- [QuestIndex] INT NOT NULL,
- [CharacterIndex] INT NOT NULL,
- [StartDateTime] DATETIME NOT NULL,
- [EndDateTime] DATETIME NULL,
- [Completed] BIT NOT NULL,
- CONSTRAINT [PK_tbl_questprogressinfo] PRIMARY KEY CLUSTERED ([QuestIndex] ASC, [CharacterIndex] ASC),
- CONSTRAINT [FK_tbl_questprogressinfo_tbl_questinfo] FOREIGN KEY ([QuestIndex]) REFERENCES [dbo].[tbl_questinfo] ([Index]),
- CONSTRAINT [FK_tbl_questprogressinfo_tbl_characterinfo] FOREIGN KEY ([CharacterIndex]) REFERENCES [dbo].[tbl_characterinfo] ([Index])
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement