task

DB - users - cleanup unconfirmed

[previously]

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

[currently]

1. ]

[next]

1. ]

 

Details

ID: 4562

NAME: DB-users

DESCRIPTION: CLEANUP - ] remove unconfirmed user records, ]

START DATE TIME: 2014-12-21 16:12:40

EST DURATION: 01:00:00

END DATE TIME: 2014-12-21 17:12:40

STATUS: Completed

PRIORITY: -5

OWNER ID: 75

photos

actions

Agenda Email task SMS task Priorities