Ignore:
Timestamp:
2010/08/18 12:42:44 (14 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
File:
1 edited

Legend:

Unmodified
Added
Removed

  • 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, 
Note: See TracChangeset for help on using the changeset viewer.