We have 3 requirements in this job:
1- Add a column Named (USERCODE) in the users table in the database which contains the sum of 1999+ID and to add the letter R at the left ( example : userID = 1 ---> usercode = R2000 , userID = 2 ---> usercode = R2001, ... etc) and to be located next to the userid column.
2- Change the "username" column to be "Referral_Id" , So the users have to enter a valid referral id when registering to the website ( referral id = existing usercode ) and to be required field.
Notice: the referral id shown in the table should be the value of the userID not the value of the usercode
3- Add new columns to the users table and to the registration form (when required)
*gender (as shown in the attached photo)
*date of birth (as shown in the attached photo)
*country (as shown in the attached photo)
*mobile number (as shown in the attached photo)
*registered at (auto time&date stamp)
*activated at (auto time&date stamp)
NOTE THAT we need a documentation of all the changes made and which files affected by that changes.
7 фрилансеров(-а) готовы выполнить эту работу в среднем за $31
Hello I have good experience in Database Management. I can easily update your MySQL database and update the backend code. Waiting to hear from you. Thank you.