Commit Diff


commit - 64eab2f45dd67a04e1e34cc237c8cc6341c29633
commit + f44d8af81c21105228d5df3c7253f3c3c68de2e9
blob - a2f9e32ad8c7606b99baa8259ca5a0f8c11bcc39
blob + aa9d93fc460e9c1a28ef03a094efbe5430895640
--- data/schema.sql	
+++ data/schema.sql	
@@ -14,7 +14,11 @@ CREATE TABLE members (
 	inviter INTEGER,
 	r_admin INTEGER,
 	r_editor INTEGER,
-	ip_address TEXT
+	ip_address TEXT,
+	twofa INTEGER,
+	twofa_moddate INTEGER,
+	phone INTEGER,
+	blocked INTEGER
 );
 
 CREATE TABLE companies (
@@ -24,7 +28,6 @@ CREATE TABLE companies (
 	domain TEXT NOT NULL,
 	phone TEXT NOT NULL,
 	downloads INTEGER,
-	is_admin INTEGER
 );
 
 CREATE TABLE downloads (
@@ -33,5 +36,6 @@ CREATE TABLE downloads (
 	id_key UUID NOT NULL,
 	u_key UUID NOT NULL,
 	e_key UUID NOT NULL,
+	company_id INTEGER NOT NULL,
 	downloaded INTEGER
 );