CREATE TABLE [dbo].[HARREPOSITORY]
(
[REPOSITOBJID] [int] NOT NULL,
[REPOSITNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ROOTPATHID] [int] NOT NULL,
[REPONLINE] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATIONTIME] [datetime] NOT NULL CONSTRAINT [DF__HARREPOSI__CREAT__55009F39] DEFAULT (getutcdate()),
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARREPOSI__MODIF__55F4C372] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL,
[INITIALVIEWID] [int] NOT NULL,
[HOSTNODE] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HOSTINSTANCE] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXTENSIONOPTION] [int] NOT NULL CONSTRAINT [DF__HARREPOSI__EXTEN__56E8E7AB] DEFAULT ((1)),
[COMPFILE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARREPOSI__COMPF__57DD0BE4] DEFAULT ('Y'),
[NOTCOMPEXT] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__HARREPOSI__NOTCO__58D1301D] DEFAULT ('.zip.jpg.gif.asf.ram.mp3.wav.cab'),
[MVSMAPPING] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__HARREPOSI__MVSMA__59C55456] DEFAULT ('M')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARREPOSITORY] ADD CONSTRAINT [HARREPOSITORY_PK] PRIMARY KEY CLUSTERED ([REPOSITOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARREPOSITORY_IND] ON [dbo].[HARREPOSITORY] ([REPOSITNAME]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARREPOSITORY table stores repository objects. ', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Compress File (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'COMPFILE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Repository file extension options. 0: No file extension list; 1: Use global file extension list; 2: Use repository file extension list', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'EXTENSIONOPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Reserve for future', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'HOSTINSTANCE'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of host node', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'HOSTNODE'
GO
EXEC sp_addextendedproperty N'Caption', N'Initial view object ID', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'INITIALVIEWID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'MVS mapping or directory mapping (M/D)', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'MVSMAPPING'
GO
EXEC sp_addextendedproperty N'Caption', N'File extension names do not compress', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'NOTCOMPEXT'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Reserved for future use', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'REPONLINE'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of repository', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'REPOSITNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of repository', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'REPOSITOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of root path', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORY', 'COLUMN', N'ROOTPATHID'
GO