Changeset 19336
- Timestamp:
- 2010/11/07 01:27:29 (13 years ago)
- Location:
- branches/camp/camp-2_5-D/html/install/sql
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/camp/camp-2_5-D/html/install/sql/create_table_pgsql.sql
r18882 r19336 1248 1248 ); 1249 1249 1250 CREATE TABLE dtb_index_list( 1251 table_name text NOT NULL DEFAULT '', 1252 column_name text NOT NULL DEFAULT '', 1253 recommend_flg int2 NOT NULL DEFAULT 0, 1254 recommend_comment text 1255 ); 1256 1250 1257 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); 1251 1258 CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id); -
branches/camp/camp-2_5-D/html/install/sql/drop_table.sql
r18882 r19336 97 97 DROP TABLE dtb_trackback; 98 98 DROP TABLE dtb_bkup; 99 DROP TABLE dtb_index_list; -
branches/camp/camp-2_5-D/html/install/sql/insert_data.sql
r18990 r19336 1085 1085 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PAGE_DISPLAY_TIME_LOG_MIN_EXEC_TIME', '2', 905, 'ページ表示時間のログを取得する時間設定(設定値以上かかった場合に取得)'); 1086 1086 1087 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_customer', 'email_mobile', 0, '会員数増加時のログイン処理速度を向上させたいときに試してみてください'); 1088 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_products', 'name', 1, '商品名検索速度を向上させたいときに試してみてください'); 1089 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_order_temp', 'order_temp_id', 0, '注文数が多いときに試してみてください。'); 1090 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_order', 'status', 1, '注文数が多いときに試してみてください。'); 1091 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_order', 'order_email', 1, '注文数が多いときに試してみてください。'); 1092 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_order', 'order_name01', 1, '注文数が多いときに試してみてください。'); 1093 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_order', 'order_name02', 0, '注文数が多いときに試してみてください。'); 1094 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_order', 'order_tel01', 0, '注文数が多いときに試してみてください。'); 1095 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_order', 'order_tel02', 0, '注文数が多いときに試してみてください。'); 1096 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_order', 'order_tel03', 0, '注文数が多いときに試してみてください。');
Note: See TracChangeset
for help on using the changeset viewer.