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');