SQLite database

[djb1815]

Features

The database should be constructed with the following tables:

• [x] users
  • email
  • password (hashed and salted)
  • creation_date
  • approved (yes or no)
• [x] admins
  • email
  • password (hashed and salted)
• [x] schedule
  • date/time
  • created_by (user)
  • name/band?

More may need to be added, feel free to make suggestions in comments.

[djb1815]

For the User table/object, we should use the built-in Django User Model. See documentation here https://docs.djangoproject.com/en/1.11/ref/contrib/auth/

It is already constructed with any fields we should need, but can be extended if necessary.

[djb1815]

Permissions can be defined to control whether or not a user is approved.

https://docs.djangoproject.com/en/1.11/ref/contrib/auth/#django.contrib.auth.models.Permission

[djb1815]

Initial database was finished with the last referenced commit, will likely need future modification outside of the scope of this issue.