create table dtb_module_update_logs( log_id int NOT NULL, module_id int NOT NULL, buckup_path text, error_flg smallint DEFAULT 0, error text, ok text, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (log_id) ); CREATE TABLE dtb_ownersstore_settings ( public_key text, PRIMARY KEY(public_key) ); CREATE TABLE dtb_kiyaku ( kiyaku_id int NOT NULL, kiyaku_title text NOT NULL, kiyaku_text text NOT NULL, rank int NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (kiyaku_id) ); CREATE TABLE dtb_holiday ( holiday_id int NOT NULL, title text NOT NULL, month smallint NOT NULL, day smallint NOT NULL, rank int NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (holiday_id) ); CREATE TABLE mtb_zip ( zip_id int, zipcode text, state text, city text, town text, PRIMARY KEY (zip_id) ); CREATE TABLE dtb_update ( module_id int NOT NULL, module_name text NOT NULL, now_version text, latest_version text NOT NULL, module_explain text, main_php text NOT NULL, extern_php text NOT NULL, install_sql text, uninstall_sql text, other_files text, del_flg smallint NOT NULL DEFAULT 0, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, release_date timestamp NOT NULL, PRIMARY KEY (module_id) ); CREATE TABLE dtb_baseinfo ( id int, company_name text, company_kana text, zip01 text, zip02 text, zipcode text, country_id int, pref smallint, addr01 text, addr02 text, tel01 text, tel02 text, tel03 text, fax01 text, fax02 text, fax03 text, business_hour text, law_company text, law_manager text, law_zip01 text, law_zip02 text, law_zipcode text, law_country_id int, law_pref smallint, law_addr01 text, law_addr02 text, law_tel01 text, law_tel02 text, law_tel03 text, law_fax01 text, law_fax02 text, law_fax03 text, law_email text, law_url text, law_term01 text, law_term02 text, law_term03 text, law_term04 text, law_term05 text, law_term06 text, law_term07 text, law_term08 text, law_term09 text, law_term10 text, email01 text, email02 text, email03 text, email04 text, free_rule numeric, shop_name text, shop_kana text, shop_name_eng text, point_rate numeric NOT NULL DEFAULT 0, welcome_point numeric NOT NULL DEFAULT 0, update_date timestamp NOT NULL, top_tpl text, product_tpl text, detail_tpl text, mypage_tpl text, good_traded text, message text, regular_holiday_ids text, latitude text, longitude text, downloadable_days numeric DEFAULT 30, downloadable_days_unlimited smallint, PRIMARY KEY (id) ); CREATE TABLE dtb_deliv ( deliv_id int NOT NULL, product_type_id int, name text, service_name text, remark text, confirm_url text, rank int, status smallint NOT NULL DEFAULT 1, del_flg smallint NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (deliv_id) ); CREATE TABLE dtb_payment_options ( deliv_id int NOT NULL, payment_id int NOT NULL, rank int, PRIMARY KEY (deliv_id, payment_id) ); CREATE TABLE dtb_delivtime ( deliv_id int NOT NULL, time_id int NOT NULL, deliv_time text NOT NULL, PRIMARY KEY (deliv_id, time_id) ); CREATE TABLE dtb_delivfee ( deliv_id int NOT NULL, fee_id int NOT NULL, fee numeric NOT NULL, pref smallint, PRIMARY KEY (deliv_id, fee_id) ); CREATE TABLE dtb_payment ( payment_id int NOT NULL, payment_method text, charge numeric, rule_max numeric, rank int, note text, fix smallint, status smallint NOT NULL DEFAULT 1, del_flg smallint NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, payment_image text, upper_rule numeric, charge_flg smallint DEFAULT 1, rule_min numeric, upper_rule_max numeric, module_id int, module_path text, memo01 text, memo02 text, memo03 text, memo04 text, memo05 text, memo06 text, memo07 text, memo08 text, memo09 text, memo10 text, PRIMARY KEY (payment_id) ); CREATE TABLE dtb_mailtemplate ( template_id int NOT NULL, subject text, header text, footer text, creator_id int NOT NULL, del_flg smallint NOT NULL DEFAULT 0, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (template_id) ); CREATE TABLE dtb_mailmaga_template ( template_id int NOT NULL, subject text, mail_method int, body text, del_flg smallint NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (template_id) ); CREATE TABLE dtb_send_history ( send_id int NOT NULL, mail_method smallint, subject text, body text, send_count int, complete_count int NOT NULL DEFAULT 0, start_date timestamp, end_date timestamp, search_data text, del_flg smallint NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (send_id) ); CREATE TABLE dtb_send_customer ( customer_id int NOT NULL, send_id int NOT NULL, email text, name text, send_flag smallint, PRIMARY KEY (send_id, customer_id) ); CREATE TABLE dtb_products ( product_id int NOT NULL, name text NOT NULL, maker_id int, status smallint NOT NULL DEFAULT 2, comment1 text, comment2 text, comment3 text, comment4 text, comment5 text, comment6 text, note text, main_list_comment text, main_list_image text, main_comment text, main_image text, main_large_image text, sub_title1 text, sub_comment1 text, sub_image1 text, sub_large_image1 text, sub_title2 text, sub_comment2 text, sub_image2 text, sub_large_image2 text, sub_title3 text, sub_comment3 text, sub_image3 text, sub_large_image3 text, sub_title4 text, sub_comment4 text, sub_image4 text, sub_large_image4 text, sub_title5 text, sub_comment5 text, sub_image5 text, sub_large_image5 text, sub_title6 text, sub_comment6 text, sub_image6 text, sub_large_image6 text, del_flg smallint NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, deliv_date_id int, PRIMARY KEY (product_id) ); CREATE TABLE dtb_products_class ( product_class_id int NOT NULL, product_id int NOT NULL, classcategory_id1 int NOT NULL DEFAULT 0, classcategory_id2 int NOT NULL DEFAULT 0, product_type_id int NOT NULL DEFAULT 0, product_code text, stock numeric, stock_unlimited smallint NOT NULL DEFAULT 0, sale_limit numeric, price01 numeric, price02 numeric NOT NULL, deliv_fee numeric, point_rate numeric NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, down_filename text, down_realfilename text, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (product_class_id), UNIQUE (product_id, classcategory_id1, classcategory_id2) ); CREATE TABLE dtb_class ( class_id int NOT NULL, name text, rank int, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (class_id) ); CREATE TABLE dtb_classcategory ( classcategory_id int NOT NULL, name text, class_id int NOT NULL, rank int, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (classcategory_id) ); CREATE TABLE dtb_category ( category_id int NOT NULL, category_name text, parent_category_id int NOT NULL DEFAULT 0, level int NOT NULL, rank int, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (category_id) ); CREATE TABLE dtb_product_categories ( product_id int NOT NULL, category_id int NOT NULL, rank int NOT NULL, PRIMARY KEY(product_id, category_id) ); CREATE TABLE dtb_product_status ( product_status_id smallint NOT NULL, product_id int NOT NULL, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (product_status_id, product_id) ); CREATE TABLE dtb_recommend_products ( product_id int NOT NULL, recommend_product_id int NOT NULL, rank int NOT NULL, comment text, status smallint NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (product_id, recommend_product_id) ); CREATE TABLE dtb_review ( review_id int NOT NULL, product_id int NOT NULL, reviewer_name text NOT NULL, reviewer_url text, sex smallint, customer_id int, recommend_level smallint NOT NULL, title text NOT NULL, comment text NOT NULL, status smallint DEFAULT 2, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (review_id) ); CREATE TABLE dtb_customer_favorite_products ( customer_id int NOT NULL, product_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (customer_id, product_id) ); CREATE TABLE dtb_category_count ( category_id int NOT NULL, product_count int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (category_id) ); CREATE TABLE dtb_category_total_count ( category_id int NOT NULL, product_count int, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (category_id) ); CREATE TABLE dtb_news ( news_id int NOT NULL, news_date timestamp, rank int, news_title text NOT NULL, news_comment text, news_url text, news_select smallint NOT NULL DEFAULT 0, link_method text, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (news_id) ); CREATE TABLE dtb_best_products ( best_id int NOT NULL, category_id int NOT NULL, rank int NOT NULL DEFAULT 0, product_id int NOT NULL, title text, comment text, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (best_id) ); CREATE TABLE dtb_mail_history ( send_id int NOT NULL, order_id int NOT NULL, send_date timestamp, template_id int, creator_id int NOT NULL, subject text, mail_body text, PRIMARY KEY (send_id) ); CREATE TABLE dtb_customer ( customer_id int NOT NULL, name01 text NOT NULL, name02 text NOT NULL, kana01 text, kana02 text, company_name text, zip01 text, zip02 text, zipcode text, country_id int, pref smallint, addr01 text, addr02 text, email text NOT NULL, email_mobile text, tel01 text, tel02 text, tel03 text, fax01 text, fax02 text, fax03 text, sex smallint, job smallint, birth timestamp, password text, reminder smallint, reminder_answer text, salt text, secret_key text NOT NULL, first_buy_date timestamp, last_buy_date timestamp, buy_times numeric DEFAULT 0, buy_total numeric DEFAULT 0, point numeric NOT NULL DEFAULT 0, note text, status smallint NOT NULL DEFAULT 1, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, mobile_phone_id text, mailmaga_flg smallint, PRIMARY KEY (customer_id), UNIQUE (secret_key) ); CREATE TABLE dtb_order ( order_id int NOT NULL, order_temp_id text, customer_id int NOT NULL, message text, order_name01 text, order_name02 text, order_kana01 text, order_kana02 text, order_company_name text, order_email text, order_tel01 text, order_tel02 text, order_tel03 text, order_fax01 text, order_fax02 text, order_fax03 text, order_zip01 text, order_zip02 text, order_zipcode text, order_country_id int, order_pref smallint, order_addr01 text, order_addr02 text, order_sex smallint, order_birth timestamp, order_job int, subtotal numeric, discount numeric NOT NULL DEFAULT 0, deliv_id int, deliv_fee numeric, charge numeric, use_point numeric NOT NULL DEFAULT 0, add_point numeric NOT NULL DEFAULT 0, birth_point numeric NOT NULL DEFAULT 0, tax numeric, total numeric, payment_total numeric, payment_id int, payment_method text, note text, status smallint, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, commit_date timestamp, payment_date timestamp, device_type_id int, del_flg smallint NOT NULL DEFAULT 0, memo01 text, memo02 text, memo03 text, memo04 text, memo05 text, memo06 text, memo07 text, memo08 text, memo09 text, memo10 text, PRIMARY KEY (order_id) ); CREATE TABLE dtb_order_temp ( order_temp_id text NOT NULL, customer_id int NOT NULL, message text, order_name01 text, order_name02 text, order_kana01 text, order_kana02 text, order_company_name text, order_email text, order_tel01 text, order_tel02 text, order_tel03 text, order_fax01 text, order_fax02 text, order_fax03 text, order_zip01 text, order_zip02 text, order_zipcode text, order_country_id int, order_pref smallint, order_addr01 text, order_addr02 text, order_sex smallint, order_birth timestamp, order_job int, subtotal numeric, discount numeric NOT NULL DEFAULT 0, deliv_id int, deliv_fee numeric, charge numeric, use_point numeric NOT NULL DEFAULT 0, add_point numeric NOT NULL DEFAULT 0, birth_point numeric NOT NULL DEFAULT 0, tax numeric, total numeric, payment_total numeric, payment_id int, payment_method text, note text, mail_flag smallint, status smallint, deliv_check smallint, point_check smallint, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, device_type_id int, del_flg smallint NOT NULL DEFAULT 0, order_id int, memo01 text, memo02 text, memo03 text, memo04 text, memo05 text, memo06 text, memo07 text, memo08 text, memo09 text, memo10 text, session text, PRIMARY KEY (order_temp_id) ); CREATE TABLE dtb_shipping ( shipping_id int NOT NULL, order_id int NOT NULL, shipping_name01 text, shipping_name02 text, shipping_kana01 text, shipping_kana02 text, shipping_company_name text, shipping_tel01 text, shipping_tel02 text, shipping_tel03 text, shipping_fax01 text, shipping_fax02 text, shipping_fax03 text, shipping_country_id int, shipping_pref smallint, shipping_zip01 text, shipping_zip02 text, shipping_zipcode text, shipping_addr01 text, shipping_addr02 text, time_id int, shipping_time text, shipping_num text, shipping_date timestamp, shipping_commit_date timestamp, rank int, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (shipping_id, order_id) ); CREATE TABLE dtb_shipment_item ( shipping_id int NOT NULL, product_class_id int NOT NULL, order_id int NOT NULL, product_name text NOT NULL, product_code text, classcategory_name1 text, classcategory_name2 text, price numeric, quantity numeric, PRIMARY KEY (shipping_id, product_class_id, order_id) ); CREATE TABLE dtb_other_deliv ( other_deliv_id int NOT NULL, customer_id int NOT NULL, name01 text, name02 text, kana01 text, kana02 text, company_name text, zip01 text, zip02 text, zipcode text, country_id int, pref smallint, addr01 text, addr02 text, tel01 text, tel02 text, tel03 text, fax01 text, fax02 text, fax03 text, PRIMARY KEY (other_deliv_id) ); CREATE TABLE dtb_order_detail ( order_detail_id int NOT NULL, order_id int NOT NULL, product_id int NOT NULL, product_class_id int NOT NULL, product_name text NOT NULL, product_code text, classcategory_name1 text, classcategory_name2 text, price numeric, quantity numeric, point_rate numeric NOT NULL DEFAULT 0, tax_rate numeric, tax_rule smallint, PRIMARY KEY (order_detail_id) ); CREATE TABLE dtb_member ( member_id int NOT NULL, name text, department text, login_id text NOT NULL, password text NOT NULL, salt text NOT NULL, authority smallint NOT NULL, rank int NOT NULL DEFAULT 0, work smallint NOT NULL DEFAULT 1, del_flg smallint NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, login_date timestamp, PRIMARY KEY (member_id) ); CREATE TABLE dtb_pagelayout ( device_type_id int NOT NULL, page_id int NOT NULL, page_name text, url text NOT NULL, filename text, header_chk smallint DEFAULT 1, footer_chk smallint DEFAULT 1, edit_flg smallint DEFAULT 1, author text, description text, keyword text, update_url text, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, meta_robots text, PRIMARY KEY (device_type_id, page_id) ); CREATE TABLE dtb_bloc ( device_type_id int NOT NULL, bloc_id int NOT NULL, bloc_name text, tpl_path text, filename text NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, php_path text, deletable_flg smallint NOT NULL DEFAULT 1, plugin_id int, PRIMARY KEY (device_type_id, bloc_id), UNIQUE (device_type_id, filename) ); CREATE TABLE dtb_blocposition ( device_type_id int NOT NULL, page_id int NOT NULL, target_id int NOT NULL, bloc_id int NOT NULL, bloc_row int, anywhere smallint DEFAULT 0 NOT NULL, PRIMARY KEY (device_type_id, page_id, target_id, bloc_id) ); CREATE TABLE dtb_csv ( no int, csv_id int NOT NULL, col text, disp_name text, rank int, rw_flg smallint DEFAULT 1, status smallint NOT NULL DEFAULT 1, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, mb_convert_kana_option text, size_const_type text, error_check_types text, PRIMARY KEY (no) ); CREATE TABLE dtb_csv_sql ( sql_id int, sql_name text NOT NULL, csv_sql text, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (sql_id) ); CREATE TABLE dtb_templates ( template_code text NOT NULL, device_type_id int NOT NULL, template_name text, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (template_code) ); CREATE TABLE dtb_maker ( maker_id int NOT NULL, name text NOT NULL, rank int NOT NULL DEFAULT 0, creator_id int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, del_flg smallint NOT NULL DEFAULT 0, PRIMARY KEY (maker_id) ); CREATE TABLE dtb_maker_count ( maker_id int NOT NULL, product_count int NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (maker_id) ); CREATE TABLE mtb_pref ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_permission ( id text, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_disable_logout ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_authority ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_auth_excludes ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_work ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_disp ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_status ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_status_image ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_allowed_tag ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_page_max ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_magazine_type ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_mail_magazine_type ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_recommend ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_taxrule ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_mail_template ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_mail_tpl_path ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_job ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_reminder ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_sex ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_customer_status ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_mail_type ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_order_status ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_product_status_color ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_customer_order_status ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_order_status_color ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_wday ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_delivery_date ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_product_list_max ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_db ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_target ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_review_deny_url ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_mobile_domain ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_ownersstore_err ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_ownersstore_ips ( id smallint, name text, rank smallint NOT NULL DEFAULT 0, PRIMARY KEY (id) ); CREATE TABLE mtb_constants ( id text, name text, rank smallint NOT NULL DEFAULT 0, remarks text, PRIMARY KEY (id) ); CREATE TABLE mtb_product_type ( id smallint, name text, rank smallint NOT NULL, PRIMARY KEY (id) ); CREATE TABLE mtb_device_type ( id smallint, name text, rank smallint NOT NULL, PRIMARY KEY (id) ); CREATE TABLE mtb_country ( id int, name text, rank int NOT NULL, PRIMARY KEY (id) ); CREATE TABLE dtb_mobile_ext_session_id ( session_id text NOT NULL, param_key text, param_value text, url text, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (session_id) ); CREATE TABLE dtb_module ( module_id int NOT NULL, module_code text NOT NULL, module_name text NOT NULL, sub_data text, auto_update_flg smallint NOT NULL DEFAULT 0, del_flg smallint NOT NULL DEFAULT 0, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (module_id) ); CREATE TABLE dtb_session ( sess_id text NOT NULL, sess_data text, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (sess_id) ); CREATE TABLE dtb_bkup ( bkup_name text, bkup_memo text, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (bkup_name) ); CREATE TABLE dtb_plugin ( plugin_id int NOT NULL, plugin_name text NOT NULL, plugin_code text NOT NULL, class_name text NOT NULL, author text, author_site_url text, plugin_site_url text, plugin_version text, compliant_version text, plugin_description text, priority int NOT NULL DEFAULT 0, enable smallint NOT NULL DEFAULT 0, free_field1 text, free_field2 text, free_field3 text, free_field4 text, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (plugin_id) ); CREATE TABLE dtb_plugin_hookpoint ( plugin_hookpoint_id int NOT NULL, plugin_id int NOT NULL, hook_point text NOT NULL, callback text, use_flg smallint NOT NULL DEFAULT 1, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (plugin_hookpoint_id) ); CREATE TABLE dtb_index_list ( table_name text NOT NULL, column_name text NOT NULL, recommend_flg smallint NOT NULL DEFAULT 0, recommend_comment text, PRIMARY KEY (table_name, column_name) ); CREATE TABLE dtb_api_config ( api_config_id int NOT NULL, operation_name text NOT NULL, operation_description text, auth_types text NOT NULL, enable smallint NOT NULL DEFAULT 0, is_log smallint NOT NULL DEFAULT 0, sub_data text, del_flg smallint NOT NULL DEFAULT 0, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (api_config_id) ); CREATE TABLE dtb_api_account ( api_account_id int NOT NULL, api_access_key text NOT NULL, api_secret_key text NOT NULL, enable smallint NOT NULL DEFAULT 0, del_flg smallint NOT NULL DEFAULT 0, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date timestamp NOT NULL, PRIMARY KEY (api_account_id) ); CREATE TABLE dtb_tax_rule ( tax_rule_id int NOT NULL, country_id int NOT NULL DEFAULT 0, pref_id int NOT NULL DEFAULT 0, product_id int NOT NULL DEFAULT 0, product_class_id int NOT NULL DEFAULT 0, calc_rule smallint NOT NULL DEFAULT 1, tax_rate numeric NOT NULL DEFAULT 5, tax_adjust numeric NOT NULL DEFAULT 0, apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, member_id int NOT NULL, del_flg smallint NOT NULL DEFAULT 0, create_date timestamp NOT NULL, update_date timestamp NOT NULL, PRIMARY KEY (tax_rule_id) ); CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id); CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer(customer_id); CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key); CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value); CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url); CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); CREATE INDEX dtb_products_class_product_id ON dtb_products_class (product_id) WHERE del_flg = 0;