9 lines
361 B
SQL
9 lines
361 B
SQL
-- Migration: Add harvest weight tracking to mortality records
|
|
-- Date: 2026-06-19
|
|
-- Description: Adds berat_panen to mortality_records so harvest weight persists across reloads
|
|
|
|
ALTER TABLE mortality_records
|
|
ADD COLUMN IF NOT EXISTS berat_panen NUMERIC(10,2) DEFAULT 0;
|
|
|
|
COMMENT ON COLUMN mortality_records.berat_panen IS 'Daily harvest weight in kilograms';
|