DB_Script/ExecuteScript/MobileAPI.sql

USE [FastMoneyPro_Remit]
GO
TRUNCATE TABLE [mobile_GmeApiClientRegistration]
GO
SET IDENTITY_INSERT [dbo].[mobile_GmeApiClientRegistration] ON 
GO
INSERT [dbo].[mobile_GmeApiClientRegistration] ([rowid], [applicationName], [description], [aboutUrl], [applicationType], [scope], [clientId], [secret], [isActive], [approvedDate], [approvedBy]) 
VALUES (1, N'Android App', N'Android Mobile App', N'QRK2UM0Q', N'Android', N'mobile_app', N'fmfgBURM3H3dLKb2', N'�zZ\e�H��emK�Hr\Dmn\jVV', 1, CAST(N'2018-10-16T18:43:34.837' AS DateTime), N'system')
GO

GO
INSERT [dbo].[mobile_GmeApiClientRegistration] ([rowid], [applicationName], [description], [aboutUrl], [applicationType], [scope], [clientId], [secret], [isActive], [approvedDate], [approvedBy]) 
VALUES (2, N'IOS APP', N'IOS Mobile APP ', N'cQeThWmZ', N'IOS', N'mobile_app', N'pdSI9oDDJmsTm8Y9', N'i`zl�q[�fM}���dk�P�Nd�VV', 1, CAST(N'2021-08-26T15:30:16.490' AS DateTime), N'system')
GO


select * FROM mobile_GmeApiClientRegistration





select  dbo.FNAEncryptString('IAaV5bL8PmPnsQp8kcobUg==') 
select  dbo.FNAEncryptString('raACLr/pjLT2p/YCf+TUCQ==') 

INSERT [dbo].[mobile_GmeApiClientRegistration] ( [applicationName], [description], [aboutUrl], [applicationType], [scope], [clientId], [secret], [isActive], [approvedDate], [approvedBy])
VALUES ( N'Android Live', N'Android Mobile App', N'VkYp3s6v', N'Android', N'mobile_app', N'fmfgBURM3H3dLKb2', N'bZzoN{eQi�i��j�Q�|�{n�VV', 1, GETDATE(), N'system')