Project

General

Profile

Download (7.92 KB)

Gen_6_User_05F03_05I01.txt

Luc Tran Van, 04/04/2023 03:14 PM

 
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'hienpt10500', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Phạm Thị Hiền', 'DV0001', NULL, '', 'NVTT', 'phamthihien2@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 15:02:46.437', 121), '1', CONVERT(DATETIME, '2023-04-04 15:02:46.437', 121), '1', 'DEP000000000080', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'phamthihien2@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'phamthihien2@vietbank.com.vn', N'hienpt10500', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000080', CONVERT(DATETIME, '2023-04-04 15:02:46.437', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3 
(NULL, N'lannt', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Nguyễn Thị Lan', 'DV0001', NULL, '', 'NVTT', 'nguyenthilan@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 15:02:46.453', 121), '1', CONVERT(DATETIME, '2023-04-04 15:02:46.453', 121), '1', 'DEP000000000080', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'nguyenthilan@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'nguyenthilan@vietbank.com.vn', N'lannt', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000080', CONVERT(DATETIME, '2023-04-04 15:02:46.453', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
4 
(NULL, N'diepnn', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N' Nguyễn Ngọc Diệp', 'DV0001', NULL, '', 'GDDV', 'nguyenngocdiep@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 15:02:46.457', 121), '1', CONVERT(DATETIME, '2023-04-04 15:02:46.457', 121), '1', 'DEP000000000080', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'nguyenngocdiep@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'nguyenngocdiep@vietbank.com.vn', N'diepnn', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000080', CONVERT(DATETIME, '2023-04-04 15:02:46.457', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
5 
(NULL, N'vietnt', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Nguyễn Tiến Việt', 'DV0001', NULL, '', 'NVTT', 'nguyentienviet@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 15:02:46.460', 121), '1', CONVERT(DATETIME, '2023-04-04 15:02:46.460', 121), '1', 'DEP000000000020', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'nguyentienviet@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'nguyentienviet@vietbank.com.vn', N'vietnt', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000020', CONVERT(DATETIME, '2023-04-04 15:02:46.460', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
6 
(NULL, N'hieubt', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Bùi Trung Hiếu', 'DV0001', NULL, '', 'NVTT', 'buitrunghieu@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 15:02:46.460', 121), '1', CONVERT(DATETIME, '2023-04-04 15:02:46.460', 121), '1', 'DEP000000000020', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'buitrunghieu@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'buitrunghieu@vietbank.com.vn', N'hieubt', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000020', CONVERT(DATETIME, '2023-04-04 15:02:46.460', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
7 
(NULL, N'khanhndk', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Nguyễn Đào Kim Khánh', 'DV0001', NULL, '', 'GDDV', 'nguyendaokimkhanh@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 15:02:46.463', 121), '1', CONVERT(DATETIME, '2023-04-04 15:02:46.463', 121), '1', 'DEP000000000020', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'nguyendaokimkhanh@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'nguyendaokimkhanh@vietbank.com.vn', N'khanhndk', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000020', CONVERT(DATETIME, '2023-04-04 15:02:46.463', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
8 
GO
9 

    		
  

  

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


    		
  

  

    
      11
    
    
      
(CONVERT(DATETIME2, '2023-04-04 15:02:46.4394633', 121), 0, 69, 1, (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'hienpt10500')),


    		
  

  

    
      12
    
    
      
(CONVERT(DATETIME2, '2023-04-04 15:02:46.4564672', 121), 0, 69, 1, (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'lannt')),


    		
  

  

    
      13
    
    
      
(CONVERT(DATETIME2, '2023-04-04 15:02:46.4614686', 121), 0, 51, 1, (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'diepnn')),


    		
  

  

    
      14
    
    
      
(CONVERT(DATETIME2, '2023-04-04 15:02:46.4634657', 121), 0, 69, 1, (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'vietnt')),


    		
  

  

    
      15
    
    
      
(CONVERT(DATETIME2, '2023-04-04 15:02:46.4644645', 121), 0, 69, 1, (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'hieubt')),


    		
  

  

    
      16
    
    
      
(CONVERT(DATETIME2, '2023-04-04 15:02:46.4654625', 121), 0, 51, 1, (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'khanhndk'))


    		
  

  

    
      17
    
    
      
GO


    		
  

  

    
      18
    
    
      

    		
  

  

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


    		
  

  

    
      20
    
    
      
('2022-12030', N'Phạm Thị Hiền', '0500', '05I01', 'hienpt10500', '', N'', CONVERT(DATETIME, '2023-04-04 15:02:46.437', 121)),


    		
  

  

    
      21
    
    
      
('0000-11017', N'Nguyễn Thị Lan', '0500', '05I01', 'lannt', '', N'', CONVERT(DATETIME, '2023-04-04 15:02:46.453', 121)),


    		
  

  

    
      22
    
    
      
('0000-16307', N' Nguyễn Ngọc Diệp', '0500', '05I01', 'diepnn', '', N'', CONVERT(DATETIME, '2023-04-04 15:02:46.457', 121)),


    		
  

  

    
      23
    
    
      
('2022-01001', N'Nguyễn Tiến Việt', '0500', '05F03', 'vietnt', '', N'', CONVERT(DATETIME, '2023-04-04 15:02:46.460', 121)),


    		
  

  

    
      24
    
    
      
('2018-03027', N'Bùi Trung Hiếu', '0500', '05F03', 'hieubt', '', N'', CONVERT(DATETIME, '2023-04-04 15:02:46.463', 121)),


    		
  

  

    
      25
    
    
      
('01.0-17003', N'Nguyễn Đào Kim Khánh', '0500', '05F03', 'khanhndk', '', N'', CONVERT(DATETIME, '2023-04-04 15:02:46.463', 121))