Database Migrations

Run Database Migrations

Apply database schema changes to add new fields to the SKUs table

Migration Details

This migration adds unit cost and unit sale price fields to the SKUs table

-- Add unit_cost and unit_sale_price columns to the skus table
ALTER TABLE skus 
ADD COLUMN IF NOT EXISTS unit_cost NUMERIC(12, 2),
ADD COLUMN IF NOT EXISTS unit_sale_price NUMERIC(12, 2);