Changeset 17268


Ignore:
Timestamp:
2008/04/18 09:45:52 (13 years ago)
Author:
miningbrownie
Message:

MySQL用のメーカテーブルにて
MySQLでDEFAULT NOW()は使用できないのでDEFAULT句を削除
dtb_customer_favorite_productsのSQL文法エラー修正
dtb_maker,dtb_maker_count,dtb_customer_favorite_products
のDROPが無かったので追加

Location:
branches/comu-ver2/html/install/sql
Files:
2 edited

Legend:

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

    r17263 r17268  
    468468    product_id int NOT NULL, 
    469469    create_date datetime NOT NULL, 
    470     update_date datetime NOT NULL, 
     470    update_date datetime NOT NULL 
    471471) TYPE=InnoDB ; 
    472472 
     
    953953 
    954954CREATE TABLE dtb_maker ( 
    955     maker_id auto_increment primary keyl, 
     955    maker_id INT auto_increment primary key, 
    956956    name text NOT NULL, 
    957957    rank int NOT NULL DEFAULT 0, 
    958958    creator_id int NOT NULL, 
    959     create_date datetime NOT NULL DEFAULT now(), 
     959    create_date datetime NOT NULL, 
    960960    update_date datetime NOT NULL, 
    961961    del_flg  smallint NOT NULL DEFAULT 0 
     
    965965    maker_id int NOT NULL, 
    966966    product_count int NOT NULL, 
    967     create_date datetime NOT NULL DEFAULT Now() 
     967    create_date datetime NOT NULL 
    968968) TYPE=InnoDB ; 
    969969 
  • branches/comu-ver2/html/install/sql/drop_table.sql

    r17087 r17268  
    9292DROP TABLE mtb_ownersstore_err; 
    9393DROP TABLE mtb_ownersstore_ips; 
     94DROP TABLE dtb_maker; 
     95DROP TABLE dtb_maker_count; 
    9496DROP TABLE dtb_holiday; 
     97DROP TABLE dtb_customer_favorite_products; 
Note: See TracChangeset for help on using the changeset viewer.