edit-task

Task Description: CLEANUP - ] remove unconfirmed user records, ]

Start Date:

Start Time:

Duration:

Priority:

Status: To Do Completed In Process

Add Photo:

Owner ID:

Content: use HTML Edit Content <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>