commit f44d8af81c21105228d5df3c7253f3c3c68de2e9 from: Tracey Emery date: Mon May 16 18:28:59 2022 UTC update schema 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 );