Changeset 11708

Timestamp:

2007/03/09 21:14:31 (17 years ago)

Author:

kakinaka

Message:

 

Location:

branches/dev/html/install/sql

Files:

• create_table_mysql.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (2 diffs)
• insert_data.sql (modified) (1 diff)

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

@@ -528 +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 TABLE dtb_customer_mail (
     email text NOT NULL UNIQUE,
@@ -529 +530 @@
 );
 
-CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);
 
 CREATE TABLE dtb_customer_mail_temp (

branches/dev/html/install/sql/insert_data.sql

@@ -3 +3 @@
 CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id);
 CREATE INDEX dtb_category_category_id_key ON dtb_category(category_id);
+CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);
 
 INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, create_date, update_date)