search

wfau / ScienceArchives

0 stars 0 forks source link

Update Programme - rename listRemeasTable to ultravistaMapRemeasurement #534

Open wfastrononomer opened 1 month ago

wfastrononomer commented 1 month ago

All the list remeasurement tables should be xxxMapRemeasurement

Done in test DB

Also need to create all the MAP tables.

update Programme set listRemeasTable=replace(listRemeasTable,'List','Map') where listRemeasTable!='NONE'

Done this on WSA and VSA

Created UltraVISTA MAP tables in VSA:

/curation/helpers/DropAndRecreateTables.py -a -u ldservrw VSA VSA_ultravistaMapSchema.sql