19 lines
739 B
SQL
19 lines
739 B
SQL
-- ============================================
|
||
-- 重新添加 age / gender 列（consumer 端提交预约需要）
|
||
-- 不影响 delivery 端链路
|
||
-- ============================================
|
||
|
||
-- care 表
|
||
ALTER TABLE public.ec_service_requests
|
||
ADD COLUMN IF NOT EXISTS elder_age INTEGER NOT NULL DEFAULT 0,
|
||
ADD COLUMN IF NOT EXISTS elder_gender TEXT NOT NULL DEFAULT '';
|
||
|
||
ALTER TABLE public.ec_care_tasks
|
||
ADD COLUMN IF NOT EXISTS elder_age INTEGER NOT NULL DEFAULT 0,
|
||
ADD COLUMN IF NOT EXISTS elder_gender TEXT NOT NULL DEFAULT '';
|
||
|
||
-- 旧订单表
|
||
ALTER TABLE public.hss_service_orders
|
||
ADD COLUMN IF NOT EXISTS recipient_age INTEGER NOT NULL DEFAULT 0,
|
||
ADD COLUMN IF NOT EXISTS recipient_gender TEXT NOT NULL DEFAULT '';
|