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

Revision 18791, 2.6 KB checked in by nanasess, 12 years ago (diff)

DB_TYPE で条件分岐している箇所の抽象化(#801)

  • SC_Helper_CSV
    • convert を mb_convert_kana_option へ変更
    • PEAR::DB の定数を MDB2 の定数へ修正
  • LC_Page_Admin_System_Bkup
    • DB_TYPE を使用している箇所を抽象化
    • シーケンス値バックアップファイルのフォーマット変更
  • html/install/index.php
    • 管理ユーザーの追加ができなくなっていたのを修正
  • html/install/sql/create_table_mysql.sql, html/install/sql/create_table_pgsql.sql
    • dtb_csv.convert を dtb_csv.mb_convert_kana_option へ変更
    • dtb_bkup を追加
  • html/install/sql/drop_table.sql
    • dtb_bkup を追加
  • html/install/sql/insert_data.sql
    • NOT NULL のフィールドが空文字にならないよう修正
  • 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_class;
16DROP TABLE dtb_classcategory;
17DROP TABLE dtb_category;
18DROP TABLE dtb_product_categories;
19DROP TABLE dtb_bat_order_daily;
20DROP TABLE dtb_bat_order_daily_hour;
21DROP TABLE dtb_recommend_products;
22DROP TABLE dtb_review;
23DROP TABLE dtb_customer_reading;
24DROP TABLE dtb_category_count;
25DROP TABLE dtb_category_total_count;
26DROP TABLE dtb_news;
27DROP TABLE dtb_best_products;
28DROP TABLE dtb_mail_history;
29DROP TABLE dtb_customer;
30DROP TABLE dtb_order;
31DROP TABLE dtb_order_temp;
32DROP TABLE dtb_other_deliv;
33DROP TABLE dtb_order_detail;
34DROP TABLE mtb_pref;
35DROP TABLE dtb_member;
36DROP TABLE dtb_bat_relate_products;
37DROP TABLE dtb_pagelayout;
38DROP TABLE dtb_bloc;
39DROP TABLE dtb_blocposition;
40DROP TABLE dtb_csv;
41DROP TABLE dtb_csv_sql;
42DROP TABLE dtb_templates;
43DROP TABLE dtb_table_comment;
44DROP TABLE dtb_ownersstore_settings;
45DROP TABLE dtb_module_update_logs;
46DROP TABLE mtb_work;
47DROP TABLE mtb_wday;
48DROP TABLE mtb_track_back_status;
49DROP TABLE mtb_taxrule;
50DROP TABLE mtb_target;
51DROP TABLE mtb_status_image;
52DROP TABLE mtb_status;
53DROP TABLE mtb_site_control_track_back;
54DROP TABLE mtb_site_control_affiliate;
55DROP TABLE mtb_sex;
56DROP TABLE mtb_review_deny_url;
57DROP TABLE mtb_reminder;
58DROP TABLE mtb_recommend;
59DROP TABLE mtb_product_status_color;
60DROP TABLE mtb_product_list_max;
61DROP TABLE mtb_permission;
62DROP TABLE mtb_page_rows;
63DROP TABLE mtb_page_max;
64DROP TABLE mtb_order_status_color;
65DROP TABLE mtb_order_status;
66DROP TABLE mtb_mail_type;
67DROP TABLE mtb_mail_tpl_path;
68DROP TABLE mtb_mail_template;
69DROP TABLE mtb_mail_magazine_type;
70DROP TABLE mtb_magazine_type;
71DROP TABLE mtb_mobile_domain;
72DROP TABLE mtb_job;
73DROP TABLE mtb_disp;
74DROP TABLE mtb_disable_logout;
75DROP TABLE mtb_delivery_date;
76DROP TABLE mtb_db;
77DROP TABLE mtb_convenience;
78DROP TABLE mtb_conveni_message;
79DROP TABLE mtb_constants;
80DROP TABLE mtb_class;
81DROP TABLE mtb_authority;
82DROP TABLE mtb_allowed_tag;
83DROP TABLE mtb_ownersstore_err;
84DROP TABLE mtb_ownersstore_ips;
85DROP TABLE dtb_maker;
86DROP TABLE dtb_maker_count;
87DROP TABLE dtb_holiday;
88DROP TABLE dtb_customer_favorite_products;
89DROP TABLE mtb_down;
90DROP TABLE dtb_module;
91DROP TABLE dtb_session;
92DROP TABLE dtb_mobile_ext_session_id;
93DROP TABLE dtb_mobile_kara_mail;
94DROP TABLE dtb_site_control;
95DROP TABLE dtb_trackback;
96DROP TABLE dtb_bkup;
Note: See TracBrowser for help on using the repository browser.