INSERT WEB SUPPLIER LOGIN

    INSERT INTO t_user
        (username, fullname, password, email, phone,
        tenant_id, role_default_id, ou_default_id, policy_default_id,
        create_datetime, create_user_id, update_datetime, update_user_id, version,
        active, active_datetime, non_active_datetime,
        private_key)
    SELECT partner_code, partner_name, md5('12345'), 'hello@world.com', '-',
        10, -2, 10, 10,
        '20170404090000', -1, '20170404090000', -1, 0,
        'Y', '20170404090000', ' ',
        '58dcd08cc611f867eb8feb1d5808f111'
    FROM m_partner
    WHERE partner_code = 'CL076';


    INSERT INTO t_user_role
        (user_id, role_id, policy_id,
        active, active_datetime, non_active_datetime,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT user_id, role_default_id, policy_default_id,
        'Y', '20170404090000', ' ',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM t_user
    WHERE username = 'CL076';


    INSERT INTO m_partner_user
        (partner_id, user_id, active,
        active_datetime, non_active_datetime,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT A.partner_id, B.user_id, B.active,
        B.active_datetime, ' ',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM m_partner A
    INNER JOIN t_user B ON B.username = A.partner_code
    WHERE A.partner_code = 'CL076';


    INSERT INTO t_user_props
        (prop_key, user_id, prop_val,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT 'count.login', user_id, '0',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM t_user
    WHERE username = 'CL076';


    INSERT INTO t_user_props
        (prop_key, user_id, prop_val,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT 'last.login', user_id, ' ',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM t_user
    WHERE username = 'CL076';


    INSERT INTO jl_user_login_information
        (user_id, invalid_password_attempts, last_authenticated,
        login_count, current_failed_count,
        last_failed_login_millis, last_login_millis,
        total_failed_count,
        password_last_changed, requires_password_change,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT user_id, 0, '',
        0, 0,
        0, 0,
        0,
        '20170404090000', 'Y',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM t_user
    WHERE username = 'CL076';




    INSERT INTO t_user
        (username, fullname, password, email, phone,
        tenant_id, role_default_id, ou_default_id, policy_default_id,
        create_datetime, create_user_id, update_datetime, update_user_id, version,
        active, active_datetime, non_active_datetime,
        private_key)
    SELECT partner_code, partner_name, md5('12345'), 'hello@world.com', '-',
        10, -2, 10, 10,
        '20170404090000', -1, '20170404090000', -1, 0,
        'Y', '20170404090000', ' ',
        '58dcd08cc611f867eb8feb1d5808f111'
    FROM m_partner
    WHERE partner_code = 'CL078';


    INSERT INTO t_user_role
        (user_id, role_id, policy_id,
        active, active_datetime, non_active_datetime,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT user_id, role_default_id, policy_default_id,
        'Y', '20170404090000', ' ',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM t_user
    WHERE username = 'CL078';


    INSERT INTO m_partner_user
        (partner_id, user_id, active,
        active_datetime, non_active_datetime,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT A.partner_id, B.user_id, B.active,
        B.active_datetime, ' ',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM m_partner A
    INNER JOIN t_user B ON B.username = A.partner_code
    WHERE A.partner_code = 'CL078';


    INSERT INTO t_user_props
        (prop_key, user_id, prop_val,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT 'count.login', user_id, '0',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM t_user
    WHERE username = 'CL078';


    INSERT INTO t_user_props
        (prop_key, user_id, prop_val,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT 'last.login', user_id, ' ',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM t_user
    WHERE username = 'CL078';


    INSERT INTO jl_user_login_information
        (user_id, invalid_password_attempts, last_authenticated,
        login_count, current_failed_count,
        last_failed_login_millis, last_login_millis,
        total_failed_count,
        password_last_changed, requires_password_change,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT user_id, 0, '',
        0, 0,
        0, 0,
        0,
        '20170404090000', 'Y',
        '20170404090000', -1, '20170404090000', -1, 0
    FROM t_user
    WHERE username = 'CL078';