Changes between Version 5 and Version 6 of Ticket #101


Ignore:
Timestamp:
04/23/2012 11:52:55 AM (14 years ago)
Author:
chenchongqi
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #101 – Description

    v5 v6  
    23231： 
    2424ent_company.TYPE<>Company.TYPE_STORE(<>3,非网店)  AND ent_company.VIP_RANK> Company.VIP_RANK_FREE(>0,非免费商家)  AND ent_company.STATUS>=Company.STATUS_NO_AUDIT(>=0,非禁用或者删除商家)'; 
     25 
     26-- Index: idx_company_id_recommend_status 
     27 
     28-- DROP INDEX idx_company_id_recommend_status; 
     29 
     30CREATE INDEX idx_company_id_recommend_status 
     31  ON ent_company_business_status 
     32  USING btree 
     33  (company_id , recommend_status ); 
    2534}}} 
    2635