Changeset 17760


Ignore:
Timestamp:
2009/02/07 13:57:16 (13 years ago)
Author:
Seasoft
Message:

dtb_csv の登録内容を「カテゴリ登録CSV」の列と一致させた。
※ create_date,update_date をセットしていないが、MySQL はそれで良いのか疑問あり。

File:
1 edited

Legend:

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

    r17673 r17760  
    222222INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_addr02','住所2',38,now(),now()); 
    223223INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'payment_total','お支払い合計',39,now(),now()); 
    224 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,status) VALUES (5,'category_id','カテゴリID',1,2); 
    225 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,status) VALUES (5,'category_name','カテゴリ名',2,2); 
    226 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,status) VALUES (5,'parent_category_id','親カテゴリID',3,2); 
     224INSERT INTO dtb_csv(csv_id,col,disp_name,rank) VALUES (5,'category_id','カテゴリID',1); 
     225INSERT INTO dtb_csv(csv_id,col,disp_name,rank) VALUES (5,'category_name','カテゴリ名',2); 
     226INSERT INTO dtb_csv(csv_id,col,disp_name,rank) VALUES (5,'parent_category_id','親カテゴリID',3); 
    227227INSERT INTO dtb_csv(csv_id,col,disp_name,status) VALUES (5,'level','階層',2); 
    228228INSERT INTO dtb_csv(csv_id,col,disp_name,status) VALUES (5,'rank','表示ランク',2); 
Note: See TracChangeset for help on using the changeset viewer.