Changeset 18061


Ignore:
Timestamp:
2009/06/09 12:20:16 (15 years ago)
Author:
Seasoft
Message:

merge r17812
・取得元: version-2_4
【取得元のログメッセージ】

  • MySQLで正常にinsert分が実行できない部分を改修(デフォルト指定がきかないため)
File:
1 edited

Legend:

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

    r18023 r18061  
    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) VALUES (5,'category_id','カテゴリID',1); 
    225 INSERT INTO dtb_csv(csv_id,col,disp_name,rank) VALUES (5,'category_name','カテゴリ名',2); 
    226 INSERT INTO dtb_csv(csv_id,col,disp_name,rank) VALUES (5,'parent_category_id','親カテゴリID',3); 
    227 INSERT INTO dtb_csv(csv_id,col,disp_name,status) VALUES (5,'level','階層',2); 
    228 INSERT INTO dtb_csv(csv_id,col,disp_name,status) VALUES (5,'rank','表示ランク',2); 
     224INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (5,'category_id','カテゴリID',1,now(),now()); 
     225INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (5,'category_name','カテゴリ名',2,now(),now()); 
     226INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (5,'parent_category_id','親カテゴリID',3,now(),now()); 
     227INSERT INTO dtb_csv(csv_id,col,disp_name,status,create_date,update_date) VALUES (5,'level','階層',2,now(),now()); 
     228INSERT INTO dtb_csv(csv_id,col,disp_name,status,create_date,update_date) VALUES (5,'rank','表示ランク',2,now(),now()); 
    229229 
    230230INSERT INTO dtb_templates (template_code, template_name, create_date, update_date) VALUES ('default','デフォルト', now(), now()); 
Note: See TracChangeset for help on using the changeset viewer.