source: branches/version-2_12-multilang/html/install/sql/create_table_mysql.sql @ 22177

Revision 22177, 28.5 KB checked in by h_yoshimoto, 8 years ago (diff)

#1997 カナのテキストフィールドを削除

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