Changeset 19369


Ignore:
Timestamp:
2010/11/07 02:13:42 (12 years ago)
Author:
fukuda
Message:

index管理用テーブルの生成・削除SQL追加

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/camp/camp-2_5-D/html/install/sql/create_table_mysql.sql

    r18882 r19369  
    12491249) TYPE=InnoDB; 
    12501250 
     1251CREATE TABLE dtb_index_list( 
     1252    table_name text NOT NULL DEFAULT '', 
     1253    column_name text NOT NULL DEFAULT '', 
     1254    recommend_flg int2 NOT NULL DEFAULT 0, 
     1255    recommend_comment text 
     1256) TYPE=InnoDB;; 
     1257 
    12511258CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); 
    12521259CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id); 
Note: See TracChangeset for help on using the changeset viewer.