Changeset 11731
- Timestamp:
- 2007/03/11 16:42:02 (17 years ago)
- Location:
- branches/dev/html/install/sql
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/install/sql/create_table_mysql.sql
r11727 r11731 523 523 524 524 CREATE 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 datetime532 ) TYPE=InnoDB ;533 525 534 526 CREATE TABLE dtb_customer_mail_temp ( -
branches/dev/html/install/sql/create_table_pgsql.sql
r11727 r11731 523 523 524 524 CREATE 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 534 525 535 526 CREATE TABLE dtb_customer_mail_temp (
Note: See TracChangeset
for help on using the changeset viewer.