// 公司媒体资源库 collection（MongoDB）—— 由 media-library-schema 生成，未来建库直接执行
db.createCollection('media_library');

db.media_library.createIndex({"platform":1,"blogger_id":1}, {"name":"uk_blogger_id","unique":true});
db.media_library.createIndex({"platform":1,"fans_count":-1}, {"name":"idx_platform_fans_desc"});
db.media_library.createIndex({"platform":1,"tier":1,"fans_count":-1}, {"name":"idx_platform_tier"});
db.media_library.createIndex({"platform":1,"tax_inclusive_price":1}, {"name":"idx_platform_price_asc"});
db.media_library.createIndex({"platform":1,"interaction_rate":-1}, {"name":"idx_platform_interaction_desc"});
db.media_library.createIndex({"platform":1,"verticality":-1}, {"name":"idx_platform_verticality"});
db.media_library.createIndex({"platform":1,"cpe":1,"cpv":1}, {"name":"idx_platform_cpe_asc"});

// 必填字段（缺一不可，对应模板「*」标记）：
// platform, content_type, nickname, fans_count, homepage_url, quote_url, fans_profile, tax_inclusive_price