Update Database for Synapse

Submitter: detwiler

The above post did not mention that, in Postgres, I loaded the same "scenegen" database as dumped from ethmoid2. However, the asset (model) files had model file locations, within the database, that still referred to ethmoid2. I ran the following commands, from within the scenegen db on synapse to correct this:

update asset set asset_x3d_filename = REPLACE(asset_x3d_filename,'http://ethmoid2.biostr.washington.edu:8080','http://synapse.si.washington.edu:8080');

update asset set asset_obj_filename = REPLACE(asset_obj_filename,'http://ethmoid2.biostr.washington.edu:8080','http://synapse.si.washington.edu:8080');