Changeset 18786


Ignore:
Timestamp:
2010/08/18 12:42:44 (13 years ago)
Author:
nanasess
bzr:base-revision:
svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18785
bzr:committer:
Kentaro Ohkouchi <ohkouchi@loop-az.jp>
bzr:file-ids:

data/Smarty/templates/default/admin/contents/subnavi.tpl 15732@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2FSmarty%2Ftemplates%2Fdefault%2Fadmin%2Fcontents%2Fsubnavi.tpl
data/class/SC_CampaignSession.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_CampaignSession.php
html/install/index.php 16809@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Findex.php
html/install/sql/column_comment.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcolumn_comment.sql
html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
html/install/sql/drop_table.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_table.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql
html/install/sql/table_comment.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Ftable_comment.sql
bzr:mapping-version:
v4
bzr:merge:

ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
ohkouchi@loop-az.jp-20100818034225-loyoujma8pjbxn2u
bzr:revno:
2269
bzr:revprop:branch-nick:
branches/version-2_5-dev
bzr:root:
branches/version-2_5-dev
bzr:text-parents:

data/Smarty/templates/default/admin/contents/subnavi.tpl ohkouchi@loop-az.jp-20100614082324-fsyp4ss6t8s1l9hk
data/class/SC_CampaignSession.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
html/install/index.php ohkouchi@loop-az.jp-20100804045224-nsulc26bh1ttqfrb
html/install/sql/column_comment.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18777
html/install/sql/create_table_mysql.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18778
html/install/sql/create_table_pgsql.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18777
html/install/sql/drop_table.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18777
html/install/sql/insert_data.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18783
html/install/sql/table_comment.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/comu-ver2:18235
bzr:text-revisions:

data/Smarty/templates/default/admin/contents/subnavi.tpl ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
data/class/SC_CampaignSession.php ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/index.php ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/column_comment.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/drop_table.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/table_comment.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
bzr:timestamp:
2010-08-18 12:42:25.005000114 +0900
bzr:user-agent:
bzr2.1.2+bzr-svn1.0.2
svn:original-date:
2010-08-18T03:42:25.005000Z
Message:

