// MongoDB初始化脚本
db = db.getSiblingDB('ecommerce_dev');

// 创建用户
db.createUser({
  user: 'ecommerce_user',
  pwd: 'ecommerce_pass',
  roles: [
    {
      role: 'readWrite',
      db: 'ecommerce_dev',
    },
  ],
});

// 创建基础集合
db.createCollection('_User');
db.createCollection('Product');
db.createCollection('Category');
db.createCollection('Order');
db.createCollection('ChatSession');

// 创建索引
db._User.createIndex({ username: 1 }, { unique: true });
db._User.createIndex({ email: 1 }, { unique: true });
db._User.createIndex({ phone: 1 }, { unique: true, sparse: true });

db.Product.createIndex({ name: 1 });
db.Product.createIndex({ category: 1, status: 1, createdAt: -1 });
db.Product.createIndex({ seller: 1 });

db.Order.createIndex({ orderNo: 1 }, { unique: true });
db.Order.createIndex({ user: 1, createdAt: -1 });
db.Order.createIndex({ status: 1, createdAt: -1 });

db.Category.createIndex({ name: 1 });
db.Category.createIndex({ parent: 1 });

print('MongoDB initialization completed');