Changeset 11716

Timestamp:

2007/03/09 21:45:11 (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) (1 diff)
• insert_data.sql (modified) (1 diff)

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

@@ -520 +520 @@
     mobile_phone_id text
 ) TYPE=InnoDB ;
+
+CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
 
 CREATE TABLE dtb_customer_mail (

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 (

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)