--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/migration/migrate_users.sql	Tue Sep 08 17:00:21 2015 +0200
@@ -0,0 +1,37 @@
+-----------------------
+-- users
+-----------------------
+
+insert into builtinuser(	id, affiliation, email, firstname, lastname, position, username)
+	select			id, institution, email, firstname, lastname, position, username
+	from _dvn3_vdcuser;
+
+insert into authenticateduser(	id, affiliation, email, firstname, lastname, position, useridentifier, superuser)
+	select			id, institution, email, firstname, lastname, position, username, false
+	from _dvn3_vdcuser;
+
+insert into authenticateduserlookup(	authenticationproviderid, persistentuserid, authenticateduser_id)
+	select				'builtin',  username, id
+	from _dvn3_vdcuser;
+
+-----------------------
+-- groups
+-----------------------
+
+-- only copy over groups that have users
+insert into explicitgroup(  id, description, displayname, groupalias, groupaliasinowner, owner_id)
+        select id, friendlyname, friendlyname, '1-'||name, name, 1
+        from _dvn3_usergroup
+        where id in (select usergroups_id from _dvn3_vdcuser_usergroup);
+
+insert into explicitgroup_authenticateduser(  explicitgroup_id, containedauthenticatedusers_id)
+        select usergroups_id, users_id
+        from _dvn3_vdcuser_usergroup;
+
+-----------------------
+-- reset sequences
+-----------------------
+
+SELECT setval('builtinuser_id_seq', (SELECT MAX(id) FROM builtinuser));
+SELECT setval('authenticateduser_id_seq', (SELECT MAX(id) FROM authenticateduser));
+SELECT setval('explicitgroup_id_seq', (SELECT MAX(id) FROM explicitgroup));
\ No newline at end of file