Changeset 22693


Ignore:
Timestamp:
2013/03/10 09:31:04 (8 years ago)
Author:
yomoro
Message:

インストール時にMySQLで問題が発生するため、若干調整

Location:
branches/camp/camp-2_13-tax/html/install/sql
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/camp/camp-2_13-tax/html/install/sql/create_table_mysql.sql

    r22671 r22693  
    12251225    tax_rate numeric NOT NULL DEFAULT 5, 
    12261226    tax_adjust numeric NOT NULL DEFAULT 0, 
    1227     apply_date timestamp, 
     1227    apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    12281228    member_id int NOT NULL, 
    12291229    del_flg smallint NOT NULL DEFAULT 0, 
    1230     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
     1230    create_date timestamp NOT NULL, 
    12311231    update_date timestamp NOT NULL, 
    12321232    PRIMARY KEY (tax_rule_id) 
    12331233); 
    1234  
    12351234 
    12361235CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(255)); 
  • branches/camp/camp-2_13-tax/html/install/sql/create_table_pgsql.sql

    r22671 r22693  
    12251225    tax_rate numeric NOT NULL DEFAULT 5, 
    12261226    tax_adjust numeric NOT NULL DEFAULT 0, 
    1227     apply_date timestamp, 
     1227    apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    12281228    member_id int NOT NULL, 
    12291229    del_flg smallint NOT NULL DEFAULT 0, 
    1230     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
     1230    create_date timestamp NOT NULL, 
    12311231    update_date timestamp NOT NULL, 
    12321232    PRIMARY KEY (tax_rule_id) 
    12331233); 
    1234  
    12351234 
    12361235CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); 
Note: See TracChangeset for help on using the changeset viewer.