Ignore:
Timestamp:
2011/01/30 18:38:52 (11 years ago)
Author:
Seasoft
Message:

#869(create_date, update_date 列の定義が、表やDBによるバラツキがある) 実装漏れ対応

Location:
branches/version-2_5-dev/html/install/sql
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r19986 r20051  
    12141214    param_value text, 
    12151215    url text, 
    1216     create_date timestamp NOT NULL DEFAULT now() 
     1216    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 
    12171217); 
    12181218 
     
    12221222    token text NOT NULL, 
    12231223    next_url text NOT NULL, 
    1224     create_date timestamp NOT NULL DEFAULT now(), 
     1224    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    12251225    email text, 
    12261226    receive_date timestamp 
  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r19986 r20051  
    739739    rank int, 
    740740    create_date timestamp NOT NULL DEFAULT now(), 
    741     update_date timestamp, 
     741    update_date timestamp NOT NULL, 
    742742    del_flg smallint NOT NULL DEFAULT 0, 
    743743    PRIMARY KEY (shipping_id, order_id) 
Note: See TracChangeset for help on using the changeset viewer.