Project

General

Profile

Download (2.23 KB)

import_user_dunglh0500.txt

Luc Tran Van, 04/05/2023 09:43 AM

 
1 
INSERT INTO TL_USER (TLID, TLNANME, Password, TLFullName, TLSUBBRID, BRANCH_NAME, BRANCH_TYPE, RoleName, EMAIL, ADDRESS, PHONE, AUTH_STATUS, MARKER_ID, AUTH_ID, APPROVE_DT, ISAPPROVE, Birthday, ISFIRSTTIME, SECUR_CODE, AccessFailedCount, AuthenticationSource, ConcurrencyStamp, CreatorUserId, DeleterUserId, EmailAddress, EmailConfirmationCode, IsActive, IsDeleted, IsEmailConfirmed, IsLockoutEnabled, IsPhoneNumberConfirmed, IsTwoFactorEnabled, LastModifierUserId, LockoutEndDateUtc, Name, NormalizedEmailAddress, NormalizedUserName, PasswordResetCode, PhoneNumber, ProfilePictureId, SecurityStamp, ShouldChangePasswordOnNextLogin, Surname, TenantId, SignInToken, SignInTokenExpireTimeUtc, GoogleAuthenticatorKey, SendActivationEmail, DEP_ID, CreationTime, UamFullName, UamEmployeeId, UamCompanyCode, UamWfDataId, UamCompanyName, UamJobTitle, UserCurrentLanguage, EMAILTEMP) VALUES
2 
(NULL, N'dunglh0500', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Lê Hoàng Dũng ', 'DV0001', NULL, '', 'GDDV', 'lehoangdung@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 10:47:17.653', 121), '1', CONVERT(DATETIME, '2023-04-04 10:47:17.653', 121), '1', 'DEP000000000048', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'lehoangdung@vietbank.com.vn', NULL, CONVERT(bit, 'True'), CONVERT(bit, 'False'), CONVERT(bit, 'True'), CONVERT(bit, 'False'), CONVERT(bit, 'True'), CONVERT(bit, 'False'), 259, NULL, NULL, N'lehoangdung@vietbank.com.vn', N'dunglh0500', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000048', CONVERT(DATETIME, '2023-04-04 10:47:17.653', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
3 
GO
4 

    		
  

  

    
      5
    
    
      
INSERT INTO AbpUserRoles (CreationTime, CreatorUserId, RoleId, TenantId, UserId) VALUES


    		
  

  

    
      6
    
    
      
(CONVERT(DATETIME2, '2023-04-04 10:47:17.6549103', 121), 0, 2096, 1, 100),


    		
  

  

    
      7
    
    
      
(CONVERT(DATETIME2, '2023-04-04 10:47:17.7949150', 121), 0, 51, 1, 100)


    		
  

  

    
      8
    
    
      
GO


    		
  

  

    
      9
    
    
      

    		
  

  

    
      10
    
    
      

    		
  

  

    
      11
    
    
      
INSERT INTO CM_EMPLOYEE_LOG (EMP_CODE, EMP_NAME, BRANCH_CODE, DEP_CODE, USER_DOMAIN, POS_CODE, POS_NAME, CREATE_DT) VALUES


    		
  

  

    
      12
    
    
      
('2022-11039', N'Lê Hoàng Dũng ', '0500', '05N22', 'dunglh0500', N'', N'', CONVERT(DATETIME, '2023-04-04 10:47:17.653', 121))