/*
Run this script on:

        (local)\SQLEXPRESS.gAMS_BVB_v3_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 2/15/2022 9:36:14 AM

*/
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'Dropping extended properties'
GO
BEGIN TRY
	EXEC sp_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'APPROVE_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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'AUTH_STATUS'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'BRANCH_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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'BUDGET'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'CHECKER_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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'CONSTRUCT_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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'CREATE_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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'IS_PARENT'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'MAKER_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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', '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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'PLAN_TYPE'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'RECORD_STATUS'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_CODE'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_CONTENT'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_NAME'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQUEST_PARENT'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'TOTAL_AMT'
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_dropextendedproperty N'MS_Description', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'YEAR_BUDGET'
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
PRINT N'Dropping constraints from [dbo].[CON_REQUEST_DOC]'
GO
ALTER TABLE [dbo].[CON_REQUEST_DOC] DROP CONSTRAINT [PK__CON_REQU__06143B5B9A835A09]
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
[TOTAL_AREA_USE] [decimal] (18, 2) NULL,
[TOTAL_COST] [decimal] (18, 2) NULL,
[UNIT_PRICE] [decimal] (18, 2) NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Rebuilding [dbo].[CON_REQUEST_DOC]'
GO
CREATE TABLE [dbo].[RG_Recovery_1_CON_REQUEST_DOC]
(
[CON_REQUEST_DOC_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_CODE] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_NAME] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_DT] [datetime] NULL,
[REQ_CONTENT] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONSTRUCT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TOTAL_AMT] [decimal] (18, 0) NULL,
[NOTES] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[AUTH_STATUS] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CHECKER_ID] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT] [datetime] NULL,
[BRANCH_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PLAN_TYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IS_PARENT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQUEST_PARENT] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BUDGET] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEAR_BUDGET] [int] NULL,
[IS_ARISE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
INSERT INTO [dbo].[RG_Recovery_1_CON_REQUEST_DOC]([REQ_CODE], [REQ_NAME], [REQ_DT], [REQ_CONTENT], [CONSTRUCT_ID], [TOTAL_AMT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [BRANCH_ID], [PLAN_TYPE], [IS_PARENT], [REQUEST_PARENT], [BUDGET], [YEAR_BUDGET], [IS_ARISE], [REQ_ID]) SELECT [REQ_CODE], [REQ_NAME], [REQ_DT], [REQ_CONTENT], [CONSTRUCT_ID], [TOTAL_AMT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [BRANCH_ID], [PLAN_TYPE], [IS_PARENT], [REQUEST_PARENT], [BUDGET], [YEAR_BUDGET], [IS_ARISE], [REQ_ID] FROM [dbo].[CON_REQUEST_DOC]
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
DROP TABLE [dbo].[CON_REQUEST_DOC]
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
EXEC sp_rename N'[dbo].[RG_Recovery_1_CON_REQUEST_DOC]', N'CON_REQUEST_DOC', N'OBJECT'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK__CON_REQU__06143B5B9A835A09] on [dbo].[CON_REQUEST_DOC]'
GO
ALTER TABLE [dbo].[CON_REQUEST_DOC] ADD CONSTRAINT [PK__CON_REQU__06143B5B9A835A09] PRIMARY KEY CLUSTERED  ([CON_REQUEST_DOC_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_ADVANCE_PAYMENT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQ_ADVANCE_PAYMENT] ADD
[TK_TGD_XL_TLNAME] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TK_TGD_XL_DT] [datetime] NULL,
[TK_TGD_APPR_TLNAME] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TK_TGD_APPR_DT] [datetime] NULL,
[TK_HDQT_XL_TLNAME] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TK_HDQT_XL_DT] [datetime] NULL,
[TK_HDQT_APPR_TLNAME] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TK_HDQT_APPR_DT] [datetime] NULL,
[TK_OTHER_XL_TLNAME] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TK_OTHER_XL_DT] [datetime] NULL,
[TK_OTHER_APPR_TLNAME] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TK_OTHER_APPR_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQ_ADVANCE_PAYMENT] ALTER COLUMN [NOTES] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CM_DEPARTMENT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CM_DEPARTMENT] ADD
[KHOI_ID] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[BUD_CONTRACT_CUST_MASTER]'
GO
CREATE TABLE [dbo].[BUD_CONTRACT_CUST_MASTER]
(
[CONTRACT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BUILDING_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONTRACT_NO] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VERSION_NO] [int] NOT NULL,
[TR_CONTRACT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CUST_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INPUT_DT] [date] NULL,
[AMEND_DT] [date] NULL,
[FROM_DT] [date] NOT NULL,
[TO_DATE] [date] NULL,
[CLOSE_DT] [date] NULL,
[MONTHS] [int] NULL,
[RENT_PRICE] [numeric] (18, 2) NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[CHECKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT] [datetime] NULL,
[XML_TEMP] [xml] NULL,
[VAT] [decimal] (18, 0) NULL,
[VAT_AMT] [decimal] (18, 0) NULL,
[DEPOSITS_AMT] [decimal] (18, 0) NULL,
[PAYMENT_SHEDULE] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAYMENT_DT] [datetime] NULL,
[EXTEND_DT] [datetime] NULL,
[IS_SEND_APPR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL,
[SIGN_USER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_DT] [datetime] NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_BUD_CONTRACT_CUST_MASTER_1] on [dbo].[BUD_CONTRACT_CUST_MASTER]'
GO
ALTER TABLE [dbo].[BUD_CONTRACT_CUST_MASTER] ADD CONSTRAINT [PK_BUD_CONTRACT_CUST_MASTER_1] PRIMARY KEY CLUSTERED  ([CONTRACT_ID], [VERSION_NO])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[BUD_CONTRACT_CUST_DT]'
GO
CREATE TABLE [dbo].[BUD_CONTRACT_CUST_DT]
(
[CONTRACT_DTID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BUILD_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONTRACT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VERSION_NO] [int] NULL,
[BUILDING_AREA_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RENT_AREA] [numeric] (18, 2) NULL,
[RENT_AREA_APP] [numeric] (18, 2) NULL,
[AREA_REMAIN] [numeric] (18, 2) NULL,
[RENT_PRICE] [numeric] (18, 2) NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DIEN_TICH_TANG] [decimal] (18, 0) NULL,
[DIEN_TICH_SD_NOI_BO] [decimal] (18, 0) NULL,
[DIEN_TICH_DA_CHO_THUE] [decimal] (18, 0) NULL,
[DIEN_TICH_CON_LAI] [decimal] (18, 0) NULL,
[DIEN_TICH_CAN_CHOTHUE] [decimal] (18, 0) NULL,
[PRICE] [decimal] (18, 0) NULL,
[TOTAL_AMT] [decimal] (18, 0) NULL,
[DIEN_TICH_CON_LAI_FINAL] [decimal] (18, 0) NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_BUD_CONTRACT_CUST_DT] on [dbo].[BUD_CONTRACT_CUST_DT]'
GO
ALTER TABLE [dbo].[BUD_CONTRACT_CUST_DT] ADD CONSTRAINT [PK_BUD_CONTRACT_CUST_DT] PRIMARY KEY CLUSTERED  ([CONTRACT_DTID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_PAYMENT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQ_PAYMENT] ADD
[AMT_PAY] [decimal] (18, 0) NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_BUDGET]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_BUDGET]
(
[BUDG_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GD_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,
[TRADE_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AMT_APP] [decimal] (18, 2) NULL,
[AMT_EXE] [decimal] (18, 2) NULL,
[AMT_REMAIN] [decimal] (18, 2) NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CURRENCY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RATE] [decimal] (18, 2) NULL,
[AMT_DO] [decimal] (18, 2) NULL,
[REASON] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TYPE_COST] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FR_LEVEL] [int] NULL,
[TO_LEVEL] [int] NULL,
[MONTH_RATE] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEAR_RATE] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQ_PAY_BUDGET] on [dbo].[TR_REQ_PAY_BUDGET]'
GO
ALTER TABLE [dbo].[TR_REQ_PAY_BUDGET] ADD CONSTRAINT [PK_TR_REQ_PAY_BUDGET] PRIMARY KEY CLUSTERED  ([BUDG_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[BUD_UTIL_LOG]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[BUD_UTIL_LOG] ADD
[TOTAL_AMT_INIT] [decimal] (18, 0) NULL,
[VAT_INIT] [numeric] (18, 0) NULL,
[IS_FIRST_TIME] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CUSTOMER_ID] [varchar] (15) 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
[CONTRACT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IS_SEND_APPR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL,
[SIGN_USER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[BUD_CONTRACT_MASTER]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[BUD_CONTRACT_MASTER] ADD
[IS_SEND_APPR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL,
[SIGN_USER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[BUD_CONTRACT_DT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[BUD_CONTRACT_DT] ADD
[DIEN_TICH_TANG] [decimal] (18, 0) NULL,
[DIEN_TICH_SD_NOI_BO] [decimal] (18, 0) NULL,
[DIEN_TICH_DA_CHO_THUE] [decimal] (18, 0) NULL,
[DIEN_TICH_CON_LAI] [decimal] (18, 0) NULL,
[DIEN_TICH_CAN_SD] [decimal] (18, 0) NULL,
[REASON] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PRICE] [decimal] (18, 0) NULL,
[TOTAL_AMT] [decimal] (18, 0) NULL,
[DIEN_TICH_CON_LAI_FINAL] [decimal] (18, 0) NULL,
[BRANCH_ID] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEP_ID] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_METHOD]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_METHOD]
(
[METHOD_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,
[EMP_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_PAY_REASON] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TOTAL_AMT] [decimal] (18, 2) NULL,
[REQ_PAY_TYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_PAY_DESC] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_PAY_ENTRIES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEMP] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[ACC_NO] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACC_NAME] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISSUED_BY] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISSUED_DT] [datetime] NULL,
[CURRENCY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RATE] [decimal] (18, 0) NULL,
[CHECK_IN] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TYPE_TRANSFER] [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_PAY_METHOD] on [dbo].[TR_REQ_PAY_METHOD]'
GO
ALTER TABLE [dbo].[TR_REQ_PAY_METHOD] ADD CONSTRAINT [PK_TR_REQ_PAY_METHOD] PRIMARY KEY CLUSTERED  ([METHOD_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_INVOICE]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_INVOICE]
(
[REQ_PAYDT_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,
[TRANS_NO] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TRANS_DT] [datetime] NULL,
[INVOICE_SIGN] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INVOICE_NO] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INVOICE_DT] [datetime] NULL,
[SELLER] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TAX_NO] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GOODS_NAME] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PRICE] [decimal] (18, 2) NULL,
[TAX] [decimal] (18, 2) NULL,
[VAT] [decimal] (18, 2) NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[EDITOR_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
[CREATE_DT_KT] [datetime] NULL,
[MAKER_ID_KT] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS_KT] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CHECKER_ID_KT] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT_KT] [datetime] NULL,
[CORE_NOTE] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_CREATE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INVOICE_NO_SIGN] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VAT_RATE] [decimal] (18, 2) NULL,
[CURRENCY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RATE] [decimal] (18, 2) NULL,
[PRICE_KT] [decimal] (18, 2) NULL,
[VAT_KT] [decimal] (18, 2) NULL,
[TOTAL_AMT_KT] [decimal] (18, 2) NULL,
[TYPE_VAT] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TYPE_FUNC] [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_PAYMENT_DT] on [dbo].[TR_REQ_PAY_INVOICE]'
GO
ALTER TABLE [dbo].[TR_REQ_PAY_INVOICE] ADD CONSTRAINT [PK_TR_REQUEST_PAYMENT_DT] PRIMARY KEY CLUSTERED  ([REQ_PAYDT_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_CAT]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_CAT]
(
[CAT_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_ADV_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CAT_NAME] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TOTAL_AMT] [decimal] (18, 2) NULL,
[DEPT_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,
[CURRENCY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RATE] [decimal] (18, 2) NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQ_PAY_CAT] on [dbo].[TR_REQ_PAY_CAT]'
GO
ALTER TABLE [dbo].[TR_REQ_PAY_CAT] ADD CONSTRAINT [PK_TR_REQ_PAY_CAT] PRIMARY KEY CLUSTERED  ([CAT_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_REQ_PAY_ATTACH]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_REQ_PAY_ATTACH] ADD
[LICENSE_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_PER_LOG]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_PER_LOG]
(
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AD_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TL_USER_V2]'
GO
CREATE TABLE [dbo].[TL_USER_V2]
(
[TLID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TLNANME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TLFullName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TLSUBBRID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_NAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_TYPE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RoleName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EMAIL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ADDRESS] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PHONE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MARKER_ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT] [datetime] NULL,
[ISAPPROVE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Birthday] [datetime] NULL,
[ISFIRSTTIME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SECUR_CODE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TL_USER_V2] on [dbo].[TL_USER_V2]'
GO
ALTER TABLE [dbo].[TL_USER_V2] ADD CONSTRAINT [PK_TL_USER_V2] PRIMARY KEY CLUSTERED  ([TLID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[RET_MASTER]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[RET_MASTER] ADD
[FLUCTUATING_DT] [datetime] NULL,
[REASON_FLUCTUATING] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[CON_REQUEST_REVIEW_DT]'
GO
CREATE TABLE [dbo].[CON_REQUEST_REVIEW_DT]
(
[CON_REQ_REVIEW_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SUP_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONS_PROCESS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAINTENANCE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REPORT_PLAN_EDIT] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONS_QUALITY] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BEAUTY_IMAGE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONSTRUCT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QCKT_REVIEW] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_CODE] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SUP_NAME] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_CON_REQUEST_REVIEW_DT] on [dbo].[CON_REQUEST_REVIEW_DT]'
GO
ALTER TABLE [dbo].[CON_REQUEST_REVIEW_DT] ADD CONSTRAINT [PK_CON_REQUEST_REVIEW_DT] PRIMARY KEY CLUSTERED  ([CON_REQ_REVIEW_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[CON_REQUEST_PROCESS_DT]'
GO
CREATE TABLE [dbo].[CON_REQUEST_PROCESS_DT]
(
[CON_REQ_PROCESS_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DATE_REPORT] [datetime] NULL,
[PERCENT_COMPLETED] [decimal] (5, 2) NULL,
[PERCENT_REMAIN] [decimal] (5, 2) NULL,
[DEADLINE] [datetime] NULL,
[CONSTRUCT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_CON_REQUEST_PROCESS_DT] on [dbo].[CON_REQUEST_PROCESS_DT]'
GO
ALTER TABLE [dbo].[CON_REQUEST_PROCESS_DT] ADD CONSTRAINT [PK_CON_REQUEST_PROCESS_DT] PRIMARY KEY CLUSTERED  ([CON_REQ_PROCESS_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[CON_REQUEST_HH_DT]'
GO
CREATE TABLE [dbo].[CON_REQUEST_HH_DT]
(
[CON_REQ_HH_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SUP_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SELLTEMENT_AMT] [decimal] (18, 2) NULL,
[DESCRIPTION] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HH_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESTIMATES_AMT] [decimal] (18, 2) NULL,
[BRANCH_DO] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONS_DOCUMENT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BID_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_CODE] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONSTRUCT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQDT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BID_CODE] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_CON_REQUEST_HH_DT] on [dbo].[CON_REQUEST_HH_DT]'
GO
ALTER TABLE [dbo].[CON_REQUEST_HH_DT] ADD CONSTRAINT [PK_CON_REQUEST_HH_DT] PRIMARY KEY CLUSTERED  ([CON_REQ_HH_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[REAL_ESTATE_R_H]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[REAL_ESTATE_R_H] ADD
[TR_CONTRACT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXTEND_DT] [datetime] NULL,
[STRUCTURE] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[CON_LAYOUT_BLUEPRINT]'
GO
CREATE TABLE [dbo].[CON_LAYOUT_BLUEPRINT]
(
[CON_LAYOUT_BLUEPRINT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LAYOUT_NAME] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONSTRUCT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONSTRUCT_NAME] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LAYOUT_TYPE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[CHECKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT] [datetime] NULL,
[PROCESS_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BRANCH_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_USER] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_CON_LAYOUT_BLUEPRINT_ID] on [dbo].[CON_LAYOUT_BLUEPRINT]'
GO
ALTER TABLE [dbo].[CON_LAYOUT_BLUEPRINT] ADD CONSTRAINT [PK_CON_LAYOUT_BLUEPRINT_ID] PRIMARY KEY CLUSTERED  ([CON_LAYOUT_BLUEPRINT_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CON_REQUEST_DOC_PARENT_VIEW]'
GO
ALTER VIEW [dbo].[CON_REQUEST_DOC_PARENT_VIEW]
AS
SELECT        REQ_ID, REQ_CODE, REQ_NAME, IS_ARISE, REQ_DT, REQ_CONTENT, CONSTRUCT_ID, TOTAL_AMT, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, BRANCH_ID, 
                         PLAN_TYPE, IS_PARENT, REQUEST_PARENT, BUDGET, YEAR_BUDGET, CON_REQUEST_DOC_ID
FROM            dbo.CON_REQUEST_DOC
WHERE        (IS_PARENT = '1')
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[RET_TAX_SCHEDULE]'
GO
CREATE TABLE [dbo].[RET_TAX_SCHEDULE]
(
[TAX_SCHEDULE_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,
[FRM_DATE] [datetime] NULL,
[TO_DATE] [datetime] NULL,
[TOTAL_AMT] [decimal] (18, 2) NULL,
[REASON] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DESCRIPTION] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RET_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_RET_TAX_SCHEDULE] on [dbo].[RET_TAX_SCHEDULE]'
GO
ALTER TABLE [dbo].[RET_TAX_SCHEDULE] ADD CONSTRAINT [PK_RET_TAX_SCHEDULE] PRIMARY KEY CLUSTERED  ([TAX_SCHEDULE_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[RET_REPAIR_SUGGEST]'
GO
CREATE TABLE [dbo].[RET_REPAIR_SUGGEST]
(
[RET_SUG_REPAIR_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REPAIR_SUG_DT] [datetime] 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,
[BRANCH_SUGGEST] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TOTAL_AMT] [decimal] (18, 2) NULL,
[USER_SUGGEST] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REPAIR_REASON] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REPAIR_CONTENT] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DESCRIPTION] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RET_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_RET_REPAIR_SUGGEST] on [dbo].[RET_REPAIR_SUGGEST]'
GO
ALTER TABLE [dbo].[RET_REPAIR_SUGGEST] ADD CONSTRAINT [PK_RET_REPAIR_SUGGEST] PRIMARY KEY CLUSTERED  ([RET_SUG_REPAIR_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[RET_REPAIR_REAL]'
GO
CREATE TABLE [dbo].[RET_REPAIR_REAL]
(
[RET_REPAIR_REAL_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,
[REPAIR_DT] [datetime] NULL,
[BRANCH_REPAIR] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TOTAL_AMT] [decimal] (18, 2) NULL,
[REPAIR_CONTENT_REAL] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DESCRIPTION] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RECORD_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RET_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_RET_REPAIR_REAL] on [dbo].[RET_REPAIR_REAL]'
GO
ALTER TABLE [dbo].[RET_REPAIR_REAL] ADD CONSTRAINT [PK_RET_REPAIR_REAL] PRIMARY KEY CLUSTERED  ([RET_REPAIR_REAL_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_ADVANCE_CUS]'
GO
CREATE TABLE [dbo].[TR_REQ_ADVANCE_CUS]
(
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CUST_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EMP_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AMT_PAY_DO] [decimal] (18, 2) NULL,
[CURRENCY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RATE] [decimal] (18, 2) NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_TR_REQ_ADVANCE_CUS] on [dbo].[TR_REQ_ADVANCE_CUS]'
GO
ALTER TABLE [dbo].[TR_REQ_ADVANCE_CUS] ADD CONSTRAINT [PK_TR_REQ_ADVANCE_CUS] PRIMARY KEY CLUSTERED  ([REQ_PAY_ID], [CUST_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 trigger [dbo].[triger_TL_AbpUserRoles_ROLENAME] on [dbo].[AbpUserRoles]'
GO
CREATE TRIGGER [dbo].[triger_TL_AbpUserRoles_ROLENAME]
ON [dbo].[AbpUserRoles]
AFTER  INSERT,UPDATE

AS
BEGIN
DECLARE @ROLE_NAME VARCHAR(20);

SET @ROLE_NAME = (SELECT TOP 1 R.DisplayName FROM  Inserted LEFT JOIN dbo.AbpRoles R ON R.Id=Inserted.RoleId)



UPDATE dbo.TL_USER SET TL_USER.RoleName=@ROLE_NAME WHERE TL_USER.ID IN (SELECT Inserted.UserId FROM Inserted)
END

GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating trigger [dbo].[triger_TL_USER_SECUR_CODE] on [dbo].[TL_USER]'
GO
CREATE TRIGGER [dbo].[triger_TL_USER_SECUR_CODE]
ON [dbo].[TL_USER]
AFTER  INSERT,UPDATE

AS
BEGIN
UPDATE dbo.TL_USER SET TL_USER.SECUR_CODE=TL_USER.DEP_ID WHERE TL_USER.ID IN (SELECT Inserted.ID FROM Inserted)
END
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[BUD_CONTRACT_LOG]'
GO
CREATE TABLE [dbo].[BUD_CONTRACT_LOG]
(
[CONTRACT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CUSTOMER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TOTAL_AMT_INIT] [decimal] (18, 0) NULL,
[VAT_INIT] [decimal] (18, 0) NULL,
[IS_FIRST_TIME] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APPROVE_DT] [datetime] NULL
)
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_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,
[ROUNTING] [nvarchar] (max) 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
)
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_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] [int] 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
)
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_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] [int] 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_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] [int] 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_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] [int] 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 primary key [PK_ASS_CONFIRM_COLLECT_MULTI_DT] on [dbo].[ASS_COLLECT_CONFIRM_DT]'
GO
ALTER TABLE [dbo].[ASS_COLLECT_CONFIRM_DT] ADD CONSTRAINT [PK_ASS_CONFIRM_COLLECT_MULTI_DT] PRIMARY KEY CLUSTERED  ([COLLECT_MULTI_CONFIRM_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_ASS_COLLECT_MULTI_CONFIRM_MASTER] on [dbo].[ASS_COLLECT_CONFIRM_MASTER]'
GO
ALTER TABLE [dbo].[ASS_COLLECT_CONFIRM_MASTER] ADD CONSTRAINT [PK_ASS_COLLECT_MULTI_CONFIRM_MASTER] PRIMARY KEY CLUSTERED  ([COL_MULTI_MASTER_CONFIRM_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_ASS_CONFIRM_TRANSFER_MULTI_DT] on [dbo].[ASS_TRANSFER_CONFIRM_DT]'
GO
ALTER TABLE [dbo].[ASS_TRANSFER_CONFIRM_DT] ADD CONSTRAINT [PK_ASS_CONFIRM_TRANSFER_MULTI_DT] PRIMARY KEY CLUSTERED  ([TRANSFER_MULTI_CONFIRM_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_ASS_CONFIRM_TRANSFER_MULTI_MASTER] on [dbo].[ASS_TRANSFER_CONFIRM_MASTER]'
GO
ALTER TABLE [dbo].[ASS_TRANSFER_CONFIRM_MASTER] ADD CONSTRAINT [PK_ASS_CONFIRM_TRANSFER_MULTI_MASTER] PRIMARY KEY CLUSTERED  ([TRANS_MULTI_MASTER_CONFIRM_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_USER_CONFIRM_MASTER_ID] on [dbo].[ASS_USE_CONFIRM_MASTER]'
GO
ALTER TABLE [dbo].[ASS_USE_CONFIRM_MASTER] ADD CONSTRAINT [PK_USER_CONFIRM_MASTER_ID] PRIMARY KEY CLUSTERED  ([USER_CONFIRM_MASTER_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK_USE_MULTI_ID] on [dbo].[ASS_USE_MULTI_DT]'
GO
ALTER TABLE [dbo].[ASS_USE_MULTI_DT] ADD CONSTRAINT [PK_USE_MULTI_ID] PRIMARY KEY CLUSTERED  ([USE_MULTI_ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating extended properties'
GO
BEGIN TRY
	EXEC sp_addextendedproperty N'MS_Description', N'Co gia tri la ngay het hieu luc khi cap nhat phu luc hop dong', 'SCHEMA', N'dbo', 'TABLE', N'BUD_CONTRACT_CUST_MASTER', 'COLUMN', N'CLOSE_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ày duyệt', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'APPROVE_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'Tình trạng duyệt', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'AUTH_STATUS'
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'Đơn vị', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'BRANCH_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ân sách', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'BUDGET'
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 duyệt', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'CHECKER_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'Mã tờ trình', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'CON_REQUEST_DOC_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'Mã công trình', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'CONSTRUCT_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 tạo', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'CREATE_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'Là tờ trình cha', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'IS_PARENT'
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 tạo', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'MAKER_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'Ghi chú', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', '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'Loại kế hoạch', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'PLAN_TYPE'
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'Tình trạng', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'RECORD_STATUS'
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'Số tờ trình', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_CODE'
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'Nội dung', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_CONTENT'
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 tờ trình', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_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'Tên tờ trình', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQ_NAME'
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ờ trình cha', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'REQUEST_PARENT'
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'Chi phí', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'TOTAL_AMT'
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'Năm ngân sách', 'SCHEMA', N'dbo', 'TABLE', N'CON_REQUEST_DOC', 'COLUMN', N'YEAR_BUDGET'
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'Lộ trình', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQUEST_JOB_FORM', 'COLUMN', N'ROUNTING'
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'Lưu thông tin tên tài khoản hoặc tên người nhận tiền', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQ_PAY_METHOD', 'COLUMN', N'ACC_NAME'
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'Lưu số tài khoản hoặc số CMND', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQ_PAY_METHOD', 'COLUMN', N'ACC_NO'
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'Vừa lưu thông tên ngân hàng hoặc lưu thông tin nơi cấp CMND', 'SCHEMA', N'dbo', 'TABLE', N'TR_REQ_PAY_METHOD', 'COLUMN', N'ISSUED_BY'
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_DiagramPane1', N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[30] 2[11] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "CON_REQUEST_DOC"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 136
               Right = 252
            End
            DisplayFlags = 280
            TopColumn = 1
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 3300
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', 'SCHEMA', N'dbo', 'VIEW', N'CON_REQUEST_DOC_PARENT_VIEW', NULL, NULL
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
	DECLARE @xp int
SELECT @xp=1
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', @xp, 'SCHEMA', N'dbo', 'VIEW', N'CON_REQUEST_DOC_PARENT_VIEW', NULL, NULL
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