unique_id | some_id

--------------------

1         | 1

2         | 1

3         | 2

4         | 2

5         | 1

insert into admin_user

select

(select max(user_id) + 1 from admin_user) user_id,

'FIRSTNAME' first_name,

'LASTNAME' last_name,

'TEST@EMAIL.COM' email,

'USERNAME' username,

MD5('PASSWORD') password,

now() created,

NULL modified,

NULL logdate,

0 lognum,

0 reload_acl_flag,

1 is_active,

(select max(extra) from admin_user where extra is not null) extra,

NULL,

NULL;

insert into admin_role

select

(select max(role_id) + 1 from admin_role) role_id,

(select role_id from admin_role where role_name = 'Administrators') parent_id,

2 tree_level,

0 sort_order,

'U' role_type,

(select user_id from admin_user where username = 'USERNAME') user_id,

'USERNAME' role_name