Confluence添加管理员用户

/*
loginName:admin2,Password:admin
id：1212121（大一位，确保不会重复）
*/
insert into cwd_user(id, user_name, lower_user_name, active, created_date, updated_date, first_name, lower_first_name, last_name, lower_last_name, display_name, lower_display_name, email_address, lower_email_address, directory_id, credential) values (1212121, 'admin2', 'admin2', 'T', '2009-11-26 17:42:08', '2009-11-26 17:42:08', 'A. D.', 'a. d.', 'Ministrator', 'ministrator', 'A. D. Ministrator', 'a. d. ministrator', 'admin@example.com', 'admin@example.com', (select id from cwd_directory where directory_name='Confluence Internal Directory'), 'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==');
 
insert into user_mapping values ('2c9681954172cf560000000000000002', 'admin2', 'admin2');

/*
添加权限：用户角色和管理员角色
294915：取自：(select top 1 id from cwd_membership order by id desc)+1
294916：取自：(select top 1 id from cwd_membership order by id desc)+1
*/
insert into cwd_membership (id, parent_id, child_user_id) values (294915, (select id from cwd_group where group_name='confluence-users' and directory_id=(select id from cwd_directory where directory_name='Confluence Internal Directory')), 1212121);
insert into cwd_membership (id, parent_id, child_user_id) values (294916, (select id from cwd_group where group_name='confluence-administrators' and directory_id=(select id from cwd_directory where directory_name='Confluence Internal Directory')), 1212121);