CREATE TABLE [dbo].[DBFiles]
(
[DBFileID] [int] NOT NULL IDENTITY(1, 1),
[DBFileTypeID] [int] NULL CONSTRAINT [DF_DBFiles_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 NOT NULL CONSTRAINT [DF_DBFiles_Description] DEFAULT ((0)),
[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,
[NetworkFilePath] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_DBFiles_NetworkFilePath] DEFAULT (''),
[Revision] [int] NOT NULL,
[Shared] [bit] NOT NULL CONSTRAINT [DF_DBFiles_Shared] DEFAULT ((0)),
[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_DBFiles_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_DBFiles_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DBFiles] ADD CONSTRAINT [PK_DBFiles] PRIMARY KEY CLUSTERED ([DBFileID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DBFiles] ADD CONSTRAINT [FK_DBFiles_DBFileMimeTypeID_DBFileMimeType] FOREIGN KEY ([DBFileMimeTypeID]) REFERENCES [dbo].[DBFileMimeType] ([DBFileMimeTypeID])
GO
ALTER TABLE [dbo].[DBFiles] ADD CONSTRAINT [FK_DBFiles_DBFileTypeID_DBFileType] FOREIGN KEY ([DBFileTypeID]) REFERENCES [dbo].[DBFileType] ([DBFileTypeID])
GO