DB Migration Process » History » Revision 11
Revision 10 (Amber Herold, 02/03/2010 12:43 PM) → Revision 11/29 (Amber Herold, 02/03/2010 01:35 PM)
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 (81 rows) +project+ * users (233 rows) * login (187 rows) * pis (145 rows) * 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. 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. h2. 4 Modify userdetails table Remove the email column from the userdetails table. From users, copy all needed fields.