schema / migration / 007-drop-amenities-branch-stocks

007 - Drop unused amenities + branch_stocks

  • Tanggal: 2026-08-10
  • DB: mpcdb (PostgreSQL)
  • Ringkas: Hapus tabel legacy amenities (Rent ada di products) dan branch_stocks (stock runtime di products.stock_quantity).

ALTER (jalankan di DB server)

-- Safe: apps read Rent via products; stock via products.stock_quantity
DROP TABLE IF EXISTS amenities;
DROP TABLE IF EXISTS branch_stocks;

Rollback (opsional)

-- Recreate only if needed; prefer restore from backup.
-- Structure was defined in Prisma BranchStock + amenities models (pre-v0.5 admin).

Catatan

  • GET /amenities di mpc-be tetap hidup (query products WHERE category = Rent).
  • Multi-branch stock adalah fitur baru terpisah — bukan rollback tabel ini.