DB Migration Process » History » Revision 5
Revision 4 (Amber Herold, 02/02/2010 10:54 AM) → Revision 5/29 (Amber Herold, 02/02/2010 10:55 AM)
h1. DB Migration Process The tables that will be affected are in the dbemdata database and the project database. Migrate the user data from project to dbemdata because dbemdata is already in Sinedon format. +dbemdata+ * GroupData * UserData +project+ * users * login * pis * userdetails * projectowner *Future* Eventually, we would like to have 3 databases, appion, leginon and project. The user related tables in dbemdata would be moved to project. All the tables in project still need to be converted to Sinedon format. +dbemdata+ * GroupData * UserData +project+ * users * login * pis * userdetails * projectowner h2. 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. h2. 2 Copy data to the UserData table From users, copy username, firstname, lastname to UserData. From login, copy password to UserData. From userdetails, copy email to UserData. h2. 3 Create projectowner table Move the data from pis table to a new projectowner table in the project database. This table will refer to users in the UserData table. We will phase out use of the pis table. h3. 4 Modify userdetails table Remove the email column from the userdetails table.