CREATE TABLE [dbo].[obj_objects]
(
[obj_object_id] [int] NOT NULL,
[obj_is_compressed] [bit] NOT NULL CONSTRAINT [DF__obj_objects__obj_is_compressed] DEFAULT ((0)),
[obj_compression_type] [varchar] (10) COLLATE French_CI_AS NULL,
[obj_binary] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[obj_objects] ADD 
CONSTRAINT [PK_obj_objects] PRIMARY KEY CLUSTERED  ([obj_object_id]) ON [PRIMARY]
ALTER TABLE [dbo].[obj_objects] ADD
CONSTRAINT [CK_obj_objects_obj_compression_type] CHECK ((isnull([obj_compression_type],'zip')='gzip' OR isnull([obj_compression_type],'zip')='tar.gz' OR isnull([obj_compression_type],'zip')='gz' OR isnull([obj_compression_type],'zip')='rar' OR isnull([obj_compression_type],'zip')='zlib' OR isnull([obj_compression_type],'zip')='7zip' OR isnull([obj_compression_type],'zip')='zip'))
GO
