Index: branches/version-2_4/html/install/sql/add/create_table_mysql.sql
===================================================================
--- branches/version-2_4/html/install/sql/add/create_table_mysql.sql (revision 17931)
+++ (revision )
@@ -1,1233 +1,0 @@
-create table dtb_module_update_logs(
- log_id int auto_increment primary key NOT NULL,
- module_id int not null,
- buckup_path text,
- error_flg smallint DEFAULT 0,
- error text,
- ok text,
- create_date datetime NOT NULL,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_ownersstore_settings (
- public_key text
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_kiyaku (
- kiyaku_id int auto_increment primary key 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 datetime NOT NULL ,
- update_date datetime NOT NULL,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_holiday (
- holiday_id int auto_increment primary key 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 datetime NOT NULL,
- update_date datetime NOT NULL,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE mtb_zip (
- code text,
- old_zipcode text,
- zipcode text,
- state_kana text,
- city_kana text,
- town_kana text,
- state text,
- city text,
- town text,
- flg1 text,
- flg2 text,
- flg3 text,
- flg4 text,
- flg5 text,
- flg6 text
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_bat_order_daily_age (
- order_count numeric NOT NULL DEFAULT 0,
- total numeric NOT NULL DEFAULT 0,
- total_average numeric NOT NULL DEFAULT 0,
- start_age smallint,
- end_age smallint,
- member smallint,
- order_date datetime,
- create_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_update (
- module_id int NOT NULL UNIQUE,
- 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 datetime NOT NULL ,
- update_date datetime,
- release_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_baseinfo (
- company_name text,
- company_kana text,
- zip01 text,
- zip02 text,
- 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_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,
- tax numeric DEFAULT 5,
- tax_rule smallint DEFAULT 1,
- email01 text,
- email02 text,
- email03 text,
- email04 text,
- email05 text,
- free_rule numeric,
- shop_name text,
- shop_kana text,
- point_rate numeric,
- welcome_point numeric,
- update_date datetime,
- top_tpl text,
- product_tpl text,
- detail_tpl text,
- mypage_tpl text,
- good_traded text,
- message text,
- regular_holiday_ids text
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_deliv (
- deliv_id int auto_increment primary key NOT NULL,
- name text,
- service_name 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 datetime NOT NULL ,
- update_date datetime
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_delivtime (
- deliv_id int NOT NULL,
- time_id int auto_increment primary key NOT NULL,
- deliv_time text NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_delivfee (
- deliv_id int NOT NULL,
- fee_id int auto_increment primary key NOT NULL,
- fee text NOT NULL,
- pref smallint
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_payment (
- payment_id int auto_increment primary key NOT NULL,
- payment_method text,
- charge numeric,
- rule numeric,
- deliv_id int DEFAULT 0,
- 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 datetime NOT NULL ,
- update_date datetime,
- payment_image text,
- upper_rule numeric,
- charge_flg int2 DEFAULT 1,
- rule_min numeric,
- upper_rule_max numeric,
- module_id int4,
- module_path text,
- memo01 text,
- memo02 text,
- memo03 text,
- memo04 text,
- memo05 text,
- memo06 text,
- memo07 text,
- memo08 text,
- memo09 text,
- memo10 text
-) TYPE=InnoDB ;
-
-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 datetime NOT NULL ,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_mailmaga_template (
- template_id int auto_increment primary key NOT NULL UNIQUE,
- subject text,
- charge_image text,
- mail_method int,
- header text,
- body text,
- main_title text,
- main_comment text,
- main_product_id int,
- sub_title text,
- sub_comment text,
- sub_product_id01 int,
- sub_product_id02 int,
- sub_product_id03 int,
- sub_product_id04 int,
- sub_product_id05 int,
- sub_product_id06 int,
- sub_product_id07 int,
- sub_product_id08 int,
- sub_product_id09 int,
- sub_product_id10 int,
- sub_product_id11 int,
- sub_product_id12 int,
- del_flg smallint NOT NULL DEFAULT 0,
- creator_id int NOT NULL,
- create_date datetime NOT NULL ,
- update_date datetime
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_send_history (
- send_id int auto_increment primary key NOT NULL,
- mail_method smallint,
- subject text,
- body text,
- send_count int,
- complete_count int NOT NULL DEFAULT 0,
- start_date datetime,
- end_date datetime,
- search_data text,
- del_flg smallint NOT NULL DEFAULT 0,
- creator_id int NOT NULL,
- create_date datetime NOT NULL ,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_send_customer (
- customer_id int,
- send_id int NOT NULL,
- email text,
- name text,
- send_flag smallint
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_products (
- product_id int auto_increment primary key NOT NULL UNIQUE,
- name text,
- deliv_fee numeric,
- sale_limit numeric,
- sale_unlimited smallint DEFAULT 0,
- category_id int,
- rank int,
- status smallint NOT NULL DEFAULT 2,
- product_flag text,
- point_rate numeric,
- comment1 text,
- comment2 text,
- comment3 mediumtext,
- comment4 text,
- comment5 text,
- comment6 text,
- note text,
- file1 text,
- file2 text,
- file3 text,
- file4 text,
- file5 text,
- file6 text,
- main_list_comment text,
- main_list_image text,
- main_comment mediumtext,
- main_image text,
- main_large_image text,
- sub_title1 text,
- sub_comment1 mediumtext,
- sub_image1 text,
- sub_large_image1 text,
- sub_title2 text,
- sub_comment2 mediumtext,
- sub_image2 text,
- sub_large_image2 text,
- sub_title3 text,
- sub_comment3 mediumtext,
- sub_image3 text,
- sub_large_image3 text,
- sub_title4 text,
- sub_comment4 mediumtext,
- sub_image4 text,
- sub_large_image4 text,
- sub_title5 text,
- sub_comment5 mediumtext,
- sub_image5 text,
- sub_large_image5 text,
- sub_title6 text,
- sub_comment6 mediumtext,
- sub_image6 text,
- sub_large_image6 text,
- del_flg smallint NOT NULL DEFAULT 0,
- creator_id int NOT NULL,
- create_date datetime NOT NULL ,
- update_date datetime,
- deliv_date_id int
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_products_class (
- product_class_id int auto_increment primary key NOT NULL UNIQUE,
- product_id int NOT NULL,
- classcategory_id1 int NOT NULL DEFAULT 0,
- classcategory_id2 int NOT NULL DEFAULT 0,
- product_code text,
- stock numeric,
- stock_unlimited smallint DEFAULT 0,
- sale_limit numeric,
- price01 numeric,
- price02 numeric,
- status smallint,
- creator_id int NOT NULL,
- create_date datetime NOT NULL ,
- update_date datetime
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_class (
- class_id int auto_increment primary key NOT NULL,
- name text,
- status smallint,
- rank int,
- creator_id int NOT NULL,
- create_date datetime NOT NULL ,
- update_date datetime,
- del_flg smallint NOT NULL DEFAULT 0,
- product_id int
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_classcategory (
- classcategory_id int auto_increment primary key NOT NULL,
- name text,
- class_id int NOT NULL,
- status smallint,
- rank int,
- creator_id int NOT NULL,
- create_date datetime NOT NULL ,
- update_date datetime,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_category (
- category_id int auto_increment primary key 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 datetime NOT NULL ,
- update_date datetime,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_product_categories (
- product_id int4 NOT NULL,
- category_id int4 NOT NULL,
- rank int4,
- PRIMARY KEY(product_id, category_id)
-) TYPE=InnoDB;
-
-CREATE TABLE dtb_bat_order_daily (
- total_order numeric NOT NULL DEFAULT 0,
- member numeric NOT NULL DEFAULT 0,
- nonmember numeric NOT NULL DEFAULT 0,
- men numeric NOT NULL DEFAULT 0,
- women numeric NOT NULL DEFAULT 0,
- men_member numeric NOT NULL DEFAULT 0,
- men_nonmember numeric NOT NULL DEFAULT 0,
- women_member numeric NOT NULL DEFAULT 0,
- women_nonmember numeric NOT NULL DEFAULT 0,
- total numeric NOT NULL DEFAULT 0,
- total_average numeric NOT NULL DEFAULT 0,
- order_date datetime NOT NULL ,
- create_date datetime NOT NULL ,
- year smallint NOT NULL,
- month smallint NOT NULL,
- day smallint NOT NULL,
- wday smallint NOT NULL,
- key_day text NOT NULL,
- key_month text NOT NULL,
- key_year text NOT NULL,
- key_wday text NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_bat_order_daily_hour (
- total_order numeric NOT NULL DEFAULT 0,
- member numeric NOT NULL DEFAULT 0,
- nonmember numeric NOT NULL DEFAULT 0,
- men numeric NOT NULL DEFAULT 0,
- women numeric NOT NULL DEFAULT 0,
- men_member numeric NOT NULL DEFAULT 0,
- men_nonmember numeric NOT NULL DEFAULT 0,
- women_member numeric NOT NULL DEFAULT 0,
- women_nonmember numeric NOT NULL DEFAULT 0,
- total numeric NOT NULL DEFAULT 0,
- total_average numeric NOT NULL DEFAULT 0,
- hour smallint NOT NULL DEFAULT 0,
- order_date datetime ,
- create_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-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 datetime NOT NULL ,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_review (
- review_id int auto_increment primary key 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 datetime,
- update_date datetime,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_customer_favorite_products (
- customer_id int NOT NULL,
- product_id int NOT NULL,
- create_date datetime NOT NULL,
- update_date datetime NOT NULL,
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_customer_reading (
- reading_product_id int NOT NULL,
- customer_id int NOT NULL,
- create_date datetime NOT NULL,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_category_count (
- category_id int NOT NULL,
- product_count int NOT NULL,
- create_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_category_total_count (
- category_id int NOT NULL,
- product_count int,
- create_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_news (
- news_id int auto_increment primary key NOT NULL UNIQUE,
- news_date datetime,
- 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 datetime NOT NULL ,
- update_date datetime,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_best_products (
- best_id int auto_increment primary key 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 datetime NOT NULL ,
- update_date datetime,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_mail_history (
- send_id int auto_increment primary key NOT NULL,
- order_id int NOT NULL,
- send_date datetime,
- template_id int,
- creator_id int NOT NULL,
- subject text,
- mail_body text
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_customer (
- customer_id int auto_increment primary key NOT NULL,
- name01 text NOT NULL,
- name02 text NOT NULL,
- kana01 text NOT NULL,
- kana02 text NOT NULL,
- zip01 text,
- zip02 text,
- 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 datetime,
- password text,
- reminder smallint,
- reminder_answer text,
- secret_key varchar(50) NOT NULL UNIQUE,
- first_buy_date datetime,
- last_buy_date datetime,
- buy_times numeric DEFAULT 0,
- buy_total numeric DEFAULT 0,
- point numeric DEFAULT 0,
- note text,
- status smallint NOT NULL DEFAULT 1,
- create_date datetime NOT NULL ,
- update_date datetime ,
- del_flg smallint NOT NULL DEFAULT 0,
- cell01 text,
- cell02 text,
- cell03 text,
- mobile_phone_id text,
- mailmaga_flg smallint
-) TYPE=InnoDB ;
-
-CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
-
-CREATE TABLE dtb_customer_mail_temp (
- email varchar(50) NOT NULL UNIQUE,
- mail_flag smallint,
- temp_id varchar(50) NOT NULL UNIQUE,
- end_flag smallint,
- update_date datetime NOT NULL ,
- create_data datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_order (
- order_id int auto_increment primary key 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_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_pref text,
- order_addr01 text,
- order_addr02 text,
- order_sex smallint,
- order_birth datetime,
- order_job int,
- deliv_name01 text,
- deliv_name02 text,
- deliv_kana01 text,
- deliv_kana02 text,
- deliv_tel01 text,
- deliv_tel02 text,
- deliv_tel03 text,
- deliv_fax01 text,
- deliv_fax02 text,
- deliv_fax03 text,
- deliv_zip01 text,
- deliv_zip02 text,
- deliv_pref text,
- deliv_addr01 text,
- deliv_addr02 text,
- subtotal numeric,
- discount numeric,
- deliv_fee numeric,
- charge numeric,
- use_point numeric,
- add_point numeric,
- birth_point numeric DEFAULT 0,
- tax numeric,
- total numeric,
- payment_total numeric,
- payment_id int,
- payment_method text,
- deliv_id int,
- deliv_time_id int,
- deliv_time text,
- deliv_no text,
- note text,
- status smallint,
- create_date datetime NOT NULL ,
- loan_result text,
- credit_result text,
- credit_msg text,
- update_date datetime,
- commit_date datetime,
- del_flg smallint NOT NULL DEFAULT 0,
- deliv_date text,
- conveni_data text,
- cell01 text,
- cell02 text,
- cell03 text,
- memo01 text,
- memo02 text,
- memo03 text,
- memo04 text,
- memo05 text,
- memo06 text,
- memo07 text,
- memo08 text,
- memo09 text,
- memo10 text,
- campaign_id int
-) TYPE=InnoDB ;
-
-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_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_pref text,
- order_addr01 text,
- order_addr02 text,
- order_sex smallint,
- order_birth datetime,
- order_job int,
- deliv_name01 text,
- deliv_name02 text,
- deliv_kana01 text,
- deliv_kana02 text,
- deliv_tel01 text,
- deliv_tel02 text,
- deliv_tel03 text,
- deliv_fax01 text,
- deliv_fax02 text,
- deliv_fax03 text,
- deliv_zip01 text,
- deliv_zip02 text,
- deliv_pref text,
- deliv_addr01 text,
- deliv_addr02 text,
- subtotal numeric,
- discount numeric,
- deliv_fee numeric,
- charge numeric,
- use_point numeric,
- add_point numeric,
- birth_point numeric DEFAULT 0,
- tax numeric,
- total numeric,
- payment_total numeric,
- payment_id int,
- payment_method text,
- deliv_id int,
- deliv_time_id int,
- deliv_time text,
- deliv_no text,
- note text,
- mail_flag smallint,
- status smallint,
- deliv_check smallint,
- point_check smallint,
- loan_result text,
- credit_result text,
- credit_msg text,
- create_date datetime NOT NULL ,
- update_date datetime,
- del_flg smallint NOT NULL DEFAULT 0,
- deliv_date text,
- conveni_data text,
- cell01 text,
- cell02 text,
- cell03 text,
- order_id int4,
- memo01 text,
- memo02 text,
- memo03 text,
- memo04 text,
- memo05 text,
- memo06 text,
- memo07 text,
- memo08 text,
- memo09 text,
- memo10 text,
- session text
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_other_deliv (
- other_deliv_id int auto_increment primary key NOT NULL,
- customer_id int NOT NULL,
- name01 text,
- name02 text,
- kana01 text,
- kana02 text,
- zip01 text,
- zip02 text,
- pref text,
- addr01 text,
- addr02 text,
- tel01 text,
- tel02 text,
- tel03 text
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_order_detail (
- order_id int NOT NULL,
- product_id int NOT NULL,
- classcategory_id1 int NOT NULL,
- classcategory_id2 int NOT NULL,
- product_name text NOT NULL,
- product_code text,
- classcategory_name1 text,
- classcategory_name2 text,
- price numeric,
- quantity numeric,
- point_rate numeric
-) TYPE=InnoDB ;
-
-CREATE TABLE mtb_pref (
- pref_id smallint NOT NULL,
- pref_name text,
- rank smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_member (
- member_id int auto_increment primary key NOT NULL,
- name text,
- department text,
- login_id text NOT NULL,
- password 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,
- update_date datetime,
- create_date datetime NOT NULL ,
- login_date datetime
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_question (
- question_id int auto_increment primary key NOT NULL,
- question_name text,
- question text,
- create_date datetime NOT NULL ,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_question_result (
- result_id int auto_increment primary key NOT NULL,
- question_id int NOT NULL,
- question_date datetime,
- question_name text,
- name01 text,
- name02 text,
- kana01 text,
- kana02 text,
- zip01 text,
- zip02 text,
- pref smallint,
- addr01 text,
- addr02 text,
- tel01 text,
- tel02 text,
- tel03 text,
- mail01 text,
- question01 text,
- question02 text,
- question03 text,
- question04 text,
- question05 text,
- question06 text,
- create_date datetime NOT NULL ,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_bat_relate_products (
- product_id int,
- relate_product_id int,
- customer_id int,
- create_date datetime
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_campaign (
- campaign_id int auto_increment primary key NOT NULL,
- campaign_name text,
- campaign_point_rate numeric NOT NULL,
- campaign_point_type smallint,
- start_date datetime NOT NULL,
- end_date datetime NOT NULL,
- directory_name text NOT NULL,
- limit_count int4 NOT NULL DEFAULT 0,
- total_count int4 NOT NULL DEFAULT 0,
- orverlapping_flg int2 NOT NULL DEFAULT 0,
- cart_flg int2 NOT NULL DEFAULT 0,
- deliv_free_flg int2 NOT NULL DEFAULT 0,
- search_condition text,
- del_flg smallint NOT NULL DEFAULT 0,
- create_date datetime NOT NULL,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_campaign_detail (
- campaign_id int NOT NULL,
- product_id int NOT NULL,
- campaign_point_rate numeric NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_pagelayout (
- page_id int auto_increment primary key NOT NULL,
- page_name text,
- url text NOT NULL,
- php_dir text,
- tpl_dir text,
- 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 datetime NOT NULL ,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_bloc (
- bloc_id int auto_increment primary key NOT NULL,
- bloc_name text,
- tpl_path text,
- filename varchar(50) NOT NULL UNIQUE,
- create_date datetime NOT NULL ,
- update_date datetime NOT NULL ,
- php_path text,
- del_flg smallint NOT NULL DEFAULT 0
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_blocposition (
- page_id int NOT NULL,
- target_id int,
- bloc_id int,
- bloc_row int,
- filename text
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_csv (
- no int auto_increment primary key,
- csv_id int NOT NULL,
- col text,
- disp_name text,
- rank int,
- status smallint NOT NULL DEFAULT 1,
- create_date datetime NOT NULL ,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_csv_sql (
- sql_id int auto_increment primary key,
- sql_name text NOT NULL,
- csv_sql text,
- update_date datetime NOT NULL,
- create_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_user_regist (
- user_id int auto_increment primary key NOT NULL,
- org_name text,
- post_name text,
- name01 text,
- name02 text,
- kana01 text,
- kana02 text,
- email text NOT NULL,
- url text,
- note text,
- secret_key varchar(50) NOT NULL UNIQUE,
- status smallint NOT NULL,
- del_flg smallint DEFAULT 0,
- create_date datetime NOT NULL,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_templates
-(
- template_code varchar(50) NOT NULL UNIQUE ,
- template_name text ,
- create_date datetime NOT NULL ,
- update_date datetime NOT NULL
-) TYPE=InnoDB ;
-
-CREATE TABLE dtb_table_comment
-(
- id int auto_increment primary key,
- table_name text,
- column_name text,
- description text
-) TYPE=InnoDB ;
-
-CREATE TABLE mtb_permission (
- id text,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id(32))
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_disable_logout (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_authority (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_work (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_disp (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_class (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_srank (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_status (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_status_image (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_allowed_tag (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_page_max (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_magazine_type (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_mail_magazine_type (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_recommend (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_taxrule (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_mail_template (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_mail_tpl_path (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_job (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_reminder (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_sex (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_page_rows (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_mail_type (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_order_status (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_product_status_color (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_order_status_color (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_wday (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_delivery_date (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_product_list_max (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_convenience (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_conveni_message (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_db (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_target (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_review_deny_url (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_track_back_status (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_site_control_track_back (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_site_control_affiliate (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_mobile_domain (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_ownersstore_err (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_ownersstore_ips (
- id int2,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- PRIMARY KEY (id)
-) TYPE=InnoDB;
-
-CREATE TABLE mtb_constants (
- id text,
- name text,
- rank int2 NOT NULL DEFAULT 0,
- remarks text
-) TYPE=InnoDB;