source: branches/version-2_5-dev/html/install/sql/create_table_mysql.sql @ 18786

Revision 18786, 26.5 KB checked in by nanasess, 14 years ago (diff)

非推奨機能の削除(#793)

  • キャンペーン機能
  • アンケート機能
  • html/test 以下の不要と思われるプログラム
  • 未使用テーブルの削除
    • dtb_user_regist
    • dtb_customer_mail_temp
    • dtb_mailmaga_template
    • mtb_srank
  • Property svn:eol-style set to LF
  • Property svn:mime-type set to text/plain; charset=utf-8
Line 
1create table dtb_module_update_logs(
2    log_id int auto_increment NOT NULL,
3    module_id int NOT NULL,
4    buckup_path text,
5    error_flg smallint DEFAULT 0,
6    error text,
7    ok text,
8    create_date datetime NOT NULL,
9    update_date datetime NOT NULL,
10    PRIMARY KEY (log_id)
11) TYPE=InnoDB;
12
13CREATE TABLE dtb_ownersstore_settings (
14    public_key text
15) TYPE=InnoDB;
16
17CREATE TABLE dtb_kiyaku (
18    kiyaku_id int auto_increment NOT NULL,
19    kiyaku_title text NOT NULL,
20    kiyaku_text text NOT NULL,
21    rank int NOT NULL DEFAULT 0,
22    creator_id int NOT NULL,
23    create_date datetime NOT NULL,
24    update_date datetime NOT NULL,
25    del_flg smallint NOT NULL DEFAULT 0,
26    PRIMARY KEY (kiyaku_id)
27) TYPE=InnoDB;
28
29CREATE TABLE dtb_holiday (
30    holiday_id int auto_increment NOT NULL,
31    title text NOT NULL,
32    month smallint NOT NULL,
33    day smallint NOT NULL,
34    rank int NOT NULL DEFAULT 0,
35    creator_id int NOT NULL,
36    create_date datetime NOT NULL,
37    update_date datetime NOT NULL,
38    del_flg smallint NOT NULL DEFAULT 0,
39    PRIMARY KEY (holiday_id)
40) TYPE=InnoDB;
41
42CREATE TABLE mtb_zip (
43    code text,
44    old_zipcode text,
45    zipcode text,
46    state_kana text,
47    city_kana text,
48    town_kana text,
49    state text,
50    city text,
51    town text,
52    flg1 text,
53    flg2 text,
54    flg3 text,
55    flg4 text,
56    flg5 text,
57    flg6 text
58) TYPE=InnoDB;
59
60CREATE TABLE dtb_bat_order_daily_age (
61    order_count numeric NOT NULL DEFAULT 0,
62    total numeric NOT NULL DEFAULT 0,
63    total_average numeric NOT NULL DEFAULT 0,
64    start_age smallint,
65    end_age smallint,
66    member smallint,
67    order_date datetime,
68    create_date datetime NOT NULL
69) TYPE=InnoDB;
70
71CREATE TABLE dtb_update (
72    module_id int NOT NULL,
73    module_name text NOT NULL,
74    now_version text,
75    latest_version text NOT NULL,
76    module_explain text,
77    main_php text NOT NULL,
78    extern_php text NOT NULL,
79    install_sql text,
80    uninstall_sql text,
81    other_files text,
82    del_flg smallint NOT NULL DEFAULT 0,
83    create_date datetime NOT NULL,
84    update_date datetime,
85    release_date datetime NOT NULL,
86    PRIMARY KEY (module_id)
87) TYPE=InnoDB;
88
89CREATE TABLE dtb_baseinfo (
90    company_name text,
91    company_kana text,
92    zip01 text,
93    zip02 text,
94    pref smallint,
95    addr01 text,
96    addr02 text,
97    tel01 text,
98    tel02 text,
99    tel03 text,
100    fax01 text,
101    fax02 text,
102    fax03 text,
103    business_hour text,
104    law_company text,
105    law_manager text,
106    law_zip01 text,
107    law_zip02 text,
108    law_pref smallint,
109    law_addr01 text,
110    law_addr02 text,
111    law_tel01 text,
112    law_tel02 text,
113    law_tel03 text,
114    law_fax01 text,
115    law_fax02 text,
116    law_fax03 text,
117    law_email text,
118    law_url text,
119    law_term01 text,
120    law_term02 text,
121    law_term03 text,
122    law_term04 text,
123    law_term05 text,
124    law_term06 text,
125    law_term07 text,
126    law_term08 text,
127    law_term09 text,
128    law_term10 text,
129    tax numeric NOT NULL DEFAULT 5,
130    tax_rule smallint NOT NULL DEFAULT 1,
131    email01 text,
132    email02 text,
133    email03 text,
134    email04 text,
135    email05 text,
136    free_rule numeric,
137    shop_name text,
138    shop_kana text,
139    shop_name_eng text,
140    point_rate numeric NOT NULL DEFAULT 0,
141    welcome_point numeric NOT NULL DEFAULT 0,
142    update_date datetime,
143    top_tpl text,
144    product_tpl text,
145    detail_tpl text,
146    mypage_tpl text,
147    good_traded text,
148    message text,
149    regular_holiday_ids text,
150    latitude text,
151    longitude text,
152    downloadable_days numeric DEFAULT 30,
153    downloadable_days_unlimited smallint
154) TYPE=InnoDB;
155
156CREATE TABLE dtb_deliv (
157    deliv_id int auto_increment NOT NULL,
158    name text,
159    service_name text,
160    confirm_url text,
161    rank int,
162    status smallint NOT NULL DEFAULT 1,
163    del_flg smallint NOT NULL DEFAULT 0,
164    creator_id int NOT NULL,
165    create_date datetime NOT NULL,
166    update_date datetime,
167    PRIMARY KEY (deliv_id)
168) TYPE=InnoDB;
169
170CREATE TABLE dtb_delivtime (
171    deliv_id int NOT NULL,
172    time_id int NOT NULL,
173    deliv_time text NOT NULL,
174    PRIMARY KEY (deliv_id, time_id)
175) TYPE=InnoDB;
176
177CREATE TABLE dtb_delivfee (
178    deliv_id int NOT NULL,
179    fee_id int auto_increment NOT NULL,
180    fee text NOT NULL,
181    pref smallint,
182    PRIMARY KEY (fee_id)
183) TYPE=InnoDB;
184
185CREATE TABLE dtb_payment (
186    payment_id int auto_increment NOT NULL,
187    payment_method text,
188    charge numeric,
189    rule numeric,
190    deliv_id int DEFAULT 0,
191    rank int,
192    note text,
193    fix smallint,
194    status smallint NOT NULL DEFAULT 1,
195    del_flg smallint NOT NULL DEFAULT 0,
196    creator_id int NOT NULL,
197    create_date datetime NOT NULL,
198    update_date datetime,
199    payment_image text,
200    upper_rule numeric,
201    charge_flg smallint DEFAULT 1,
202    rule_min numeric,
203    upper_rule_max numeric,
204    module_id int,
205    module_path text,
206    memo01 text,
207    memo02 text,
208    memo03 text,
209    memo04 text,
210    memo05 text,
211    memo06 text,
212    memo07 text,
213    memo08 text,
214    memo09 text,
215    memo10 text,
216    PRIMARY KEY (payment_id)
217) TYPE=InnoDB;
218
219CREATE TABLE dtb_mailtemplate (
220    template_id int NOT NULL,
221    subject text,
222    header text,
223    footer text,
224    creator_id int NOT NULL,
225    del_flg smallint NOT NULL DEFAULT 0,
226    create_date datetime NOT NULL,
227    update_date datetime NOT NULL
228) TYPE=InnoDB;
229
230CREATE TABLE dtb_send_history (
231    send_id int auto_increment NOT NULL,
232    mail_method smallint,
233    subject text,
234    body text,
235    send_count int,
236    complete_count int NOT NULL DEFAULT 0,
237    start_date datetime,
238    end_date datetime,
239    search_data text,
240    del_flg smallint NOT NULL DEFAULT 0,
241    creator_id int NOT NULL,
242    create_date datetime NOT NULL,
243    update_date datetime NOT NULL,
244    PRIMARY KEY (send_id)
245) TYPE=InnoDB;
246
247CREATE TABLE dtb_send_customer (
248    customer_id int,
249    send_id int NOT NULL,
250    email text,
251    name text,
252    send_flag smallint,
253    PRIMARY KEY (send_id, customer_id)
254) TYPE=InnoDB;
255
256CREATE TABLE dtb_products (
257    product_id int auto_increment NOT NULL,
258    name text,
259    deliv_fee numeric,
260    sale_limit numeric,
261    category_id int,
262    maker_id int,
263    rank int,
264    status smallint NOT NULL DEFAULT 2,
265    product_flag text,
266    point_rate numeric,
267    comment1 text,
268    comment2 text,
269    comment3 mediumtext,
270    comment4 text,
271    comment5 text,
272    comment6 text,
273    note text,
274    file1 text,
275    file2 text,
276    file3 text,
277    file4 text,
278    file5 text,
279    file6 text,
280    main_list_comment text,
281    main_list_image text,
282    main_comment mediumtext,
283    main_image text,
284    main_large_image text,
285    sub_title1 text,
286    sub_comment1 mediumtext,
287    sub_image1 text,
288    sub_large_image1 text,
289    sub_title2 text,
290    sub_comment2 mediumtext,
291    sub_image2 text,
292    sub_large_image2 text,
293    sub_title3 text,
294    sub_comment3 mediumtext,
295    sub_image3 text,
296    sub_large_image3 text,
297    sub_title4 text,
298    sub_comment4 mediumtext,
299    sub_image4 text,
300    sub_large_image4 text,
301    sub_title5 text,
302    sub_comment5 mediumtext,
303    sub_image5 text,
304    sub_large_image5 text,
305    sub_title6 text,
306    sub_comment6 mediumtext,
307    sub_image6 text,
308    sub_large_image6 text,
309    del_flg smallint NOT NULL DEFAULT 0,
310    creator_id int NOT NULL,
311    create_date datetime NOT NULL,
312    update_date datetime,
313    deliv_date_id int,
314    down smallint NOT NULL ,
315    down_filename text,
316    down_realfilename text,
317    PRIMARY KEY (product_id)
318) TYPE=InnoDB;
319
320CREATE TABLE dtb_products_class (
321    product_class_id int auto_increment NOT NULL,
322    product_id int NOT NULL,
323    classcategory_id1 int NOT NULL DEFAULT 0,
324    classcategory_id2 int NOT NULL DEFAULT 0,
325    product_code text,
326    stock numeric,
327    stock_unlimited smallint NOT NULL DEFAULT 0,
328    sale_limit numeric,
329    price01 numeric,
330    price02 numeric,
331    status smallint,
332    creator_id int NOT NULL,
333    create_date datetime NOT NULL,
334    update_date datetime,
335    PRIMARY KEY (product_class_id)
336) TYPE=InnoDB;
337
338CREATE TABLE dtb_class (
339    class_id int auto_increment NOT NULL,
340    name text,
341    status smallint,
342    rank int,
343    creator_id int NOT NULL,
344    create_date datetime NOT NULL,
345    update_date datetime,
346    del_flg smallint NOT NULL DEFAULT 0,
347    product_id int,
348    PRIMARY KEY (class_id)
349) TYPE=InnoDB;
350
351CREATE TABLE dtb_classcategory (
352    classcategory_id int auto_increment NOT NULL,
353    name text,
354    class_id int NOT NULL,
355    status smallint,
356    rank int,
357    creator_id int NOT NULL,
358    create_date datetime NOT NULL,
359    update_date datetime,
360    del_flg smallint NOT NULL DEFAULT 0,
361    PRIMARY KEY (classcategory_id)
362) TYPE=InnoDB;
363
364CREATE TABLE dtb_category (
365    category_id int auto_increment NOT NULL,
366    category_name text,
367    parent_category_id int NOT NULL DEFAULT 0,
368    level int NOT NULL,
369    rank int,
370    creator_id int NOT NULL,
371    create_date datetime NOT NULL,
372    update_date datetime,
373    del_flg smallint NOT NULL DEFAULT 0,
374    PRIMARY KEY (category_id)
375) TYPE=InnoDB;
376
377CREATE TABLE dtb_product_categories (
378    product_id int NOT NULL,
379    category_id int NOT NULL,
380    rank int NOT NULL,
381    PRIMARY KEY(product_id, category_id)
382) TYPE=InnoDB;
383
384CREATE TABLE dtb_bat_order_daily (
385    total_order numeric NOT NULL DEFAULT 0,
386    member numeric NOT NULL DEFAULT 0,
387    nonmember numeric NOT NULL DEFAULT 0,
388    men numeric NOT NULL DEFAULT 0,
389    women numeric NOT NULL DEFAULT 0,
390    men_member numeric NOT NULL DEFAULT 0,
391    men_nonmember numeric NOT NULL DEFAULT 0,
392    women_member numeric NOT NULL DEFAULT 0,
393    women_nonmember numeric NOT NULL DEFAULT 0,
394    total numeric NOT NULL DEFAULT 0,
395    total_average numeric NOT NULL DEFAULT 0,
396    order_date datetime NOT NULL,
397    create_date datetime NOT NULL,
398    year smallint NOT NULL,
399    month smallint NOT NULL,
400    day smallint NOT NULL,
401    wday smallint NOT NULL,
402    key_day text NOT NULL,
403    key_month text NOT NULL,
404    key_year text NOT NULL,
405    key_wday text NOT NULL
406) TYPE=InnoDB;
407
408CREATE TABLE dtb_bat_order_daily_hour (
409    total_order numeric NOT NULL DEFAULT 0,
410    member numeric NOT NULL DEFAULT 0,
411    nonmember numeric NOT NULL DEFAULT 0,
412    men numeric NOT NULL DEFAULT 0,
413    women numeric NOT NULL DEFAULT 0,
414    men_member numeric NOT NULL DEFAULT 0,
415    men_nonmember numeric NOT NULL DEFAULT 0,
416    women_member numeric NOT NULL DEFAULT 0,
417    women_nonmember numeric NOT NULL DEFAULT 0,
418    total numeric NOT NULL DEFAULT 0,
419    total_average numeric NOT NULL DEFAULT 0,
420    hour smallint NOT NULL DEFAULT 0,
421    order_date datetime,
422    create_date datetime NOT NULL
423) TYPE=InnoDB;
424
425CREATE TABLE dtb_recommend_products (
426    product_id int NOT NULL,
427    recommend_product_id int NOT NULL,
428    rank int NOT NULL,
429    comment text,
430    status smallint NOT NULL DEFAULT 0,
431    creator_id int NOT NULL,
432    create_date datetime NOT NULL,
433    update_date datetime NOT NULL
434) TYPE=InnoDB;
435
436CREATE TABLE dtb_review (
437    review_id int auto_increment NOT NULL,
438    product_id int NOT NULL,
439    reviewer_name text NOT NULL,
440    reviewer_url text,
441    sex smallint,
442    customer_id int,
443    recommend_level smallint NOT NULL,
444    title text NOT NULL,
445    comment text NOT NULL,
446    status smallint DEFAULT 2,
447    creator_id int NOT NULL,
448    create_date datetime,
449    update_date datetime,
450    del_flg smallint NOT NULL DEFAULT 0,
451    PRIMARY KEY (review_id)
452) TYPE=InnoDB;
453
454CREATE TABLE dtb_customer_reading (
455    reading_product_id int NOT NULL,
456    customer_id int NOT NULL,
457    create_date datetime NOT NULL,
458    update_date datetime NOT NULL
459) TYPE=InnoDB;
460
461CREATE TABLE dtb_customer_favorite_products (
462    customer_id int NOT NULL,
463    product_id int NOT NULL,
464    create_date datetime NOT NULL,
465    update_date datetime NOT NULL
466) TYPE=InnoDB;
467
468CREATE TABLE dtb_category_count (
469    category_id int NOT NULL,
470    product_count int NOT NULL,
471    create_date datetime NOT NULL
472) TYPE=InnoDB;
473
474CREATE TABLE dtb_category_total_count (
475    category_id int NOT NULL,
476    product_count int,
477    create_date datetime NOT NULL
478) TYPE=InnoDB;
479
480CREATE TABLE dtb_news (
481    news_id int auto_increment NOT NULL,
482    news_date datetime,
483    rank int,
484    news_title text NOT NULL,
485    news_comment text,
486    news_url text,
487    news_select smallint NOT NULL DEFAULT 0,
488    link_method text,
489    creator_id int NOT NULL,
490    create_date datetime NOT NULL,
491    update_date datetime,
492    del_flg smallint NOT NULL DEFAULT 0,
493    PRIMARY KEY (news_id)
494) TYPE=InnoDB;
495
496CREATE TABLE dtb_best_products (
497    best_id int auto_increment NOT NULL,
498    category_id int NOT NULL,
499    rank int NOT NULL DEFAULT 0,
500    product_id int NOT NULL,
501    title text,
502    comment text,
503    creator_id int NOT NULL,
504    create_date datetime NOT NULL,
505    update_date datetime,
506    del_flg smallint NOT NULL DEFAULT 0,
507    PRIMARY KEY (best_id)
508) TYPE=InnoDB;
509
510CREATE TABLE dtb_mail_history (
511    send_id int auto_increment NOT NULL,
512    order_id int NOT NULL,
513    send_date datetime,
514    template_id int,
515    creator_id int NOT NULL,
516    subject text,
517    mail_body text,
518    PRIMARY KEY (send_id)
519) TYPE=InnoDB;
520
521CREATE TABLE dtb_customer (
522    customer_id int auto_increment NOT NULL,
523    name01 text NOT NULL,
524    name02 text NOT NULL,
525    kana01 text NOT NULL,
526    kana02 text NOT NULL,
527    zip01 text,
528    zip02 text,
529    pref smallint,
530    addr01 text,
531    addr02 text,
532    email text NOT NULL,
533    email_mobile text,
534    tel01 text,
535    tel02 text,
536    tel03 text,
537    fax01 text,
538    fax02 text,
539    fax03 text,
540    sex smallint,
541    job smallint,
542    birth datetime,
543    password text,
544    reminder smallint,
545    reminder_answer text,
546    secret_key varchar(50) NOT NULL UNIQUE,
547    first_buy_date datetime,
548    last_buy_date datetime,
549    buy_times numeric DEFAULT 0,
550    buy_total numeric DEFAULT 0,
551    point numeric DEFAULT 0,
552    note text,
553    status smallint NOT NULL DEFAULT 1,
554    create_date datetime NOT NULL,
555    update_date datetime,
556    del_flg smallint NOT NULL DEFAULT 0,
557    cell01 text,
558    cell02 text,
559    cell03 text,
560    mobile_phone_id text,
561    mailmaga_flg smallint,
562    PRIMARY KEY (customer_id)
563) TYPE=InnoDB;
564
565CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
566
567CREATE TABLE dtb_order (
568    order_id int auto_increment NOT NULL,
569    order_temp_id text,
570    customer_id int NOT NULL,
571    message text,
572    order_name01 text,
573    order_name02 text,
574    order_kana01 text,
575    order_kana02 text,
576    order_email text,
577    order_tel01 text,
578    order_tel02 text,
579    order_tel03 text,
580    order_fax01 text,
581    order_fax02 text,
582    order_fax03 text,
583    order_zip01 text,
584    order_zip02 text,
585    order_pref smallint,
586    order_addr01 text,
587    order_addr02 text,
588    order_sex smallint,
589    order_birth datetime,
590    order_job int,
591    deliv_name01 text,
592    deliv_name02 text,
593    deliv_kana01 text,
594    deliv_kana02 text,
595    deliv_tel01 text,
596    deliv_tel02 text,
597    deliv_tel03 text,
598    deliv_fax01 text,
599    deliv_fax02 text,
600    deliv_fax03 text,
601    deliv_zip01 text,
602    deliv_zip02 text,
603    deliv_pref smallint,
604    deliv_addr01 text,
605    deliv_addr02 text,
606    subtotal numeric,
607    discount numeric,
608    deliv_fee numeric,
609    charge numeric,
610    use_point numeric,
611    add_point numeric,
612    birth_point numeric DEFAULT 0,
613    tax numeric,
614    total numeric,
615    payment_total numeric,
616    payment_id int,
617    payment_method text,
618    deliv_id int,
619    deliv_time_id int,
620    deliv_time text,
621    deliv_no text,
622    note text,
623    status smallint,
624    create_date datetime NOT NULL,
625    loan_result text,
626    credit_result text,
627    credit_msg text,
628    update_date datetime,
629    commit_date datetime,
630    del_flg smallint NOT NULL DEFAULT 0,
631    deliv_date text,
632    conveni_data text,
633    cell01 text,
634    cell02 text,
635    cell03 text,
636    memo01 text,
637    memo02 text,
638    memo03 text,
639    memo04 text,
640    memo05 text,
641    memo06 text,
642    memo07 text,
643    memo08 text,
644    memo09 text,
645    memo10 text,
646    PRIMARY KEY (order_id)
647) TYPE=InnoDB;
648
649CREATE TABLE dtb_order_temp (
650    order_temp_id text NOT NULL,
651    customer_id int NOT NULL,
652    message text,
653    order_name01 text,
654    order_name02 text,
655    order_kana01 text,
656    order_kana02 text,
657    order_email text,
658    order_tel01 text,
659    order_tel02 text,
660    order_tel03 text,
661    order_fax01 text,
662    order_fax02 text,
663    order_fax03 text,
664    order_zip01 text,
665    order_zip02 text,
666    order_pref smallint,
667    order_addr01 text,
668    order_addr02 text,
669    order_sex smallint,
670    order_birth datetime,
671    order_job int,
672    deliv_name01 text,
673    deliv_name02 text,
674    deliv_kana01 text,
675    deliv_kana02 text,
676    deliv_tel01 text,
677    deliv_tel02 text,
678    deliv_tel03 text,
679    deliv_fax01 text,
680    deliv_fax02 text,
681    deliv_fax03 text,
682    deliv_zip01 text,
683    deliv_zip02 text,
684    deliv_pref smallint,
685    deliv_addr01 text,
686    deliv_addr02 text,
687    subtotal numeric,
688    discount numeric,
689    deliv_fee numeric,
690    charge numeric,
691    use_point numeric,
692    add_point numeric,
693    birth_point numeric DEFAULT 0,
694    tax numeric,
695    total numeric,
696    payment_total numeric,
697    payment_id int,
698    payment_method text,
699    deliv_id int,
700    deliv_time_id int,
701    deliv_time text,
702    deliv_no text,
703    note text,
704    mail_flag smallint,
705    status smallint,
706    deliv_check smallint,
707    point_check smallint,
708    loan_result text,
709    credit_result text,
710    credit_msg text,
711    create_date datetime NOT NULL,
712    update_date datetime,
713    del_flg smallint NOT NULL DEFAULT 0,
714    deliv_date text,
715    conveni_data text,
716    cell01 text,
717    cell02 text,
718    cell03 text,
719    order_id int,
720    memo01 text,
721    memo02 text,
722    memo03 text,
723    memo04 text,
724    memo05 text,
725    memo06 text,
726    memo07 text,
727    memo08 text,
728    memo09 text,
729    memo10 text,
730    session text
731) TYPE=InnoDB;
732
733CREATE TABLE dtb_other_deliv (
734    other_deliv_id int auto_increment NOT NULL,
735    customer_id int NOT NULL,
736    name01 text,
737    name02 text,
738    kana01 text,
739    kana02 text,
740    zip01 text,
741    zip02 text,
742    pref smallint,
743    addr01 text,
744    addr02 text,
745    tel01 text,
746    tel02 text,
747    tel03 text,
748    PRIMARY KEY (other_deliv_id)
749) TYPE=InnoDB;
750
751CREATE TABLE dtb_order_detail (
752    order_id int NOT NULL,
753    product_id int NOT NULL,
754    classcategory_id1 int NOT NULL,
755    classcategory_id2 int NOT NULL,
756    product_name text NOT NULL,
757    product_code text,
758    classcategory_name1 text,
759    classcategory_name2 text,
760    price numeric,
761    quantity numeric,
762    point_rate numeric
763) TYPE=InnoDB;
764
765CREATE TABLE mtb_pref (
766    pref_id smallint NOT NULL,
767    pref_name text,
768    rank smallint NOT NULL DEFAULT 0,
769    PRIMARY KEY (pref_id)
770) TYPE=InnoDB;
771
772CREATE TABLE dtb_member (
773    member_id int auto_increment NOT NULL,
774    name text,
775    department text,
776    login_id text NOT NULL,
777    password text NOT NULL,
778    authority smallint NOT NULL,
779    rank int NOT NULL DEFAULT 0,
780    work smallint NOT NULL DEFAULT 1,
781    del_flg smallint NOT NULL DEFAULT 0,
782    creator_id int NOT NULL,
783    update_date datetime,
784    create_date datetime NOT NULL,
785    login_date datetime,
786    PRIMARY KEY (member_id)
787) TYPE=InnoDB;
788
789CREATE TABLE dtb_bat_relate_products (
790    product_id int,
791    relate_product_id int,
792    customer_id int,
793    create_date datetime
794) TYPE=InnoDB;
795
796CREATE TABLE dtb_pagelayout (
797    page_id int auto_increment NOT NULL,
798    page_name text,
799    url text NOT NULL,
800    php_dir text,
801    tpl_dir text,
802    filename text,
803    header_chk smallint DEFAULT 1,
804    footer_chk smallint DEFAULT 1,
805    edit_flg smallint DEFAULT 1,
806    author text,
807    description text,
808    keyword text,
809    update_url text,
810    create_date datetime NOT NULL,
811    update_date datetime NOT NULL,
812    PRIMARY KEY (page_id)
813) TYPE=InnoDB;
814
815CREATE TABLE dtb_bloc (
816    bloc_id int auto_increment NOT NULL,
817    bloc_name text,
818    tpl_path text,
819    filename varchar(50) NOT NULL UNIQUE,
820    create_date datetime NOT NULL,
821    update_date datetime NOT NULL,
822    php_path text,
823    del_flg smallint NOT NULL DEFAULT 0,
824    PRIMARY KEY (bloc_id)
825) TYPE=InnoDB;
826
827CREATE TABLE dtb_blocposition (
828    page_id int NOT NULL,
829    target_id int,
830    bloc_id int,
831    bloc_row int,
832    filename text,
833    anywhere int DEFAULT 0 NOT NULL
834) TYPE=InnoDB;
835
836CREATE TABLE dtb_csv (
837    no int auto_increment,
838    csv_id int NOT NULL,
839    col text,
840    disp_name text,
841    rank int,
842    status smallint NOT NULL DEFAULT 1,
843    create_date datetime NOT NULL,
844    update_date datetime NOT NULL,
845    `convert` text,
846    PRIMARY KEY (no)
847) TYPE=InnoDB;
848
849CREATE TABLE dtb_csv_sql (
850    sql_id int auto_increment,
851    sql_name text NOT NULL,
852    csv_sql text,
853    update_date datetime NOT NULL,
854    create_date datetime NOT NULL,
855    PRIMARY KEY (sql_id)
856) TYPE=InnoDB;
857
858CREATE TABLE dtb_templates
859(
860    template_code varchar(50) NOT NULL,
861    template_name text,
862    create_date datetime NOT NULL,
863    update_date datetime NOT NULL,
864    PRIMARY KEY (template_code)
865) TYPE=InnoDB;
866
867CREATE TABLE dtb_table_comment
868(
869    id int auto_increment,
870    table_name text,
871    column_name text,
872    description text,
873    PRIMARY KEY (id)
874) TYPE=InnoDB;
875
876CREATE TABLE dtb_maker (
877    maker_id int auto_increment,
878    name text NOT NULL,
879    rank int NOT NULL DEFAULT 0,
880    creator_id int NOT NULL,
881    create_date datetime NOT NULL,
882    update_date datetime NOT NULL,
883    del_flg smallint NOT NULL DEFAULT 0,
884    PRIMARY KEY (maker_id)
885) TYPE=InnoDB;
886
887CREATE TABLE dtb_maker_count (
888    maker_id int NOT NULL,
889    product_count int NOT NULL,
890    create_date datetime NOT NULL
891) TYPE=InnoDB;
892
893
894CREATE TABLE mtb_permission (
895    id text,
896    name text,
897    rank smallint NOT NULL DEFAULT 0,
898    PRIMARY KEY (id(32))
899) TYPE=InnoDB;
900
901CREATE TABLE mtb_disable_logout (
902    id smallint,
903    name text,
904    rank smallint NOT NULL DEFAULT 0,
905    PRIMARY KEY (id)
906) TYPE=InnoDB;
907
908CREATE TABLE mtb_authority (
909    id smallint,
910    name text,
911    rank smallint NOT NULL DEFAULT 0,
912    PRIMARY KEY (id)
913) TYPE=InnoDB;
914
915CREATE TABLE mtb_work (
916    id smallint,
917    name text,
918    rank smallint NOT NULL DEFAULT 0,
919    PRIMARY KEY (id)
920) TYPE=InnoDB;
921
922CREATE TABLE mtb_disp (
923    id smallint,
924    name text,
925    rank smallint NOT NULL DEFAULT 0,
926    PRIMARY KEY (id)
927) TYPE=InnoDB;
928
929CREATE TABLE mtb_class (
930    id smallint,
931    name text,
932    rank smallint NOT NULL DEFAULT 0,
933    PRIMARY KEY (id)
934) TYPE=InnoDB;
935
936CREATE TABLE mtb_status (
937    id smallint,
938    name text,
939    rank smallint NOT NULL DEFAULT 0,
940    PRIMARY KEY (id)
941) TYPE=InnoDB;
942
943CREATE TABLE mtb_status_image (
944    id smallint,
945    name text,
946    rank smallint NOT NULL DEFAULT 0,
947    PRIMARY KEY (id)
948) TYPE=InnoDB;
949
950CREATE TABLE mtb_allowed_tag (
951    id smallint,
952    name text,
953    rank smallint NOT NULL DEFAULT 0,
954    PRIMARY KEY (id)
955) TYPE=InnoDB;
956
957CREATE TABLE mtb_page_max (
958    id smallint,
959    name text,
960    rank smallint NOT NULL DEFAULT 0,
961    PRIMARY KEY (id)
962) TYPE=InnoDB;
963
964CREATE TABLE mtb_magazine_type (
965    id smallint,
966    name text,
967    rank smallint NOT NULL DEFAULT 0,
968    PRIMARY KEY (id)
969) TYPE=InnoDB;
970
971CREATE TABLE mtb_mail_magazine_type (
972    id smallint,
973    name text,
974    rank smallint NOT NULL DEFAULT 0,
975    PRIMARY KEY (id)
976) TYPE=InnoDB;
977
978CREATE TABLE mtb_recommend (
979    id smallint,
980    name text,
981    rank smallint NOT NULL DEFAULT 0,
982    PRIMARY KEY (id)
983) TYPE=InnoDB;
984
985CREATE TABLE mtb_taxrule (
986    id smallint,
987    name text,
988    rank smallint NOT NULL DEFAULT 0,
989    PRIMARY KEY (id)
990) TYPE=InnoDB;
991
992CREATE TABLE mtb_mail_template (
993    id smallint,
994    name text,
995    rank smallint NOT NULL DEFAULT 0,
996    PRIMARY KEY (id)
997) TYPE=InnoDB;
998
999CREATE TABLE mtb_mail_tpl_path (
1000    id smallint,
1001    name text,
1002    rank smallint NOT NULL DEFAULT 0,
1003    PRIMARY KEY (id)
1004) TYPE=InnoDB;
1005
1006CREATE TABLE mtb_job (
1007    id smallint,
1008    name text,
1009    rank smallint NOT NULL DEFAULT 0,
1010    PRIMARY KEY (id)
1011) TYPE=InnoDB;
1012
1013CREATE TABLE mtb_reminder (
1014    id smallint,
1015    name text,
1016    rank smallint NOT NULL DEFAULT 0,
1017    PRIMARY KEY (id)
1018) TYPE=InnoDB;
1019
1020CREATE TABLE mtb_sex (
1021    id smallint,
1022    name text,
1023    rank smallint NOT NULL DEFAULT 0,
1024    PRIMARY KEY (id)
1025) TYPE=InnoDB;
1026
1027CREATE TABLE mtb_page_rows (
1028    id smallint,
1029    name text,
1030    rank smallint NOT NULL DEFAULT 0,
1031    PRIMARY KEY (id)
1032) TYPE=InnoDB;
1033
1034CREATE TABLE mtb_mail_type (
1035    id smallint,
1036    name text,
1037    rank smallint NOT NULL DEFAULT 0,
1038    PRIMARY KEY (id)
1039) TYPE=InnoDB;
1040
1041CREATE TABLE mtb_order_status (
1042    id smallint,
1043    name text,
1044    rank smallint NOT NULL DEFAULT 0,
1045    PRIMARY KEY (id)
1046) TYPE=InnoDB;
1047
1048CREATE TABLE mtb_product_status_color (
1049    id smallint,
1050    name text,
1051    rank smallint NOT NULL DEFAULT 0,
1052    PRIMARY KEY (id)
1053) TYPE=InnoDB;
1054
1055CREATE TABLE mtb_order_status_color (
1056    id smallint,
1057    name text,
1058    rank smallint NOT NULL DEFAULT 0,
1059    PRIMARY KEY (id)
1060) TYPE=InnoDB;
1061
1062CREATE TABLE mtb_wday (
1063    id smallint,
1064    name text,
1065    rank smallint NOT NULL DEFAULT 0,
1066    PRIMARY KEY (id)
1067) TYPE=InnoDB;
1068
1069CREATE TABLE mtb_delivery_date (
1070    id smallint,
1071    name text,
1072    rank smallint NOT NULL DEFAULT 0,
1073    PRIMARY KEY (id)
1074) TYPE=InnoDB;
1075
1076CREATE TABLE mtb_product_list_max (
1077    id smallint,
1078    name text,
1079    rank smallint NOT NULL DEFAULT 0,
1080    PRIMARY KEY (id)
1081) TYPE=InnoDB;
1082
1083CREATE TABLE mtb_convenience (
1084    id smallint,
1085    name text,
1086    rank smallint NOT NULL DEFAULT 0,
1087    PRIMARY KEY (id)
1088) TYPE=InnoDB;
1089
1090CREATE TABLE mtb_conveni_message (
1091    id smallint,
1092    name text,
1093    rank smallint NOT NULL DEFAULT 0,
1094    PRIMARY KEY (id)
1095) TYPE=InnoDB;
1096
1097CREATE TABLE mtb_db (
1098    id smallint,
1099    name text,
1100    rank smallint NOT NULL DEFAULT 0,
1101    PRIMARY KEY (id)
1102) TYPE=InnoDB;
1103
1104CREATE TABLE mtb_target (
1105    id smallint,
1106    name text,
1107    rank smallint NOT NULL DEFAULT 0,
1108    PRIMARY KEY (id)
1109) TYPE=InnoDB;
1110
1111CREATE TABLE mtb_review_deny_url (
1112    id smallint,
1113    name text,
1114    rank smallint NOT NULL DEFAULT 0,
1115    PRIMARY KEY (id)
1116) TYPE=InnoDB;
1117
1118CREATE TABLE mtb_track_back_status (
1119    id smallint,
1120    name text,
1121    rank smallint NOT NULL DEFAULT 0,
1122    PRIMARY KEY (id)
1123) TYPE=InnoDB;
1124
1125CREATE TABLE mtb_site_control_track_back (
1126    id smallint,
1127    name text,
1128    rank smallint NOT NULL DEFAULT 0,
1129    PRIMARY KEY (id)
1130) TYPE=InnoDB;
1131
1132CREATE TABLE mtb_site_control_affiliate (
1133    id smallint,
1134    name text,
1135    rank smallint NOT NULL DEFAULT 0,
1136    PRIMARY KEY (id)
1137) TYPE=InnoDB;
1138
1139CREATE TABLE mtb_mobile_domain (
1140    id smallint,
1141    name text,
1142    rank smallint NOT NULL DEFAULT 0,
1143    PRIMARY KEY (id)
1144) TYPE=InnoDB;
1145
1146CREATE TABLE mtb_ownersstore_err (
1147    id smallint,
1148    name text,
1149    rank smallint NOT NULL DEFAULT 0,
1150    PRIMARY KEY (id)
1151) TYPE=InnoDB;
1152
1153CREATE TABLE mtb_ownersstore_ips (
1154    id smallint,
1155    name text,
1156    rank smallint NOT NULL DEFAULT 0,
1157    PRIMARY KEY (id)
1158) TYPE=InnoDB;
1159
1160CREATE TABLE mtb_constants (
1161    id text,
1162    name text,
1163    rank smallint NOT NULL DEFAULT 0,
1164    remarks text,
1165    PRIMARY KEY (id(64))
1166) TYPE=InnoDB;
1167
1168CREATE TABLE mtb_down (
1169    id int2,
1170    name text,
1171    rank int2 NOT NULL,
1172    PRIMARY KEY (id)
1173) TYPE=InnoDB;
Note: See TracBrowser for help on using the repository browser.