useful-qry/table-controls/테이블-replace.sql

REPLACE INTO dbr_media
    (id, media_no, media_date, user_id, branch_id, media_brand, media_name)
VALUES
    (1, '200101-0000', '20000101', 5, 1, 'item', 'blank_image');

REPLACE INTO dbr_media_bd (id,  media_id, seq_no, image_type, bd_file_url) VALUES (1, 1, 1, 'big', '');
REPLACE INTO dbr_media_bd (id,  media_id, seq_no, image_type, bd_file_url) VALUES (2, 1, 2, 'middle', '');
REPLACE INTO dbr_media_bd (id,  media_id, seq_no, image_type, bd_file_url) VALUES (3, 1, 3, 'thumb', '');

REPLACE INTO users
    (id, email, password, activate_code, reset_code, nick_name, first_name, sur_name, status)
VALUES
    (1, SUBSTR(MD5(RAND()),1,20), 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', '5');

REPLACE INTO dbr_user_ext
    (id, mobile_no, phone_no, user_perm_id, menu_lang_sw,
    sgroup_id, branch_id, storage_id, agroup_id, country_code, is_expired)
VALUES
    (1, 'unlinked', 'unlinked', 7, 0, 
    1, 1, 1, 1, 'ko_KR', '0');

REPLACE INTO pro_member
    (id, email, password, activate_code, reset_code, nick_name, first_name, sur_name, status, buyer_id)
VALUES
    (1, 'email-unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', '5', 1);

REPLACE INTO pro_member
    (id, email, password, activate_code, reset_code, nick_name, first_name, sur_name, status, sso_sub_id, is_member_app)
VALUES
    (2, 'ab64-app', 'ab64-app', 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', '5', 2, '1');

REPLACE INTO pro_member
    (id, email, password, activate_code, reset_code, nick_name, first_name, sur_name, status, sso_sub_id, is_member_app)
VALUES
    (3, 'api23-app', 'api23-app', 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', '5', 3, '1');

REPLACE INTO pro_member_ext
    (id, mobile_no, phone_no, member_perm_id, menu_lang_sw,
    sgroup_id, branch_id, storage_id, agroup_id, country_code, is_expired)
VALUES
    (1, 'unlinked', 'unlinked', 7, 0, 
    1, 1, 1, 1, 'ko_KR', '0');

REPLACE INTO pro_member_ext
    (id, mobile_no, phone_no, member_perm_id, menu_lang_sw,
    sgroup_id, branch_id, storage_id, agroup_id, country_code, is_expired)
VALUES
    (2, 'unlinked', 'unlinked', 7, 0, 
    1, 1, 1, 1, 'ko_KR', '0');

REPLACE INTO pro_member_ext
    (id, mobile_no, phone_no, member_perm_id, menu_lang_sw,
    sgroup_id, branch_id, storage_id, agroup_id, country_code, is_expired)
VALUES
    (3, 'unlinked', 'unlinked', 7, 0, 
    1, 1, 1, 1, 'ko_KR', '0');

REPLACE INTO dbr_company
    (id, created_on, updated_on, 
    company_date, company_no, company_name, company_class, full_name 
    )
VALUES
    (1, unix_timestamp(), unix_timestamp(),
    '00000000', '000000-00', 'unlinked', 'AA', 'unlinked');

REPLACE INTO pro_member_device
    (id, created_on, activate_on,
     member_id, device_ip, device_hash, device_desc, last_login_on, status )
VALUES
    (1, unix_timestamp(), unix_timestamp(),
    1, 'unlinked', 'unlinked', 'unlinked', 0, '0');