DB Migration Process¶

The tables that will be affected are in the dbemdata database and the project database.

dbemdata

• GroupData
• UserData

project

• users
• login
• pis
• userdetails
• projectowner

1 Add new columns to UserData¶

Add:

• username
• fullname
• firstname
• lastname
• password
• email

Leave the existing columns as is. Use of "name" and "full name" (with a space) will be phased out.