Ignore:
Timestamp:
2008/04/16 20:13:17 (14 years ago)
Author:
Yammy
Message:

メーカー検索機能
http://svn.ec-cube.net/open_trac/ticket/273
実装

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/comu-ver2/html/install/sql/create_table_pgsql.sql

    r17162 r17263  
    275275    sale_unlimited int2 DEFAULT 0, 
    276276    category_id int4, 
     277    maker_id int4, 
    277278    rank int4, 
    278279    status int2 NOT NULL DEFAULT 2, 
     
    953954); 
    954955 
     956CREATE TABLE dtb_maker ( 
     957    maker_id serial NOT NULL, 
     958    name text NOT NULL, 
     959    rank int4 NOT NULL DEFAULT 0, 
     960    creator_id int4 NOT NULL, 
     961    create_date timestamp NOT NULL DEFAULT now(), 
     962    update_date timestamp NOT NULL, 
     963    del_flg  int2 NOT NULL DEFAULT 0 
     964); 
     965 
     966CREATE TABLE dtb_maker_count ( 
     967    maker_id int4 NOT NULL, 
     968    product_count int4 NOT NULL, 
     969    create_date timestamp NOT NULL DEFAULT Now() 
     970); 
     971 
    955972CREATE TABLE mtb_permission ( 
    956973    id text, 
Note: See TracChangeset for help on using the changeset viewer.