Changes

Jump to: navigation, search

Location point

83 bytes removed, 04:43, 18 November 2014
no edit summary
{{Warning | This page contains UPDATE and DELETE queries}} This Run this query changes '''Location pointbefore''' to the database upgrade starts and compare with the result '''Reference pointafter'''upgrade.
<pre>
UPDATE SELECT"public".imsmaenum.enumvalue,Count("public".geopoint.geopoint_guid)SETFROM"public".imsmaenumINNER JOIN "public".geopoint ON "public".geopoint.pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'"public".imsmaenum.imsmaenum_guidWHEREGROUP BYpointtypeenum_guid = '{TestData-PointType-00000000000-00009}'"public".imsmaenum.enumvalueORDER BY"public".imsmaenum.enumvalue ASC
</pre>
<pre>
DELETE FROM imsmaenum
WHERE
imsmaenum.enumcategory = 'Point Type' AND
imsmaenum.enumvalue = 'Location Point' AND
imsmaenum.imsmaenum_guid = '{TestData-PointType-00000000000-00009}'
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]
Alnaucler
NoPublic, bureaucrat, administrator
6,632
edits
Retrieved from "http://mwiki.gichd.org:8090/IM/Special:MobileDiff/17967"

Navigation menu