非推奨機能の削除(#793)

  • キャンペーン機能
  • アンケート機能
  • html/test 以下の不要と思われるプログラム
  • 未使用テーブルの削除
    • dtb_user_regist
    • dtb_customer_mail_temp
    • dtb_mailmaga_template
    • mtb_srank
Location:
branches/version-2_5-dev
Files:
15 deleted
9 edited

Legend:

Unmodified
Added
Removed

  • branches/version-2_5-dev/data/Smarty/templates/default/admin/contents/subnavi.tpl

    r18700 r18786  
    2525<li<!--{if $tpl_subno == 'index'}--> class="on"<!--{/if}--> id="navi-contents-index"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/<!--{$smarty.const.DIR_INDEX_URL}-->"><span>新着情報管理</span></a></li> 
    2626<li<!--{if $tpl_subno == 'recommend'}--> class="on"<!--{/if}--> id="navi-contents-recommend"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/recommend.php"><span>おすすめ商品管理</span></a></li> 
    27 <li<!--{if $tpl_subno == 'inquiry'}--> class="on"<!--{/if}--> id="navi-contents-inquiry"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/inquiry.php"><span>アンケート管理</span></a></li> 
    28 <li<!--{if $tpl_subno == 'campaign'}--> class="on"<!--{/if}--> id="navi-contents-campaign"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/campaign.php"><span>キャンペーン管理</span></a></li> 
    2927<li<!--{if $tpl_subno == 'file'}--> class="on"<!--{/if}--> id="navi-contents-file"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/file_manager.php"><span>ファイル管理</span></a></li> 
    3028<li<!--{if $tpl_subno == 'csv'}--> class="on"<!--{/if}--> id="navi-contents-csv"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/csv.php"><span>CSV出力項目設定</span></a> 
    … …  
    3331  <li<!--{if $tpl_subno_csv == 'customer'}--> class="on"<!--{/if}--> id="navi-csv-customer"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/csv.php?tpl_subno_csv=customer"><span>顧客管理</span></a></li> 
    3432  <li<!--{if $tpl_subno_csv == 'order'}--> class="on"<!--{/if}--> id="navi-csv-order"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/csv.php?tpl_subno_csv=order"><span>受注管理</span></a></li> 
    35   <li<!--{if $tpl_subno_csv == 'campaign'}--> class="on"<!--{/if}--> id="navi-csv-campaign"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/csv.php?tpl_subno_csv=campaign"><span>キャンペーン</span></a></li> 
    3633  <li<!--{if $tpl_subno_csv == 'category'}--> class="on"<!--{/if}--> id="navi-csv-category"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/csv.php?tpl_subno_csv=category"><span>カテゴリ</span></a></li> 
    3734  <li<!--{if $tpl_subno_csv == 'csv_sql'}--> class="on"<!--{/if}--> id="navi-csv-sql"><a href="<!--{$smarty.const.URL_DIR}-->admin/contents/csv_sql.php"><span>高度な設定</span></a></li> 

  • branches/version-2_5-dev/data/class/SC_CampaignSession.php

    r18701 r18786  
    2222 */ 
    2323 
    24 /* キャンペーン管理クラス */ 
     24/* キャンペーン管理クラス  
     25 * 
     26 * @deprecated キャンペーン機能は廃止のため使用しない. 
     27 *             このクラスに依存している実装を改修後, このクラスを削除する. 
     28 */ 
    2529class SC_CampaignSession { 
    2630    var $key; 

  • branches/version-2_5-dev/html/install/index.php

    r18775 r18786  
    131131    $objPage->arrErr = lfAddTable("dtb_session", $dsn);         // セッション管理テーブル 
    132132    $objPage->arrErr = lfAddTable("dtb_module", $dsn);          // モジュール管理テーブル 
    133     $objPage->arrErr = lfAddTable("dtb_campaign_order", $dsn);  // キャンペーン受注テーブル 
    134133    $objPage->arrErr = lfAddTable("dtb_mobile_kara_mail", $dsn);    // 空メール管理テーブル 
    135134    $objPage->arrErr = lfAddTable("dtb_mobile_ext_session_id", $dsn);   // セッションID管理テーブル 
    … …  
    226225    lfDropTable("dtb_module", $dsn); 
    227226    lfDropTable("dtb_session", $dsn); 
    228     lfDropTable("dtb_campaign_order", $dsn); 
    229227    lfDropTable("dtb_mobile_ext_session_id", $dsn); 
    230228    lfDropTable("dtb_mobile_kara_mail", $dsn); 
    … …  
    898896    $objDb->sfColumnExists("dtb_order", "memo09", "text", $dsn, true); 
    899897    $objDb->sfColumnExists("dtb_order", "memo10", "text", $dsn, true); 
    900     $objDb->sfColumnExists("dtb_order", "campaign_id", "int4", $dsn, true); 
    901898 
    902899    // 受注一時テーブル 
    … …  
    930927    $objDb->sfColumnExists("dtb_payment", "memo10", "text", $dsn, true); 
    931928 
    932     // キャンペーンテーブル 
    933     $objDb->sfColumnExists("dtb_campaign", "directory_name", "text NOT NULL", $dsn, true); 
    934     $objDb->sfColumnExists("dtb_campaign", "limit_count", "int4 NOT NULL DEFAULT 0", $dsn, true); 
    935     $objDb->sfColumnExists("dtb_campaign", "total_count", "int4 NOT NULL DEFAULT 0", $dsn, true); 
    936     $objDb->sfColumnExists("dtb_campaign", "orverlapping_flg", "int2 NOT NULL DEFAULT 0", $dsn, true); 
    937     $objDb->sfColumnExists("dtb_campaign", "cart_flg", "int2 NOT NULL DEFAULT 0", $dsn, true); 
    938     $objDb->sfColumnExists("dtb_campaign", "deliv_free_flg", "int2 NOT NULL DEFAULT 0", $dsn, true); 
    939  
    940929    // 顧客 
    941930    $objDb->sfColumnExists("dtb_customer", "mailmaga_flg", "int2", $dsn, true); 
    … …  
    946935        $objDb->sfIndexExists("dtb_customer", "mobile_phone_id", "dtb_customer_mobile_phone_id_key", 64, $dsn, true); 
    947936    } 
    948  
    949     // 顧客メール 
    950     if ($objDBParam->getValue('db_type') == 'mysql') { 
    951         $objDb->sfColumnExists("dtb_customer_mail", "secret_key", "varchar(50) unique", $dsn, true); 
    952     } else { 
    953         $objDb->sfColumnExists("dtb_customer_mail", "secret_key", "text unique", $dsn, true); 
    954     } 
    955 } 
    956937 
    957938// データの追加（既にデータが存在する場合は作成しない） 
    … …  
    962943        lfInsertCSVData(1,'category_id','カテゴリID',53,'now()','now()', $dsn); 
    963944        lfInsertCSVData(4,'order_id','注文番号',1,'now()','now()', $dsn); 
    964         lfInsertCSVData(4,'campaign_id','キャンペーンID',2,'now()','now()', $dsn); 
    965945        lfInsertCSVData(4,'customer_id','顧客ID',3,'now()','now()', $dsn); 
    966946        lfInsertCSVData(4,'message','要望等',4,'now()','now()', $dsn); 

  • branches/version-2_5-dev/html/install/sql/column_comment.sql

    r18777 r18786  
    555555INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','create_date','作成日'); 
    556556INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','login_date','ログイン日'); 
    557 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question_id','質問ID'); 
    558 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question_name','質問名'); 
    559 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question','質問内容'); 
    560 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','create_date','作成日時'); 
    561 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','del_flg ','0:既定、1:削除'); 
    562 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','result_id','結果ID'); 
    563 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_id','質問ID'); 
    564 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_date','質問日'); 
    565 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_name','質問名'); 
    566 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','name01','回答者名'); 
    567 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','name02','回答者名'); 
    568 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','kana01','回答者名'); 
    569 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','kana02','回答者名'); 
    570 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','zip01','郵便番号1'); 
    571 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','zip02','郵便番号2'); 
    572 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','pref','都道府県'); 
    573 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','addr01','住所1'); 
    574 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','addr02','住所2'); 
    575 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel01','電話番号1'); 
    576 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel02','電話番号2'); 
    577 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel03','電話番号3'); 
    578 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','mail01','メールアドレス'); 
    579 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question01','回答内容'); 
    580 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question02','回答内容'); 
    581 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question03','回答内容'); 
    582 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question04','回答内容'); 
    583 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question05','回答内容'); 
    584 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question06','回答内容'); 
    585 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','create_date','作成日時'); 
    586 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','del_flg ','0:既定、1:削除'); 
    587557INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','product_id','この商品ID'); 
    588558INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','relate_product_id','こんな商品ID'); 
    589559INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','customer_id','顧客ID'); 
    590560INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','create_date','集計日時'); 
    591 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_id','キャンペーンID'); 
    592 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_name','キャンペーン名'); 
    593 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_point_rate','キャンペーンポイント'); 
    594 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_point_type','キャンペーンタイプ'); 
    595 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','start_date','キャンペーン開始期間'); 
    596 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','end_date','キャンペーン終了期間'); 
    597 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','search_condition','検索条件'); 
    598 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','del_flg','0:既定　1:削除'); 
    599 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','create_date','作成日時'); 
    600 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','update_date','更新日時'); 
    601 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','campaign_id','キャンペーンID'); 
    602 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','product_id','キャンペーン名'); 
    603 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','campaign_point_rate','キャンペーンポイント'); 
    604561INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','page_id','ページID 0はプレビュー用データ'); 
    605562INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','page_name','ページ名称'); 

  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r18778 r18786  
    228228) TYPE=InnoDB; 
    229229 
    230 CREATE TABLE dtb_mailmaga_template ( 
    231     template_id int auto_increment NOT NULL, 
    232     subject text, 
    233     charge_image text, 
    234     mail_method int, 
    235     header text, 
    236     body text, 
    237     main_title text, 
    238     main_comment text, 
    239     main_product_id int, 
    240     sub_title text, 
    241     sub_comment text, 
    242     sub_product_id01 int, 
    243     sub_product_id02 int, 
    244     sub_product_id03 int, 
    245     sub_product_id04 int, 
    246     sub_product_id05 int, 
    247     sub_product_id06 int, 
    248     sub_product_id07 int, 
    249     sub_product_id08 int, 
    250     sub_product_id09 int, 
    251     sub_product_id10 int, 
    252     sub_product_id11 int, 
    253     sub_product_id12 int, 
    254     del_flg smallint NOT NULL DEFAULT 0, 
    255     creator_id int NOT NULL, 
    256     create_date datetime NOT NULL, 
    257     update_date datetime, 
    258     PRIMARY KEY (template_id) 
    259 ) TYPE=InnoDB; 
    260  
    261230CREATE TABLE dtb_send_history ( 
    262231    send_id int auto_increment NOT NULL, 
    … …  
    595564 
    596565CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); 
    597  
    598 CREATE TABLE dtb_customer_mail_temp ( 
    599     email varchar(50) NOT NULL UNIQUE, 
    600     mail_flag smallint, 
    601     temp_id varchar(50) NOT NULL, 
    602     end_flag smallint, 
    603     update_date datetime NOT NULL, 
    604     create_data datetime NOT NULL, 
    605     PRIMARY KEY (temp_id) 
    606 ) TYPE=InnoDB; 
    607566 
    608567CREATE TABLE dtb_order ( 
    … …  
    685644    memo09 text, 
    686645    memo10 text, 
    687     campaign_id int, 
    688646    PRIMARY KEY (order_id) 
    689647) TYPE=InnoDB; 
    … …  
    829787) TYPE=InnoDB; 
    830788 
    831 CREATE TABLE dtb_question ( 
    832     question_id int auto_increment NOT NULL, 
    833     question_name text, 
    834     question text, 
    835     create_date datetime NOT NULL, 
    836     del_flg smallint NOT NULL DEFAULT 0, 
    837     PRIMARY KEY (question_id) 
    838 ) TYPE=InnoDB; 
    839  
    840 CREATE TABLE dtb_question_result ( 
    841     result_id int auto_increment NOT NULL, 
    842     question_id int NOT NULL, 
    843     question_date datetime, 
    844     question_name text, 
    845     name01 text, 
    846     name02 text, 
    847     kana01 text, 
    848     kana02 text, 
    849     zip01 text, 
    850     zip02 text, 
    851     pref smallint, 
    852     addr01 text, 
    853     addr02 text, 
    854     tel01 text, 
    855     tel02 text, 
    856     tel03 text, 
    857     mail01 text, 
    858     question01 text, 
    859     question02 text, 
    860     question03 text, 
    861     question04 text, 
    862     question05 text, 
    863     question06 text, 
    864     create_date datetime NOT NULL, 
    865     del_flg smallint NOT NULL DEFAULT 0, 
    866     PRIMARY KEY (result_id) 
    867 ) TYPE=InnoDB; 
    868  
    869789CREATE TABLE dtb_bat_relate_products ( 
    870790    product_id int, 
    … …  
    872792    customer_id int, 
    873793    create_date datetime 
    874 ) TYPE=InnoDB; 
    875  
    876 CREATE TABLE dtb_campaign ( 
    877     campaign_id int auto_increment NOT NULL, 
    878     campaign_name text, 
    879     campaign_point_rate numeric NOT NULL, 
    880     campaign_point_type smallint, 
    881     start_date datetime NOT NULL, 
    882     end_date datetime NOT NULL, 
    883     directory_name text NOT NULL, 
    884     limit_count int NOT NULL DEFAULT 0, 
    885     total_count int NOT NULL DEFAULT 0, 
    886     orverlapping_flg smallint NOT NULL DEFAULT 0, 
    887     cart_flg smallint NOT NULL DEFAULT 0, 
    888     deliv_free_flg smallint NOT NULL DEFAULT 0, 
    889     search_condition text, 
    890     del_flg smallint NOT NULL DEFAULT 0, 
    891     create_date datetime NOT NULL, 
    892     update_date datetime NOT NULL, 
    893     PRIMARY KEY (campaign_id) 
    894 ) TYPE=InnoDB; 
    895  
    896 CREATE TABLE dtb_campaign_detail ( 
    897     campaign_id int NOT NULL, 
    898     product_id int NOT NULL, 
    899     campaign_point_rate numeric NOT NULL 
    900794) TYPE=InnoDB; 
    901795 
    … …  
    962856) TYPE=InnoDB; 
    963857 
    964 CREATE TABLE dtb_user_regist ( 
    965     user_id int auto_increment NOT NULL, 
    966     org_name text, 
    967     post_name text, 
    968     name01 text, 
    969     name02 text, 
    970     kana01 text, 
    971     kana02 text, 
    972     email text NOT NULL, 
    973     url text, 
    974     note text, 
    975     secret_key varchar(50) NOT NULL UNIQUE, 
    976     status smallint NOT NULL, 
    977     del_flg smallint DEFAULT 0, 
    978     create_date datetime NOT NULL, 
    979     update_date datetime NOT NULL, 
    980     PRIMARY KEY (user_id) 
    981 ) TYPE=InnoDB; 
    982  
    983858CREATE TABLE dtb_templates 
    984859( 
    … …  
    1059934) TYPE=InnoDB; 
    1060935 
    1061 CREATE TABLE mtb_srank ( 
    1062     id smallint, 
    1063     name text, 
    1064     rank smallint NOT NULL DEFAULT 0, 
    1065     PRIMARY KEY (id) 
    1066 ) TYPE=InnoDB; 
    1067  
    1068936CREATE TABLE mtb_status ( 
    1069937    id smallint, 

  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r18777 r18786  
    228228); 
    229229 
    230 CREATE TABLE dtb_mailmaga_template ( 
    231     template_id serial NOT NULL, 
    232     subject text, 
    233     charge_image text, 
    234     mail_method int, 
    235     header text, 
    236     body text, 
    237     main_title text, 
    238     main_comment text, 
    239     main_product_id int, 
    240     sub_title text, 
    241     sub_comment text, 
    242     sub_product_id01 int, 
    243     sub_product_id02 int, 
    244     sub_product_id03 int, 
    245     sub_product_id04 int, 
    246     sub_product_id05 int, 
    247     sub_product_id06 int, 
    248     sub_product_id07 int, 
    249     sub_product_id08 int, 
    250     sub_product_id09 int, 
    251     sub_product_id10 int, 
    252     sub_product_id11 int, 
    253     sub_product_id12 int, 
    254     del_flg smallint NOT NULL DEFAULT 0, 
    255     creator_id int NOT NULL, 
    256     create_date timestamp NOT NULL DEFAULT now(), 
    257     update_date timestamp, 
    258     PRIMARY KEY (template_id) 
    259 ); 
    260  
    261230CREATE TABLE dtb_send_history ( 
    262231    send_id serial NOT NULL, 
    … …  
    596565 
    597566CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); 
    598  
    599 CREATE TABLE dtb_customer_mail_temp ( 
    600     email text NOT NULL UNIQUE, 
    601     mail_flag smallint, 
    602     temp_id text NOT NULL, 
    603     end_flag smallint, 
    604     update_date timestamp NOT NULL DEFAULT Now(), 
    605     create_data timestamp NOT NULL DEFAULT Now(), 
    606     PRIMARY KEY (temp_id) 
    607 ); 
    608567 
    609568CREATE TABLE dtb_order ( 
    … …  
    686645    memo09 text, 
    687646    memo10 text, 
    688     campaign_id int, 
    689647    PRIMARY KEY (order_id) 
    690648); 
    … …  
    830788); 
    831789 
    832 CREATE TABLE dtb_question ( 
    833     question_id serial NOT NULL, 
    834     question_name text, 
    835     question text, 
    836     create_date timestamp NOT NULL DEFAULT now(), 
    837     del_flg smallint NOT NULL DEFAULT 0, 
    838     PRIMARY KEY (question_id) 
    839 ); 
    840  
    841 CREATE TABLE dtb_question_result ( 
    842     result_id serial NOT NULL, 
    843     question_id int NOT NULL, 
    844     question_date timestamp, 
    845     question_name text, 
    846     name01 text, 
    847     name02 text, 
    848     kana01 text, 
    849     kana02 text, 
    850     zip01 text, 
    851     zip02 text, 
    852     pref smallint, 
    853     addr01 text, 
    854     addr02 text, 
    855     tel01 text, 
    856     tel02 text, 
    857     tel03 text, 
    858     mail01 text, 
    859     question01 text, 
    860     question02 text, 
    861     question03 text, 
    862     question04 text, 
    863     question05 text, 
    864     question06 text, 
    865     create_date timestamp NOT NULL DEFAULT now(), 
    866     del_flg smallint NOT NULL DEFAULT 0, 
    867     PRIMARY KEY (result_id) 
    868 ); 
    869  
    870790CREATE TABLE dtb_bat_relate_products ( 
    871791    product_id int, 
    … …  
    873793    customer_id int, 
    874794    create_date timestamp DEFAULT now() 
    875 ); 
    876  
    877 CREATE TABLE dtb_campaign ( 
    878     campaign_id serial NOT NULL, 
    879     campaign_name text, 
    880     campaign_point_rate numeric NOT NULL, 
    881     campaign_point_type smallint, 
    882     start_date timestamp NOT NULL, 
    883     end_date timestamp NOT NULL, 
    884     directory_name text NOT NULL, 
    885     limit_count int NOT NULL DEFAULT 0, 
    886     total_count int NOT NULL DEFAULT 0, 
    887     orverlapping_flg smallint NOT NULL DEFAULT 0, 
    888     cart_flg smallint NOT NULL DEFAULT 0, 
    889     deliv_free_flg smallint NOT NULL DEFAULT 0, 
    890     search_condition text, 
    891     del_flg smallint NOT NULL DEFAULT 0, 
    892     create_date timestamp NOT NULL, 
    893     update_date timestamp NOT NULL DEFAULT now(), 
    894     PRIMARY KEY (campaign_id) 
    895 ); 
    896  
    897 CREATE TABLE dtb_campaign_detail ( 
    898     campaign_id int NOT NULL, 
    899     product_id int NOT NULL, 
    900     campaign_point_rate numeric NOT NULL 
    901795); 
    902796 
    … …  
    963857); 
    964858 
    965 CREATE TABLE dtb_user_regist ( 
    966     user_id serial NOT NULL, 
    967     org_name text, 
    968     post_name text, 
    969     name01 text, 
    970     name02 text, 
    971     kana01 text, 
    972     kana02 text, 
    973     email text NOT NULL, 
    974     url text, 
    975     note text, 
    976     secret_key text NOT NULL UNIQUE, 
    977     status smallint NOT NULL, 
    978     del_flg smallint DEFAULT 0, 
    979     create_date timestamp NOT NULL, 
    980     update_date timestamp NOT NULL DEFAULT now(), 
    981     PRIMARY KEY (user_id) 
    982 ); 
    983  
    984859create table dtb_templates ( 
    985860    template_code text NOT NULL, 
    … …  
    1057932); 
    1058933 
    1059 CREATE TABLE mtb_srank ( 
    1060     id smallint, 
    1061     name text, 
    1062     rank smallint NOT NULL DEFAULT 0, 
    1063     PRIMARY KEY (id) 
    1064 ); 
    1065  
    1066934CREATE TABLE mtb_status ( 
    1067935    id smallint, 

  • branches/version-2_5-dev/html/install/sql/drop_table.sql

    r18777 r18786  
    99DROP TABLE dtb_payment; 
    1010DROP TABLE dtb_mailtemplate; 
    11 DROP TABLE dtb_mailmaga_template; 
    1211DROP TABLE dtb_send_history; 
    1312DROP TABLE dtb_send_customer; 
    … …  
    2928DROP TABLE dtb_mail_history; 
    3029DROP TABLE dtb_customer; 
    31 DROP TABLE dtb_customer_mail; 
    32 DROP TABLE dtb_customer_mail_temp; 
    3330DROP TABLE dtb_order; 
    3431DROP TABLE dtb_order_temp; 
    … …  
    3734DROP TABLE mtb_pref; 
    3835DROP TABLE dtb_member; 
    39 DROP TABLE dtb_question; 
    40 DROP TABLE dtb_question_result; 
    4136DROP TABLE dtb_bat_relate_products; 
    42 DROP TABLE dtb_campaign; 
    43 DROP TABLE dtb_campaign_detail; 
    4437DROP TABLE dtb_pagelayout; 
    4538DROP TABLE dtb_bloc; 
    … …  
    4740DROP TABLE dtb_csv; 
    4841DROP TABLE dtb_csv_sql; 
    49 DROP TABLE dtb_user_regist; 
    5042DROP TABLE dtb_templates; 
    5143DROP TABLE dtb_table_comment; 
    … …  
    5951DROP TABLE mtb_status_image; 
    6052DROP TABLE mtb_status; 
    61 DROP TABLE mtb_srank; 
    6253DROP TABLE mtb_site_control_track_back; 
    6354DROP TABLE mtb_site_control_affiliate; 

  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r18783 r18786  
    566566INSERT INTO mtb_class VALUES ('1', '規格無し',0); 
    567567INSERT INTO mtb_class VALUES ('2', '規格有り',1); 
    568 INSERT INTO mtb_srank VALUES ('1', '1',0); 
    569 INSERT INTO mtb_srank VALUES ('2', '2',1); 
    570 INSERT INTO mtb_srank VALUES ('3', '3',2); 
    571 INSERT INTO mtb_srank VALUES ('4', '4',3); 
    572 INSERT INTO mtb_srank VALUES ('5', '5',4); 
    573568INSERT INTO mtb_status VALUES ('1', 'NEW',0); 
    574569INSERT INTO mtb_status VALUES ('2', '残りわずか',1); 

  • branches/version-2_5-dev/html/install/sql/table_comment.sql

    r18235 r18786  
    3333INSERT INTO dtb_table_comment(table_name,description) values ('mtb_pref','都道府県ﾏｽﾀ'); 
    3434INSERT INTO dtb_table_comment(table_name,description) values ('dtb_member','管理者'); 
    35 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_question','質問'); 
    36 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_question_result','質問結果'); 
    3735INSERT INTO dtb_table_comment(table_name,description) values ('dtb_bat_relate_products','こんな商品も買っています'); 
    38 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_campaign','キャンペーン'); 
    39 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_campaign_detail','キャンペーン詳細'); 
    4036INSERT INTO dtb_table_comment(table_name,description) values ('dtb_pagelayout','ページレイアウト'); 
    4137INSERT INTO dtb_table_comment(table_name,description) values ('dtb_bloc','ブロック'); 
Note: See TracChangeset for help on using the changeset viewer.