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 freelances font une offre moyenne de 31 $ pour ce travail
I am Senior Full Stack Developer in Website/Software Design & Website Development. I'm an Expert in: -Frontend & Backend Development -Zend -Cake PHP -Python -Data Science -Machine Learning -JVM technologies -Jquery, P Plus
Hi I am Ahmed from Palestine living in Turkey, I speak Arabic & English very well. We are an integrated team working in several fields like building a Websites, APPs, creating Videos and Designs. I read your project '' Plus
Hii there, How are you?? I have checked your need having more than 4 years experience , you want someone who can understand and perform modification in your existing website so please share me credential with an oppor Plus
Hi, I am available to work on this project if you like you can discus with me in private message I start work asap.
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.
Hello there ! I did Read Your Requirements as You Shown in Project Details. Excellent Knowledge in web developments. please share me project details. I will solve your issues very fast. I will provide you best resp Plus
Hey dude, I can do this job for you as quick as you want I have a good experience in Backend PHP and SQL If you're interested I look forward your reply