(public).sospep.events ~ view task ~ DB-users

<h1 style="text-align: center;">DB - users - cleanup unconfirmed</h1>
<h2>[previously]</h2>
<ol>
<li><strong>[12-19]17:30] NEW task IN s/prj-000/DB</strong></li>
<ol>
<li>*] # 4531 - DB-maintenance - x] users - backup current tables,</li>
</ol>
<li><strong>[TASKS] </strong></li>
<ol>
<li><strong>] EDIT - remove non confirmed users,</strong></li>
<ol>
<li>] TRY - USE select into to create a copy of the records in the&nbsp;table(that we dont want)&nbsp;</li>
<li>] FAIL - bc need create table, need tooling or have to do manually,</li>
<li>] proceed with delete, HAVE copy of orig record set on file</li>
</ol></ol>
<li><strong>[PROCESS]</strong></li>
<ol>
<li>] write code to execute against the db</li>
<li>OR</li>
<li>x] copy db local, make changes, upload db</li>
</ol>
<li><strong>[TOOLS]</strong></li>
<ol>
<li>x] USE local db ide(WM)</li>
</ol>
<li><strong>[2014-12-23] EDIT - remove non confirmed users, </strong></li>
<ol>
<li>x] have approx (###) in users (xx %) that&nbsp;are not confirmed users,</li>
<li><strong>x] PRB - NO relationship between "user profile"&nbsp;&nbsp;&amp;&nbsp;"members" table</strong></li>
<ol>
<li>*] see PRIVATE &nbsp;docs</li>
</ol>
<li>x] deleted non confirmed users</li>
<li>x] deleted corresponding records in members</li>
</ol>
<li><strong>[2014-12-23]</strong><strong> VERIFY - manually)</strong></li>
<ol>
<li>x] all sospep owners are still present in user profile</li>
</ol>
<li><strong>[2014-12-23] UPLOAD&nbsp;</strong></li>
<ol>
<li>x] # # - modified users db</li>
<li>*] # # - check current ( no changes),</li>
<li>x] download (extra) copy as precaution</li>
</ol>
<li><strong>[2014-12-23] TEST - </strong></li>
<ol>
<li>x] # # - login - multiple accounts (OK)</li>
</ol>
<li><strong>[2014-12-23] TEST -</strong></li>
<ol>
<li>] #&nbsp;4566 - registration - PENDING ( 2 problems to resolve)</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>]</li>
</ol>
<h2>[next]</h2>
<ol>
<li>]</li>
</ol>
<p>&nbsp;</p>

~ view task ~ TaskGroup] DB FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep