CREATE TABLE [dbo].[d_status](
[id] [int] IDENTITY(1,1) NOT NULL,
[source_id] [int] NULL,
[parent_code] varchar NOT NULL,
[linked_id] [int] NULL,
[created_date] [datetime] NULL,
[modified_date] [datetime] NULL,
[authored_by] varchar NULL,
[sort_order] [int] NULL,
[item_status] [int] NULL,
[item_code] varchar NOT NULL,
[item_desc] varchar NULL,
[item_label] varchar NOT NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
UNIQUE NONCLUSTERED
(
[parent_code] ASC,
[item_code] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[d_status] ADD DEFAULT ((0)) FOR [source_id]
GO
ALTER TABLE [dbo].[d_status] ADD DEFAULT ((0)) FOR [linked_id]
GO
ALTER TABLE [dbo].[d_status] ADD DEFAULT (getdate()) FOR [created_date]
GO
ALTER TABLE [dbo].[d_status] ADD DEFAULT (getdate()) FOR [modified_date]
GO
Populate Table
Add Column to d_projects
ALTER TABLE SomeTable
ADD SomeCol Bit NULL --Or NOT NULL.
CONSTRAINT D_SomeTable_SomeCol --When Omitted a Default-Constraint Name is autogenerated.
DEFAULT (0)--Optional Default-Constraint.
WITH VALUES --Add if Column is Nullable and you want the Default Value for Existing Records.
ALTER TABLE dbo.d_project
ADD project_status int
CONSTRAINT df_project_status
DEFAULT (1)
Manage Status
update dbo.d_project
set project_status = -1
where id \< 0
update dbo.d_project
set project_status = 0
where site_breeze_id is null
and source_id = 5