source: branches/version-2_5-dev/html/install/sql/drop_table.sql @ 18815

Revision 18815, 2.7 KB checked in by nanasess, 14 years ago (diff)

規格まわりの内部構成変更に伴う修正(#781)

  • 規格のデータ構造を木構造へ変更
  • 商品検索ロジックを SC_Product クラスへできるだけ集約
  • 以下の VIEW を削除
    • vw_category_count;
    • vw_product_class;
    • vw_products_nonclass;
    • vw_cross_products_class;
    • vw_cross_class;
    • vw_download_class;
  • Property svn:eol-style set to LF
  • Property svn:mime-type set to text/plain; charset=utf-8
Line 
1DROP TABLE dtb_kiyaku;
2DROP TABLE mtb_zip;
3DROP TABLE dtb_bat_order_daily_age;
4DROP TABLE dtb_update;
5DROP TABLE dtb_baseinfo;
6DROP TABLE dtb_deliv;
7DROP TABLE dtb_delivtime;
8DROP TABLE dtb_delivfee;
9DROP TABLE dtb_payment;
10DROP TABLE dtb_mailtemplate;
11DROP TABLE dtb_send_history;
12DROP TABLE dtb_send_customer;
13DROP TABLE dtb_products;
14DROP TABLE dtb_products_class;
15DROP TABLE dtb_product_status;
16DROP TABLE dtb_class;
17DROP TABLE dtb_classcategory;
18DROP TABLE dtb_class_combination;
19DROP TABLE dtb_category;
20DROP TABLE dtb_product_categories;
21DROP TABLE dtb_bat_order_daily;
22DROP TABLE dtb_bat_order_daily_hour;
23DROP TABLE dtb_recommend_products;
24DROP TABLE dtb_review;
25DROP TABLE dtb_customer_reading;
26DROP TABLE dtb_category_count;
27DROP TABLE dtb_category_total_count;
28DROP TABLE dtb_news;
29DROP TABLE dtb_best_products;
30DROP TABLE dtb_mail_history;
31DROP TABLE dtb_customer;
32DROP TABLE dtb_order;
33DROP TABLE dtb_order_temp;
34DROP TABLE dtb_other_deliv;
35DROP TABLE dtb_order_detail;
36DROP TABLE mtb_pref;
37DROP TABLE dtb_member;
38DROP TABLE dtb_bat_relate_products;
39DROP TABLE dtb_pagelayout;
40DROP TABLE dtb_bloc;
41DROP TABLE dtb_blocposition;
42DROP TABLE dtb_csv;
43DROP TABLE dtb_csv_sql;
44DROP TABLE dtb_templates;
45DROP TABLE dtb_table_comment;
46DROP TABLE dtb_ownersstore_settings;
47DROP TABLE dtb_module_update_logs;
48DROP TABLE mtb_work;
49DROP TABLE mtb_wday;
50DROP TABLE mtb_track_back_status;
51DROP TABLE mtb_taxrule;
52DROP TABLE mtb_target;
53DROP TABLE mtb_status_image;
54DROP TABLE mtb_status;
55DROP TABLE mtb_site_control_track_back;
56DROP TABLE mtb_site_control_affiliate;
57DROP TABLE mtb_sex;
58DROP TABLE mtb_review_deny_url;
59DROP TABLE mtb_reminder;
60DROP TABLE mtb_recommend;
61DROP TABLE mtb_product_status_color;
62DROP TABLE mtb_product_list_max;
63DROP TABLE mtb_permission;
64DROP TABLE mtb_page_rows;
65DROP TABLE mtb_page_max;
66DROP TABLE mtb_order_status_color;
67DROP TABLE mtb_order_status;
68DROP TABLE mtb_mail_type;
69DROP TABLE mtb_mail_tpl_path;
70DROP TABLE mtb_mail_template;
71DROP TABLE mtb_mail_magazine_type;
72DROP TABLE mtb_magazine_type;
73DROP TABLE mtb_mobile_domain;
74DROP TABLE mtb_job;
75DROP TABLE mtb_disp;
76DROP TABLE mtb_disable_logout;
77DROP TABLE mtb_delivery_date;
78DROP TABLE mtb_db;
79DROP TABLE mtb_convenience;
80DROP TABLE mtb_conveni_message;
81DROP TABLE mtb_constants;
82DROP TABLE mtb_class;
83DROP TABLE mtb_authority;
84DROP TABLE mtb_allowed_tag;
85DROP TABLE mtb_ownersstore_err;
86DROP TABLE mtb_ownersstore_ips;
87DROP TABLE dtb_maker;
88DROP TABLE dtb_maker_count;
89DROP TABLE dtb_holiday;
90DROP TABLE dtb_customer_favorite_products;
91DROP TABLE mtb_down;
92DROP TABLE dtb_module;
93DROP TABLE dtb_session;
94DROP TABLE dtb_mobile_ext_session_id;
95DROP TABLE dtb_mobile_kara_mail;
96DROP TABLE dtb_site_control;
97DROP TABLE dtb_trackback;
98DROP TABLE dtb_bkup;
Note: See TracBrowser for help on using the repository browser.