CREATE TABLE IF NOT EXISTS user_profile_details (
 user_id BIGINT UNSIGNED NOT NULL PRIMARY KEY,
 preferred_name VARCHAR(100) NOT NULL DEFAULT '',
 phone VARCHAR(40) NOT NULL DEFAULT '',
 country VARCHAR(100) NOT NULL DEFAULT '',
 city VARCHAR(100) NOT NULL DEFAULT '',
 bio VARCHAR(1000) NOT NULL DEFAULT '',
 revision INT UNSIGNED NOT NULL DEFAULT 1,
 updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
