insert into usr_institution (id,keyword,name,url,institution_type_id) values (nextval('usr_institution_id_seq'),'NAME','KEYWORD','http://gazelle.ihe.net',1);

insert into usr_users (id,email,password,username,institution_id,activated,is_institution_informations_entered,blocked,counter_logins,counter_failed_login_attempts,firstname) values (nextval('usr_users_id_seq'),'EMAIL','MD5PASSWORD','ADMIN',(SELECT  id from usr_institution where keyword = 'KEYWORD'),true,true,false,0,0,'ADMIN');

insert into usr_user_role (user_id,role_id) values ((select id from usr_users where username = 'ADMIN'), (select id from usr_role where name ='admin_role'));
INSERT INTO tm_user_preferences VALUES (nextval('tm_user_preferences_id_seq'), 'now', 'ADMIN', 20, NULL, (select id from usr_users where username = 'ADMIN'), 35, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL);