Changes

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]]

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits