Database build script

[n1c0z]

Nicely structured SQL script. 👍

Only a couple of suggestions that you may find useful:

• Like that you have kept most of your VARCHARs for email and names to 80. Personally, I am happy to keep it to 255 which I think is the default value.
• TEXT I believe is anything above 4000 characters (I think that's about 2-3 pages in Word). Feel free to use VARCHAR instead with a smaller number if storage would be an issue.
• I would probably move the on_loan field to loans as this is a dynamic field while the items table is quite static. Normally historical data are tend to be kept in a separate table from non-frequently updated tables, i.e. users / user-logins