Changeset 11706 for branches/dev/html

Timestamp:

2007/03/09 21:04:22 (19 years ago)

Author:

kakinaka

Message:

 

Location:

branches/dev/html/install/sql

Files:

• create_table_mysql.sql (modified) (2 diffs)
• create_table_pgsql.sql (modified) (2 diffs)

branches/dev/html/install/sql/create_table_mysql.sql

@@ -521 +521 @@
 ) TYPE=InnoDB ;
 
-CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
-
 CREATE TABLE dtb_customer_mail (
     email varchar(50) NOT NULL UNIQUE,
@@ -530 +528 @@
     update_date datetime 
 ) TYPE=InnoDB ;
+
+CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
 
 CREATE TABLE dtb_customer_mail_temp (

branches/dev/html/install/sql/create_table_pgsql.sql

@@ -521 +521 @@
 );
 
-CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);
-
 CREATE TABLE dtb_customer_mail (
     email text NOT NULL UNIQUE,
@@ -530 +528 @@
     update_date timestamp DEFAULT now()
 );
+
+CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);
 
 CREATE TABLE dtb_customer_mail_temp (