Changes between Version 6 and Version 7 of Ticket #101


Ignore:
Timestamp:
04/23/2012 02:03:39 PM (14 years ago)
Author:
chenchongqi
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #101 – Description

    v6 v7  
    4848 
    4949}}} 
     50 
     51ent_company_product_line 
     52{{{ 
     53-- Table: ent_company_product_line 
     54 
     55-- DROP TABLE ent_company_product_line; 
     56 
     57CREATE TABLE ent_company_product_line 
     58( 
     59  company_id bigint, 
     60  big_type_id bigint, 
     61  small_type_id bigint, 
     62  brand_id bigint, 
     63  last_update_date timestamp without time zone 
     64) 
     65WITH ( 
     66  OIDS=FALSE 
     67); 
     68ALTER TABLE ent_company_product_line 
     69  OWNER TO cyp_nw_app; 
     70COMMENT ON TABLE ent_company_product_line 
     71  IS '商家和产品线关系表'; 
     72 
     73-- Index: idx_company_product_line 
     74 
     75-- DROP INDEX idx_company_product_line; 
     76 
     77CREATE INDEX idx_company_product_line 
     78  ON ent_company_product_line 
     79  USING btree 
     80  (company_id , big_type_id , small_type_id , brand_id ); 
     81}}}