CREATE TABLE [dbo].[DBFileRevisions]
(
[DBFileRevisionID] [int] NOT NULL IDENTITY(1, 1),
[DBFileID] [int] NOT NULL,
[DBFileTypeID] [int] NULL CONSTRAINT [DF_DBFileRevisions_DBFileTypeID] DEFAULT ((1)),
[DBFileMimeTypeID] [int] NOT NULL,
[FileName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UploadComputer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UploadPath] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FileSize] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBFileContentID] [int] NOT NULL CONSTRAINT [DF_DBFileRevisions_DBFileContentID] DEFAULT ((0)),
[NetworkFilePath] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DBFileRevisions_NetworkFilePath] DEFAULT (''),
[Revision] [int] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_DBFileRevisions_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_DBFileRevisions_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DBFileRevisions] ADD CONSTRAINT [PK_DBFileRevisions] PRIMARY KEY CLUSTERED ([DBFileRevisionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DBFileRevisions] ADD CONSTRAINT [FK_DBFileRevisions_DBFileID_DBFiles] FOREIGN KEY ([DBFileID]) REFERENCES [dbo].[DBFiles] ([DBFileID])
GO
ALTER TABLE [dbo].[DBFileRevisions] ADD CONSTRAINT [FK_DBFileRevisions_DBFileMimeTypeID_DBFileMimeType] FOREIGN KEY ([DBFileMimeTypeID]) REFERENCES [dbo].[DBFileMimeType] ([DBFileMimeTypeID])
GO
ALTER TABLE [dbo].[DBFileRevisions] ADD CONSTRAINT [FK_DBFileRevisions_DBFileTypeID_DBFileType] FOREIGN KEY ([DBFileTypeID]) REFERENCES [dbo].[DBFileType] ([DBFileTypeID])
GO