Index: branches/dev/html/install/sql/create_table_mysql.sql
===================================================================
--- branches/dev/html/install/sql/create_table_mysql.sql	(revision 13431)
+++ branches/dev/html/install/sql/create_table_mysql.sql	(revision 13431)
@@ -0,0 +1,910 @@
+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 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
+) 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 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,
+    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_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,
+    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_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 text,
+    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
+) 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 ;
+