• Hopefully I have this correct per request.

    USE [Test_DB]

    GO

    /****** Object: Table [dbo].[ProjectTree] Script Date: 12/21/2014 11:02:58 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE TABLE [dbo].[ProjectTree](

    [ChildProject] [int] NOT NULL,

    [ProjectID] [int] NOT NULL,

    CONSTRAINT [aaaaaProjectTree1_PK] PRIMARY KEY CLUSTERED

    (

    [ChildProject] 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

    INSERT INTO ProjectTree (ChildProject, ProjectID)

    VALUES ('0','1');

    INSERT INTO ProjectTree (ChildProject, ProjectID)

    VALUES ('2','1');

    INSERT INTO ProjectTree (ChildProject, ProjectID)

    VALUES ('3','1');

    USE [Test_DB]

    GO

    /****** Object: Table [dbo].[Projects] Script Date: 12/21/2014 11:05:27 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE TABLE [dbo].[Projects](

    [ProjectID] [int] IDENTITY(1,1) NOT NULL,

    [Name] [nvarchar](255) NULL,

    [Deleted] [bit] NOT NULL,

    CONSTRAINT [aaaaaProjects1_PK] PRIMARY KEY NONCLUSTERED

    (

    [ProjectID] 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

    INSERT INTO Projects (Name, Deleted)

    VALUES ('Projects','0');

    INSERT INTO Projects (Name, Deleted)

    VALUES ('Prometheous','0');

    INSERT INTO Projects (Name, Deleted)

    VALUES ('Genesis','0');