sql: migrations: Add 0002.sqlite3

This migrations adds a `users` table with id, username and
password_bcrypt.

This allows basic user management and authentication.

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/migrations/0002.sqlite3 b/sql/migrations/0002.sqlite3
new file mode 100644
index 0000000..ea8aa3a
--- /dev/null
+++ b/sql/migrations/0002.sqlite3
@@ -0,0 +1,7 @@
+PRAGMA user_version = 2;
+
+CREATE TABLE users (
+	id              INTEGER PRIMARY KEY,
+	username        TEXT NOT NULL UNIQUE,
+	password_bcrypt BLOB NOT NULL UNIQUE
+);