[AccessD] Re: Code Librarian 2

Hello Robert,

its Ok with me.
Do you have an idea when it will be active and on which site?

Pedro



----- Original Message -----
From: "Robert L. Stewart" <rl_stewart at highstream.net>
To: <accessd at databaseadvisors.com>
Sent: Friday, February 06, 2004 3:36 PM
Subject: [AccessD] Re: Code Librarian 2


> Here is the current SQL for the tables:
>
> CREATE TABLE [dbo].[tbl_CodeBase] (
>          [CodeBaseID] [int] IDENTITY (1, 1) NOT NULL ,
>          [Category] [varchar] (15) NOT NULL ,
>          [Short_Desc] [varchar] (75) NOT NULL ,
>          [Contributor_Name] [varchar] (50) NULL ,
>          [Contributor_Email] [varchar] (50) NULL ,
>          [Full_Desc] [text] NOT NULL ,
>          [Code_Text] [text] NOT NULL ,
>          [KnownIssues] [text] NULL ,
>          [Audt_Create_Dt] [datetime] NOT NULL ,
>          [Audt_Create_UID] [varchar] (20) NOT NULL ,
>          [Audt_Modify_Dt] [datetime] NULL ,
>          [Audt_Modify_UID] [varchar] (20) NULL
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
> GO
>
> CREATE TABLE [dbo].[tbl_CodeBaseReferences] (
>          [CodeBaseReferenceID] [int] IDENTITY (1, 1) NOT NULL ,
>          [CodeBaseID] [int] NOT NULL ,
>          [RequiredReference] [varchar] (75) NOT NULL
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE [dbo].[tbl_CodeBaseSoftware] (
>          [CodeBaseSoftwareID] [int] IDENTITY (1, 1) NOT NULL ,
>          [CodeBaseID] [int] NOT NULL ,
>          [SoftwareVersionID] [int] NOT NULL
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE [dbo].[tbl_CodebaseFiles] (
>          [Code_Link_ID] [int] IDENTITY (1, 1) NOT NULL ,
>          [CodeBaseID] [int] NOT NULL ,
>          [CodeFile] [binary] (50) NOT NULL
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE [dbo].[tbl_CodebaseKeyword] (
>          [CodeBaseKeywordID] [int] IDENTITY (1, 1) NOT NULL ,
>          [CodeBaseID] [int] NOT NULL ,
>          [Keyword] [varchar] (10) NOT NULL
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE [dbo].[tlkp_Category] (
>          [Category] [varchar] (15) NOT NULL
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE [dbo].[tlkp_SoftwareName] (
>          [SoftwareName] [varchar] (20) NOT NULL
> ) ON [PRIMARY]
> GO
>
> CREATE TABLE [dbo].[tlkp_SoftwareVersion] (
>          [SoftwareVersionID] [int] IDENTITY (1, 1) NOT NULL ,
>          [SoftwareName] [varchar] (20) NOT NULL ,
>          [SoftwareVersion] [varchar] (10) NOT NULL
> ) ON [PRIMARY]
> GO
>
> If you catch something that I forgot, drop me a note and I will
> get it in there.
>
> Robert
>
> At 02:12 AM 2/6/2004 -0600, you wrote:
> >Date: Thu, 5 Feb 2004 16:27:29 -0600
> >From: "John Bartow" <john at winhaven.net>
> >Subject: RE: [AccessD] Re: Code Librarian 2
> >To: "Access Developers discussion and problem solving"
> >         <accessd at databaseadvisors.com>
> >Message-ID: <LPBBLAKMHEDAKJKENHKICECOFBAA.john at winhaven.net>
> >Content-Type: text/plain;       charset="iso-8859-1"
> >
> >Pedro,
> >References needed is a good one. Right now I put it into the details and
it
> >isn't easy to find there.
> >Contributor is a better description for what I listed as "Who (or where)
it
> >came from"
> >
> >John
> >
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com
> > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pedro
Janssen
> > > Sent: Thursday, February 05, 2004 3:25 PM
> > > To: Access Developers discussion and problem solving
> > > Subject: Re: [AccessD] Re: Code Librarian 2
> > >
> > >
> > > Hello,
> > >
> > > The fields that you mentioned and the fields that
> > > John Bartow suggested are ok with me.
> > > Other fields that i would recomment are:
> > > references (that are needed), expected problems,
> > > Contributor, Email.
> > >
> > > Greetings
> > >
> > > Pedro
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>