CREATE TABLE IF NOT EXISTS user ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `avatar` VARCHAR, `username` VARCHAR UNIQUE NOT NULL, `password_hash` VARCHAR NOT NULL, `last_seen` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP );