NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
Run this query '''before''' the database upgrade starts and compare with the result '''after''' upgradeto check if there are any Location points.
<pre>
SELECT
</pre>
If there are Location points this query will change them to Reference points.
<pre>
UPDATE geopoint
SET
geopoint.pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'
WHERE
geopoint.pointtypeenum_guid = '{TestData-PointType-00000000000-00009}'
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]
