Changeset 11731


Ignore:
Timestamp:
2007/03/11 16:42:02 (17 years ago)
Author:
uehara
Message:
 
Location:
branches/dev/html/install/sql
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/html/install/sql/create_table_mysql.sql

    r11727 r11731  
    523523 
    524524CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); 
    525  
    526 CREATE TABLE dtb_customer_mail ( 
    527     email varchar(50) NOT NULL UNIQUE, 
    528     mail_flag smallint, 
    529     secret_key varchar(50) UNIQUE, 
    530     create_date datetime NOT NULL , 
    531     update_date datetime  
    532 ) TYPE=InnoDB ; 
    533525 
    534526CREATE TABLE dtb_customer_mail_temp ( 
  • branches/dev/html/install/sql/create_table_pgsql.sql

    r11727 r11731  
    523523 
    524524CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); 
    525  
    526 CREATE TABLE dtb_customer_mail ( 
    527     email text NOT NULL UNIQUE, 
    528     mail_flag int2, 
    529     secret_key text UNIQUE, 
    530     create_date timestamp NOT NULL DEFAULT now(), 
    531     update_date timestamp DEFAULT now() 
    532 ); 
    533  
    534525 
    535526CREATE TABLE dtb_customer_mail_temp ( 
Note: See TracChangeset for help on using the changeset viewer.