You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
27 lines
5.3 KiB
27 lines
5.3 KiB
USE [FastMoneyPro_Remit]
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[customerAgreeDocumentTbl]
|
|
(
|
|
[rowId] [int] NOT NULL IDENTITY(1, 1),
|
|
[PdfName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
[AgreePdfPAth] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
[createBy] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
[createDate] [datetime] NULL,
|
|
[isActive] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
|
|
[targetObj] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
ALTER TABLE [dbo].[customerAgreeDocumentTbl] ADD CONSTRAINT [PK_customerAgreeDocumentTbl] PRIMARY KEY CLUSTERED ([rowId]) ON [PRIMARY]
|
|
GO
|
|
|
|
|
|
SET IDENTITY_INSERT [dbo].[customerAgreeDocumentTbl] ON
|
|
|
|
INSERT [dbo].[customerAgreeDocumentTbl] ([rowId], [PdfName], [AgreePdfPAth], [createBy], [createDate], [isActive], [targetObj]) VALUES (1, N'PrivacyPolicyProcess', N'http://gmeuat.gmeremit.com:5022/Document\\AgreeDocument\\PrivacyPolicyProcess.pdf', N'Justin', CAST(N'2020-01-12T16:28:26.977' AS DateTime), N'Y', N'STAGING')
|
|
INSERT [dbo].[customerAgreeDocumentTbl] ([rowId], [PdfName], [AgreePdfPAth], [createBy], [createDate], [isActive], [targetObj]) VALUES (2, N'PersonalInfoUseAgree', N'http://gmeuat.gmeremit.com:5022/Document\\AgreeDocument\\PersonalInfoUseAgree.pdf', N'Justin', CAST(N'2020-01-12T16:28:26.977' AS DateTime), N'Y', N'STAGING')
|
|
INSERT [dbo].[customerAgreeDocumentTbl] ([rowId], [PdfName], [AgreePdfPAth], [createBy], [createDate], [isActive], [targetObj]) VALUES (3, N'OverseasSendMoney', N'http://gmeuat.gmeremit.com:5022/Document\\AgreeDocument\\OverseasSendMoney.pdf', N'Justin', CAST(N'2020-01-12T16:28:26.977' AS DateTime), N'Y', N'STAGING')
|
|
INSERT [dbo].[customerAgreeDocumentTbl] ([rowId], [PdfName], [AgreePdfPAth], [createBy], [createDate], [isActive], [targetObj]) VALUES (4, N'IllegalTran', N'http://gmeuat.gmeremit.com:5022/Document\\AgreeDocument\\IllegalTran.pdf', N'Justin', CAST(N'2020-01-12T16:28:26.977' AS DateTime), N'Y', N'STAGING')
|
|
INSERT [dbo].[customerAgreeDocumentTbl] ([rowId], [PdfName], [AgreePdfPAth], [createBy], [createDate], [isActive], [targetObj]) VALUES (5, N'OpenbankingService', N'http://gmeuat.gmeremit.com:5022/Document\\AgreeDocument\\OpenbankingService.pdf', N'Justin', CAST(N'2020-01-12T16:28:26.977' AS DateTime), N'Y', N'STAGING')
|
|
INSERT [dbo].[customerAgreeDocumentTbl] ([rowId], [PdfName], [AgreePdfPAth], [createBy], [createDate], [isActive], [targetObj]) VALUES (6, N'ElectronicFinancial', N'http://gmeuat.gmeremit.com:5022/Document\\AgreeDocument\\ElectronicFinancial.pdf', N'Justin', CAST(N'2020-01-12T16:28:26.977' AS DateTime), N'Y', N'STAGING')
|
|
SET IDENTITY_INSERT [dbo].[customerAgreeDocumentTbl] OFF
|