/*
Run this script on:

        (local)\SQLEXPRESS.gAMS_BVB_v3_UAT_Customer    -  This database will be modified

to synchronize it with:

        192.168.1.230,5036.gAMSPro_BVB_v3_UAT_NB

You are recommended to back up your database before running this script

Script created by SQL Compare version 13.1.6.5463 from Red Gate Software Ltd at 3/4/2022 5:05:02 PM

*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL Serializable
GO
BEGIN TRANSACTION
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQUEST_JOB_TRAIN]'
GO
CREATE TABLE [dbo].[TR_REQUEST_JOB_TRAIN]
(
[TRAIN_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_TRAIN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DAY_TRAIN] [datetime] NULL,
[FROM_TRAIN] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TO_TRAIN] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VEHICLE_TYPE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONSIGNMENT] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQUEST_JOB_TRAIN] on [dbo].[TR_REQUEST_JOB_TRAIN]'
GO
ALTER TABLE [dbo].[TR_REQUEST_JOB_TRAIN] ADD CONSTRAINT [PK_TR_REQUEST_JOB_TRAIN] PRIMARY KEY CLUSTERED  ([TRAIN_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQUEST_JOB_FORM]'
GO
CREATE TABLE [dbo].[TR_REQUEST_JOB_FORM]
(
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_CODE] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_DT] [datetime] NULL,
[REF_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CHECKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT] [datetime] NULL,
[REQ_REASON] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_DESC] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_TYPE_TRANS] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_TYPE_GROUP] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_TYPE_BOOKING_HOTEL] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_TYPE_BOOKING_AIR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_TYPE_BOOKING_TRAIN] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SENDER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_DT] [datetime] NULL,
[SIGN_USER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_DT] [datetime] NULL,
[PROCESS_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_CREATE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEP_CREATE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEP_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FRMDATE] [datetime] NULL,
[TODATE] [datetime] NULL,
[IS_SEND_APPR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COST_AMOUNT] [decimal] (18, 0) NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQUEST_JOB_FORM] on [dbo].[TR_REQUEST_JOB_FORM]'
GO
ALTER TABLE [dbo].[TR_REQUEST_JOB_FORM] ADD CONSTRAINT [PK_TR_REQUEST_JOB_FORM] PRIMARY KEY CLUSTERED  ([REQ_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQUEST_JOB_DETAIL]'
GO
CREATE TABLE [dbo].[TR_REQUEST_JOB_DETAIL]
(
[REQ_DT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EMP_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TLNANME] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEP_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PHONE] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQUEST_JOB_DETAIL] on [dbo].[TR_REQUEST_JOB_DETAIL]'
GO
ALTER TABLE [dbo].[TR_REQUEST_JOB_DETAIL] ADD CONSTRAINT [PK_TR_REQUEST_JOB_DETAIL] PRIMARY KEY CLUSTERED  ([REQ_DT_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_JOB_TRIP]'
GO
CREATE TABLE [dbo].[TR_REQ_JOB_TRIP]
(
[TRIP_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_TRIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DAY_TRIP] [datetime] NULL,
[FROM_TRIP] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TO_TRIP] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQ_JOB_TRIP] on [dbo].[TR_REQ_JOB_TRIP]'
GO
ALTER TABLE [dbo].[TR_REQ_JOB_TRIP] ADD CONSTRAINT [PK_TR_REQ_JOB_TRIP] PRIMARY KEY CLUSTERED  ([TRIP_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_JOB]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_JOB]
(
[REQ_PAY_JOB_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[PAY_TYPE] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAY_PHASE] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAY_AMT] [decimal] (18, 0) NULL,
[PAY_DESC] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS_KT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_CODE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_DRIVE_DT]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_DRIVE_DT]
(
[REQ_PAY_DRIVE_DT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CAR_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_REQ] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAY_PHASE] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CAR_TYPE] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CAR_PLATE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RATE_GAS_100KM] [decimal] (18, 0) NULL,
[KM_START] [decimal] (18, 0) NULL,
[KM_END] [decimal] (18, 0) NULL,
[KM_USED] [decimal] (18, 0) NULL,
[RATE_GAS] [decimal] (18, 0) NULL,
[REAL_GAS] [decimal] (18, 0) NULL,
[REDUNDANCY_GAS] [decimal] (18, 0) NULL,
[INVENTORY_GAS] [decimal] (18, 0) NULL,
[COST_INCURRED] [decimal] (18, 0) NULL,
[NOTES] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_SCHEDULE] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TRUONGDONVI] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS_KT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT] [datetime] NULL,
[APPROVE_DT_KT] [datetime] NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_DRIVE]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_DRIVE]
(
[REQ_PAY_DRIVE_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CAR_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CAR_PLATE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[PAY_TYPE] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAY_PHASE] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAY_AMT] [decimal] (18, 0) NULL,
[PAY_DESC] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS_KT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RATE_GAS_100KM] [decimal] (18, 0) NULL,
[CAR_TYPE] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT_KT] [datetime] NULL,
[APPROVE_DT] [datetime] NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_JOB_RETURN_TRIP]'
GO
CREATE TABLE [dbo].[TR_REQ_JOB_RETURN_TRIP]
(
[RETURN_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_RETURN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DAY_RETURN] [datetime] NULL,
[FROM_RETURN] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TO_RETURN] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQ_JOB_RETURN_TRIP] on [dbo].[TR_REQ_JOB_RETURN_TRIP]'
GO
ALTER TABLE [dbo].[TR_REQ_JOB_RETURN_TRIP] ADD CONSTRAINT [PK_TR_REQ_JOB_RETURN_TRIP] PRIMARY KEY CLUSTERED  ([RETURN_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_JOB_FLY]'
GO
CREATE TABLE [dbo].[TR_REQ_JOB_FLY]
(
[FLY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_FLY] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DAY_FLY] [datetime] NULL,
[COST] [decimal] (18, 2) NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQ_JOB_FLY] on [dbo].[TR_REQ_JOB_FLY]'
GO
ALTER TABLE [dbo].[TR_REQ_JOB_FLY] ADD CONSTRAINT [PK_TR_REQ_JOB_FLY] PRIMARY KEY CLUSTERED  ([FLY_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_ADVANCE_LIMIT_LOG]'
GO
CREATE TABLE [dbo].[TR_REQ_ADVANCE_LIMIT_LOG]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AMT] [decimal] (18, 2) NULL,
[APRPOVE_DT] [datetime] NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQ_ADVANCE_LIMIT_LOG] on [dbo].[TR_REQ_ADVANCE_LIMIT_LOG]'
GO
ALTER TABLE [dbo].[TR_REQ_ADVANCE_LIMIT_LOG] ADD CONSTRAINT [PK_TR_REQ_ADVANCE_LIMIT_LOG] PRIMARY KEY CLUSTERED  ([ID], [REQ_PAY_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating extended properties'
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Lộ trình', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'COST_AMOUNT'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Ghi chú', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'NOTES'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Trạng thái hoàn tất của phiếu', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'PROCESS_ID'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Hình thức booking vé máy bay', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'REQ_TYPE_BOOKING_AIR'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Cá nhân tự đặt hoặc công ty đặt', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'REQ_TYPE_BOOKING_HOTEL'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Hình thức đặt vé tàu xe', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'REQ_TYPE_BOOKING_TRAIN'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Cá nhân hay theo đoàn', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'REQ_TYPE_GROUP'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Một chiều hay khứ hồi', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'REQ_TYPE_TRANS'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Ngày gửi duyệt', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'SEND_DT'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Người gửi duyệt', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'SENDER_ID'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Ngày duyệt trung gian', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'SIGN_DT'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Cấp duyệt trung gian', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'SIGN_USER'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'kỳ thanh toán', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQ_PAY_DRIVE', 'COLUMN', N'PAY_PHASE'
END TRY
BEGIN CATCH
	DECLARE @msg nvarchar(max);
	DECLARE @severity int;
	DECLARE @state int;
	SELECT @msg = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE();
	RAISERROR(@msg, @severity, @state);

	SET NOEXEC ON
END CATCH
GO
COMMIT TRANSACTION
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
-- This statement writes to the SQL Server Log so SQL Monitor can show this deployment.
IF HAS_PERMS_BY_NAME(N'sys.xp_logevent', N'OBJECT', N'EXECUTE') = 1
BEGIN
    DECLARE @databaseName AS nvarchar(2048), @eventMessage AS nvarchar(2048)
    SET @databaseName = REPLACE(REPLACE(DB_NAME(), N'\', N'\\'), N'"', N'\"')
    SET @eventMessage = N'Redgate SQL Compare: { "deployment": { "description": "Redgate SQL Compare deployed to ' + @databaseName + N'", "database": "' + @databaseName + N'" }}'
    EXECUTE sys.xp_logevent 55000, @eventMessage
END
GO
DECLARE @Success AS BIT
SET @Success = 1
SET NOEXEC OFF
IF (@Success = 1) PRINT 'The database update succeeded'
ELSE BEGIN
	IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION
	PRINT 'The database update failed'
END
GO