Context Navigation

Changes between Version 7 and Version 8 of Ticket #101

-                      v7
+                      v8
   (company_id , big_type_id , small_type_id , brand_id );
 }}}
+定时任务
+{{{
+insert into ent_company_product_line(company_id,brand_id,small_type_id, big_type_id, last_update_date)
+select distinct a.user_id as company_id, a.type_id as brand_id, b.parent_id as small_type_id, c.parent_id as big_type_id, now()
+from ent_product a,v_pdl_product_type b, v_pdl_product_type c
+where a.type_id = b.id and b.parent_id = c.id and not exists (
+select z.company_id from ent_company_product_line z
+where z.company_id = a.user_id and z.brand_id = a.type_id and z.small_type_id = c.id and z.big_type_id = c.parent_id
+)
+}}}