-- 일보 저장
CREATE TABLE IF NOT EXISTS daily_reports (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  report_date DATE NOT NULL,
  day_of_week TEXT,
  safety_msg TEXT,
  material_text TEXT,
  rows_json JSONB DEFAULT '[]',
  equips_json JSONB DEFAULT '[]',
  created_at TIMESTAMPTZ DEFAULT NOW()
);
-- items 신규 컬럼
ALTER TABLE items ADD COLUMN IF NOT EXISTS qty INT DEFAULT 1;
ALTER TABLE items ADD COLUMN IF NOT EXISTS level_el TEXT;
ALTER TABLE items ADD COLUMN IF NOT EXISTS length_mm FLOAT DEFAULT 0;
ALTER TABLE items ADD COLUMN IF NOT EXISTS paint_area FLOAT DEFAULT 0;
ALTER TABLE items ADD COLUMN IF NOT EXISTS matl TEXT;
ALTER TABLE items ADD COLUMN IF NOT EXISTS remark TEXT;
ALTER TABLE items ADD COLUMN IF NOT EXISTS location TEXT;