DB Migration Process » History » Version 2
Amber Herold, 02/02/2010 09:48 AM
| 1 | 1 | Amber Herold | h1. DB Migration Process |
|---|---|---|---|
| 2 | |||
| 3 | The tables that will be affected are in the dbemdata database and the project database. |
||
| 4 | |||
| 5 | +dbemdata+ |
||
| 6 | |||
| 7 | * GroupData |
||
| 8 | * UserData |
||
| 9 | |||
| 10 | +project+ |
||
| 11 | |||
| 12 | * users |
||
| 13 | * login |
||
| 14 | * pis |
||
| 15 | * userdetails |
||
| 16 | * projectowner |
||
| 17 | 2 | Amber Herold | |
| 18 | h2. 1 Add new columns to UserData |
||
| 19 | |||
| 20 | Add: |
||
| 21 | |||
| 22 | * username |
||
| 23 | * fullname |
||
| 24 | * firstname |
||
| 25 | * lastname |
||
| 26 | * password |
||
| 27 | |||
| 28 | |||
| 29 | Leave the existing columns as is. Use of "name" and "full name" (with a space) will be phased out. |
||
| 30 | |||
| 31 |