Dept and branch fields in user info

[ridhishjain-zepto]

Add a dept, branch, and bio column in the user table, API change:

• /signup (branch and department from frontend as integer)
• /getUser (send branch and department as integer to frontend)
• /updateUser (update value of branch and department integer taken from frontend in DB)

Bio:

• /getUser (send bio as a string to frontend)
• /updateUser (take bio as a string and update in DB)

Department:

INSERT INTO `department` (`
id`,
`dept_name
`) VALUES
(0, 'Electrical Engineering'),
(1, 'Computer Science and Engineering'),
(2, 'Electronics Engineering'),
(3, 'Applied Mathematics'),
(4, 'Applied Physics'),
(5, 'Mechanical Engineering'),
(6, 'Civil Engineering'),
(7, 'Chemical Engineering'),
(8, 'Environmental Science and Engineering'),
(9, 'Mining Engineering'),
(10, 'Petroleum Engineering'),
(11, 'Humanities and Social Sciences'),
(12, 'Management Studies'),
(13, 'Fuel and Mineral Engineering'),
(14, 'Mining Machinery Engineering');

Branch

INSERT INTO `branch` (`
id`,
`branch_name
`) VALUES
(0, 'B.Tech'),
(1, 'M.Tech'),
(2, 'Dual Degree'),
(3, 'Integrated B.Tech and M.Tech');