create table produk (
  id text primary key,
  kode text unique not null,
  nama text not null,
  kategori text, harga numeric default 0,
  hpp numeric default 0,
  stok_awal integer default 0,
  min_stok integer default 5,
  ket text,
  created_at timestamptz default now()
);
create table penjualan (
  id text primary key, tgl date not null,
  channel text, platform text,
  produk_id text references produk(id),
  qty integer default 1, harga numeric default 0,
  diskon numeric default 0, status text,
  catatan text, created_at timestamptz default now()
);
create table pembelian (
  id text primary key, tgl date not null,
  faktur text, supplier text,
  produk_id text references produk(id),
  qty integer default 1, harga numeric default 0,
  metode text, catatan text,
  created_at timestamptz default now()
);
alter table produk enable row level security;
alter table penjualan enable row level security;
alter table pembelian enable row level security;
create policy "allow all" on produk for all using (true);
create policy "allow all" on penjualan for all using (true);
create policy "allow all" on pembelian for all using (true);