-- ═══ PWO/WMS — Supabase Setup SQL (v55) ═══ -- Jalankan SEKALI di Supabase → SQL Editor -- 1. Tabel PWO List CREATE TABLE IF NOT EXISTS pwo_list ( id TEXT PRIMARY KEY, no_pwo TEXT, produk TEXT, qty_produksi NUMERIC DEFAULT 0, tgl_produksi DATE, status TEXT DEFAULT 'Saved', data JSONB, created_at TIMESTAMPTZ DEFAULT now() ); -- 2. Tabel Stok BB CREATE TABLE IF NOT EXISTS stok ( id TEXT PRIMARY KEY, kode TEXT, nama TEXT, induk TEXT, qty NUMERIC DEFAULT 0, satuan TEXT DEFAULT 'kg', no_dok TEXT, batch_inbound TEXT, tgl DATE, expired_date DATE, qty_masuk NUMERIC DEFAULT 0, qty_pakai NUMERIC DEFAULT 0, status TEXT DEFAULT 'Tersedia', created_at TIMESTAMPTZ DEFAULT now() ); -- 3. Tabel Penerimaan BB (termasuk data timbangan) CREATE TABLE IF NOT EXISTS penerimaan ( id TEXT PRIMARY KEY, no_dok TEXT, batch_inbound TEXT, lokasi TEXT, tgl DATE, supplier TEXT, status_final TEXT, segel TEXT, kebersihan TEXT, kondisi_kemasan TEXT, staff_inventory TEXT, qc_checker TEXT, leader TEXT, catatan TEXT, total_qty NUMERIC DEFAULT 0, items JSONB DEFAULT '[]', created_at TIMESTAMPTZ DEFAULT now() ); -- 4. Tabel Master BB Overrides CREATE TABLE IF NOT EXISTS master_bb_overrides ( kode TEXT PRIMARY KEY, sku TEXT, status TEXT DEFAULT 'Active', nama TEXT, induk TEXT, supplier TEXT, last_active TEXT, created_at TIMESTAMPTZ DEFAULT now() ); -- 5. Tabel Counters CREATE TABLE IF NOT EXISTS counters ( key TEXT PRIMARY KEY, value INTEGER DEFAULT 1, updated_at TIMESTAMPTZ DEFAULT now() ); INSERT INTO counters (key, value) VALUES ('pwo', 1), ('penerimaan', 1) ON CONFLICT (key) DO NOTHING; -- 6. Tabel Log Aktivitas CREATE TABLE IF NOT EXISTS activity_log ( id TEXT PRIMARY KEY, ts TIMESTAMPTZ DEFAULT now(), user_name TEXT, user_role TEXT, action TEXT, detail TEXT, screen TEXT ); -- 7. Tabel Daftar Pengguna CREATE TABLE IF NOT EXISTS users ( id TEXT PRIMARY KEY, username TEXT NOT NULL UNIQUE, nama TEXT NOT NULL, password_hash TEXT NOT NULL DEFAULT '', role TEXT DEFAULT 'Staff', active INTEGER DEFAULT 1, created_at TIMESTAMPTZ DEFAULT now() ); -- Enable RLS + open policy (anon key) ALTER TABLE pwo_list ENABLE ROW LEVEL SECURITY; ALTER TABLE stok ENABLE ROW LEVEL SECURITY; ALTER TABLE penerimaan ENABLE ROW LEVEL SECURITY; ALTER TABLE master_bb_overrides ENABLE ROW LEVEL SECURITY; ALTER TABLE counters ENABLE ROW LEVEL SECURITY; ALTER TABLE activity_log ENABLE ROW LEVEL SECURITY; ALTER TABLE users ENABLE ROW LEVEL SECURITY; CREATE POLICY "open_pwo" ON pwo_list FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "open_stok" ON stok FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "open_pnr" ON penerimaan FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "open_bb" ON master_bb_overrides FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "open_ctr" ON counters FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "open_log" ON activity_log FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "open_users" ON users FOR ALL USING (true) WITH CHECK (true);