13 lines
382 B
SQL
13 lines
382 B
SQL
-- migrate:up
|
|
|
|
-- Agregar campo para distinguir adulto/niño
|
|
alter table reco_rule_items
|
|
add column if not exists audience_type text not null default 'adult';
|
|
|
|
-- Valores válidos: 'adult', 'child', 'all'
|
|
comment on column reco_rule_items.audience_type is 'Tipo de audiencia: adult, child, all';
|
|
|
|
-- migrate:down
|
|
alter table reco_rule_items
|
|
drop column if exists audience_type;
|