|
1
|
/*
|
|
2
|
Run this script on:
|
|
3
|
|
|
4
|
DESKTOP-RQSO948\DEV.VCCB_AMS - This database will be modified
|
|
5
|
|
|
6
|
to synchronize it with:
|
|
7
|
|
|
8
|
118.69.72.241,5036.gAMSPro_BVB_v3_FINAL
|
|
9
|
|
|
10
|
You are recommended to back up your database before running this script
|
|
11
|
|
|
12
|
Script created by SQL Compare version 13.7.7.10021 from Red Gate Software Ltd at 16/01/2023 4:15:05 PM
|
|
13
|
|
|
14
|
*/
|
|
15
|
SET NUMERIC_ROUNDABORT OFF
|
|
16
|
GO
|
|
17
|
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
|
|
18
|
GO
|
|
19
|
SET XACT_ABORT ON
|
|
20
|
GO
|
|
21
|
IF @@ERROR <> 0 SET NOEXEC ON
|
|
22
|
GO
|
|
23
|
PRINT N'Creating [dbo].[TR_REQ_KPI]'
|
|
24
|
GO
|
|
25
|
IF @@ERROR <> 0 SET NOEXEC ON
|
|
26
|
GO
|
|
27
|
PRINT N'Creating primary key [PK__TR_REQ_K__3214EC2720D18873] on [dbo].[TR_REQ_KPI]'
|
|
28
|
GO
|
|
29
|
ALTER TABLE [dbo].[TR_REQ_KPI] ADD CONSTRAINT [PK__TR_REQ_K__3214EC2720D18873] PRIMARY KEY CLUSTERED ([ID])
|
|
30
|
GO
|
|
31
|
IF @@ERROR <> 0 SET NOEXEC ON
|
|
32
|
GO
|
|
33
|
PRINT N'Creating [dbo].[DT_KHACH_THUE_IMPORT]'
|
|
34
|
GO
|
|
35
|
CREATE TABLE [dbo].[DT_KHACH_THUE_IMPORT]
|
|
36
|
(
|
|
37
|
[MA_DV_TAO] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
38
|
[TEN_DV_TAO] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
39
|
[SO_HOP_DONG] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
40
|
[TEN_TRU_SO] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
41
|
[NGAY_GIA_HAN_HOP_DONG] [datetime] NULL,
|
|
42
|
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
43
|
[VAT] [int] NULL,
|
|
44
|
[SO_TIEN_DAT_COC] [decimal] (18, 2) NULL,
|
|
45
|
[NGAY_DINH_KY_THANH_TOAN] [datetime] NULL,
|
|
46
|
[LICH_THANH_TOAN] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
|
|
47
|
)
|
|
48
|
GO
|
|
49
|
IF @@ERROR <> 0 SET NOEXEC ON
|
|
50
|
GO
|
|
51
|
PRINT N'Creating [dbo].[DT_KHACH_THUE_DT_IMPORT]'
|
|
52
|
GO
|
|
53
|
CREATE TABLE [dbo].[DT_KHACH_THUE_DT_IMPORT]
|
|
54
|
(
|
|
55
|
[TEN_TRU_SO] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
56
|
[TANG] [int] NULL,
|
|
57
|
[DT_KHACH_HANG_THUE] [decimal] (18, 2) NULL,
|
|
58
|
[DON_GIA] [decimal] (18, 0) NULL,
|
|
59
|
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
|
|
60
|
)
|
|
61
|
GO
|
|
62
|
IF @@ERROR <> 0 SET NOEXEC ON
|
|
63
|
GO
|
|
64
|
COMMIT TRANSACTION
|
|
65
|
GO
|
|
66
|
IF @@ERROR <> 0 SET NOEXEC ON
|
|
67
|
GO
|
|
68
|
SET NOEXEC OFF
|