-- [MwusRevisionSupersedesUpdate] table has to be created for DM although it will not have data
CREATE TABLE [MwusRevisionSupersedesUpdate] (
  [RevisionID] int  NOT NULL
, [SupersededUpdateGuid] uniqueidentifier NOT NULL
);
GO
ALTER TABLE [MwusRevisionSupersedesUpdate] ADD CONSTRAINT [PK_MwusRevisionSupersedesUpdate] PRIMARY KEY ([RevisionID],[SupersededUpdateGuid]);
GO
CREATE INDEX [MwusRevisionSupersedesUpdate_SupersededUpdateGuid_IX] ON [MwusRevisionSupersedesUpdate] ([SupersededUpdateGuid] ASC);
GO
ALTER TABLE [MwusRevisionSupersedesUpdate] ADD CONSTRAINT [FK_MwusSupersedesUpdate_MwusRevision] FOREIGN KEY ([RevisionID]) REFERENCES [MwusRevision]([RevisionID]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

