Change FOX plotids from old to new naming

bexis / Module_ResearchAreaManagement

A tool to manage research areas. You can define the shape of your main plots and draw subplots inside. You can plan the localization of field experiments. You can use maps for orientation in the field. As you will keep the history of the subplots, you will always be able to distribute prospective subplots. Module for Core @BEXIS2.

0 stars 0 forks source link

Change FOX plotids from old to new naming #79

Closed aostrow closed 3 years ago

aostrow commented 3 years ago

In B1, we had the limitation of 5 characters for plotid-names. Also, the precise naming convention was not clear by the time of implementation.

Now we have no limitation, and the naming is clear. Therefore we can change the names/plotids.

Change:

"1" to "G", "2" to "GD", "3" to "D"
"A" to "AEW", "H" to "HEW", "S" to "SEW"

aostrow commented 3 years ago

UPDATE pmm_plot SET plotid = REPLACE(plotid,'-1','-G') WHERE plotid not like '%E%'

UPDATE pmm_plot SET plotid = REPLACE(plotid,'S','SEW') WHERE plotid not like '%E%'