ALTER TABLE [dbo].[TR_REQUEST_JOB_FORM] ALTER COLUMN [BRANCH_ID] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQUEST_JOB_FORM] ALTER COLUMN [DEP_ID] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[BUD_MASTER]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[BUD_MASTER] ADD
[RET_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_JOB_TRIP]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQ_JOB_TRIP] ADD
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQUEST_CAR]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQUEST_CAR] ADD
[IS_CAR_DRIVE] [bit] NULL CONSTRAINT [DF__TR_REQUES__IS_CA__78159CA3] DEFAULT ((0)),
[CAR_DR_ID] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_PAY_BUDGET]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CON_MASTER]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CON_MASTER] ADD
[DEP_CREATE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_PAY_INVOICE]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_JOB_FLY]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQ_JOB_FLY] ADD
[IS_OLD] [bit] NULL CONSTRAINT [DF__TR_REQ_JO__IS_OL__762D5431] DEFAULT ((0))
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_PAY_INVOICE_LOG]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_BUDGET_YEAR_LIMIT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_JOB_RETURN_TRIP]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQ_JOB_RETURN_TRIP] ADD
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_BUDGET_YEAR_LIMIT_DETAIL]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CON_REQUEST_REVIEW_DT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CON_REQUEST_REVIEW_DT] ADD
[HANGHOA_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CON_REQUEST_PROCESS_DT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CON_REQUEST_PROCESS_DT] ADD
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITEM_JOB] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEADLINE_CON] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating index [IX01_PL_REQUEST_DOC] on [dbo].[PL_REQUEST_DOC]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering extended properties'