X-Git-Url: https://git.jacobcasper.com/?p=perfect-gift.git;a=blobdiff_plain;f=backend%2Fmigrations%2F003-create_user.sql;fp=backend%2Fmigrations%2F003-create_user.sql;h=3ae517a45ec5705e01cc0571668f757d0797e600;hp=0000000000000000000000000000000000000000;hb=d52f08d6553f3c61ee71067c791b94f1f1e041da;hpb=7f640a6b59bdce4326d1427689c00cb71600cb7d

diff --git a/backend/migrations/003-create_user.sql b/backend/migrations/003-create_user.sql
new file mode 100644
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
+);