Update user creation database for data analysis
Currently, the database only have last_update
column which does not tell when the user first requested/created the account.
CREATE TABLE users (
id INTEGER NOT NULL,
username TEXT,
uid TEXT,
gid TEXT,
email TEXT,
reason TEXT,
fullname TEXT,
create_account TEXT,
git_commit TEXT,
dir_verify TEXT,
subscribe_mail_list TEXT,
notify_user TEXT,
sent TEXT,
reported BOOLEAN,
last_update DATETIME,
queuename TEXT, count BIGINT,
PRIMARY KEY (id),
CHECK (reported IN (0, 1))
);