create table products (
  id text primary key,
  name text not null,
  brand text not null,
  category text not null,
  price numeric not null,
  old_price numeric,
  stock integer not null default 0,
  badge text,
  image text not null,
  notes text not null,
  active boolean not null default true
);

create table orders (
  code text primary key,
  customer jsonb not null,
  items jsonb not null,
  total numeric not null,
  status text not null default 'Recebido',
  created_at timestamptz default now()
);