alter table equipment_items
  add column if not exists short_name text;

create table if not exists user_click_daily (
  user_id uuid not null references users(id) on delete cascade,
  click_date date not null,
  click_count integer not null default 0,
  updated_at timestamptz not null default now(),
  primary key (user_id, click_date)
);

create index if not exists user_click_daily_click_date_idx on user_click_daily (click_date desc);

