SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[hip_Project](
	[Project_Id] [int] IDENTITY(200,1) NOT NULL,
	[ProjectName] [nvarchar](50) NOT NULL,
	[ProjectDesc] [nvarchar](50) NULL,
	[deleted] [int] NOT NULL,
	[ProjectNotes] [nvarchar](50) NULL,
	[dtCreated] [datetime] NULL
) ON [PRIMARY]


GO


ALTER TABLE [dbo].[hip_Project] ADD  CONSTRAINT [DF_hip_Project_dtCreated]  DEFAULT (getdate()) FOR [dtCreated]
GO