UserTable

User Table

Coumns

UserID
primary key
varchar(10)

User w number.

UserFirst
varchar(45)

User first name.

UserLast
varchar(45)

User last name.

UserPass
blob

Encrypted password field.

UserAdmin
bit(1)

Bit flag to determine if user is an admin(1) or student(0).

UserPassReset
bit(1)

Bit flag to determine if user must reset password(1) or not(0).

UserEmail
varchar(45)

User email address.

UserActive
bit(1)

Bit flag to determine if user is active(1) or inactive(0)

UserYear
date

User registration date.

Stored Procedures

sp_AddUser
Expected values:spUserID:varchar, spFirst:varchar, spLast:varchar, spPass:blob, spAdmin:bit, spPassReset:bit, spEmail:varchar, spUserActive:bit, spUserDate:date

Adds a user to the user table.

sp_ChangePassword
Expected values:sp_newpassword:varchar, sp_userName:varchar

Changes the user's password.

sp_DeleteUser
Expected values:sp_userID:varchar

Deletes a user form user table.

sp_GetAllUsers

Gets all users from the user table.

sp_Login
Expected values:userName:varchar, pass:varchar

Returns a user with a matching w# and password.

sp_UpdateUser
Expected values:UID:varchar, FirstName:varchar, LastName:varchar, Admin:bit, PassReset:bit, Email:varchar, Active:bit, UYear:date

Updates a user's information.