-- Delete table if it exists already
IF OBJECT_ID('CleanData.PostHistory') IS NOT NULL
DROP TABLE CleanData.PostHistory;
GO
-- Create the table
CREATE TABLE CleanData.PostHistory (
SiteId UNIQUEIDENTIFIER NOT NULL,
ApiSiteParameter NVARCHAR(256) NOT NULL,
RowId INT,
PostHistoryTypeId INT,
PostId INT,
RevisionGUID UNIQUEIDENTIFIER,
CreationDate DATETIME2,
UserId INT,
[Text] NVARCHAR(MAX),
Inserted DATETIME2 DEFAULT GETDATE(),
CONSTRAINT fk_PostHistory_SiteId FOREIGN KEY (SiteId) REFERENCES CleanData.Sites(Id),