This project is read-only.

Missing SQL for OI_Source table creation

Feb 23, 2011 at 5:10 PM

Hello,

First of all, congratulations on great project!

This is very useful code that you are sharing, and I think this is great starter for many projects.

I have noticed that provided sql script in the documentation has to be filled with part for OI_Source table creation, which is something like:

CREATE TABLE [dbo].[OI_Source](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [name] [varchar](256) NOT NULL,
    [filter] [varchar](256) NULL,
 CONSTRAINT [PK_ogdi_source] PRIMARY KEY CLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

 

Keep on the good work!

Nikola Kovacevic

Mar 3, 2011 at 9:36 PM

Thanks Nikola!  We've made some updates to the documentation over the past two weeks, including the SQL you mentioned.  Are you planning to use the OI codebase on a project?  If so, we'd love to hear about it.

Benton