Create db queries

[JollyRen]

Todo

User DB Functions

• createUser
• getUserById
• getUserByIdAuth (authorized users only, has all data; backend use only)
• getUserByUsername (authorized users only, has all data, no subs; backend use only)
• verifyUser (uses getUserByUsername)
• getAllUsers
• updateUser
• deleteUser (changes active state)
• createSub
• getSubByUserId
• getSubsByStatus
• updateSub
• cancelSub

Item DB Functions

• createColor
• getColorByName
• getColorByCode
• editColor
• deleteColor
• addItem
• getItemByName
• getItemByType
• getItemBySubtype
• editItem
• deleteItem
• addPattern
• editPattern
• deletePattern

Client DB Functions

• createClient
• updateClient
• deleteClient
• createChoice
• getChoice
• updateChoice
• deleteChoice
• getClientsByUser
• getclientById