# use prod_ln_scene;

# 创建集合
db.createCollection("MerchantFieldsVo");
db.createCollection("MerchantFieldAppliesVo");
db.createCollection("MerchantFieldCheckersVo");
db.createCollection("MerchantSponsorsVo");
db.createCollection("MerchantSponsorAppliesVo");
db.createCollection("MerchantAuthorizationRecordsVo");
db.createCollection("MerchantAuthorizationPerformanceVo");


# 创建索引
db.MerchantFieldsVo.createIndex({fieldId:"hashed"});
db.MerchantFieldsVo.createIndex({isOnline:"hashed"});
db.MerchantFieldsVo.createIndex({uid:"hashed"});
db.MerchantFieldsVo.createIndex({companyId:"hashed"});
db.MerchantFieldAppliesVo.createIndex({fieldApplyId:"hashed"})
db.MerchantFieldAppliesVo.createIndex({fieldId:"hashed"});
db.MerchantFieldAppliesVo.createIndex({uid:"hashed"});
db.MerchantFieldCheckersVo.createIndex({fieldCheckerId:"hashed"});
db.MerchantFieldCheckersVo.createIndex({fieldId:"hashed"});
db.MerchantFieldCheckersVo.createIndex({uid:"hashed"});

db.MerchantSponsorsVo.createIndex({sponsorId:"hashed"});
db.MerchantSponsorsVo.createIndex({isOnline:"hashed"});
db.MerchantSponsorsVo.createIndex({uid:"hashed"});
db.MerchantSponsorsVo.createIndex({companyId:"hashed"});
db.MerchantSponsorAppliesVo.createIndex({sponsorApplyId:"hashed"});
db.MerchantSponsorAppliesVo.createIndex({sponsorId:"hashed"});
db.MerchantSponsorAppliesVo.createIndex({uid:"hashed"});

db.MerchantAuthorizationRecordsVo.createIndex({authorizationRecordId:"hashed"});
db.MerchantAuthorizationRecordsVo.createIndex({performanceId:"hashed"});
db.MerchantAuthorizationRecordsVo.createIndex({uidRole:"hashed"});
db.MerchantAuthorizationRecordsVo.createIndex({uid:"hashed"});
db.MerchantAuthorizationRecordsVo.createIndex({cuidRole:"hashed"});
db.MerchantAuthorizationRecordsVo.createIndex({cuid:"hashed"});

db.MerchantAuthorizationPerformanceVo.createIndex({performanceId:"hashed"});
db.MerchantAuthorizationPerformanceVo.createIndex({uid:"hashed"});
