CREATE TABLE [dbo].[DataSource]
(
[DSID] [uniqueidentifier] NOT NULL,
[ItemID] [uniqueidentifier] NULL,
[SubscriptionID] [uniqueidentifier] NULL,
[Name] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Extension] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Link] [uniqueidentifier] NULL,
[CredentialRetrieval] [int] NULL,
[Prompt] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ConnectionString] [image] NULL,
[OriginalConnectionString] [image] NULL,
[OriginalConnectStringExpressionBased] [bit] NULL,
[UserName] [image] NULL,
[Password] [image] NULL,
[Flags] [int] NULL,
[Version] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSource] ADD CONSTRAINT [PK_DataSource] PRIMARY KEY CLUSTERED ([DSID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DataSourceItemID] ON [dbo].[DataSource] ([ItemID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DataSourceSubscriptionID] ON [dbo].[DataSource] ([SubscriptionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSource] WITH NOCHECK ADD CONSTRAINT [FK_DataSourceItemID] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[Catalog] ([ItemID])
GO
GRANT REFERENCES ON  [dbo].[DataSource] TO [RSExecRole]
GRANT SELECT ON  [dbo].[DataSource] TO [RSExecRole]
GRANT INSERT ON  [dbo].[DataSource] TO [RSExecRole]
GRANT DELETE ON  [dbo].[DataSource] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[DataSource] TO [RSExecRole]
GO