2. PHPRunner General questions
  3. [SOLVED]  Renaming database tables
This topic is locked
[SOLVED]

 Renaming database tables

 		6/27/2014 9:44:13 AM
PHPRunner General questions
W
 wpl author

Hello list,
how would one deal with the case of some (>5) tables (for which pages exist) having to be renamed in the database? Of course, without losing pages, events and so on. Is there a recomended manual procedure for what seems to be a feature in PHPRunner 8. Version in use is 7.1, build 21342.
thanks
Sergey Kornilov admin 6/27/2014

Rename it right in PHPRunner, using 'Modify table' function on Datasource tables screen.
W
 		wpl author 6/28/2014

Sergey,
thank you. I really did not expect it to be that simple! And it will really propagate the changes to all necessary occurrences of that table name? That's cool. And what about changing a column's name?
tia
Sergey Kornilov admin 6/30/2014

It will update table names where it can i.e. in master-details relationships. The same applies to field name change - it will be changed automatically where it's possible. I would suggest to run a search across .phpr project file just in case for old table/field names and change it manually if found.