text: CREATE TABLE [Audit].[AuditDocument]
  (
     [AuditId]        UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL
    ,[AuditStatus]   TINYINT          NOT NULL
    ,[AuditAppUser]  UNIQUEIDENTIFIER NOT NULL
    ,[AuditSqlUser]  VARCHAR(256)     NOT NULL
    ,[AuditDate]     DATETIME         NOT NULL
    ,[AuditBatchId]    VARCHAR(64)      NOT NULL
    ,[AuditOperation]  VARCHAR(255)     NOT NULL
    ,[DocumentNode]    HIERARCHYID       NULL
    ,[DocumentLevel]   SMALLINT          NULL
    ,[Title]           NVARCHAR(50)      NULL
    ,[Owner]           INT               NULL
    ,[FolderFlag]      BIT               NULL
    ,[FileName]        NVARCHAR(400)     NULL
    ,[FileExtension]   NVARCHAR(8)       NULL
    ,[Revision]        NCHAR(5)          NULL
    ,[ChangeNumber]    INT               NULL
    ,[Status]          TINYINT           NULL
    ,[DocumentSummary] NVARCHAR( MAX )   NULL
    ,[Document]        VARBINARY(MAX)    NULL
    ,[rowguid]         UNIQUEIDENTIFIER  NULL
    ,[RowStatus]       TINYINT           NULL
    ,[CreatedBy]       UNIQUEIDENTIFIER  NULL
    ,[ModifiedBy]      UNIQUEIDENTIFIER  NULL
    ,[CreatedDate]     DATETIME          NULL
    ,[ModifiedDate]    DATETIME          NULL
    ,[Uuid]            UNIQUEIDENTIFIER  NULL
  )
  GO
  
  ALTER TABLE [Audit].[AuditDocument] ADD CONSTRAINT [DF__AuditDocument__AuditId] DEFAULT (NEWID()) FOR [AuditId]
  GO
  
  ALTER TABLE [Audit].[AuditDocument] ADD CONSTRAINT [DF__AuditDocument__AuditStatus] DEFAULT ((1)) FOR [AuditStatus]
  GO
  
  ALTER TABLE [Audit].[AuditDocument] ADD CONSTRAINT [DF__AuditDocument__AuditAppUser] DEFAULT ('4E3A7D6D-8351-8494-FDB7-39E2A3A2E972') FOR [AuditAppUser]
  GO
  
  ALTER TABLE [Audit].[AuditDocument] ADD CONSTRAINT [DF__AuditDocument__AuditSqlUser] DEFAULT (suser_sname()) FOR [AuditSqlUser]
  GO
  
  ALTER TABLE [Audit].[AuditDocument] ADD CONSTRAINT [DF__AuditDocument__AuditDate] DEFAULT (GETUTCDATE()) FOR [AuditDate]
  GO
  
  EXEC sys.sp_addextendedproperty 
    @name=N'MS_Description',
    @value=N'Transactional audit table.  Source is Production.Document',
    @level0type=N'SCHEMA',
    @level0name=N'Audit',
    @level1type=N'TABLE',
    @level1name=N'AuditDocument'
  GO