17 lines
534 B
SQL
17 lines
534 B
SQL
-- V1 helper: insert a KOL profile manually.
|
|
-- Usage:
|
|
-- PGPASSWORD=geo_dev psql -h localhost -U geo -d geo \
|
|
-- -v tenant_id=1 -v user_id=5 -v display_name="'测试 KOL'" -v bio="'家具行业专家'" \
|
|
-- -f server/scripts/seed_kol_profile.sql
|
|
INSERT INTO kol_profiles (tenant_id, user_id, display_name, bio, market_enabled, status)
|
|
VALUES (
|
|
:tenant_id::bigint,
|
|
:user_id::bigint,
|
|
:display_name,
|
|
:bio,
|
|
TRUE,
|
|
'active'
|
|
)
|
|
ON CONFLICT DO NOTHING
|
|
RETURNING id, tenant_id, user_id, display_name, status;
|