Challenge Overview
For this challenge, we basically need to opt a new user during activation in for all active notification types. Check this source file:
common_oltp.notify_lu is the table stores all the types, we need to get all active types with status='A' and insert to common_oltp.user_notify_xref for a user when we activate a new user.
VM, SVN
VM:
VM specific information is found here: http://www.topcoder.com/wiki/display/docs/VM+Image+2.5.
Upon registration as a submitter or reviewer you will need to request a VM based on the new TopCoder Cockpit/Direct image. To request your image, please use the forum.
Before requesting your VM, you need to ensure that you have an SSH key created and in your member profile. Instructions to do so are here:http://www.topcoder.com/wiki/display/projects/Generate+SSH+Key, and instructions to connect afterwards are here: http://www.topcoder.com/wiki/display/projects/Connect+Using+SSH+Key.
There is a TC Site Resource page that contains documentation / instructions for the VM instance you will be issued upon request. It is located here:http://www.topcoder.com/wiki/display/projects/Cockpit%2CDirect+VM
SVN:
Please email support@topcoder.com to request access to direct trunk and any other SVN paths listed above and below, please include the contest title/link and your user name in the email.
Web Module: https://coder.topcoder.com/internal/web_module/trunk
DB Trunk: https://coder.topcoder.com/internal/database/scripts/trunk
Final Submission Guidelines
Below is an overview of the deliverables:
- The new code that does what's required.
- A document that explains how to setup and test your code, with detailed verification steps and valid test data.