Sign up/in/out and authentication.

[recipes.git] / backend / sql / version_1.sql

diff --git a/backend/sql/version_1.sql b/backend/sql/version_1.sql
index 4457863..aaa8a9f 100644 (file)
--- a/backend/sql/version_1.sql
+++ b/backend/sql/version_1.sql
@@ -25,7 +25,7 @@ CREATE TABLE [UserLoginToken] (
     [last_login_datetime] DATETIME,
     [token] TEXT NOT NULL, --  24 alphanumeric character token. Can be stored in a cookie to be able to authenticate without a password.
 
-    [ip] INTEGER,
+    [ip] TEXT, -- Can be ipv4 or ipv6
     [user_agent] TEXT,
 
     FOREIGN KEY([user_id]) REFERENCES [User]([id])