Added database migration files

[perfect-gift.git] / backend / migrations / 003-create_user.sql

diff --git a/backend/migrations/003-create_user.sql b/backend/migrations/003-create_user.sql
new file mode 100644 (file)
index 0000000..3ae517a
--- /dev/null
+++ b/backend/migrations/003-create_user.sql
@@ -0,0 +1,7 @@
+CREATE TABLE USER(
+    ID INTEGER PRIMARY KEY AUTOINCREMENT,
+    USERNAME TEXT NOT NULL,
+    HASH TEXT NOT NULL,
+    SALT BLOB NOT NULL,
+    EMAIL TEXT
+);