
-- v7.3 patch: create users_v7 independent table
CREATE TABLE IF NOT EXISTS users_v7 (
  user_id BIGINT NOT NULL,
  phone VARCHAR(20) NULL,
  mode VARCHAR(10) NOT NULL DEFAULT 'buyer',
  role VARCHAR(10) NOT NULL DEFAULT 'buyer',
  created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
