yii Ecommerce 表索引 index

索引操作：http://www.cnblogs.com/IT-Monkey/p/3293131.html
创建索引：

create index customer_id on sales_flat_quote (customer_id);

查看索引：

show index from sales_flat_quote; 

1.sales_flat_quote:
customer_id
customer_email

create index customer_id on sales_flat_quote (customer_id);
create index customer_email on sales_flat_quote (customer_email);

2.sales_flat_quote_item:
quote_id  sku  custom_option 这个没有必要添加联合索引
quote_id

create index quote_id on sales_flat_quote_item (quote_id);

3.sales_flat_order:
customer_id

create index customer_id on sales_flat_order (customer_id);

4.sales_flat_order_item:
order_id

create index order_id on sales_flat_order_item (order_id);

5.sales_coupon:
coupon_code

create index coupon_code on sales_coupon (coupon_code);

6.sales_coupon_usage:
coupon_id
customer_id

create index coupon_id on sales_coupon_usage (coupon_id);
create index customer_id on sales_coupon_usage (customer_id);

Mongodb:


catalog_product:

sku,      (Unique)
url_key   (Unique)
url_path   (Unique)
filter_final_price  

//数组：filter_color  filter_size
//filter_color_key   filter_size_key



catalog_category:

url_key  (Unique)
url_path (Unique)

catalog_category_product:

category_id
product_id

customer_accout:

email (Unique)

customer_address:

customer_id

customer_favorite:

email
sku

~~~~~~~~~~
customer_account_getpassword：

email

blog_category :

url_key (Unique)
url_path(Unique)

blog_article:

category
url_key (Unique)
url_path(Unique)

blog_comment:

article_id

ids

name (Unique)

newsletter_subscriber

subscriber_email

system_config_data:

handle (Unique)

url_rewrite:

request_path  (Unique)